MaterialsBatchMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialsBatchMD
Overview
This view provides a comprehensive overview of batch-related data for materials in SAP systems. It combines information from various tables to offer a consolidated view of batch characteristics, status, and history.
Data Sources
| Source Table/View | Description |
|---|---|
| mch1 | Material Batch Header Data |
Key Use Cases
- Tracking batch-specific information for inventory management and quality control.
- Analyzing batch availability, shelf life, and status changes over time.
- Identifying batches associated with specific vendors, production plants, and materials.
- Monitoring batch classification and certification details.
Query Logic
The view selects all columns from the mch1 table, which contains detailed information about material batches in SAP systems.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MB51 | Display Batch |
| MB52 | Change Batch |
| MB53 | Batch Where-Used List |
| MB54 | Batch Stock Overview |
| MB55 | Batch Valuation |
| MB56 | Batch Input/Output Analysis |
| MB58 | Batch Characteristics |
| MB59 | Batch Classification |
| MB60 | Batch Serial Numbers |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| 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 |