MaterialTypesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialTypesMD
Overview
This reporting view provides information about material types in SAP systems. It combines data from the T134 and T134T tables to provide a comprehensive view of material type attributes, including descriptions, references, and configuration settings.
Data Sources
| Source Table/View | Description |
|---|---|
| T134 | Material Type Attributes |
| T134T | Material Type Descriptions |
Key Use Cases
- Material type management and configuration
- Material master data analysis
- Reporting on material type-related settings and attributes
Query Logic
The view joins the T134 and T134T tables on the MANDT (client) and MTART (material type) fields. It selects a range of attributes from T134, including material type description, reference material type, screen reference, and language key. From T134T, it includes the description of the material type in the specified language.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM01 | Create Material Master |
| MM02 | Change Material Master |
| MM03 | Display Material Master |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| MaterialType_MTART | Material Type | |
| ReferenceMaterialType_MTREF | Reference Material Type | |
| ScreenReferenceDependingOnTheMaterialType_MBREF | Screen Reference Depending On The Material Type | |
| LanguageKey_SPRAS | Language Key | |
| DescriptionOfMaterialType_MTBEZ | Description Of Material Type | |
| FieldReferenceForMaterialMaster_FLREF | Field Reference For Material Master | |
| NumberRange_NUMKI | Number Range | |
| NumberRange_NUMKE | Number Range | |
| ExternalNumberAssignmentWithoutValidation_ENVOP | External Number Assignment Without Validation | |
| ExternalPurchaseOrdersAllowed_BSEXT | External Purchase Orders Allowed | |
| InternalPurchaseOrdersAllowed_BSINT | Internal Purchase Orders Allowed | |
| MaintenanceStatus_PSTAT | Maintenance Status | |
| AccountCategoryReference_KKREF | Account Category Reference | |
| PriceControlIndicator_VPRSV | Price Control Indicator | |
| PriceControlMandatory_KZVPR | Price Control Mandatory | |
| DefaultValueForMaterialItemCategoryGroup_VMTPO | Default Value For Material Item Category Group | |
| MaterialIsCostedWithQuantityStructure_EKALR | Material Is Costed With Quantity Structure | |
| GroupingIndicator_KZGRP | Grouping Indicator | |
| ConfigurableMaterial_KZKFG | Configurable Material | |
| AuthorizationGroupInTheMaterialMaster_BEGRU | Authorization Group In The Material Master | |
| MaterialMasterRecordForAProcess_KZPRC | Material Master Record For A Process | |
| PipelineHandlingMandatory_KZPIP | Pipeline Handling Mandatory | |
| DisplayPriceOnCashRegisterDisplayAndPrintOnReceipt_PRDRU | Display Price On Cash Register Display And Print On Receipt | |
| DisplayMaterialOnCashRegisterDisplay_ARANZ | Display Material On Cash Register Display | |
| MaterialTypeId_WMAKG | Material Type Id | |
| InitialStatusOfANewBatch_IZUST | Initial Status Of A New Batch | |
| TimeInDaysUntilAMaterialIsDeleted_ARDEL | Time In Days Until A Material Is Deleted | |
| ManufacturerPart_KZMPN | Manufacturer Part | |
| CrossPlantMaterialStatus_MSTAE | Cross Plant Material Status | |
| Control__time__OfHistoryRequirement_Material_CCHIS | Control__time__Of History Requirement_Material | |
| ClassType_CTYPE | Class Type | |
| ClassNumber_CLASS | Class Number | |
| BatchCreationControl__automaticmanual___CHNEU | Batch Creation Control__automatic/manual___ | |
| VersionCategory_VTYPE | Version Category | |
| NumberRange_VNUMKI | Number Range | |
| NumberRange_VNUMKE | Number Range | |
| ReturnablePackagingLogisticsIsMandatory_KZRAC | Returnable Packaging Logistics Is Mandatory |