P_GRIRPROCHISTRESPUSERCHANGE2

CDS View
13 Fields 1 CDS Views

GR/IR Process History status change

P_GRIRPROCHISTRESPUSERCHANGE2 is a CDS View in S/4HANA. GR/IR Process History status change. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GRIRProcHistRespUserChange3 view from CONSUMPTION GR/IR Process History resp user change

Fields (13)

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

-- GR/IR Process History status change
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCHISTRESPUSERCHANGE2 (
    COMPANYCODE,
    LASTCHANGEDATETIME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    GRIRCLRGPROCESSRESPONSIBLEUSER,
    GRIRCLRGPROCNEXTCHANGEDATETIME,
    GRIRCLRGPROCNEXTRESPONSIBLEUSR,
    MATERIALGROUP,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More