P_GRIRPROCESSHISTORYFIRSTCHGE

CDS View
9 Fields 5 CDS Views

P_GRIRPROCESSHISTORYFIRSTCHGE is a CDS View in S/4HANA. It contains 9 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_GRIRProcHistPrioChange1 view union CONSUMPTION GR/IR Proc. History prio change w. start
P_GRIRProcHistRespDpmtChange1 view union CONSUMPTION GR/IR Proc. Hist. Resp Dpt chge w. start
P_GRIRProcHistRespUserChange1 view union CONSUMPTION GR/IR Proc. Hist. resp usr chge w. start
P_GRIRProcHistRootCauseChange1 view union CONSUMPTION GR/IR Proc. Hist. Root Cse chge w. start
P_GRIRProcHistStatusChange1 view union CONSUMPTION GR/IR Proc. History status chge w. start

Fields (9)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocument PurchasingDocument 5
KEY PurchasingDocumentItem PurchasingDocumentItem 5
AccountAssignmentCategory AccountAssignmentCategory 5
LastChangeDateTime GRIRClrgProcNextChangeDateTime 5
MaterialGroup MaterialGroup 5
Plant Plant 5
PurchasingGroup PurchasingGroup 5
PurchasingOrganization PurchasingOrganization 5
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCESSHISTORYFIRSTCHGE (
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    LASTCHANGEDATETIME,
    MATERIALGROUP,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PRIMARY KEY (PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More