RCG SAP S/4 HANA Products System API - Implementation Template

(0 reviews)

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.

ModuleDescription
createPricingReqMaps the CIM request to create product pricing data in SAP S/4HANA
getProductByIdResponseMaps the SAP S/4HANA product to CIM response
getProductListResponseMaps the SAP S/4HANA products to CIM response
updateProductsRequestMaps the CIM to SAP S/4HANA update product description
updateProductdescriptionMaps the CIM to SAP S/4HANA update product description
updatePricingReqMaps the CIM to SAP S/4HANA update product pricing
update-custom-propertiesMaps the CIM to SAP S/4HANA Product custom Properties
getProductResponseMaps the SAP S/4HANA product to CIM response
getProductListResponsebyexternalIdMaps the SAP S/4HANA product to CIM response
createProductsRequestMaps the CIM request to create product data in SAP S/4HANA
createProductsResponseMaps 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.

CIMHana Source fieldDescription of source field
NAConditionTabledefault to '304'
NAConditionTypedefault to 'PPR0'
priceBookEntry.unitListPriceConditionRateValueproduct unit price
NAConditionRateValueUnitproduct pricing currency
NAto_SlsPrcgCndnRecdValidity.ConditionValidityEndDatedefault to "9999-12-31T00:00:00"
NAto_SlsPrcgCndnRecdValidity.ConditionValidityStartDatedefault to current timestamp
idto_SlsPrcgCndnRecdValidity.Materialproduct Id
NAto_SlsPrcgCndnRecdValidity.SalesOrganizationdefault to "1710"
NAto_SlsPrcgCndnRecdValidity.DistributionChanneldefault to "10"

(back to top)

getProductByIdResponse

Maps the SAP S/4HANA product to CIM response

Source: ./src/main/resources/dwl/getProductByIdResponse.dwl

Mapping Tables

get Products response mapping.

Resp FieldCoupa Source fieldDescription of source field
nameIndustryStandardNameproduct name
longDescriptionProductDescriptionproduct item description
idProductproduct id
descriptionto_Descriptionproduct description
productSKUProductTypeproduct type
validFromDateCreationDateproduct creation date
modelNumberexternalIdmaster product Id
maximumOrderQuantityCountPurchaseOrderQuantityUnitproduct quantity
manufacturerNameManufacturerNumberproduct manufacture number
versionNumberProductGroupproduct group
primaryProductCategoryProductGroupproduct category
brandGradeBrandproduct brand
mSRPAmountStandardPriceproduct price
externalSourceRecordProductproduct external record
minimumOrderQuantityCountPurchaseOrderQuantityUnitproduct order quantity
externalIds.statusLastChangedDateLastChangeDateTimeproduct last changed date
modelYearFiscalYearCurrentPeriodproduct model year
revenueInstallmentPeriodPeriodTypeproduct period type
modelYearFiscalYearCurrentPeriodproduct model year
auditInfo.createdByCreatedByUserproduct Created by user
auditInfo.updatedByLastChangedByUserproduct last changed by user
auditInfo.createdDateCreationDateproduct creation date
quantityScheduleTypeStandardHandlingUnitTypeproduct quantity schedule
typeProductTypeproduct brand
glAccountCodeANPCodeproduct gl account code

(back to top)

getProductListResponse

Maps the SAP S/4HANA products to CIM response

Source: ./src/main/resources/dwl/getProductListResponse.dwl

Mapping Tables

get Products response mapping.

Resp FieldCoupa Source fieldDescription of source field
nameIndustryStandardNameproduct name
longDescriptionProductDescriptionproduct item description
idProductproduct id
descriptionto_Descriptionproduct description
productSKUProductTypeproduct type
validFromDateCreationDateproduct creation date
modelNumberexternalIdmaster product Id
maximumOrderQuantityCountPurchaseOrderQuantityUnitproduct quantity
manufacturerNameManufacturerNumberproduct manufacture number
versionNumberProductGroupproduct group
primaryProductCategoryProductGroupproduct category
brandGradeBrandproduct brand
mSRPAmountStandardPriceproduct price
externalSourceRecordProductproduct external record
minimumOrderQuantityCountPurchaseOrderQuantityUnitproduct order quantity
externalIds.statusLastChangedDateLastChangeDateTimeproduct last changed date
modelYearFiscalYearCurrentPeriodproduct model year
revenueInstallmentPeriodPeriodTypeproduct period type
modelYearFiscalYearCurrentPeriodproduct model year
auditInfo.createdByCreatedByUserproduct Created by user
auditInfo.updatedByLastChangedByUserproduct last changed by user
auditInfo.createdDateCreationDateproduct creation date
quantityScheduleTypeStandardHandlingUnitTypeproduct quantity schedule
typeProductTypeproduct brand
glAccountCodeANPCodeproduct gl account code

