Skip to Content
0
Former Member
Sep 07, 2004 at 07:55 PM

Problem loading data into infocube

62 Views

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.