P_CN_FsvHierInCoa

DDL: P_CN_FSVHIERINCOA SQL: PCNFSVINCOA Type: view CONSUMPTION Package: GLO_FIN_CN
4 Fields 4 Data Sources

FSV based on chart of accounts

P_CN_FsvHierInCoa is a Consumption CDS View that provides data about "FSV based on chart of accounts" in SAP S/4HANA. It reads from 4 data sources (R_HierRuntimeRprstnAttrib, R_HierRuntimeRprstnNode, R_HierRuntimeRprstnNode, R_HierRuntimeRprstnAttrib) and exposes 4 fields with key field FinancialStatementVariant. Part of development package GLO_FIN_CN.

Data Sources (4)

SourceAliasJoin Type
R_HierRuntimeRprstnAttrib chartofacct left_outer
R_HierRuntimeRprstnNode hrrp_node from
R_HierRuntimeRprstnNode hrrp_parenet_node inner
R_HierRuntimeRprstnAttrib notassign left_outer

Parameters (2)

NameTypeDefault
P_FinancialStatementVariant versn_011
P_Key_date abap.dats

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCNFSVINCOA view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label FSV based on chart of accounts view
AbapCatalog.preserveKey true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementVariant R_HierRuntimeRprstnNode HierarchyID Hierarchy ID
ValidityEndDate R_HierRuntimeRprstnNode ValidityEndDate ValidTo
ValidityStartDate R_HierRuntimeRprstnNode ValidityStartDate Validity Start Date
HierarchyNodeClassendasChartOfAccounts

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_FsvHierInCoa.
-- 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: PCNFSVINCOA
-- Parameters: P_FinancialStatementVariant : versn_011, P_Key_date : abap.dats

CREATE VIEW P_CN_FsvHierInCoa AS
SELECT
  hrrp_node.HierarchyID AS FinancialStatementVariant,
  hrrp_node.ValidityEndDate AS ValidityEndDate,
  hrrp_node.ValidityStartDate AS ValidityStartDate,
  case hrrp_node.HierarchyNodeClass when '' then case hrrp_node.NodeType when 'L' then chartofacct.HierAttributeRangeFromVal end else hrrp_node.HierarchyNodeClass end as ChartOfAccounts AS HierarchyNodeClassendasChartOfAccounts
FROM R_HierRuntimeRprstnNode AS hrrp_node
INNER JOIN R_HierRuntimeRprstnNode AS hrrp_parenet_node ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_HierRuntimeRprstnAttrib AS notassign ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_HierRuntimeRprstnAttrib AS chartofacct ON /* join condition not captured in parsed metadata */
;

Learn More