MaterialsBatchMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialsBatchMD
Descripción general
Esta vista proporciona una descripción general completa de los datos relacionados con lotes para materiales en sistemas SAP. Combina información de varias tablas para ofrecer una vista consolidada de las características, el estado y el historial de los lotes.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| mch1 | Datos de cabecera de lote de material |
Casos de uso clave
- Seguimiento de información específica del lote para la gestión de inventario y el control de calidad.
- Análisis de la disponibilidad del lote, la vida útil y los cambios de estado a lo largo del tiempo.
- Identificación de lotes asociados con proveedores, plantas de producción y materiales específicos.
- Supervisión de los detalles de clasificación y certificación de lotes.
Lógica de consulta
La vista selecciona todas las columnas de la tabla mch1, que contiene información detallada sobre los lotes de materiales en los sistemas SAP.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| MB51 | Mostrar lote |
| MB52 | Cambiar lote |
| MB53 | Lista de uso del lote |
| MB54 | Descripción general del stock del lote |
| MB55 | Valoración del lote |
| MB56 | Análisis de entrada/salida del lote |
| MB58 | Características del lote |
| MB59 | Clasificación del lote |
| MB60 | Números de serie del lote |
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 | |
| BatchNumber_CHARG | Batch Number | |
| DeletionFlagForAllDataInABatch_LVORM | Deletion Flag For All Data In A Batch | |
| CreatedOn_ERSDA | Created On | |
| NameOfPersonWhoCreatedTheObject_ERNAM | Name Of Person Who Created The Object | |
| NameOfPersonWhoChangedObject_AENAM | Name Of Person Who Changed Object | |
| DateOfLastChange_LAEDA | Date Of Last Change | |
| AvailabilityDate_VERAB | Availability Date | |
| ShelfLifeExpirationOrBestBeforeDate_VFDAT | Shelf Life Expiration Or Best Before Date | |
| BatchStatusKey_ZUSCH | Batch Status Key | |
| BatchInRestrictedUseStock_ZUSTD | Batch In Restricted Use Stock | |
| DateOfLastStatusChange_ZAEDT | Date Of Last Status Change | |
| VendorsAccountNumber_LIFNR | Vendors Account Number | |
| SupplierBatchNumber_LICHA | Supplier Batch Number | |
| OriginalBatchNumber_VLCHA | Original Batch Number | |
| OriginalPlant_VLWRK | Original Plant | |
| OriginalMaterial_VLMAT | Original Material | |
| BatchID_BatchID | Batch ID | |
| SingleUnitBatchIndicator_XPCBT | Single Unit Batch Indicator | |
| UnitOfIssueForBatch_CHAME | Unit Of Issue For Batch | |
| DateOfLastGoodsReceipt_LWEDT | Date Of Last Goods Receipt | |
| DateForFreeUse_FVDT1 | Date For Free Use | |
| DateForFreeUse_FVDT2 | Date For Free Use | |
| DateForFreeUse_FVDT3 | Date For Free Use | |
| DateForFreeUse_FVDT4 | Date For Free Use | |
| DateForFreeUse_FVDT5 | Date For Free Use | |
| DateForFreeUse_FVDT6 | Date For Free Use | |
| CountryOfOriginOfMaterial_HERKL | Country Of Origin Of Material | |
| RegionOfOriginOfMaterial_HERKL | Region Of Origin Of Material | |
| MaterialGroupForIntrastat_MTVER | Material Group For Intrastat | |
| NextInspectionDate_QNDAT | Next Inspection Date | |
| DateOfManufacture_HSDAT | Date Of Manufacture | |
| InternalObjectNumberBatchClassification_CUOBJ_BM | Internal Object Number Batch Classification | |
| BatchIsNoLongerActive_DEACT_BM | Batch Is No Longer Active | |
| TypeOfBatch_BATCH_TYPE | Type Of Batch | |
| StockSegment_SGT_SCAT | Stock Segment | |
| DeprecatedDoNotUse_ERSDA_TMSTP | Deprecated Do Not Use | |
| DeprecatedDoNotUse_ERSDA_TZ_SYS | Deprecated Do Not Use | |
| DeprecatedDoNotUse_ERSDA_TZ_USR | Deprecated Do Not Use | |
| DateOfCertification_ZFDAT | Date Of Certification | |
| CreatedOnTimestamp_CREATION_DATETIME | Created On Timestamp | |
| LastChangeTimestamp_LASTCHANGE_DATETIME | Last Change Timestamp | |
| SerializationType_STTPEC_SERTYPE | Serialization Type | |
| BatchProductionPlant_STTPEC_PLANT | Batch Production Plant | |
| SynchronizationTimeStamp_STTPEC_SYNCTIME | Synchronization Time Stamp | |
| SynchronizationActive_STTPEC_SYNCACT | Synchronization Active | |
| SeasonYear_FSH_SEASON_YEAR | Season Year | |
| Season_FSH_SEASON | Season | |
| FashionCollection_FSH_COLLECTION | Fashion Collection | |
| FashionTheme_FSH_THEME | Fashion Theme |