topic linking between the tables in Application Development and Automation Discussions

linking between the tables

Former Member — Wed, 12 Nov 2008 14:06:53 GMT

Hi all.

i wish to know the common table between tables eban,ekko,ekpo and eket.

As their is no common key field although ebeln and ebelp are there but their check tables are different,

please guide me how to link these tables.

As my select query is showing the data available and read table is also showing the data coming but may be because the ebeln can be differnet for diffrent table thats why iam not geting any display.

please guide

Re: linking between the tables

former_member585060 — Wed, 12 Nov 2008 14:32:57 GMT

Hi,

These are the fields common in EKKO,EKET,EKPO

EKPO

(Purchasing Document Item)

Purchasing Doc (EBELN)

Item (EBELP)

EKKO

(Purchasing Document Header)

Purchasing Doc (EBELN)

EKET

(Delivery Schedules)

Purchasing Doc (EBELN)

Item (EBELP)

Delivery Schedule (ETENR)

For EBAN look for these fields relations to EKKO and EKPO

EBAN

KONNR(EKKO)

KTPNR(EKPO)

Regards

Bala Krishna

Re: linking between the tables

Former Member — Wed, 12 Nov 2008 14:40:10 GMT

in EBELN filed also there in different types numbers like below based on Purchasing Document Category(BSTYP).. better ask your functional consultant wich category you need to display..

Request for Quotationhere

Purchase Order

Contract

Scheduling Agreement

Re: linking between the tables

Former Member — Wed, 12 Nov 2008 14:42:43 GMT

hi,

check this:

EBAN

(Purchase Requisition)

Purchasing Req (BANFN)

Item (BNFPO)

EKKO

(Purchasing Document Header)

Purchasing Doc (EBELN)

EKPO

(Purchasing Document Item)

Purchasing Doc (EBELN)

Item (EBELP)

EKET

(Delivery Schedules)

Purchasing Doc (EBELN)

Item (EBELP)

Delivery Schedule (ETENR)

Re: linking between the tables

Former Member — Wed, 12 Nov 2008 14:43:48 GMT

Hi,

Yes you are right !!

EBAN is for Purchase Requisition.

Get the EBELN and EBELP from this table against BANFN and BNFPO.

Pass this on to EKKO and EKPO. Data will be there if not deleted or archived. As you know this is Purchase Order Header and Item Table.

EKET for Scheduling. So Pass the same EBELN and EBELP to EKET and you will get multiple values based on the available scheduling agreement.

If still data is not coming then please check the query logic once.

Cheers

Somnath

Re: linking between the tables

Former Member — Wed, 12 Nov 2008 14:52:31 GMT

Hi,

Iam kiran posanapalli, just try out this by linking up table with the common fields provided.

**************EBAN---Purchase Requisition*****************************

BANFN BANFN CHAR 10 0 Purchase Requisition Number

BNFPO BNFPO NUMC 5 0 Item Number of Purchase Requisition

******************************************************************************

********************EKKO-------Purchasing Document Header**************

EBELN EBELN CHAR 10 0 Purchasing Document Number

*****************************************************************

**********************EKPO-------Purchasing Document Item*********

EBELN EBELN CHAR 10 0 Purchasing Document Number

EBELP EBELP NUMC 5 0 Item Number of Purchasing Document

BANFN BANFN CHAR 10 0 Purchase Requisition Number

BNFPO BNFPO NUMC 5 0 Item Number of Purchase Requisition

***************************************************************************

***************EKET----

Scheduling Agreement Schedule Lines*************

EBELN EBELN CHAR 10 0 Purchasing Document Number

EBELP EBELP NUMC 5 0 Item Number of Purchasing Document

ETENR EETEN NUMC 4 0 Delivery Schedule Line Counter

BANFN BANFN CHAR 10 0 Purchase Requisition Number

BNFPO BNFPO NUMC 5 0 Item Number of Purchase Requisition

************************************************************************

Regards,

Kiran Posanapalli