I_GRIRPROCESS

CDS View
36 Fields 2 CDS Views

GR/IR Process

I_GRIRPROCESS is a CDS View in S/4HANA. GR/IR Process. It contains 36 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_GRIRProcess view_entity projection CONSUMPTION GR/IR Process
P_GRIRPurgDocItemStatus1 view_entity from CONSUMPTION GR/IR Purchasing Document Item Status

Fields (36)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY PurchasingDocument PurchasingDocument 2
KEY PurchasingDocumentItem PurchasingDocumentItem 2
_CompanyCode _CompanyCode 2
_GRIRProcessRootCause _GRIRProcessRootCause 1
_GRIRProcessStatus _GRIRProcessStatus 2
_PurchasingDocument _PurchasingDocument 2
_PurchasingDocumentItem _PurchasingDocumentItem 2
GRIRClearingProcessPriority GRIRClearingProcessPriority 2
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 2
GRIRClearingProcessStatus GRIRClearingProcessStatus 2
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 1
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 1
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 1
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 1
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 1
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 1
HasNote HasNote 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Note Note 1
ProposedResponsiblePerson ProposedResponsiblePerson 1
PrpsdRespDeptMaxClProbability PrpsdRespDeptMaxClProbability 1
PrpsdResponsibleDepartment PrpsdResponsibleDepartment 1
PrpsdRespPersonMaxClassProblty PrpsdRespPersonMaxClassProblty 1
ResponsibleDepartment ResponsibleDepartment 2
ResponsiblePerson ResponsiblePerson 2
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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GRIRPROCESS (
    COMPANYCODE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _GRIRPROCESSROOTCAUSE,
    _GRIRPROCESSSTATUS,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    GRIRCLRGPROCESSPRPSDROOTCAUSE,
    GRIRCLRGPROCESSPRPSDSTATUS,
    GRIRCLRGPROCPRPSDPRIORITY,
    GRIRPROPOSEDPRIOMAXCLPROBLTY,
    GRIRPROPOSEDSTATUSMAXCLPROBLTY,
    GRIRPRPSDROOTCAUSEMAXCLPROBLTY,
    HASNOTE,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    NOTE,
    PROPOSEDRESPONSIBLEPERSON,
    PRPSDRESPDEPTMAXCLPROBABILITY,
    PRPSDRESPONSIBLEDEPARTMENT,
    PRPSDRESPPERSONMAXCLASSPROBLTY,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    SYSTEMMESSAGETEXT,
    SYSTEMMESSAGETYPE,
    SYSTEMMESSAGEVARIABLE1,
    SYSTEMMESSAGEVARIABLE2,
    SYSTEMMESSAGEVARIABLE3,
    SYSTEMMESSAGEVARIABLE4,
    PRIMARY KEY (COMPANYCODE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More