C_RO_GLAccountLineItemC

DDL: C_RO_GLACCOUNTLINEITEMC Type: view_entity CONSUMPTION
35 Fields 1 Data Sources 2 Associations

Romania G/L Account Line Items - Cube

C_RO_GLAccountLineItemC is a Consumption CDS View (Cube) that provides data about "Romania G/L Account Line Items - Cube" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemRawData) and exposes 35 fields with key fields CompanyCode, SourceLedger, AccountingDocument, LedgerGLLineItem, FiscalYear. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemRawData AccountingDocument from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StRpJournalEntryLog _StRpLog $projection.CompanyCode = _StRpLog.CompanyCode and $projection.AccountingDocument = _StRpLog.AccountingDocument and $projection.FiscalYear = _StRpLog.FiscalYear
[0..1] I_OperationalAcctgDocItem _BsegItem $projection.CompanyCode = _BsegItem.CompanyCode and $projection.AccountingDocument = _BsegItem.AccountingDocument and $projection.FiscalYear = _BsegItem.FiscalYear and $projection.AccountingDocumentItem = _BsegItem.AccountingDocumentItem

Annotations (10)

NameValueLevelField
EndUserText.label Romania G/L Account Line Items - Cube view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
Analytics.internalName #LOCAL view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY SourceLedger I_GLAccountLineItemRawData SourceLedger Source Ledger
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY StatryRptCategory _StRpLog StatryRptCategory Report ID
KEY StatryRptRunID _StRpLog StatryRptRunID Report Run ID
KEY StatryRptgEntity _StRpLog StatryRptgEntity Reporting Entity
ReferenceDocumentItem I_GLAccountLineItemRawData ReferenceDocumentItem Reference item
DocumentDate I_GLAccountLineItemRawData DocumentDate Journal Entry Date
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR
FiscalPeriod I_GLAccountLineItemRawData FiscalPeriod Tax period
TaxCode I_GLAccountLineItemRawData TaxCode Tax Code
FinancialAccountType I_GLAccountLineItemRawData FinancialAccountType Fin. Account Type
Supplierendasbu_partnerasBusinessPartner
GLAccount I_GLAccountLineItemRawData GLAccount General Ledger
GLAccountLongName
DebitCreditCode I_GLAccountLineItemRawData DebitCreditCode Single-Character Flag
AccountingDocumentType I_GLAccountLineItemRawData AccountingDocumentType Journal Entry Type
TransactionCurrency I_GLAccountLineItemRawData TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_GLAccountLineItemRawData AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency I_GLAccountLineItemRawData CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_GLAccountLineItemRawData AmountInCompanyCodeCurrency Local Crcy Amt
ClearingAccountingDocument I_GLAccountLineItemRawData ClearingAccountingDocument Clearing Journal Entry
AccountingDocumentItem I_GLAccountLineItemRawData AccountingDocumentItem Posting View Item
TransactionTypeDetermination I_GLAccountLineItemRawData TransactionTypeDetermination Transaction Key
SpecialGLCode I_GLAccountLineItemRawData SpecialGLCode Special G/L Ind
AccountingDocumentItemType _BsegItem AccountingDocumentItemType Line Item ID
IsNegativePosting _BsegItem IsNegativePosting Negative Posting
AlternativeGLAccount AltAcct AlternativeGLAccount Group Account
AlternativeGLAccountLongName AltAcctText GLAccountLongName Long Text
AccountingDocumentHeaderText
DocumentReferenceID
AccountingDocumentTypeName
ReferenceDocumentType

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_RO_GLAccountLineItemC.
-- 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 C_RO_GLAccountLineItemC AS
SELECT
  AccountingDocument.CompanyCode AS CompanyCode,
  AccountingDocument.SourceLedger AS SourceLedger,
  AccountingDocument.AccountingDocument AS AccountingDocument,
  AccountingDocument.LedgerGLLineItem AS LedgerGLLineItem,
  AccountingDocument.FiscalYear AS FiscalYear,
  _StRpLog.StatryRptCategory AS StatryRptCategory,
  _StRpLog.StatryRptRunID AS StatryRptRunID,
  _StRpLog.StatryRptgEntity AS StatryRptgEntity,
  AccountingDocument.ReferenceDocumentItem AS ReferenceDocumentItem,
  AccountingDocument.DocumentDate AS DocumentDate,
  AccountingDocument.PostingDate AS PostingDate,
  AccountingDocument.FiscalPeriod AS FiscalPeriod,
  AccountingDocument.TaxCode AS TaxCode,
  AccountingDocument.FinancialAccountType AS FinancialAccountType,
  cast( case when AccountingDocument.Customer is not initial then AccountingDocument.Customer else AccountingDocument.Supplier end as bu_partner ) as BusinessPartner AS Supplierendasbu_partnerasBusinessPartner,
  AccountingDocument.GLAccount AS GLAccount,
  AccountingDocument._GLAccountInChartOfAccounts._Text[1: Language = $session.system_language ].GLAccountLongName AS GLAccountLongName,
  AccountingDocument.DebitCreditCode AS DebitCreditCode,
  AccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  AccountingDocument.TransactionCurrency AS TransactionCurrency,
  AccountingDocument.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  AccountingDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  AccountingDocument.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  AccountingDocument.ClearingAccountingDocument AS ClearingAccountingDocument,
  AccountingDocument.AccountingDocumentItem AS AccountingDocumentItem,
  AccountingDocument.TransactionTypeDetermination AS TransactionTypeDetermination,
  AccountingDocument.SpecialGLCode AS SpecialGLCode,
  _BsegItem.AccountingDocumentItemType AS AccountingDocumentItemType,
  _BsegItem.IsNegativePosting AS IsNegativePosting,
  AltAcct.AlternativeGLAccount AS AlternativeGLAccount,
  AltAcctText.GLAccountLongName AS AlternativeGLAccountLongName,
  AccountingDocument._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  AccountingDocument._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  AccountingDocument._AccountingDocumentType._Text[1: Language = $session.system_language ].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  AccountingDocument._JournalEntry.ReferenceDocumentType AS ReferenceDocumentType
FROM I_GLAccountLineItemRawData AS AccountingDocument
LEFT OUTER JOIN I_StRpJournalEntryLog AS _StRpLog ON CompanyCode = _StRpLog.CompanyCode AND AccountingDocument = _StRpLog.AccountingDocument AND FiscalYear = _StRpLog.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _BsegItem ON CompanyCode = _BsegItem.CompanyCode AND AccountingDocument = _BsegItem.AccountingDocument AND FiscalYear = _BsegItem.FiscalYear AND AccountingDocumentItem = _BsegItem.AccountingDocumentItem  -- association [0..1]
;

Learn More