P_RU_PURCHASEORDERHISTORYGRIR

CDS View
12 Fields 1 CDS Views

FI RU PurchaseOrder History GR/IR

P_RU_PURCHASEORDERHISTORYGRIR is a CDS View in S/4HANA. FI RU PurchaseOrder History GR/IR. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_MaterialRcptDateMM4 view inner CONSUMPTION FI RU get Material Receipt Date: MM-4

Fields (12)

KeyField CDS FieldsUsed in Views
GoodsReceiptIsExpected GoodsReceiptIsExpected 1
GR_MaterialDocument GR_MaterialDocument 1
GR_MaterialDocumentItem GR_MaterialDocumentItem 1
GR_MaterialDocumentYear GR_MaterialDocumentYear 1
GR_PostingDate GR_PostingDate 1
GRIR_ReferenceDocument GRIR_ReferenceDocument 1
GRIR_ReferenceDocumentFisYear GRIR_ReferenceDocumentFisYear 1
GRIR_ReferenceDocumentItem GRIR_ReferenceDocumentItem 1
IR_MaterialDocument IR_MaterialDocument 1
IR_MaterialDocumentItem IR_MaterialDocumentItem 1
IR_MaterialDocumentYear IR_MaterialDocumentYear 1
Plant Plant 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.

-- FI RU PurchaseOrder History GR/IR
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_PURCHASEORDERHISTORYGRIR (
    GOODSRECEIPTISEXPECTED,
    GR_MATERIALDOCUMENT,
    GR_MATERIALDOCUMENTITEM,
    GR_MATERIALDOCUMENTYEAR,
    GR_POSTINGDATE,
    GRIR_REFERENCEDOCUMENT,
    GRIR_REFERENCEDOCUMENTFISYEAR,
    GRIR_REFERENCEDOCUMENTITEM,
    IR_MATERIALDOCUMENT,
    IR_MATERIALDOCUMENTITEM,
    IR_MATERIALDOCUMENTYEAR,
    PLANT
);

Learn More