FINCSJRNLENTRH_D

Transparent Table Application Table
52 Fields 2 CDS Views

I_CNSLDTNJRNLENTRYTP I_CNSLDTNJRNLENTRYTP

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CnsldtnJournalEntryDraft view_entity from BASIC Cnsldtn Journal Entry Header - Draft
P_IMPORTJOURNALENTRIES view inner BASIC Import Journal Entries

Fields (52)

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 fincs_consolidationunit Consolidation 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 fincs_investeeconsunit Investee Consolidation 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.
cnsldtnjrnlentrdoctypeisrstrcd fincs_je_doctype_is_rstrcd
hasactiveentity sdraft_has_active Has active

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,               -- Consolidation Unit [fincs_consolidationunit]
    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 Consolidation Unit [fincs_investeeconsunit]
    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]
    CNSLDTNJRNLENTRDOCTYPEISRSTRCD,  -- fincs_je_doctype_is_rstrcd
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More