MaterialTypesMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialTypesMD
Descripción general
Esta vista de informes proporciona información sobre tipos de materiales en sistemas SAP. Combina datos de las tablas T134 y T134T para proporcionar una vista integral de atributos de tipo de material, incluyendo descripciones, referencias y ajustes de configuración.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| T134 | Atributos de Tipo de Material |
| T134T | Descripciones de Tipo de Material |
Casos de uso clave
- Administración y configuración de tipo de material
- Análisis de datos maestros de material
- Informes sobre ajustes y atributos relacionados con el tipo de material
Lógica de consulta
La vista une las tablas T134 y T134T en los campos MANDT (cliente) y MTART (tipo de material). Selecciona un rango de atributos de T134, incluyendo descripción de tipo de material, tipo de material de referencia, referencia de pantalla y clave de idioma. De T134T, incluye la descripción del tipo de material en el idioma especificado.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| MM01 | Crear Maestro de Material |
| MM02 | Cambiar Maestro de Material |
| MM03 | Mostrar Maestro de 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 | |
| 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 |