FINCS_LASTLOG
MCDX List Directory Including Test Run
FINCS_LASTLOG is an SAP database table in S/4HANA. MCDX List Directory Including Test Run. It contains 15 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CnsldtnTaskRunLastLog_2 | view_entity | from | BASIC | Consolidation Task Run Last Log |
| Last_Log_UUID | view | union | Last_log_ID |
Fields (15)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | dimen | FC_DIMEN | Dimension | |||
| KEY | itclg | FC_ITCLG | Cons. COA | |||
| KEY | rldnr | FC_RLDNR | Ledger | |||
| KEY | rvers | FC_RVERS | Version | |||
| KEY | ryear | FC_RYEAR | Fiscal year | |||
| KEY | perid | FC_PERID | Period | |||
| KEY | cacti | FC_CACTI | Task | |||
| KEY | bunit | FC_BUNIT | Cons. Unit | |||
| KEY | testrun | FC_TESTRUN | Test Run | |||
| usr | FC_USER | Last changed by | ||||
| datum | FC_DATE | Changed on | ||||
| time | FC_TIME | Changed at | ||||
| protid | CHAR30 | 30 Characters | ||||
| protid_gen | FINCS_LOGNUMBER | Consolidation Log GUID |
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.
-- MCDX List Directory Including Test Run
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_LASTLOG (
MANDT, -- Client [MANDT]
DIMEN, -- Dimension [FC_DIMEN]
ITCLG, -- Cons. COA [FC_ITCLG]
RLDNR, -- Ledger [FC_RLDNR]
RVERS, -- Version [FC_RVERS]
RYEAR, -- Fiscal year [FC_RYEAR]
PERID, -- Period [FC_PERID]
CACTI, -- Task [FC_CACTI]
BUNIT, -- Cons. Unit [FC_BUNIT]
TESTRUN, -- Test Run [FC_TESTRUN]
USR, -- Last changed by [FC_USER]
DATUM, -- Changed on [FC_DATE]
TIME, -- Changed at [FC_TIME]
PROTID, -- 30 Characters [CHAR30]
PROTID_GEN, -- Consolidation Log GUID [FINCS_LOGNUMBER]
PRIMARY KEY (MANDT, DIMEN, ITCLG, RLDNR, RVERS, RYEAR, PERID, CACTI, BUNIT, TESTRUN)
);
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