SAP TABLES | Cross-Application Components | Joint Venture und Production Sharing Accounting(CA-JVA) SAP CA

JVPO1 SAP JVA: Plan Line Items Table and data







JVPO1 is a standard SAP Table which is used to store JVA: Plan Line Items data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP JVPO1 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Not classified
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP JVPO1 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
RCLNTMANDTCLNT3 T000Client
GL_SIRIDGU_RECIDCHAR18 Record number of the line item record
RLDNRRLDNRCHAR2 T881LedgerALPHA
RRCTYRRCTYCHAR1 Record Type
RVERSRVERSCHAR3 T894VersionALPHA
RYEARGJAHRNUMC4 Fiscal YearGJAHR
RTCURRTCURCUKY5 TCURCCurrency Key
RUNITMEINSUNIT3 T006Base Unit of MeasureCUNIT
DRCRKSHKZGCHAR1 Debit/Credit Indicator
RPMAXRPMAXNUMC3 Period
DOCCTDOCCTCHAR1 Document Type
DOCNRDOCNRCHAR10 Doc. NumberALPHA
DOCLNJV_DOCLNNUMC3 Line Item in Joint Venture Document
RBUKRSBUKRSCHAR4 T001Company Code
RJVNAMJV_NAMECHAR6 T8JVJoint VentureALPHA
REGROUJV_EGROUPCHAR3 T8JFEquity groupALPHA
RACCTRACCTCHAR10
*
Account NumberALPHA
RBUSAGSBERCHAR4 TGSBBusiness Area
RKOKRSKOKRSCHAR4 TKA01Controlling Area
RCNTRKOSTLCHAR10
*
Cost CenterALPHA
RORDNRAUFNRCHAR12 AUFKOrder NumberALPHA
RPROJKPS_PSP_PNRNUMC8 PRPSWork Breakdown Structure Element (WBS Element)ABPSP
RPRCTRPRCTRCHAR10
*
Profit CenterALPHA
RANLN1ANLN1CHAR12 ANLHMain Asset NumberALPHA
RANLN2ANLN2CHAR4 ANLAAsset SubnumberALPHA
RANBWAANBWACHAR3 TABWAsset Transaction Type
RRECINJV_RECINDCHAR2 T8JJRecovery IndicatorALPHA
RPARTNJV_PARTCHAR10 KNA1Partner account numberALPHA
RDPOMJV_DPOMCHAR4 Posting Period Difference for Operational Month
RDBILLMJV_DBILLMCHAR4 Invoice Month: Posting Period Difference
NPLNRNPLNRCHAR12 AUFKNetwork Number for Account AssignmentALPHA
AUFPLAUFPL_CHNUMC10 Task list number for operations in order
APLZLAPLZL_CHNUMC8
*
General counter for order
VORNRVORNRCHAR4 Operation/Activity NumberNUMCV
TSLVTTSLVT9CURR17(2) Balance carried forward in transaction currency
TSL01TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL02TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL03TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL04TSLXX9CURR17(2) Total of transactions of the period in transaction currency


TSL05TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL06TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL07TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL08TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL09TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL10TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL11TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL12TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL13TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL14TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL15TSLXX9CURR17(2) Total of transactions of the period in transaction currency
TSL16TSLXX9CURR17(2) Total of transactions of the period in transaction currency
HSLVTHSLVT9CURR17(2) Balance carried forward in local currency
HSL01HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL02HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL03HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL04HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL05HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL06HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL07HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL08HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL09HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL10HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL11HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL12HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL13HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL14HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL15HSLXX9CURR17(2) Total of transactions of the period in local currency
HSL16HSLXX9CURR17(2) Total of transactions of the period in local currency
KSLVTKSLVT9CURR17(2) Balance carried forward in group currency
KSL01KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL02KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL03KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL04KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL05KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL06KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL07KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL08KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL09KSLXX9CURR17(2) Total of transactions of the period in group currency


