MaterialsBatchMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialsBatchMD
Overview
This reporting view provides information about batches in SAP systems. It includes data on batch status, availability, shelf life, and other relevant attributes.
Data Sources
| Source Table/View | Description |
|---|---|
| mch1 | Batch Master Data |
Key Use Cases
- Monitor batch status and availability
- Track batch changes and history
- Analyze batch-related data for reporting and analysis
Query Logic
The view selects all columns from the mch1 table.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MB51 | Display Batch |
| MB52 | Change Batch |
| MB53 | Display Batch Where-Used List |
| MB54 | Display Batch Stock Overview |
| MB55 | Display Batch Inspection Results |
| MB56 | Display Batch Classification |
| MB57 | Display Batch Valuations |
| MB58 | Display Batch Account Assignment |
| MB59 | Display 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 | |
| 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 |