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:
Above screen is divided into two parts:
Source Fields for Table Lookup
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:
Origin (Table Name) and Origin Field (Field Name) from standard table
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:
Origin (Table Name) and Origin Field (Field Name) from standard table
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
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