MaterialsMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialsMD
Descripción general
Esta vista es una vista de informes para sistemas SAP que proporciona información detallada sobre los materiales.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| MARA | Tabla maestra de materiales |
| MAKT | Tabla de texto de materiales |
Casos de uso clave
- Se puede utilizar para recuperar información de materiales para fines de elaboración de informes.
- Se puede utilizar para identificar materiales que cumplen criterios específicos.
- Se puede utilizar para realizar un seguimiento de los cambios en los datos de materiales a lo largo del tiempo.
Lógica de consulta
La vista une las tablas MARA y MAKT en los campos MANDT y MATNR. Esto garantiza que la vista solo incluya materiales que tengan descripciones de texto correspondientes.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| MM01 | Crear material |
| MM02 | Cambiar material |
| MM03 | Mostrar material |
Linaje de datos
Em desarollo
Campos de tabla/vista
| Campo | Descripción del campo | Descripción del Diccionario SAP (Em breve) |
|---|---|---|
| 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 |