on 12-19-2008 9:46 AM
Hi Experts,
I have a requirement as below.
In LIPS table (SD document: Delivery: Item data), in this table has one kind data.
One record has maintianed 2 fields PSPNR(Project definition (internal)) and PS_PSP_PNR(Work Breakdown Structure Element (WBS Element)).
How to find sales order number of the above record? Could you tell me which table link the delivery item data and sales order number?
Thanks a lot,
Frank
Hi Frank, if i understood your question correctly u want sales order no. refering to that delivery . if that is it then it will be available in LIPS table field LIPS-VGBEL.
Think answers your question.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can find sales order & item reference in delivery from LIPS-VGBEL & LIPS-VGPOS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you give the delivery no. in VBFA-VBELN and the item no. of delivery in VBFA-POSNN you shoul get the sales order no. in VBFA-VBELV (VBFA-VBTYP="C").
(table VBFA stores information on sales document flow)
Regards,
Csaba
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi ,
to find the link between delivery and sales order.
PLease go through the table:
1.VAPMA
2.VBAP
3. VBUP
hope this will be helpful
Regards
Tapeshwar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi frank
Check the following tables VBAP , VAPMA , VBUP . It may help you
Regards
Srinath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
you can check VBELV field in LIPS table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
6 | |
6 | |
4 | |
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.