I_ProductSales

Product Sales | view: IPRDSALES | ATTR | Extraction: Full or Incremental | 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
Column Name Description
VariantsPricingProfile Pricing profile for variants Show values
IsVariantPriceAllowed Variant Price Allowed (for Material Master) Show values
IsActiveEntity Draft - Indicator - Is active document Show values
IsClosedPackagingMaterial Packaging Material is Closed Packaging Show values
ContractAutoRenewalType Contract Auto Renewal Indicator Show values
Column Name Description Domain name
ExcessWeightTolerance Excess Weight Tolerance for Handling unit PRZ21
ExcessVolumeTolerance Excess Volume Tolerance of the Handling Unit PRZ21
VolumeMaximumLevel Maximum level (by volume) DEC3
AuthorizationGroup Authorization Group BEGRU
StackingFactor Stacking factor INT2
Master Data Relations Join Conditions
Unit of Volume for Allowed Packaging Weight
  • Volume unit (allowed packaging volume)
  • Client
  • I_PRODUCTSALES.ALLOWEDPACKAGINGVOLUMEQTYUNIT == T006.MSEHI
  • I_PRODUCTSALES.MANDT == T006.MANDT
Unit of Weight for Allowed Packaging Weight
  • Unit of weight (allowed packaging weight)
  • Client
  • I_PRODUCTSALES.ALLOWEDPACKAGINGWEIGHTQTYUNIT == T006.MSEHI
  • I_PRODUCTSALES.MANDT == T006.MANDT
Billing Cycle
  • Billing Cycle
  • Client
  • I_PRODUCTSALES.CABILLGCYCLE == TFK2607.CYCLE
  • I_PRODUCTSALES.MANDT == TFK2607.MANDT
Loading Group
  • Loading Group
  • Client
  • I_PRODUCTSALES.LOADINGGROUP == TLGR.LADGR
  • I_PRODUCTSALES.MANDT == TLGR.MANDT
Material freight group
  • Client
  • Material freight group
  • I_PRODUCTSALES.MANDT == TMFG.MANDT
  • I_PRODUCTSALES.MATERIALFREIGHTGROUP == TMFG.MFRGR
Packaging Material Type
  • Packaging Material Type
  • Client
  • I_PRODUCTSALES.PACKAGINGMATERIALTYPE == TVTY.TRATY
  • I_PRODUCTSALES.MANDT == TVTY.MANDT
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • I_PRODUCTSALES.PRICINGREFERENCEPRODUCT == MARA.MATNR
  • I_PRODUCTSALES.MANDT == MARA.MANDT
Response Profile
  • Response Profile
  • Client
Cross-distribution-chain material status
  • Cross-distribution-chain material status
  • Client
  • I_PRODUCTSALES.SALESSTATUS == TVMS.VMSTA
  • I_PRODUCTSALES.MANDT == TVMS.MANDT
Unit for Duration of Work
  • Unit for Duration of Work
  • Client
  • I_PRODUCTSALES.SERVICEDURATIONUNIT == T006.MSEHI
  • I_PRODUCTSALES.MANDT == T006.MANDT
Service Profile
  • Service Profile
  • Client
Billing Cycle Determination Rule ID
  • Billing Cycle Determination Rule ID
  • Client
Assignment Schema
  • Client
  • Assignment Schema
Tax classification of the material
  • ?
  • Tax classification of the material
  • Client
  • I_PRODUCTSALES.[column in domain "TATYP"] == TSKM.TATYP
  • I_PRODUCTSALES.TAXCLASSIFICATION == TSKM.TAXKM
  • I_PRODUCTSALES.MANDT == TSKM.MANDT
Carr. Group
  • Transportation Group
  • Client
  • I_PRODUCTSALES.TRANSPORTATIONGROUP == TTGR.TRAGR
  • I_PRODUCTSALES.MANDT == TTGR.MANDT