0ART_SALES_ATTR

Article Number Compounded with Sales | #ATTR | Extraction method: F1 | Delta: NEWE | Component: Logistics Master Data
Tables used: MVKEKNVVMARAMARCLFM1 ... +11 more
Column Name Description
MANDT FK Client
MATNR Material Number
VKORG Sales Organization
VTWEG Distribution Channel
Column Name Description
Column Name Description
AUMNG Minimum order quantity in base unit of measure
LFMNG Minimum Delivery Quantity in Delivery Note Processing
EFMNG Minimum make-to-order quantity
SCMNG Delivery unit
LFMAX Maximum delivery quantity in store order processing
Column Name Description
VMSTD Date from which distr.-chain-spec. material status is valid
LDVFL Date from which listed in the store
LDBFL Date to which listed in the store
LDVZL Date from which listed in the distribution center
LDBZL Date to which listed in the central warehouse/distr. center
VDVFL Date from which sold in the store
VDBFL Date to which sold in the store
VDVZL Date from which sold in the distribution center
VDBZL Date to which sold in the distribution center
Column Name Description
LVORM Ind.: Flag material for deletion at distribution chain level Show values
SKTOF Cash Discount Indicator Show values
LSTAK Listing functions (assortments) are active Show values
PRAT1 ID for product attribute 1 Show values
PRAT2 ID for product attribute 2 Show values
PRAT3 ID for product attribute 3 Show values
PRAT4 ID for product attribute 4 Show values
PRAT5 ID for product attribute 5 Show values
PRAT6 ID for product attribute 6 Show values
PRAT7 ID for product attribute 7 Show values
PRAT8 ID for product attribute 8 Show values
PRAT9 ID for product attribute 9 Show values
PRATA ID for product attribute 10 Show values
RJART Flag rackjobber material Show values
PBIND Indicator for price fixing Show values
VAVME Variable Sales Unit Not Allowed Show values
MATKC Competition characterization of a material Show values
Column Name Description Domain name
VERSG Material statistics group STGMA
BONUS Volume rebate group BONUS
PROVG Commission Group PROVG
VMSTA Distribution-chain-specific material status VMSTA
MTPOS Item Category Group from Material Master MTPOS
DWERK Delivering Plant (Own or External) WERKS
KONDM Material Price Group KONDM
KTGRM Account Assignment Group for Material KTGRM
MVGR1 Material Group 1 MVGR1
MVGR2 Material Group 2 MVGR2
MVGR3 Material Group 3 MVGR3
MVGR4 Material Group 4 MVGR4
MVGR5 Material Group 5 MVGR5
SSTUF Assortment grade SSTUF
PFLKS External assortment priority PFLKS
LSTFL Listing procedure for store or other assortment categories LSTFL
LSTVZ Listing procedure for distr. center assortment categories LSTFL
RDPRF Rounding Profile RDPRF
MEGRU Unit of Measure Group MEGRU
PVMSO Material sorting in product proposal PVMSO
PLGTP Price Band Category PLGTP
Master Data Relations Join Conditions
Client 0ART_SALES_ATTR.MANDT == T000.MANDT
Pricing Reference Material
  • 0ART_SALES_ATTR.MANDT == MARA.MANDT
  • 0ART_SALES_ATTR.PMATN == MARA.MATNR
Product Hierarchy
  • 0ART_SALES_ATTR.MANDT == T179.MANDT
  • 0ART_SALES_ATTR.PRODH == T179.PRODH