P_CN_CADEReportStructure

DDL: P_CN_CADEREPORTSTRUCTURE SQL: PCADEREPORTSTRUC Type: view COMPOSITE Package: GLO_FIN_CADE_CN
15 Fields 3 Data Sources

CADE - Report Structure

P_CN_CADEReportStructure is a Composite CDS View that provides data about "CADE - Report Structure" in SAP S/4HANA. It reads from 3 data sources (I_CN_CADEReportSetWithPeriod, P_CN_CADE_ManualEntry, I_CN_FinStmntFormStrucLine) and exposes 15 fields with key fields CompanyCode, CN_CADENatlStdRelVersion, Ledger, CN_CADEReport, FinStmntFormStruc. Part of development package GLO_FIN_CADE_CN.

Data Sources (3)

SourceAliasJoin Type
I_CN_CADEReportSetWithPeriod I_CN_CADEReportSetWithPeriod inner
P_CN_CADE_ManualEntry ManualEntry left_outer
I_CN_FinStmntFormStrucLine ReportStructure from

Parameters (7)

NameTypeDefault
P_CompanyCode fis_bukrs
P_Ledger fis_rldnr
P_FiscalYear fis_gjahr
P_FromFiscalPeriod fins_fiscalperiod
P_ToFiscalPeriod fins_fiscalperiod
P_IsSpecialPeriod xfeld
P_Language sylangu

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PCADEREPORTSTRUC view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
KEY CN_CADENatlStdRelVersion ReportSet CN_CADENatlStdRelVersion
KEY Ledger
KEY CN_CADEReport ReportSet CN_CADEReport
KEY FinStmntFormStruc I_CN_FinStmntFormStrucLine FinStmntFormStruc Form Str. Key
KEY FinancialStatementVariant I_CN_FinStmntFormStrucLine FinancialStatementVariant Version
KEY FinStmntFormStrucLineNmbr I_CN_FinStmntFormStrucLine FinStmntFormStrucLineNmbr Source Select. Index
KEY FiscalYear ReportSet FiscalYear G/L Fiscal Year
KEY FiscalYearPeriod ReportSet FiscalYearPeriod Period/Year
FinStmntFormStrucItemSign I_CN_FinStmntFormStrucLine FinStmntFormStrucItemSign Sign
DocumentReferenceID I_CN_FinStmntFormStrucLine DocumentReferenceID Reference
FinStmntFormStrucItemType I_CN_FinStmntFormStrucLine FinStmntFormStrucItemType Type of line
CN_CADEReportType ReportSet CN_CADEReportType
Currency ReportSet Currency Valuation Crcy
AmountInReportingCurrency P_CN_CADE_ManualEntry AmountInCompanyCodeCurrency Local Crcy Amt

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_CN_CADEReportStructure.
-- 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: PCADEREPORTSTRUC
-- Parameters: P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_FiscalYear : fis_gjahr, P_FromFiscalPeriod : fins_fiscalperiod, P_ToFiscalPeriod : fins_fiscalperiod, P_IsSpecialPeriod : xfeld, P_Language : sylangu

CREATE VIEW P_CN_CADEReportStructure AS
SELECT
  :P_CompanyCode AS CompanyCode,
  ReportSet.CN_CADENatlStdRelVersion AS CN_CADENatlStdRelVersion,
  :P_Ledger AS Ledger,
  ReportSet.CN_CADEReport AS CN_CADEReport,
  ReportStructure.FinStmntFormStruc AS FinStmntFormStruc,
  ReportStructure.FinancialStatementVariant AS FinancialStatementVariant,
  ReportStructure.FinStmntFormStrucLineNmbr AS FinStmntFormStrucLineNmbr,
  ReportSet.FiscalYear AS FiscalYear,
  ReportSet.FiscalYearPeriod AS FiscalYearPeriod,
  ReportStructure.FinStmntFormStrucItemSign AS FinStmntFormStrucItemSign,
  ReportStructure.DocumentReferenceID AS DocumentReferenceID,
  ReportStructure.FinStmntFormStrucItemType AS FinStmntFormStrucItemType,
  ReportSet.CN_CADEReportType AS CN_CADEReportType,
  ReportSet.Currency AS Currency,
  ManualEntry.AmountInCompanyCodeCurrency AS AmountInReportingCurrency
FROM I_CN_FinStmntFormStrucLine AS ReportStructure
INNER JOIN I_CN_CADEReportSetWithPeriod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_CN_CADE_ManualEntry AS ManualEntry ON /* join condition not captured in parsed metadata */
;

Learn More