FINIJU_CASEJEITM
Proposed JE Item
FINIJU_CASEJEITM is an SAP database table in S/4HANA. Proposed JE Item. It contains 49 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_JournalCaseProposalItem | view_entity | from | EXTENSION | Case Proposal Item - Extension |
| I_JournalCaseProposalItem | view_entity | from | BASIC | Case Journal Item Basic |
Fields (49)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| acdoc_eew_dummy | CFD_DUMMY | Dummy | ||||
| dummy_incl_eew_cobl | 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.
-- 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]
ACDOC_EEW_DUMMY, -- Dummy [CFD_DUMMY]
DUMMY_INCL_EEW_COBL, -- Dummy [CFD_DUMMY]
PRIMARY KEY (MANDT, JEITM_UUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA