P_GRIRCLEARINGPROCESSCHANGE

CDS View
18 Fields 2 CDS Views

GR/IR Process History change

P_GRIRCLEARINGPROCESSCHANGE is a CDS View in S/4HANA. GR/IR Process History change. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_GRIRClearingProcessChange view from CONSUMPTION GRIR Clearing Process Change
C_GRIRClrgProcessedPurgDocItem view from CONSUMPTION GRIR Processed Purchasing Document Item

Fields (18)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY LastChangeDateTime LastChangeDateTime 1
KEY PurchasingDocument PurchasingDocument 2
KEY PurchasingDocumentItem PurchasingDocumentItem 2
_CompanyCode _CompanyCode 2
_PurchasingDocument _PurchasingDocument 2
_PurchasingDocumentItem _PurchasingDocumentItem 2
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
GRIRClrgProcessNumberOfChanges GRIRClrgProcessNumberOfChanges 1
GRIRClrgProcessResponsibleUser GRIRClrgProcessResponsibleUser 1
MaterialGroup MaterialGroup 2
Plant Plant 2
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
ResponsibleDepartment ResponsibleDepartment 1
Supplier Supplier 2

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 change
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRCLEARINGPROCESSCHANGE (
    COMPANYCODE,
    LASTCHANGEDATETIME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    GRIRCLRGPROCESSNUMBEROFCHANGES,
    GRIRCLRGPROCESSRESPONSIBLEUSER,
    MATERIALGROUP,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RESPONSIBLEDEPARTMENT,
    SUPPLIER,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More