P_ProductSalesDeliveryWD

Union | view: PPRDSALESDELIVWD | Extraction: Not supported | Component: Material Master
Tables used: SDRAFT_ADMIN, MARA, USR21, MARA, MVKE, PRD_ROOT, PRD_SALES_DEL
Column Name Description
Draftkey UUID in X form (binary)
ActiveProduct FK Product Number
ActiveProductSalesOrg FK Sales Organization
ActiveProductDistributionChnl FK Distribution Channel
Column Name Description
Column Name Description
MinimumOrderQuantity Minimum order quantity in base unit of measure
DeliveryNoteProcMinDelivQty Minimum Delivery Quantity in Delivery Note Processing
MinimumMakeToOrderOrderQty Minimum make-to-order quantity
MaxDeliveryQtyStoreOrder Maximum delivery quantity in store order processing
📏 Unit of measure of delivery unit (DeliveryQuantityUnit):
DeliveryQuantity Delivery unit
Column Name Description
ProductSalesStatusValidityDate Date from which distr.-chain-spec. material status is valid
StoreListingStartDate Date from which listed in the store
StoreListingEndDate Date to which listed in the store
DistrCntrListingStartDate Date from which listed in the distribution center
DistrCntrListingEndDate Date to which listed in the central warehouse/distr. center
StoreSaleStartDate Date from which sold in the store
StoreSaleEndDate Date to which sold in the store
DistrCntrSaleStartDate Date from which sold in the distribution center
DistrCntrSaleEndDate Date to which sold in the distribution center
Column Name Description
IsMarkedForDeletion Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
CashDiscountIsDeductible Cash Discount Indicator Show values
PriceFixingCategory Indicator for price fixing Show values
VariableSalesUnitIsNotAllowed Variable Sales Unit Not Allowed Show values
CompetitionPressureCategory Competition characterization of a material 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
DraftAdministrativeDataUUID UUID in X form (binary) SYSUUID
Master Data Relations Join Conditions
Account assignment group for the material
  • Account Assignment Group for Material
  • Client
  • P_PRODUCTSALESDELIVERYWD.ACCOUNTDETNPRODUCTGROUP == TVKM.KTGRM
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVKM.MANDT
Material No.
  • Product Number
  • Product Number
  • Client
  • P_PRODUCTSALESDELIVERYWD.ACTIVEPRODUCT == MARA.MATNR
  • P_PRODUCTSALESDELIVERYWD.PRODUCT == MARA.MATNR
  • P_PRODUCTSALESDELIVERYWD.MANDT == MARA.MANDT
Distribution channel
  • Client
  • Distribution Channel
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVTW.MANDT
  • P_PRODUCTSALESDELIVERYWD.ACTIVEPRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
Sales organization
  • Client
  • Sales Organization
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVKO.MANDT
  • P_PRODUCTSALESDELIVERYWD.ACTIVEPRODUCTSALESORG == TVKO.VKORG
Assortment grade
  • Client
  • Assortment grade
  • P_PRODUCTSALESDELIVERYWD.MANDT == TWSS.MANDT
  • P_PRODUCTSALESDELIVERYWD.ASSORTMENTGRADE == TWSS.SSTUF
Unit of measure
  • Client
  • Unit of measure of delivery unit
  • P_PRODUCTSALESDELIVERYWD.MANDT == T006.MANDT
  • P_PRODUCTSALESDELIVERYWD.DELIVERYQUANTITYUNIT == T006.MSEHI
Listing procedure for distr. center assortment categories
  • Client
  • Listing procedure for distr. center assortment categories
  • P_PRODUCTSALESDELIVERYWD.MANDT == TWLV.MANDT
  • P_PRODUCTSALESDELIVERYWD.DISTRCNTRLISTINGPROCEDURE == TWLV.LSTFL
Product Group 5
  • Client
  • Product Group 5
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVM5.MANDT
  • P_PRODUCTSALESDELIVERYWD.FIFTHSALESSPECPRODUCTGROUP == TVM5.MVGR5
Product Group 1
  • Product Group 1
  • Client
  • P_PRODUCTSALESDELIVERYWD.FIRSTSALESSPECPRODUCTGROUP == TVM1.MVGR1
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVM1.MANDT
Product Group 4
  • Product Group 4
  • Client
  • P_PRODUCTSALESDELIVERYWD.FOURTHSALESSPECPRODUCTGROUP == TVM4.MVGR4
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVM4.MANDT
Item category group
  • Client
  • Item Category Group from Material Master
  • P_PRODUCTSALESDELIVERYWD.MANDT == TPTM.MANDT
  • P_PRODUCTSALESDELIVERYWD.ITEMCATEGORYGROUP == TPTM.MTPOS
