on 10-28-2013 4:01 PM
Hi experts,
I m working on SD data to load into SAP Business warehouse, and I have a functional question and I really appreciate your help.
I have all information about deliveries items: Document number, Item, article ...etc. I have also the document number of the sales order that those delivries items were created from.
Now, I m wondering how can I find the sales order Item that correspond to a specific delivery Item? is by Item number?
Or by Article number? but in this case what if I have the same Article number many times in several Item inside the sales oder...
Thank you for you help.
Abdess,
Hi everyone,
The Delivery Item number may or may not be equal to the Sales Order Item number, so we cannot use it to look for the Sales Order Item number that corresponds to a Delivery Item number.
In the delivery document, this is a field called "Reference ITEM", it contains the Sales Order Item number: LIPS->VGPOS.
Thank you all.
Abdess,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Abdessamad,
I m looking for the sales order Item corresponding to a delivery Item .
Whether you want sales order, item; for a delivery, item or vice-versa; make use of table VBFA.
Give the document number and item number, you can get the preceeding or subsequent document number and item number.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sales order Item Number.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Abdessamad,
It is not alway the case that sales order, item number would be identical to delivery, item number.
There are two different processes, with different documents; and in each document, the items are arranged in a sequence, so the sequence could be same or different, depending upon how and how many documents are created.
Hi,
For delivery item reference number, you can refer the Delivery item table LIPS. In this table for each delivery item there is a reference Sales order number in column LIPS-VGBEL.
I hope this will help.
Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.