MaterialLedger

Source SQL File - Google Cloud Cortex Data Foundation

Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialLedger

Overview

This reporting view provides information about material ledger data in SAP S/4HANA systems. It combines data from the CKMLHD and CKMLCR tables, providing key information such as material number, valuation type, valuation area, price unit, posting period, fiscal year, price control indicator, standard cost, value of total valuated stock, moving average price, and currency key.

Data Sources

Source Table/View	Description
ckmlhd	Material Ledger Header Data
ckmlcr	Material Ledger Line Item Data
t001k	Company Code Currency Table
t001	Currency Table
currency_decimal	Currency Decimal Table

Key Use Cases

Analyzing material valuation data
Reporting on inventory values
Monitoring stock movements and costs

Query Logic

The query joins the CKMLHD and CKMLCR tables on the MANDT and KALNR fields. It then joins the T001K and T001 tables to retrieve the currency key. The CURRENCY_DECIMAL table is used to convert the currency values to a consistent format. The query filters the results to include only records with CURTP = '10'.

Possible relation with SAP Transactions

Transaction Code	Transaction Description
MM03	Display Material Master
MB51	Material Document List
MB52	Stock Overview: List
FBL3N	Display Line Items: G/L Account

Data Lineage

Under Development

Table/View Fields

Field	Field Description	Description in SAP Dictionary (Comming soon)
Client_MANDT	Client ID
MaterialNumber_MATNR	Material Number
ValuationType_BWTAR	Valuation Type
ValuationArea_BWKEY	Valuation Area
PriceUnit_PEINH	Price Unit
PostingPeriod	Posting Period
FiscalYear	Fiscal Year
PriceControlIndicator_VPRSV	Price Control Indicator
StandardCost_STPRS	Standard Cost
ValueOfTotalValuatedStock_SALK3	Value of Total Valuated Stock
MovingAveragePrice	Moving Average Price
CurrencyKey_WAERS	Currency Key