DOCITEM

DOCITEM is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY AccountingDocumentType AccountingDocumentType 1
KEY AssignmentReference AssignmentReference 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY PostingDate PostingDate 1
CostCenter RO_SAFTAnalysisEntry 1
OrderID RO_SAFTAnalysisEntry 1
Segment RO_SAFTAnalysisEntry 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 DOCITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ASSIGNMENTREFERENCE,
    COMPANYCODE,
    FISCALYEAR,
    POSTINGDATE,
    COSTCENTER,
    ORDERID,
    SEGMENT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ACCOUNTINGDOCUMENTTYPE, ASSIGNMENTREFERENCE, COMPANYCODE, FISCALYEAR, POSTINGDATE)
);