I_GRIRProcess
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)
| Source | Alias | Join Type |
|---|---|---|
| P_GRIRProcess | P_GRIRProcess | from |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA