GOODSRECEIPT

GOODSRECEIPT is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PrecedingDocument 1
KEY SubsequentDocument MaterialDocument,SubsequentDocument 1
GLAccount GoodsReceiptGLAccount 1
MaterialDocument SubsequentDocument 1
MaterialDocumentItem SubsequentDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
PurchaseOrderItem PrecedingDocumentItem 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 GOODSRECEIPT (
    PURCHASEORDER,
    SUBSEQUENTDOCUMENT,
    GLACCOUNT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    PURCHASEORDERITEM,
    PRIMARY KEY (PURCHASEORDER, SUBSEQUENTDOCUMENT)
);