JVGLFLEXP SAP (General Ledger: Plan Line Items) Table details

Dictionary Type: Table
Description: General Ledger: Plan Line Items




ABAP Code to SELECT data from JVGLFLEXP
Related tables to JVGLFLEXP
Access table JVGLFLEXP




Table field list including key, data, relationships and ABAP select examples

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

The JVGLFLEXP table consists of various fields, each holding specific information or linking keys about General Ledger: Plan Line Items data available in SAP. These include RYEAR (Fiscal Year), DOCNR (Accounting Document Number), RLDNR (Ledger in General Ledger Accounting), RBUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP JVGLFLEXP table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
RCLNTClient MANDTCLNT3T000MANDT
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
RLDNRLedger in General Ledger Accounting FAGL_RLDNRCHAR2V_FAGL_T881_DBALALPHARLDNRGLN_FLEXFAGL_RLDNR
RBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
DOCLNSix-Character Posting Item for Ledger DOCLN6CHAR6DOCLN6
DOCCTDocument Type DOCCTCHAR1DOCCTGCT
RPMAXPeriod RPMAXNUMC3RPMAX
ACTIVFI-SL Business Transaction ACTI1CHAR4T022ACTIVITY
RMVCTTransaction Type RMVCTCHAR3T856RMVCT
RTCURCurrency Key RTCURCUKY5Assigned to domainWAERSFWS
RUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
RRCTYRecord Type RRCTYCHAR1RRCTY
RVERSVersion RVERSCHAR3T894ALPHARVERSGVS
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
RACCTAccount Number RACCTCHAR10SKB1ALPHASAKNRACC
COST_ELEMCost Element KSTARCHAR10CSKBALPHAKSTARKAT
RCNTRCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
RFAREAFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
RBUSABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
SCNTRSender cost center SKOSTCHAR10CSKSALPHAKOSTLKSK
PPRCTRPartner Profit Center PPRCTRCHAR10CEPCALPHAPRCTRPPC
SFAREAPartner Functional Area SFKBERCHAR16TFKBFKBER
SBUSATrading partner's business area PARGBCHAR4TGSBGSBERGSB
RASSCCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
RECIDRecovery Indicator JV_RECINDCHAR2Assigned to domainALPHAJV_RECIND
TSLVTBalance carried forward in transaction currency TSLVT12CURR23(2) WERTV12
TSL01Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL02Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL03Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL04Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL05Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL06Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL07Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL08Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL09Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL10Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL11Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL12Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL13Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL14Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL15Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
TSL16Total of transactions of the period in transaction currency TSLXX12CURR23(2) WERTV12
HSLVTBalance carried forward in local currency HSLVT12CURR23(2) WERTV12
HSL01Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL02Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL03Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL04Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL05Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL06Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL07Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL08Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL09Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL10Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL11Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL12Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL13Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL14Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL15Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
HSL16Total of transactions of the period in local currency HSLXX12CURR23(2) WERTV12
KSLVTTotal of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL01Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL02Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL03Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL04Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL05Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL06Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL07Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL08Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL09Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL10Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL11Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL12Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL13Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL14Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL15Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
KSL16Total of transactions of the period in group currency KSLXX12CURR23(2) WERTV12
OSLVTBalance carried forward in fourth currency OSLVT12CURR23(2) WERTV12
OSL01Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL02Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL03Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL04Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL05Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL06Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL07Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL08Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL09Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL10Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL11Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL12Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL13Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL14Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL15Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
OSL16Total transactions for the period in the fourth currency OSLXX12CURR23(2) WERTV12
MSLVTBalance carried forward of quantity MSLVT12QUAN23(3) MENGV12
MSL01Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL02Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL03Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL04Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL05Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL06Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL07Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL08Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL09Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL10Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL11Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL12Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL13Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL14Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL15Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
MSL16Total of the transactions of period in units of measure MSLXX12QUAN23(3) MENGV12
DRCRKDebit/Credit Indicator SHKZGCHAR1SHKZG
DOCTYDocument Type for Plan Documents in General Ledger FAGL_DOCTYCHAR2FAGL_T889AFAGL_DOCTY
WSDATValue Date for Currency Translation WSDATDATS8DATUMWSD
REFDOCNRReference document number of an accounting document REFBELNRCHAR10ALPHABELNRBLN
REFDOCLNSix-digit number of the reference posting line REFBUZEI6NUMC6BUZEI6BUZ
REFDOCCTReference document category REFDOCCTCHAR1DOCCTGCT
USNAMUser name USNAMCHAR12USR02XUBNAMEUSR
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table JVGLFLEXP using ABAP code

The following ABAP code Example will allow you to do a basic selection on JVGLFLEXP to SELECT all data from the table
DATA: WA_JVGLFLEXP TYPE JVGLFLEXP.

SELECT SINGLE *
FROM JVGLFLEXP
INTO CORRESPONDING FIELDS OF WA_JVGLFLEXP
WHERE...

How to access SAP table JVGLFLEXP

Within an ECC or HANA version of SAP you can also view further information about JVGLFLEXP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!