P_FsvHierarchWithCOCD

DDL: P_FSVHIERARCHWITHCOCD SQL: PFSVHIERCOCD Type: view BASIC
18 Fields 3 Data Sources

P_FsvHierarchWithCOCD is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (I_GLAccountInCompanyCode, I_CompanyCode, P_FsvHierarchyWithCategory) and exposes 18 fields with key fields HierarchyUniqueNodeID, bukrs, versn, ktopl.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountInCompanyCode _GLAccountInCompanyCode left_outer
I_CompanyCode I_CompanyCode inner
P_FsvHierarchyWithCategory P_FsvHierarchyWithCategory from

Annotations (6)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PFSVHIERCOCD view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view

Fields (18)

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

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_FsvHierarchWithCOCD.
-- 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: PFSVHIERCOCD

CREATE VIEW P_FsvHierarchWithCOCD AS
SELECT
  P_FsvHierarchyWithCategory.HierarchyUniqueNodeID AS HierarchyUniqueNodeID,
  I_CompanyCode.CompanyCode AS bukrs,
  P_FsvHierarchyWithCategory.versn AS versn,
  P_FsvHierarchyWithCategory.ktopl AS ktopl,
  P_FsvHierarchyWithCategory.UniqueParentID AS UniqueParentID,
  P_FsvHierarchyWithCategory.ergsl AS ergsl,
  P_FsvHierarchyWithCategory.saknr AS saknr,
  P_FsvHierarchyWithCategory.fkber AS fkber,
  P_FsvHierarchyWithCategory.type AS type,
  P_FsvHierarchyWithCategory.Description AS Description,
  P_FsvHierarchyWithCategory.id AS id,
  P_FsvHierarchyWithCategory.nextn AS nextn,
  P_FsvHierarchyWithCategory.stufe AS stufe,
  P_FsvHierarchyWithCategory.ergs2 AS ergs2,
  P_FsvHierarchyWithCategory.segment AS segment,
  I_CompanyCode.CountryChartOfAccounts AS CountryChartOfAccounts,
  _GLAccountInCompanyCode.GLAccount AS GLAccount,
  _GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccount
FROM P_FsvHierarchyWithCategory
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