P_GRIRPROCESSHISTORYLASTCHANGE

CDS View
14 Fields 6 CDS Views

GR/IR Process History Last Change

P_GRIRPROCESSHISTORYLASTCHANGE is a CDS View in S/4HANA. GR/IR Process History Last Change. It contains 14 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_GRIRProcessSituation view_entity from CONSUMPTION Situation in GR/IR Process History
P_GRIRProcHistPrioChange3 view union CONSUMPTION GR/IR Process History prio change
P_GRIRProcHistRespDpmtChange3 view union CONSUMPTION GR/IR Process History Resp Dpmt change
P_GRIRProcHistRespUserChange3 view union CONSUMPTION GR/IR Process History resp user change
P_GRIRProcHistRootCauseChange3 view union CONSUMPTION GR/IR Process History Root Cause change
P_GRIRProcHistStatusChange3 view union CONSUMPTION GR/IR Process History status change

Fields (14)

KeyField CDS FieldsUsed in Views
KEY LastChangeDateTime LastChangeDateTime 5
KEY PurchasingDocument PurchasingDocument 5
KEY PurchasingDocumentItem PurchasingDocumentItem 5
AccountAssignmentCategory AccountAssignmentCategory 5
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
MaterialGroup MaterialGroup 5
Plant Plant 5
PurchasingGroup PurchasingGroup 5
PurchasingOrganization PurchasingOrganization 5
ResponsibleDepartment ResponsibleDepartment 1
ResponsiblePerson GRIRClrgProcessResponsibleUser 1
Supplier Supplier 5

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.

-- GR/IR Process History Last Change
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCESSHISTORYLASTCHANGE (
    LASTCHANGEDATETIME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    MATERIALGROUP,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    PRIMARY KEY (LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More