Navigation / Steps :
Select any one Data Source , I'll take from FIAR , The Data source name : 0FI_AR_4
For above DataSource supported DSO : ZFAR_O03
For above DataSource Supported Info Cube : ZFAR_C03
Note : first you have to check in DSO and InfoCube , before you doing the task .
DataSource PSA data :
New Data Table output .
check for net due data field
Example this is the Task :
Write a Routine to find the Net Period Used
We need to write Net Period Used = Clearing Date - Net Due Date
Double Click on the Transformation (DSO and Info Cube)
This is Item Status
Select 0NETTAKEN ----> Right Click ----> Click on Rule Details
after that select bellow screen
Select InfoObject for Clearing Data ----> 0CLEAR_DATA
Select InfoObject for intem status -----> 0FI_DOCSTAT
Select InfoObject for Due date for net pay ----> 0NETDUEDATE
click on save.
check the status ----> If any errors it will show.
Click on Activate.
After that Delete the Previous DTP Request (Info Cube) and Execute the DTP (Info Cube) again
Info Cube - Output
You can see the changes (Check the Net Period Used)
Info Cube - Output
You can see the Required Output.