PurchaseOrder for a Sales Order

[Former Member]

Hi,

I need to get the purchase order number and the purchase order item for a paticular item in the Invoice.Please help me out with the tables and fields if possible

[Former Member]

Hi,

U will not get it here . Goto Table VBPA ( Table for doc flow with doc category C) to get the sales order no. after getting sales order no. -> select the line item -> goto schedule lines -> check field purchase requisition .

Goto VBPA - put doc category C and check preceeding doc no. (This is sales order no.)

Goto VBEP -> Put sales order no. line item no. and schedule line no. and check field ( VBEP-BANFN) (This is puchase requistion no.)

Take this no. and goto Table EBAN - Put Purchase Requisition no and field (EBAN-STATU -"B") (This is the indicator which suggest whether PO is created or not) then pick the field EBAN-BANFN This is ur PO No.

Hope this is fine

[Former Member]

Hi,

U will not get it here . Goto Table VBFA ( Table for doc flow with doc category C) to get the sales order no. after getting sales order no. -> select the line item -> goto schedule lines -> check field purchase requisition .

Goto VBPA - put doc category C and check preceeding doc no. (This is sales order no.)

Goto VBEP -> Put sales order no. line item no. and schedule line no. and check field ( VBEP-BANFN) (This is puchase requistion no.)

Take this no. and goto Table EBAN - Put Purchase Requisition no and field (EBAN-STATU -"B") (This is the indicator which suggest whether PO is created or not) then pick the field EBAN-BANFN This is ur PO No.

Hope this is fine

[Former Member]

Hi Karthik,

Using the invoice number, line number and preceding document category as 'C' combination go to table VBFA for the sales order number and line number. Using the sales order and line number as preceding document and preceding document line number and with the Subsequent doc category as 'V' in the same table you would get the purchase order and line number.

Regards

Nadarajah Pratheb