I_GRIRPROCESSHISTORY

CDS View
68 Fields 13 CDS Views

GRIR Process History

I_GRIRPROCESSHISTORY is a CDS View in S/4HANA. GRIR Process History. It contains 68 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_GRIRProcessHistoryNote view from CONSUMPTION Notes history for purchase orders
I_GRIRProcHistWthPrdcssr view from BASIC GRIR History view with predecessor
P_GRIRClearingProcessChange view from CONSUMPTION GR/IR Process History change
P_GRIRProcessHistoryFirstChge view from CONSUMPTION
P_GRIRProcessHistoryLastChange view from CONSUMPTION
P_GRIRProcessHistoryWithPredec view from BASIC
P_GRIRProcHistNxtPrioTmeStmp view from CONSUMPTION GR/IR Proc History with next status time
P_GRIRProcHistNxtRespDtTmeStmp view from CONSUMPTION GR/IR Proc History w next resp dpmt time
P_GRIRProcHistNxtRespPnTmeStmp view from CONSUMPTION GR/IR Proc History w next resp prsn time
P_GRIRProcHistNxtRtCseTmeStmp view from CONSUMPTION GR/IR Proc History w next root cse time
P_GRIRProcHistNxtStatusTmeStmp view from CONSUMPTION GR/IR Proc History with next status time
P_GRIRProcHistPredecessor view from CONSUMPTION
P_GRIRProcHistSuccssrTimestamp view from CONSUMPTION

Fields (68)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 13
KEY LastChangeDateTime LastChangeDateTime 13
KEY PurchasingDocument PurchasingDocument 13
KEY PurchasingDocumentItem PurchasingDocumentItem 13
_CompanyCode _CompanyCode 4
_PurchasingDocument _PurchasingDocument 4
_PurchasingDocumentItem _PurchasingDocumentItem 4
AccountAssignmentCategory AccountAssignmentCategory 7
BalAmtInCompanyCodeCrcy BalAmtInCompanyCodeCrcy 2
BalanceQuantity BalanceQuantity 2
CompanyCodeCurrency CompanyCodeCurrency 2
DeliveryCostBalAmtInCCCrcy DeliveryCostBalAmtInCCCrcy 2
DeliveryCostBalanceQuantity DeliveryCostBalanceQuantity 2
DueDays DueDays 2
GdsRcptDelivCostAmtInCCCrcy GdsRcptDelivCostAmtInCCCrcy 2
GoodsBalanceAmountInCCCrcy GoodsBalanceAmountInCCCrcy 2
GoodsBalanceQuantity GoodsBalanceQuantity 2
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmountInCoCodeCrcy 2
GoodsReceiptDeliveryCostQty GoodsReceiptDeliveryCostQty 2
GoodsReceiptGoodsAmtInCCCrcy GoodsReceiptGoodsAmtInCCCrcy 2
GoodsReceiptGoodsQuantity GoodsReceiptGoodsQuantity 2
GoodsReceiptQty GoodsReceiptQty 2
GRIRClearingProcessPriority GRIRClearingProcessPriority 5
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 5
GRIRClearingProcessStatus GRIRClearingProcessStatus 6
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 2
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 2
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 2
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 2
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 2
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 2
HasNote HasNote 3
InvcRcptDelivCostAmtInCCCrcy InvcRcptDelivCostAmtInCCCrcy 2
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy 2
InvoiceRcptDeliveryCostQty InvoiceRcptDeliveryCostQty 2
InvoiceRcptGoodsAmtInCCCrcy InvoiceRcptGoodsAmtInCCCrcy 2
InvoiceReceiptGoodsQuantity InvoiceReceiptGoodsQuantity 2
InvoiceReceiptQty InvoiceReceiptQty 2
IsFinallyInvoiced IsFinallyInvoiced 2
IsGdsRcptDelivCostAmtSurplus IsGdsRcptDelivCostAmtSurplus 2
IsGdsRcptDelivCostQtySurplus IsGdsRcptDelivCostQtySurplus 2
IsGoodsRcptGoodsAmtSurplus IsGoodsRcptGoodsAmtSurplus 2
IsGoodsRcptGoodsQtySurplus IsGoodsRcptGoodsQtySurplus 2
IsInvoiceDelivCostAmtSurplus IsInvoiceDelivCostAmtSurplus 2
IsInvoiceDelivCostQtySurplus IsInvoiceDelivCostQtySurplus 2
IsInvoiceGoodsAmountSurplus IsInvoiceGoodsAmountSurplus 2
IsInvoiceGoodsQtySurplus IsInvoiceGoodsQtySurplus 2
LastChangedByUser LastChangedByUser 3
LatestOpenItemPostingDate LatestOpenItemPostingDate 2
MaterialGroup MaterialGroup 8
Note Note 1
NumberOfGoodsReceipts NumberOfGoodsReceipts 2
NumberOfInvoiceReceipts NumberOfInvoiceReceipts 2
OldestOpenItemPostingDate OldestOpenItemPostingDate 2
Plant Plant 9
ProposedResponsiblePerson ProposedResponsiblePerson 2
PrpsdRespDeptMaxClProbability PrpsdRespDeptMaxClProbability 2
PrpsdResponsibleDepartment PrpsdResponsibleDepartment 2
PrpsdRespPersonMaxClassProblty PrpsdRespPersonMaxClassProblty 2
PurchasingGroup PurchasingGroup 9
PurchasingOrganization PurchasingOrganization 9
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 2
ResponsibleDepartment ResponsibleDepartment 5
ResponsiblePerson GRIRClrgProcessResponsibleUser,ResponsiblePerson 6
Supplier Supplier 9
SystemMessageIdentification SystemMessageIdentification 2
SystemMessageNumber SystemMessageNumber 2
SystemMessageType SystemMessageType 2

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.

-- GRIR Process History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_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,
    ISGDSRCPTDELIVCOSTAMTSURPLUS,
    ISGDSRCPTDELIVCOSTQTYSURPLUS,
    ISGOODSRCPTGOODSAMTSURPLUS,
    ISGOODSRCPTGOODSQTYSURPLUS,
    ISINVOICEDELIVCOSTAMTSURPLUS,
    ISINVOICEDELIVCOSTQTYSURPLUS,
    ISINVOICEGOODSAMOUNTSURPLUS,
    ISINVOICEGOODSQTYSURPLUS,
    LASTCHANGEDBYUSER,
    LATESTOPENITEMPOSTINGDATE,
    MATERIALGROUP,
    NOTE,
    NUMBEROFGOODSRECEIPTS,
    NUMBEROFINVOICERECEIPTS,
    OLDESTOPENITEMPOSTINGDATE,
    PLANT,
    PROPOSEDRESPONSIBLEPERSON,
    PRPSDRESPDEPTMAXCLPROBABILITY,
    PRPSDRESPONSIBLEDEPARTMENT,
    PRPSDRESPPERSONMAXCLASSPROBLTY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCORDERQUANTITYUNIT,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    SYSTEMMESSAGETYPE,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More