(back to top)

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

HANACIMDescription
ProductproductIdproductId
IndustryStandardNamenameproduct name
ProductTypeMATProduct type default to MAT
GrossWeightcontainerSizeProduct Container Size
NetWeightnetWeightproduct net weight
CrossPlantConfigurableProduct""default to ""
ProductManufacturerNumber""default to ""
MaximumPackagingLength0.000default to 0.000
HasVariableTareWeightfalsedefault to false
ANPCode""default to ""
WeightUnitcontainerSizeUnitProduct container size unit
ProdNoInGenProdInPrepackProd""default to ""
CompetitorID""default to false
QualityInspectionGroup""default to ""
IsBatchManagementRequiredfalsedefault to false
IsRelevantForHzdsSubstancesfalsedefault to false
Division00default to 00
IndustrySectorMfalsedefault to M
ProductIsConfigurablefalsedefault to false
QltyMgmtInProcmtIsActivefalsedefault to false
MaximumPackagingHeightfalsedefault to false
BaseUnitcontainerTypeProduct container type
YY1_SME_UnvProductId_PRDexternalIdsproduct external id

(back to top)

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

HANACIMDescription
NALanguagedefault to 'EN'
IdProductproduct Id
nameProductDescriptiondescription of Product

(back to top)

updatePricingReq

Maps the CIM to SAP S/4HANA update product pricing

Source: ./src/main/resources/dwl/updatePricingReq.dwl

Mapping Tables

create Pricing request mapping.

cimHana Source fieldDescription of source field
ConditionRecordConditionRecordpricing condition
priceBookEntry.unitListPriceConditionRateValueproduct unit price
to_SlsPrcgConditionRecord.ConditionRateValueUnitConditionRateValueUnit""

(back to top)

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

SAPCIMDescription
ProductIdThe product Id
YY1_SME_UnvProductId_PRDexternalIdsExternal Unique Id
YY1_SME_PowSuppCon_RTL_PRDpowersupplyconnectedThe Product power supply
YY1_SME_PackSize_RTL_PRDpackSizeThe size of the product
YY1_SME_PackSizeUn_RTL_PRDpackSizeUnitProduct Unit
YY1_SME_KAM_Prod_RTL_PRDkamProductKam product id
YY1_SME_Prod_Code_RTL_PRDproductCodeProduct code
YY1_SME_Prod_Desc1_RTL_PRDdescriptionProduct description
YY1_SME_Prod_Desc2_RTL_PRDdescriptionProduct description
YY1_SME_HierarchID_RTL_PRDproductLevelProduct Level
YY1_SME_Asset_Temp_RTL_PRDassetTemplateProduct Template
YY1_SME_Prod_Temp_RTL_PRDtypeProduct Type
YY1_SME_Shrt_PCode_RTL_PRDproductShortCodeProduct Short Code
YY1_SME_Sell_Code_RTL_PRDsellInCodeProduct Sell in Code
YY1_SME_ProdForm_RTL_PRDproductFormThe product Form
YY1_SME_Flavor_RTL_PRDproductCategory.parentCategoryThe Product Category Level
YY1_SME_Brand_RTL_PRDproductCategory.parentCategoryThe Product Category Level
YY1_SME_Package_RTL_PRDproductCategory.parentCategoryThe Product Category Level
YY1_SME_Category_RTL_PRDproductCategory.parentCategoryThe Product Category Level
YY1_SME_Comp_Prod_RTL_PRDcompetitiveProductCompetitive Product
YY1_SME_EstimValue_RTL_PRDestimatedValueProduct estimated value

(back to top)

getProductResponse

Maps the SAP S/4HANA product to CIM response

Source: ./src/main/resources/dwl/getProductResponse.dwl

Mapping Tables

get Products response mapping.

