GLU3 SAP (FI-SL drilldown reporting: Superstructure w/all fields used) Structure details

Dictionary Type: Structure
Description: FI-SL drilldown reporting: Superstructure w/all fields used




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




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

GLU3 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "FI-SL drilldown reporting: Superstructure w/all fields used" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_GLU3 TYPE GLU3.

The GLU3 table consists of various fields, each holding specific information or linking keys about FI-SL drilldown reporting: Superstructure w/all fields used data available in SAP. These include ID (Internal: Node ID), VERSN (Financial Statement Version), ERGSL (Financial Statement Item), CURTP (Currency Type for Sales Segments).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP GLU3 structure 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
IDInternal: Node ID SEU_IDNUMC6SEU_ID
VERSNFinancial Statement Version VERSN_011CHAR4T011VERSN_011BIL
ERGSLFinancial Statement Item ERGSLCHAR10ERGSL
CURTPCurrency Type for Sales Segments ALLGCRTPCHAR2CURTP
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
KTOPLChart of Accounts KTOPLCHAR4T004KTOPLKPLC_KTOPL
SAK_PLUMIFinancial Statement Item/Account Number SAK_PLUMICHAR11RRSAKSAKNR_PLUMI
SAKFB_LONGFinancial Statement Item/Account No./Functional Area Long SAKFB_LONGCHAR16RRSAKSAKFB_LONG
KKTPLGroup Chart of Accts KKTPLCHAR4T004KTOPLKPL
BILKTGroup Account Number BILKTCHAR10SKA1ALPHASAKNR
KTOP2Chart of Accounts According to Country Legislation KTOP2CHAR4T004KTOPL
ALTKTAlternative account number in company code ALTKT_SKB1CHAR10SKA1ALPHASAKNR
RKTPLChart of Accounts KTOPLCHAR4T004KTOPLKPLC_KTOPL
ADB_PFROMPeriod From (Average Daily Balance) ADB_PFROMDATS8DATUM
ADB_PTOPeriod To (Average Daily Balance) ADB_PTODATS8DATUM
RCLNTClient MANDTCLNT3T000MANDT
RLDNRLedger RLDNRCHAR2T881ALPHARLDNRGLNH_T881
RRCTYRecord Type RRCTYCHAR1RRCTY
RVERSVersion RVERSCHAR3T894ALPHARVERSGVS
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
RTCURCurrency Key RTCURCUKY5TCURCWAERSFWS
RUNITBase Unit of Measure MEINSUNIT3T006CUNITMEINS
DRCRKDebit/Credit Indicator SHKZGCHAR1SHKZG
RBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RACCTAccount Number RACCTCHAR10SKB1ALPHASAKNRACC
RBUSABusiness Area GSBERCHAR4TGSBGSBERGSB
RFAREAFunctional Area FKBERCHAR16TFKBFKBERFBE
OCLNTOriginal client OCLNTNUMC3NUM3
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
RMVCTTransaction Type RMVCTCHAR3T856RMVCT
RASSCCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
SBUKRSCompany code of partner PBUKRSCHAR4T001BUKRSBUK
SACCTPartner account number PRACCTCHAR10Assigned to domainALPHASAKNR
SBUSATrading Partner Business Area of the Business Partner PPARGBCHAR4TGSBGSBERGSB
SFAREAPartner Functional Area SFKBERCHAR16TFKBFKBER
RHRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4TKKH1HRKFT
ROBARTReconciliation ledger object type (technical) COFI_OB_CVCHAR2OBARTJ_OBART_LD
RSCOPEObject Class SCOPE_CVCHAR2SCOPESCOPE_CVPCO
RFUNDFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
RGRANT_NBRReceiver Grant GM_GRANT_RECEIVERCHAR20Assigned to domainALPHAGM_GRANT_NBR
RLOGSYSLogical system of object LOGSYSOCHAR10TBDLSALPHALOGSYS
SHRKFTOrigin of partner (subdivision of cost element) PHRKFTCHAR4TKKH1HRKFT
SOBARTPartner object type (for reconciliation ledger) COFI_PO_CVCHAR2OBARTJ_OBART_LD
SSCOPEPartner object class PSCOPE_CVCHAR2SCOPESCOPE_CV
SFUNDPartner Fund BP_P_GEBERCHAR10FMFINCODEBP_GEBERFIC
SGRANT_NBRSender Grant GM_GRANT_SENDERCHAR20GMGRALPHAGM_GRANT_NBR
SLOGSYSLogical system of partner object LOGSYSPCHAR10TBDLSALPHALOGSYS
VRGNGCO Business Transaction CO_VORGANGCHAR4TJ01J_VORGANG
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
WRTTPValue Type CO_WRTTPCHAR2CO_WRTTP
ACTIVRecord type of reconciliation ledger RCL_TRIGCHAR4RCL_TRIG
RCOMPCompany RCOMP_DCHAR6T880ALPHARCOMPGCC
RDIMENDimension FC_DIMENCHAR2TF150FC_DIMENDINFC_DIMEN
RBUNITConsolidation unit FC_BUNITCHAR18TF160AFIMCFC_BUNITBUN
RITCLGConsolidation chart of accounts FC_ITCLGCHAR2TF120FC_ITCLGITCFC_ITCLG
RITEMFinancial statement item FC_ITEMCHAR10TF100BFIMCFC_ITEMITM
RBUPTRPartner unit FC_BUPTRCHAR18TF160AFIMCFC_BUNIT
RCONGRConsolidation group FC_CONGRCHAR18TF180AFIMCFC_CONGRCGR
ROBUKRSOriginal company code OBUKRCHAR4T001BUKRS
SITYPSubitem category FC_SITYPCHAR3TF110FC_SITYPSTPFC_SITYP
SUBITSubitem FC_SITEMCHAR10TF115FC_SITEMSTM
PLEVLPosting level FC_PLEVLCHAR2FC_PLEVL
RPFLGApportionment FC_RPFLGNUMC1FC_RPFLG
RTFLGCurrency translation FC_RTFLGNUMC1FC_RTFLG
DOCTYFI-SL Document Type DOCTYCHAR2T889DOCTYBAR
YRACQYear of acquisition FC_RYACQNUMC4GJAHRGJAHR
PRACQPeriod of Acquisition RPACQNUMC3NUM03
COICUInvestee unit FC_COICUCHAR18TF160AFIMCFC_BUNITCCU
DOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DOCLNSix-Character Posting Item for Ledger DOCLN6CHAR6DOCLN6
AWTYPReference Transaction AWTYPCHAR5TTYPAWTYP
COST_ELEMCost Element KSTARCHAR10CSKBALPHAKSTARKAT
RCNTRCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
SCNTRSender cost center SKOSTCHAR10CSKSALPHAKOSTLKSK
PPRCTRPartner Profit Center PPRCTRCHAR10CEPCALPHAPRCTRPPC
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
RTYPERecord Type FB_ICRC_RTYPECHAR1FB_ICRC_RTYPE
SEQNRSegment number within a cycle SQNRNUMC4T811SSQNR
RCUSTCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
RVENDAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
RLEVLPosting level RLEVLCHAR1RLEVL
RSUBDSubgroup RSUBDCHAR3T852RSUBDGSG
RYACQYear of acquisition RYACQCHAR4GJAHRCJAHR
RPACQPeriod of Acquisition RPACQNUMC3NUM03
ADFLD1First additional field for user-defined account assignments ADFLD1CHAR10T85AADFLD1FK_ADFLD1
ADFLD2Second additional field for user-defined account assignments ADFLD2CHAR10T85BADFLD2FK_ADFLD2
ADFLD3Third additional field for user-defined account assignments ADFLD3CHAR10T85CADFLD3FK_ADFLD3
SCOMPCompany SCOMP_DCHAR6T880ALPHARCOMPGCC
SASSCCompany ID of trading partner SASSCCHAR6T880ALPHARCOMPPGS
RFIKRSFinancial Management Area FIKRSCHAR4FM01FIKRSFIK
RFUNDSCTRFunds Center FISTLCHAR16FMFCTRFISTLFIS
RCMMTITEMCommitment Item FM_FIPEXCHAR24FMCIFM_FIPEXFPS
RFUNCAREAFunctional Area FM_FAREACHAR16TFKBFKBERFBE
RUSERDIMCustomer Field for FM Actual and Commitment Data FM_USERDIMCHAR10CHAR10
RMEASUREFunded Program FM_MEASURECHAR24FMMEASUREFM_MEASUREFM_MEASURE
RCVRGRP_9Cover Group FMCE_CVRGRPCHAR16Assigned to domainFMCE_CVRGRP
BUDGET_PD_9FM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
CEFFYEAR_9Year of Cash Effectivity GNJHRNUMC4GJAHRGJAHRGNJHR
WFSTATE_9Workflow Status of a Record in the AVC Totals Table BUAVC_WFSTATECHAR1BUKU_WFSTATE
ALLOCTYPE_9Amount Type (Availability Control) BUAVC_ALLOCTYPECHAR4BUAVC_ALLOCTYPE
VALTYPE_9BCS Value Type BUKU_VALTYPECHAR2BUVALTYPEBUKU_VALTYPE
PROCESS_9Internal Budgeting Process BUKU_PROCESSCHAR4BUPROCESSBUKU_PROCESS
BUDTYPE_9Budget Type BUKU_BUDTYPECHAR4FMBUDTYPECHAR4BUTY
RBUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
FIKRSFinancial Management Area FIKRSCHAR4FM01FIKRSFIK
RFISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
RFONDSFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
RFIPEXCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
RWRTTPValue Type FM_WRTTPCHAR2FM_WRTTP
RBTARTAmount type FM_BTARTCHAR4FM_BTART
RGNJHRYear of Cash Effectivity GNJHRNUMC4GJAHRGJAHRGNJHR
RHKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
RSTATSFunds Management Statistical Indicator FM_STATSCHAR1FM_STATS
RCFLEVCarryforward level FM_CFLEVCHAR1FM_CFLEV
ROBJNRZObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
RVRGNGCO Business Transaction CO_VORGANGCHAR4Assigned to domainJ_VORGANG
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
RIBPROC_9RIB Process BURB_PROCESSCHAR4BURB_PROCESS
RPRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
RPROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
RORDNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
RVBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
RAGNCY_LCTN_CODEAgency Location Code FMFG_ALCCHAR8Assigned to domainFMFG_ALCFMFG_ALC
RFINUSEApplication of Secondary Source Funds FM_FINUSECHAR16Assigned to domainFM_FINUSEFIU
FMFG_SUBKEY_9Subkey for FMUSFGT FMFG_SUBKEYCHAR10CHAR10
BLSTATUS_9Budgetary ledger status FMFG_BLSTATUSCHAR5FMFG_BLSTATUSFMFG_BLSTATUS
RFLG_COVEREDCovered Indicator FM_FLG_COVEREDCHAR1FM_FLG_COVERED
RFLG_CUSTODIALCustodial Indicator FM_FLG_CUSTODIALCHAR1FM_FLG_CUSTODIAL
RFLG_ENTITYEntity Indicator FM_FLG_ENTITYCHAR1FM_FLG_ENTITY
RFLG_EXCHANGEExchange Indicator FM_FLG_EXCHANGECHAR1FM_FLG_EXCHANGE
RFLG_PARTNERTransaction Partner FM_FLG_PARTNERCHAR1FM_FLG_PARTNER
RBDGT_FUNC_CLSSClassification of Data According to Major Purpose FM_BDGT_FUNC_CLSSCHAR3CHAR3
FMFG_SUBKEY96_9Subkey for FMUSFGFACTS1T FMFG_SUBKEY96CHAR10CHAR10
RFLG_APPORTApportionment Category FM_FLG_APPORTCHAR1FM_FLG_APPORT
RFLG_AVAILAvailability Time FM_FLG_AVAILCHAR1FM_FLG_AVAIL
RFLG_BORROWBorrowing Source FM_FLG_BORROWCHAR1FM_FLG_BORROW
RFLG_DEFINITEDefinite/Indef indicator FM_FLG_DEFINITECHAR1FM_FLG_DEFINITE
RFLG_BEABudget Enforcement Act Category FM_FLG_BEACHAR1FM_FLG_BEA
RLEGISType of Legislation FM_LEGISCHAR1FM_LEGIS
RFLG_REIMBURReimbursable FM_FLG_REIMBURCHAR1FM_FLG_REIMBUR
RCOHORTReporting Year for Cohort FM_COHORTCHAR4FM_COHORT
RPUBLAWPublic Law Cited FM_PUBLAWCHAR20FM_PUBLAW
RFLG_AUTHORAuthority Type FM_FLG_AUTHORCHAR1FM_FLG_AUTHOR
FAREAFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
BUSABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
FMFG_SUBKEY97_9Subkey for FMUSFGFACTS2T FMFG_SUBKEY97CHAR10CHAR10
RHOARTType of origin object (EC-PCA) HOARTNUMC2HOARTPCH
HRKFTOrigin Group as Subdivision of Cost Element HRKFTCHAR4Assigned to domainHRKFT
EPRCTRPartner profit center for elimination of internal business EPRCTRCHAR10CEPCALPHAPRCTR
AFABEReal depreciation area AFABE_DNUMC2Assigned to domainAFABEAFB
SPRCTRPartner Profit Center PPRCTRCHAR10CEPCALPHAPRCTRPPC
SHOARTType of receiver object SHOARTNUMC2HOART
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
VERSAResults Analysis Version VERSN_ABGRCHAR3TKKAPALPHAVERSN_ABGRACV
STAGRStatistical key figure STAGRCHAR6TKA03STAGRSTA
REP_MATNRRepresentative material for Profit Center Accounting REP_MATNRCHAR18T8A60MATN1MATNRRPMPCA_SHLP_REP_MATNR
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
POPERPosting period POPERNUMC3POPERPOPR
DOCCTDocument Type DOCCTCHAR1DOCCTGCT
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
RACVTActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
OBUKROriginal company code OBUKRCHAR4T001BUKRS
RSPONSORED_PROGSponsored Program GM_SPONSORED_PROGCHAR20Assigned to domainGM_SPONSORED_PROGGM_SPONSORED_PROG
RSPONSORED_CLASSSponsored Class GM_SPONSORED_CLASSCHAR20Assigned to domainGM_SPONSORED_CLASSGM_SPONSORED_CLASS
RBDGT_VLDTY_NBRBudget Validity Number GM_BDGT_VLDTY_NBRCHAR3GM_BDGT_VLDTY_NBR
GRANTEE_FY_9Fiscal Year of Grantee Organization GM_GRANTEE_FYNUMC4GJAHRGJAHR
RVALUETYPE_9GM Value Type GM_VALUETYPECHAR2GM_VALUETYPEGMVALUETYPE
RTRANSBusiness Transaction J_VORGANGCHAR4Assigned to domainJ_VORGANG
RSTATS_INDStatistical Indicator GM_STATSCHAR1GM_STATS
RGRANTEE_FY_9Fiscal Year of Grantee Organization GM_GRANTEE_FYNUMC4GJAHRGJAHR
BDGT_STATEWorkflow State of a Record in the Budget Totals Table GM_BDGT_STATECHAR1GM_BDGT_STATE
RPSC_NAMEPSC Name PSC_NAMECHAR10Assigned to domainPSC_NAME
RPSC_PRODUCTPSC Product PSC_PRODUCTCHAR10Assigned to domainPSC_PRODUCT
RJVNAMJoint Venture JV_NAMECHAR6T8JVALPHAJV_NAMEJVV
REGROUEquity group JV_EGROUPCHAR3T8JFALPHAJV_EGROUPGJE
RAUFPLTask list number for operations in order AUFPL_CHNUMC10AUFPL
RAPLZLGeneral counter for order APLZL_CHNUMC8Assigned to domainCO_APLZL
RRECINRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
PSC_CALC_TYPEPSC Calculation Type PSC_CTNUMC3Assigned to domainPSC_CT
PSC_PER_COSTPSC Period Costs PSC_PER_COSTCHAR1PSC_PER_COST
ANLN1Main Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
ANBWAAsset Transaction Type ANBWACHAR3Assigned to domainBWASL
PARTNPartner account number JV_PARTCHAR10Assigned to domainALPHAKUNNR
SPSC_NAMEPSC Name PSC_NAMECHAR10Assigned to domainPSC_NAME
SPSC_PRODUCTPSC Product PSC_PRODUCTCHAR10Assigned to domainPSC_PRODUCT
RKOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
RANLN1Main Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
RANLN2Asset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
RANBWAAsset Transaction Type ANBWACHAR3TABWBWASL
RPARTNPartner account number JV_PARTCHAR10KNA1ALPHAKUNNR
NPLNRNetwork Number for Account Assignment NPLNRCHAR12AUFKALPHAAUFNRNET
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLGeneral counter for order APLZL_CHNUMC8Assigned to domainCO_APLZL
VORNROperation/Activity Number VORNRCHAR4NUMCVVORNRVGN
RBILIDPayroll Type JV_BILINDCHAR2T8JAALPHAJV_BILIND
RDPOMPosting Period Difference for Operational Month JV_DPOMCHAR4CHAR4
RDBILLMInvoice Month: Posting Period Difference JV_DBILLMCHAR4CHAR4
RZZPROJKWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
RZZCOAREAControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
RZZREGION 0Assigned to domain
SZZREGION 0Assigned to domain
RZZBUSPARTN 0
RZZPRODUCT 0
RZZLOCA 0
RZZCHAN 0
RZZPRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
RZZAUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
RZZHKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
RMATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
RZZLOB 0Assigned to domain
SMATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
SZZLOB 0Assigned to domain
RZZUSER1 0
RZZUSER2 0
RZZUSER3 0
RZZSTATE 0Assigned to domain
RZZREG 0
RZZFKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
SZZUSER1 0
SZZUSER2 0
SZZUSER3 0
SZZSTATE 0Assigned to domain
SZZREG 0
RZSPREG 0Assigned to domain
SZSPREG 0Assigned to domain
REFDOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
REFRYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
REFDOCLNSix-figure number of line item BUZEI6NUMC6BUZEI6BUZ
REFDOCCTDocument Type DOCCTCHAR1DOCCTGCT
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
CSPREDDistribution key for currency amounts CSPREDCHAR4T821SSPREDGSP
QSPREDDistribution key for quantities QSPREDCHAR4T821SSPREDGSP
DISTKEYDistribution keys FM_DISTKEYCHAR4FM_DISTKEY
TSLValue in Transaction Currency VTCUR12CURR23(2) WERTV12
HSLValue in Local Currency VLCUR12CURR23(2) WERTV12
KSLValue in Group Currency VGCUR12CURR23(2) WERTV12
MSLQuantity QUAN1_12QUAN23(3) MENGV12
SGTXTItem Text SGTXTCHAR50TEXT50
AUTOMIndicator: Automatic posting lines AUTOMCHAR1TEXT1
BVORGNumber of Cross-Company Code Posting Transaction BVORGCHAR16BVORG
BUDATPosting Date in the Document BUDATDATS8DATUM
WSDATValue Date for Currency Translation WSDATDATS8DATUMWSD
REFACTIVBusiness Transaction GLVORCHAR4CHAR4
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
USNAMUser name USNAMCHAR12USR02XUBNAMEUSR
AWORGReference Organizational Units AWORGCHAR10AWORG
STOKZIndicator: Document Has Been Reversed CO_STOKZCHAR1FLAG
STFLGIdentifier for reversal document CO_STFLGCHAR1FLAG
ACCOUNTReconciliation Account for Reconciliation Posting RACCT_RCLCHAR10SKB1ALPHASAKNRSAK
VAL_REFDOCLNPosting Row in Operative Version VAL_REFDOCLNCHAR3DOCLN
UPDHPHighest update period UPDHPNUMC3POPER
RVSDOCNRReverse Document Number STBLGCHAR10ALPHABELNR
ORNDOCNRDocument number of reversed document STBLNCHAR10ALPHABELNR
COIACActivity for consolidation of investments FC_COIACCHAR2FC_COIACCOA
COINRConsolidation of investments activity number FC_COINRCHAR10ALPHABELNRCNR
REVYEARYear of reversal document or reversed document FC_REVYEARNUMC4GJAHRGJAHR
OSLValue in Another Currency VOCUR12CURR23(2) WERTV12
WSLValue in Original Transaction Currency (Document Currency) VWCUR12CURR23(2) WERTV12
RWCURCurrency key of the original transaction currency RWCURCUKY5TCURCWAERSFWS
BSCHLPosting Key BSCHLCHAR2TBSLBSCHL
BSTATDocument Status BSTAT_DCHAR1BSTAT
LINETYPEItem category LINETYPECHAR5T8G02LINETYPE
XSPLITMODItem changed by document splitting XSPLITMODCHAR1XFELD
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DOCDTDocument Date in Document BLDATDATS8DATUM
REFNRReference Number FB_ICRC_REFNRCHAR30CHAR30LOW
GRREFDocument Group Number FB_ICRC_GROUPREFCHAR18ALPHAFB_ICRC_GROUPREF
PSTATProcessing Status FB_ICRC_PSTATNUMC3NUMC3
CSTATCommunication Status FB_ICRC_CSTATNUMC3NUMC3
OSIRIDRecord number of the line item record GU_RECIDCHAR18OBJNROBN
FAGL_RCLNTClient MANDTCLNT3Assigned to domainMANDT
FAGL_RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
FAGL_DOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
FAGL_RLDNRLedger RLDNRCHAR2Assigned to domainALPHARLDNRGLNH_T881
FAGL_RBUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
FAGL_DOCLNSix-Character Posting Item for Ledger DOCLN6CHAR6DOCLN6
ASLAdditional Quantity QUAN2_12QUAN23(3) MENGV12
AUNITAdditional unit of measure AUNITUNIT3T006CUNITMEINS
CTEM_CATEGORY_9Commitment Item Category FM_POTYPNUMC1FM_POTYP
TECHORG_9Original Application BUKU_TECHORGCHAR10Assigned to domainBUKU_TECHORG
PFONDSPartner Fund FM_PFUNDCHAR10Assigned to domainBP_GEBERPARTNER_FUND
BLDATDocument Date in Document BLDATDATS8DATUM
PMT_OFFICEPayment Office FMFG_PMT_OFFCHAR5Assigned to domainFMFG_PMT_OFFFMFG_PMT_OFFICE
COHORTReporting Year for Cohort FM_COHORTCHAR4FM_COHORT
PUBLAWPublic Law Cited FM_PUBLAWCHAR20FM_PUBLAW
LEGISType of Legislation FM_LEGISCHAR1FM_LEGIS
FLG_COVEREDCovered Indicator FM_FLG_COVEREDCHAR1FM_FLG_COVERED
FLG_CUSTODIALCustodial Indicator FM_FLG_CUSTODIALCHAR1FM_FLG_CUSTODIAL
FLG_ENTITYEntity Indicator FM_FLG_ENTITYCHAR1FM_FLG_ENTITY
FLG_EXCHANGEExchange Indicator FM_FLG_EXCHANGECHAR1FM_FLG_EXCHANGE
FLG_FEDERALFederal/Nonfederal Code FM_FLG_FEDERALCHAR1FM_FLG_FEDERAL
FLG_APPORTApportionment Category FM_FLG_APPORTCHAR1FM_FLG_APPORT
FLG_AVAILAvailability Time FM_FLG_AVAILCHAR1FM_FLG_AVAIL
FLG_BORROWBorrowing Source FM_FLG_BORROWCHAR1FM_FLG_BORROW
FLG_DEFINITEDefinite/Indef indicator FM_FLG_DEFINITECHAR1FM_FLG_DEFINITE
FLG_PARTNERTransaction Partner FM_FLG_PARTNERCHAR1FM_FLG_PARTNER
FLG_REIMBURReimbursable FM_FLG_REIMBURCHAR1FM_FLG_REIMBUR
FLG_AUTHORAuthority Type FM_FLG_AUTHORCHAR1FM_FLG_AUTHOR
FLG_BEABudget Enforcement Act Category FM_FLG_BEACHAR1FM_FLG_BEA
BUREAUFederal Bureau FM_BUREAUCHAR2FM_BUREAU
BUSINESS_LINEBusiness Line FM_BUSINESS_LINECHAR2FM_BUSINESS_LINE
FGDPRTMNTFederal Department FM_DEPARTMENTCHAR2FM_DEPARTMENT
FGDPRTMNT_PARTFederal Department Partner FM_DEPARTMENT_PARTNERCHAR2FM_DEPARTMENT
FUND_ACC_SYMBLTreasury Account Symbol - Main Account FM_MAIN_ACCTCHAR4FM_MAIN_ACCT
AWIDReference document: Current identification AWIDCHAR10AWID
FUND_TYPEFM Fund Type FM_FUNDTYPECHAR6Assigned to domainFM_FUNDTYPE
FM_AREAFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
CO_AREAControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
SGL_ACCOUNTStandard General Ledger Account for US Federal Government FM_SGL_ACCOUNTCHAR6FM_SGL_ACCOUNTSGL_ACCOUNTFMFG_SGL_ACCOUNT
BDGT_FUNC_CLSSClassification of Data According to Major Purpose FM_BDGT_FUNC_CLSSCHAR3CHAR3
FMCMMTSTR_9FM Commitment String For Budgetary Ledger FMCMMTSTRCHAR62FMCMMTSTR
TRANSFER_AGCY_9Transfer Agency FMFG_TRANSFER_AGCYCHAR2Assigned to domainFMFG_TRANSFER
TRANSFER_ACCT_9Transfer Account FMFG_TRANSFER_ACCTCHAR4Assigned to domainFMFG_TRAN_ACCT
YEAR_BDGT_AUTH_9Year of Budget Authority FMFG_YR_BUD_AUTHCHAR4FMFG_YR_BUD_AUTH
FLG_ADVANCE_9Advanced Flag FM_FLG_ADVANCECHAR1FMFG_FLG_ADVANCE
DEFENSE_INDIC_9Defense Indicator FMFG_DEFENSE_INDICATORCHAR3FMFG_DEFENSE_INDICATOR
MEASUREFunded Program FM_MEASURECHAR24FMMEASUREFM_MEASUREFM_MEASURE
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
PROG_REPT_CAT_9Program Reporting Category FMFG_PROGRAM_REPORT_CATEGORYCHAR3FMFG_PROGRAM_REPORT_CATEGORY
ASSETMAINO_9Main Asset Number BF_ANLN1CHAR12ALPHABF_ANLN1AN1
ASSETSUBNO_9Asset Subnumber BF_ANLN2CHAR4ALPHABF_ANLN2AN2
MOVEMENTTYPE_9Asset Transaction Type ANBWACHAR3Assigned to domainBWASL
ASSET_ACQDATE_9Asset value date BZDATDATS8DATUM
NPLNR_9Network Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
APLZL_9Internal counter CIM_COUNTNUMC8CIM_COUNT
AUFPL_9Routing number of operations in the order CO_AUFPLNUMC10AUFPL
PRZNR_9Business Process CO_PRZNRCHAR12Assigned to domainALPHACO_PRZNRKWP
IMKEY_9Internal Key for Real Estate Object IMKEYCHAR8IMKEY
INTRENO_9Internal Real Estate Master Data Code VVINTRENOCHAR13VVINTRENO
APPOR_CATB_DTL_9Apportionment Category B Program Code FMFG_APPORTDTLCHAR4
BDGT_IMPACT_9Budgetary Impact FMFG_BDGT_IMPACTCHAR1FMFG_BDGT_IMPACT
FLG_PYA_9Prior Year Adjustment Code FMFG_FLG_PYACHAR1FMFG_FLG_PYA
PROGRAM_IND_9Program FMFG_PROGRAM_INDCHAR1FMFG_PROGRAM_IND
TP_SUBLEVL_9Sublevel Prefix (SP) for Trading Partner FMFG_TP_SUBLEVLCHAR2FMFG_SUBLEVL
TP_AGENCID_9Agency Identifier (AID) for Trading Partner FMFG_TP_AGENCIDCHAR3FMFG_AGENCID
TP_ALTRAID_9Allocation Transfer Agency Identifier (ATA) Trading Partner FMFG_TP_ALTRAIDCHAR3FMFG_ALTRAID
TP_BEGPER_9Beginning Period of Availability (BPOA) for Trading Partner FMFG_TP_BEGPERNUMC4GJAHRFMFG_BEGPER
TP_ENDPER_9Ending Period of Availability (EPOA) for Trading Partner FMFG_TP_ENDPERNUMC4GJAHRFMFG_ENDPER
TP_AVTYPE_9Availability Type Code (A) for Trading Partner FMFG_TP_AVTYPECHAR1FMFG_AVTYPE
TP_MAIN_ACCT_9Main Account for Trading Partner FMFG_TP_MAIN_ACCTCHAR4
TP_SUB_ACCT_9Subaccount for Trading Partner FMFG_TP_SUB_ACCTCHAR3
BETC_9Business Event Type Code FMFG_BETCCHAR10CHAR10
TP_BETC_9Business Event Type Code for Trading Partner FMFG_TP_BETCCHAR10
TREASURY_OFFS_9Treasury Offset Program Eligibility FMFG_TREASURY_OFFSETCHAR1
GARNISHMENT_9Garnishment FMFG_GARNISHMENTCHAR1
SUBLEVL_9Sublevel Prefix (SP) FMFG_SUBLEVLCHAR2FMFG_SUBLEVL
AGENCID_9Agency Identifier (AID) FMFG_AGENCIDCHAR3FMFG_AGENCID
ALTRAID_9Allocation Transfer Agency Identifier (ATA) FMFG_ALTRAIDCHAR3FMFG_ALTRAID
BEGPER_9Beginning Period of Availability (BPOA) FMFG_BEGPERNUMC4GJAHRFMFG_BEGPER
ENDPER_9Ending Period of Availability (EPOA) FMFG_ENDPERNUMC4GJAHRFMFG_ENDPER
AVTYPE_9Availability Type Code (A) FMFG_AVTYPECHAR1FMFG_AVTYPE
SUB_ACCT_9Treasury Account Symbol - Subaccount FM_SUB_ACCTCHAR3FM_SUB_ACCT
ULDNROriginal ledger ULDNRCHAR2T881ALPHARLDNRGLN
URCTYOriginal record type URCTYCHAR1RRCTY
UVERSOriginal version UUVERSCHAR3Assigned to domainALPHARVERSGVS
UDRCRKOriginal debit/credit indicator USHKZGCHAR1SHKZG
UBUKRSOriginal company code UBUKRSCHAR4T001BUKRS
UACCTOriginal account number UACCTCHAR10Assigned to domainALPHASAKNR
UBUSAOriginal business area UGSBERCHAR4TGSBGSBERGSB
UFAREASource Functional Area UFKBERCHAR16TFKBFKBERFBE
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
LSTARActivity Type LSTARCHAR6CSLALSTARLARLART_EMPTY
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
BWKEYValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
KSTRGCost Object KSTRGCHAR12Assigned to domainKSTRGKTR
ERKRSOperating concern ERKRSCHAR4Assigned to domainERKRSERB
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PASUBNRProfitability segment changes (CO-PA) RKESUBNRNUMC4RKESUBNR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
KDAUFSales Order Number KDAUFCHAR10Assigned to domainALPHAVBELNAUN
KDPOSItem Number in Sales Order KDPOSNUMC6NUM06KPO
FKARTBilling Type FKARTCHAR4Assigned to domainFKART
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
AUBELSales Document VBELN_VACHAR10Assigned to domainALPHAVBELNAUN
AUPOSSales Document Item POSNR_VANUMC6Assigned to domainPOSNRAPO
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
ALEBNALE: PCA document number in system where created PCA_ALEBNCHAR10ALPHABELNR
AWSYSLogical system of source document AWSYSCHAR10Assigned to domainALPHALOGSYS
GRTYPStatistical Key Figure Category GRTYPCHAR1GRTYP
CO_PRZNRBusiness Process CO_PRZNRCHAR12CBPRALPHACO_PRZNRKWP
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
DABRZReference Date for Settlement DABRBEZDATS8DDAT
VALUTValue date VALUTDATS8DATUM
AWREF_REVReversal: Reverse Document Reference Document Number AWREF_REVCHAR10ALPHAAWREF
AWORG_REVReversal: Reverse Document Reference Organization AWORG_REVCHAR10AWORG
BWARTMovement Type (Inventory Management) BWARTCHAR3Assigned to domainBWARTBWA
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
REFDOC_DETAILReference Key AWKEYCHAR20AWKEY
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
COSTCENTERCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
ORDERIDOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
WBS_ELEMENTWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
PROFIT_CTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
ASSETMAINOMain Asset Number BF_ANLN1CHAR12ALPHABF_ANLN1AN1
ASSETSUBNOAsset Subnumber BF_ANLN2CHAR4ALPHABF_ANLN2AN2
MATERIALMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
BUS_AREABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
FUNDS_CTRFunds Center FISTLCHAR16Assigned to domainFISTLFIS
CMMT_ITEMCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
NETWORKNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
ROUTING_NORouting number of operations in the order CO_AUFPLNUMC10AUFPL
COUNTER_9Internal counter CIM_COUNTNUMC8CIM_COUNT
OBJ_ORG_PReference Organizational Units AWORGCHAR10AWORG
OBJ_TYP_PPrevious document: Reference procedure AWTYP_PRECHAR5Assigned to domainAWTYP
OBJ_KEY_PPrevious document: Object key (AWREF_REV and AWORG_REV) AWKEY_PRECHAR20AWKEY
OBJ_POS_PPrevious document: Reference line item AWPOS_PRECHAR10AWPOS
BILLING_STATUSBilling Status for Item GM_BILLING_STATUSCHAR1GM_BILLING_STATUS
ERLKZCompletion Indicator for Line Item GM_ERLKZCHAR1CHAR1_X
LOEKZDeletion Indicator GM_LOEKZCHAR1CHAR1_X
BILLING_BLOCK_9Billing Block Flag for an Item GM_BILLING_BLOCKCHAR1GM_BILLING_BLOCK
DOC_ORIGIN_9Document's Technical Origin GM_TECHORGCHAR1GM_TECHORG
WBS_SHORT_9Work Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
REFFIDLNNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BILIDPayroll Type JV_BILINDCHAR2T8JAALPHAJV_BILIND
ORECIDOriginal Recovery Indicator JV_ORECIDCHAR2T8JJALPHAJV_RECIND
BILLMBilling Month JV_BILLMDATS8DATUM
POMProcessing operational month JV_POMDATS8DATUM
CBPERIODJV Cutback Period JV_CBPERINUMC3POPER
KTOSLTransaction Key KTOSLCHAR3CHAR3
MMACTJVA MM Activity Type JV_MM_ACTCHAR1JV_MM_ACT
CYCLEAllocation/cycle CYCLECHAR10CYCLEGCY
SDATEStart Date SDATEDATS8Assigned to domainSDATEGAS
SEQNAMEName of a segment in assessment/distribution SEQNAMECHAR10SEQNAMEFSR
REFCYCReference Field for Allocation Cycle JV_REFCYCCHAR10TEXT10
CONDIJoint Venture Indicator (Condition Key) JV_CONDCODCHAR2T8JXALPHAJV_CONDCOD
REFAWTYPReference Transaction AWTYPCHAR5TTYPAWTYP
REFAWREFReference Document Number AWREFCHAR10ALPHAAWREF
REFAWORGReference Organizational Units AWORGCHAR10AWORG
REFLOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
PRODPERProduction Month (Date to find period and year) JV_PRODPERDATS8JV_PRODPER
REFFIDOCAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
CBCUSTOMERCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
CBVENDORAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
CBPAYTERMTerms of Payment Key DZTERMCHAR4ZTERM
XSBLFlag: Line is Split Basis Line JV_XSBLINECHAR1XFELD
SBREFLNReference Split Basis Line Number JV_SBREFLNNUMC5JV_SBREFLN
LCURRCurrency key of currency 2 CURR1CUKY5TCURCWAERSFWS
GCURRCurrency key of currency 3 CURR2CUKY5TCURCWAERSFWS
OCURRCurrency key of currency 4 CURR3CUKY5TCURCWAERSFWS
JVA_KSLValue in group currency VGCURCURR15(2) WERTV8
JVA_KSL1Value in group currency VGCURCURR15(2) WERTV8
JVA_CURRCurrency key of the ledger currency GCURRCUKY5TCURCWAERSFWS
JVA_CURR1Currency key of the ledger currency GCURRCUKY5TCURCWAERSFWS
TYPESingle-Character Indicator CHAR1CHAR1CHAR1
MAXPERPeriod PERIODENUMC3NUM3GFP
PERIOPeriod/year JAHRPERNUMC7PERI7JAHRPER
WERTBValue: Balance Sheet Accounts RR_WERTBCURR17(2) WERTV9
WERTEValue: P&L Accounts RR_WERTECURR17(2) WERTV9
UMSAVBalance Carryforward RR_UMSAVCURR17(2) WERTV9
UMSOLTotal debit postings RR_UMSOLCURR17(2) WERTV9
UMHABTotal credit postings RR_UMHABCURR17(2) WERTV9
UMPERPeriod balance RR_UMPERCURR17(2) WERTV9
KUMSLAccumulated balance RR_KUMSLCURR17(2) WERTV9
MENGPQuantity for period RR_MENGPQUAN15(3) MENGV8
MENGKCumulative quantity RR_MENGKQUAN15(3) MENGV8
ADB_WERTBValue: Balance Sheet Accounts RR_WERTBCURR17(2) WERTV9
ADB_WERTEValue: P&L Accounts RR_WERTECURR17(2) WERTV9
ADB_KUMSLAverage Daily Balance: Cumulated ADB_KUMSLCURR17(2) WERTV9
ADB_UMPERAverage Daily Balance of Period ADB_UMPERCURR17(2) WERTV9

Key field Non-key field



How do I retrieve data from SAP structure GLU3 using ABAP code?

As GLU3 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on GLU3 as there is no data to select.

How to access SAP table GLU3

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