I_GRIRPROCESSHISTORY

CDS View
80 Fields 13 CDS Views

GRIR Process History

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

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_GRIRProcessHistoryNote view_entity 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 GR/IR Process History First Change
P_GRIRProcessHistoryLastChange view_entity from CONSUMPTION GR/IR Process History Last Change
P_GRIRProcessHistoryWithPredec view from BASIC GR/IR Process History
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_entity from CONSUMPTION GR/IR Process History with Predecessor
P_GRIRProcHistSuccssrTimestamp view_entity from CONSUMPTION GR/IR Process History with successor timestamp

Fields (80)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 13
KEY LastChangeDateTime LastChangeDateTime 13
KEY PurchasingDocument PurchasingDocument 13
KEY PurchasingDocumentItem PurchasingDocumentItem 13
_CompanyCode _CompanyCode 5
_GRIRClrgProcPrpsdPriorityText _GRIRClrgProcPrpsdPriorityText 1
_GRIRClrgProcPrpsdStatusText _GRIRClrgProcPrpsdStatusText 1
_GRIRProcessPriorityText _GRIRProcessPriorityText 1
_GRIRProcessPrpsdRootCauseText _GRIRProcessPrpsdRootCauseText 1
_GRIRProcessRootCauseText _GRIRProcessRootCauseText 1
_GRIRProcessStatusText _GRIRProcessStatusText 1
_LastChangedByUser _LastChangedByUser 1
_PurchasingDocument _PurchasingDocument 5
_PurchasingDocumentItem _PurchasingDocumentItem 5
AccountAssignmentCategory AccountAssignmentCategory 8
BalAmtInCompanyCodeCrcy BalAmtInCompanyCodeCrcy,PrevBalAmtInCompanyCodeCrcy 3
BalanceQuantity BalanceQuantity 3
CompanyCodeCurrency CompanyCodeCurrency 3
DeliveryCostBalAmtInCCCrcy DeliveryCostBalAmtInCCCrcy 3
DeliveryCostBalanceQuantity DeliveryCostBalanceQuantity 3
DueDays DueDays 3
GdsRcptDelivCostAmtInCCCrcy GdsRcptDelivCostAmtInCCCrcy 3
GoodsBalanceAmountInCCCrcy GoodsBalanceAmountInCCCrcy 3
GoodsBalanceQuantity GoodsBalanceQuantity 3
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmountInCoCodeCrcy 3
GoodsReceiptDeliveryCostQty GoodsReceiptDeliveryCostQty 3
GoodsReceiptGoodsAmtInCCCrcy GoodsReceiptGoodsAmtInCCCrcy 3
GoodsReceiptGoodsQuantity GoodsReceiptGoodsQuantity 3
GoodsReceiptQty GoodsReceiptQty,PrevGoodsReceiptQty 3
GRIRClearingProcessPriority GRIRClearingProcessPriority 6
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 6
GRIRClearingProcessStatus GRIRClearingProcessStatus 7
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 3
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 3
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 3
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 3
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 3
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 3
HasNote HasNote 4
InvcRcptDelivCostAmtInCCCrcy InvcRcptDelivCostAmtInCCCrcy 3
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy 3
InvoiceRcptDeliveryCostQty InvoiceRcptDeliveryCostQty 3
InvoiceRcptGoodsAmtInCCCrcy InvoiceRcptGoodsAmtInCCCrcy 3
InvoiceReceiptGoodsQuantity InvoiceReceiptGoodsQuantity 3
InvoiceReceiptQty InvoiceReceiptQty,PrevInvoiceReceiptQty 3
IsFinallyInvoiced IsFinallyInvoiced 3
IsGdsRcptDelivCostAmtSurplus IsGdsRcptDelivCostAmtSurplus 3
IsGdsRcptDelivCostQtySurplus IsGdsRcptDelivCostQtySurplus 3
IsGoodsRcptGoodsAmtSurplus IsGoodsRcptGoodsAmtSurplus 3
IsGoodsRcptGoodsQtySurplus IsGoodsRcptGoodsQtySurplus 3
IsInvoiceDelivCostAmtSurplus IsInvoiceDelivCostAmtSurplus 3
IsInvoiceDelivCostQtySurplus IsInvoiceDelivCostQtySurplus 3
IsInvoiceGoodsAmountSurplus IsInvoiceGoodsAmountSurplus 3
IsInvoiceGoodsQtySurplus IsInvoiceGoodsQtySurplus 3
LastChangedByUser LastChangedByUser 4
LatestOpenItemPostingDate LatestOpenItemPostingDate 3
MaterialGroup MaterialGroup 9
Note Note 2
NumberOfGoodsReceipts NumberOfGoodsReceipts,PrevNumberOfGoodsReceipts 3
NumberOfInvoiceReceipts NumberOfInvoiceReceipts,PrevNumberOfInvoiceReceipts 3
OldestOpenItemPostingDate OldestOpenItemPostingDate 3
Plant Plant 10
ProposedResponsiblePerson ProposedResponsiblePerson 3
PrpsdRespDeptMaxClProbability PrpsdRespDeptMaxClProbability 3
PrpsdResponsibleDepartment PrpsdResponsibleDepartment 3
PrpsdRespPersonMaxClassProblty PrpsdRespPersonMaxClassProblty 3
PurchasingGroup PurchasingGroup 10
PurchasingOrganization PurchasingOrganization 10
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 3
ResponsibleDepartment ResponsibleDepartment 6
ResponsiblePerson GRIRClrgProcessResponsibleUser,ResponsiblePerson 7
Supplier Supplier 10
SystemMessageIdentification SystemMessageIdentification 3
SystemMessageNumber SystemMessageNumber 3
SystemMessageText SystemMessageText 1
SystemMessageType SystemMessageType 3
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.

-- 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,
    _GRIRCLRGPROCPRPSDPRIORITYTEXT,
    _GRIRCLRGPROCPRPSDSTATUSTEXT,
    _GRIRPROCESSPRIORITYTEXT,
    _GRIRPROCESSPRPSDROOTCAUSETEXT,
    _GRIRPROCESSROOTCAUSETEXT,
    _GRIRPROCESSSTATUSTEXT,
    _LASTCHANGEDBYUSER,
    _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,
    SYSTEMMESSAGETEXT,
    SYSTEMMESSAGETYPE,
    SYSTEMMESSAGEVARIABLE1,
    SYSTEMMESSAGEVARIABLE2,
    SYSTEMMESSAGEVARIABLE3,
    SYSTEMMESSAGEVARIABLE4,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More