05-18-2006 11:56 AM
Hi all
Which field corresponds to SALES ORDER LINE NUMBER in VBAK table
thanks in advance
Regards
Neha kapoor
05-18-2006 12:00 PM
Hello Neha,
Table VBAK holds Sales Document: Header Data wheras VBAP holds Sales Document: Item Data. Field POSNR from VBAP holds line number. You need to relate table VBAK-VBELN = VBAP-VBELN to get Sales order item details.
Cheers,
Nilesh
05-18-2006 12:00 PM
Hello Neha,
Table VBAK holds Sales Document: Header Data wheras VBAP holds Sales Document: Item Data. Field POSNR from VBAP holds line number. You need to relate table VBAK-VBELN = VBAP-VBELN to get Sales order item details.
Cheers,
Nilesh
05-18-2006 12:06 PM
HI,
VBAK table is the header for sales orcer. so here you cannot find the item details, for that you have to go to VBAP table, sale order line number is VBAP-POSNR.
Regards
vijay
05-18-2006 12:09 PM
Hi Neha
VBAK: is for Header data
VBAP: is for Item data
So take the key field VBELN , you can get the
sales order line number which POSNR which in VBAP.
so VBAK-VBELN = VBAP-VBELN and get the VBAP-POSNR.
Regards.
Laxmi
05-18-2006 12:29 PM
Hey Neha,
VBAK is header table.... VBAP is the Item table of Sales Documents. POSNR is the field which represents Sales Order Items.
Regds
Sandip
05-18-2006 1:14 PM
Hi Neha,
VBAK is the sales order header table. The line items you get in the line item table which is VBAP. You get the field POSNR in VBAP which tells u the line item numbers
regards,
Satya