P_GRIRPROCESS

CDS View
41 Fields 2 CDS Views

P_GRIRPROCESS is a CDS View in S/4HANA. It contains 41 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_GRIRProcess view_entity from TRANSACTIONAL GR/IR Process
I_GRIRProcessBasic view_entity from BASIC GR IR Process Basic

Fields (41)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY PurchasingDocument PurchasingDocument 2
KEY PurchasingDocumentItem PurchasingDocumentItem 2
_CompanyCode _CompanyCode 2
_GRIRClrgProcPrpsdPriority _GRIRClrgProcPrpsdPriority 2
_GRIRProcessPriority _GRIRProcessPriority 2
_GRIRProcessPrpsdRootCause _GRIRProcessPrpsdRootCause 2
_GRIRProcessRootCause _GRIRProcessRootCause 2
_GRIRProcessStatus _GRIRProcessStatus 2
_GRIRPrpsdStatus _GRIRPrpsdStatus 2
_PurchasingDocument _PurchasingDocument 2
_PurchasingDocumentItem _PurchasingDocumentItem 2
GRIRClearingProcessPriority GRIRClearingProcessPriority 2
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 2
GRIRClearingProcessStatus GRIRClearingProcessStatus 2
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 2
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 2
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 2
GRIRProcPrpslLastChangeDteTime GRIRProcPrpslLastChangeDteTime 2
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 2
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 2
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 2
HasNote HasNote 2
LastChangeDate LastChangeDate 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
Note Note 2
ProposedResponsiblePerson ProposedResponsiblePerson 2
PrpsdRespDeptMaxClProbability PrpsdRespDeptMaxClProbability 2
PrpsdResponsibleDepartment PrpsdResponsibleDepartment 2
PrpsdRespPersonMaxClassProblty PrpsdRespPersonMaxClassProblty 2
ResponsibleDepartment ResponsibleDepartment 2
ResponsiblePerson GRIRClrgProcessResponsibleUser,ResponsiblePerson 2
SystemMessageIdentification SystemMessageIdentification 2
SystemMessageNumber SystemMessageNumber 2
SystemMessageText SystemMessageText 2
SystemMessageType SystemMessageType 2
SystemMessageVariable1 SystemMessageVariable1 2
SystemMessageVariable2 SystemMessageVariable2 2
SystemMessageVariable3 SystemMessageVariable3 2
SystemMessageVariable4 SystemMessageVariable4 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCESS (
    COMPANYCODE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _GRIRCLRGPROCPRPSDPRIORITY,
    _GRIRPROCESSPRIORITY,
    _GRIRPROCESSPRPSDROOTCAUSE,
    _GRIRPROCESSROOTCAUSE,
    _GRIRPROCESSSTATUS,
    _GRIRPRPSDSTATUS,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    GRIRCLRGPROCESSPRPSDROOTCAUSE,
    GRIRCLRGPROCESSPRPSDSTATUS,
    GRIRCLRGPROCPRPSDPRIORITY,
    GRIRPROCPRPSLLASTCHANGEDTETIME,
    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