0ARTICLE_ATTR

Article Number | #ATTR | Extraction method: F1 | Delta: NEWE | Component: Logistics Master Data
Tables used: MARA, MARM, MARC, KNVV, MARD ... +11 more
Column Name Description
MATNR Material Number
SPART FK Division
KUNNR FK Competitor
Column Name Description
Column Name Description
📏 Weight Unit (GEWEI):
BRGEW Gross weight
NTGEW Net weight
📏 Volume unit (VOLEH):
VOLUM Volume
📏 Base Unit of Measure (MEINS):
WESCH Quantity: Number of GR/GI slips to be printed
📏 Unit of Dimension for Length/Width/Height (MEABM):
LAENG Length
BREIT Width
HOEHE Height
📏 Unit of weight (allowed packaging weight) (ERGEI):
ERGEW Allowed packaging weight
📏 Volume unit (allowed packaging volume) (ERVOE):
ERVOL Allowed packaging volume
📏 Content unit (INHME):
INHAL Net contents
INHBR Gross contents
Column Name Description
ERSDA Created On
LAEDA Date of Last Change
DATAB Valid-From Date
LIQDT Deletion date
MSTDE Date from which the cross-plant material status is valid
MSTDV Date from which the X-distr.-chain material status is valid
Column Name Description
LVORM Flag Material for Deletion at Client Level Show values
AEKLK Stock Transfer Net Change Costing Show values
CADKZ CAD Indicator Show values
QMPUR QM in Procurement Is Active Show values
VABME Variable Purchase Order Unit Active Show values
KZREV Revision Level Has Been Assigned to the Material Show values
KZKFG Configurable Material Show values
XCHPF Batch Management Requirement Indicator Show values
MLGUT Empties Bill of Material Show values
ATTYP Material Category Show values
KZKUP Indicator: Material can be co-product Show values
KZNFM Indicator: The material has a follow-up material Show values
CMETH Quantity Conversion Method Show values
KZUMW Environmentally Relevant Show values
SPROF Pricing profile for variants Show values
NRFHG Material qualifies for discount in kind Show values
KZWSM Units of measure usage Show values
IHIVI Indicator: Highly Viscous Show values
ILOOS Indicator: In Bulk/Liquid Show values
SERLV Level of Explicitness for Serial Number Show values
KZGVH Packaging Material is Closed Packaging Show values
XGCHP Approved Batch Record Required Show values
KZEFF Assign effectivity parameter values/ override change numbers Show values
IPRKZ Period Indicator for Shelf Life Expiration Date Show values
RDMHD Rounding rule for calculation of SLED Show values
PRZUS Indicator: Product composition printed on packaging Show values
BFLME Generic Material with Logistical Variants Show values
Column Name Description Domain name
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
VPSTA Maintenance status of complete material PSTAT
PSTAT Maintenance status PSTAT
BISMT Old material number BISMT
ZEINR Document number (without document management system) CHAR22
ZEIAR Document type (without Document Management system) ZEIAR
ZEIVR Document version (without Document Management system) VERSI
ZEIFO Page format of document (without Document Management system) DINFO
AESZN Document change number (without document management system) AENUM
BLATT Page number of document (without Document Management system) BLATT
BLANZ Number of sheets (without Document Management system) NUM3
FERTH Production/inspection memo FERTH
FORMT Page Format of Production Memo DINFO
GROES Size/dimensions CHAR32
NORMT Industry Standard Description (such as ANSI or ISO) NORMT
DISST Low-Level Code DISST
EANNR European Article Number (EAN) - obsolete!!!!! CHAR13
ENTAR Disposal type ENTAR
EAN11 International Article Number (EAN/UPC) EAN11
GEWTO Excess Weight Tolerance for Handling unit PRZ21
VOLTO Excess Volume Tolerance of the Handling Unit PRZ21
FUELG Maximum level (by volume) DEC3
STFAK Stacking factor INT2
BEGRU Authorization Group BEGRU
SAISJ Season Year CJAHR
MHDRZ Minimum Remaining Shelf Life DEC4
MHDHB Total shelf life DEC4
MHDLP Storage percentage DEC3
VPREH Comparison price unit PACK3
CUOBF Internal object number CUOBJ
MFRPN Manufacturer Part Number CHAR40
Master Data Relations Join Conditions
Container Requirement(s)
  • Client
  • Container requirements
  • 0ARTICLE_ATTR.MANDT == T144.MANDT
  • 0ARTICLE_ATTR.BEHVO == T144.BEHVO
