JVBX03

Transparent Table Temporary Data
83 Fields 1 CDS Views

JV Billing Extract: Expenditure Detail Rpt

JVBX03 is an SAP database table in S/4HANA. JV Billing Extract: Expenditure Detail Rpt. It contains 83 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_JVAExpenditureDetail view_entity from BASIC JVA Expenditure Details

Fields (83)

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
year_doc gjahr_pos G/L Fiscal Year
poper_doc poper Posting Period
vptnr jv_part Partner
ps_psp_pnr ps_psp_pnr WBS Element
prodper jv_prodper Prod.Month
rcntr kostl Cost Center
rordnr aufnr Order
nplnr nplnr Network
nplnr_vorgn npvrg Netwk activity
egrup jv_egroup Equity group
vname jv_name Joint venture
funding_currency jv_fundcur Funding Crcy
racct racct Account Number
sds_result jv_sds SDS
sds_co jv_sds SDS
orsds_co jv_sds SDS
rcntr_sds kostl Cost Center
proj_sds jv_proj Project
proj_sup jv_proj Project
order_sds aufnr Order
billcode jv_billco Billing Code
sds_acc jv_sds SDS
orsds_acc jv_sds SDS
acc_sds racct Account Number
sds_ri jv_sds SDS
orsds_ri jv_sds SDS
ri_sds jv_recind Recovery Ind.
tangind jv_tangi Tangible Ind
afeind jv_afeind AFE Indicator
afenum jv_afenum AFE(CO Obj.no)
etype jv_etype Equity Type
jibcl jv_jibcl JIB/JIBE Class
jibsa jv_jibsa JIB/JIBE SbClsA
jibsb jv_jibsb JIB/JIBE Sub B
ceind jv_ceind Expense Type
fcurr_ptd wertv12 Value (12,2)
fcurr_ytd wertv12 Value (12,2)
fcurr_itd wertv12 Value (12,2)
rhcur fins_currh CompanyCode Currency
hsl_ptd fins_vhcur12 Amnt in Comp Cd Crcy
hsl_ytd fins_vhcur12 Amnt in Comp Cd Crcy
hsl_itd fins_vhcur12 Amnt in Comp Cd Crcy
rkcur fins_currk Global Currency
ksl_ptd fins_vkcur12 Amnt in Global Crcy
ksl_ytd fins_vkcur12 Amnt in Global Crcy
ksl_itd fins_vkcur12 Amnt in Global Crcy
rocur fins_curr1 Free Defined Crcy 1
osl_ptd fins_vocur12 Amount in Currency 1
osl_ytd fins_vocur12 Amount in Currency 1
osl_itd fins_vocur12 Amount in Currency 1
rvcur fins_curr2 Free Defined Crcy 2
vsl_ptd fins_vvcur12 Amount in Currency 2
vsl_ytd fins_vvcur12 Amount in Currency 2
vsl_itd fins_vvcur12 Amount in Currency 2
rbcur fins_curr3 Free Defined Crcy 3
bsl_ptd fins_vbcur12 Amount in Currency 3
bsl_ytd fins_vbcur12 Amount in Currency 3
bsl_itd fins_vbcur12 Amount in Currency 3
rccur fins_curr4 Free Defined Crcy 4
csl_ptd fins_vccur12 Amount in Currency 4
csl_ytd fins_vccur12 Amount in Currency 4
csl_itd fins_vccur12 Amount in Currency 4
rdcur fins_curr5 Free Defined Crcy 5
dsl_ptd fins_vdcur12 Amount in Currency 5
dsl_ytd fins_vdcur12 Amount in Currency 5
dsl_itd fins_vdcur12 Amount in Currency 5
recur fins_curr6 Free Defined Crcy 6
esl_ptd fins_vecur12 Amount in Currency 6
esl_ytd fins_vecur12 Amount in Currency 6
esl_itd fins_vecur12 Amount in Currency 6
rfcur fins_curr7 Free Defined Crcy 7
fsl_ptd fins_vfcur12 Amount in Currency 7
fsl_ytd fins_vfcur12 Amount in Currency 7
fsl_itd fins_vfcur12 Amount in Currency 7
rgcur fins_curr8 Free Defined Crcy 8
gsl_ptd fins_vgcur12 Amount in Currency 8
gsl_ytd fins_vgcur12 Amount in Currency 8
gsl_itd 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: Expenditure Detail Rpt
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JVBX03 (
    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]
    YEAR_DOC,          -- G/L Fiscal Year [gjahr_pos]
    POPER_DOC,         -- Posting Period [poper]
    VPTNR,             -- Partner [jv_part]
    PS_PSP_PNR,        -- WBS Element [ps_psp_pnr]
    PRODPER,           -- Prod.Month [jv_prodper]
    RCNTR,             -- Cost Center [kostl]
    RORDNR,            -- Order [aufnr]
    NPLNR,             -- Network [nplnr]
    NPLNR_VORGN,       -- Netwk activity [npvrg]
    EGRUP,             -- Equity group [jv_egroup]
    VNAME,             -- Joint venture [jv_name]
    FUNDING_CURRENCY,  -- Funding Crcy [jv_fundcur]
    RACCT,             -- Account Number [racct]
    SDS_RESULT,        -- SDS [jv_sds]
    SDS_CO,            -- SDS [jv_sds]
    ORSDS_CO,          -- SDS [jv_sds]
    RCNTR_SDS,         -- Cost Center [kostl]
    PROJ_SDS,          -- Project [jv_proj]
    PROJ_SUP,          -- Project [jv_proj]
    ORDER_SDS,         -- Order [aufnr]
    BILLCODE,          -- Billing Code [jv_billco]
    SDS_ACC,           -- SDS [jv_sds]
    ORSDS_ACC,         -- SDS [jv_sds]
    ACC_SDS,           -- Account Number [racct]
    SDS_RI,            -- SDS [jv_sds]
    ORSDS_RI,          -- SDS [jv_sds]
    RI_SDS,            -- Recovery Ind. [jv_recind]
    TANGIND,           -- Tangible Ind [jv_tangi]
    AFEIND,            -- AFE Indicator [jv_afeind]
    AFENUM,            -- AFE(CO Obj.no) [jv_afenum]
    ETYPE,             -- Equity Type [jv_etype]
    JIBCL,             -- JIB/JIBE Class [jv_jibcl]
    JIBSA,             -- JIB/JIBE SbClsA [jv_jibsa]
    JIBSB,             -- JIB/JIBE Sub B [jv_jibsb]
    CEIND,             -- Expense Type [jv_ceind]
    FCURR_PTD,         -- Value (12,2) [wertv12]
    FCURR_YTD,         -- Value (12,2) [wertv12]
    FCURR_ITD,         -- Value (12,2) [wertv12]
    RHCUR,             -- CompanyCode Currency [fins_currh]
    HSL_PTD,           -- Amnt in Comp Cd Crcy [fins_vhcur12]
    HSL_YTD,           -- Amnt in Comp Cd Crcy [fins_vhcur12]
    HSL_ITD,           -- Amnt in Comp Cd Crcy [fins_vhcur12]
    RKCUR,             -- Global Currency [fins_currk]
    KSL_PTD,           -- Amnt in Global Crcy [fins_vkcur12]
    KSL_YTD,           -- Amnt in Global Crcy [fins_vkcur12]
    KSL_ITD,           -- Amnt in Global Crcy [fins_vkcur12]
    ROCUR,             -- Free Defined Crcy 1 [fins_curr1]
    OSL_PTD,           -- Amount in Currency 1 [fins_vocur12]
    OSL_YTD,           -- Amount in Currency 1 [fins_vocur12]
    OSL_ITD,           -- Amount in Currency 1 [fins_vocur12]
    RVCUR,             -- Free Defined Crcy 2 [fins_curr2]
    VSL_PTD,           -- Amount in Currency 2 [fins_vvcur12]
    VSL_YTD,           -- Amount in Currency 2 [fins_vvcur12]
    VSL_ITD,           -- Amount in Currency 2 [fins_vvcur12]
    RBCUR,             -- Free Defined Crcy 3 [fins_curr3]
    BSL_PTD,           -- Amount in Currency 3 [fins_vbcur12]
    BSL_YTD,           -- Amount in Currency 3 [fins_vbcur12]
    BSL_ITD,           -- Amount in Currency 3 [fins_vbcur12]
    RCCUR,             -- Free Defined Crcy 4 [fins_curr4]
    CSL_PTD,           -- Amount in Currency 4 [fins_vccur12]
    CSL_YTD,           -- Amount in Currency 4 [fins_vccur12]
    CSL_ITD,           -- Amount in Currency 4 [fins_vccur12]
    RDCUR,             -- Free Defined Crcy 5 [fins_curr5]
    DSL_PTD,           -- Amount in Currency 5 [fins_vdcur12]
    DSL_YTD,           -- Amount in Currency 5 [fins_vdcur12]
    DSL_ITD,           -- Amount in Currency 5 [fins_vdcur12]
    RECUR,             -- Free Defined Crcy 6 [fins_curr6]
    ESL_PTD,           -- Amount in Currency 6 [fins_vecur12]
    ESL_YTD,           -- Amount in Currency 6 [fins_vecur12]
    ESL_ITD,           -- Amount in Currency 6 [fins_vecur12]
    RFCUR,             -- Free Defined Crcy 7 [fins_curr7]
    FSL_PTD,           -- Amount in Currency 7 [fins_vfcur12]
    FSL_YTD,           -- Amount in Currency 7 [fins_vfcur12]
    FSL_ITD,           -- Amount in Currency 7 [fins_vfcur12]
    RGCUR,             -- Free Defined Crcy 8 [fins_curr8]
    GSL_PTD,           -- Amount in Currency 8 [fins_vgcur12]
    GSL_YTD,           -- Amount in Currency 8 [fins_vgcur12]
    GSL_ITD,           -- Amount in Currency 8 [fins_vgcur12]
    PRIMARY KEY (RCLNT, LINE_ID, RYEAR, POPER, RBUKRS)
);

Learn More