P_GRIRProcessHistory
P_GRIRProcessHistory is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fins_grirprochis) and exposes 65 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem, LastChangeDateTime.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| fins_grirprochis | fins_grirprochis | from |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PFIGRIRHISTORY | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view | |
| ObjectModel.representativeKey | LastChangeDateTime | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view |
Fields (65)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | fins_grirprochis | companycode | Receiver Company Code |
| KEY | PurchasingDocument | fins_grirprochis | purchasingdocument | Purchasing Document |
| KEY | PurchasingDocumentItem | fins_grirprochis | purchasingdocumentitem | Purchasing Doc. Item |
| KEY | LastChangeDateTime | fins_grirprochis | lastchangedatetime | Timestamp |
| LastChangedByUser | fins_grirprochis | lastchangedbyuser | User Name | |
| ResponsibleDepartment | fins_grirprochis | responsibledepartment | Processing Department | |
| ResponsiblePerson | fins_grirprochis | responsibleperson | Processor | |
| GRIRClearingProcessStatus | fins_grirprochis | grirclearingprocessstatus | Status | |
| GRIRClearingProcessPriority | fins_grirprochis | grirclearingprocesspriority | Priority | |
| HasNote | fins_grirprochis | hasnote | TRUE | |
| Note | fins_grirprochis | note | TradeRequest Comment | |
| SystemMessageIdentification | fins_grirprochis | systemmessageidentification | Message ID | |
| SystemMessageType | fins_grirprochis | systemmessagetype | Message type | |
| SystemMessageNumber | fins_grirprochis | systemmessagenumber | Message Number | |
| AccountAssignmentCategory | fins_grirprochis | accountassignmentcategory | Acct Assgmt Cat | |
| BalAmtInCompanyCodeCrcy | fins_grirprochis | balamtincompanycodecrcy | Balance Amount | |
| BalanceQuantity | fins_grirprochis | balancequantity | Balance Quantity | |
| IsFinallyInvoiced | fins_grirprochis | isfinallyinvoiced | Final Invoice | |
| LatestOpenItemPostingDate | fins_grirprochis | latestopenitempostingdate | Latest Posting Date | |
| MaterialGroup | fins_grirprochis | materialgroup | Product Group | |
| NumberOfGoodsReceipts | fins_grirprochis | numberofgoodsreceipts | Number of Goods Receipts | |
| NumberOfInvoiceReceipts | fins_grirprochis | numberofinvoicereceipts | Number of Invoice Receipts | |
| OldestOpenItemPostingDate | fins_grirprochis | oldestopenitempostingdate | Oldest Posting Date | |
| Plant | fins_grirprochis | plant | Valuation Area | |
| PurchasingGroup | fins_grirprochis | purchasinggroup | Purchasing Group | |
| PurchasingOrganization | fins_grirprochis | purchasingorganization | Purchasing Organization | |
| Supplier | fins_grirprochis | supplier | Supplier | |
| SystemMessageVariable1 | fins_grirprochis | systemmessagevariable1 | Variable 1 | |
| SystemMessageVariable2 | fins_grirprochis | systemmessagevariable2 | Variable 2 | |
| SystemMessageVariable3 | fins_grirprochis | systemmessagevariable3 | Variable 3 | |
| SystemMessageVariable4 | fins_grirprochis | systemmessagevariable4 | Variable 4 | |
| SystemMessageText | fins_grirprochis | systemmessagetext | Message Text | |
| DueDays | fins_grirprochis | duedays | Processing Time | |
| CompanyCodeCurrency | fins_grirprochis | companycodecurrency | Local Currency | |
| PurgDocOrderQuantityUnit | fins_grirprochis | purgdocorderquantityunit | Purchasing Document Order Qty Unit | |
| PrpsdResponsibleDepartment | fins_grirprochis | prpsdresponsibledepartment | Proposed Processing Department | |
| ProposedResponsiblePerson | fins_grirprochis | proposedresponsibleperson | Proposed Processor | |
| GRIRClrgProcessPrpsdStatus | fins_grirprochis | grirclrgprocessprpsdstatus | Proposed Status | |
| GRIRClrgProcPrpsdPriority | fins_grirprochis | grirclrgprocprpsdpriority | Proposed Priority | |
| GRIRClearingProcessRootCause | fins_grirprochis | grirclearingprocessrootcause | Root Cause | |
| GRIRClrgProcessPrpsdRootCause | fins_grirprochis | grirclrgprocessprpsdrootcause | Proposed Root Cause | |
| PrpsdRespDeptMaxClProbability | fins_grirprochis | prpsdrespdeptmaxclprobability | Processing Department Proposal Confidence | |
| PrpsdRespPersonMaxClassProblty | fins_grirprochis | prpsdresppersonmaxclassproblty | Processor Proposal Confidence | |
| GRIRProposedStatusMaxClProblty | fins_grirprochis | grirproposedstatusmaxclproblty | Status Proposal Confidence | |
| GRIRProposedPrioMaxClProblty | fins_grirprochis | grirproposedpriomaxclproblty | Priority Proposal Confidence | |
| GRIRPrpsdRootCauseMaxClProblty | fins_grirprochis | grirprpsdrootcausemaxclproblty | Root Cause Proposal Confidence | |
| GoodsReceiptGoodsAmtInCCCrcy | fins_grirprochis | goodsreceiptgoodsamtincccrcy | Goods Receipt Amount (Goods) | |
| InvoiceRcptGoodsAmtInCCCrcy | fins_grirprochis | invoicercptgoodsamtincccrcy | Invoice Receipt Amount (Goods) | |
| GdsRcptDelivCostAmtInCCCrcy | fins_grirprochis | gdsrcptdelivcostamtincccrcy | Goods Receipt Amount (Delivery Costs) | |
| InvcRcptDelivCostAmtInCCCrcy | fins_grirprochis | invcrcptdelivcostamtincccrcy | Invoice Receipt Amount (Delivery Costs) | |
| GoodsReceiptGoodsQuantity | fins_grirprochis | goodsreceiptgoodsquantity | Goods Receipt Quantity (Goods) | |
| InvoiceReceiptGoodsQuantity | fins_grirprochis | invoicereceiptgoodsquantity | Invoice Receipt Quantity (Goods) | |
| GoodsReceiptDeliveryCostQty | fins_grirprochis | goodsreceiptdeliverycostqty | Goods Receipt Quantity (Delivery Costs) | |
| InvoiceRcptDeliveryCostQty | fins_grirprochis | invoicercptdeliverycostqty | Invoice Receipt Quantity (Deliv. Costs) | |
| GoodsBalanceAmountInCCCrcy | ||||
| GoodsBalanceQuantity | ||||
| DeliveryCostBalAmtInCCCrcy | ||||
| DeliveryCostBalanceQuantity | ||||
| GoodsReceiptAmountInCoCodeCrcy | ||||
| GoodsReceiptQty | ||||
| InvoiceRcptAmtInCoCodeCrcy | ||||
| InvoiceReceiptQty | ||||
| _CompanyCode | _CompanyCode | |||
| _PurchasingDocument | _PurchasingDocument | |||
| _PurchasingDocumentItem | _PurchasingDocumentItem |
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_GRIRProcessHistory.
-- 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: PFIGRIRHISTORY
CREATE VIEW P_GRIRProcessHistory AS
SELECT
fins_grirprochis.companycode AS CompanyCode,
fins_grirprochis.purchasingdocument AS PurchasingDocument,
fins_grirprochis.purchasingdocumentitem AS PurchasingDocumentItem,
fins_grirprochis.lastchangedatetime AS LastChangeDateTime,
fins_grirprochis.lastchangedbyuser AS LastChangedByUser,
fins_grirprochis.responsibledepartment AS ResponsibleDepartment,
fins_grirprochis.responsibleperson AS ResponsiblePerson,
fins_grirprochis.grirclearingprocessstatus AS GRIRClearingProcessStatus,
fins_grirprochis.grirclearingprocesspriority AS GRIRClearingProcessPriority,
fins_grirprochis.hasnote AS HasNote,
fins_grirprochis.note AS Note,
fins_grirprochis.systemmessageidentification AS SystemMessageIdentification,
fins_grirprochis.systemmessagetype AS SystemMessageType,
fins_grirprochis.systemmessagenumber AS SystemMessageNumber,
fins_grirprochis.accountassignmentcategory AS AccountAssignmentCategory,
fins_grirprochis.balamtincompanycodecrcy AS BalAmtInCompanyCodeCrcy,
fins_grirprochis.balancequantity AS BalanceQuantity,
fins_grirprochis.isfinallyinvoiced AS IsFinallyInvoiced,
fins_grirprochis.latestopenitempostingdate AS LatestOpenItemPostingDate,
fins_grirprochis.materialgroup AS MaterialGroup,
fins_grirprochis.numberofgoodsreceipts AS NumberOfGoodsReceipts,
fins_grirprochis.numberofinvoicereceipts AS NumberOfInvoiceReceipts,
fins_grirprochis.oldestopenitempostingdate AS OldestOpenItemPostingDate,
fins_grirprochis.plant AS Plant,
fins_grirprochis.purchasinggroup AS PurchasingGroup,
fins_grirprochis.purchasingorganization AS PurchasingOrganization,
fins_grirprochis.supplier AS Supplier,
fins_grirprochis.systemmessagevariable1 AS SystemMessageVariable1,
fins_grirprochis.systemmessagevariable2 AS SystemMessageVariable2,
fins_grirprochis.systemmessagevariable3 AS SystemMessageVariable3,
fins_grirprochis.systemmessagevariable4 AS SystemMessageVariable4,
fins_grirprochis.systemmessagetext AS SystemMessageText,
fins_grirprochis.duedays AS DueDays,
fins_grirprochis.companycodecurrency AS CompanyCodeCurrency,
fins_grirprochis.purgdocorderquantityunit AS PurgDocOrderQuantityUnit,
fins_grirprochis.prpsdresponsibledepartment AS PrpsdResponsibleDepartment,
fins_grirprochis.proposedresponsibleperson AS ProposedResponsiblePerson,
fins_grirprochis.grirclrgprocessprpsdstatus AS GRIRClrgProcessPrpsdStatus,
fins_grirprochis.grirclrgprocprpsdpriority AS GRIRClrgProcPrpsdPriority,
fins_grirprochis.grirclearingprocessrootcause AS GRIRClearingProcessRootCause,
fins_grirprochis.grirclrgprocessprpsdrootcause AS GRIRClrgProcessPrpsdRootCause,
fins_grirprochis.prpsdrespdeptmaxclprobability AS PrpsdRespDeptMaxClProbability,
fins_grirprochis.prpsdresppersonmaxclassproblty AS PrpsdRespPersonMaxClassProblty,
fins_grirprochis.grirproposedstatusmaxclproblty AS GRIRProposedStatusMaxClProblty,
fins_grirprochis.grirproposedpriomaxclproblty AS GRIRProposedPrioMaxClProblty,
fins_grirprochis.grirprpsdrootcausemaxclproblty AS GRIRPrpsdRootCauseMaxClProblty,
fins_grirprochis.goodsreceiptgoodsamtincccrcy AS GoodsReceiptGoodsAmtInCCCrcy,
fins_grirprochis.invoicercptgoodsamtincccrcy AS InvoiceRcptGoodsAmtInCCCrcy,
fins_grirprochis.gdsrcptdelivcostamtincccrcy AS GdsRcptDelivCostAmtInCCCrcy,
fins_grirprochis.invcrcptdelivcostamtincccrcy AS InvcRcptDelivCostAmtInCCCrcy,
fins_grirprochis.goodsreceiptgoodsquantity AS GoodsReceiptGoodsQuantity,
fins_grirprochis.invoicereceiptgoodsquantity AS InvoiceReceiptGoodsQuantity,
fins_grirprochis.goodsreceiptdeliverycostqty AS GoodsReceiptDeliveryCostQty,
fins_grirprochis.invoicercptdeliverycostqty AS InvoiceRcptDeliveryCostQty,
fins_grirprochis.goodsreceiptgoodsamtincccrcy + fins_grirprochis.invoicercptgoodsamtincccrcy AS GoodsBalanceAmountInCCCrcy,
fins_grirprochis.goodsreceiptgoodsquantity + fins_grirprochis.invoicereceiptgoodsquantity AS GoodsBalanceQuantity,
fins_grirprochis.gdsrcptdelivcostamtincccrcy + fins_grirprochis.invcrcptdelivcostamtincccrcy AS DeliveryCostBalAmtInCCCrcy,
fins_grirprochis.goodsreceiptdeliverycostqty + fins_grirprochis.invoicercptdeliverycostqty AS DeliveryCostBalanceQuantity,
fins_grirprochis.goodsreceiptgoodsamtincccrcy + fins_grirprochis.gdsrcptdelivcostamtincccrcy AS GoodsReceiptAmountInCoCodeCrcy,
fins_grirprochis.goodsreceiptgoodsquantity + fins_grirprochis.goodsreceiptdeliverycostqty AS GoodsReceiptQty,
fins_grirprochis.invoicercptgoodsamtincccrcy + fins_grirprochis.invcrcptdelivcostamtincccrcy AS InvoiceRcptAmtInCoCodeCrcy,
fins_grirprochis.invoicereceiptgoodsquantity + fins_grirprochis.invoicercptdeliverycostqty AS InvoiceReceiptQty
FROM fins_grirprochis
;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