P_GRIRSITUATIONTRIGGER

CDS View
19 Fields 2 CDS Views

GRIR Sitatuation Handling Trigger View

P_GRIRSITUATIONTRIGGER is a CDS View in S/4HANA. GRIR Sitatuation Handling Trigger View. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_GRIRDeviationSituation view_entity from CONSUMPTION Situation View Deviations on GR/IR Account Reconciliation
C_GRIRProcessingSituation view_entity from CONSUMPTION GR/IR Processing Situation for Situation Handling

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY PurchasingDocument PurchasingDocument 1
KEY PurchasingDocumentItem PurchasingDocumentItem 1
_Supplier _Supplier 1
BalAmtInCompanyCodeCrcy BalAmtInCompanyCodeCrcy 1
BalanceAbsoluteAmtInCoCodeCrcy BalanceAbsoluteAmtInCoCodeCrcy 1
CompanyCodeCurrency CompanyCodeCurrency 1
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
LastChangeDays LastChangeDays 1
LastChangedByUser LastChangedByUser 1
NumberOfDaysSinceLastPosting NumberOfDaysSinceLastPosting 1
Plant Plant 1
PurchasingDocumentItemUniqueID PurchasingDocumentItemUniqueID 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
ResponsiblePerson ResponsiblePerson 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.

-- GRIR Sitatuation Handling Trigger View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRSITUATIONTRIGGER (
    COMPANYCODE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _SUPPLIER,
    BALAMTINCOMPANYCODECRCY,
    BALANCEABSOLUTEAMTINCOCODECRCY,
    COMPANYCODECURRENCY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    LASTCHANGEDAYS,
    LASTCHANGEDBYUSER,
    NUMBEROFDAYSSINCELASTPOSTING,
    PLANT,
    PURCHASINGDOCUMENTITEMUNIQUEID,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RESPONSIBLEPERSON,
    SUPPLIER,
    PRIMARY KEY (COMPANYCODE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More