_MATERIALDOCITEM

22 Fields

_MATERIALDOCITEM is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY MaterialDocument MaterialDocument 1
KEY MaterialDocumentLine MaterialDocumentLine 1
KEY MaterialDocumentYear MaterialDocumentYear 1
AccountingDocumentType AccountingDocumentType 1
ActiveGLAccount ActiveGLAccount 1
AlternativeUnit AlternativeUnit 1
Batch Batch 1
CompanyCode CompanyCode 1
DebitCreditCode DebitCreditCode 1
DocumentReferenceID DocumentReferenceID 1
EntryUnit EntryUnit 1
GoodsMovementEntryQty GoodsMovementEntryQty 1
GoodsMovementQuantity GoodsMovementQuantity 1
GoodsMovementType GoodsMovementType 1
MaterialDocumentItemText MaterialDocumentItemText 1
MaterialLedgerTransactionType MaterialLedgerTransactionType 1
OriginalReferenceDocument OriginalReferenceDocument 1
Plant Plant 1
PostingDate PostingDate 1
Product Product 1
ProjectNetworkHasSpecialStock ProjectNetworkHasSpecialStock 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 _MATERIALDOCITEM (
    MATERIALDOCUMENT,
    MATERIALDOCUMENTLINE,
    MATERIALDOCUMENTYEAR,
    ACCOUNTINGDOCUMENTTYPE,
    ACTIVEGLACCOUNT,
    ALTERNATIVEUNIT,
    BATCH,
    COMPANYCODE,
    DEBITCREDITCODE,
    DOCUMENTREFERENCEID,
    ENTRYUNIT,
    GOODSMOVEMENTENTRYQTY,
    GOODSMOVEMENTQUANTITY,
    GOODSMOVEMENTTYPE,
    MATERIALDOCUMENTITEMTEXT,
    MATERIALLEDGERTRANSACTIONTYPE,
    ORIGINALREFERENCEDOCUMENT,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROJECTNETWORKHASSPECIALSTOCK,
    STORAGELOCATION,
    PRIMARY KEY (MATERIALDOCUMENT, MATERIALDOCUMENTLINE, MATERIALDOCUMENTYEAR)
);

Learn More