P_ID_StRpVATOutGLAccount

DDL: P_ID_STRPVATOUTGLACCOUNT Type: view_entity COMPOSITE
7 Fields 2 Data Sources

P_ID_StRpVATOutGLAccount is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_GLAccountText, I_OperationalAcctgDocItem) and exposes 7 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxCode.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountText _GLAccountsText inner
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Parameters (3)

NameTypeDefault
P_CompanyCode fis_bukrs
P_FromFiscalYear gjahr
P_ToFiscalYear gjahr

Annotations (4)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY TaxCode I_OperationalAcctgDocItem TaxCode Tax Code
DocumentItemText I_OperationalAcctgDocItem DocumentItemText Text
GLAccountName I_GLAccountText GLAccountName Short Text
AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item

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_ID_StRpVATOutGLAccount.
-- 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_CompanyCode : fis_bukrs, P_FromFiscalYear : gjahr, P_ToFiscalYear : gjahr

CREATE VIEW P_ID_StRpVATOutGLAccount AS
SELECT
  I_OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  I_OperationalAcctgDocItem.TaxCode AS TaxCode,
  I_OperationalAcctgDocItem.DocumentItemText AS DocumentItemText,
  _GLAccountsText.GLAccountName AS GLAccountName,
  I_OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem
FROM I_OperationalAcctgDocItem
INNER JOIN I_GLAccountText AS _GLAccountsText ON /* join condition not captured in parsed metadata */
;

Learn More