Number of Internal Material Master Record
  • Client
  • Number of firm's own (internal) inventory-managed material
  • 0ARTICLE_ATTR.MANDT == MARA.MANDT
  • 0ARTICLE_ATTR.BMATN == MARA.MATNR
Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.BSTME == T006.MSEHI
Source of Supply
  • Client
  • Source of Supply
  • 0ARTICLE_ATTR.MANDT == TMBW1.MANDT
  • 0ARTICLE_ATTR.BWSCL == TMBW1.BWSCL
Procurement rule
  • Client
  • Procurement rule
  • 0ARTICLE_ATTR.MANDT == T6WP1.MANDT
  • 0ARTICLE_ATTR.BWVOR == T6WP1.BWVOR
Material completion level
  • Client
  • Material completion level
Purchasing Value Key
  • Client
  • Purchasing Value Key
  • 0ARTICLE_ATTR.MANDT == T405.MANDT
  • 0ARTICLE_ATTR.EKWSL == T405.EKWSL
Unit of Weight for Allowed Packaging Weight
  • Client
  • Unit of weight (allowed packaging weight)
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.ERGEI == T006.MSEHI
Unit of Volume for Allowed Packaging Weight
  • Client
  • Volume unit (allowed packaging volume)
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.ERVOE == T006.MSEHI
IS-R Labeling: material grouping (deactivated in 4.0)
  • Client
  • IS-R Labeling: material grouping (deactivated in 4.0)
  • 0ARTICLE_ATTR.MANDT == TWEA.MANDT
  • 0ARTICLE_ATTR.ETIAG == TWEA.ARTGR
Label Type
  • Client
  • Label type
  • 0ARTICLE_ATTR.MANDT == T6WP3.MANDT
  • 0ARTICLE_ATTR.ETIAR == T6WP3.ETIAR
Label Form
  • Client
  • Label form
  • 0ARTICLE_ATTR.MANDT == T6WP4.MANDT
  • 0ARTICLE_ATTR.ETIFO == T6WP4.ETIFO
External Material Group
  • Client
  • External Material Group
  • 0ARTICLE_ATTR.MANDT == TWEW.MANDT
  • 0ARTICLE_ATTR.EXTWG == TWEW.EXTWG
Unit of Weight
  • Client
  • Weight Unit
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.GEWEI == T006.MSEHI
Content unit
  • Client
  • Content unit
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.INHME == T006.MSEHI
Product Allocation Determination Procedure
  • Client
  • Product allocation determination procedure
  • 0ARTICLE_ATTR.MANDT == T190S.MANDT
  • 0ARTICLE_ATTR.KOSCH == T190S.KOSCH
Laboratory
  • Client
  • Laboratory/design office
  • 0ARTICLE_ATTR.MANDT == T024L.MANDT
  • 0ARTICLE_ATTR.LABOR == T024L.LABOR
Material Group: Packaging Materials
  • Client
  • Material Group: Packaging Materials
  • 0ARTICLE_ATTR.MANDT == TVEGR.MANDT
  • 0ARTICLE_ATTR.MAGRV == TVEGR.MAGRV
Material Group
  • Client
  • Material Group
  • 0ARTICLE_ATTR.MANDT == T023.MANDT
  • 0ARTICLE_ATTR.MATKL == T023.MATKL
Industry Sector
  • Client
  • Industry Sector
  • 0ARTICLE_ATTR.MANDT == T137.MANDT
  • 0ARTICLE_ATTR.MBRSH == T137.MBRSH
Unit of Measure for Length/Breadth/Height
  • Client
  • Unit of Dimension for Length/Width/Height
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.MEABM == T006.MSEHI
Unit of Measure
  • Client
  • Base Unit of Measure
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.MEINS == T006.MSEHI
Manufacturer Number
  • Client
  • Manufacturer number
  • 0ARTICLE_ATTR.MANDT == LFA1.MANDT
  • 0ARTICLE_ATTR.MFRNR == LFA1.LIFNR
Control Profile for Manufacturer Parts Processing
  • Client
  • Mfr part profile
  • 0ARTICLE_ATTR.MANDT == TMPPF.MANDT
  • 0ARTICLE_ATTR.MPROF == TMPPF.MPROF
Cross-Plant Material Status
  • Client
  • Cross-Plant Material Status
  • 0ARTICLE_ATTR.MANDT == T141.MANDT
  • 0ARTICLE_ATTR.MSTAE == T141.MMSTA
