C_Productsalesdeliverypos

Consumption - Product Sales delivery POS | view: CPRDSALESDELPOS | Extraction: Not supported | Component: Material Master

Tables used: WLK2

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (3)
☰ Categorical (3)
Other
🔗 Relations (9)

Column Name	Description
Product FK	Material Number
ProductSalesOrg FK	Sales organization in distribution chain, IS-R
ProductDistributionChnl FK	Distribution channel in distribution chain, IS-R
Plant FK	Retail plant

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
ProdSlsDelivPOSIsPriceRequired	Price required	Show values
ProdSlsDelivRepeatKey	No repeat key	Show values

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Retail plant Client Retail plant Retail plant	`C_PRODUCTSALESDELIVERYPOS.MANDT == T001W.MANDT` `C_PRODUCTSALESDELIVERYPOS.PLANT == T001W.WERKS` `C_PRODUCTSALESDELIVERYPOS.PLANTFOREDIT == T001W.WERKS`
Retail plant Client Retail plant Retail plant	`C_PRODUCTSALESDELIVERYPOS.MANDT == T001W.MANDT` `C_PRODUCTSALESDELIVERYPOS.PLANT == T001W.WERKS` `C_PRODUCTSALESDELIVERYPOS.PLANTFOREDIT == T001W.WERKS`
Material Number Client Material Number	`C_PRODUCTSALESDELIVERYPOS.MANDT == MARA.MANDT` `C_PRODUCTSALESDELIVERYPOS.PRODUCT == MARA.MATNR`
Distribution channel in distribution chain, IS-R Client Distribution channel in distribution chain, IS-R Distribution channel in distribution chain, IS-R	`C_PRODUCTSALESDELIVERYPOS.MANDT == TVTW.MANDT` `C_PRODUCTSALESDELIVERYPOS.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG` `C_PRODUCTSALESDELIVERYPOS.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVTW.VTWEG`
Distribution channel in distribution chain, IS-R Client Distribution channel in distribution chain, IS-R Distribution channel in distribution chain, IS-R	`C_PRODUCTSALESDELIVERYPOS.MANDT == TVTW.MANDT` `C_PRODUCTSALESDELIVERYPOS.PRODUCTDISTRIBUTIONCHNL == TVTW.VTWEG` `C_PRODUCTSALESDELIVERYPOS.PRODUCTDISTRIBUTIONCHNLFOREDIT == TVTW.VTWEG`
Sales organization in distribution chain, IS-R Client Sales organization in distribution chain, IS-R Sales organization in distribution chain, IS-R	`C_PRODUCTSALESDELIVERYPOS.MANDT == TVKO.MANDT` `C_PRODUCTSALESDELIVERYPOS.PRODUCTSALESORGFOREDIT == TVKO.VKORG` `C_PRODUCTSALESDELIVERYPOS.PRODUCTSALESORG == TVKO.VKORG`
Sales organization in distribution chain, IS-R Client Sales organization in distribution chain, IS-R Sales organization in distribution chain, IS-R	`C_PRODUCTSALESDELIVERYPOS.MANDT == TVKO.MANDT` `C_PRODUCTSALESDELIVERYPOS.PRODUCTSALESORGFOREDIT == TVKO.VKORG` `C_PRODUCTSALESDELIVERYPOS.PRODUCTSALESORG == TVKO.VKORG`
Distribution-chain-specific material status Client Distribution-chain-specific material status	`C_PRODUCTSALESDELIVERYPOS.MANDT == TVMS.MANDT` `C_PRODUCTSALESDELIVERYPOS.PRODUCTSALESSTATUS == TVMS.VMSTA`
Foreign key for scales group Client Scales group	`C_PRODUCTSALESDELIVERYPOS.MANDT == TWWAG.MANDT` `C_PRODUCTSALESDELIVERYPOS.SCALESGROUP == TWWAG.SCAGR`