CIMHANADescription of source field
nameIndustryStandardNameproduct name
longDescriptionProductDescriptionproduct item description
idProductproduct id
productStatusCrossPlantStatusproduct cross plant status
descriptionto_Descriptionproduct description
productSKUProductTypeproduct type
productLevelYY1_SME_HierarchID_RTL_PRDProduct Hierarchy
typeYY1_SME_Prod_Temp_RTL_PRDproduct type
productCodeYY1_SME_Prod_Code_RTL_PRDproduct code
productShortCodeYY1_SME_Shrt_PCode_RTL_PRDproduct short code
manufacturerNameIndustryStandardNameproduct manufacturer name
primaryProductCategoryYY1_SME_Package_RTL_PRDproduct primary category
masterProductProductGroupproduct master product
brandto_Description.ProductDescriptionproduct brand
kamProductYY1_SME_KAM_Prod_RTL_PRDproduct kam
competitiveProductYY1_SME_Comp_Prod_RTL_PRDproduct competitive
sellInCodeYY1_SME_Sell_Code_RTL_PRDproduct sell in code
packSizeYY1_SME_PackSize_RTL_PRDproduct pack size
packSizeUnitYY1_SME_PackSizeUn_RTL_PRDproduct pack size unit
assetTemplateYY1_SME_Asset_Temp_RTL_PRDproduct asset template
productFormYY1_SME_ProdForm_RTL_PRDproduct form
containerSizeGrossWeightproduct container size
containerSizeUnitWeightUnitproduct container size unit
containerTypeBaseUnitproduct container type
deliveryValidFromYY1_SME_DlvValFrom_RTL_PRDproduct delivery valid from
validToDateYY1_SME_FieldValTh_RTL_PRDproduct valid to date
validFromDateYY1_SME_FieldValFr_RTL_PRDproduct valid from date
deliveryValidThruYY1_SME_DlvValThru_RTL_PRDproduct delivery valid through
kamValidFromYY1_SME_KAMValFrom_RTL_PRDproduct kam valid from
kamValidThruYY1_SME_KAMValThru_RTL_PRDproduct kam valid through
fundValidFromYY1_SME_FundValiFr_RTL_PRDproduct fund valid from
newItemValidFromYY1_SME_NewItmVldF_RTL_PRDproduct new item valid from
newItemValidThruYY1_SME_NewItmVldT_RTL_PRDproduct new item valid through
fundValidThruYY1_SME_FundValiTh_RTL_PRDproduct fund valid through
estimatedValueYY1_SME_EstimValue_RTL_PRDproduct estimated value
manufacturerIndustryStandardNameproduct manufacturer
manufacturerItemNumberYY1_SME_ManItemNmb_RTL_PRDproduct item number
productTemplateYY1_SME_HierarchID_RTL_PRDproduct template
criterion1ProductProductproduct criterion
criterion1ProductDescriptionto_Description.ProductDescriptionproduct description
criterion2ProductProductproduct criterion
criterion2ProductDescriptionto_Description.ProductDescriptionproduct description
criterion3ProductProductproduct criterion
criterion3ProductDescriptionto_Description.ProductDescriptionproduct description
criterion4ProductProductproduct criterion
criterion4ProductDescriptionto_Description.ProductDescriptionproduct description
criterion5ProductProductproduct criterion
criterion5ProductDescriptionto_Description.ProductDescriptionproduct description
criterion6ProductProductproduct criterion
criterion6ProductDescriptionto_Description.ProductDescriptionproduct description
weightGrossWeightproduct weight
heightSizeOrDimensionTexproduct height
sizeSizeOrDimensionTextproduct size
volumeMaterialVolumeproduct volume
productCategory.idnullproductCategory default to null
productCategory.nameproductHierarchy.ParentNodeproduct name
productCategory.activeFromDateproductHierarchy.ProdHierarchyValidityStartDateproduct activeFromDate
productCategory.activeToDateproductHierarchy.ProdHierarchyValidityEndDateproduct activeToDate
parentCategoryproductLevelproduct level
productCatalog.idnullcatalog id default to null
productCatalog.nameproductHierarchy.ProdUnivHierarchyproduct catalog name
productCatalog.activeFromDateproductHierarchy.ProdHierarchyValidityStartDateproduct catalog active from date
productCatalog.activeToDateproductHierarchy.ProdHierarchyValidityEndDateproduct catalog active to date
priceBookEntry.id""price book entry default to ""
priceBookEntry.minRequiredQuantitypricingResponse.to_SlsPrcgConditionRecord.ConditionQuantityproduct pricing response
priceBookEntry.maxRequiredOrderValue0price book entry default to 0
priceBookEntry.unitListPricepricingResponse.to_SlsPrcgConditionRecord.ConditionRateValueproduct pricing response
priceBookEntry.priceListTypepricingResponse.YY1_SME_CondPriLiT_RTL_PCHproduct condition's PriceList Type
priceBookEntry.priceTypepricingResponse.YY1_SME_CondPriTyp_RTL_PCHproduct condition's Price Type
priceBookEntry.validFrompricingResponse.to_SlsPrcgConditionRecord.ConditionValidityStartDateproduct condition's validity start date
priceBookEntry.validThrupricingResponse.to_SlsPrcgConditionRecord.ConditionValidityEndDateproduct condition's validity end date
priceBookEntry.isActivetruepriceBookEntry default to true
auditInfo.isDeletedfalseauditInfo default to false
auditInfo.createdByCreatedByUserproduct created by
auditInfo.updatedByLastChangedByUserproduct updated by
auditInfo.updatedDateLastChangeDateTimeproduct updated date
auditInfo.createdDateCreationDateproduct creation date
externalIds.externalIdTypeMDMdefault to MDM
externalIds.externalIdYY1_SME_UnvProductId_PRDexternal id
externalIds.idnullexternalIds default to null
externalIds.statusVALIDexternalIds default to valid
externalIds.statusLastChangedOnnow()externalIds default to now()

