LedgersMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - LedgersMD
Overview
This reporting view provides information about SAP ledgers, including their 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 table |
| t881t | Ledger text table |
Key Use Cases
- Analyzing ledger configurations
- Identifying ledgers with specific currency or valuation type
- Understanding the relationships between ledgers and logical systems
Query Logic
The view joins the t881 and t881t tables on the rldnr and mandt fields to retrieve both master data and text descriptions for each ledger.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FS00 | Create/Change Ledger |
| FS10N | Display 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 |