MaterialsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialsMD
Overview
This view is a reporting view for SAP systems that provides detailed information about materials.
Data Sources
| Source Table/View | Description |
|---|---|
| MARA | Material Master table |
| MAKT | Material Text table |
Key Use Cases
- Can be used to retrieve material information for reporting purposes.
- Can be used to identify materials that meet specific criteria.
- Can be used to track changes to material data over time.
Query Logic
The view joins the MARA and MAKT tables on the MANDT and MATNR fields. This ensures that the view only includes materials that have corresponding text descriptions.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM01 | Create Material |
| MM02 | Change Material |
| MM03 | Display Material |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_Mandt | Client | |
| Materialnumber_Matnr | Material number | |
| Createdon_Ersda | Created on | |
| Nameofpersonwhocreatedtheobject_Ernam | Name of person who created the object | |
| Dateoflastchange_Laeda | Date of last change | |
| Nameofpersonwhochangedobject_Aenam | Name of person who changed object | |
| Maintenancestatusofcompletematerial_Vpsta | Maintenance status of complete material | |
| Maintenancestatus_Pstat | Maintenance status | |
| Flagmaterialfordeletionatclientlevel_Lvorm | Flag material for deletion at client level | |
| Materialtype_Mtart | Material type | |
| Industrysector_Mbrsh | Industry sector | |
| Materialgroup_Matkl | Material group | |
| Oldmaterialnumber_Bismt | Old material number | |
| Baseunitofmeasure_Meins | Base unit of measure | |
| Orderunit_Bstme | Order unit | |
| Documentnumberwithoutdocumentmanagementsystem_Zeinr | Document number without document management system | |
| Documenttypewithoutdocumentmanagementsystem_Zeiar | Document type without document management system | |
| Documentversionwithoutdocumentmanagementsystem_Zeivr | Document version without document management system | |
| Pageformatofdocumentwithoutdocumentmanagementsystem_Zeifo | Page format of document without document management system | |
| Documentchangenumberwithoutdocumentmanagementsystem_Aeszn | Document change number without document management system | |
| Pagenumberofdocumentwithoutdocumentmanagementsystem_Blatt | Page number of document without document management system | |
| Numberofsheetswithoutdocumentmanagementsystem_Blanz | Number of sheets without document management system | |
| Productioninspectionmemo_Ferth | Production inspection memo | |
| Pageformatofproductionmemo_Formt | Page format of production memo | |
| Sizedimensions_Groes | Size dimensions | |
| Basicmaterial_Wrkst | Basic material | |
| Industrystandarddescriptionsuchasansioriso_Normt | Industry standard description such as ANSI or ISO | |
| Laboratorydesignoffice_Labor | Laboratory design office | |
| Purchasingvaluekey_Ekwsl | Purchasing value key | |
| Grossweight_Brgew | Gross weight | |
| Netweight_Ntgew | Net weight | |
| Weightunit_Gewei | Weight unit | |
| Volume_Volum | Volume | |
| Volumeunit_Voleh | Volume unit | |
| Containerrequirements_Behvo | Container requirements | |
| Storageconditions_Raube | Storage conditions | |
| Temperatureconditionsindicator_Tempb | Temperature conditions indicator | |
| Lowlevelcode_Disst | Low level code | |
| Transportationgroup_Tragr | Transportation group | |
| Hazardousmaterialnumber_Stoff | Hazardous material number | |
| Division_Spart | Division | |
| Competitor_Kunnr | Competitor | |
| Europeanarticlenumber_Eannr | European article number | |
| Quantitynumberofgrgislipstobeprinted_Wesch | Quantity number of GRGI slips to be printed | |
| Procurementrule_Bwvor | Procurement rule | |
| Sourceofsupply_Bwscl | Source of supply | |
| Seasoncategory_Saiso | Season category | |
| Labeltype_Etiar | Label type | |
| Labelform_Etifo | Label form | |
| Deactivated_Entar | Deactivated | |
| Internationalarticlenumbereanupc_Ean11 | International article number EAN/UPC | |
| Categoryofinternationalarticlenumberean_Numtp | Category of international article number EAN | |
| Length_Laeng | Length | |
| Width_Breit | Width | |
| Height_Hoehe | Height | |
| Unitofdimensionforlengthwidthheight_Meabm | Unit of dimension for length, width, height | |
| ProductHierarchy_Prdha | Product Hierarchy | |
| Stocktransfernetchangecosting_Aeklk | Stock transfer net change costing | |
| Cadindicator_Cadkz | CAD indicator | |
| Qminprocurementisactive_Qmpur | Qmin procurement is active | |
| Allowedpackagingweight_Ergew | Allowed packaging weight | |
| Unitofweightallowedpackagingweight_Ergew | Unit of weight allowed packaging weight | |
| Allowedpackagingvolume_Ervol | Allowed packaging volume | |
| Volumeunitallowedpackagingvolume_Ervoe | Volume unit allowed packaging volume | |
| Excessweighttoleranceforhandlingunit_Gewto | Excess weight tolerance for handling unit | |
| Excessvolumetoleranceofthehandlingunit_Volto | Excess volume tolerance of the handling unit | |
| Variablepurchaseorderunitactive_Vabme | Variable purchase order unit active | |
| Revisionlevelhasbeenassignedtothematerial_Kzrev | Revision level has been assigned to the material | |
| Configurablematerial_Kzkfg | Configurable material | |
| Batchmanagementrequirementindicator_Xchpf | Batch management requirement indicator | |
| Packagingmaterialtype_Vhart | Packaging material type | |
| Maximumlevelbyvolume_Fuelg | Maximum level by volume | |
| Stackingfactor_Stfak | Stacking factor | |
| Materialgrouppackagingmaterials_Magrv | Material group packaging materials | |
| Authorizationgroup_Begru | Authorization group | |
| Validfromdate_Datab | Valid from date | |
| Deletiondate_Liqdt | Deletion date | |
| Seasonyear_Saisj | Season year | |
| Pricebandcategory_Plgtp | Price band category | |
| Emptiesbillofmaterial_Mlgut | Empties bill of material | |
| Externalmaterialgroup_Extwg | External material group | |
| Crossplantconfigurablematerial_Satnr | Cross-plant configurable material | |
| Materialcategory_Attyp | Material category | |
| Indicatormaterialcanbecoproduct_Kzkup | Indicator material can be co-product | |
| Indicatorthematerialhasafollowupmaterial_Kznfm | Indicator the material has a follow-up material | |
| Pricingreferencematerial_Pmata | Pricing reference material | |
| Crossplantmaterialstatus_Mstae | Cross-plant material status | |
| Crossdistributionchainmaterialstatus_Mstav | Cross-distribution chain material status | |
| Datefromwhichthecrossplantmaterialstatusisvalid_Mstde | Date from which the cross-plant material status is valid | |
| Datefromwhichthexdistrchainmaterialstatusisvalid_Mstdv | Date from which the x-distr. chain material status is valid | |
| Taxclassificationofthematerial_Taklv | Tax classification of the material | |
| Catalogprofile_Rbnrm | Catalog profile | |
| Minimumremainingshelflife_Mhdrz | Minimum remaining shelf life | |
| Totalshelflife_Mhdhb | Total shelf life | |
| Storagepercentage_Mhdlp | Storage percentage | |
| Contentunit_Inhme | Content unit | |
| Netcontents_Inhal | Net contents | |
| Comparisonpriceunit_Vpreh | Comparison price unit | |
| Grosscontents_Inhbr | Gross contents | |
| Quantityconversionmethod_Cmeth | Quantity conversion method | |
| Internalobjectnumber_Cuobf | Internal object number | |
| Environmentallyrelevant_Kzumw | Environmentally relevant | |
| Productallocationdeterminationprocedure_Kosch | Product allocation determination procedure | |
| Pricingprofileforvariants_Sprof | Pricing profile for variants | |
| Materialqualifiesfordiscountinkind_Nrfhg | Material qualifies for discount in kind | |
| Manufacturerpartnumber_Mfrpn | Manufacturer part number | |
| Manufacturernumber_Mfrpn | Manufacturer number | |
| Numberinventorymanagedmaterial_Bmatn | Number inventory managed material | |
| Mfrpartprofile_Mprof | Mfr part profile | |
| Unitsofmeasureusage_Kzwsm | Units of measure usage | |
| Rolloutinaseason_Saity | Rollout in a season | |
| Dangerousgoodsindicatorprofile_Profl | Dangerous goods indicator profile | |
| Indicatorhighlyviscous_Ihivi | Indicator highly viscous | |
| Indicatorinbulkliquid_Iloos | Indicator in bulk liquid | |
| Levelofexplicitnessforserialnumber_Serlv | Level of explicitness for serial number | |
| Packagingmaterialisclosedpackaging_Kzgvh | Packaging material is closed packaging | |
| Indicatorapprovedbatchrecordrequired_Xgchp | Indicator approved batch record required | |
| Assigneffectivityparametervaluesoverridechangenumbers_Kzeff | Assign effectivity parameter values override change numbers | |
| Materialcompletionlevel_Compl | Material completion level | |
| Periodindicatorforshelflifeexpirationdate_Iprkz | Period indicator for shelf life expiration date | |
| Roundingruleforcalculationofsled_Rdmhd | Rounding rule for calculation of SLED | |
| Indicatorproductcompositionprintedonpackaging_Przus | Indicator product composition printed on packaging | |
| Generalitemcategorygroup_Mtpos_Mara | General item category group | |
| Genericmaterialwithlogisticalvariants_Bflme | Generic material with logistical variants | |
| Materialislocked_Matfi | Material is locked | |
| Relevantforconfigurationmanagement_Cmrel | Relevant for configuration management | |
| Assortmentlisttype_Bbtyp | Assortment list type | |
| Expirationdate_Sled_Bbd | Expiration date | |
| Globaltradeitemnumbervariant_Gtin_Variant | Global trade item number variant | |
| Materialnumberofthegenericmaterialinprepackmaterials_Gennr | Material number of the generic material in prepack materials | |
| Referencematerialformaterialspackedinsameway_Rmatp | Reference material for materials packed in same way | |
| Indicatorglobaldatasynchronizationrelevant_Gds_Relevant | Indicator global data synchronization relevant | |
| Acceptanceatorigin_Weora | Acceptance at origin | |
| Standardhutype_Hutyp_Dflt | Standard HU type | |
| Pilferable_Pilferable | Pilferable | |
| Warehousestoragecondition_Whstc | Warehouse storage condition | |
| Warehousematerialgroup_Whmatgr | Warehouse material group | |
| Handlingindicator_Hndlcode | Handling indicator | |
| Relevantforhazardoussubstances_Hazmat | Relevant for hazardous substances | |
| Handlingunittype_Hutyp | Handling unit type | |
| Variabletareweight_Tare_Var | Variable tare weight | |
| Maximumallowedcapacityofpackagingmaterial_Maxc | Maximum allowed capacity of packaging material | |
| Overcapacitytoleranceofthehandlingunit_Maxc_Tol | Overcapacity tolerance of the handling unit | |
| Maximumpackinglengthofpackagingmaterial_Maxl | Maximum packing length of packaging material | |
| Maximumpackingwidthofpackagingmaterial_Maxb | Maximum packing width of packaging material | |
| Maximumpackingheightofpackagingmaterial_Maxh | Maximum packing height of packaging material | |
| Unitofmeasureformaximumpackinglengthwidthheight_Maxdim_Uom | Unit of measure for maximum packing length, width, height | |
| Countryoforiginofmaterial_Herkl | Country of origin of material | |
| Materialfreightgroup_Mfrgr | Material freight group | |
| Quarantineperiod_Qqtime | Quarantine period | |
| Timeunitforquarantineperiod_Qqtimeuom | Time unit for quarantine period | |
| Qualityinspectiongroup_Qgrp | Quality inspection group | |
| Serialnumberprofile_Serial | Serial number profile | |
| Formname_Ps_Smartform | Form name | |
| Ewmcwlogisticsunitofmeasure_Logunit | Ewmcw logistics unit of measure | |
| Ewmcwmaterialisacatchweightmaterial_Cwqrel | Ewmcw material is a catch weight material | |
| Ewmcwcatchweightprofileforenteringcwquantity_Cwqproc | Ewmcw catch weight profile for entering CW quantity | |
| Ewmcatchweighttolerancegroupforewm_Cwqtolgr | Ewm catch weight tolerance group for EWM | |
| Adjustmentprofile_Adprof | Adjustment profile | |
| Idforanintellectualpropertycrmproduct_Ipmipproduct | Id for an intellectual property CRM product | |
| Variantpriceallowedformaterialmaster_Allow_Pmat_Igno | Variant price allowed for material master | |
| Medium_Medium | Medium | |
| Physicalcommodity_Commodity | Physical commodity | |
| Brand_Brand_Id | Brand | |
| Language_Spras | Language | |
| Materialtext_Maktx | Material text |