P_ProductSalesWD

Union | view: PPRDSALESWD | Extraction: Not supported | Component: Material Master
Tables used: SDRAFT_ADMINUSR21MAW1MARAPRD_ROOTPRD_SALES
Column Name Description
Draftkey UUID in X form (binary)
ActiveProduct 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
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 Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasActiveEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
HasDraftEntity Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
ParentDraftKey UUID in X form (binary) SYSUUID
Product Material Number MATNR
DraftAdministrativeDataUUID UUID in X form (binary) SYSUUID
Master Data Relations Join Conditions
Unit of Volume for Allowed Packaging Weight
  • Client
  • Volume unit (allowed packaging volume)
  • P_PRODUCTSALESWD.MANDT == T006.MANDT
  • P_PRODUCTSALESWD.ALLOWEDPACKAGINGVOLUMEQTYUNIT == T006.MSEHI
Unit of Weight for Allowed Packaging Weight
  • Client
  • Unit of weight (allowed packaging weight)
  • P_PRODUCTSALESWD.MANDT == T006.MANDT
  • P_PRODUCTSALESWD.ALLOWEDPACKAGINGWEIGHTQTYUNIT == T006.MSEHI
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • P_PRODUCTSALESWD.MANDT == MARA.MANDT
  • P_PRODUCTSALESWD.PRICINGREFERENCEPRODUCT == MARA.MATNR
Cross-distribution-chain material status
  • Client
  • Cross-distribution-chain material status
  • P_PRODUCTSALESWD.MANDT == TVMS.MANDT
  • P_PRODUCTSALESWD.SALESSTATUS == TVMS.VMSTA
Tax classification of the material
  • Client
  • ?
  • Tax classification of the material
  • P_PRODUCTSALESWD.MANDT == TSKM.MANDT
  • P_PRODUCTSALESWD.[column in domain "TATYP"] == TSKM.TATYP
  • P_PRODUCTSALESWD.TAXCLASSIFICATION == TSKM.TAXKM
Carr. Group
  • Client
  • Transportation Group
  • P_PRODUCTSALESWD.MANDT == TTGR.MANDT
  • P_PRODUCTSALESWD.TRANSPORTATIONGROUP == TTGR.TRAGR