P_GRIRPURCHASEORDERHISTORY1

CDS View
15 Fields 1 CDS Views

GR/IR Purchase Order History

P_GRIRPURCHASEORDERHISTORY1 is a CDS View in S/4HANA. GR/IR Purchase Order History. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_GRIRPurchaseOrderHistory view from CONSUMPTION GR/IR Purchase Order History

Fields (15)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 1
KEY ConditionCount ConditionCount 1
AccountingDocumentCreationDate AccountingDocumentCreationDate 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
DocumentReferenceID DocumentReferenceID 1
GoodsMovementType GoodsMovementType 1
IsCompletelyDelivered IsCompletelyDelivered 1
Material Material 1
PostingDate PostingDate 1
PurchasingHistoryCategory PurchasingHistoryCategory 1
PurgHistDocumentCreationTime PurgHistDocumentCreationTime 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 1
ReferenceDocumentItem ReferenceDocumentItem 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.

-- GR/IR Purchase Order History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPURCHASEORDERHISTORY1 (
    ACCOUNTASSIGNMENTNUMBER,
    CONDITIONCOUNT,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    GOODSMOVEMENTTYPE,
    ISCOMPLETELYDELIVERED,
    MATERIAL,
    POSTINGDATE,
    PURCHASINGHISTORYCATEGORY,
    PURGHISTDOCUMENTCREATIONTIME,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, CONDITIONCOUNT)
);

Learn More