• admin

CO-PA Characteristics Derivation Types – Part II

CO-PA Characteristics Derivation Types – Part II

Lets go ahead in this post and try to find out next Derivation Type which is Table Lookup.

This type of Derivation Type is about fetching the data from Tables based on certain characteristics available from the transaction. This is mostly used Derivation Type in all the available types.

Table lookups let you read individual records of any table to determine characteristic values. Here the source fields must make up the key of a specific table, from which the system can copy certain contents to the target fields.

When you generate the environment for your operating concern, the system automatically generates table lookups for all characteristics that you choose from predefined SAP tables.

Implementation Consideration

Using Transaction Code KEDR we can maintain Table Lookup. After using Transaction Code KEDR, the system takes us to following screen:


Select Table Lookup here and click on OK button to proceed further.

Creating Table Lookup

After selecting Table Lookup, the system will take us to the following screen:


COPA Derivation

Above screen is divided into two parts:

  1. Source Fields for Table Lookup

  2. Assignment of Table Fields to Target Fields

Source Fields

In the above image we can see that following information has to be maintained explained below:

  1. Origin (Table Name) and Origin Field (Field Name) from standard table

  2. Origin (CO-PA) and Origin Field (Field Name)

This information works as the basic condition, in the above example we can see the MARA-MATNR as source in standard tables and COPA-ARTNR in CO-PA Tables. This means the value in COPA-ARTNR is to be passed on to table MARA under field MATNR to identify the information under target field.

Target Fields

In the above image we can see that following information has to be maintained explained below:

  1. Origin (Table Name) and Origin Field (Field Name) from standard table

  2. Origin (CO-PA) and Origin Field (Field Name)

This information under MARA-SPART i.e. Division is identified in the table for AMAR for MATNR value available from source field and is passed on to SPART field under CO-PA.

Sum up

To sum up the things, system will get the ARTNR information fetched from transaction and is passed to table MARA in field MATNR. Now the information available under MARA-SPART field for the material number is identified and passed on to SPART characteristics under CO-PA. This will essentially pass on Division of under material master to CO-PA.

Standard Table Lookups

SAP by default  provides various standard Table Lookup steps as part of standard solution when we generate the Operating Concern.

Reference

SAP Help

What Next?

In the next posts we will try to look further into other CO-PA Derivation Types. Till then have a great day ahead………… Next Post

#SAPCOPA #Controlling #COPADerivationRule #COPACharacteristicsDerivation #DerivationRule #COPATableLookup #CharacteristicsDerivation #COPADerivationRule #SAP #SAPCO

64 views0 comments

Recent Posts

See All