CO-PA Characteristics Derivation Types – Part III
CO-PA Characteristics Derivation Types – Part III
In our last post we tried to go through “Table Lookup” which is one of the COPA Derivation Type. Although it is majorly used Derivation Strategy, there are few more derivation types that can be used as per the business requirement.
In this post we will try to work ahead with next Characteristics Derivation Type i.e. “Moves” lets dive into this type and try to understand how it is configured.
Implementation Consideration
Using Transaction Code KEDR we can maintain “Moves”. After using Transaction Code KEDR, the system takes us to following screen:
Select “Move” here and click on OK button to proceed further.
Creating Step with “Move”
After selecting “Move” system will take us to the following screen:
Definition Tab
If we look closely into the screen, we can find that the tab “Definition” basically has two options (radio buttons) available for selection i.e. Source Field and Constant. At the same time system also requires Target Field. We will look into details of both the available options one by one.
Source Field
To understand this options, lets have a look at the following image and try to understand how this works:
In the above screen we have maintained Company Code “BUKRS” under Source Field and Sales Organization “VKORG” as Target Field.
This maintenance of field will take the information available under Characteristics “Company Code” and fill it Characteristics “Sales Organization”. For e.g. if the Company Code is “1000” then this value will be automatically entered by the system in “Sales Organization”.
Constant
Clicking on the Constant radio button allows use of this option by deactivating Source Field.
To understand this options, lets have a look at the following image and try to understand how this works:
In the above example I have entered Sales Organization “VKORG” as Target Field. After entering the field when we press enter system assigns search help of Sales Organization to the Constant Button. Which means now system allows us to select available Sales Organization from the standard table.
Select the Sales Organization from the available list using Search Help and press enter. This will show the description of the selected Sales Organization.
In real time during transaction processing, system automatically enters this value i.e. “1000” in “Sales Organization” characteristic.
Condition Tab
In addition to the Definition Tab where we define Source/Constant and Target Fields with their values, SAP provides one more tab i.e. Condition which can be used if above derivation is to be performed only under certain conditions. Given below is how the screen of Condition Tab looks like:
In the above screen we can notice “Origin”, “Operator” and Value columns available for entry. Lets try to understand them one by one.
Origin
Under this column we select the CO-PA Characteristic based on which the condition is to work. This is the base for condition.
Operator
This is operator for the condition and has following options available for selection:
Select the appropriate operator, in our case we have selected “=” i.e. “equal to”.
Value
This is a searchable field available for us to find if any existing value is to be inserted. In our case, we can search the list of available “Sales Organizations”, but we have not entered anything. Upon leaving the field blank, system mentions it as “Not assigned”, in this case, the derivation works if “Sales Organization” field is blank.
Before creating the step it is crucial to decide if one has to go with Source and Target Field or Constant and Target field combination. This decision can be based on scenario and availability of data.
Overview
Click “F6” or use menu Extras => Overview and the system will show following screen:
This screen gives us overview of the current CO-PA Derivation step.
After maintaining all the required information, click on save button and the step will be saved for deriving values for CO-PA Reporting.
Hope this post adds value to your knowledge.
References
What Next?
In the next post we will try to look into other types of CO-PA Characteristic Derivation in detail.
Till then have a great day ahead…….
#SAPCOPA #Controlling #COPADerivationRule #COPADerivationMove #COPACharacteristicsDerivation #DerivationRule #CharacteristicsDerivation #COPADerivationRule #SAP #SAPCO