Can't find Sales Doc. Type in 2LIS_12_VCITM

29 Views

I have a requirement to find open order qty. by manipulating two ODS objects mapped to 2LIS_11_VASCL & 2LIS_12_VCITM datasources respectively.

I need the following information from 2LIS_11_VASCL & 2LIS_12_VCITM datasources to find the open order qty.

1) Sales order from both 2LIS_11_VASCL & 2LIS_12_VCITM.

2) Item from both 2LIS_11_VASCL & 2LIS_12_VCITM.

3) Sales doc. Type from both 2LIS_11_VASCL & 2LIS_12_VCITM.

4) Act. goods issue date from 2LIS_12_VCITM.

5) Del. Qty. from 2LIS_12_VCITM.

6) Planned goods issue date from 2LIS_11_VASCL.

7) Confirmed qty. from 2LIS_11_VASCL.

I could map all the above referred fields except "Sales Document Type" from 2LIS_12_VCITM.

Can someone help me with the answer? Thanks in advance for the helping me with the answer and please let me know how to assign reward points as I am new to SDN.

Gita.