GLFLEXP SAP (Flexible G/L: Plan line items) Table details

Dictionary Type: Table
Description: Flexible G/L: Plan line items




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




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

GLFLEXP is a standard SAP Table which is used to store Flexible G/L: Plan line items data and is available within R/3 SAP systems depending on the version and release level.

The GLFLEXP table consists of various fields, each holding specific information or linking keys about Flexible G/L: Plan line items data available in SAP. These include RYEAR (Fiscal Year), DOCNR (Accounting Document Number), RLDNR (Ledger of Flexible General Ledger), 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 GLFLEXP 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 of Flexible General Ledger RLDNR_FLEXCHAR2T881ALPHARLDNRGLN_FLEXH_T881_FLEX
RBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
DOCLNSix-Character Posting Item for Ledger DOCLN6CHAR6DOCLN6
DOCCTDocument Type DOCCTCHAR1DOCCTGCT
RPMAXPeriod RPMAXNUMC3RPMAX
DRCRKDebit/Credit Indicator SHKZGCHAR1SHKZG
RRCTYRecord Type RRCTYCHAR1RRCTY
RVERSVersion RVERSCHAR3T894ALPHARVERSGVS
RACCTAccount Number RACCTCHAR10Assigned to domainALPHASAKNRACC
RCNTRCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
RFAREAFunctional Area FKBERCHAR16TFKBFKBERFBE
RBUSABusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
SACCTPartner account number SACCTCHAR10Assigned to domainALPHASAKNRACC
SCNTRSender cost center SKOSTCHAR10Assigned to domainALPHAKOSTLKSK
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
SFAREAPartner Functional Area SFKBERCHAR16TFKBFKBER
SBUSATrading partner's business area PARGBCHAR4TGSBGSBERGSB
RASSCCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
ACTIVBusiness Transaction GLVORCHAR4CHAR4
RMVCTTransaction Type RMVCTCHAR3Assigned to domainRMVCT
RTCURCurrency Key RTCURCUKY5TCURCWAERSFWS
RUNITBase Unit of Measure MEINSUNIT3T006CUNITMEINS
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
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
KSLVTBalance carried forward in group currency KSLVT12CURR23(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
SGTXTItem Text SGTXTCHAR50TEXT50
DOCTYDocument Type for General Ledger Accounting in ERP DOCTY_FLEXCHAR2T003BLARTBAR
BUDATPosting Date in the Document BUDATDATS8DATUM
WSDATValue Date for Currency Translation WSDATDATS8DATUMWSD
REFDOCNRReference document number of an accounting document REFBELNRCHAR10ALPHABELNRBLN
REFRYEARReference fiscal year REFGJAHRNUMC4GJAHRGJAHRGJR
REFDOCLNSix-digit number of the reference posting line REFBUZEI6NUMC6BUZEI6BUZ
REFDOCCTReference document category REFDOCCTCHAR1DOCCTGCT
REFACTIVFI-SL Business Reference Transaction REFGLVORCHAR4CHAR4
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
USNAMUser name USNAMCHAR12USR02XUBNAMEUSR
AWTYPReference Transaction AWTYPCHAR5TTYPAWTYP
AWORGReference Organizational Units AWORGCHAR10AWORG

Key field Non-key field



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

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

SELECT SINGLE *
FROM GLFLEXP
INTO CORRESPONDING FIELDS OF WA_GLFLEXP
WHERE...

How to access SAP table GLFLEXP

Within an ECC or HANA version of SAP you can also view further information about GLFLEXP 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!