FINS_GRIRPROC

Transparent Table Application Table
32 Fields 1 CDS Views

GR/IR Clearing Process

FINS_GRIRPROC is an SAP database table in S/4HANA. GR/IR Clearing Process. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GRIRProcess view from BASIC

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY companycode BUKRS Company Code
KEY purchasingdocument FIS_EBELN Purchasing Document
KEY purchasingdocumentitem FIS_EBELP Purchasing Doc. Item
lastchangedatetime FIS_GRIR_LASTCHANGEDATETIME Last Changed On
lastchangedbyuser FIS_GRIR_LASTCHANGEDBYUSER Last Changed By
responsibledepartment FIS_GRIR_RESPONSIBLE_DPMNT Processing Department
responsibleperson FIS_GRIR_RESPONSIBLE_USER Processor
grirclearingprocessstatus FIS_GRIR_CLEARING_STATUS Status
grirclearingprocesspriority FIS_GRIR_PRIORITY Priority
hasnote FIS_GRIR_HAS_NOTE Notes
note FIS_NOTE Note
grirclearingprocessrootcause FIS_GRIR_CLRG_ROOT_CAUSE Root Cause
systemmessageidentification MSGID Message ID
systemmessagetype MSGTY Message Type
systemmessagenumber MSGNR Message
systemmessagevariable1 MSGV1 Message var.
systemmessagevariable2 MSGV2 Message var.
systemmessagevariable3 MSGV3 Message var.
systemmessagevariable4 MSGV4 Message var.
systemmessagetext NATXT Message Text
prpsdresponsibledepartment FIS_GRIR_P_RESPONSIBLE_DPMNT Proposed Processing Department
proposedresponsibleperson FIS_GRIR_P_RESPONSIBLE_USER Proposed Processor
grirclrgprocessprpsdstatus FIS_GRIR_P_CLEARING_STATUS Proposed Status
grirclrgprocprpsdpriority FIS_GRIR_P_PRIORITY Proposed Priority
grirclrgprocessprpsdrootcause FIS_GRIR_P_CLRG_ROOT_CAUSE Proposed Root Cause
prpsdrespdeptmaxclprobability FIS_GRIR_P_DEPARTMENT_CONF Processing Department Proposal Confidence
prpsdresppersonmaxclassproblty FIS_GRIR_P_RESPONSIBLE_CONF Processor Proposal Confidence
grirproposedstatusmaxclproblty FIS_GRIR_P_STATUS_CONF Status Proposal Confidence
grirproposedpriomaxclproblty FIS_GRIR_P_PRIORITY_CONF Priority Proposal Confidence
grirprpsdrootcausemaxclproblty FIS_GRIR_P_ROOTCAUSE_CONF Root Cause Proposal Confidence
grirprocprpsllastchangedtetime FIS_GRIR_P_LASTCHANGEDATETIME Proposals Last Updated On

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 Clearing Process
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_GRIRPROC (
    CLIENT,                          -- Client [MANDT]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGDOCUMENT,              -- Purchasing Document [FIS_EBELN]
    PURCHASINGDOCUMENTITEM,          -- Purchasing Doc. Item [FIS_EBELP]
    LASTCHANGEDATETIME,              -- Last Changed On [FIS_GRIR_LASTCHANGEDATETIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [FIS_GRIR_LASTCHANGEDBYUSER]
    RESPONSIBLEDEPARTMENT,           -- Processing Department [FIS_GRIR_RESPONSIBLE_DPMNT]
    RESPONSIBLEPERSON,               -- Processor [FIS_GRIR_RESPONSIBLE_USER]
    GRIRCLEARINGPROCESSSTATUS,       -- Status [FIS_GRIR_CLEARING_STATUS]
    GRIRCLEARINGPROCESSPRIORITY,     -- Priority [FIS_GRIR_PRIORITY]
    HASNOTE,                         -- Notes [FIS_GRIR_HAS_NOTE]
    NOTE,                            -- Note [FIS_NOTE]
    GRIRCLEARINGPROCESSROOTCAUSE,    -- Root Cause [FIS_GRIR_CLRG_ROOT_CAUSE]
    SYSTEMMESSAGEIDENTIFICATION,     -- Message ID [MSGID]
    SYSTEMMESSAGETYPE,               -- Message Type [MSGTY]
    SYSTEMMESSAGENUMBER,             -- Message [MSGNR]
    SYSTEMMESSAGEVARIABLE1,          -- Message var. [MSGV1]
    SYSTEMMESSAGEVARIABLE2,          -- Message var. [MSGV2]
    SYSTEMMESSAGEVARIABLE3,          -- Message var. [MSGV3]
    SYSTEMMESSAGEVARIABLE4,          -- Message var. [MSGV4]
    SYSTEMMESSAGETEXT,               -- Message Text [NATXT]
    PRPSDRESPONSIBLEDEPARTMENT,      -- Proposed Processing Department [FIS_GRIR_P_RESPONSIBLE_DPMNT]
    PROPOSEDRESPONSIBLEPERSON,       -- Proposed Processor [FIS_GRIR_P_RESPONSIBLE_USER]
    GRIRCLRGPROCESSPRPSDSTATUS,      -- Proposed Status [FIS_GRIR_P_CLEARING_STATUS]
    GRIRCLRGPROCPRPSDPRIORITY,       -- Proposed Priority [FIS_GRIR_P_PRIORITY]
    GRIRCLRGPROCESSPRPSDROOTCAUSE,   -- Proposed Root Cause [FIS_GRIR_P_CLRG_ROOT_CAUSE]
    PRPSDRESPDEPTMAXCLPROBABILITY,   -- Processing Department Proposal Confidence [FIS_GRIR_P_DEPARTMENT_CONF]
    PRPSDRESPPERSONMAXCLASSPROBLTY,  -- Processor Proposal Confidence [FIS_GRIR_P_RESPONSIBLE_CONF]
    GRIRPROPOSEDSTATUSMAXCLPROBLTY,  -- Status Proposal Confidence [FIS_GRIR_P_STATUS_CONF]
    GRIRPROPOSEDPRIOMAXCLPROBLTY,    -- Priority Proposal Confidence [FIS_GRIR_P_PRIORITY_CONF]
    GRIRPRPSDROOTCAUSEMAXCLPROBLTY,  -- Root Cause Proposal Confidence [FIS_GRIR_P_ROOTCAUSE_CONF]
    GRIRPROCPRPSLLASTCHANGEDTETIME,  -- Proposals Last Updated On [FIS_GRIR_P_LASTCHANGEDATETIME]
    PRIMARY KEY (CLIENT, COMPANYCODE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More