FINIJU_JEITM_D

Transparent Table Application Table
55 Fields 2 CDS Views

Draft table for entity R_JRNLCASEPRPSLITEMTP

FINIJU_JEITM_D is an SAP database table in S/4HANA. Draft table for entity R_JRNLCASEPRPSLITEMTP. It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_JournalCaseProposalItemDraft view_entity from EXTENSION Case Proposal Item - Extension
R_JournalCaseProposalItemDraft view_entity from BASIC Journal Case Proposal Item - Draft

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY journalcaseproposalitemuuid SYSUUID_X16 UUID
journalcaseuuid SYSUUID_X16 UUID
journalcaseproposaluuid SYSUUID_X16 UUID
jrnlcaseprpsljournalentryitem IJU_JEITEMID Jrnl Prpsl Line Item
companycode BUKRS Company Code
glaccount HKONT G/L Acct
documentitemtext SGTXT Text
debitamountintranscrcy WRSOL Debit Amt in DC
creditamountintranscrcy WRHAB Credit Amt in DC
amountinlocalcurrency DMBTR Amount in LC
amountinadditionalcurrency2 DMBE2 LC2 Amount
taxcode MWSKZ Tax Code
taxjurisdiction TXJCD Tax Jur.
costcenter KOSTL Cost Center
profitcenter PRCTR Profit Center
orderid AUFNR Order
wbselement FIS_WBS_NO_CONV WBS Element
valuedate VALUT Value date
housebankaccount HBKID House Bank
housebank HKTID Account ID
assignmentreference DZUONR Assignment
partnercompany VBUND Company ID
postingkey NEWBS Posting Key
specialglcode NEWUM Special G/L Ind
absoluteamountintransaccrcy WRBTR Amount
taxiscalculatedautomatically XMWST Calculate Tax
paymentblockingreason DZLSPR Pmnt block
personnelnumber PERNR_D Personnel No.
assettransactiontype NEWBW Trans.Type
purchasingdocument EBELN Purchasing Doc.
salesorder KDAUF Sales Order
salesorderitem KDPOS Sales Ord. Item
partnerfunctionalarea FKBER Functional Area
partnerprofitcenter PPRCTR Partner PC
product ARTNR Product
distributionchannel VTWEG Distr. Channel
jointventureobjecttype JV_OTYPE JV Object Type
billtoparty KUNRE Bill-to Party
providercontract VTKEY_KK Contract
providercontractitem VTPOS_KK Contract Item
customernum KUNNR Customer
transactioncurrency FINS_CURRW Transaction Currency
globalcurrency FINS_CURRK Global Currency
companycodecurrency FINS_CURRH CompanyCode Currency
controllingarea KOKRS CO Area
chartofaccounts KTOPL Chart of Accts
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
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.

-- Draft table for entity R_JRNLCASEPRPSLITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINIJU_JEITM_D (
    MANDT,                          -- Client [MANDT]
    JOURNALCASEPROPOSALITEMUUID,    -- UUID [SYSUUID_X16]
    JOURNALCASEUUID,                -- UUID [SYSUUID_X16]
    JOURNALCASEPROPOSALUUID,        -- UUID [SYSUUID_X16]
    JRNLCASEPRPSLJOURNALENTRYITEM,  -- Jrnl Prpsl Line Item [IJU_JEITEMID]
    COMPANYCODE,                    -- Company Code [BUKRS]
    GLACCOUNT,                      -- G/L Acct [HKONT]
    DOCUMENTITEMTEXT,               -- Text [SGTXT]
    DEBITAMOUNTINTRANSCRCY,         -- Debit Amt in DC [WRSOL]
    CREDITAMOUNTINTRANSCRCY,        -- Credit Amt in DC [WRHAB]
    AMOUNTINLOCALCURRENCY,          -- Amount in LC [DMBTR]
    AMOUNTINADDITIONALCURRENCY2,    -- LC2 Amount [DMBE2]
    TAXCODE,                        -- Tax Code [MWSKZ]
    TAXJURISDICTION,                -- Tax Jur. [TXJCD]
    COSTCENTER,                     -- Cost Center [KOSTL]
    PROFITCENTER,                   -- Profit Center [PRCTR]
    ORDERID,                        -- Order [AUFNR]
    WBSELEMENT,                     -- WBS Element [FIS_WBS_NO_CONV]
    VALUEDATE,                      -- Value date [VALUT]
    HOUSEBANKACCOUNT,               -- House Bank [HBKID]
    HOUSEBANK,                      -- Account ID [HKTID]
    ASSIGNMENTREFERENCE,            -- Assignment [DZUONR]
    PARTNERCOMPANY,                 -- Company ID [VBUND]
    POSTINGKEY,                     -- Posting Key [NEWBS]
    SPECIALGLCODE,                  -- Special G/L Ind [NEWUM]
    ABSOLUTEAMOUNTINTRANSACCRCY,    -- Amount [WRBTR]
    TAXISCALCULATEDAUTOMATICALLY,   -- Calculate Tax [XMWST]
    PAYMENTBLOCKINGREASON,          -- Pmnt block [DZLSPR]
    PERSONNELNUMBER,                -- Personnel No. [PERNR_D]
    ASSETTRANSACTIONTYPE,           -- Trans.Type [NEWBW]
    PURCHASINGDOCUMENT,             -- Purchasing Doc. [EBELN]
    SALESORDER,                     -- Sales Order [KDAUF]
    SALESORDERITEM,                 -- Sales Ord. Item [KDPOS]
    PARTNERFUNCTIONALAREA,          -- Functional Area [FKBER]
    PARTNERPROFITCENTER,            -- Partner PC [PPRCTR]
    PRODUCT,                        -- Product [ARTNR]
    DISTRIBUTIONCHANNEL,            -- Distr. Channel [VTWEG]
    JOINTVENTUREOBJECTTYPE,         -- JV Object Type [JV_OTYPE]
    BILLTOPARTY,                    -- Bill-to Party [KUNRE]
    PROVIDERCONTRACT,               -- Contract [VTKEY_KK]
    PROVIDERCONTRACTITEM,           -- Contract Item [VTPOS_KK]
    CUSTOMERNUM,                    -- Customer [KUNNR]
    TRANSACTIONCURRENCY,            -- Transaction Currency [FINS_CURRW]
    GLOBALCURRENCY,                 -- Global Currency [FINS_CURRK]
    COMPANYCODECURRENCY,            -- CompanyCode Currency [FINS_CURRH]
    CONTROLLINGAREA,                -- CO Area [KOKRS]
    CHARTOFACCOUNTS,                -- Chart of Accts [KTOPL]
    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]
    ACDOC_EEW_DUMMY,                -- Dummy [CFD_DUMMY]
    DUMMY_INCL_EEW_COBL,            -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, JOURNALCASEPROPOSALITEMUUID)
);

Learn More