FIIS_KRD_LOG

Transparent Table Customizing Table

Log for KRD report assignment

FIIS_KRD_LOG is an SAP database table in S/4HANA. Log for KRD report assignment. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SI_CntrlBkRptgRblsPyblsLog view_entity from BASIC SI Central Bank Reporting KRD Log

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY company_code BUKRS Company Code
KEY ledger RLDNR Ledger
KEY accounting_document FIS_BELNR Journal Entry
KEY ledger_gl_lineitem FIS_DOCLN Journal Entry Item
KEY fiscal_year GJAHR Fiscal Year
sector GLO_FIN_SI_SECTOR_KRD_NONRES Fin. S. KRD
institution_code GLO_FIN_SI_IINS_CODE Inst. code
cap_relationship GLO_FIN_SI_CAP_RELATIONSHIP Capital Relationship
fin_instrument_type GLO_FIN_SI_FIN_INS_TYPE Fin. Instrument Type
maturity GLO_FIN_SI_MATURITY Fin. Instr. Mtty.
isdisabled GLO_FIN_SI_ISREMOVED Is Disabled
income_type GLO_FIN_SI_INCOME Income Type
last_changed_at TIMESTAMPL Time Stamp
local_last_changed_at TIMESTAMPL Time Stamp

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.

-- Log for KRD report assignment
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIIS_KRD_LOG (
    MANDT,                  -- Client [MANDT]
    COMPANY_CODE,           -- Company Code [BUKRS]
    LEDGER,                 -- Ledger [RLDNR]
    ACCOUNTING_DOCUMENT,    -- Journal Entry [FIS_BELNR]
    LEDGER_GL_LINEITEM,     -- Journal Entry Item [FIS_DOCLN]
    FISCAL_YEAR,            -- Fiscal Year [GJAHR]
    SECTOR,                 -- Fin. S. KRD [GLO_FIN_SI_SECTOR_KRD_NONRES]
    INSTITUTION_CODE,       -- Inst. code [GLO_FIN_SI_IINS_CODE]
    CAP_RELATIONSHIP,       -- Capital Relationship [GLO_FIN_SI_CAP_RELATIONSHIP]
    FIN_INSTRUMENT_TYPE,    -- Fin. Instrument Type [GLO_FIN_SI_FIN_INS_TYPE]
    MATURITY,               -- Fin. Instr. Mtty. [GLO_FIN_SI_MATURITY]
    ISDISABLED,             -- Is Disabled [GLO_FIN_SI_ISREMOVED]
    INCOME_TYPE,            -- Income Type [GLO_FIN_SI_INCOME]
    LAST_CHANGED_AT,        -- Time Stamp [TIMESTAMPL]
    LOCAL_LAST_CHANGED_AT,  -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, COMPANY_CODE, LEDGER, ACCOUNTING_DOCUMENT, LEDGER_GL_LINEITEM, FISCAL_YEAR)
);