_DOCITEM

11 Fields

_DOCITEM is an SAP database table in S/4HANA. It contains 11 fields.

Fields (11)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
GoodsReceiptLatestCreationDate MRPElementStartDate 1
Material Product 1
MRPArea MRPArea 1
OrderQuantityUnit MaterialBaseUnit 1
Plant MRPPlant 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentCategory ReferenceDocumentCategory 1
ReferenceDocumentItem ReferenceDocumentItem 1
StorageLocation StorageLocation 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 (
    COMPANYCODE,
    COMPANYCODECURRENCY,
    GOODSRECEIPTLATESTCREATIONDATE,
    MATERIAL,
    MRPAREA,
    ORDERQUANTITYUNIT,
    PLANT,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCATEGORY,
    REFERENCEDOCUMENTITEM,
    STORAGELOCATION
);

Learn More