C_Productsales

Product Master Sales | view: CPRDSALESWD | Extraction: Not supported | Component: Material Master

Tables used: MAW1, MARA

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

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
DistrCntrSaleStartDate	Date from which sold in the distribution center
DistrCntrSaleEndDate	Date to which sold in the distribution center
StoreSaleStartDate	Date from which sold in the store
StoreSaleEndDate	Date to which sold in the store

Column Name	Description
VariantsPricingProfile	Pricing profile for variants	Show values
IsVariantPriceAllowed	Variant Price Allowed (for Material Master)	Show values
IsClosedPackagingMaterial	Packaging Material is Closed Packaging	Show values
ContractAutoRenewalType	Contract Auto Renewal Indicator	Show values

Column Name	Description	Domain name
AuthorizationGroup	Authorization Group	BEGRU
ExcessWeightTolerance	Excess Weight Tolerance for Handling unit	PRZ21
ExcessVolumeTolerance	Excess Volume Tolerance of the Handling Unit	PRZ21
StackingFactor	Stacking factor	INT2
VolumeMaximumLevel	Maximum level (by volume)	DEC3

Master Data Relations	Join Conditions
Unit of Volume for Allowed Packaging Weight Client Volume unit (allowed packaging volume)	`C_PRODUCTSALES.MANDT == T006.MANDT` `C_PRODUCTSALES.ALLOWEDPACKAGINGVOLUMEQTYUNIT == T006.MSEHI`
Unit of Weight for Allowed Packaging Weight Client Unit of weight (allowed packaging weight)	`C_PRODUCTSALES.MANDT == T006.MANDT` `C_PRODUCTSALES.ALLOWEDPACKAGINGWEIGHTQTYUNIT == T006.MSEHI`
Billing Cycle Billing Cycle Client	`C_PRODUCTSALES.CABILLGCYCLE == TFK2607.CYCLE` `C_PRODUCTSALES.MANDT == TFK2607.MANDT`
Loading Group Loading Group Client	`C_PRODUCTSALES.LOADINGGROUP == TLGR.LADGR` `C_PRODUCTSALES.MANDT == TLGR.MANDT`
Packaging Material Type Packaging Material Type Client	`C_PRODUCTSALES.PACKAGINGMATERIALTYPE == TVTY.TRATY` `C_PRODUCTSALES.MANDT == TVTY.MANDT`
Pricing Reference Material Client Pricing Reference Material	`C_PRODUCTSALES.MANDT == MARA.MANDT` `C_PRODUCTSALES.PRICINGREFERENCEPRODUCT == MARA.MATNR`
Response Profile Client Response Profile	`C_PRODUCTSALES.MANDT == CRMD_ESCAL.CLIENT` `C_PRODUCTSALES.RESPONSEPROFILE == CRMD_ESCAL.SRV_ESCAL`
Cross-distribution-chain material status Client Cross-distribution-chain material status	`C_PRODUCTSALES.MANDT == TVMS.MANDT` `C_PRODUCTSALES.SALESSTATUS == TVMS.VMSTA`
Unit for Duration of Work Client Unit for Duration of Work	`C_PRODUCTSALES.MANDT == T006.MANDT` `C_PRODUCTSALES.SERVICEDURATIONUNIT == T006.MSEHI`
Service Profile Service Profile Client	`C_PRODUCTSALES.SERVICEPROFILE == CRMD_SERWI.SRV_SERWI` `C_PRODUCTSALES.MANDT == CRMD_SERWI.CLIENT`
Billing Cycle Determination Rule ID Client Billing Cycle Determination Rule ID	`C_PRODUCTSALES.MANDT == CRMC_ISX_BCDETR.CLIENT` `C_PRODUCTSALES.SUBSCRPNPRODBILLGCYCDETN == CRMC_ISX_BCDETR.RULE_ID`
Tax classification of the material ? Tax classification of the material Client	`C_PRODUCTSALES.[column in domain "TATYP"] == TSKM.TATYP` `C_PRODUCTSALES.TAXCLASSIFICATION == TSKM.TAXKM` `C_PRODUCTSALES.MANDT == TSKM.MANDT`
Carr. Group Transportation Group Client	`C_PRODUCTSALES.TRANSPORTATIONGROUP == TTGR.TRAGR` `C_PRODUCTSALES.MANDT == TTGR.MANDT`