FICITD_SETTLMTLG

Transparent Table Application Table
14 Fields 2 CDS Views

CIT Settlement Data for a Report Run

FICITD_SETTLMTLG is an SAP database table in S/4HANA. CIT Settlement Data for a Report Run. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CITSettlementLog view from EXTENSION CIT Settlmt Reporting Log - Extension
I_CITSettlementLog view from BASIC CIT Settlements Reporting Log

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY statryrptgentity SRF_REPORTING_ENTITY Reporting Entity
KEY statryrptcategory SRF_REP_CAT_ID Report ID
KEY statryrptrunid SRF_REPORT_RUN_ID Report Run ID
KEY uuid UUID UUID
reportinglineid FICITE_REPORTING_LINE CIT Report Line
reportingitemid FICITE_REPORTING_LINE_ITEM CIT Report Item
reportversionid FICITE_REPORT_VERSION CIT Report Version
brfapplicationname FDT_APPLICATION_NAME BRFplus Application
settlementcode FICITE_SETTLEMENTCODE CIT Settlmt Code
amount FICITE_AMNT Amount
currency FICITE_CURR Currency
itemsignisreversed FICITE_REPORTING_CHANGE_SIGN Change Item Sign
dummy_ficit_clsfy_incl_eew_ps CFD_DUMMY Dummy

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.

-- CIT Settlement Data for a Report Run
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICITD_SETTLMTLG (
    MANDT,                          -- Client [MANDT]
    STATRYRPTGENTITY,               -- Reporting Entity [SRF_REPORTING_ENTITY]
    STATRYRPTCATEGORY,              -- Report ID [SRF_REP_CAT_ID]
    STATRYRPTRUNID,                 -- Report Run ID [SRF_REPORT_RUN_ID]
    UUID,                           -- UUID [UUID]
    REPORTINGLINEID,                -- CIT Report Line [FICITE_REPORTING_LINE]
    REPORTINGITEMID,                -- CIT Report Item [FICITE_REPORTING_LINE_ITEM]
    REPORTVERSIONID,                -- CIT Report Version [FICITE_REPORT_VERSION]
    BRFAPPLICATIONNAME,             -- BRFplus Application [FDT_APPLICATION_NAME]
    SETTLEMENTCODE,                 -- CIT Settlmt Code [FICITE_SETTLEMENTCODE]
    AMOUNT,                         -- Amount [FICITE_AMNT]
    CURRENCY,                       -- Currency [FICITE_CURR]
    ITEMSIGNISREVERSED,             -- Change Item Sign [FICITE_REPORTING_CHANGE_SIGN]
    DUMMY_FICIT_CLSFY_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, UUID)
);

Learn More