FINCS_LOG_ITEM20
ICMR log
FINCS_LOG_ITEM20 is an SAP database table in S/4HANA. ICMR log. It contains 149 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CnsldtnTskLgItmRecncln | view_entity | from | BASIC | Cnsldtn Task Log Item Reconciliation |
Fields (149)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | cnsldtnlognumber | FINCS_LOGNUMBER | Consolidation Log GUID | |||
| KEY | cnsldtnlogitemnumber | FINCS_LOGITEMNUMBER | Consolidation Log Item Number GUID | |||
| node | FINCS_NODE | Node | ||||
| parentnode | FINCS_NODE | Node | ||||
| raw_rowid | FINCS_ROWID | Row Number | ||||
| cnsldtnlineitemtype | FINCS_LINEITEMTYPE | Log Line Item Type | ||||
| cnsldtntask | FINCS_TSK | Task | ||||
| method_id | ICA_METHOD_ID | Matching Method | ||||
| recon_case_id | ICA_RECON_CASE_ID | Reconciliation Case | ||||
| rule_id | ICA_RULE_ID | Matching Rule ID | ||||
| recon_bunit | FINCS_CONSOLIDATIONUNIT | Consolidation Unit | ||||
| recon_rbuptr | FINCS_BUPTR | Partner Unit | ||||
| item_group | ICA_DCM_ITEM_GROUP | Item Group | ||||
| disp_group | ICA_DISP_GROUP | Display Group | ||||
| selection | FINCS_SEL_ID | Selection ID | ||||
| docnr | BELNR_D | Document Number | ||||
| docln | DOCLN6 | G/L Line Item | ||||
| seqno | FINCS_SEQNO | Consolidation Sequence Number | ||||
| reexchangerateindicator | FINCS_RERIN | Ref Ex Rate Type | ||||
| reexchagerate | FINCS_RRATE | Ref Ex Rate | ||||
| exchangerateindicator | FINCS_EXRIND | Ex Rate Type | ||||
| exchangerate | FINCS_ERATE | Exchange Rate | ||||
| ctkey | FINCS_CTKEY | Crcy Translation Key | ||||
| entryid | FINCS_ENTRYID | Entry ID | ||||
| tsl_rbunit | VTCUR12 | Amount in TC | ||||
| tsl_rbuptr | VTCUR12 | Amount in TC | ||||
| tsl_diff | VTCUR12 | Amount in TC | ||||
| ksl_rbunit | VGCUR12 | Amnt in GrpCrcy | ||||
| ksl_rbuptr | VGCUR12 | Amnt in GrpCrcy | ||||
| ksl_diff | VGCUR12 | Amnt in GrpCrcy | ||||
| msl_rbunit | FINCS_QUAN | Quantity | ||||
| msl_rbuptr | FINCS_QUAN | Quantity | ||||
| msl_diff | FINCS_QUAN | Quantity | ||||
| rrcty | FINCS_RRCTY | Record Type | ||||
| rvers | FINCS_CONSOLIDATIONVERSION | Version | ||||
| rtcur | RTCUR | Currency | ||||
| rhcur | LCURR | Local crcy | ||||
| rkcur | GCURR | Ledger curr. | ||||
| runit | MEINS | Base Unit | ||||
| poper | FINCS_POPER | Fiscal Period | ||||
| fiscyearper | FINCS_FISCYEARPER | Period/Year | ||||
| docct | DOCCT | Document Categ. | ||||
| rcomp | FINCS_COMPANY | Company | ||||
| rbunit | FINCS_CONSOLIDATIONUNIT | Consolidation Unit | ||||
| ritclg | FINCS_CONSCHARTOFACCOUNTS | Cons. Chart of Accounts | ||||
| ritem | FINCS_MD_FINSTATEMENTITEM | Consolidation FS Item | ||||
| rbuptr | FINCS_PARTNERCONSOLIDATIONUNIT | Partner Consolidation Unit | ||||
| rcongr | FINCS_MD_CONGR | Consolidation Group | ||||
| robukrs | OBUKR | Orig. CC | ||||
| sityp | FINCS_SUBITEMCATEGORY | Subitem Category | ||||
| subit | FINCS_SUBITEM | Subitem | ||||
| plevl | FINCS_POSTINGLEVEL | Posting Level | ||||
| rpflg | FINCS_APPORTIONMENT | Apportionment | ||||
| rtflg | FINCS_CURRENCYCNVRSNSDIFFTYPE | Currency Translation Indicator | ||||
| docty | FINCS_DOCUMENTTYPE | Document Type | ||||
| yracq | FINCS_YRACQ | Year of Acquisition | ||||
| pracq | FINCS_PRACQ | Period of Acquisition | ||||
| coicu | FINCS_INVESTEECONSUNIT | Investee Consolidation Unit | ||||
| uppcu | FINCS_INVESTORCONSUNIT | Investor Consolidation Unit | ||||
| tsl | FINCS_TSL | Amount in Transaction Currency | ||||
| hsl | FINCS_HSL | Amount in Local Currency | ||||
| ksl | FINCS_KSL | Amount in Group Currency | ||||
| msl | FINCS_QUAN | Quantity | ||||
| sgtxt | SGTXT | Text | ||||
| autom | AUTOM | Auto. ID | ||||
| activ | GLVOR | Bus.transaction | ||||
| bvorg | BVORG | Cross-CC Number | ||||
| budat | BUDAT | Posting Date | ||||
| wsdat | WSDAT | Value Date | ||||
| refdocnr | BELNR_D | Document Number | ||||
| refryear | FINCS_REFRYEAR | Reference Fiscal Year | ||||
| refdocln | BUZEI6 | Item | ||||
| refdocct | DOCCT | Document Categ. | ||||
| refactiv | GLVOR | Bus.transaction | ||||
| timestamp | TIMESTAMP | Time Stamp | ||||
| cpudt | CPUDT | Entered On | ||||
| cputm | CPUTM | Entered at | ||||
| bunnr | FINCS_BUNNR | Document Bundle No. | ||||
| coiac | FINCS_COIAC | Investment Activity | ||||
| coinr | FINCS_COINR | Investment Activity Number | ||||
| awtyp | AWTYP | Ref. procedure | ||||
| aworg | AWORG | Refer. Org.Unit | ||||
| logsys | LOGSYS | Logical system | ||||
| ktopl | KTOPL | Chart of Accts | ||||
| racct | RACCT | Account Number | ||||
| xblnr | XBLNR1 | Reference | ||||
| zuonr | DZUONR | Assignment | ||||
| rcntr | KOSTL | Cost Center | ||||
| prctr | PRCTR | Profit Center | ||||
| rfarea | FKBER | Functional Area | ||||
| rbusa | GSBER | Business Area | ||||
| kokrs | KOKRS | CO Area | ||||
| segment | FB_SEGMENT | Segment | ||||
| scntr | SKOST | Sender cost ctr | ||||
| pprctr | PPRCTR | Partner PC | ||||
| sfarea | SFKBER | Partner FArea | ||||
| sbusa | PARGB | Trdg Part.BA | ||||
| rassc | RASSC | Trading Partner | ||||
| psegment | FB_PSEGMENT | Partner Segment | ||||
| aufnr | AUFNR | Order | ||||
| kunnr | KUNNR | Customer | ||||
| lifnr | LIFNR | Supplier | ||||
| matnr | MATNR | Material | ||||
| matkl_mm | FINS_MATKL_MM | Material Group | ||||
| werks | WERKS_D | Plant | ||||
| rmvct | RMVCT | Transactn type | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| ps_posid | PS_POSID | WBS Element | ||||
| ps_pspid | PS_PSPID | Project def. | ||||
| fkart | FKART | Billing Type | ||||
| vkorg | VKORG | Sales Org. | ||||
| vtweg | VTWEG | Distr. Channel | ||||
| spart | SPART | Division | ||||
| matnr_copa | FINS_MATNR_PA | Product Sold | ||||
| matkl | FINS_MATKL_PA | Product Sold Group | ||||
| kdgrp | KDGRP | Customer Group | ||||
| land1 | COBL_LAND1_GP | Country/Region | ||||
| brsch | BRSCH | Industry | ||||
| bzirk | BZIRK | Sales District | ||||
| kunre | KUNRE | Bill-to Party | ||||
| kunwe | KUNWE | Ship-to Party | ||||
| konzs | KONZS | Group | ||||
| fs_product_group | FFS_PRODUCT_GROUP | Product Group (FS) | ||||
| branch_id | FFS_BRANCH_ID | Branch (FS) | ||||
| datasource_id | FFS_DATASOURCE_ID | Data Source | ||||
| rfund | BP_GEBER | Fund | ||||
| rgrant_nbr | GM_GRANT_NBR | Grant | ||||
| re_account | FIS_RE_ACCOUNT | Cash Origin Account | ||||
| fikrs | FIKRS | FM Area | ||||
| re_ktopl | FINCS_RE_KTOPL | Cash Origin ChtAccts | ||||
| sfund | BP_P_GEBER | Partner Fund | ||||
| ghgcategory | SUFND_VDM_GHGCATEGORY | GHG Category | ||||
| ghgscope | SUFND_VDM_GHGSCOPE | GHG Scope | ||||
| ghgscp2calcmeth | SUFND_VDM_GHGSCP2CALCMETH | GHG Scp 2 Calc Meth | ||||
| ghgscp2contrinstr | SUFND_VDM_GHGSCP2CONTRINSTR | GHG Scp 2 Cntrctl In | ||||
| susmodeoftransport | SUFND_VDM_SUSMODEOFTRANSPORT | Sust Mode of Transpt | ||||
| ghgdtaqltycharc | SUFND_VDM_GHGDTAQLTYCHARC | GHG Data Qlty Charc | ||||
| ghgenergyclass | SUFND_VDM_GHGENERGYCLASS | GHG Engy Classfctn | ||||
| ghgenergymix | SUFND_VDM_GHGENERGYMIX | GHG Energy Mix | ||||
| ghgengysrcgtype | SUFND_VDM_GHGENGYSRCGTYPE | GHG Engy Srcg Type | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| adhocitem | FINCS_ADHOCITEM | Ad Hoc Item | ||||
| adhocset | FINCS_ADHOCSET | Ad Hoc Set | ||||
| adhocsetitem | FINCS_ADHOCSETITEM | Ad Hoc Set Item | ||||
| rcode | ICA_RCODE | Reason Code | ||||
| orig_type | FINCS_ORIG_TYPE | Origin Type | ||||
| orig_ref | FINCS_ORIG_REF | Origin Ref. | ||||
| dummy_cje_incl_eew_ps | CFD_DUMMY | Dummy |
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.
-- ICMR log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_LOG_ITEM20 (
MANDT, -- Client [MANDT]
CNSLDTNLOGNUMBER, -- Consolidation Log GUID [FINCS_LOGNUMBER]
CNSLDTNLOGITEMNUMBER, -- Consolidation Log Item Number GUID [FINCS_LOGITEMNUMBER]
NODE, -- Node [FINCS_NODE]
PARENTNODE, -- Node [FINCS_NODE]
RAW_ROWID, -- Row Number [FINCS_ROWID]
CNSLDTNLINEITEMTYPE, -- Log Line Item Type [FINCS_LINEITEMTYPE]
CNSLDTNTASK, -- Task [FINCS_TSK]
METHOD_ID, -- Matching Method [ICA_METHOD_ID]
RECON_CASE_ID, -- Reconciliation Case [ICA_RECON_CASE_ID]
RULE_ID, -- Matching Rule ID [ICA_RULE_ID]
RECON_BUNIT, -- Consolidation Unit [FINCS_CONSOLIDATIONUNIT]
RECON_RBUPTR, -- Partner Unit [FINCS_BUPTR]
ITEM_GROUP, -- Item Group [ICA_DCM_ITEM_GROUP]
DISP_GROUP, -- Display Group [ICA_DISP_GROUP]
SELECTION, -- Selection ID [FINCS_SEL_ID]
DOCNR, -- Document Number [BELNR_D]
DOCLN, -- G/L Line Item [DOCLN6]
SEQNO, -- Consolidation Sequence Number [FINCS_SEQNO]
REEXCHANGERATEINDICATOR, -- Ref Ex Rate Type [FINCS_RERIN]
REEXCHAGERATE, -- Ref Ex Rate [FINCS_RRATE]
EXCHANGERATEINDICATOR, -- Ex Rate Type [FINCS_EXRIND]
EXCHANGERATE, -- Exchange Rate [FINCS_ERATE]
CTKEY, -- Crcy Translation Key [FINCS_CTKEY]
ENTRYID, -- Entry ID [FINCS_ENTRYID]
TSL_RBUNIT, -- Amount in TC [VTCUR12]
TSL_RBUPTR, -- Amount in TC [VTCUR12]
TSL_DIFF, -- Amount in TC [VTCUR12]
KSL_RBUNIT, -- Amnt in GrpCrcy [VGCUR12]
KSL_RBUPTR, -- Amnt in GrpCrcy [VGCUR12]
KSL_DIFF, -- Amnt in GrpCrcy [VGCUR12]
MSL_RBUNIT, -- Quantity [FINCS_QUAN]
MSL_RBUPTR, -- Quantity [FINCS_QUAN]
MSL_DIFF, -- Quantity [FINCS_QUAN]
RRCTY, -- Record Type [FINCS_RRCTY]
RVERS, -- Version [FINCS_CONSOLIDATIONVERSION]
RTCUR, -- Currency [RTCUR]
RHCUR, -- Local crcy [LCURR]
RKCUR, -- Ledger curr. [GCURR]
RUNIT, -- Base Unit [MEINS]
POPER, -- Fiscal Period [FINCS_POPER]
FISCYEARPER, -- Period/Year [FINCS_FISCYEARPER]
DOCCT, -- Document Categ. [DOCCT]
RCOMP, -- Company [FINCS_COMPANY]
RBUNIT, -- Consolidation Unit [FINCS_CONSOLIDATIONUNIT]
RITCLG, -- Cons. Chart of Accounts [FINCS_CONSCHARTOFACCOUNTS]
RITEM, -- Consolidation FS Item [FINCS_MD_FINSTATEMENTITEM]
RBUPTR, -- Partner Consolidation Unit [FINCS_PARTNERCONSOLIDATIONUNIT]
RCONGR, -- Consolidation Group [FINCS_MD_CONGR]
ROBUKRS, -- Orig. CC [OBUKR]
SITYP, -- Subitem Category [FINCS_SUBITEMCATEGORY]
SUBIT, -- Subitem [FINCS_SUBITEM]
PLEVL, -- Posting Level [FINCS_POSTINGLEVEL]
RPFLG, -- Apportionment [FINCS_APPORTIONMENT]
RTFLG, -- Currency Translation Indicator [FINCS_CURRENCYCNVRSNSDIFFTYPE]
DOCTY, -- Document Type [FINCS_DOCUMENTTYPE]
YRACQ, -- Year of Acquisition [FINCS_YRACQ]
PRACQ, -- Period of Acquisition [FINCS_PRACQ]
COICU, -- Investee Consolidation Unit [FINCS_INVESTEECONSUNIT]
UPPCU, -- Investor Consolidation Unit [FINCS_INVESTORCONSUNIT]
TSL, -- Amount in Transaction Currency [FINCS_TSL]
HSL, -- Amount in Local Currency [FINCS_HSL]
KSL, -- Amount in Group Currency [FINCS_KSL]
MSL, -- Quantity [FINCS_QUAN]
SGTXT, -- Text [SGTXT]
AUTOM, -- Auto. ID [AUTOM]
ACTIV, -- Bus.transaction [GLVOR]
BVORG, -- Cross-CC Number [BVORG]
BUDAT, -- Posting Date [BUDAT]
WSDAT, -- Value Date [WSDAT]
REFDOCNR, -- Document Number [BELNR_D]
REFRYEAR, -- Reference Fiscal Year [FINCS_REFRYEAR]
REFDOCLN, -- Item [BUZEI6]
REFDOCCT, -- Document Categ. [DOCCT]
REFACTIV, -- Bus.transaction [GLVOR]
TIMESTAMP, -- Time Stamp [TIMESTAMP]
CPUDT, -- Entered On [CPUDT]
CPUTM, -- Entered at [CPUTM]
BUNNR, -- Document Bundle No. [FINCS_BUNNR]
COIAC, -- Investment Activity [FINCS_COIAC]
COINR, -- Investment Activity Number [FINCS_COINR]
AWTYP, -- Ref. procedure [AWTYP]
AWORG, -- Refer. Org.Unit [AWORG]
LOGSYS, -- Logical system [LOGSYS]
KTOPL, -- Chart of Accts [KTOPL]
RACCT, -- Account Number [RACCT]
XBLNR, -- Reference [XBLNR1]
ZUONR, -- Assignment [DZUONR]
RCNTR, -- Cost Center [KOSTL]
PRCTR, -- Profit Center [PRCTR]
RFAREA, -- Functional Area [FKBER]
RBUSA, -- Business Area [GSBER]
KOKRS, -- CO Area [KOKRS]
SEGMENT, -- Segment [FB_SEGMENT]
SCNTR, -- Sender cost ctr [SKOST]
PPRCTR, -- Partner PC [PPRCTR]
SFAREA, -- Partner FArea [SFKBER]
SBUSA, -- Trdg Part.BA [PARGB]
RASSC, -- Trading Partner [RASSC]
PSEGMENT, -- Partner Segment [FB_PSEGMENT]
AUFNR, -- Order [AUFNR]
KUNNR, -- Customer [KUNNR]
LIFNR, -- Supplier [LIFNR]
MATNR, -- Material [MATNR]
MATKL_MM, -- Material Group [FINS_MATKL_MM]
WERKS, -- Plant [WERKS_D]
RMVCT, -- Transactn type [RMVCT]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
PS_POSID, -- WBS Element [PS_POSID]
PS_PSPID, -- Project def. [PS_PSPID]
FKART, -- Billing Type [FKART]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
SPART, -- Division [SPART]
MATNR_COPA, -- Product Sold [FINS_MATNR_PA]
MATKL, -- Product Sold Group [FINS_MATKL_PA]
KDGRP, -- Customer Group [KDGRP]
LAND1, -- Country/Region [COBL_LAND1_GP]
BRSCH, -- Industry [BRSCH]
BZIRK, -- Sales District [BZIRK]
KUNRE, -- Bill-to Party [KUNRE]
KUNWE, -- Ship-to Party [KUNWE]
KONZS, -- Group [KONZS]
FS_PRODUCT_GROUP, -- Product Group (FS) [FFS_PRODUCT_GROUP]
BRANCH_ID, -- Branch (FS) [FFS_BRANCH_ID]
DATASOURCE_ID, -- Data Source [FFS_DATASOURCE_ID]
RFUND, -- Fund [BP_GEBER]
RGRANT_NBR, -- Grant [GM_GRANT_NBR]
RE_ACCOUNT, -- Cash Origin Account [FIS_RE_ACCOUNT]
FIKRS, -- FM Area [FIKRS]
RE_KTOPL, -- Cash Origin ChtAccts [FINCS_RE_KTOPL]
SFUND, -- Partner Fund [BP_P_GEBER]
GHGCATEGORY, -- GHG Category [SUFND_VDM_GHGCATEGORY]
GHGSCOPE, -- GHG Scope [SUFND_VDM_GHGSCOPE]
GHGSCP2CALCMETH, -- GHG Scp 2 Calc Meth [SUFND_VDM_GHGSCP2CALCMETH]
GHGSCP2CONTRINSTR, -- GHG Scp 2 Cntrctl In [SUFND_VDM_GHGSCP2CONTRINSTR]
SUSMODEOFTRANSPORT, -- Sust Mode of Transpt [SUFND_VDM_SUSMODEOFTRANSPORT]
GHGDTAQLTYCHARC, -- GHG Data Qlty Charc [SUFND_VDM_GHGDTAQLTYCHARC]
GHGENERGYCLASS, -- GHG Engy Classfctn [SUFND_VDM_GHGENERGYCLASS]
GHGENERGYMIX, -- GHG Energy Mix [SUFND_VDM_GHGENERGYMIX]
GHGENGYSRCGTYPE, -- GHG Engy Srcg Type [SUFND_VDM_GHGENGYSRCGTYPE]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
ADHOCITEM, -- Ad Hoc Item [FINCS_ADHOCITEM]
ADHOCSET, -- Ad Hoc Set [FINCS_ADHOCSET]
ADHOCSETITEM, -- Ad Hoc Set Item [FINCS_ADHOCSETITEM]
RCODE, -- Reason Code [ICA_RCODE]
ORIG_TYPE, -- Origin Type [FINCS_ORIG_TYPE]
ORIG_REF, -- Origin Ref. [FINCS_ORIG_REF]
DUMMY_CJE_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, CNSLDTNLOGNUMBER, CNSLDTNLOGITEMNUMBER)
);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