Alignment of data in BW using ABAP syntax

[former_member203111]

Hi BW/ABAP experts,

I created a BW model in which I am bringing in sales data (Infocube) plus some change log data from CDHDR and CDPOS (Look up DSO) like "Change On date" and Old value of the plant called "Old Plant".

The model is absolutely fine and pulling the data as required. I am doing a look up from change log DSO into Sales cube which I created to capture daily changes for the field "Change On" and "Old Plant" based on the "Sales Document Number and Item". Please see the screenshot:

When I pulls the data into cube it shows two separate records in the cube (Line 1 record is from look up DSO and Line 2 record is from sales cube) and after aggregation in the BEx Report there is only one line but there are "not assigned" values for Changed On date and Old Plant.

I would like to write a small syntax in the End Routine that should check the vales for Old plant and Change On date (H11 and J11) from Line 1 and populate into blank cell in Line 2 (H12 and J12).

Can someone please help me with the logic/ABAP syntax that can fill these not assigned blank values so all the information in my BEx report should show in one line.The good thing is that all the required data is available in the cube now and I just need to align it properly so it can show in one line in the report.

I will appreciate your help.

Thanks

[former_member203111]

Hi, Can someone please help on this issue, will really appreciate.

Thank You.