Hello everyone,
Working with LO cockpit customization.Have two datasources,
1) 2lis_11_vaitm (Sales order item data) &
2) 2lis_12_vcitm (Delivery item data).
Fields chosen from the above dataasources:
2lis_11_vaitm: Sales Order no, Item and Cumulative order qty in sales units.
2lis_12_vcitm: Reference Doc Number, Reference item, Goods Movement Status, Picking Status, Goods Issue Date,Delivery Number, Delivery Qty.
When i populate the data from both these infosources into one cube, some of the data is missing. Like either the delivery qty. or the order qty. is 0 or the GI date is null.When i take a look at the data packet in the PSA, all the data is correct.
Update rules for the cube are:
2lis_11_vaitm:
Sales order no ---> Sales Order no.
Sales item -
> Sales item.
Order Qty -
> Order Qty.
2lis_12_vcitm:
Sales order no -
> Reference number of the doc.
Sales Item -
> reference item
Delivery -
> Delivery
GI Date -
> GI date
Good Mvmt St. -
> Goods Mvmt. st
Picking St. -
> Picking St.
Can somebody please help me with this problem.