How Can We Fetch Zfields defined in EKPO/EKKO and MSEG to COPA Characteristics

[Former Member]

Hi SAP Gurus,

We have requirement to calculate profitability based on some characteristics which are not standard fields.

I have defined them as Custom Characteristics and its working fine. But for the same every time i have to maintain

KES1 and KEDR for the same.

Those fields are coming from PO and MIGO transactions can i directly create Z--FIELDS in PO and MIGO and link

this fields to COPA Characteristics so that i need not to maintain KES1 and KEDR every time.

I have tried to create new characteristics but i am not able to find PO tables EKPO/EKKO and MIGO table MSEG.

I can see below mentioned tables only no table is related to MM how can i proceed to flow these new characteristics

value to COPA. Can i use any table look up derivation rule

KNA1    General Data in Customer Master

KNB1    Customer Master (Company Code)

KNVV    Customer Master Sales Data

MARA    General Material Data

MARC    Plant Data for Material

MVKE    Sales Data for Material

PACPROJECT    Characteristics from cProjects That Can Be Used in CO-PA

PACRMIPM    Characteristics from CRM IPM That Can Be Used in CO-PA

PACRMSLS    Attributes of CRM Sales That Can be Used in PA

PACRMSRV    Attributes of CRM Service that can be used in PA

PAPARTNER    SD partner that can be used in CO-PA

PARETAIL    Retail fields that can be used in CO-PA

PRPS    WBS (Work Breakdown Structure) Element Master Data

T001W    Plants/Branches

VBAK    Sales Document: Header Data

VBAP    Sales Document: Item Data

VBKD    Sales Document: Business Data

VIAUFKST    Generated Table for View

Thanks

Sagar

[ajaycwa1981 · Accepted solution]

Hi

KES1 you maintain because you defined the char as "With own value maintenance" in KEA5

KEDR is a one time activity for each characteristic

What you want to achieve - linking Z field of PO to COPA - this is exacty what you do in KEDR..

KES1 you can avoid if you choose "char without own value maint"

br, Ajay M

[Former Member · Accepted solution]

HI Ajay,

I have a similar issue of fetching a Net order price . What sagar want to ask is for bringing the characteristic values which are not there in 18 tables mentioned in his query

suppose I want to fetch a Net order price which is in EKPO table. If I want to capture the value of the field NETPR i.e. Net order price from the table EKPO, how to do this is the problem.

So, I have the same requirement of fetching the characteristic values which are not appearing in 18 Tables. Even If I define User defined characters, how to write a derivation rule (Table Lookup)  referring the table EKPO etc

will you please help us out?

regards,

Makrand

[Former Member · Accepted solution]

Hi,

In tcode KEDR, you can use "table look up" option, where in you specify table EKPO..

In Assignment of table fields to Target fields you can choose EKPO-NETPR in origin section for first half and assign custom characteristic in origin section of second half.

Ofcourse, you have to have "Source fields for table lookup" maintained fields EKPO-EBELN and EKPO-EBELP with copa characteristics..