(back to top)

getProductListResponsebyexternalId

Maps the SAP S/4HANA product to CIM response

Source: ./src/main/resources/dwl/getProductListResponsebyexternalId.dwl

Mapping Tables

get Products response mapping.

Resp FieldCoupa Source fieldDescription of source field
nameIndustryStandardNameproduct name
longDescriptionProductDescriptionproduct item description
idProductproduct id
descriptionto_Descriptionproduct description
productSKUProductTypeproduct type
validFromDateCreationDateproduct creation date
modelNumberexternalIdmaster product Id
maximumOrderQuantityCountPurchaseOrderQuantityUnitproduct quantity
manufacturerNameManufacturerNumberproduct manufacture number
versionNumberProductGroupproduct group
primaryProductCategoryProductGroupproduct category
brandGradeBrandproduct brand
mSRPAmountStandardPriceproduct price
externalSourceRecordProductproduct external record
minimumOrderQuantityCountPurchaseOrderQuantityUnitproduct order quantity
externalIds.statusLastChangedDateLastChangeDateTimeproduct last changed date
modelYearFiscalYearCurrentPeriodproduct model year
revenueInstallmentPeriodPeriodTypeproduct period type
modelYearFiscalYearCurrentPeriodproduct model year
auditInfo.createdByCreatedByUserproduct Created by user
auditInfo.updatedByLastChangedByUserproduct last changed by user
auditInfo.createdDateCreationDateproduct creation date
quantityScheduleTypeStandardHandlingUnitTypeproduct quantity schedule
typeProductTypeproduct brand
glAccountCodeANPCodeproduct gl account code

(back to top)

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

