FIELD RELATING TABLES

[Former Member]

can anyone give me the fields relating EBAN, EKKO and EKPO

[Former Member]

can anyone give me the fields relating EBAN, EKKO and EKPO

[Former Member]

EBAN- it's the purchase requisition table

when u create a purchase requisition using ME51N it's saved to this table.

EKKO- Purchasing Doc Header

EKPO- Purchasing Doc Item

When u create a purchase order using ME21N, data go to these 2 tables.

as per relation is concerned if u generate a PO with respect to a PR then there is a relation between EBAN & EKPO

EKKO - EKPO mapped with EBELN

EKPO - EBAN mapped with BANFN & BFNPO

Reward if useful

[JozsefSzikszai]

Amardeep Khaira come here, a question for you to answer and you can go on with the point hunting...

[Former Member]

Hi

U can go to transaction SQVI and enter the table names to get the common fields between them.

Thanks

Vasudha

[Former Member]

Create a database view in SE11 by adding the tables EBAN, EKKO and EKPO, select all and click on show relationship. It will display all the fields relating to these tables.

THanks

vijay

PLZ reward poitns if helpful

[Former Member]

EKKO and EKPO can be linked with field EBELN.

EKPO and EBAN link them with Field EBELP in EKPO and

Field BNFPO in EBAN.