LedgersMD

Source SQL File - Google Cloud Cortex Data Foundation

Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - LedgersMD

Overview

This view provides a comprehensive overview of the ledger settings in SAP systems. It combines data from the T881 and T881T tables to provide key information about each ledger, including its client, currency, company currency role, logical system, controlling valuation type, leading ledger flag, ledger application, ledger subapplication, and additional currency roles.

Data Sources

Source Table/View	Description
t881	Ledger Master Data
t881t	Ledger Master Data: Texts

Key Use Cases

Analyzing ledger configurations across different SAP systems
Identifying ledgers used for specific purposes, such as leading ledgers or controlling ledgers
Understanding the currency and valuation settings for each ledger
Reporting on the use of additional currencies in different ledgers

Query Logic

The view joins the T881 and T881T tables on the RLDNR (ledger number) and MANDT (client) fields to combine data from both tables. The resulting view includes all fields from the T881 table and the LANGU (language) and NAME (ledger name) fields from the T881T table.

Possible relation with SAP Transactions

Transaction Code	Transaction Description
FS00	Create Ledger
FS01	Change Ledger
FS02	Display Ledger
FS03	Delete Ledger

Data Lineage

Under Development

Table/View Fields

Field	Field Description	Description in SAP Dictionary (Comming soon)
Client_MANDT	Client
Ledger_RLDNR	Ledger
Currency_GCURR	Currency
CompanyCurrencyRole_CLASS	Company Currency Role
LogicalSystem_LOGSYS	Logical System
ControllingValuationType_VALUTYP	Controlling Valuation Type
LeadingLedgerFlag_XLEADING	Leading Ledger Flag
LedgerApplication_APPL	Ledger Application
LedgerSubapplication_SUBAPPL	Ledger Subapplication
AddlCurrRole1_CURT1	Additional Currency Role 1
AddlCurrRole2_CURT2	Additional Currency Role 2
AddlCurrRole3_CURT3	Additional Currency Role 3
Language_LANGU	Language
Name	Name