Conversion of DataSource Field into InfoObject 
Conversion of DataSource Field into InfoObject
Technical name: 0GN_CONV
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 and non-SAP systems) often deliver characteristic values that do not adhere to these standards.The ODS object 0GN_CONV (conversion of DataSource field à InfoObject) contains the rules for converting data from different source systems into InfoObjects for which standardized characteristic values exist.
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 standardize only those InfoObjects with a limited number of characteristic values (around 100).
This conversion does not standardize central master data with mass data (for 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.You use the function module RS_BCT_GN_CONVERT_IOBJ to evaluate this InfoObject.
Key Fields
|
Key Field |
Description |
|
0GN_IOBJNM |
Standardized InfoObject |
|
0LOGSYS |
Source system |
|
0GN_SOURVAL |
Characteristic value in the source system |
Data Fields
|
Data Field |
Description |
|
0GN_IOBJVAL |
Characteristic value of standardized InfoObjects |