I_ProductSalesWD

Product BO - Sales Node (draft) | view: IPRDSALESWD | TRAN | Extraction: Not supported | Component: Material Master
Tables used: MAW1MARA
Column Name Description
Product Material Number
Column Name Description
Column Name Description
📏 Unit of weight (allowed packaging weight) (AllowedPackagingWeightQtyUnit):
AllowedPackagingWeightQty Allowed packaging weight
📏 Volume unit (allowed packaging volume) (AllowedPackagingVolumeQtyUnit):
AllowedPackagingVolumeQty Allowed packaging volume
📏 Unit for Duration of Work (ServiceDurationUnit):
ServiceDuration Duration of Work
Column Name Description
SalesStatusValidityDate Date from which the X-distr.-chain Product status is valid
StoreSaleEndDate Date to which sold in the store
DistrCntrSaleEndDate Date to which sold in the distribution center
StoreSaleStartDate Date from which sold in the store
DistrCntrSaleStartDate Date from which sold in the distribution center
Column Name Description
VariantsPricingProfile Pricing profile for variants Show values
IsVariantPriceAllowed Variant Price Allowed (for Material Master) Show values
IsClosedPackagingMaterial Packaging Material is Closed Packaging Show values
ContractAutoRenewalType Contract Auto Renewal Indicator Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BEGRU
ExcessWeightTolerance Excess Weight Tolerance for Handling unit PRZ21
ExcessVolumeTolerance Excess Volume Tolerance of the Handling Unit PRZ21
StackingFactor Stacking factor INT2
VolumeMaximumLevel Maximum level (by volume) DEC3
Master Data Relations Join Conditions
Unit of Volume for Allowed Packaging Weight
  • Volume unit (allowed packaging volume)
  • Client
  • I_PRODUCTSALESWD.ALLOWEDPACKAGINGVOLUMEQTYUNIT == T006.MSEHI
  • I_PRODUCTSALESWD.MANDT == T006.MANDT
Unit of Weight for Allowed Packaging Weight
  • Unit of weight (allowed packaging weight)
  • Client
  • I_PRODUCTSALESWD.ALLOWEDPACKAGINGWEIGHTQTYUNIT == T006.MSEHI
  • I_PRODUCTSALESWD.MANDT == T006.MANDT
Billing Cycle
  • Client
  • Billing Cycle
  • I_PRODUCTSALESWD.MANDT == TFK2607.MANDT
  • I_PRODUCTSALESWD.CABILLGCYCLE == TFK2607.CYCLE
Loading Group
  • Client
  • Loading Group
  • I_PRODUCTSALESWD.MANDT == TLGR.MANDT
  • I_PRODUCTSALESWD.LOADINGGROUP == TLGR.LADGR
Packaging Material Type
  • Client
  • Packaging Material Type
  • I_PRODUCTSALESWD.MANDT == TVTY.MANDT
  • I_PRODUCTSALESWD.PACKAGINGMATERIALTYPE == TVTY.TRATY
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • I_PRODUCTSALESWD.MANDT == MARA.MANDT
  • I_PRODUCTSALESWD.PRICINGREFERENCEPRODUCT == MARA.MATNR
Response Profile
  • Client
  • Response Profile
  • I_PRODUCTSALESWD.MANDT == CRMD_ESCAL.CLIENT
  • I_PRODUCTSALESWD.RESPONSEPROFILE == CRMD_ESCAL.SRV_ESCAL
Cross-distribution-chain material status
  • Client
  • Cross-distribution-chain material status
  • I_PRODUCTSALESWD.MANDT == TVMS.MANDT
  • I_PRODUCTSALESWD.SALESSTATUS == TVMS.VMSTA
Unit for Duration of Work
  • Client
  • Unit for Duration of Work
  • I_PRODUCTSALESWD.MANDT == T006.MANDT
  • I_PRODUCTSALESWD.SERVICEDURATIONUNIT == T006.MSEHI
Service Profile
  • Client
  • Service Profile
  • I_PRODUCTSALESWD.MANDT == CRMD_SERWI.CLIENT
  • I_PRODUCTSALESWD.SERVICEPROFILE == CRMD_SERWI.SRV_SERWI
Billing Cycle Determination Rule ID
  • Client
  • Billing Cycle Determination Rule ID
Assignment Schema
  • Assignment Schema
  • Client
Tax classification of the material
  • Tax classification of the material
  • Client
  • ?
  • I_PRODUCTSALESWD.TAXCLASSIFICATION == TSKM.TAXKM
  • I_PRODUCTSALESWD.MANDT == TSKM.MANDT
  • I_PRODUCTSALESWD.[column in domain "TATYP"] == TSKM.TATYP
Carr. Group
  • Transportation Group
  • Client
  • I_PRODUCTSALESWD.TRANSPORTATIONGROUP == TTGR.TRAGR
  • I_PRODUCTSALESWD.MANDT == TTGR.MANDT