FINCSJRNLENTRH_D

Transparent Table Application Table
56 Fields 1 CDS Views

I_CNSLDTNJRNLENTRYTP I_CNSLDTNJRNLENTRYTP

FINCSJRNLENTRH_D is an SAP database table in S/4HANA. I_CNSLDTNJRNLENTRYTP I_CNSLDTNJRNLENTRYTP. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_IMPORTJOURNALENTRIES view inner BASIC

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
fiscalyear GJAHR Fiscal Year
consolidationdocumentnumber BELNR_D Document Number
consolidationledger RLDNR Ledger
consolidationdimension FC_DIMEN Dimension
consolidationledgerforedit RLDNR Ledger
fiscalyearforedit GJAHR Fiscal Year
consolidationversion FC_RVERS Version
consolidationunit FC_BUNIT Cons. Unit
fiscalperiod POPER Posting Period
consolidationchartofaccounts FC_ITCLG Cons. COA
postinglevel FC_PLEVL Posting Level
consolidationgroup FC_CONGR Cons. Group
consolidationdocumenttype FC_DOCTY Document Type
documentitemtext SGTXT Text
postingdate BUDAT Posting Date
creationdate CPUDT Entered On
creationtime CPUTM Entered at
userid USNAM User Name
consolidationunit1 FC_BUNIT1 Cons Unit 1
consolidationunit2 FC_BUNIT2 Cons Unit 2
investeeconsolidationunit FC_COICU Investee Unit
investmentactivitytype FC_COIAC C/I Activity
investmentactivity FC_COINR Activity Number
refconsolidationdocumentnumber BELNR_D Document Number
reverseddocument STBLN Reversed doc.
reversedocument STBLG Reversed With
consolidationdocreversalyear FC_REVYEAR Year of reversal doc
isreversaldocument FC_RVSIND Reverse
isconsolidationtasktestrun FC_TESTRUN Test Run
isinworkflow FINCS_ISWORKFLOW In workflow
consolidationtaskcategory FC_CACTT Task category
consolidationtask FC_CACTI Task
consolidationjrnlentrsource FINCS_JOURNALENTRY_SOURCE Draft Entry Source
consolidationjrnlentrdraftuuid FINCS_UUID UUID
cnsldtndocumentnumberforedit BELNR_D Document Number
amountintranscurrencyishidden FINCS_ISHIDDEN Hidden
amountinlocalcurrencyishidden FINCS_ISHIDDEN Hidden
amountingroupcurrencyishidden FINCS_ISHIDDEN Hidden
quantityinbaseunitishidden FINCS_ISHIDDEN Hidden
cnsldtnunit1isusedishidden FINCS_ISHIDDEN Hidden
consolidationgroupishidden FINCS_ISHIDDEN Hidden
partnercnsldtnunitishidden FINCS_ISHIDDEN Hidden
consolidationunitishidden FINCS_ISHIDDEN Hidden
consolidationunit3ishidden FINCS_ISHIDDEN Hidden
partnercnsldtnunit3ishidden FINCS_ISHIDDEN Hidden
subitemishidden FINCS_ISHIDDEN Hidden
subitemcategoryishidden FINCS_ISHIDDEN Hidden
cnsldtngroupjrnlentrybundle FINCS_BUNNR Document Bundle No.
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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.

