FICITD_SETTLMTLG

Transparent Table Application Table

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 13 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 (13)

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

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]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, UUID)
);