JVBXCI

Transparent Table Temporary Data

JV Billing Extract: Carried Interest (CI)

JVBXCI is an SAP database table in S/4HANA. JV Billing Extract: Carried Interest (CI). It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JntVntrCarriedInterestItem view from BASIC Carried Interest Document Items for JVA

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY rclnt MANDT Client
KEY line_id JV_EXTR_LINEID LINE_ID
KEY ryear GJAHR_POS G/L Fiscal Year
KEY poper POPER Posting Period
KEY rbukrs BUKRS Company Code
int_type JV_INTTYPE Interest Type
vptnr JV_PART Partner
npigruop abap.char
cigroup JV_CIGRP CI Group
vname JV_NAME Joint venture
etype JV_ETYPE Equity Type
egrup JV_EGROUP Equity group
rwcur abap.cuky
rhcur FINS_CURRH CompanyCode Currency
rkcur FINS_CURRK Global Currency
rocur FINS_CURR1 Free Defined Crcy 1
rvcur FINS_CURR2 Free Defined Crcy 2
rbcur FINS_CURR3 Free Defined Crcy 3
rccur FINS_CURR4 Free Defined Crcy 4
rdcur FINS_CURR5 Free Defined Crcy 5
recur FINS_CURR6 Free Defined Crcy 6
rfcur FINS_CURR7 Free Defined Crcy 7
rgcur FINS_CURR8 Free Defined Crcy 8
e_r_ind JV_E_R_IND Expense/Revenue Indi
pencat JV_PENCAT Pen Category
btype JV_BILIND Billing ind.
recpc JV_NOSIGRP Non-signatory %
stoppay JV_STOPPAY StopPay
penalty FINS_VHCUR12 Amnt in Comp Cd Crcy
begbalt abap.curr
curbalt abap.curr
endbalt abap.curr
begball FINS_VHCUR12 Amnt in Comp Cd Crcy
curball FINS_VHCUR12 Amnt in Comp Cd Crcy
endball FINS_VHCUR12 Amnt in Comp Cd Crcy
begbalk FINS_VKCUR12 Amnt in Global Crcy
curbalk FINS_VKCUR12 Amnt in Global Crcy
endbalk FINS_VKCUR12 Amnt in Global Crcy
begbalo FINS_VOCUR12 Amount in Currency 1
curbalo FINS_VOCUR12 Amount in Currency 1
endbalo FINS_VOCUR12 Amount in Currency 1
begbalv FINS_VVCUR12 Amount in Currency 2
curbalv FINS_VVCUR12 Amount in Currency 2
endbalv FINS_VVCUR12 Amount in Currency 2
begbalb FINS_VBCUR12 Amount in Currency 3
curbalb FINS_VBCUR12 Amount in Currency 3
endbalb FINS_VBCUR12 Amount in Currency 3
begbalc FINS_VCCUR12 Amount in Currency 4
curbalc FINS_VCCUR12 Amount in Currency 4
endbalc FINS_VCCUR12 Amount in Currency 4
begbald FINS_VDCUR12 Amount in Currency 5
curbald FINS_VDCUR12 Amount in Currency 5
endbald FINS_VDCUR12 Amount in Currency 5
begbale FINS_VECUR12 Amount in Currency 6
curbale FINS_VECUR12 Amount in Currency 6
endbale FINS_VECUR12 Amount in Currency 6
begbalf FINS_VFCUR12 Amount in Currency 7
curbalf FINS_VFCUR12 Amount in Currency 7
endbalf FINS_VFCUR12 Amount in Currency 7
begbalg FINS_VGCUR12 Amount in Currency 8
curbalg FINS_VGCUR12 Amount in Currency 8
endbalg FINS_VGCUR12 Amount in Currency 8

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.

