Identifying Attributes of Products and Locations 
The following table describes the identifying attributes of object of the standard object types FDH_PROD Product and FDH_LOC Location in the standard system, and how they are related to the object attributes in SAP NetWeaver Business Warehouse (BW).
Note
You can change the external keys and the mapping instructions in Customizing under 
Cross-Application Components 
Demand Data Foundation Data Harmonization Technical Settings Define Object Types 
.
Object Type | Technical name of Attribute Used in BW | Technical name of Attribute Used in Data Harmonization | Attribute Name on UIs for Data Harmonization | Comment |
|---|---|---|---|---|
Product | GPID | OBJECT_ID | Product ID | The product ID is the internal key of a product in harmonization and unique within harmonization. |
/1DD/S_GPID | OBJECT_ID_HARMONIZED_DATA | Assigned Harmonized Product ID | Attribute of a source product that contains the ID of the harmonized product to which the source product is mapped. This attribute is empty when the data is imported from BW, but is filled when the data is exported to BW. | |
EANUPC | EANUPC | Global Trade Item Number or GTIN | The global trade item number (GTIN) identifies the product in logistics. The GTIN can be used to identify various products and is not unique. For example, own brand products of a retailer can have the same GTIN. | |
/1DD/S_PRODREF | EXTERNAL_KEY | External Key | The external key is the key as provided by data provider and is unique within the same context. | |
/1DD/S_PRODUCT | DATA_LOAD_ID | Technical ID | The technical ID is an internal key assigned by BW and is used there as the only identifying key. When a product has multiple GTINs assigned, only one record exists in BW. In the standard system, data harmonization uses the technical ID in combination with the GTIN to identify a product. For this reason, you can have multiple product records in data harmonization that refer to the same product record in BW. | |
MATERIAL | MATERIAL | Material Number | The material number is the ID that is used in the ERP system of the manufacturer. | |
Location | GLID | OBJECT_ID | Location ID | The location ID is the internal key of a location in harmonization and unique within harmonization. |
/1DD/S_GLID | OBJECT_ID_HARMONIZED_DATA | Assigned Harmonized Location ID | Attribute of a source location that contains the ID of the harmonized location to which the source location is mapped. This attribute is empty when the data is imported from BW, but is filled when the data is exported to BW. | |
GLN | GLN | Global Location Number or GLN | The global location number (GLN) identifies the location in logistics. | |
/1DD/S_LOCREF | EXTERNAL_KEY | External Key | The external key is the key as provided by data provider and is unique within the same context. | |
/1DD/S_LOCATION | DATA_LOAD_ID | Technical ID | The technical ID is an internal key assigned by BW during data upload and is unique within BW. | |
CUSTOMER_ID | CUSTOMER_ID | Account | The account ID is the ID that is used in the ERP system of the manufacturer. |