KSL10KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL11KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL12KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL13KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL14KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL15KSLXX9CURR17(2) Total of transactions of the period in group currency
KSL16KSLXX9CURR17(2) Total of transactions of the period in group currency
MSLVTMSLVTQUAN15(3) Balance carried forward of quantity
MSL01MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL02MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL03MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL04MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL05MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL06MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL07MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL08MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL09MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL10MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL11MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL12MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL13MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL14MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL15MSLXXQUAN15(3) Total of the transactions of period in units of measure
MSL16MSLXXQUAN15(3) Total of the transactions of period in units of measure
AUNITAUNITUNIT3 T006Additional unit of measureCUNIT
SGTXTSGTXTCHAR50 Item Text
AUTOMAUTOMCHAR1 Indicator: Automatic posting lines
DOCTYBLARTCHAR2 T003Document Type
ACTIVGLVORCHAR4 Business Transaction
BUDATBUDATDATS8 Posting Date in the Document
WSDATWSDATDATS8 Value Date for Currency Translation
VALUTVALUTDATS8 Value date
REFDOCNRDOCNRCHAR10 Doc. NumberALPHA
REFRYEARGJAHRNUMC4 Fiscal YearGJAHR
REFDOCLNJV_REFDLNNUMC5 Line Item in Joint Venture Reference Doc
REFDOCCTDOCCTCHAR1 Document Type
REFACTIVGLVORCHAR4 Business Transaction
REFFIDLNBUZEINUMC3 Number of Line Item Within Accounting Document
CPUDTCPUDTDATS8 Day On Which Accounting Document Was Entered

CPUTMCPUTMTIMS6 Time of Entry
USNAMUSNAMCHAR12
*
User name
BLDATBLDATDATS8 Document Date in Document
BILIDJV_BILINDCHAR2 T8JAPayroll TypeALPHA
ORECIDJV_ORECIDCHAR2 T8JJOriginal Recovery IndicatorALPHA
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
BILLMJV_BILLMDATS8 Billing Month
POMJV_POMDATS8 Processing operational month
CBPERIODJV_CBPERINUMC3 JV Cutback Period
EBELNEBELNCHAR10 EKKOPurchasing Document NumberALPHA
EBELPEBELPNUMC5 EKPOItem Number of Purchasing Document
KTOSLKTOSLCHAR3 Transaction Key
MMACTJV_MM_ACTCHAR1 JVA MM Activity Type
LSTARLSTARCHAR6
*
Activity Type
CYCLECYCLECHAR10 Allocation/cycle
SDATESDATEDATS8
*
Start Date
SEQNRSQNRNUMC4
*
Segment number within a cycle
SEQNAMESEQNAMECHAR10 Name of a segment in assessment/distribution
REFCYCJV_REFCYCCHAR10 Reference Field for Allocation Cycle
MATNRMATNRCHAR18 MARAMaterial NumberMATN1
CONDIJV_CONDCODCHAR2 T8JXJoint Venture Indicator (Condition Key)ALPHA
AWTYPAWTYPCHAR5
*
Reference Transaction
AWORGAWORGCHAR10 Reference Organizational Units
LOGSYSLOGSYSCHAR10 TBDLSLogical systemALPHA
REFAWTYPAWTYPCHAR5 TTYPReference Transaction
REFAWREFAWREFCHAR10 Reference Document NumberALPHA
REFAWORGAWORGCHAR10 Reference Organizational Units
REFLOGSYSLOGSYSCHAR10 TBDLSLogical systemALPHA



Key field
Non-key field

JVPO1 relationships with other tables


GLFF-Fixed Fields in FI-SL
     COFIT-Totals Records for Reconciliation Ledger
          COFIS-Actual line items for reconciliation ledger
          COFIP-Single plan items for reconciliation ledger
     ECMCT-SAP Cons.: Totals Table
          ECMCA-SAP Cons.: Journal Entry Table (Actual)
     FBICRC001T-ICRC: Open Items GL Accounts: Totals
          FBICRC001A-ICRC: Open Items GL Accounts: Documents
          FBICRC001P-Not in use
     FBICRC002T-ICRC: GL Accounts: Totals
          FBICRC002A-ICRC: GL Accounts: Documents
          FBICRC002P-Not in use
     FBICRC003T-ICRC: Open Items Customers/Vendors: Totals
          FBICRC003A-ICRC: Open Items Customers/Vendors: Documents
          FBICRC003P-Not in use
     FILCT-FI-LC: Global totals table with 2 object tables
          FILCA-FI-LC: Actual journal entry table with 2 object ta
          FILCP-FI-LC: Plan line items for object table
     FMCCAVCT-Totals Table
          FMCCAVCA-Actual line item table
          FMCCAVCP-Plan line items table
     FMIT-Totals Table for Funds Management
          FMIA-Actual Line Item Table for Funds Management
          FMIP-Plan Line Items Table for Funds Management
     FMUSFGFACTS1T-Summary table
          FMUSFGFACTS1A-4Actual line item table
          FMUSFGFACTS1P-Plan line items table
     FMUSFGFACTS2T-Summary table
          FMUSFGFACTS2A-Actual line item table
          FMUSFGFACTS2P-Plan line items table
     FMUSFGT-Summary table for US Federal Government
          FMUSFGA-Actual line item table for US Federal Government.
          FMUSFGP-Plan line items table
     GLFUNCT-Totals Table for Cost of Sales Accounting
          GLFUNCA-Actual Line Items Table for Cost of Sales Accounti
          GLFUNCP-Plan Line Items Table for Cost of Sales Accounting
          GLFUNCU-Rollup line item tables with function area for IDE
          GLFUNCV-Rollup plan line items table with function area fo
     GLPCT-EC-PCA: Totals Table
          GLPCA-EC-PCA: Actual Line Items
          GLPCP-EC-PCA: Plan Line Items
     GLT0-G/L account master record transaction figures
          GLP0-Local Logical General Ledger Plan Line Items
     GLT1-Local General Ledger Summary Table
          GLS1-Local Logical General Ledger Actual Line Items
          GLP1-Local Logical General Ledger Plan Line Items
     GLT2-Consolidation totals table
          GLS2-Global logical Consolidation line items
          GLP2-Global Special Purpose Ledger Plan Line Item Table
     GLT3-Summary Data Preparations for Consolidation
     GMAVCT-Summary table
          GMAVCA-Actual line item table
          GMAVCP-Plan line items table
     GMIT-Summary table
          GMIA-Actual Line Item Table
          GMIP-Plan line items table
     JVPSC01T-Summary table
          JVPSC01A-Actual line item table
          JVPSC01P-Plan line item table
     JVTO1-JV Summary Table with Objects
          JVSO1-JV LI Table with Objects for JVTO1
          JVPO1-JVA: Plan Line Items
     JVTO2-JV Billing FI-SL Summary Table
          JVSO2-JV Billing FI-SL Line Item
     TRACTSLT-Totals Table
          TRACTSLA-Actual Line Item Table
          TRACTSLP-Plan Line Items Table
     ZSAWT-Summary table
          ZSAWA-Actual line item table
          ZSAWP-Plan line items table
     ZSEMBPST-Summary table
          ZSEMBPSA-Actual line item table
          ZSEMBPSP-Plan line items table
     ZSPLITT-
          ZSPLITA-
          ZSPLITP-
     ZZ001T-Summary Table
          ZZ001A-Actual Line Item Table
          ZZ001P-Plan Line Items Table
     ZZLINET-Summary table
          ZZLINEA-Actual line item table
          ZZLINEP-Plan line items table
     ZZSL01T-Summary table
          ZZSL01A-Actual line item table
          ZZSL01P-Plan line items table
     ZZSPECT-Summary table
          ZZSPECA-Actual line item table
          ZZSPECP-Plan line item table