P_GRIRPROCESSHISTORY

CDS View
65 Fields 1 CDS Views

GR/IR Process History

P_GRIRPROCESSHISTORY is a CDS View in S/4HANA. GR/IR Process History. It contains 65 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GRIRProcessHistory view_entity from BASIC GRIR Process History

Fields (65)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY LastChangeDateTime LastChangeDateTime 1
KEY PurchasingDocument PurchasingDocument 1
KEY PurchasingDocumentItem PurchasingDocumentItem 1
_CompanyCode _CompanyCode 1
_PurchasingDocument _PurchasingDocument 1
_PurchasingDocumentItem _PurchasingDocumentItem 1
AccountAssignmentCategory AccountAssignmentCategory 1
BalAmtInCompanyCodeCrcy BalAmtInCompanyCodeCrcy 1
BalanceQuantity BalanceQuantity 1
CompanyCodeCurrency CompanyCodeCurrency 1
DeliveryCostBalAmtInCCCrcy DeliveryCostBalAmtInCCCrcy 1
DeliveryCostBalanceQuantity DeliveryCostBalanceQuantity 1
DueDays DueDays 1
GdsRcptDelivCostAmtInCCCrcy GdsRcptDelivCostAmtInCCCrcy 1
GoodsBalanceAmountInCCCrcy GoodsBalanceAmountInCCCrcy 1
GoodsBalanceQuantity GoodsBalanceQuantity 1
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmountInCoCodeCrcy 1
GoodsReceiptDeliveryCostQty GoodsReceiptDeliveryCostQty 1
GoodsReceiptGoodsAmtInCCCrcy GoodsReceiptGoodsAmtInCCCrcy 1
GoodsReceiptGoodsQuantity GoodsReceiptGoodsQuantity 1
GoodsReceiptQty GoodsReceiptQty 1
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 1
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 1
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 1
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 1
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 1
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 1
HasNote HasNote 1
InvcRcptDelivCostAmtInCCCrcy InvcRcptDelivCostAmtInCCCrcy 1
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy 1
InvoiceRcptDeliveryCostQty InvoiceRcptDeliveryCostQty 1
InvoiceRcptGoodsAmtInCCCrcy InvoiceRcptGoodsAmtInCCCrcy 1
InvoiceReceiptGoodsQuantity InvoiceReceiptGoodsQuantity 1
InvoiceReceiptQty InvoiceReceiptQty 1
IsFinallyInvoiced IsFinallyInvoiced 1
LastChangedByUser LastChangedByUser 1
LatestOpenItemPostingDate LatestOpenItemPostingDate 1
MaterialGroup MaterialGroup 1
Note Note 1
NumberOfGoodsReceipts NumberOfGoodsReceipts 1
NumberOfInvoiceReceipts NumberOfInvoiceReceipts 1
OldestOpenItemPostingDate OldestOpenItemPostingDate 1
Plant Plant 1
ProposedResponsiblePerson ProposedResponsiblePerson 1
PrpsdRespDeptMaxClProbability PrpsdRespDeptMaxClProbability 1
PrpsdResponsibleDepartment PrpsdResponsibleDepartment 1
PrpsdRespPersonMaxClassProblty PrpsdRespPersonMaxClassProblty 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 1
ResponsibleDepartment ResponsibleDepartment 1
ResponsiblePerson ResponsiblePerson 1
Supplier Supplier 1
SystemMessageIdentification SystemMessageIdentification 1
SystemMessageNumber SystemMessageNumber 1
SystemMessageText SystemMessageText 1
SystemMessageType SystemMessageType 1
SystemMessageVariable1 SystemMessageVariable1 1
SystemMessageVariable2 SystemMessageVariable2 1
SystemMessageVariable3 SystemMessageVariable3 1
SystemMessageVariable4 SystemMessageVariable4 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 Process History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCESSHISTORY (
    COMPANYCODE,
    LASTCHANGEDATETIME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    BALAMTINCOMPANYCODECRCY,
    BALANCEQUANTITY,
    COMPANYCODECURRENCY,
    DELIVERYCOSTBALAMTINCCCRCY,
    DELIVERYCOSTBALANCEQUANTITY,
    DUEDAYS,
    GDSRCPTDELIVCOSTAMTINCCCRCY,
    GOODSBALANCEAMOUNTINCCCRCY,
    GOODSBALANCEQUANTITY,
    GOODSRECEIPTAMOUNTINCOCODECRCY,
    GOODSRECEIPTDELIVERYCOSTQTY,
    GOODSRECEIPTGOODSAMTINCCCRCY,
    GOODSRECEIPTGOODSQUANTITY,
    GOODSRECEIPTQTY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    GRIRCLRGPROCESSPRPSDROOTCAUSE,
    GRIRCLRGPROCESSPRPSDSTATUS,
    GRIRCLRGPROCPRPSDPRIORITY,
    GRIRPROPOSEDPRIOMAXCLPROBLTY,
    GRIRPROPOSEDSTATUSMAXCLPROBLTY,
    GRIRPRPSDROOTCAUSEMAXCLPROBLTY,
    HASNOTE,
    INVCRCPTDELIVCOSTAMTINCCCRCY,
    INVOICERCPTAMTINCOCODECRCY,
    INVOICERCPTDELIVERYCOSTQTY,
    INVOICERCPTGOODSAMTINCCCRCY,
    INVOICERECEIPTGOODSQUANTITY,
    INVOICERECEIPTQTY,
    ISFINALLYINVOICED,
    LASTCHANGEDBYUSER,
    LATESTOPENITEMPOSTINGDATE,
    MATERIALGROUP,
    NOTE,
    NUMBEROFGOODSRECEIPTS,
    NUMBEROFINVOICERECEIPTS,
    OLDESTOPENITEMPOSTINGDATE,
    PLANT,
    PROPOSEDRESPONSIBLEPERSON,
    PRPSDRESPDEPTMAXCLPROBABILITY,
    PRPSDRESPONSIBLEDEPARTMENT,
    PRPSDRESPPERSONMAXCLASSPROBLTY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCORDERQUANTITYUNIT,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    SYSTEMMESSAGETEXT,
    SYSTEMMESSAGETYPE,
    SYSTEMMESSAGEVARIABLE1,
    SYSTEMMESSAGEVARIABLE2,
    SYSTEMMESSAGEVARIABLE3,
    SYSTEMMESSAGEVARIABLE4,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More