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 | |||||
| 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)
);
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