C_GRIRProcess

DDL: C_GRIRPROCESS Type: view_entity CONSUMPTION
38 Fields 1 Data Sources 2 Associations

GR/IR Process

C_GRIRProcess is a Consumption CDS View that provides data about "GR/IR Process" in SAP S/4HANA. It reads from 1 data source (I_GRIRProcess) and exposes 38 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_GRIRProcess I_GRIRProcess projection

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.ContactCardID
[0..1] I_UserContactCard _ResponsiblePerson $projection.ResponsiblePerson = _ResponsiblePerson.ContactCardID

Annotations (10)

NameValueLevelField
UI.headerInfo.typeNamePlural GRIR Status view
UI.headerInfo.typeName Status view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey PurchasingDocumentItem view
VDM.viewType #CONSUMPTION view
EndUserText.label GR/IR Process view
AccessControl.authorizationCheck #CHECK view

Fields (38)

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

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 C_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 C_GRIRProcess AS
SELECT
  I_GRIRProcess.CompanyCode AS CompanyCode,
  I_GRIRProcess.PurchasingDocument AS PurchasingDocument,
  I_GRIRProcess.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GRIRProcess.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  I_GRIRProcess.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  I_GRIRProcess.HasNote AS HasNote,
  I_GRIRProcess.LastChangeDate AS LastChangeDate,
  I_GRIRProcess.LastChangeDateTime AS LastChangeDateTime,
  I_GRIRProcess.LastChangedByUser AS LastChangedByUser,
  I_GRIRProcess.Note AS Note,
  I_GRIRProcess.ResponsibleDepartment AS ResponsibleDepartment,
  I_GRIRProcess.ResponsiblePerson AS ResponsiblePerson,
  I_GRIRProcess.PrpsdResponsibleDepartment AS PrpsdResponsibleDepartment,
  I_GRIRProcess.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  I_GRIRProcess.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  I_GRIRProcess.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  I_GRIRProcess.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  I_GRIRProcess.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  I_GRIRProcess.GRIRProposedStatusMaxClProblty AS GRIRProposedStatusMaxClProblty,
  I_GRIRProcess.PrpsdRespDeptMaxClProbability AS PrpsdRespDeptMaxClProbability,
  I_GRIRProcess.PrpsdRespPersonMaxClassProblty AS PrpsdRespPersonMaxClassProblty,
  I_GRIRProcess.GRIRProposedPrioMaxClProblty AS GRIRProposedPrioMaxClProblty,
  I_GRIRProcess.GRIRPrpsdRootCauseMaxClProblty AS GRIRPrpsdRootCauseMaxClProblty,
  I_GRIRProcess.SystemMessageIdentification AS SystemMessageIdentification,
  I_GRIRProcess.SystemMessageNumber AS SystemMessageNumber,
  I_GRIRProcess.SystemMessageType AS SystemMessageType,
  I_GRIRProcess.SystemMessageVariable1 AS SystemMessageVariable1,
  I_GRIRProcess.SystemMessageVariable2 AS SystemMessageVariable2,
  I_GRIRProcess.SystemMessageVariable3 AS SystemMessageVariable3,
  I_GRIRProcess.SystemMessageVariable4 AS SystemMessageVariable4,
  I_GRIRProcess.SystemMessageText AS SystemMessageText,
  I_GRIRProcess._CompanyCode AS _CompanyCode,
  I_GRIRProcess._PurchasingDocument AS _PurchasingDocument,
  I_GRIRProcess._PurchasingDocumentItem AS _PurchasingDocumentItem,
  I_GRIRProcess._GRIRProcessStatus AS _GRIRProcessStatus,
  I_GRIRProcess._GRIRProcessRootCause AS _GRIRProcessRootCause
FROM I_GRIRProcess
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ContactCardID  -- association [0..1]
;

Learn More