FIN_D_CORR_REQS

Transparent Table Application Table

Correspondence requests with parameteres

FIN_D_CORR_REQS is an SAP database table in S/4HANA. Correspondence requests with parameteres. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CorrespondenceHistory view from BASIC Correspondence History
P_FinCorrOMPrmDet view from BASIC

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY request_id fin_corr_req_id Request unique ID
KEY appl_object_type apoc_appl_object_type Appl. Object Type
appl_object_id apoc_appl_object_id Appl. Object ID
parent_appl_object_id apoc_appl_object_id Appl. Object ID
event event_korr Correspondence
company_code bukrs Company Code
account_type koart Account type
account konto Account number
fis_year gjahr Fiscal Year
date1 datum Date
date2 datum Date
document belnr_d Document Number
req_mode fin_corr_mode Mode
cruser uname User Name
crdatetime timestamp Time Stamp
correspondence_type fin_corr_type Corr. Identifier
variant fin_corr_variant Parameters Variant
output_params abap.string Additional output parameters

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.

-- Correspondence requests with parameteres
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIN_D_CORR_REQS (
    MANDT,                  -- Client [mandt]
    REQUEST_ID,             -- Request unique ID [fin_corr_req_id]
    APPL_OBJECT_TYPE,       -- Appl. Object Type [apoc_appl_object_type]
    APPL_OBJECT_ID,         -- Appl. Object ID [apoc_appl_object_id]
    PARENT_APPL_OBJECT_ID,  -- Appl. Object ID [apoc_appl_object_id]
    EVENT,                  -- Correspondence [event_korr]
    COMPANY_CODE,           -- Company Code [bukrs]
    ACCOUNT_TYPE,           -- Account type [koart]
    ACCOUNT,                -- Account number [konto]
    FIS_YEAR,               -- Fiscal Year [gjahr]
    DATE1,                  -- Date [datum]
    DATE2,                  -- Date [datum]
    DOCUMENT,               -- Document Number [belnr_d]
    REQ_MODE,               -- Mode [fin_corr_mode]
    CRUSER,                 -- User Name [uname]
    CRDATETIME,             -- Time Stamp [timestamp]
    CORRESPONDENCE_TYPE,    -- Corr. Identifier [fin_corr_type]
    VARIANT,                -- Parameters Variant [fin_corr_variant]
    OUTPUT_PARAMS,          -- Additional output parameters [abap.string]
    PRIMARY KEY (MANDT, REQUEST_ID, APPL_OBJECT_TYPE)
);