FAC_AUDIT_Z3_MATERIAL_MASTER

Material master | view: FAC_AUDMATMST | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: MARAMARCMATERIALIDT001KT001WADCPADRCT001TKA02MARAT023T023TMAKTT134T134TT001WT179TFINSC_LD_CMP
Column Name Description
CompanyCode Company Code
Material Material Number
Column Name Description
Column Name Description
Column Name Description
preng Validity date of vendor declaration
prend Exemption certificate: Issue date of exemption certificate
ersda Created On
Column Name Description
attyp Material Category Show values
kzumw Environmentally Relevant Show values
atpkz Replacement part Show values
prefe Customs Preference Show values
prenc Exemption certificate: Indicator for legal control Show values
prene Indicator: Vendor declaration exists Show values
schgt Indicator: bulk material Show values
Column Name Description Domain name
Plant Plant WERKS
MaterialTypeName Description of Material Type TEXT25
MaterialGroupName Product Group Description
MaterialName Material Description TEXT40
normt Industry Standard Description (such as ANSI or ISO) NORMT
ProductHierarchyText Product Hierarchy Text TEXT40
MaterialCategoryName Product Category Text
prctr Profit Center PRCTR
preno Exemption certificate number for legal control PRENN
herbl State of manufacture HERBL
cuobf Internal object number CUOBJ
objid Object ID NUM08
bismt Old material number BISMT
matnr_external External Representation of Material Number CHAR40
matnr_vers Material Version Number MATNR_VERS
ernam Name of Person Responsible for Creating the Object USNAM
system_client 3-Byte field
Master Data Relations Join Conditions
Valuation Category
  • Valuation Category
  • Client
  • FAC_AUDIT_Z3_MATERIAL_MASTER.BWTTY == T149C.BWTTY
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T149C.MANDT
Foreign trade: CAS number - pharmaceutical products
  • CAS number for pharmaceutical products in foreign trade
  • ?
  • Client
  • FAC_AUDIT_Z3_MATERIAL_MASTER.CASNR == T610C.CASNR
  • FAC_AUDIT_Z3_MATERIAL_MASTER.[column in domain "EILAN"] == T610C.LAND1
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T610C.MANDT
External Material Group
  • External Material Group
  • Client
  • FAC_AUDIT_Z3_MATERIAL_MASTER.EXTWG == TWEW.EXTWG
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == TWEW.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_AUDIT_Z3_MATERIAL_MASTER.FISCALYEARVARIANT == T009.PERIV
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T009.MANDT
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T005.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.HERKL == T005.LAND1
Region of Origin of Material (Non-Preferential Origin)
  • Region of Origin of Material (Non-Preferential Origin)
  • Client
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • FAC_AUDIT_Z3_MATERIAL_MASTER.HERKR == T005S.BLAND
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T005S.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.HERKL == T005S.LAND1
Material Group
  • Client
  • Material Group
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T023.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T134.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MATERIALTYPE == T134.MTART
Checking group
  • Material Group for Intrastat
  • Client
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MTVER == TVFM.MTVER
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == TVFM.MANDT
Object type for production resource/tool master record
  • Client
  • Object Type
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T778O.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.OTYPE == T778O.OTYPE
Product Hierarchy
  • Client
  • Product hierarchy
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T179.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.PRDHA == T179.PRODH
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == MARA.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.SATNR == MARA.MATNR
Configurable material
  • Configurable material
  • Client
  • FAC_AUDIT_Z3_MATERIAL_MASTER.STDPD == MARA.MATNR
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == MARA.MANDT
Foreign trade: control code
  • ?
  • Client
  • Control code for consumption taxes in foreign trade
  • FAC_AUDIT_Z3_MATERIAL_MASTER.[column in domain "LAND1"] == T604F.LAND1
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == T604F.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.STEUC == T604F.STEUC
Hazardous material number
  • Hazardous material number
  • Client
  • ?
  • FAC_AUDIT_Z3_MATERIAL_MASTER.STOFF == MGEF.STOFF
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == MGEF.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.[column in domain "REGKZ"] == MGEF.REGKZ
Tax classification of the material
  • Tax classification of the material
  • Client
  • ?
  • FAC_AUDIT_Z3_MATERIAL_MASTER.TAKLV == TSKM.TAXKM
  • FAC_AUDIT_Z3_MATERIAL_MASTER.MANDT == TSKM.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER.[column in domain "TATYP"] == TSKM.TATYP