I_LedgerCoCode

DDL: I_LEDGERCOCODE Type: view_entity COMPOSITE Package: FINS_LEDGER_VDM
14 Fields 1 Data Sources 6 Associations

Company Code Settings for Ledger

I_LedgerCoCode (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_LedgerCoCode is a Composite CDS View that provides data about "Company Code Settings for Ledger" in SAP S/4HANA. It reads from 1 data source (I_LedgerCompanyCodeCrcyRoles) and exposes 14 fields with key fields Ledger, CompanyCode. It has 6 associations to related views. Part of development package FINS_LEDGER_VDM.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-A-2CL
CapabilitiesData Source in SQL Select,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the settings for active ledger and company code combinations. It combines ledger-company code relationships with essential master data attributes such as chart of accounts, controlling area, fiscal year variant, and currency settings. The view serves as a reference point for understanding how company codes are configured within different ledgers and provides access to related organizational and accounting configuration data.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which company codes are assigned to a specific ledger and what are their basic organizational details (name, city)?</p></li> <li><p>What chart of accounts, controlling area, and fiscal year variant are configured for each company code-ledger combination?</p></li> <li><p>What is the company code currency assigned to each company code operating within a particular ledger?</p></li> <li><p>How can I navigate from a ledger-company code combination to related master data such as fiscal year variants or currency definitions?</p></li> <li><p>Which company codes share the same accounting configuration settings (chart of accounts, controlling area) across different ledgers?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.chartofaccounts = _ChartOfAccounts.ChartOfAccounts
[0..1] I_ControllingArea _ControllingArea $projection.controllingarea = _ControllingArea.ControllingArea
[1..1] I_FiscalYearVariant _FiscalYearVariant $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
[1..1] I_Currency _CompanyCodeCurrency $projection.currency = _CompanyCodeCurrency.Currency

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Company Code Settings for Ledger view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_LedgerCompanyCodeCrcyRoles Ledger Ledger in General Ledger Accounting
KEY CompanyCode I_LedgerCompanyCodeCrcyRoles CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Name of Company Code or Company
ControllingArea _CompanyCode ControllingArea Controlling Area
ChartOfAccounts _CompanyCode ChartOfAccounts Chart of Accounts
CityName _CompanyCode CityName Name
Currency _CompanyCode Currency Valuation Crcy
FiscalYearVariant I_LedgerCompanyCodeCrcyRoles FiscalYearVariant Fiscal Year Variant
_CompanyCode _CompanyCode
_Ledger _Ledger
_ChartOfAccounts _ChartOfAccounts
_ControllingArea _ControllingArea
_FiscalYearVariant _FiscalYearVariant
_CompanyCodeCurrency _CompanyCodeCurrency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_LedgerCoCode.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_LedgerCoCode AS
SELECT
  I_LedgerCompanyCodeCrcyRoles.Ledger AS Ledger,
  I_LedgerCompanyCodeCrcyRoles.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCode.ControllingArea AS ControllingArea,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _CompanyCode.CityName AS CityName,
  _CompanyCode.Currency AS Currency,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant
FROM I_LedgerCompanyCodeCrcyRoles
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON chartofaccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON controllingarea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON currency = _CompanyCodeCurrency.Currency  -- association [1..1]
;

Learn More