C_CO_AccountBalanceLedgerItem

DDL: C_CO_ACCOUNTBALANCELEDGERITEM Type: view_entity CONSUMPTION
17 Fields 3 Data Sources 1 Associations

Colombia Acct Bal Ledger Item

C_CO_AccountBalanceLedgerItem is a Consumption CDS View that provides data about "Colombia Acct Bal Ledger Item" in SAP S/4HANA. It reads from 3 data sources (I_StRpGLAccountLog, P_StRpTrialBalanceItem, I_StRpJournalEntryHeaderLog) and exposes 17 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, Ledger, CompanyCode. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_StRpGLAccountLog GLAccountLog inner
P_StRpTrialBalanceItem P_StRpTrialBalanceItem from
I_StRpJournalEntryHeaderLog ReportedItemLog inner

Parameters (2)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Currency _ReportingCurrency _ReportingCurrency.Currency = $projection.ReportingCurrency

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Colombia Acct Bal Ledger Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity I_StRpJournalEntryHeaderLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryHeaderLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryHeaderLog StatryRptRunID Report Run ID
KEY Ledger GLAccountBalance Ledger Ledger
KEY CompanyCode GLAccountBalance CompanyCode Receiver Company Code
KEY FiscalYear GLAccountBalance FiscalYear G/L Fiscal Year
KEY GLAccount GLAccountBalance GLAccount General Ledger
ChartOfAccounts GLAccountBalance ChartOfAccounts Node Class
PostingDate GLAccountBalance PostingDate Posting Date for GR
FiscalPeriod GLAccountBalance FiscalPeriod Tax period
ReportingCurrency
CompanyCodeCurrency GLAccountBalance CompanyCodeCurrency Local Currency
StartingBalanceAmtInCoCodeCrcy
DebitAmountInCoCodeCrcy
CreditAmountInCoCodeCrcy
EndingBalanceAmtInCoCodeCrcy
_ReportingCurrency _ReportingCurrency

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 C_CO_AccountBalanceLedgerItem.
-- 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.
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to

CREATE VIEW C_CO_AccountBalanceLedgerItem AS
SELECT
  ReportedItemLog.StatryRptgEntity AS StatryRptgEntity,
  ReportedItemLog.StatryRptCategory AS StatryRptCategory,
  ReportedItemLog.StatryRptRunID AS StatryRptRunID,
  GLAccountBalance.Ledger AS Ledger,
  GLAccountBalance.CompanyCode AS CompanyCode,
  GLAccountBalance.FiscalYear AS FiscalYear,
  GLAccountBalance.GLAccount AS GLAccount,
  GLAccountBalance.ChartOfAccounts AS ChartOfAccounts,
  GLAccountBalance.PostingDate AS PostingDate,
  GLAccountBalance.FiscalPeriod AS FiscalPeriod,
  cast( 'COP' as glo_reporting_currency ) AS ReportingCurrency,
  GLAccountBalance.CompanyCodeCurrency AS CompanyCodeCurrency,
  sum ( GLAccountBalance.StartingBalanceAmtInCoCodeCrcy ) AS StartingBalanceAmtInCoCodeCrcy,
  sum ( GLAccountBalance.DebitAmountInCoCodeCrcy ) AS DebitAmountInCoCodeCrcy,
  sum ( GLAccountBalance.CreditAmountInCoCodeCrcy ) AS CreditAmountInCoCodeCrcy,
  sum ( GLAccountBalance.EndingBalanceAmtInCoCodeCrcy ) AS EndingBalanceAmtInCoCodeCrcy
FROM P_StRpTrialBalanceItem
INNER JOIN I_StRpJournalEntryHeaderLog AS ReportedItemLog ON /* join condition not captured in parsed metadata */
INNER JOIN I_StRpGLAccountLog AS GLAccountLog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON _ReportingCurrency.Currency = ReportingCurrency  -- association [0..1]
;

Learn More