P_GRIRPROCHISTPREDECESSOR

CDS View
67 Fields 3 CDS Views

P_GRIRPROCHISTPREDECESSOR is a CDS View in S/4HANA. It contains 67 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_GRIRProcessSituation view inner CONSUMPTION Situation in GR/IR Process History
P_GRIRProcHistoryFirstChange1 view from CONSUMPTION
P_GRIRProcHistoryLastChange1 view from CONSUMPTION

Fields (67)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY LastChangeDateTime LastChangeDateTime 1
KEY PurchasingDocument PurchasingDocument 1
KEY PurchasingDocumentItem PurchasingDocumentItem 1
_CompanyCode _CompanyCode 1
_PurchasingDocument _PurchasingDocument 1
_PurchasingDocumentItem _PurchasingDocumentItem 1
AccountAssignmentCategory AccountAssignmentCategory 1
BalAmtInCompanyCodeCrcy BalAmtInCompanyCodeCrcy 1
BalanceQuantity BalanceQuantity 1
CompanyCodeCurrency CompanyCodeCurrency 1
DeliveryCostBalAmtInCCCrcy DeliveryCostBalAmtInCCCrcy 1
DeliveryCostBalanceQuantity DeliveryCostBalanceQuantity 1
DueDays DueDays 1
GdsRcptDelivCostAmtInCCCrcy GdsRcptDelivCostAmtInCCCrcy 1
GoodsBalanceAmountInCCCrcy GoodsBalanceAmountInCCCrcy 1
GoodsBalanceQuantity GoodsBalanceQuantity 1
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmountInCoCodeCrcy 1
GoodsReceiptDeliveryCostQty GoodsReceiptDeliveryCostQty 1
GoodsReceiptGoodsAmtInCCCrcy GoodsReceiptGoodsAmtInCCCrcy 1
GoodsReceiptGoodsQuantity GoodsReceiptGoodsQuantity 1
GoodsReceiptQty GoodsReceiptQty 1
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 1
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 1
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 1
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 1
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 1
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 1
HasNote HasNote 1
InvcRcptDelivCostAmtInCCCrcy InvcRcptDelivCostAmtInCCCrcy 1
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy 1
InvoiceRcptDeliveryCostQty InvoiceRcptDeliveryCostQty 1
InvoiceRcptGoodsAmtInCCCrcy InvoiceRcptGoodsAmtInCCCrcy 1
InvoiceReceiptGoodsQuantity InvoiceReceiptGoodsQuantity 1
InvoiceReceiptQty InvoiceReceiptQty 1
IsFinallyInvoiced IsFinallyInvoiced 1
IsGdsRcptDelivCostAmtSurplus IsGdsRcptDelivCostAmtSurplus 1
IsGdsRcptDelivCostQtySurplus IsGdsRcptDelivCostQtySurplus 1
IsGoodsRcptGoodsAmtSurplus IsGoodsRcptGoodsAmtSurplus 1
IsGoodsRcptGoodsQtySurplus IsGoodsRcptGoodsQtySurplus 1
IsInvoiceDelivCostAmtSurplus IsInvoiceDelivCostAmtSurplus 1
IsInvoiceDelivCostQtySurplus IsInvoiceDelivCostQtySurplus 1
IsInvoiceGoodsAmountSurplus IsInvoiceGoodsAmountSurplus 1
IsInvoiceGoodsQtySurplus IsInvoiceGoodsQtySurplus 1
LastChangedByUser LastChangedByUser 1
LatestOpenItemPostingDate LatestOpenItemPostingDate 1
MaterialGroup MaterialGroup 1
NumberOfGoodsReceipts NumberOfGoodsReceipts 1
NumberOfInvoiceReceipts NumberOfInvoiceReceipts 1
OldestOpenItemPostingDate OldestOpenItemPostingDate 1
Plant Plant 1
ProposedResponsiblePerson ProposedResponsiblePerson 1
PrpsdRespDeptMaxClProbability PrpsdRespDeptMaxClProbability 1
PrpsdResponsibleDepartment PrpsdResponsibleDepartment 1
PrpsdRespPersonMaxClassProblty PrpsdRespPersonMaxClassProblty 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 1
ResponsibleDepartment ResponsibleDepartment 1
ResponsiblePerson ResponsiblePerson 1
Supplier Supplier 1
SystemMessageIdentification SystemMessageIdentification 1
SystemMessageNumber SystemMessageNumber 1
SystemMessageType SystemMessageType 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCHISTPREDECESSOR (
    COMPANYCODE,
    LASTCHANGEDATETIME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    BALAMTINCOMPANYCODECRCY,
    BALANCEQUANTITY,
    COMPANYCODECURRENCY,
    DELIVERYCOSTBALAMTINCCCRCY,
    DELIVERYCOSTBALANCEQUANTITY,
    DUEDAYS,
    GDSRCPTDELIVCOSTAMTINCCCRCY,
    GOODSBALANCEAMOUNTINCCCRCY,
    GOODSBALANCEQUANTITY,
    GOODSRECEIPTAMOUNTINCOCODECRCY,
    GOODSRECEIPTDELIVERYCOSTQTY,
    GOODSRECEIPTGOODSAMTINCCCRCY,
    GOODSRECEIPTGOODSQUANTITY,
    GOODSRECEIPTQTY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    GRIRCLRGPROCESSPRPSDROOTCAUSE,
    GRIRCLRGPROCESSPRPSDSTATUS,
    GRIRCLRGPROCPRPSDPRIORITY,
    GRIRPROPOSEDPRIOMAXCLPROBLTY,
    GRIRPROPOSEDSTATUSMAXCLPROBLTY,
    GRIRPRPSDROOTCAUSEMAXCLPROBLTY,
    HASNOTE,
    INVCRCPTDELIVCOSTAMTINCCCRCY,
    INVOICERCPTAMTINCOCODECRCY,
    INVOICERCPTDELIVERYCOSTQTY,
    INVOICERCPTGOODSAMTINCCCRCY,
    INVOICERECEIPTGOODSQUANTITY,
    INVOICERECEIPTQTY,
    ISFINALLYINVOICED,
    ISGDSRCPTDELIVCOSTAMTSURPLUS,
    ISGDSRCPTDELIVCOSTQTYSURPLUS,
    ISGOODSRCPTGOODSAMTSURPLUS,
    ISGOODSRCPTGOODSQTYSURPLUS,
    ISINVOICEDELIVCOSTAMTSURPLUS,
    ISINVOICEDELIVCOSTQTYSURPLUS,
    ISINVOICEGOODSAMOUNTSURPLUS,
    ISINVOICEGOODSQTYSURPLUS,
    LASTCHANGEDBYUSER,
    LATESTOPENITEMPOSTINGDATE,
    MATERIALGROUP,
    NUMBEROFGOODSRECEIPTS,
    NUMBEROFINVOICERECEIPTS,
    OLDESTOPENITEMPOSTINGDATE,
    PLANT,
    PROPOSEDRESPONSIBLEPERSON,
    PRPSDRESPDEPTMAXCLPROBABILITY,
    PRPSDRESPONSIBLEDEPARTMENT,
    PRPSDRESPPERSONMAXCLASSPROBLTY,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCORDERQUANTITYUNIT,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    SYSTEMMESSAGETYPE,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More