FIIS_KRD_LOG
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SI_CntrlBkRptgRblsPyblsLog | view_entity | from | BASIC | SI Central Bank Reporting KRD Log |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA