FINIJU_CASE

Transparent Table Application Table
20 Fields 1 CDS Views

Case

FINIJU_CASE is an SAP database table in S/4HANA. Case. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JournalCase view_entity from BASIC Case Document Basic

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY case_uuid sysuuid_x16 UUID
case_id ijucase_id Case ID
gjahr gjahr Fiscal Year
case_cat case_cat Category Code
case_subcat case_subcat Subcategory Code
case_status case_status Case Status
poper poper Posting Period
periv periv FY Variant
case_desc case_desc Case Description
summary ijusummary Summary
pdoc_uuid sysuuid_x16 UUID
attachment finiju_attachment Attachment
mimetype finiju_mime_type Mime Type
filename finiju_filename File Name
responsible suidresponsible Responsible
createdby abp_creation_user Created By
createdon abp_creation_tstmpl Created On
changedby abp_locinst_lastchange_user Changed By
changedon abp_locinst_lastchange_tstmpl Changed On

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.

-- Case
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINIJU_CASE (
    MANDT,        -- Client [mandt]
    CASE_UUID,    -- UUID [sysuuid_x16]
    CASE_ID,      -- Case ID [ijucase_id]
    GJAHR,        -- Fiscal Year [gjahr]
    CASE_CAT,     -- Category Code [case_cat]
    CASE_SUBCAT,  -- Subcategory Code [case_subcat]
    CASE_STATUS,  -- Case Status [case_status]
    POPER,        -- Posting Period [poper]
    PERIV,        -- FY Variant [periv]
    CASE_DESC,    -- Case Description [case_desc]
    SUMMARY,      -- Summary [ijusummary]
    PDOC_UUID,    -- UUID [sysuuid_x16]
    ATTACHMENT,   -- Attachment [finiju_attachment]
    MIMETYPE,     -- Mime Type [finiju_mime_type]
    FILENAME,     -- File Name [finiju_filename]
    RESPONSIBLE,  -- Responsible [suidresponsible]
    CREATEDBY,    -- Created By [abp_creation_user]
    CREATEDON,    -- Created On [abp_creation_tstmpl]
    CHANGEDBY,    -- Changed By [abp_locinst_lastchange_user]
    CHANGEDON,    -- Changed On [abp_locinst_lastchange_tstmpl]
    PRIMARY KEY (MANDT, CASE_UUID)
);

Learn More