Shipping statistics group
  • Client
  • Material statistics group
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVSM.MANDT
  • P_PRODUCTSALESDELIVERYWD.LOGISTICSSTATISTICSGROUP == TVSM.STGMA
Condition group
  • Product Pricing Group
  • Client
  • P_PRODUCTSALESDELIVERYWD.PRICESPECIFICATIONPRODUCTGROUP == T178.KONDM
  • P_PRODUCTSALESDELIVERYWD.MANDT == T178.MANDT
Price group
  • Client
  • Pricing Reference Material
  • P_PRODUCTSALESDELIVERYWD.MANDT == MARA.MANDT
  • P_PRODUCTSALESDELIVERYWD.PRICINGREFERENCEPRODUCT == MARA.MATNR
Material No.
  • Product Number
  • Product Number
  • Client
  • P_PRODUCTSALESDELIVERYWD.ACTIVEPRODUCT == MARA.MATNR
  • P_PRODUCTSALESDELIVERYWD.PRODUCT == MARA.MATNR
  • P_PRODUCTSALESDELIVERYWD.MANDT == MARA.MANDT
Commission group
  • Client
  • Commission Group
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVPR.MANDT
  • P_PRODUCTSALESDELIVERYWD.PRODUCTCOMMISSIONGROUP == TVPR.PROVG
Product hierarchy
  • Client
  • Product hierarchy
  • P_PRODUCTSALESDELIVERYWD.MANDT == T179.MANDT
  • P_PRODUCTSALESDELIVERYWD.PRODUCTHIERARCHY == T179.PRODH
Material status for sales
  • Client
  • Distribution-chain-specific material status
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVMS.MANDT
  • P_PRODUCTSALESDELIVERYWD.PRODUCTSALESSTATUS == TVMS.VMSTA
Rounding profile
  • Rounding Profile
  • Delivering Plant (Own or External)
  • Client
  • ?
  • P_PRODUCTSALESDELIVERYWD.ROUNDINGPROFILE == RDPR.RDPRF
  • P_PRODUCTSALESDELIVERYWD.SUPPLYINGPLANT == RDPR.WERKS
  • P_PRODUCTSALESDELIVERYWD.MANDT == RDPR.MANDT
  • P_PRODUCTSALESDELIVERYWD.[column in domain "RDZAE"] == RDPR.RDZAE
Unit of measure
  • Sales unit
  • Client
  • P_PRODUCTSALESDELIVERYWD.SALESMEASUREUNIT == T006.MSEHI
  • P_PRODUCTSALESDELIVERYWD.MANDT == T006.MANDT
Product Group 2
  • Client
  • Product Group 2
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVM2.MANDT
  • P_PRODUCTSALESDELIVERYWD.SECONDSALESSPECPRODUCTGROUP == TVM2.MVGR2
Listing procedure for store or other assortment categories
  • Client
  • Listing procedure for store or other assortment categories
  • P_PRODUCTSALESDELIVERYWD.MANDT == TWLV.MANDT
  • P_PRODUCTSALESDELIVERYWD.STORELISTINGPROCEDURE == TWLV.LSTFL
Default plant
  • Delivering Plant (Own or External)
  • Client
  • Distribution Channel
  • Sales Organization
  • P_PRODUCTSALESDELIVERYWD.SUPPLYINGPLANT == TVKWZ.WERKS
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVKWZ.MANDT
  • P_PRODUCTSALESDELIVERYWD.ACTIVEPRODUCTDISTRIBUTIONCHNL == TVKWZ.VTWEG
  • P_PRODUCTSALESDELIVERYWD.ACTIVEPRODUCTSALESORG == TVKWZ.VKORG
Product Group 3
  • Client
  • Product Group 3
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVM3.MANDT
  • P_PRODUCTSALESDELIVERYWD.THIRDSALESSPECPRODUCTGROUP == TVM3.MVGR3
Volume rebate group
  • Volume rebate group
  • Client
  • P_PRODUCTSALESDELIVERYWD.VOLUMEREBATEGROUP == TVBO.BONUS
  • P_PRODUCTSALESDELIVERYWD.MANDT == TVBO.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Units of measure group
  • Client
  • Unit of Measure Group
  • ?
  • P_PRODUCTSALESDELIVERYWD.MANDT == TWMEG.MANDT
  • P_PRODUCTSALESDELIVERYWD.PRODUCTUNITGROUP == TWMEG.MEGRU
  • P_PRODUCTSALESDELIVERYWD.[column in domain "LRMEI"] == TWMEG.MEINS