-- JV Billing Extract: Carried Interest (CI)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JVBXCI (
    RCLNT,     -- Client [MANDT]
    LINE_ID,   -- LINE_ID [JV_EXTR_LINEID]
    RYEAR,     -- G/L Fiscal Year [GJAHR_POS]
    POPER,     -- Posting Period [POPER]
    RBUKRS,    -- Company Code [BUKRS]
    INT_TYPE,  -- Interest Type [JV_INTTYPE]
    VPTNR,     -- Partner [JV_PART]
    NPIGRUOP,  -- abap.char
    CIGROUP,   -- CI Group [JV_CIGRP]
    VNAME,     -- Joint venture [JV_NAME]
    ETYPE,     -- Equity Type [JV_ETYPE]
    EGRUP,     -- Equity group [JV_EGROUP]
    RWCUR,     -- abap.cuky
    RHCUR,     -- CompanyCode Currency [FINS_CURRH]
    RKCUR,     -- Global Currency [FINS_CURRK]
    ROCUR,     -- Free Defined Crcy 1 [FINS_CURR1]
    RVCUR,     -- Free Defined Crcy 2 [FINS_CURR2]
    RBCUR,     -- Free Defined Crcy 3 [FINS_CURR3]
    RCCUR,     -- Free Defined Crcy 4 [FINS_CURR4]
    RDCUR,     -- Free Defined Crcy 5 [FINS_CURR5]
    RECUR,     -- Free Defined Crcy 6 [FINS_CURR6]
    RFCUR,     -- Free Defined Crcy 7 [FINS_CURR7]
    RGCUR,     -- Free Defined Crcy 8 [FINS_CURR8]
    E_R_IND,   -- Expense/Revenue Indi [JV_E_R_IND]
    PENCAT,    -- Pen Category [JV_PENCAT]
    BTYPE,     -- Billing ind. [JV_BILIND]
    RECPC,     -- Non-signatory % [JV_NOSIGRP]
    STOPPAY,   -- StopPay [JV_STOPPAY]
    PENALTY,   -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    BEGBALT,   -- abap.curr
    CURBALT,   -- abap.curr
    ENDBALT,   -- abap.curr
    BEGBALL,   -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    CURBALL,   -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    ENDBALL,   -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    BEGBALK,   -- Amnt in Global Crcy [FINS_VKCUR12]
    CURBALK,   -- Amnt in Global Crcy [FINS_VKCUR12]
    ENDBALK,   -- Amnt in Global Crcy [FINS_VKCUR12]
    BEGBALO,   -- Amount in Currency 1 [FINS_VOCUR12]
    CURBALO,   -- Amount in Currency 1 [FINS_VOCUR12]
    ENDBALO,   -- Amount in Currency 1 [FINS_VOCUR12]
    BEGBALV,   -- Amount in Currency 2 [FINS_VVCUR12]
    CURBALV,   -- Amount in Currency 2 [FINS_VVCUR12]
    ENDBALV,   -- Amount in Currency 2 [FINS_VVCUR12]
    BEGBALB,   -- Amount in Currency 3 [FINS_VBCUR12]
    CURBALB,   -- Amount in Currency 3 [FINS_VBCUR12]
    ENDBALB,   -- Amount in Currency 3 [FINS_VBCUR12]
    BEGBALC,   -- Amount in Currency 4 [FINS_VCCUR12]
    CURBALC,   -- Amount in Currency 4 [FINS_VCCUR12]
    ENDBALC,   -- Amount in Currency 4 [FINS_VCCUR12]
    BEGBALD,   -- Amount in Currency 5 [FINS_VDCUR12]
    CURBALD,   -- Amount in Currency 5 [FINS_VDCUR12]
    ENDBALD,   -- Amount in Currency 5 [FINS_VDCUR12]
    BEGBALE,   -- Amount in Currency 6 [FINS_VECUR12]
    CURBALE,   -- Amount in Currency 6 [FINS_VECUR12]
    ENDBALE,   -- Amount in Currency 6 [FINS_VECUR12]
    BEGBALF,   -- Amount in Currency 7 [FINS_VFCUR12]
    CURBALF,   -- Amount in Currency 7 [FINS_VFCUR12]
    ENDBALF,   -- Amount in Currency 7 [FINS_VFCUR12]
    BEGBALG,   -- Amount in Currency 8 [FINS_VGCUR12]
    CURBALG,   -- Amount in Currency 8 [FINS_VGCUR12]
    ENDBALG,   -- Amount in Currency 8 [FINS_VGCUR12]
    PRIMARY KEY (RCLNT, LINE_ID, RYEAR, POPER, RBUKRS)
);