P_FinStmtLeafItem

DDL: P_FINSTMTLEAFITEM SQL: PFSLEAFITM Type: view BASIC
15 Fields 2 Data Sources

P_FinStmtLeafItem is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_FinancialStatementItem, P_FinStmtLeaf) and exposes 15 fields with key fields UniqueParentIDendasUniqueParentID, versn, ergsl, ktopl, saknr.

Data Sources (2)

SourceAliasJoin Type
I_FinancialStatementItem I_FinancialStatementItem from
P_FinStmtLeaf P_FinStmtLeaf inner

Annotations (7)

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

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY UniqueParentIDendasUniqueParentID
KEY versn P_FinStmtLeaf versn Version
KEY ergsl P_FinStmtLeaf ergsl FS Item
KEY ktopl P_FinStmtLeaf ktopl G/L Chart of Accounts
KEY saknr P_FinStmtLeaf saknr G/L Account
KEY fkber P_FinStmtLeaf fkber Functional Area
type P_FinStmtLeaf type Worklist Type
Description P_FinStmtLeaf Description Well Code Des.
xsoll P_FinStmtLeaf xsoll Debit Balance
xhabn P_FinStmtLeaf xhabn Credit Balance
id I_FinancialStatementItem HierarchyNode Node
parent I_FinancialStatementItem HierarchyNode Node
nextn
child
ergs2

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_FinStmtLeafItem.
-- 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: PFSLEAFITM

CREATE VIEW P_FinStmtLeafItem AS
SELECT
  case when P_FinStmtLeaf.UniqueParentID is null then cast ( I_FinancialStatementItem.HierarchyNode as abap.char(50) ) else P_FinStmtLeaf.UniqueParentID end as UniqueParentID AS UniqueParentIDendasUniqueParentID,
  P_FinStmtLeaf.versn AS versn,
  P_FinStmtLeaf.ergsl AS ergsl,
  P_FinStmtLeaf.ktopl AS ktopl,
  P_FinStmtLeaf.saknr AS saknr,
  P_FinStmtLeaf.fkber AS fkber,
  P_FinStmtLeaf.type AS type,
  P_FinStmtLeaf.Description AS Description,
  P_FinStmtLeaf.xsoll AS xsoll,
  P_FinStmtLeaf.xhabn AS xhabn,
  I_FinancialStatementItem.HierarchyNode AS id,
  I_FinancialStatementItem.HierarchyNode AS parent,
  cast ('000000' as seu_id) AS nextn,
  cast ('000000' as seu_id) AS child,
  cast ('' as ergsl) AS ergs2
FROM I_FinancialStatementItem
INNER JOIN P_FinStmtLeaf ON /* join condition not captured in parsed metadata */
;

Learn More