I_FINANCIALSTATEMENTITEM

CDS View
8 Fields 10 CDS Views

Items in Financial Statement Version

I_FINANCIALSTATEMENTITEM is a CDS View in S/4HANA. Items in Financial Statement Version. It contains 8 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_CN_CADEFinStmntItemMapping view from COMPOSITE
P_CN_CADEFinStmntItemMapping view left_outer COMPOSITE
P_CN_CADEFSVITMWPrefix view from CONSUMPTION
P_CN_CADEFSVITMWPrefix2 view from COMPOSITE
P_CN_CADEGLAccountForBalance view from COMPOSITE
P_FinStmtHierarchy view from BASIC
P_FinStmtLeafItem view from BASIC
P_FinStmtLeafWithFuncArea view left_outer BASIC
P_FinStmtLeafWithGLAcct view left_outer BASIC
P_FSVHierarchy view from BASIC

Fields (8)

KeyField CDS FieldsUsed in Views
KEY FinancialStatementItem ergsl,FinancialStatementItem,GLAccountWOPrefix 4
KEY FinancialStatementVariant FinancialStatementVariant,versn 4
ChildNode child 2
HierarchyNode id,parent 5
NodeType type 2
OffsettingItem ergs2 1
ParentNode parent 2
SiblingNode nextn 2

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.

-- Items in Financial Statement Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINANCIALSTATEMENTITEM (
    FINANCIALSTATEMENTITEM,
    FINANCIALSTATEMENTVARIANT,
    CHILDNODE,
    HIERARCHYNODE,
    NODETYPE,
    OFFSETTINGITEM,
    PARENTNODE,
    SIBLINGNODE,
    PRIMARY KEY (FINANCIALSTATEMENTITEM, FINANCIALSTATEMENTVARIANT)
);

Learn More