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