MaterialsMD
Arquivo SQL de origem - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialsMD
Visão geral
Esta visão de relatório fornece uma visão geral abrangente dos dados mestres de material em sistemas SAP. Ele combina dados das tabelas MARA e MAKT para fornecer informações detalhadas sobre materiais, incluindo seus atributos, descrições e relacionamentos.
Fontes de Dados
| Tabela/Visão | Descrição |
|---|---|
| MARA | Tabela Mestra de Materiais |
| MAKT | Tabela de Texto do Material |
Casos de Uso
- Gerenciamento e planejamento de materiais
- Controle e avaliação de estoque
- Processamento de pedidos de compra e venda
- Controle de produção e qualidade
- Contabilidade e relatórios financeiros
Lógica da Query
A visão une as tabelas MARA e MAKT nos campos MANDT e MATNR para recuperar dados mestres de material e textos de material correspondentes. A consulta seleciona uma ampla gama de campos de ambas as tabelas, fornecendo uma visão abrangente das informações do material.
Possível relação com transações SAP
| Código da Transação | Descrição da Transação |
|---|---|
| MM01 | Criar mestre de material |
| MM02 | Alterar mestre de material |
| MM03 | Exibir mestre de material |
| MB51 | Visão geral do estoque de material |
| MB52 | Visão geral do movimento do material |
Linhagem de dados
Em desenvolvimento
Campos da Tabela/Visão
| Campo | Descrição do Campo | Descrição no Dicionário 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 | |
| DocumentNumber_WithoutDocumentManagementSystem_ZEINR | Document Number (Without Document Management System) | |
| DocumentType_WithoutDocumentManagementSystem_ZEIAR | Document Type (Without Document Management System) | |
| DocumentVersion_WithoutDocumentManagementSystem_ZEIVR | Document Version (Without Document Management System) | |
| PageFormatOfDocument_WithoutDocumentManagementSystem_ZEIFO | Page Format Of Document (Without Document Management System) | |
| DocumentChangeNumber_WithoutDocumentManagementSystem_AESZN | Document Change Number (Without Document Management System) | |
| PageNumberOfDocument_WithoutDocumentManagementSystem_BLATT | Page Number Of Document (Without Document Management System) | |
| NumberOfSheets_WithoutDocumentManagementSystem_BLANZ | Number Of Sheets (Without Document Management System) | |
| ProductioInspectionMemo_FERTH | Productio Inspection Memo | |
| PageFormatOfProductionMemo_FORMT | Page Format Of Production Memo | |
| SizeDimensions_GROES | Size Dimensions | |
| BasicMaterial_WRKST | Basic Material | |
| IndustryStandardDescription_SuchAsAnsiOrIso_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 | |
| Quantity_NumberOfGrgiSlipsToBePrinted_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 | |
| InternationalArticleNumber_Eanupc_EAN11 | International Article Number (Eanupc) | |
| CategoryOfInternationalArticleNumber_Ean_NUMTP | Category Of International Article Number (Ean) | |
| Length_LAENG | Length | |
| Width_BREIT | Width | |
| Height_HOEHE | Height | |
| UnitOfDimensionForLengthwidthheight_MEABM | Unit Of Dimension For Lengthwidthheight | |
| ProductHierarchy_PRDHA | Product Hierarchy | |
| StockTransferNetChangeCosting_AEKLK | Stock Transfer Net Change Costing | |
| CadIndicator_CADKZ | Cad Indicator | |
| QmInProcurementIsActive_QMPUR | Qm In Procurement Is Active | |
| AllowedPackagingWeight_ERGEW | Allowed Packaging Weight | |
| UnitOfWeight_AllowedPackagingWeight_ERGEI | Unit Of Weight (Allowed Packaging Weight) | |
| AllowedPackagingVolume_ERVOL | Allowed Packaging Volume | |
| VolumeUnit_AllowedPackagingVolume_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 | |
| MaximumLevel_ByVolume_FUELG | Maximum Level (By Volume) | |
| StackingFactor_STFAK | Stacking Factor | |
| MaterialGroup_PackagingMaterials_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 | |
| Indicator_MaterialCanBeCoProduct_KZKUP | Indicator (Material Can Be Co Product) | |
| Indicator_TheMaterialHasAFollowUpMaterial_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_MFRNR | 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 | |
| Indicator_HighlyViscous_IHIVI | Indicator (Highly Viscous) | |
| Indicator_InBulkLiquid_ILOOS | Indicator (In Bulk Liquid) | |
| LevelOfExplicitnessForSerialNumber_SERLV | Level Of Explicitness For Serial Number | |
| PackagingMaterialIsClosedPackaging_KZGVH | Packaging Material Is Closed Packaging | |
| Indicator_ApprovedBatchRecordRequired_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 | |
| Indicator_ProductCompositionPrintedOnPackaging_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 | |
| Indicator_GlobalDataSynchronizationRelevant_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 Lengthwidthheight | |
| 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 | |
| EwmCw_LogisticsUnitOfMeasure_LOGUNIT | Ewm Cw (Logistics Unit Of Measure) | |
| EwmCw_MaterialIsACatchWeightMaterial_CWQREL | Ewm Cw (Material Is A Catch Weight Material) | |
| EwmCw_CatchWeightProfileForEnteringCwQuantity_CWQPROC | Ewm Cw (Catch Weight Profile For Entering Cw Quantity) | |
| EwmCatchWeightToleranceGroupForEwm_CWQTOLGR | Ewm Catch Weight Tolerance Group For Ewm | |
| AdjustmentProfile_ADPROF | Adjustment Profile | |
| IdForAnIntellectualProperty_CrmProduct_IPMIPPRODUCT | Id For An Intellectual Property (Crm Product) | |
| VariantPriceAllowed_ForMaterialMaster_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 |