RCG SAP S/4 HANA Products System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
Module | Description |
---|---|
createPricingReq | Maps the CIM request to create product pricing data in SAP S/4HANA |
getProductByIdResponse | Maps the SAP S/4HANA product to CIM response |
getProductListResponse | Maps the SAP S/4HANA products to CIM response |
updateProductsRequest | Maps the CIM to SAP S/4HANA update product description |
updateProductdescription | Maps the CIM to SAP S/4HANA update product description |
updatePricingReq | Maps the CIM to SAP S/4HANA update product pricing |
update-custom-properties | Maps the CIM to SAP S/4HANA Product custom Properties |
getProductResponse | Maps the SAP S/4HANA product to CIM response |
getProductListResponsebyexternalId | Maps the SAP S/4HANA product to CIM response |
createProductsRequest | Maps the CIM request to create product data in SAP S/4HANA |
createProductsResponse | Maps the SAP S/4HANA to CIM response |
createPricingReq
Maps the CIM request to create product pricing data in SAP S/4HANA
Source:
./src/main/resources/dwl/createPricingReq.dwl
Mapping Tables
create Pricing request mapping.
CIM | Hana Source field | Description of source field |
---|---|---|
NA | ConditionTable | default to '304' |
NA | ConditionType | default to 'PPR0' |
priceBookEntry.unitListPrice | ConditionRateValue | product unit price |
NA | ConditionRateValueUnit | product pricing currency |
NA | to_SlsPrcgCndnRecdValidity.ConditionValidityEndDate | default to "9999-12-31T00:00:00" |
NA | to_SlsPrcgCndnRecdValidity.ConditionValidityStartDate | default to current timestamp |
id | to_SlsPrcgCndnRecdValidity.Material | product Id |
NA | to_SlsPrcgCndnRecdValidity.SalesOrganization | default to "1710" |
NA | to_SlsPrcgCndnRecdValidity.DistributionChannel | default to "10" |
getProductByIdResponse
Maps the SAP S/4HANA product to CIM response
Source:
./src/main/resources/dwl/getProductByIdResponse.dwl
Mapping Tables
get Products response mapping.
Resp Field | Coupa Source field | Description of source field |
---|---|---|
name | IndustryStandardName | product name |
longDescription | ProductDescription | product item description |
id | Product | product id |
description | to_Description | product description |
productSKU | ProductType | product type |
validFromDate | CreationDate | product creation date |
modelNumber | externalId | master product Id |
maximumOrderQuantityCount | PurchaseOrderQuantityUnit | product quantity |
manufacturerName | ManufacturerNumber | product manufacture number |
versionNumber | ProductGroup | product group |
primaryProductCategory | ProductGroup | product category |
brandGrade | Brand | product brand |
mSRPAmount | StandardPrice | product price |
externalSourceRecord | Product | product external record |
minimumOrderQuantityCount | PurchaseOrderQuantityUnit | product order quantity |
externalIds.statusLastChangedDate | LastChangeDateTime | product last changed date |
modelYear | FiscalYearCurrentPeriod | product model year |
revenueInstallmentPeriod | PeriodType | product period type |
modelYear | FiscalYearCurrentPeriod | product model year |
auditInfo.createdBy | CreatedByUser | product Created by user |
auditInfo.updatedBy | LastChangedByUser | product last changed by user |
auditInfo.createdDate | CreationDate | product creation date |
quantityScheduleType | StandardHandlingUnitType | product quantity schedule |
type | ProductType | product brand |
glAccountCode | ANPCode | product gl account code |
getProductListResponse
Maps the SAP S/4HANA products to CIM response
Source:
./src/main/resources/dwl/getProductListResponse.dwl
Mapping Tables
get Products response mapping.
Resp Field | Coupa Source field | Description of source field |
---|---|---|
name | IndustryStandardName | product name |
longDescription | ProductDescription | product item description |
id | Product | product id |
description | to_Description | product description |
productSKU | ProductType | product type |
validFromDate | CreationDate | product creation date |
modelNumber | externalId | master product Id |
maximumOrderQuantityCount | PurchaseOrderQuantityUnit | product quantity |
manufacturerName | ManufacturerNumber | product manufacture number |
versionNumber | ProductGroup | product group |
primaryProductCategory | ProductGroup | product category |
brandGrade | Brand | product brand |
mSRPAmount | StandardPrice | product price |
externalSourceRecord | Product | product external record |
minimumOrderQuantityCount | PurchaseOrderQuantityUnit | product order quantity |
externalIds.statusLastChangedDate | LastChangeDateTime | product last changed date |
modelYear | FiscalYearCurrentPeriod | product model year |
revenueInstallmentPeriod | PeriodType | product period type |
modelYear | FiscalYearCurrentPeriod | product model year |
auditInfo.createdBy | CreatedByUser | product Created by user |
auditInfo.updatedBy | LastChangedByUser | product last changed by user |
auditInfo.createdDate | CreationDate | product creation date |
quantityScheduleType | StandardHandlingUnitType | product quantity schedule |
type | ProductType | product brand |
glAccountCode | ANPCode | product gl account code |
updateProductsRequest
Maps the CIM to SAP S/4HANA update product description
Source:
./src/main/resources/dwl/updateProductsRequest.dwl
Mapping Tables
Maps CIM Product format to HANA Custom product request mapping
HANA | CIM | Description | |
---|---|---|---|
Product | productId | productId | |
IndustryStandardName | name | product name | |
ProductType | MAT | Product type default to MAT | |
GrossWeight | containerSize | Product Container Size | |
NetWeight | netWeight | product net weight | |
CrossPlantConfigurableProduct | "" | default to "" | |
ProductManufacturerNumber | "" | default to "" | |
MaximumPackagingLength | 0.000 | default to 0.000 | |
HasVariableTareWeight | false | default to false | |
ANPCode | "" | default to "" | |
WeightUnit | containerSizeUnit | Product container size unit | |
ProdNoInGenProdInPrepackProd | "" | default to "" | |
CompetitorID | "" | default to false | |
QualityInspectionGroup | "" | default to "" | |
IsBatchManagementRequired | false | default to false | |
IsRelevantForHzdsSubstances | false | default to false | |
Division | 00 | default to 00 | |
IndustrySector | M | false | default to M |
ProductIsConfigurable | false | default to false | |
QltyMgmtInProcmtIsActive | false | default to false | |
MaximumPackagingHeight | false | default to false | |
BaseUnit | containerType | Product container type | |
YY1_SME_UnvProductId_PRD | externalIds | product external id |
updateProductdescription
Maps the CIM to SAP S/4HANA update product description
Source:
./src/main/resources/dwl/updateProductdescription.dwl
Mapping Tables
Maps CIM Product format to HANA Custom product request mapping
HANA | CIM | Description |
---|---|---|
NA | Language | default to 'EN' |
Id | Product | product Id |
name | ProductDescription | description of Product |
updatePricingReq
Maps the CIM to SAP S/4HANA update product pricing
Source:
./src/main/resources/dwl/updatePricingReq.dwl
Mapping Tables
create Pricing request mapping.
cim | Hana Source field | Description of source field |
---|---|---|
ConditionRecord | ConditionRecord | pricing condition |
priceBookEntry.unitListPrice | ConditionRateValue | product unit price |
to_SlsPrcgConditionRecord.ConditionRateValueUnit | ConditionRateValueUnit | "" |
update-custom-properties
Maps the CIM to SAP S/4HANA Product custom Properties
Source:
./src/main/resources/dwl/update-custom-properties.dwl
Mapping Tables
Maps CIM Product format to HANA Custom product request mapping
SAP | CIM | Description |
---|---|---|
Product | Id | The product Id |
YY1_SME_UnvProductId_PRD | externalIds | External Unique Id |
YY1_SME_PowSuppCon_RTL_PRD | powersupplyconnected | The Product power supply |
YY1_SME_PackSize_RTL_PRD | packSize | The size of the product |
YY1_SME_PackSizeUn_RTL_PRD | packSizeUnit | Product Unit |
YY1_SME_KAM_Prod_RTL_PRD | kamProduct | Kam product id |
YY1_SME_Prod_Code_RTL_PRD | productCode | Product code |
YY1_SME_Prod_Desc1_RTL_PRD | description | Product description |
YY1_SME_Prod_Desc2_RTL_PRD | description | Product description |
YY1_SME_HierarchID_RTL_PRD | productLevel | Product Level |
YY1_SME_Asset_Temp_RTL_PRD | assetTemplate | Product Template |
YY1_SME_Prod_Temp_RTL_PRD | type | Product Type |
YY1_SME_Shrt_PCode_RTL_PRD | productShortCode | Product Short Code |
YY1_SME_Sell_Code_RTL_PRD | sellInCode | Product Sell in Code |
YY1_SME_ProdForm_RTL_PRD | productForm | The product Form |
YY1_SME_Flavor_RTL_PRD | productCategory.parentCategory | The Product Category Level |
YY1_SME_Brand_RTL_PRD | productCategory.parentCategory | The Product Category Level |
YY1_SME_Package_RTL_PRD | productCategory.parentCategory | The Product Category Level |
YY1_SME_Category_RTL_PRD | productCategory.parentCategory | The Product Category Level |
YY1_SME_Comp_Prod_RTL_PRD | competitiveProduct | Competitive Product |
YY1_SME_EstimValue_RTL_PRD | estimatedValue | Product estimated value |
getProductResponse
Maps the SAP S/4HANA product to CIM response
Source:
./src/main/resources/dwl/getProductResponse.dwl
Mapping Tables
get Products response mapping.
CIM | HANA | Description of source field |
---|---|---|
name | IndustryStandardName | product name |
longDescription | ProductDescription | product item description |
id | Product | product id |
productStatus | CrossPlantStatus | product cross plant status |
description | to_Description | product description |
productSKU | ProductType | product type |
productLevel | YY1_SME_HierarchID_RTL_PRD | Product Hierarchy |
type | YY1_SME_Prod_Temp_RTL_PRD | product type |
productCode | YY1_SME_Prod_Code_RTL_PRD | product code |
productShortCode | YY1_SME_Shrt_PCode_RTL_PRD | product short code |
manufacturerName | IndustryStandardName | product manufacturer name |
primaryProductCategory | YY1_SME_Package_RTL_PRD | product primary category |
masterProduct | ProductGroup | product master product |
brand | to_Description.ProductDescription | product brand |
kamProduct | YY1_SME_KAM_Prod_RTL_PRD | product kam |
competitiveProduct | YY1_SME_Comp_Prod_RTL_PRD | product competitive |
sellInCode | YY1_SME_Sell_Code_RTL_PRD | product sell in code |
packSize | YY1_SME_PackSize_RTL_PRD | product pack size |
packSizeUnit | YY1_SME_PackSizeUn_RTL_PRD | product pack size unit |
assetTemplate | YY1_SME_Asset_Temp_RTL_PRD | product asset template |
productForm | YY1_SME_ProdForm_RTL_PRD | product form |
containerSize | GrossWeight | product container size |
containerSizeUnit | WeightUnit | product container size unit |
containerType | BaseUnit | product container type |
deliveryValidFrom | YY1_SME_DlvValFrom_RTL_PRD | product delivery valid from |
validToDate | YY1_SME_FieldValTh_RTL_PRD | product valid to date |
validFromDate | YY1_SME_FieldValFr_RTL_PRD | product valid from date |
deliveryValidThru | YY1_SME_DlvValThru_RTL_PRD | product delivery valid through |
kamValidFrom | YY1_SME_KAMValFrom_RTL_PRD | product kam valid from |
kamValidThru | YY1_SME_KAMValThru_RTL_PRD | product kam valid through |
fundValidFrom | YY1_SME_FundValiFr_RTL_PRD | product fund valid from |
newItemValidFrom | YY1_SME_NewItmVldF_RTL_PRD | product new item valid from |
newItemValidThru | YY1_SME_NewItmVldT_RTL_PRD | product new item valid through |
fundValidThru | YY1_SME_FundValiTh_RTL_PRD | product fund valid through |
estimatedValue | YY1_SME_EstimValue_RTL_PRD | product estimated value |
manufacturer | IndustryStandardName | product manufacturer |
manufacturerItemNumber | YY1_SME_ManItemNmb_RTL_PRD | product item number |
productTemplate | YY1_SME_HierarchID_RTL_PRD | product template |
criterion1Product | Product | product criterion |
criterion1ProductDescription | to_Description.ProductDescription | product description |
criterion2Product | Product | product criterion |
criterion2ProductDescription | to_Description.ProductDescription | product description |
criterion3Product | Product | product criterion |
criterion3ProductDescription | to_Description.ProductDescription | product description |
criterion4Product | Product | product criterion |
criterion4ProductDescription | to_Description.ProductDescription | product description |
criterion5Product | Product | product criterion |
criterion5ProductDescription | to_Description.ProductDescription | product description |
criterion6Product | Product | product criterion |
criterion6ProductDescription | to_Description.ProductDescription | product description |
weight | GrossWeight | product weight |
height | SizeOrDimensionTex | product height |
size | SizeOrDimensionText | product size |
volume | MaterialVolume | product volume |
productCategory.id | null | productCategory default to null |
productCategory.name | productHierarchy.ParentNode | product name |
productCategory.activeFromDate | productHierarchy.ProdHierarchyValidityStartDate | product activeFromDate |
productCategory.activeToDate | productHierarchy.ProdHierarchyValidityEndDate | product activeToDate |
parentCategory | productLevel | product level |
productCatalog.id | null | catalog id default to null |
productCatalog.name | productHierarchy.ProdUnivHierarchy | product catalog name |
productCatalog.activeFromDate | productHierarchy.ProdHierarchyValidityStartDate | product catalog active from date |
productCatalog.activeToDate | productHierarchy.ProdHierarchyValidityEndDate | product catalog active to date |
priceBookEntry.id | "" | price book entry default to "" |
priceBookEntry.minRequiredQuantity | pricingResponse.to_SlsPrcgConditionRecord.ConditionQuantity | product pricing response |
priceBookEntry.maxRequiredOrderValue | 0 | price book entry default to 0 |
priceBookEntry.unitListPrice | pricingResponse.to_SlsPrcgConditionRecord.ConditionRateValue | product pricing response |
priceBookEntry.priceListType | pricingResponse.YY1_SME_CondPriLiT_RTL_PCH | product condition's PriceList Type |
priceBookEntry.priceType | pricingResponse.YY1_SME_CondPriTyp_RTL_PCH | product condition's Price Type |
priceBookEntry.validFrom | pricingResponse.to_SlsPrcgConditionRecord.ConditionValidityStartDate | product condition's validity start date |
priceBookEntry.validThru | pricingResponse.to_SlsPrcgConditionRecord.ConditionValidityEndDate | product condition's validity end date |
priceBookEntry.isActive | true | priceBookEntry default to true |
auditInfo.isDeleted | false | auditInfo default to false |
auditInfo.createdBy | CreatedByUser | product created by |
auditInfo.updatedBy | LastChangedByUser | product updated by |
auditInfo.updatedDate | LastChangeDateTime | product updated date |
auditInfo.createdDate | CreationDate | product creation date |
externalIds.externalIdType | MDM | default to MDM |
externalIds.externalId | YY1_SME_UnvProductId_PRD | external id |
externalIds.id | null | externalIds default to null |
externalIds.status | VALID | externalIds default to valid |
externalIds.statusLastChangedOn | now() | externalIds default to now() |
getProductListResponsebyexternalId
Maps the SAP S/4HANA product to CIM response
Source:
./src/main/resources/dwl/getProductListResponsebyexternalId.dwl
Mapping Tables
get Products response mapping.
Resp Field | Coupa Source field | Description of source field |
---|---|---|
name | IndustryStandardName | product name |
longDescription | ProductDescription | product item description |
id | Product | product id |
description | to_Description | product description |
productSKU | ProductType | product type |
validFromDate | CreationDate | product creation date |
modelNumber | externalId | master product Id |
maximumOrderQuantityCount | PurchaseOrderQuantityUnit | product quantity |
manufacturerName | ManufacturerNumber | product manufacture number |
versionNumber | ProductGroup | product group |
primaryProductCategory | ProductGroup | product category |
brandGrade | Brand | product brand |
mSRPAmount | StandardPrice | product price |
externalSourceRecord | Product | product external record |
minimumOrderQuantityCount | PurchaseOrderQuantityUnit | product order quantity |
externalIds.statusLastChangedDate | LastChangeDateTime | product last changed date |
modelYear | FiscalYearCurrentPeriod | product model year |
revenueInstallmentPeriod | PeriodType | product period type |
modelYear | FiscalYearCurrentPeriod | product model year |
auditInfo.createdBy | CreatedByUser | product Created by user |
auditInfo.updatedBy | LastChangedByUser | product last changed by user |
auditInfo.createdDate | CreationDate | product creation date |
quantityScheduleType | StandardHandlingUnitType | product quantity schedule |
type | ProductType | product brand |
glAccountCode | ANPCode | product gl account code |
createProductsRequest
Maps the CIM request to create product data in SAP S/4HANA
Source:
./src/main/resources/dwl/createProductsRequest.dwl
Mapping Tables
Maps CIM Product format to HANA product request mapping
HANA | CIM | Description |
---|---|---|
ProductGroup | productLevel | If the Product Level is product "L001" else "L005" |
ProductGroup | productLevel | If the Product Level is product "L001" else "L005" |
Product | id | product id |
IndustryStandardName | description | product description |
id | Product | product id |
ProductStandardID | ProductType | product type |
to_Valuation.Product | id | product Id |
to_Valuation.StandardPrice | mSRPAmount | standard price |
to_Valuation.PrevInvtryPriceInCoCodeCrcy | mSRPAmount | product price |
to_Valuation.PriceUnitQty | quantity | The quantity of the product default 1 |
to_Valuation.IsMarkedForDeletion | false | default to false |
to_Valuation.MovingAveragePrice | mSRPAmount | product mSRPAmount |
to_Valuation.PlannedPrice | mSRPAmount | The product planned Price |
to_Valuation.Currency | USD | default to USD |
to_Valuation.PriceDeterminationControl | "" | The product PriceDeterminationControl default to "" |
to_Valuation.ValuationType | "" | The product ValuationType default to "" |
to_Valuation.InventoryValuationProcedure | "" | The product InventoryValuationProcedure default to "" |
to_Valuation.ProdCostEstNumber | "" | The product ProdCostEstNumber default to "" |
to_Valuation.ProductOriginType | "" | The ProductOriginType default to "" |
to_Valuation.IsProducedInhouse | false | The product IsProducedInhouse default to false |
to_Valuation.PlannedPrice1InCoCodeCrcy | mSRPAmount | The Product PlannedPrice Currency |
to_Valuation.TaxBasedPricesPriceUnitQty | 0 | The product TaxBasedPricesPriceUnitQty default to 0 |
to_Valuation.ValuationArea | 1710 | The product ValuationArea default to 1710 |
to_Valuation.BaseUnit | "" | The product BaseUnit default to "" |
to_Valuation. ValuationClass | 3100 | The product class default to 3100 |
to_Valuation.ValuationCategory | "" | The ValuationCategory default to "" |
Brand | brand | The product Brand |
ProductType | MAT | The ProductType default to MAT |
to_Description.Language | EN | Language default to EN(English) |
to_Description.Product | id | product id |
to_Description.ProductDescription | name | product name |
to_SalesDelivery.product | Id | productId |
to_SalesDelivery.ProductDescriptionchnl | 10 | The product description channel default to 10 |
to_SalesDelivery.ProductSalesOrg | 1710 | Sales org is default to 1710 |
to_SalesDelivery.ItemCategoryGroup | NORM | default to NORM |
to_SalesDelivery.to_SalesTax.product | Id | productId |
to_SalesDelivery.to_SalesTax.Country | US | default to US |
to_SalesDelivery.to_SalesTax.TaxCategory | UTXJ | default to UTXJ |
to_SalesDelivery.to_SalesTax.TaxClassification | 1 | default to 1 |
to_Plant.product | Id | productId |
to_Plant.Plant | 1710 | default to 1710 |
to_Plant.PurchasingGroup | 002 | default to 002 |
to_Plant.PeriodType | M | default to M |
to_Plant.ProfitCenter | YB700 | default to YB700 |
to_Plant.MaintenanceStatusName | BEVDLP | default to BEVDLP |
to_Plant.IsMarkedForDeletion | false | default to False |
to_Plant.ProcurementType | F | default to F |
to_Plant.MRPType | ND | default to ND |
to_Plant.MRPResponsible | 001 | default to 001 |
to_Plant.to_PlantSales.Product | Id | productId |
to_Plant.to_PlantSales.Plant | 1710 | default to 1710 |
to_Plant.to_PlantSales.LoadingGroup | 0001 | default to 0001 |
to_Plant.to_PlantSales.AvailabilityCheckType | SP | default to SP |
GrossWeight | containerSize | product grossWeight |
NetWeight | 0 | default to 0 |
SizeOrDimensionText | size | size of the product |
CrossPlantConfigurableProduct | "" | default to "" |
ProductManufacturerNumber | "" | default to "" |
MaximumPackagingLength | 0.000 | default to 0.000 |
HasVariableTareWeight | false | default to false |
ANPCode | "" | default to "" |
WeightUnit | containerSizeUnit | containerSize |
ProdNoInGenProdInPrepackProd | "" | default to "" |
IsMarkedForDeletion | false | default to False |
CompetitorID | "" | default to "" |
QualityInspectionGroup | "" | default to "" |
IsBatchManagementRequired | False | default to false |
IsRelevantForHzdsSubstances | False | default to False |
Division | 00 | default to 00 |
IndustrySector | M | default to m |
ProductIsConfigurable | False | default to false |
QltyMgmtInProcmtIsActiv | false | default to False |
MaximumPackagingHeight | 0.000 | The maximum product height default to 0.000 |
BaseUnit | containerType | The product container Type |
YY1_SME_UnvProductId_PRD | externalId | product externalId |
YY1_SME_FieldValFr_RTL_PRD | validFromDate | The product valid From Date |
YY1_SME_PowSuppCon_RTL_PRD | powersupplyconnected | The product productpowersupply |
YY1_SME_PackSize_RTL_PRD | packSize | product package size |
YY1_SME_PackSizeUn_RTL_PRD | packSizeUnit | The product package size |
YY1_SME_KAM_Prod_RTL_PRD | kamProduct | The productkam code |
YY1_SME_Prod_Code_RTL_PRD | productCode | The product code |
YY1_SME_Prod_Desc1_RTL_PRD | description | ProductDescription |
YY1_SME_Prod_Desc2_RTL_PRD | description | ProductDescription |
YY1_SME_HierarchID_RTL_PRD | productLevel | level of the product |
YY1_SME_Asset_Temp_RTL_PRD | assetTemplate | product template |
YY1_SME_Prod_Temp_RTL_PRD | type | ProductType |
YY1_SME_Shrt_PCode_RTL_PRD | productShortCode | product Short Code |
YY1_SME_Sell_Code_RTL_PRD | sellInCode | product sell in code |
YY1_SME_ProdForm_RTL_PRD | productForm | productForm |
YY1_SME_Flavor_RTL_PRD | productCategory.parentCategory | productCategory |
YY1_SME_Brand_RTL_PRD | productCategory.parentCategory | productCategory |
YY1_SME_Package_RTL_PRD | productCategory.parentCategory | The product Category |
YY1_SME_SubCategor_RTL_PRD | productCategory.parentCategory | The product productCategory |
YY1_SME_Category_RTL_PRD | productCategory.parentCategory | the productCategory |
YY1_SME_Comp_Prod_RTL_PRD | competitiveProduct | The competitiveProduct |
YY1_SME_ManItemNmb_RTL_PRD | manufacturerItemNumber | The Product Manufacture number |
YY1_SME_EstimValue_RTL_PRD | estimatedValue | The product estimatedValue |
createProductsResponse
Maps the SAP S/4HANA to CIM response
Source:
./src/main/resources/dwl/createProductsResponse.dwl
Mapping Tables
create Product response mapping.
Resp Field | Coupa Source field | Description of source field |
---|---|---|
responseStatus | successful | product response status |
resultMessages.severity | items.successful | product severity |
resultMessages.message | items.successful | product message |
parameters.paramValue | Id | product paramValue |