StorageLocationsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - StorageLocationsMD
Overview
This reporting view provides information about storage locations in SAP systems.
Data Sources
| Source Table/View | Description |
|---|---|
| t001l | Table containing storage location master data |
Key Use Cases
- Retrieve storage location details for reporting purposes
- Analyze inventory levels and movements across storage locations
- Identify storage locations with specific characteristics, such as negative stock allowance or freezing book inventory balance
Query Logic
The query selects specific fields from the t001l table, including client, plant, storage location, and storage location text.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM01 | Create Storage Location |
| MM02 | Change Storage Location |
| MM03 | Display Storage Location |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| Plant_WERKS | Plant | |
| StorageLocation_LGORT | Storage Location | |
| StorageLocationText_LGOBE | Storage Location Text |