HANACIMDescription
ProductGroupproductLevelIf the Product Level is product "L001" else "L005"
ProductGroupproductLevelIf the Product Level is product "L001" else "L005"
Productidproduct id
IndustryStandardNamedescriptionproduct description
idProductproduct id
ProductStandardIDProductTypeproduct type
to_Valuation.Productidproduct Id
to_Valuation.StandardPricemSRPAmountstandard price
to_Valuation.PrevInvtryPriceInCoCodeCrcymSRPAmountproduct price
to_Valuation.PriceUnitQtyquantityThe quantity of the product default 1
to_Valuation.IsMarkedForDeletionfalsedefault to false
to_Valuation.MovingAveragePricemSRPAmountproduct mSRPAmount
to_Valuation.PlannedPricemSRPAmountThe product planned Price
to_Valuation.CurrencyUSDdefault 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.IsProducedInhousefalseThe product IsProducedInhouse default to false
to_Valuation.PlannedPrice1InCoCodeCrcymSRPAmountThe Product PlannedPrice Currency
to_Valuation.TaxBasedPricesPriceUnitQty0The product TaxBasedPricesPriceUnitQty default to 0
to_Valuation.ValuationArea1710The product ValuationArea default to 1710
to_Valuation.BaseUnit""The product BaseUnit default to ""
to_Valuation. ValuationClass3100The product class default to 3100
to_Valuation.ValuationCategory""The ValuationCategory default to ""
BrandbrandThe product Brand
ProductTypeMATThe ProductType default to MAT
to_Description.LanguageENLanguage default to EN(English)
to_Description.Productidproduct id
to_Description.ProductDescriptionnameproduct name
to_SalesDelivery.productIdproductId
to_SalesDelivery.ProductDescriptionchnl10The product description channel default to 10
to_SalesDelivery.ProductSalesOrg1710Sales org is default to 1710
to_SalesDelivery.ItemCategoryGroupNORMdefault to NORM
to_SalesDelivery.to_SalesTax.productIdproductId
to_SalesDelivery.to_SalesTax.CountryUSdefault to US
to_SalesDelivery.to_SalesTax.TaxCategoryUTXJdefault to UTXJ
to_SalesDelivery.to_SalesTax.TaxClassification1default to 1
to_Plant.productIdproductId
to_Plant.Plant1710default to 1710
to_Plant.PurchasingGroup002default to 002
to_Plant.PeriodTypeMdefault to M
to_Plant.ProfitCenterYB700default to YB700
to_Plant.MaintenanceStatusNameBEVDLPdefault to BEVDLP
to_Plant.IsMarkedForDeletionfalsedefault to False
to_Plant.ProcurementTypeFdefault to F
to_Plant.MRPTypeNDdefault to ND
to_Plant.MRPResponsible001default to 001
to_Plant.to_PlantSales.ProductIdproductId
to_Plant.to_PlantSales.Plant1710default to 1710
to_Plant.to_PlantSales.LoadingGroup0001default to 0001
to_Plant.to_PlantSales.AvailabilityCheckTypeSPdefault to SP
GrossWeightcontainerSizeproduct grossWeight
NetWeight0default to 0
SizeOrDimensionTextsizesize of the product
CrossPlantConfigurableProduct""default to ""
ProductManufacturerNumber""default to ""
MaximumPackagingLength0.000default to 0.000
HasVariableTareWeightfalsedefault to false
ANPCode""default to ""
WeightUnitcontainerSizeUnitcontainerSize
ProdNoInGenProdInPrepackProd""default to ""
IsMarkedForDeletionfalsedefault to False
CompetitorID""default to ""
QualityInspectionGroup""default to ""
IsBatchManagementRequiredFalsedefault to false
IsRelevantForHzdsSubstancesFalsedefault to False
Division00default to 00
IndustrySectorMdefault to m
ProductIsConfigurableFalsedefault to false
QltyMgmtInProcmtIsActivfalsedefault to False
MaximumPackagingHeight0.000The maximum product height default to 0.000
BaseUnitcontainerTypeThe product container Type
YY1_SME_UnvProductId_PRDexternalIdproduct externalId
YY1_SME_FieldValFr_RTL_PRDvalidFromDateThe product valid From Date
YY1_SME_PowSuppCon_RTL_PRDpowersupplyconnectedThe product productpowersupply
YY1_SME_PackSize_RTL_PRDpackSizeproduct package size
YY1_SME_PackSizeUn_RTL_PRDpackSizeUnitThe product package size
YY1_SME_KAM_Prod_RTL_PRDkamProductThe productkam code
YY1_SME_Prod_Code_RTL_PRDproductCodeThe product code
YY1_SME_Prod_Desc1_RTL_PRDdescriptionProductDescription
YY1_SME_Prod_Desc2_RTL_PRDdescriptionProductDescription
YY1_SME_HierarchID_RTL_PRDproductLevellevel of the product
YY1_SME_Asset_Temp_RTL_PRDassetTemplateproduct template
YY1_SME_Prod_Temp_RTL_PRDtypeProductType
YY1_SME_Shrt_PCode_RTL_PRDproductShortCodeproduct Short Code
YY1_SME_Sell_Code_RTL_PRDsellInCodeproduct sell in code
YY1_SME_ProdForm_RTL_PRDproductFormproductForm
YY1_SME_Flavor_RTL_PRDproductCategory.parentCategoryproductCategory
YY1_SME_Brand_RTL_PRDproductCategory.parentCategoryproductCategory
YY1_SME_Package_RTL_PRDproductCategory.parentCategoryThe product Category
YY1_SME_SubCategor_RTL_PRDproductCategory.parentCategoryThe product productCategory
YY1_SME_Category_RTL_PRDproductCategory.parentCategorythe productCategory
YY1_SME_Comp_Prod_RTL_PRDcompetitiveProductThe competitiveProduct
YY1_SME_ManItemNmb_RTL_PRDmanufacturerItemNumberThe Product Manufacture number
YY1_SME_EstimValue_RTL_PRDestimatedValueThe product estimatedValue

(back to top)

createProductsResponse

Maps the SAP S/4HANA to CIM response

Source: ./src/main/resources/dwl/createProductsResponse.dwl

Mapping Tables

create Product response mapping.

Resp FieldCoupa Source fieldDescription of source field
responseStatussuccessfulproduct response status
resultMessages.severityitems.successfulproduct severity
resultMessages.messageitems.successfulproduct message
parameters.paramValueIdproduct paramValue

(back to top)


Reviews

TypeTemplate
OrganizationMuleSoft
Published by
MuleSoft Solutions
Published onOct 3, 2023
Asset overview

Asset versions for 2.6.x

Asset versions
VersionActions
2.6.4
2.6.2
2.6.1
2.6.0