P_GRIRProcess

DDL: P_GRIRPROCESS SQL: PFIGRIRPROCESS Type: view BASIC
40 Fields 1 Data Sources

P_GRIRProcess is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fins_grirproc) and exposes 40 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
fins_grirproc fins_grirproc from

Annotations (13)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PFIGRIRPROCESS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.representativeKey PurchasingDocumentItem view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
Search.searchable false view
ObjectModel.compositionRoot true view
ObjectModel.entityChangeStateId GRIRClearingProcessStatus view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode fins_grirproc companycode Receiver Company Code
KEY PurchasingDocument fins_grirproc purchasingdocument Purchasing Document
KEY PurchasingDocumentItem fins_grirproc purchasingdocumentitem Purchasing Doc. Item
LastChangeDateTime fins_grirproc lastchangedatetime Timestamp
LastChangedByUser fins_grirproc lastchangedbyuser User Name
ResponsibleDepartment fins_grirproc responsibledepartment Processing Department
ResponsiblePerson fins_grirproc responsibleperson Processor
GRIRClearingProcessStatus fins_grirproc grirclearingprocessstatus Status
GRIRClearingProcessPriority fins_grirproc grirclearingprocesspriority Priority
HasNote fins_grirproc hasnote TRUE
Note fins_grirproc note TradeRequest Comment
SystemMessageIdentification fins_grirproc systemmessageidentification Message ID
SystemMessageType fins_grirproc systemmessagetype Message type
SystemMessageNumber fins_grirproc systemmessagenumber Message Number
SystemMessageVariable1 fins_grirproc systemmessagevariable1 Variable 1
SystemMessageVariable2 fins_grirproc systemmessagevariable2 Variable 2
SystemMessageVariable3 fins_grirproc systemmessagevariable3 Variable 3
SystemMessageVariable4 fins_grirproc systemmessagevariable4 Variable 4
SystemMessageText fins_grirproc systemmessagetext Message Text
GRIRClearingProcessRootCause fins_grirproc grirclearingprocessrootcause Root Cause
PrpsdResponsibleDepartment fins_grirproc prpsdresponsibledepartment Proposed Processing Department
ProposedResponsiblePerson fins_grirproc proposedresponsibleperson Proposed Processor
GRIRClrgProcessPrpsdStatus fins_grirproc grirclrgprocessprpsdstatus Proposed Status
GRIRClrgProcPrpsdPriority fins_grirproc grirclrgprocprpsdpriority Proposed Priority
GRIRClrgProcessPrpsdRootCause fins_grirproc grirclrgprocessprpsdrootcause Proposed Root Cause
PrpsdRespDeptMaxClProbability fins_grirproc prpsdrespdeptmaxclprobability Processing Department Proposal Confidence
PrpsdRespPersonMaxClassProblty fins_grirproc prpsdresppersonmaxclassproblty Processor Proposal Confidence
GRIRProposedStatusMaxClProblty fins_grirproc grirproposedstatusmaxclproblty Status Proposal Confidence
GRIRProposedPrioMaxClProblty fins_grirproc grirproposedpriomaxclproblty Priority Proposal Confidence
GRIRPrpsdRootCauseMaxClProblty fins_grirproc grirprpsdrootcausemaxclproblty Root Cause Proposal Confidence
GRIRProcPrpslLastChangeDteTime fins_grirproc grirprocprpsllastchangedtetime Proposals Last Updated On
_CompanyCode _CompanyCode
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_GRIRProcessStatus _GRIRProcessStatus
_GRIRPrpsdStatus _GRIRPrpsdStatus
_GRIRProcessPriority _GRIRProcessPriority
_GRIRClrgProcPrpsdPriority _GRIRClrgProcPrpsdPriority
_GRIRProcessRootCause _GRIRProcessRootCause
_GRIRProcessPrpsdRootCause _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 P_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.
-- SQL view name: PFIGRIRPROCESS

CREATE VIEW P_GRIRProcess AS
SELECT
  fins_grirproc.companycode AS CompanyCode,
  fins_grirproc.purchasingdocument AS PurchasingDocument,
  fins_grirproc.purchasingdocumentitem AS PurchasingDocumentItem,
  fins_grirproc.lastchangedatetime AS LastChangeDateTime,
  fins_grirproc.lastchangedbyuser AS LastChangedByUser,
  fins_grirproc.responsibledepartment AS ResponsibleDepartment,
  fins_grirproc.responsibleperson AS ResponsiblePerson,
  fins_grirproc.grirclearingprocessstatus AS GRIRClearingProcessStatus,
  fins_grirproc.grirclearingprocesspriority AS GRIRClearingProcessPriority,
  fins_grirproc.hasnote AS HasNote,
  fins_grirproc.note AS Note,
  fins_grirproc.systemmessageidentification AS SystemMessageIdentification,
  fins_grirproc.systemmessagetype AS SystemMessageType,
  fins_grirproc.systemmessagenumber AS SystemMessageNumber,
  fins_grirproc.systemmessagevariable1 AS SystemMessageVariable1,
  fins_grirproc.systemmessagevariable2 AS SystemMessageVariable2,
  fins_grirproc.systemmessagevariable3 AS SystemMessageVariable3,
  fins_grirproc.systemmessagevariable4 AS SystemMessageVariable4,
  fins_grirproc.systemmessagetext AS SystemMessageText,
  fins_grirproc.grirclearingprocessrootcause AS GRIRClearingProcessRootCause,
  fins_grirproc.prpsdresponsibledepartment AS PrpsdResponsibleDepartment,
  fins_grirproc.proposedresponsibleperson AS ProposedResponsiblePerson,
  fins_grirproc.grirclrgprocessprpsdstatus AS GRIRClrgProcessPrpsdStatus,
  fins_grirproc.grirclrgprocprpsdpriority AS GRIRClrgProcPrpsdPriority,
  fins_grirproc.grirclrgprocessprpsdrootcause AS GRIRClrgProcessPrpsdRootCause,
  fins_grirproc.prpsdrespdeptmaxclprobability AS PrpsdRespDeptMaxClProbability,
  fins_grirproc.prpsdresppersonmaxclassproblty AS PrpsdRespPersonMaxClassProblty,
  fins_grirproc.grirproposedstatusmaxclproblty AS GRIRProposedStatusMaxClProblty,
  fins_grirproc.grirproposedpriomaxclproblty AS GRIRProposedPrioMaxClProblty,
  fins_grirproc.grirprpsdrootcausemaxclproblty AS GRIRPrpsdRootCauseMaxClProblty,
  fins_grirproc.grirprocprpsllastchangedtetime AS GRIRProcPrpslLastChangeDteTime
FROM fins_grirproc
;

Learn More