P_FinStmtHierarchyWithCocd

DDL: P_FINSTMTHIERARCHYWITHCOCD SQL: PFSITEMHIERCOCD Type: view BASIC
19 Fields 3 Data Sources

P_FinStmtHierarchyWithCocd is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (I_GLAccountInCompanyCode, I_CompanyCode, P_FinStmtHierarchy) and exposes 19 fields with key fields HierarchyUniqueNodeID, UniqueParentID, versn, ergsl, ktopl.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountInCompanyCode _GLAccountInCompanyCode left_outer
I_CompanyCode I_CompanyCode inner
P_FinStmtHierarchy P_FinStmtHierarchy from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PFSITEMHIERCOCD view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY HierarchyUniqueNodeID P_FinStmtHierarchy HierarchyUniqueNodeID
KEY UniqueParentID P_FinStmtHierarchy UniqueParentID
KEY versn P_FinStmtHierarchy versn Version
KEY ergsl P_FinStmtHierarchy ergsl FS Item
KEY ktopl P_FinStmtHierarchy ktopl G/L Chart of Accounts
KEY bukrs I_CompanyCode CompanyCode Receiver Company Code
KEY saknr P_FinStmtHierarchy saknr G/L Account
KEY fkber P_FinStmtHierarchy fkber Functional Area
type P_FinStmtHierarchy type Worklist Type
Description P_FinStmtHierarchy Description Well Code Des.
MaintenanceLanguage P_FinStmtHierarchy MaintenanceLanguage Maint. Language
id P_FinStmtHierarchy id WorklistID
parent P_FinStmtHierarchy parent UUID
child P_FinStmtHierarchy child ID
nextn P_FinStmtHierarchy nextn ID
stufe P_FinStmtHierarchy stufe Level Number
ergs2 P_FinStmtHierarchy ergs2 Credit Item Key
segment P_FinStmtHierarchy segment Segment number
GLAccount I_GLAccountInCompanyCode GLAccount General Ledger

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_FinStmtHierarchyWithCocd.
-- 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: PFSITEMHIERCOCD

CREATE VIEW P_FinStmtHierarchyWithCocd AS
SELECT
  P_FinStmtHierarchy.HierarchyUniqueNodeID AS HierarchyUniqueNodeID,
  P_FinStmtHierarchy.UniqueParentID AS UniqueParentID,
  P_FinStmtHierarchy.versn AS versn,
  P_FinStmtHierarchy.ergsl AS ergsl,
  P_FinStmtHierarchy.ktopl AS ktopl,
  I_CompanyCode.CompanyCode AS bukrs,
  P_FinStmtHierarchy.saknr AS saknr,
  P_FinStmtHierarchy.fkber AS fkber,
  P_FinStmtHierarchy.type AS type,
  P_FinStmtHierarchy.Description AS Description,
  P_FinStmtHierarchy.MaintenanceLanguage AS MaintenanceLanguage,
  P_FinStmtHierarchy.id AS id,
  P_FinStmtHierarchy.parent AS parent,
  P_FinStmtHierarchy.child AS child,
  P_FinStmtHierarchy.nextn AS nextn,
  P_FinStmtHierarchy.stufe AS stufe,
  P_FinStmtHierarchy.ergs2 AS ergs2,
  P_FinStmtHierarchy.segment AS segment,
  _GLAccountInCompanyCode.GLAccount AS GLAccount
FROM P_FinStmtHierarchy
INNER JOIN I_CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More