Cross-distribution-chain material status
  • Client
  • Cross-distribution-chain material status
  • 0ARTICLE_ATTR.MANDT == TVMS.MANDT
  • 0ARTICLE_ATTR.MSTAV == TVMS.VMSTA
Material type
  • Client
  • Material type
  • 0ARTICLE_ATTR.MANDT == T134.MANDT
  • 0ARTICLE_ATTR.MTART == T134.MTART
General item category group
  • Client
  • General item category group
  • 0ARTICLE_ATTR.MANDT == TPTM.MANDT
  • 0ARTICLE_ATTR.MTPOS_MARA == TPTM.MTPOS
Category of International Article Number (EAN)
  • Client
  • Category of International Article Number (EAN)
  • 0ARTICLE_ATTR.MANDT == TNTP.MANDT
  • 0ARTICLE_ATTR.NUMTP == TNTP.NUMTP
Price Band Category
  • Client
  • Price Band Category
  • 0ARTICLE_ATTR.MANDT == TWPT.MANDT
  • 0ARTICLE_ATTR.PLGTP == TWPT.PLGTP
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • 0ARTICLE_ATTR.MANDT == MARA.MANDT
  • 0ARTICLE_ATTR.PMATA == MARA.MATNR
Product Hierarchy
  • Client
  • Product hierarchy
  • 0ARTICLE_ATTR.MANDT == T179.MANDT
  • 0ARTICLE_ATTR.PRDHA == T179.PRODH
Dangerous Goods Profile
  • Client
  • Dangerous Goods Indicator Profile
  • 0ARTICLE_ATTR.MANDT == TDG41.MANDT
  • 0ARTICLE_ATTR.PROFL == TDG41.PROFL
Storage Condition(s)
  • Client
  • Storage conditions
  • 0ARTICLE_ATTR.MANDT == T142.MANDT
  • 0ARTICLE_ATTR.RAUBE == T142.RAUBE
Catalog Profile
  • Client
  • Catalog Profile
  • 0ARTICLE_ATTR.MANDT == T352B.MANDT
  • 0ARTICLE_ATTR.RBNRM == T352B.RBNR
Season
  • Client
  • Season Category
  • 0ARTICLE_ATTR.MANDT == T6WSP.MANDT
  • 0ARTICLE_ATTR.SAISO == T6WSP.SAISO
Categories of Seasonal Materials
  • Client
  • Rollout in a Season
  • 0ARTICLE_ATTR.MANDT == T6WSA.MANDT
  • 0ARTICLE_ATTR.SAITY == T6WSA.SAITY
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • 0ARTICLE_ATTR.MANDT == MARA.MANDT
  • 0ARTICLE_ATTR.SATNR == MARA.MATNR
Division
  • Client
  • Division
  • 0ARTICLE_ATTR.MANDT == TSPA.MANDT
  • 0ARTICLE_ATTR.SPART == TSPA.SPART
Hazardous material number
  • Client
  • ?
  • Hazardous material number
  • 0ARTICLE_ATTR.MANDT == MGEF.MANDT
  • 0ARTICLE_ATTR.[column in domain "REGKZ"] == MGEF.REGKZ
  • 0ARTICLE_ATTR.STOFF == MGEF.STOFF
Tax classification of the material
  • Client
  • ?
  • Tax classification of the material
  • 0ARTICLE_ATTR.MANDT == TSKM.MANDT
  • 0ARTICLE_ATTR.[column in domain "TATYP"] == TSKM.TATYP
  • 0ARTICLE_ATTR.TAKLV == TSKM.TAXKM
Temperature Condition(s)
  • Client
  • Temperature conditions indicator
  • 0ARTICLE_ATTR.MANDT == T143.MANDT
  • 0ARTICLE_ATTR.TEMPB == T143.TEMPB
Carr. Group
  • Client
  • Transportation Group
  • 0ARTICLE_ATTR.MANDT == TTGR.MANDT
  • 0ARTICLE_ATTR.TRAGR == TTGR.TRAGR
Packaging Material Type
  • Client
  • Packaging Material Type
  • 0ARTICLE_ATTR.MANDT == TVTY.MANDT
  • 0ARTICLE_ATTR.VHART == TVTY.TRATY
Volume Unit
  • Client
  • Volume unit
  • 0ARTICLE_ATTR.MANDT == T006.MANDT
  • 0ARTICLE_ATTR.VOLEH == T006.MSEHI
Basic Material
  • Client
  • Basic Material
  • 0ARTICLE_ATTR.MANDT == TWSPR.MANDT
  • 0ARTICLE_ATTR.WRKST == TWSPR.WRKST