FINIJU_CASE_D

Transparent Table Application Table
35 Fields 2 CDS Views

Draft table for entity R_JOURNALCASETP

FINIJU_CASE_D is an SAP database table in S/4HANA. Draft table for entity R_JOURNALCASETP. It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JournalCaseDraft view_entity from EXTENSION Manage Journal Case - Extension
R_JournalCaseDraft view_entity from BASIC Manage Journal Case - Draft

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY journalcaseuuid SYSUUID_X16 UUID
journalcase IJUCASE_ID Case ID
fiscalyear GJAHR Fiscal Year
fiscalyearvariant PERIV FY Variant
journalcasecategory CASE_CAT Category Code
journalcasesubcategory CASE_SUBCAT Subcategory Code
journalcasestatus CASE_STATUS Case Status
journalcaseapprovalstatus CASE_APPR_STATUS Approval Status
fiscalperiod POPER Posting Period
reversalreason STGRD Reversal Reason
plannedreversaldate STODT Reversal Date
journalcasepolicyuuid SYSUUID_X16 UUID
jrnlcaseattchcontentbinary FINIJU_ATTACHMENT Attachment
mimetype FINIJU_MIME_TYPE Mime Type
journalcaseattachmentfilename FINIJU_FILENAME File Name
createdbyuser ABP_CREATION_USER Created By
creationdatetime ABP_CREATION_TSTMPL Created On
lastchangebyuser ABP_LOCINST_LASTCHANGE_USER Changed By
locallastchangedatetime ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
lastchangedatetime ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
responsibleuser SUIDRESPONSIBLE Responsible
fiscalyearperiod FINS_FYEARPERIOD Fiscal YPeriod
journalcasename CASE_DESC Case Description
journalcasesummarytext IJUSUMMARY Summary
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
jrnlcaseprpslcontentbinary FINIJU_ATTACHMENT Attachment
jrnlcaseprpslmimetype FINIJU_MIME_TYPE Mime Type
journalcaseproposalfilename FINIJU_FILENAME File Name
dummy_jrnl_case_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.

-- Draft table for entity R_JOURNALCASETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINIJU_CASE_D (
    MANDT,                          -- Client [MANDT]
    JOURNALCASEUUID,                -- UUID [SYSUUID_X16]
    JOURNALCASE,                    -- Case ID [IJUCASE_ID]
    FISCALYEAR,                     -- Fiscal Year [GJAHR]
    FISCALYEARVARIANT,              -- FY Variant [PERIV]
    JOURNALCASECATEGORY,            -- Category Code [CASE_CAT]
    JOURNALCASESUBCATEGORY,         -- Subcategory Code [CASE_SUBCAT]
    JOURNALCASESTATUS,              -- Case Status [CASE_STATUS]
    JOURNALCASEAPPROVALSTATUS,      -- Approval Status [CASE_APPR_STATUS]
    FISCALPERIOD,                   -- Posting Period [POPER]
    REVERSALREASON,                 -- Reversal Reason [STGRD]
    PLANNEDREVERSALDATE,            -- Reversal Date [STODT]
    JOURNALCASEPOLICYUUID,          -- UUID [SYSUUID_X16]
    JRNLCASEATTCHCONTENTBINARY,     -- Attachment [FINIJU_ATTACHMENT]
    MIMETYPE,                       -- Mime Type [FINIJU_MIME_TYPE]
    JOURNALCASEATTACHMENTFILENAME,  -- File Name [FINIJU_FILENAME]
    CREATEDBYUSER,                  -- Created By [ABP_CREATION_USER]
    CREATIONDATETIME,               -- Created On [ABP_CREATION_TSTMPL]
    LASTCHANGEBYUSER,               -- Changed By [ABP_LOCINST_LASTCHANGE_USER]
    LOCALLASTCHANGEDATETIME,        -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    LASTCHANGEDATETIME,             -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    RESPONSIBLEUSER,                -- Responsible [SUIDRESPONSIBLE]
    FISCALYEARPERIOD,               -- Fiscal YPeriod [FINS_FYEARPERIOD]
    JOURNALCASENAME,                -- Case Description [CASE_DESC]
    JOURNALCASESUMMARYTEXT,         -- Summary [IJUSUMMARY]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    JRNLCASEPRPSLCONTENTBINARY,     -- Attachment [FINIJU_ATTACHMENT]
    JRNLCASEPRPSLMIMETYPE,          -- Mime Type [FINIJU_MIME_TYPE]
    JOURNALCASEPROPOSALFILENAME,    -- File Name [FINIJU_FILENAME]
    DUMMY_JRNL_CASE_INCL_EEW_PS,    -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, JOURNALCASEUUID)
);

Learn More