topic Re: relation between EKPO and EKKN in Application Development and Automation Discussions

relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 08:02:57 GMT

Hi, what is the relation between EKPO and EKKN?

I want to retrieve the requestor name (EKKN-WEMPF) for all open orders in EKPO. But I dont find any matching data between these two tables.

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 08:05:12 GMT

Hello,

EKPO-EBELN & EBELP

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 08:06:12 GMT

SELECT * FROM EKKN WHERE EBELN = EKPO-EBELN

AND EBELP = EKPO-EBELP.

WRITE EKKN-WEMPF.

.........................

Max

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 08:14:02 GMT

Hi S Kantheri,

EKPO-EBELN and EKPO-EBELP is the Relation. But the EKKN

will only be filled, if you have a COST-Order, f. Example

to KOSTL or AUFNR.

Regards, Dieter

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 08:25:25 GMT

Thanks Dieter,

But then how to relate these two table using KOSTL or AUFNR. EKPO doesnot have both

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 08:34:00 GMT

But what do you really need to do?

The link between EKKN and EKPO are only the field EBELN and EBELP.

If you know the item you can know its data for account reading EKKN, you don't need to know how to relate KOSTL or AUFNR with EKPO.

SELECT * FROM EKPO WHERE EBELN = P_EBELN

SELECT * FROM EKKN WHERE EBELN = EKPO-EBELN

AND EBELP = EKPO-EBELN

>EKKN-KOSTL is the cost center of the position you're elaborating

Max

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 08:40:57 GMT

Hi S Kantheri,

the question is, what do you want to know.

You can read EKKN with KOSTL or AUFNR and then

read EKPO with EBELN and EBELP from EKKN.

Or you read EKPO with KNTTP = 'F' (AUFNR) or = K (KOSTL)

and then go to EKKN with EKPO-EBELN and EBELP.

Regards, Dieter

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 09:22:43 GMT

I have a program which gets the open purchase order.

Now I need to get the requestor name (EKKN-WEMPF) for these purchase orders.

I know that ebeln and ebelp has to be used to get the corresponding EKKN records. But I am not getting any record picked. So is it that not all EKPO records have entry in EKKN? Only those EKPO record with KNTTP = 'F' or 'K' will have corresponding records in EKKN?

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 10:53:25 GMT

Hi S Kantheri,

if you want to know the WEMPF.

If there is no EKKN there is no WEMPF.

WEMPF can only be filled in EKKN/EBKN!

Look at SE11. WEMPF is only used in EBKN and in EKKN

not in EKPO, EKKO etc.

Regards, Dieter

Re: relation between EKPO and EKKN

Former Member — Fri, 07 Jul 2006 10:59:19 GMT

Hi,

Select single EKKN into lv_ekkn

where EBELN = EKPO-EBELN

AND EBELP = EKPO-EBELP.

Write:/ lv_ekkn.

Regs,

Venkat Ramanan