P_SI_StstcsFinAccount

DDL: P_SI_STSTCSFINACCOUNT Type: view_entity COMPOSITE
27 Fields 2 Data Sources 3 Associations

Slovenian SFR report

P_SI_StstcsFinAccount is a Composite CDS View that provides data about "Slovenian SFR report" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItem, I_StRpJournalEntryLog) and exposes 27 fields with key fields SourceLedger, Ledger, CompanyCode, AccountingDocument, FiscalYear. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItem GLAccountLineItem from
I_StRpJournalEntryLog StRpJournalEntryLog inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_SI_StatFinRepAcctgCstmzg _Customizing _Customizing.CompanyCode = GLAccountLineItem.CompanyCode and _Customizing.FromGLAccount <= GLAccountLineItem.GLAccount and _Customizing.ToGLAccount >= GLAccountLineItem.GLAccount
[0..1] I_SI_CntrlBkRptgPrtnAssignment _CustomerFinSector _CustomerFinSector.CompanyCode = GLAccountLineItem.CompanyCode and ( _CustomerFinSector.Customer = GLAccountLineItem.Customer and GLAccountLineItem.Customer is not initial and GLAccountLineItem.Customer is not null )
[0..1] I_SI_CntrlBkRptgPrtnAssignment _SupplierFinSector _SupplierFinSector.CompanyCode = GLAccountLineItem.CompanyCode and ( _SupplierFinSector.Supplier = GLAccountLineItem.Supplier and GLAccountLineItem.Supplier is not initial and GLAccountLineItem.Supplier is not null )

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Slovenian SFR report view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_GLAccountLineItem SourceLedger Source Ledger
KEY Ledger I_GLAccountLineItem Ledger Ledger
KEY CompanyCode I_GLAccountLineItem CompanyCode Receiver Company Code
KEY AccountingDocument I_GLAccountLineItem AccountingDocument Journal Entry
KEY FiscalYear I_GLAccountLineItem FiscalYear G/L Fiscal Year
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem Journal Entry Item
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID Report Run ID
AccountingDocumentItem I_GLAccountLineItem AccountingDocumentItem Posting View Item
DebitCreditCode I_GLAccountLineItem DebitCreditCode Single-Character Flag
PostingDate I_GLAccountLineItem PostingDate Posting Date for GR
DocumentDate I_GLAccountLineItem DocumentDate Journal Entry Date
GLAccount I_GLAccountLineItem GLAccount General Ledger
DocumentItemText I_GLAccountLineItem DocumentItemText Text
FinancialAccountType I_GLAccountLineItem FinancialAccountType Fin. Account Type
Customer I_GLAccountLineItem Customer Sold-to Party
CustomerCountry
Supplier I_GLAccountLineItem Supplier Supplier
SupplierCountry
TransactionCurrency I_GLAccountLineItem TransactionCurrency Transaction Currency
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency Local Currency
SI_GLAccountType _Customizing SI_GLAccountType
SI_FinancialInstrument _Customizing SI_FinancialInstrument
Calculation _Customizing Calculation
_Customer I_GLAccountLineItem _Customer
_Supplier I_GLAccountLineItem _Supplier

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 P_SI_StstcsFinAccount.
-- 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 P_SI_StstcsFinAccount AS
SELECT
  GLAccountLineItem.SourceLedger AS SourceLedger,
  GLAccountLineItem.Ledger AS Ledger,
  GLAccountLineItem.CompanyCode AS CompanyCode,
  GLAccountLineItem.AccountingDocument AS AccountingDocument,
  GLAccountLineItem.FiscalYear AS FiscalYear,
  GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  GLAccountLineItem.AccountingDocumentItem AS AccountingDocumentItem,
  GLAccountLineItem.DebitCreditCode AS DebitCreditCode,
  GLAccountLineItem.PostingDate AS PostingDate,
  GLAccountLineItem.DocumentDate AS DocumentDate,
  GLAccountLineItem.GLAccount AS GLAccount,
  GLAccountLineItem.DocumentItemText AS DocumentItemText,
  GLAccountLineItem.FinancialAccountType AS FinancialAccountType,
  GLAccountLineItem.Customer AS Customer,
  GLAccountLineItem._Customer.Country AS CustomerCountry,
  GLAccountLineItem.Supplier AS Supplier,
  GLAccountLineItem._Supplier.Country AS SupplierCountry,
  GLAccountLineItem.TransactionCurrency AS TransactionCurrency,
  GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Customizing.SI_GLAccountType AS SI_GLAccountType,
  _Customizing.SI_FinancialInstrument AS SI_FinancialInstrument,
  _Customizing.Calculation AS Calculation,
  GLAccountLineItem._Customer AS _Customer,
  GLAccountLineItem._Supplier AS _Supplier
FROM I_GLAccountLineItem AS GLAccountLineItem
INNER JOIN I_StRpJournalEntryLog AS StRpJournalEntryLog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SI_StatFinRepAcctgCstmzg AS _Customizing ON _Customizing.CompanyCode = GLAccountLineItem.CompanyCode AND _Customizing.FromGLAccount <= GLAccountLineItem.GLAccount AND _Customizing.ToGLAccount >= GLAccountLineItem.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_SI_CntrlBkRptgPrtnAssignment AS _CustomerFinSector ON _CustomerFinSector.CompanyCode = GLAccountLineItem.CompanyCode AND ( _CustomerFinSector.Customer = GLAccountLineItem.Customer AND GLAccountLineItem.Customer is not initial AND GLAccountLineItem.Customer is not null )  -- association [0..1]
LEFT OUTER JOIN I_SI_CntrlBkRptgPrtnAssignment AS _SupplierFinSector ON _SupplierFinSector.CompanyCode = GLAccountLineItem.CompanyCode AND ( _SupplierFinSector.Supplier = GLAccountLineItem.Supplier AND GLAccountLineItem.Supplier is not initial AND GLAccountLineItem.Supplier is not null )  -- association [0..1]
;

Learn More