Conversion of DataSource Field into InfoObject 
Conversion of DataSource Field into InfoObject
Technical name: 0GN_CONV_1
Use
Certain InfoObjects have standardized, default characteristic values (for example, ISO codes for country and language) or company-wide standard characteristic values (for example, region, industry sector). These standardized characteristic values have to be transferred into the global attributes of
consolidated InfoObjects for business partner, product and product category. However, DataSources from different source systems (for example, SAP R/3, SAP CRM, non-SAP systems) often deliver characteristic values that do not adhere to the standards.The InfoSource 0GN_CONV_1 (conversion of DataSource field à InfoObject) contains the rules for converting data from different source systems into InfoObjects for which standardized characteristic values exist. The data target for this InfoSource is the ODS obejct 0GN_CONV.
Example: Country Conversion
|
Source system |
Standardized InfoObject |
Characteristic Value in the Source System |
Standardized Characteristic Value |
|
R/3 # 1 |
0COUNTRY |
D |
DE |
|
CRM #1 |
0COUNTRY |
UK |
GB |
|
Oracle |
0COUNTRY |
GER |
DE |
Conversion can only standardize InfoObjects with a limited number of characteristic values (around 100).
This conversion does not standardize central master data with mass data (InfoObjects such as product or business partner). Standardization of such master data takes place in the BW system using the
consolidated InfoObjects for business partner, product and product category.A PC file is used as the DataSource for the InfoSource 0GN_CONV_1. The conversions are saved in this file record by record in the following format:
Format of Conversions
|
Field |
Data Type |
Length |
|
Standardized InfoObject |
CHAR |
30 |
|
Source system |
CHAR |
10 |
|
Source characteristic value |
CHAR |
60 |
|
Characteristic value of standardized InfoObject |
CHAR |
60 |