-- I_CNSLDTNJRNLENTRYTP I_CNSLDTNJRNLENTRYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCSJRNLENTRH_D (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    FISCALYEAR,                      -- Fiscal Year [GJAHR]
    CONSOLIDATIONDOCUMENTNUMBER,     -- Document Number [BELNR_D]
    CONSOLIDATIONLEDGER,             -- Ledger [RLDNR]
    CONSOLIDATIONDIMENSION,          -- Dimension [FC_DIMEN]
    CONSOLIDATIONLEDGERFOREDIT,      -- Ledger [RLDNR]
    FISCALYEARFOREDIT,               -- Fiscal Year [GJAHR]
    CONSOLIDATIONVERSION,            -- Version [FC_RVERS]
    CONSOLIDATIONUNIT,               -- Cons. Unit [FC_BUNIT]
    FISCALPERIOD,                    -- Posting Period [POPER]
    CONSOLIDATIONCHARTOFACCOUNTS,    -- Cons. COA [FC_ITCLG]
    POSTINGLEVEL,                    -- Posting Level [FC_PLEVL]
    CONSOLIDATIONGROUP,              -- Cons. Group [FC_CONGR]
    CONSOLIDATIONDOCUMENTTYPE,       -- Document Type [FC_DOCTY]
    DOCUMENTITEMTEXT,                -- Text [SGTXT]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    CREATIONDATE,                    -- Entered On [CPUDT]
    CREATIONTIME,                    -- Entered at [CPUTM]
    USERID,                          -- User Name [USNAM]
    CONSOLIDATIONUNIT1,              -- Cons Unit 1 [FC_BUNIT1]
    CONSOLIDATIONUNIT2,              -- Cons Unit 2 [FC_BUNIT2]
    INVESTEECONSOLIDATIONUNIT,       -- Investee Unit [FC_COICU]
    INVESTMENTACTIVITYTYPE,          -- C/I Activity [FC_COIAC]
    INVESTMENTACTIVITY,              -- Activity Number [FC_COINR]
    REFCONSOLIDATIONDOCUMENTNUMBER,  -- Document Number [BELNR_D]
    REVERSEDDOCUMENT,                -- Reversed doc. [STBLN]
    REVERSEDOCUMENT,                 -- Reversed With [STBLG]
    CONSOLIDATIONDOCREVERSALYEAR,    -- Year of reversal doc [FC_REVYEAR]
    ISREVERSALDOCUMENT,              -- Reverse [FC_RVSIND]
    ISCONSOLIDATIONTASKTESTRUN,      -- Test Run [FC_TESTRUN]
    ISINWORKFLOW,                    -- In workflow [FINCS_ISWORKFLOW]
    CONSOLIDATIONTASKCATEGORY,       -- Task category [FC_CACTT]
    CONSOLIDATIONTASK,               -- Task [FC_CACTI]
    CONSOLIDATIONJRNLENTRSOURCE,     -- Draft Entry Source [FINCS_JOURNALENTRY_SOURCE]
    CONSOLIDATIONJRNLENTRDRAFTUUID,  -- UUID [FINCS_UUID]
    CNSLDTNDOCUMENTNUMBERFOREDIT,    -- Document Number [BELNR_D]
    AMOUNTINTRANSCURRENCYISHIDDEN,   -- Hidden [FINCS_ISHIDDEN]
    AMOUNTINLOCALCURRENCYISHIDDEN,   -- Hidden [FINCS_ISHIDDEN]
    AMOUNTINGROUPCURRENCYISHIDDEN,   -- Hidden [FINCS_ISHIDDEN]
    QUANTITYINBASEUNITISHIDDEN,      -- Hidden [FINCS_ISHIDDEN]
    CNSLDTNUNIT1ISUSEDISHIDDEN,      -- Hidden [FINCS_ISHIDDEN]
    CONSOLIDATIONGROUPISHIDDEN,      -- Hidden [FINCS_ISHIDDEN]
    PARTNERCNSLDTNUNITISHIDDEN,      -- Hidden [FINCS_ISHIDDEN]
    CONSOLIDATIONUNITISHIDDEN,       -- Hidden [FINCS_ISHIDDEN]
    CONSOLIDATIONUNIT3ISHIDDEN,      -- Hidden [FINCS_ISHIDDEN]
    PARTNERCNSLDTNUNIT3ISHIDDEN,     -- Hidden [FINCS_ISHIDDEN]
    SUBITEMISHIDDEN,                 -- Hidden [FINCS_ISHIDDEN]
    SUBITEMCATEGORYISHIDDEN,         -- Hidden [FINCS_ISHIDDEN]
    CNSLDTNGROUPJRNLENTRYBUNDLE,     -- Document Bundle No. [FINCS_BUNNR]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More