P_GRIRPROCHISTRESPUSERCHANGE1

CDS View
12 Fields 1 CDS Views

GR/IR Proc. Hist. resp usr chge w. start

P_GRIRPROCHISTRESPUSERCHANGE1 is a CDS View in S/4HANA. GR/IR Proc. Hist. resp usr chge w. start. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GRIRProcHistRespUserChange2 view from CONSUMPTION GR/IR Process History status change

Fields (12)

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
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 Proc. Hist. resp usr chge w. start
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCHISTRESPUSERCHANGE1 (
    COMPANYCODE,
    LASTCHANGEDATETIME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    ACCOUNTASSIGNMENTCATEGORY,
    GRIRCLRGPROCESSRESPONSIBLEUSER,
    GRIRCLRGPROCNEXTCHANGEDATETIME,
    MATERIALGROUP,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More