link between PO and Delivery

[Former Member]

How do we get the Purchase order number from a delivery.

Say i have an Purchase order and from that i have created a delivery.

In my output for the delivery, i need the preceeding document number for the delivery which is the PO number.

How do i get the same. what table should i look in. I checked the VBFA table, but i am not able to get the same there...

is there any table with which we can get this info.

thanks and Regards,

Gauravjit.

[Former Member]

Hi Gauravjit,

I suppose you are speaking of Stock Transfer Scenario. In this the Document Flow does not updates the PO number.

The link between Deliver & PO number will have to be established through common firld in PO table & Delivery Table. This requires to be explored at T.Code: VL04 / VL10B / VL10D level & you should certainly get the link. I am not in front of SAP system, else I would try to get the details & furnish the same.

Regards,

Rajesh Banka

Rerward points if helpful.

Gauravjit - It's good to see you back in the forum these days.

[Former Member]

Dear Gauravjit,

LIKP (Delivery Document header), VBFA (Sales Document Flow), and EKBE (Purchase order history).

SAP MM Tables and Table Relations:

http://www.erpgenie.com/abap/tables_mm.htm

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

MOFF Lists what views have not been created

A501 Plant/Material

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

EKKO Purchasing Document Header

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T Texts for Purchasing Document Types

SAP SD Tabels and Table Relations:

http://www.erpgenie.com/abap/tables_sd.htm

KONV Conditions for Transaction Data

KONP Conditions for Items

LIKP Delivery Header Data

LIPS Delivery: Item data

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBBE Sales Requirements: Individual Records

VBEH Schedule line history

VBEP Sales Document: Schedule Line Data

VBFA Sales Document Flow

VBLB Sales document: Release order data

VBLK SD Document: Delivery Note Header

VBPA Sales Document: Partner

VBRK Billing: Header Data

VBRP Billing: Item Data

VBUK Sales Document: Header Status and Administrative Data

VBUP Sales Document: Item Status

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

VEPVG Delivery Due Index

Regards,

Naveen.

[Former Member]

Hi Gauravjit,

In LIPS give the delivery doc and line no. to get the purchase order and line no. The fields are Reference Doc. VGBEL and reference item VGPOS.

Regards

Nadarajah Pratheb

[Former Member]

hi,

check in LIKP & LIPS tables.it would give u some insight

regards

sriram.

[Former Member]

Hi,

After checking i found that it is stored in LIPS Table and field VGBEL. And also i would like to add table VBFA (Document Flow if the same is active).

Rewards point if it helps.

Regards,

Sreekanth

Message was edited by:

Sreekanth. V.T