REPORTEDITEM

REPORTEDITEM is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY ChartOfAccounts ChartOfAccounts 3
KEY CompanyCode CompanyCode 1
KEY FinancialStatementHierarchy FinancialStatementHierarchy 1
KEY FinStatementHierarchyNodeValue FinStatementHierarchyNodeValue 2
KEY FiscalYear FiscalYear 3
KEY HierarchyNode HierarchyNode 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY ParentNode HierarchyParentNode,ParentNode 3
KEY ValidityEndDate ValidityEndDate 1
AlternativeGLAccount AlternativeGLAccount 1
Currency Currency 1
DebitCreditCode DebitCreditCode 1
GLAccount RealGLAccount 1
NodeType NodeType 1
PostingDate PostingDate 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE REPORTEDITEM (
    ACCOUNTINGDOCUMENT,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    FINANCIALSTATEMENTHIERARCHY,
    FINSTATEMENTHIERARCHYNODEVALUE,
    FISCALYEAR,
    HIERARCHYNODE,
    LEDGER,
    LEDGERGLLINEITEM,
    PARENTNODE,
    VALIDITYENDDATE,
    ALTERNATIVEGLACCOUNT,
    CURRENCY,
    DEBITCREDITCODE,
    GLACCOUNT,
    NODETYPE,
    POSTINGDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CHARTOFACCOUNTS, COMPANYCODE, FINANCIALSTATEMENTHIERARCHY, FINSTATEMENTHIERARCHYNODEVALUE, FISCALYEAR, HIERARCHYNODE, LEDGER, LEDGERGLLINEITEM, PARENTNODE, VALIDITYENDDATE)
);