P_GRIRPURCHASEORDERHISTORY2

CDS View
22 Fields 1 CDS Views

GR/IR Purchase Order History

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GRIRPurchaseOrderHistory1 view union_all CONSUMPTION GR/IR Purchase Order History

Fields (22)

KeyField CDS FieldsUsed in Views
CompanyCodeCurrency CompanyCodeCurrency 1
ConditionCount ConditionCount 1
ConditionStep ConditionStep 1
ConditionType ConditionType 1
Currency Currency 1
DebitCreditCode DebitCreditCode 1
DocumentReferenceID DocumentReferenceID 1
GRIRAcctClrgAmtInCoCodeCrcy GRIRAcctClrgAmtInCoCodeCrcy 1
GRIRAcctClrgAmtInOrdTrnsacCrcy GRIRAcctClrgAmtInOrdTrnsacCrcy 1
GRIRAcctClrgAmtInTransacCrcy GRIRAcctClrgAmtInTransacCrcy 1
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency 1
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy 1
InvoiceAmtInPurOrdTransacCrcy InvoiceAmtInPurOrdTransacCrcy 1
PostingDate PostingDate 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingHistoryCategory PurchasingHistoryCategory 1
PurchasingHistoryDocument PurchasingHistoryDocument 1
PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem 1
PurchasingHistoryDocumentType PurchasingHistoryDocumentType 1
PurgHistDocumentCreationTime PurgHistDocumentCreationTime 1
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy 1
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit 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_GRIRPURCHASEORDERHISTORY2 (
    COMPANYCODECURRENCY,
    CONDITIONCOUNT,
    CONDITIONSTEP,
    CONDITIONTYPE,
    CURRENCY,
    DEBITCREDITCODE,
    DOCUMENTREFERENCEID,
    GRIRACCTCLRGAMTINCOCODECRCY,
    GRIRACCTCLRGAMTINORDTRNSACCRCY,
    GRIRACCTCLRGAMTINTRANSACCRCY,
    INVOICEAMOUNTINFRGNCURRENCY,
    INVOICEAMTINCOCODECRCY,
    INVOICEAMTINPURORDTRANSACCRCY,
    POSTINGDATE,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGHISTORYCATEGORY,
    PURCHASINGHISTORYDOCUMENT,
    PURCHASINGHISTORYDOCUMENTITEM,
    PURCHASINGHISTORYDOCUMENTTYPE,
    PURGHISTDOCUMENTCREATIONTIME,
    PURORDAMOUNTINCOMPANYCODECRCY,
    QTYINPURCHASEORDERPRICEUNIT
);

Learn More