Costing Based ADSO

[GVR]

Hello All,

could you please help me to create the costing based ADSO.

Source fieds

GL Account Company Code Fiscal year val1 val2 val3 val4 etc

Target required

GL Account Fiscal year company code fiscal year period amount

here based on the GL Account, company code, fiscal year we need to pick the fiscal year period 

then

if period 001 we need to pick the value  from value1 and store to Amount

if period 002 we need to pick the value  from value2 and store to Amount

So one. 

Thanks and Regards,

VenkatC

[GVR]

May be could be please check below scanrios for better understanding.

I required 2 ADSO one is actuals and another one for plan (in plan ADSO fields are GL Account, Company code, Fiscal year and keyfigures are val1 val2 valu3 like 12)

for Actual ADSO i dont have any problem but plan ADSO i have GL account, Company code, Fiscal year

I need to show the report like below

in CP i will create the join like Actual.GL = Plan. GL and Actual.Company code = Plant. Company code

variable screen : Fiscal year period 001.2024 Company Code 001 Then report like shown

GL Account comapny Acual Value Plan Valu

123 001                      5000             100 (if it has the value1)

if we select fiscal year period 001.2024 to 002.2024 then

GL Account comapny Acual Value Plan Valu

123              001         5000           300 (Val1 100 + value 200) if value is not there for valu2 it will show only 100)

Could you please check these one and help me.