C_CustomerMaterial_F2499

Customer Material | view: CSDCUSTMATF2499 | Extraction: Not supported | Component: Customer Material Information
Tables used: ADCP, ADRC, ADR6, ADR2, BUT000, KNA1, KNMT, CVI_CUST_LINK, MARA, MAKT, TVKO, TVKOT
Column Name Description
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Customer FK Customer number
Material FK Product Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (BaseUnit):
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
Column Name Description
Column Name Description
CustMatlAddrDepdntInfoIsHidden Truth Value: True/False Show values
PartialDeliveryIsAllowed Partial delivery at item level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
SalesOrganizationName Sales Organization Description TEXT20
MaterialByCustomer Material Number Used by Customer
MaterialName Material Description TEXT40
MaterialByCustomerForEdit Material Number Used by Customer
MaterialDescriptionByCustomer Customer Description of Material TEXT40
CustomerName Name of Customer TEXT80
SortField ETag CHAR10
Plant Plant (Own or External) WERKS
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
MaxNmbrOfPartialDelivery Maximum Number of Partial Deliveries Allowed Per Item ANTLF
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
SalesQtyToBaseQtyDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
SalesQtyToBaseQtyNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_CUSTOMERMATERIAL_F2499.BASEUNIT == T006.MSEHI
  • C_CUSTOMERMATERIAL_F2499.MANDT == T006.MANDT
Customer number
  • Client
  • Customer number
  • Customer number
  • C_CUSTOMERMATERIAL_F2499.MANDT == KNA1.MANDT
  • C_CUSTOMERMATERIAL_F2499.CUSTOMER == KNA1.KUNNR
  • C_CUSTOMERMATERIAL_F2499.CUSTOMERFOREDIT == KNA1.KUNNR
Customer number
  • Client
  • Customer number
  • Customer number
  • C_CUSTOMERMATERIAL_F2499.MANDT == KNA1.MANDT
  • C_CUSTOMERMATERIAL_F2499.CUSTOMER == KNA1.KUNNR
  • C_CUSTOMERMATERIAL_F2499.CUSTOMERFOREDIT == KNA1.KUNNR
Delivery Priority
  • Delivery Priority
  • Client
  • C_CUSTOMERMATERIAL_F2499.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_CUSTOMERMATERIAL_F2499.MANDT == TPRIO.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_CUSTOMERMATERIAL_F2499.MANDT == TVTW.MANDT
  • C_CUSTOMERMATERIAL_F2499.DISTRIBUTIONCHANNELFOREDIT == TVTW.VTWEG
  • C_CUSTOMERMATERIAL_F2499.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_CUSTOMERMATERIAL_F2499.MANDT == TVTW.MANDT
  • C_CUSTOMERMATERIAL_F2499.DISTRIBUTIONCHANNELFOREDIT == TVTW.VTWEG
  • C_CUSTOMERMATERIAL_F2499.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Product Number
  • Product Number
  • Material Number
  • Client
  • C_CUSTOMERMATERIAL_F2499.MATERIAL == MARA.MATNR
  • C_CUSTOMERMATERIAL_F2499.MATERIALFOREDIT == MARA.MATNR
  • C_CUSTOMERMATERIAL_F2499.MANDT == MARA.MANDT
Material Number
  • Product Number
  • Material Number
  • Client
  • C_CUSTOMERMATERIAL_F2499.MATERIAL == MARA.MATNR
  • C_CUSTOMERMATERIAL_F2499.MATERIALFOREDIT == MARA.MATNR
  • C_CUSTOMERMATERIAL_F2499.MANDT == MARA.MANDT
Sales Organization
  • Client
  • Sales Organization
  • Sales Organization
  • C_CUSTOMERMATERIAL_F2499.MANDT == TVKO.MANDT
  • C_CUSTOMERMATERIAL_F2499.SALESORGANIZATION == TVKO.VKORG
  • C_CUSTOMERMATERIAL_F2499.SALESORGANIZATIONFOREDIT == TVKO.VKORG
Sales Organization
  • Client
  • Sales Organization
  • Sales Organization
  • C_CUSTOMERMATERIAL_F2499.MANDT == TVKO.MANDT
  • C_CUSTOMERMATERIAL_F2499.SALESORGANIZATION == TVKO.VKORG
  • C_CUSTOMERMATERIAL_F2499.SALESORGANIZATIONFOREDIT == TVKO.VKORG