JVBXCI
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_JntVntrCarriedInterestItem | view | from | BASIC | Carried Interest Document Items for JVA |
Fields (62)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | (Obsolete) JV Net Profit Interest Group | ||||
| cigroup | jv_cigrp | CI Group | ||||
| vname | jv_name | Joint venture | ||||
| etype | jv_etype | Equity Type | ||||
| egrup | jv_egroup | Equity group | ||||
| rwcur | abap.cuky | (Obsolete) Transaction Currency | ||||
| 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 | (Obsolete) Amount in Transaction Currency | ||||
| curbalt | abap.curr | (Obsolete) Amount in Transaction Currency | ||||
| endbalt | abap.curr | (Obsolete) Amount in Transaction Currency | ||||
| 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, -- (Obsolete) JV Net Profit Interest Group [abap.char]
CIGROUP, -- CI Group [jv_cigrp]
VNAME, -- Joint venture [jv_name]
ETYPE, -- Equity Type [jv_etype]
EGRUP, -- Equity group [jv_egroup]
RWCUR, -- (Obsolete) Transaction Currency [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, -- (Obsolete) Amount in Transaction Currency [abap.curr]
CURBALT, -- (Obsolete) Amount in Transaction Currency [abap.curr]
ENDBALT, -- (Obsolete) Amount in Transaction Currency [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)
);
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