I_StRpAccountingDocumentItmC

DDL: I_STRPACCOUNTINGDOCUMENTITMC SQL: ISRACCDOCITMC Type: view COMPOSITE
19 Fields 2 Data Sources

Accounting Document Item Cube for Statutory Reporting

I_StRpAccountingDocumentItmC is a Composite CDS View (Cube) that provides data about "Accounting Document Item Cube for Statutory Reporting" in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_StRpJournalEntryLog) and exposes 19 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem acctdocitm from
I_StRpJournalEntryLog ReportedItemsLog inner

Parameters (3)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISRACCDOCITMC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accounting Document Item Cube for Statutory Reporting view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Metadata.allowExtensions true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_StRpJournalEntryLog CompanyCode Receiver Company Code
KEY AccountingDocument I_StRpJournalEntryLog AccountingDocument Journal Entry
KEY FiscalYear I_StRpJournalEntryLog FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
OriginRefDocBusObjTypeName
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
DocumentDate I_OperationalAcctgDocItem DocumentDate Journal Entry Date
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
GLAccountName
SupplierNameendasBusinessPartnerName1
OriginalReferenceDocument I_OperationalAcctgDocItem OriginalReferenceDocument Reference Key
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AdditionalCurrency1 I_OperationalAcctgDocItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_OperationalAcctgDocItem AdditionalCurrency2 Local curr. 3
DebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
AccountingDocumentTypeName
DocumentItemText I_OperationalAcctgDocItem DocumentItemText Text

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_StRpAccountingDocumentItmC.
-- 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.
-- SQL view name: ISRACCDOCITMC
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW I_StRpAccountingDocumentItmC AS
SELECT
  ReportedItemsLog.CompanyCode AS CompanyCode,
  ReportedItemsLog.AccountingDocument AS AccountingDocument,
  ReportedItemsLog.FiscalYear AS FiscalYear,
  acctdocitm.AccountingDocumentItem AS AccountingDocumentItem,
  concat(concat(ReportedItemsLog.CompanyCode, ReportedItemsLog.AccountingDocument),ReportedItemsLog.FiscalYear) AS OriginRefDocBusObjTypeName,
  acctdocitm.PostingDate AS PostingDate,
  acctdocitm.DocumentDate AS DocumentDate,
  acctdocitm.GLAccount AS GLAccount,
  _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language ].GLAccountName AS GLAccountName,
  case FinancialAccountType when 'D' then _Customer.CustomerName when 'K' then _Supplier.SupplierName end as BusinessPartnerName1 AS SupplierNameendasBusinessPartnerName1,
  acctdocitm.OriginalReferenceDocument AS OriginalReferenceDocument,
  acctdocitm.FinancialAccountType AS FinancialAccountType,
  acctdocitm.TransactionCurrency AS TransactionCurrency,
  acctdocitm.CompanyCodeCurrency AS CompanyCodeCurrency,
  acctdocitm.AdditionalCurrency1 AS AdditionalCurrency1,
  acctdocitm.AdditionalCurrency2 AS AdditionalCurrency2,
  acctdocitm.DebitCreditCode AS DebitCreditCode,
  acctdocitm._AccountingDocumentType._Text[1: Language = $session.system_language ].AccountingDocumentTypeName AS AccountingDocumentTypeName,
  acctdocitm.DocumentItemText AS DocumentItemText
FROM I_OperationalAcctgDocItem AS acctdocitm
INNER JOIN I_StRpJournalEntryLog AS ReportedItemsLog ON /* join condition not captured in parsed metadata */
;

Learn More