P_FSVHIERARCHYWITHCATEGORY

CDS View
16 Fields 2 CDS Views

financial statement version hierarchy with category flag

P_FSVHIERARCHYWITHCATEGORY is a CDS View in S/4HANA. financial statement version hierarchy with category flag. It contains 16 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FsvHierarchyInCoa view_entity from COMPOSITE FSV based on chart of accounts
P_FsvHierarchWithCOCD view_entity from BASIC fsv hierarchy with company code assigned

Fields (16)

KeyField CDS FieldsUsed in Views
KEY HierarchyUniqueNodeID HierarchyNodeUniqueID,HierarchyUniqueNodeID 2
KEY ktopl ChartOfAccounts,ktopl 2
KEY versn FinancialStatementVariant,versn 2
Description Description,HierarchyNodeDescription 2
ergs2 ergs2,OffsettingItem 2
ergsl ergsl,FinancialStatementItem 2
fkber fkber,FunctionalArea 2
id HierarchyNode,id 2
nextn nextn,SiblingNode 2
saknr GLAccount,saknr 2
segment GLAcctHierarchyNodeCategory,segment 2
stufe FinStatementHierarchyLevelVal,stufe 2
type NodeType,type 2
UniqueParentID ParentNodeUniqueID,UniqueParentID 2
xhabn IsCreditBalanceRelevant 1
xsoll IsDebitBalanceRelevant 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- financial statement version hierarchy with category flag
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FSVHIERARCHYWITHCATEGORY (
    HIERARCHYUNIQUENODEID,
    KTOPL,
    VERSN,
    DESCRIPTION,
    ERGS2,
    ERGSL,
    FKBER,
    ID,
    NEXTN,
    SAKNR,
    SEGMENT,
    STUFE,
    TYPE,
    UNIQUEPARENTID,
    XHABN,
    XSOLL,
    PRIMARY KEY (HIERARCHYUNIQUENODEID, KTOPL, VERSN)
);

Learn More