List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

Routine Lesson 2

Scenario: cube needs a customer number and the datasource does not provide the customer number. The datasource however contains the country code such as DE,FR etc. based on the country code a particular customer number is assigned for eg: for DE it is DE01J45 and for FR it is FR023J4. This customer number needs to be populated in the cube.
In this scenario the transformation from the DSO to the cube is worked on where the start routine is coded to load a data element from a standard table with a field in the standard table as a reference. This is then used in the END routine with a CASE statement and the  RESULT_FIELDS are loaded accordingly.
Code snippet:
select single low from ZBW_CONSTANT_TAB
into g_de_billto
where vnam = ‘JV_DE_BILLTO’.
Code snippet:
case -/bic/zjvsource.
when ‘DE’.
-Ship_to = g_de_billto.
-Sold_to = g_de_billto.
-billtoprty = g_de_billto.
-payer = g_de_billto
end case.
case <RESULT_FIELDS>-/bic/zjvsource.
                                                         when ‘DE’.
                                                 <RESULT_FIELDS>-Ship_to    = g_de_billto.
                                                <RESULT_FIELDS>-Sold_to    = g_de_billto.
                                                <RESULT_FIELDS>-billtoprty = g_de_billto.
                                                <RESULT_FIELDS>-payer      = g_de_billto
end case.

1 comment:


This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget