JVB03 - JV Billing Extract: Expenditure Detail Rpt

JV Billing Extract: Expenditure Detail Rpt information is stored in SAP table JVB03.
It is part of development package GJVA_BILLING in software component CA-JVA-JVA. This development package consists of objects that can be grouped under "Billing functionality for Joint Venture Accounting".

Fields for table JVB03

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
RCLNTClientXMANDTCLNT6
ID16 byte UUID in 36 chars according to RFC4122XSYSUUID_C36CHAR72JVB00
RYEARGeneral Ledger Fiscal YearXGJAHR_POSNUMC8
POPERPosting periodXPOPERNUMC6
VPTNRPartner account numberXJV_PARTCHAR20KNA1
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)XPS_PSP_PNRNUMC16
PRODPERProduction Month (Date to find period and year)XJV_PRODPERDATS16
RBUKRSCompany CodeXBUKRSCHAR8T001
RCNTRCost CenterXKOSTLCHAR20
RORDNROrder NumberXAUFNRCHAR24
NPLNRNetwork Number for Account AssignmentXNPLNRCHAR24
NPLNR_VORGNNetwork activityXNPVRGCHAR8
EGRUPEquity groupXJV_EGROUPCHAR6T8JF
VNAMEJoint ventureXJV_NAMECHAR12T8JV
FUNDING_CURRENCYFunding currencyXJV_FUNDCURCUKY10TCURC
RACCTAccount NumberXRACCTCHAR20SKA1
SDS_COSupplemental detail set for JV billingJV_SDSCHAR8
ORSDS_COSupplemental detail set for JV billingJV_SDSCHAR8
PROJ_SDSJV ProjectJV_PROJNUMC16
PROJ_SUPJV ProjectJV_PROJNUMC16
ORDER_SDSOrder NumberAUFNRCHAR24
BILLCODEJV Billing codeJV_BILLCOCHAR6
SDS_ACCSupplemental detail set for JV billingJV_SDSCHAR8
ORSDS_ACCSupplemental detail set for JV billingJV_SDSCHAR8
ACC_SDSAccount NumberRACCTCHAR20
SDS_RISupplemental detail set for JV billingJV_SDSCHAR8
ORSDS_RISupplemental detail set for JV billingJV_SDSCHAR8
RI_SDSRecovery IndicatorJV_RECINDCHAR4
TANGINDJV Tangible/Intangible IndicatorJV_TANGICHAR2
AFEINDJV AFE IndicatorJV_AFEINDCHAR2
AFENUMAFE (authorization for expenditure)JV_AFENUMCHAR44
ETYPEEquity typeJV_ETYPECHAR6
JIBCLJIB/JIBE ClassJV_JIBCLCHAR6T8J6A
JIBSAJIB/JIBE Subclass AJV_JIBSACHAR10T8J6C
JIBSBJV Subclass BJV_JIBSBCHAR48T8J6E
CEINDIndicator: CapitalJV_CEINDCHAR2
FCURR_PTDValue field 12(23) characters with 2 decimal placesWERTV12CURR12
FCURR_YTDValue field 12(23) characters with 2 decimal placesWERTV12CURR12
FCURR_ITDValue field 12(23) characters with 2 decimal placesWERTV12CURR12
RWCURTransaction CurrencyFINS_CURRWCUKY10TCURC
WSL_PTDAmount in Company Code CurrencyFINS_VHCUR12CURR12
WSL_YTDAmount in Company Code CurrencyFINS_VHCUR12CURR12
WSL_ITDAmount in Company Code CurrencyFINS_VHCUR12CURR12
RHCURCompany Code CurrencyFINS_CURRHCUKY10TCURC
HSL_PTDAmount in Company Code CurrencyFINS_VHCUR12CURR12
HSL_YTDAmount in Company Code CurrencyFINS_VHCUR12CURR12
HSL_ITDAmount in Company Code CurrencyFINS_VHCUR12CURR12
RKCURGlobal CurrencyFINS_CURRKCUKY10TCURC
KSL_PTDAmount in Global CurrencyFINS_VKCUR12CURR12
KSL_YTDAmount in Global CurrencyFINS_VKCUR12CURR12
KSL_ITDAmount in Global CurrencyFINS_VKCUR12CURR12
ROCURFreely Defined Currency 1FINS_CURR1CUKY10TCURC
OSL_PTDAmount in Freely Defined Currency 1FINS_VOCUR12CURR12
OSL_YTDAmount in Freely Defined Currency 1FINS_VOCUR12CURR12
OSL_ITDAmount in Freely Defined Currency 1FINS_VOCUR12CURR12
RVCURFreely Defined Currency 2FINS_CURR2CUKY10TCURC
VSL_PTDAmount in Freely Defined Currency 2FINS_VVCUR12CURR12
VSL_YTDAmount in Freely Defined Currency 2FINS_VVCUR12CURR12
VSL_ITDAmount in Freely Defined Currency 2FINS_VVCUR12CURR12
RBCURFreely Defined Currency 3FINS_CURR3CUKY10TCURC
BSL_PTDAmount in Freely Defined Currency 3FINS_VBCUR12CURR12
BSL_YTDAmount in Freely Defined Currency 3FINS_VBCUR12CURR12
BSL_ITDAmount in Freely Defined Currency 3FINS_VBCUR12CURR12
RCCURFreely Defined Currency 4FINS_CURR4CUKY10TCURC
CSL_PTDAmount in Freely Defined Currency 4FINS_VCCUR12CURR12
CSL_YTDAmount in Freely Defined Currency 4FINS_VCCUR12CURR12
CSL_ITDAmount in Freely Defined Currency 4FINS_VCCUR12CURR12
RDCURFreely Defined Currency 5FINS_CURR5CUKY10TCURC
DSL_PTDAmount in Freely Defined Currency 5FINS_VDCUR12CURR12
DSL_YTDAmount in Freely Defined Currency 5FINS_VDCUR12CURR12
DSL_ITDAmount in Freely Defined Currency 5FINS_VDCUR12CURR12
RECURFreely Defined Currency 6FINS_CURR6CUKY10TCURC
ESL_PTDAmount in Freely Defined Currency 6FINS_VECUR12CURR12
ESL_YTDAmount in Freely Defined Currency 6FINS_VECUR12CURR12
ESL_ITDAmount in Freely Defined Currency 6FINS_VECUR12CURR12
RFCURFreely Defined Currency 7FINS_CURR7CUKY10TCURC
FSL_PTDAmount in Freely Defined Currency 7FINS_VFCUR12CURR12
FSL_YTDAmount in Freely Defined Currency 7FINS_VFCUR12CURR12
FSL_ITDAmount in Freely Defined Currency 7FINS_VFCUR12CURR12
RGCURFreely Defined Currency 8FINS_CURR8CUKY10TCURC
GSL_PTDAmount in Freely Defined Currency 8FINS_VGCUR12CURR12
GSL_YTDAmount in Freely Defined Currency 8FINS_VGCUR12CURR12
GSL_ITDAmount in Freely Defined Currency 8FINS_VGCUR12CURR12
Privacy Policy