topic Re: FIELD RELATING TABLES in Application Development and Automation Discussions

FIELD RELATING TABLES

Former Member — Tue, 19 Feb 2008 09:59:34 GMT

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

Re: FIELD RELATING TABLES

Former Member — Tue, 19 Feb 2008 10:04:23 GMT

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

Re: FIELD RELATING TABLES

JozsefSzikszai — Tue, 19 Feb 2008 10:04:25 GMT

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

Re: FIELD RELATING TABLES

Former Member — Tue, 19 Feb 2008 10:04:47 GMT

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

Thanks

Vasudha

Re: FIELD RELATING TABLES

Former Member — Tue, 19 Feb 2008 10:07:25 GMT

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

Re: FIELD RELATING TABLES

Former Member — Tue, 19 Feb 2008 10:07:30 GMT

EKKO and EKPO can be linked with field EBELN.

EKPO and EBAN link them with Field EBELP in EKPO and

Field BNFPO in EBAN.