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 CADE - Financial Statement Item Mapping Leaf Item
P_CN_CADEFinStmntItemMapping view left_outer COMPOSITE CADE - Financial Statement Item Mapping Leaf Item
P_CN_CADEFSVITMWPrefix view from CONSUMPTION CADE FSV Item with Prefix
P_CN_CADEFSVITMWPrefix2 view from COMPOSITE Financial Statement Item with Prefix for CADE 2
P_CN_CADEGLAccountForBalance view from COMPOSITE CADE GL Account Structure for Balance
P_FinStmtHierarchy view from BASIC Financial Statement Hierarchy (Items +Leaves)
P_FinStmtLeafItem view from BASIC Fin Statement Leaf Item (with Parent/Child info)
P_FinStmtLeafWithFuncArea view left_outer BASIC Financial Statement Leaf with assigned Functional Area
P_FinStmtLeafWithGLAcct view left_outer BASIC Fin Statement Item with G/L Account (assigned & unassigned)
P_FSVHierarchy view_entity from BASIC FSV Hierarchy

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