BatchesMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - BatchesMD
Overview
This reporting view provides information about batches in SAP systems. It includes data such as client, material number, batch number, plant, creation date, name of person who created the object, name of person who changed the object, date of last change, availability date, shelf life expiration, date of manufacture, batch status key, batch in restricted use stock, and date of last status change.
Data Sources
| Source Table/View | Description |
|---|---|
| mcha | Batch Master Data |
Key Use Cases
- Reporting on batch-related data
- Analysis of batch status and availability
- Tracking changes to batches over time
Query Logic
The view selects specific columns from the mcha table, which contains batch master data in SAP systems.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MB51 | Display Batch Stock |
| MB52 | Display Batch Where-Used List |
| MB53 | Display Batch Inspection Results |
| MB54 | Display Batch Classification |
| MB55 | Display Batch Valuations |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_Mandt | Client Mandt | |
| MaterialNumber_MATNR | Material Number | |
| BatchNumber_CHARG | Batch Number | |
| Plant_WERKS | Plant | |
| CreationDate_ERSDA | Creation Date | |
| 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 | |
| ShelfLifeExpiration_VFDAT | Shelf Life Expiration | |
| DateOfManufacture_HSDAT | Date Of Manufacture | |
| BatchStatusKey_ZUSCH | Batch Status Key | |
| BatchInRestricted_UseStock_ZUSTD | Batch In Restricted Use Stock | |
| DateOfLastStatusChange_ZAEDT | Date Of Last Status Change |