FINIJU_CASEJEITM

Transparent Table Application Table
47 Fields 1 CDS Views

Proposed JE Item

FINIJU_CASEJEITM is an SAP database table in S/4HANA. Proposed JE Item. It contains 47 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JournalCaseProposalItem view_entity from BASIC Case Journal Item Basic

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY jeitm_uuid sysuuid_x16 UUID
case_uuid sysuuid_x16 UUID
jehdr_uuid sysuuid_x16 UUID
iju_jeitemid iju_jeitemid Jrnl Prpsl Line Item
bukrs bukrs Company Code
hkont hkont G/L Acct
sgtxt sgtxt Text
wrsol wrsol Debit Amt in DC
wrhab wrhab Credit Amt in DC
dmbtr dmbtr Amount in LC
dmbe2 dmbe2 LC2 Amount
mwskz mwskz Tax Code
txjcd txjcd Tax Jur.
kostl kostl Cost Center
prctr prctr Profit Center
aufnr aufnr Order
ps_posid ps_posid WBS Element
valut valut Value date
hbkid hbkid House Bank
hktid hktid Account ID
zuonr dzuonr Assignment
vbund vbund Company ID
newbs newbs Posting Key
newum newum Special G/L Ind
wrbtr wrbtr Amount
xmwst xmwst Calculate Tax
zlspr dzlspr Pmnt block
pernr pernr_d Personnel No.
newbw newbw Trans.Type
ebeln ebeln Purchasing Doc.
kaufn kdauf Sales Order
kdpos kdpos Sales Ord. Item
fkber fkber Functional Area
pprct pprctr Partner PC
artnr artnr Product
vtweg vtweg Distr. Channel
otype jv_otype JV Object Type
kunre kunre Bill-to Party
wwprc vtkey_kk Contract
wwpci vtpos_kk Contract Item
kndnr kunnr Customer
rkcur fins_currk Global Currency
rhcur fins_currh CompanyCode Currency
rwcur fins_currw Transaction Currency
kokrs kokrs CO Area
ktopl ktopl Chart of Accts

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.

-- Proposed JE Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINIJU_CASEJEITM (
    MANDT,         -- Client [mandt]
    JEITM_UUID,    -- UUID [sysuuid_x16]
    CASE_UUID,     -- UUID [sysuuid_x16]
    JEHDR_UUID,    -- UUID [sysuuid_x16]
    IJU_JEITEMID,  -- Jrnl Prpsl Line Item [iju_jeitemid]
    BUKRS,         -- Company Code [bukrs]
    HKONT,         -- G/L Acct [hkont]
    SGTXT,         -- Text [sgtxt]
    WRSOL,         -- Debit Amt in DC [wrsol]
    WRHAB,         -- Credit Amt in DC [wrhab]
    DMBTR,         -- Amount in LC [dmbtr]
    DMBE2,         -- LC2 Amount [dmbe2]
    MWSKZ,         -- Tax Code [mwskz]
    TXJCD,         -- Tax Jur. [txjcd]
    KOSTL,         -- Cost Center [kostl]
    PRCTR,         -- Profit Center [prctr]
    AUFNR,         -- Order [aufnr]
    PS_POSID,      -- WBS Element [ps_posid]
    VALUT,         -- Value date [valut]
    HBKID,         -- House Bank [hbkid]
    HKTID,         -- Account ID [hktid]
    ZUONR,         -- Assignment [dzuonr]
    VBUND,         -- Company ID [vbund]
    NEWBS,         -- Posting Key [newbs]
    NEWUM,         -- Special G/L Ind [newum]
    WRBTR,         -- Amount [wrbtr]
    XMWST,         -- Calculate Tax [xmwst]
    ZLSPR,         -- Pmnt block [dzlspr]
    PERNR,         -- Personnel No. [pernr_d]
    NEWBW,         -- Trans.Type [newbw]
    EBELN,         -- Purchasing Doc. [ebeln]
    KAUFN,         -- Sales Order [kdauf]
    KDPOS,         -- Sales Ord. Item [kdpos]
    FKBER,         -- Functional Area [fkber]
    PPRCT,         -- Partner PC [pprctr]
    ARTNR,         -- Product [artnr]
    VTWEG,         -- Distr. Channel [vtweg]
    OTYPE,         -- JV Object Type [jv_otype]
    KUNRE,         -- Bill-to Party [kunre]
    WWPRC,         -- Contract [vtkey_kk]
    WWPCI,         -- Contract Item [vtpos_kk]
    KNDNR,         -- Customer [kunnr]
    RKCUR,         -- Global Currency [fins_currk]
    RHCUR,         -- CompanyCode Currency [fins_currh]
    RWCUR,         -- Transaction Currency [fins_currw]
    KOKRS,         -- CO Area [kokrs]
    KTOPL,         -- Chart of Accts [ktopl]
    PRIMARY KEY (MANDT, JEITM_UUID)
);

Learn More