FAC_AUDIT_Z3_MATERIAL_MASTER_B

Material Master based CDS View | view: FAC_AUDMATMSTB | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: MARAMARCMATERIALIDT001KT001WADCPADRCT001TKA02MARAT023T023TMAKTT134T134TT001WT179T
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 TEXT20
MaterialName Material Description TEXT40
normt Industry Standard Description (such as ANSI or ISO) NORMT
ProductHierarchyText Product Hierarchy Text TEXT40
MaterialCategoryName Product Category Text DDTEXT
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
Language null
Master Data Relations Join Conditions
Valuation Category
  • Client
  • Valuation Category
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T149C.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.BWTTY == T149C.BWTTY
Foreign trade: CAS number - pharmaceutical products
  • CAS number for pharmaceutical products in foreign trade
  • Client
  • ?
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.CASNR == T610C.CASNR
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T610C.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.[column in domain "EILAN"] == T610C.LAND1
External Material Group
  • Client
  • External Material Group
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == TWEW.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.EXTWG == TWEW.EXTWG
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.HERKL == T005.LAND1
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T005.MANDT
Region of Origin of Material (Non-Preferential Origin)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • Region of Origin of Material (Non-Preferential Origin)
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.HERKL == T005S.LAND1
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T005S.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.HERKR == T005S.BLAND
Material Group
  • Client
  • Material Group
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T023.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T134.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MATERIALTYPE == T134.MTART
Checking group
  • Client
  • Material Group for Intrastat
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == TVFM.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MTVER == TVFM.MTVER
Object type for production resource/tool master record
  • Client
  • Object Type
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T778O.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.OTYPE == T778O.OTYPE
Product Hierarchy
  • Client
  • Product hierarchy
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T179.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.PRDHA == T179.PRODH
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == MARA.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.SATNR == MARA.MATNR
Configurable material
  • Client
  • Configurable material
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == MARA.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.STDPD == MARA.MATNR
Foreign trade: control code
  • Client
  • Control code for consumption taxes in foreign trade
  • ?
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == T604F.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.STEUC == T604F.STEUC
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.[column in domain "LAND1"] == T604F.LAND1
Hazardous material number
  • Client
  • ?
  • Hazardous material number
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == MGEF.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.[column in domain "REGKZ"] == MGEF.REGKZ
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.STOFF == MGEF.STOFF
Tax classification of the material
  • Client
  • Tax classification of the material
  • ?
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.MANDT == TSKM.MANDT
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.TAKLV == TSKM.TAXKM
  • FAC_AUDIT_Z3_MATERIAL_MASTER_B.[column in domain "TATYP"] == TSKM.TATYP