MaterialTypesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialTypesMD
Overview
This reporting view provides information about material types in SAP systems.
Data Sources
| Source Table/View | Description |
|---|---|
| T134 | Material Type Master Data |
| T134T | Material Type Texts |
Key Use Cases
- Material type management
- Material master data maintenance
- Inventory management
- Purchasing and sales
Query Logic
The view joins the T134 and T134T tables on the MANDT and MTART fields to retrieve material type data and corresponding texts.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM01 | Create Material Master |
| MM02 | Change Material Master |
| MM03 | Display Material Master |
| MM17 | Create Material Type |
| MM18 | Change Material Type |
| MM19 | Display Material Type |
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 |