P_Productsalesdeliveryposwd

Product Sales Delivery POS union(draft) | view: PRDSTORAGELOCWD | Extraction: Not supported | Component: Material Master
Column Name Description
Draftkey UUID in X form (binary)
ActiveProduct FK Material Number
ActivePlant FK Retail plant
ActiveProductSalesOrg FK Sales organization in distribution chain, IS-R
ActiveProductDistributionChnl FK Distribution channel in distribution chain, IS-R
Column Name Description
Column Name Description
Column Name Description
StoreSaleStartDate Date from which sold in the store
StoreSaleEndDate Date to which sold in the store
ProductSalesStatusValidityDate Date from which distr.-chain-spec. material status is valid
Column Name Description
IsPointOfSalesDiscountAllowed Discount allowed 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
RootDraftKey UUID in X form (binary) SYSUUID
DraftAdministrativeDataUUID UUID in X form (binary) SYSUUID
Master Data Relations Join Conditions
Retail plant
  • Retail plant
  • Retail plant
  • Client
  • P_PRODUCTSALESDELIVERYPOSWD.PLANT == T001W.WERKS
  • P_PRODUCTSALESDELIVERYPOSWD.ACTIVEPLANT == T001W.WERKS
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • Material Number
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == MARA.MANDT
  • P_PRODUCTSALESDELIVERYPOSWD.PRODUCT == MARA.MATNR
  • P_PRODUCTSALESDELIVERYPOSWD.ACTIVEPRODUCT == MARA.MATNR
Distribution channel in distribution chain, IS-R
  • Client
  • Distribution channel in distribution chain, IS-R
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == TVTW.MANDT
  • P_PRODUCTSALESDELIVERYPOSWD.ACTIVEPRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG
Sales organization in distribution chain, IS-R
  • Client
  • Sales organization in distribution chain, IS-R
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == TVKO.MANDT
  • P_PRODUCTSALESDELIVERYPOSWD.ACTIVEPRODUCTSALESORG == TVKO.VKORG
Retail plant
  • Retail plant
  • Retail plant
  • Client
  • P_PRODUCTSALESDELIVERYPOSWD.PLANT == T001W.WERKS
  • P_PRODUCTSALESDELIVERYPOSWD.ACTIVEPLANT == T001W.WERKS
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == T001W.MANDT
Material Number
  • Client
  • Material Number
  • Material Number
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == MARA.MANDT
  • P_PRODUCTSALESDELIVERYPOSWD.PRODUCT == MARA.MATNR
  • P_PRODUCTSALESDELIVERYPOSWD.ACTIVEPRODUCT == MARA.MATNR
Distribution-chain-specific material status
  • Client
  • Distribution-chain-specific material status
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == TVMS.MANDT
  • P_PRODUCTSALESDELIVERYPOSWD.PRODUCTSALESSTATUS == TVMS.VMSTA
Foreign key for scales group
  • Scales group
  • Client
  • P_PRODUCTSALESDELIVERYPOSWD.SCALESGROUP == TWWAG.SCAGR
  • P_PRODUCTSALESDELIVERYPOSWD.MANDT == TWWAG.MANDT