I_GRIRProcess

DDL: I_GRIRPROCESS Type: view_entity TRANSACTIONAL

GR/IR Process

I_GRIRProcess is a Transactional CDS View that provides data about "GR/IR Process" in SAP S/4HANA. It reads from 1 data source (P_GRIRProcess) and exposes 41 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_GRIRProcess P_GRIRProcess from

Annotations (16)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label GR/IR Process view
VDM.viewType #TRANSACTIONAL view
ObjectModel.representativeKey PurchasingDocumentItem view
Analytics.technicalName IFIGRIRPROCESS view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.sapObjectNodeType.name GoodsReceiptInvoiceReceiptProc view
ObjectModel.transactionalProcessingEnabled true view
UI.headerInfo.typeName Status view
UI.headerInfo.typeNamePlural GRIR Status view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_GRIRProcess CompanyCode Receiver Company Code
KEY PurchasingDocument P_GRIRProcess PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem P_GRIRProcess PurchasingDocumentItem Purchasing Doc. Item
LastChangeDateTime P_GRIRProcess LastChangeDateTime Timestamp
LastChangedByUser P_GRIRProcess LastChangedByUser User Name
ResponsibleDepartment P_GRIRProcess ResponsibleDepartment Processing Department
ResponsiblePerson P_GRIRProcess ResponsiblePerson Processor
GRIRClearingProcessStatus P_GRIRProcess GRIRClearingProcessStatus Status
GRIRClearingProcessPriority P_GRIRProcess GRIRClearingProcessPriority Priority
HasNote P_GRIRProcess HasNote TRUE
Note P_GRIRProcess Note TradeRequest Comment
LastChangeDate P_GRIRProcess LastChangeDate Time Stamp
PrpsdResponsibleDepartment P_GRIRProcess PrpsdResponsibleDepartment Proposed Processing Department
ProposedResponsiblePerson P_GRIRProcess ProposedResponsiblePerson Proposed Processor
GRIRClrgProcessPrpsdStatus P_GRIRProcess GRIRClrgProcessPrpsdStatus Proposed Status
GRIRClrgProcPrpsdPriority P_GRIRProcess GRIRClrgProcPrpsdPriority Proposed Priority
GRIRClearingProcessRootCause P_GRIRProcess GRIRClearingProcessRootCause Root Cause
GRIRClrgProcessPrpsdRootCause P_GRIRProcess GRIRClrgProcessPrpsdRootCause Proposed Root Cause
GRIRProposedStatusMaxClProblty P_GRIRProcess GRIRProposedStatusMaxClProblty Status Proposal Confidence
PrpsdRespDeptMaxClProbability P_GRIRProcess PrpsdRespDeptMaxClProbability Processing Department Proposal Confidence
PrpsdRespPersonMaxClassProblty P_GRIRProcess PrpsdRespPersonMaxClassProblty Processor Proposal Confidence
GRIRProposedPrioMaxClProblty P_GRIRProcess GRIRProposedPrioMaxClProblty Priority Proposal Confidence
GRIRPrpsdRootCauseMaxClProblty P_GRIRProcess GRIRPrpsdRootCauseMaxClProblty Root Cause Proposal Confidence
GRIRProcPrpslLastChangeDteTime P_GRIRProcess GRIRProcPrpslLastChangeDteTime Proposals Last Updated On
SystemMessageIdentification P_GRIRProcess SystemMessageIdentification Message ID
SystemMessageType P_GRIRProcess SystemMessageType Message type
SystemMessageNumber P_GRIRProcess SystemMessageNumber Message Number
SystemMessageVariable1 P_GRIRProcess SystemMessageVariable1 Variable 1
SystemMessageVariable2 P_GRIRProcess SystemMessageVariable2 Variable 2
SystemMessageVariable3 P_GRIRProcess SystemMessageVariable3 Variable 3
SystemMessageVariable4 P_GRIRProcess SystemMessageVariable4 Variable 4
SystemMessageText P_GRIRProcess SystemMessageText Message Text
_CompanyCode P_GRIRProcess _CompanyCode
_PurchasingDocument P_GRIRProcess _PurchasingDocument
_PurchasingDocumentItem P_GRIRProcess _PurchasingDocumentItem
_GRIRProcessStatus P_GRIRProcess _GRIRProcessStatus
_GRIRPrpsdStatus P_GRIRProcess _GRIRPrpsdStatus
_GRIRProcessPriority P_GRIRProcess _GRIRProcessPriority
_GRIRClrgProcPrpsdPriority P_GRIRProcess _GRIRClrgProcPrpsdPriority
_GRIRProcessRootCause P_GRIRProcess _GRIRProcessRootCause
_GRIRProcessPrpsdRootCause P_GRIRProcess _GRIRProcessPrpsdRootCause

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_GRIRProcess.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_GRIRProcess AS
SELECT
  P_GRIRProcess.CompanyCode AS CompanyCode,
  P_GRIRProcess.PurchasingDocument AS PurchasingDocument,
  P_GRIRProcess.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRProcess.LastChangeDateTime AS LastChangeDateTime,
  P_GRIRProcess.LastChangedByUser AS LastChangedByUser,
  P_GRIRProcess.ResponsibleDepartment AS ResponsibleDepartment,
  P_GRIRProcess.ResponsiblePerson AS ResponsiblePerson,
  P_GRIRProcess.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  P_GRIRProcess.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  P_GRIRProcess.HasNote AS HasNote,
  P_GRIRProcess.Note AS Note,
  P_GRIRProcess.LastChangeDate AS LastChangeDate,
  P_GRIRProcess.PrpsdResponsibleDepartment AS PrpsdResponsibleDepartment,
  P_GRIRProcess.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  P_GRIRProcess.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  P_GRIRProcess.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  P_GRIRProcess.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  P_GRIRProcess.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  P_GRIRProcess.GRIRProposedStatusMaxClProblty AS GRIRProposedStatusMaxClProblty,
  P_GRIRProcess.PrpsdRespDeptMaxClProbability AS PrpsdRespDeptMaxClProbability,
  P_GRIRProcess.PrpsdRespPersonMaxClassProblty AS PrpsdRespPersonMaxClassProblty,
  P_GRIRProcess.GRIRProposedPrioMaxClProblty AS GRIRProposedPrioMaxClProblty,
  P_GRIRProcess.GRIRPrpsdRootCauseMaxClProblty AS GRIRPrpsdRootCauseMaxClProblty,
  P_GRIRProcess.GRIRProcPrpslLastChangeDteTime AS GRIRProcPrpslLastChangeDteTime,
  P_GRIRProcess.SystemMessageIdentification AS SystemMessageIdentification,
  P_GRIRProcess.SystemMessageType AS SystemMessageType,
  P_GRIRProcess.SystemMessageNumber AS SystemMessageNumber,
  P_GRIRProcess.SystemMessageVariable1 AS SystemMessageVariable1,
  P_GRIRProcess.SystemMessageVariable2 AS SystemMessageVariable2,
  P_GRIRProcess.SystemMessageVariable3 AS SystemMessageVariable3,
  P_GRIRProcess.SystemMessageVariable4 AS SystemMessageVariable4,
  P_GRIRProcess.SystemMessageText AS SystemMessageText,
  P_GRIRProcess._CompanyCode AS _CompanyCode,
  P_GRIRProcess._PurchasingDocument AS _PurchasingDocument,
  P_GRIRProcess._PurchasingDocumentItem AS _PurchasingDocumentItem,
  P_GRIRProcess._GRIRProcessStatus AS _GRIRProcessStatus,
  P_GRIRProcess._GRIRPrpsdStatus AS _GRIRPrpsdStatus,
  P_GRIRProcess._GRIRProcessPriority AS _GRIRProcessPriority,
  P_GRIRProcess._GRIRClrgProcPrpsdPriority AS _GRIRClrgProcPrpsdPriority,
  P_GRIRProcess._GRIRProcessRootCause AS _GRIRProcessRootCause,
  P_GRIRProcess._GRIRProcessPrpsdRootCause AS _GRIRProcessPrpsdRootCause
FROM P_GRIRProcess
;