Mapping of location attributes from SAP to SPO product
Fetch and map the attributes from SAP to the corresponding fields in the ServiceNow CMN location and Office Location table.
SAP Table | SAP Field | SAP Description | SNOW Field | SNOW Table |
T001W | LAND1 | Country | country | cmn_location |
T001W | NAME1 | Name 1 | name | cmn_location |
T001W | PSTLZ | Postal Code | zip | cmn_location |
T001W | ORT01 | City | city | cmn_location |
T001W | REGIO | Region | state | cmn_location |
T001W | STRAS | Street/House | street | cmn_location |
SAP Table | SAP Field | SAP Description | SNOW Field | SNOW Table |
T001K | BUKRS | Company Code | legal_entity | sn_shop_office_location |
T001W | NAME1 | Name 1 | name | sn_shop_office_location |
T001W | REGIO | Country | country | sn_shop_office_location |
NA | NA | NA | location | sn_shop_office_location |
SAP Table | SAP Field | SAP Description | SNOW Field | SNOW Table |
NA | NA | NA | location | sn_sap_data_int_erp_plant_address_mapping |
T001K | BUKRS | Company Code | legal_entity | sn_sap_data_int_erp_plant_address_mapping |
NA | NA | NA | erp_source | sn_sap_data_int_erp_plant_address_mapping |
T001W | NAME1 | Name 1 | name | sn_sap_data_int_erp_plant_address_mapping |
T001W | LAND1 | Country | country | sn_sap_data_int_erp_plant_address_mapping |
T001W | WERKS | Plant | erp_location_id | sn_sap_data_int_erp_plant_address_mapping |
T001W | LAND1 | Country | country | sn_sap_data_int_erp_plant_address_mapping |