urgent

[Former Member]

pls send me the link between likp and purchase table.

ekbe,ekpo,ekko...any purchase table

plsss

it is urgent

[Former Member]

pls send me the link between likp and purchase table.

ekbe,ekpo,ekko...any purchase table

plsss

it is urgent

[Former Member]

my question is not yet answered

[Former Member]

Hi,

May I know the actual requirement why do you need this relation.

Regards,

Jayaram..

[Former Member]

suppose table T_data has ur purchase orders...

SELECT EBELN

EBELP

BELNR

BUZEI

FROM EKBE

INTO CORRESPONDING FIELDS OF TABLE T_DLVY

FOR ALL ENTRIES IN T_DATA

WHERE

EBELN EQ T_DATA-EBELN AND

EBELP EQ T_DATA-EBELP AND

VGABE EQ '8' . " Delivery

belnr and buzei will be delivery numbers and item numbers..

this may not work for all type of POs...u have to make sure in ur system, what type sof POs will this work.. generally, inter company stock transfers ..will work..

but for PO to SO cases.. this will not...

in that case.. u may have to first select the Sales order for the corresponding PO..

and then find it from LIPs based VGBEL and VGPOS fields..

[Former Member]

Hi,

Only for STO(Stock transfer Orders) ie, Inter company POs you will get deliveries in EKBE table.

Select BELNR from EKBE with VGABE ='8' .then you will get the delivery no.

Regards,

Jayaram...

[Former Member]

Hi ,

just check the link u will get the all the relations between tables required

http://www.erpgenie.com/abap/tables_mm.htm#Purchasing%20Tables

Reward points if useful..

Regards

Nilesh

[Former Member]

Hi,

Please mail me(id from business card) your email ID. I do have a nice exe file showing the linking between the tables you are talking about.

Regards

[Former Member]

Hi,

Meanwhile, plz refer the following site for table linking required by you -

http://www.erpgenie.com/abap/tables_mm.htm#Purchasing Tables

Hope this sort out your issue.

PS If the answer solves your query, plz close the thread by rewarding each reply.

Regards

[Former Member]

just give where used list and select the table

[Former Member]

hi

the following are the tables related to purchasing

EKKO Purchase document

EKPO Purchase document (item level)

EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item

EKET Delivery schedule

VETVG Delivery Due Index for Stock Transfer

EKES Order Acceptance/Fulfillment Confirmations

EKKN Account assignment in purchasing

EKAN Vendor address purchasing

EKPA Partner functions

EIPO Item export / import data

EINA Purchase info record (main data)

EINE Purchase info record (organisational data)

EORD Source list

EBAN Purchase requisition

EBKN Purchase Requisition Account Assignment