MaterialsBatchMD
Archivo SQL de origen: Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialsBatchMD
Descripción general
Esta vista de informes proporciona información sobre lotes en sistemas SAP. Incluye datos sobre el estado del lote, disponibilidad, vida útil y otros atributos relevantes.
Fuentes de datos
| Tabla/vista de origen | Descripción |
|---|---|
| mch1 | Datos Maestros de Lote |
Casos de uso clave
- Monitorizar el estado y la disponibilidad del lote
- Rastrear los cambios y el historial del lote
- Analizar datos relacionados con el lote para informes y análisis
Lógica de consulta
La vista selecciona todas las columnas de la tabla mch1.
Posible relación con SAP Transactions
| Codigo de transacción | Descripción de la transacción |
|---|---|
| MB51 | Mostrar Lote |
| MB52 | Cambiar Lote |
| MB53 | Mostrar Lista de Dónde se Usó el Lote |
| MB54 | Mostrar Visión General del Stock del Lote |
| MB55 | Mostrar Resultados de la Inspección del Lote |
| MB56 | Mostrar Clasificación del Lote |
| MB57 | Mostrar Valoraciones del Lote |
| MB58 | Mostrar Asignación de Cuenta del Lote |
| MB59 | Mostrar 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 | |
| NameOfPersonWhoChangedTheObject_AENAM | Name Of Person Who Changed The Object | |
| DateOfLastChange_LAEDA | Date Of Last Change | |
| AvailabilityChange_VERAB | Availability Change | |
| ShelfLifeExpiration_VFDAT | Shelf Life Expiration | |
| BatchStatusKey_ZUSCH | Batch Status Key | |
| BatchInRestrictedUseStock_ZUSTD | Batch In Restricted Use Stock | |
| DateOfLastStatusChange_ZAEDT | Date Of Last Status Change | |
| VendorsAccountNumber_LIFNR | Vendors Account Number | |
| VendorBatchNumber_LICHA | Vendor Batch Number | |
| OriginalBatchNumber_VLCHA | Original Batch Number | |
| OriginalPlant_VLWRK | Original Plant | |
| OriginalMaterial_VLMAT | Original Material | |
| UnitOfIssueForBatch_CHAME | Unit Of Issue For Batch | |
| DateOfLastGoodsReceipt_LWEDT | Date Of Last Goods Receipt | |
| DateForFreeUse1_FVDT1 | Date For Free Use 1 | |
| DateForFreeUse1_FVDT2 | Date For Free Use 1 | |
| DateForFreeUse1_FVDT3 | Date For Free Use 1 | |
| DateForFreeUse1_FVDT4 | Date For Free Use 1 | |
| DateForFreeUse1_FVDT5 | Date For Free Use 1 | |
| DateForFreeUse1_FVDT6 | Date For Free Use 1 | |
| CountryOfOriginOfMaterial_HERKL | Country Of Origin Of Material | |
| RegionOfOriginOfMaterial_HERKL | Region Of Origin Of Material | |
| MaterialGroupExportForForeignTrade_MTVER | Material Group Export For Foreign Trade | |
| NextInspectionDate_QNDAT | Next Inspection Date | |
| DateOfManufacture_HSDAT | Date Of Manufacture | |
| InternalObjectNumber_BatchClassification_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 | |
| UTCTimeStampInShortForm_ERSDA_TMSTP | UTC Time Stamp In Short Form | |
| TimeZone_ERSDA_TZ_SYS | Time Zone | |
| TimeZone_ERSDA_TZ_USR | Time Zone | |
| CertificationDate_ZFDAT | Certification Date | |
| SeasonYear_FSH_SEASON_YEAR | Season Year | |
| Season_FSH_SEASON | Season | |
| FashionCollection_FSH_COLLECTION | Fashion Collection | |
| FashionTheme_FSH_THEME | Fashion Theme |