GMRBIL SAP (GM report structure for billing list) Structure details

Dictionary Type: Structure
Description: GM report structure for billing list




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




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

GMRBIL 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 "GM report structure for billing list" 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_GMRBIL TYPE GMRBIL.

The GMRBIL table consists of various fields, each holding specific information or linking keys about GM report structure for billing list data available in SAP. These include SPONSORED_PROG (Sponsored Program), SPONSORED_CLASS (Sponsored Class), FUND (Fund), BUDAT (Posting Date in the Document).. 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 GMRBIL 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
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
SPONSORED_PROGSponsored Program GM_SPONSORED_PROGCHAR20Assigned to domainGM_SPONSORED_PROGGM_SPONSORED_PROG
SPONSORED_CLASSSponsored Class GM_SPONSORED_CLASSCHAR20Assigned to domainGM_SPONSORED_CLASSGM_SPONSORED_CLASS
FUNDFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
BUDATPosting Date in the Document BUDATDATS8DATUM
GL_SIRIDRecord number of the line item record GU_RECIDCHAR18OBJNROBN
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
RTCURCurrency Key RTCURCUKY5TCURCWAERSFWS
POPERPosting period POPERNUMC3POPERPOPR
DOCCTDocument Type DOCCTCHAR1DOCCTGCT
DOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DOCLNSix-Character Posting Item for Ledger DOCLN6CHAR6DOCLN6
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
BDGT_VLDTY_NBRBudget Validity Number GM_BDGT_VLDTY_NBRCHAR3GM_BDGT_VLDTY_NBR
VALUETYPEGM Value Type GM_VALUETYPECHAR2GM_VALUETYPEGMVALUETYPE
RTRANSBusiness Transaction J_VORGANGCHAR4Assigned to domainJ_VORGANG
RSTATS_INDStatistical Indicator GM_STATSCHAR1GM_STATS
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
BDGT_STATEWorkflow State of a Record in the Budget Totals Table GM_BDGT_STATECHAR1GM_BDGT_STATE
TSLGM Amount in Grant Currency GM_AMT_TSLCURR17(2) WERTV9
HSLGM Amount in Company Code Currency GM_AMT_HSLCURR17(2) WERTV9
SGTXTItem Text SGTXTCHAR50TEXT50
DOCTYFI-SL Document Type DOCTYCHAR2T889DOCTYBAR
ACTIVBusiness Transaction GLVORCHAR4CHAR4
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
REFDOC_DETAILReference Key AWKEYCHAR20AWKEY
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
AWTYPReference Transaction AWTYPCHAR5TTYPAWTYP
AWORGReference Organizational Units AWORGCHAR10AWORG
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
CO_AREAControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
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
FM_AREAFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
BUS_AREABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
FUNDS_CTRFunds Center FISTLCHAR16Assigned to domainFISTLFIS
CMMT_ITEMCommitment Item FM_FIPEXCHAR24Assigned to domainFM_FIPEXFPS
FAREAFunctional Area FM_FAREACHAR16Assigned to domainFKBERFBE
MEASUREFunded Program FM_MEASURECHAR24Assigned to domainFM_MEASUREFM_MEASURE
NETWORKNetwork Number for Account Assignment NPLNRCHAR12Assigned to domainALPHAAUFNRNET
ROUTING_NORouting number of operations in the order CO_AUFPLNUMC10AUFPL
COUNTERInternal 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
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
LINETYPEItem category LINETYPECHAR5Assigned to domainLINETYPE
XSPLITMODItem changed by document splitting XSPLITMODCHAR1XFELD
BILLING_STATUSBilling Status for Item GM_BILLING_STATUSCHAR1GM_BILLING_STATUS
ERLKZCompletion Indicator for Line Item GM_ERLKZCHAR1CHAR1_X
LOEKZDeletion Indicator GM_LOEKZCHAR1CHAR1_X
EXPENSELINEGM Specifies the Expense Line GM_EXPENSELINECHAR1FLAG
EXPENSEDOCGM Expense Document Number GM_EXPENSEDOCCHAR10ALPHABELNRBLN
BILLINGDOCGM Billing Document Number GM_BILLINGDOCCHAR10ALPHABELNR
WAERSGM Company Code Currency GM_COMP_CODE_CURRENCYCUKY5Assigned to domainWAERS
AMOUNT_UNBILLEDGM Amount to be billed GM_AMOUNT_UNBILLEDCURR17(2) WERTV9
AMOUNT_BILLEDGM Amount Billed GM_AMOUNT_BILLEDCURR17(2) WERTV9
AMOUNT_SUMBILLEDGM Amount Unbilled and Billed GM_AMOUNT_SUMBILLEDCURR17(2) WERTV9
CURRENCYGM reporting currency GM_REPORTING_CURRENCYCUKY5Assigned to domainWAERSFWS
GRANT_SHORT_DESCRIPTIONName of Grant GM_GRANT_SHORT_DESCCHAR20CHAR20
SPONSORGrant Sponsor GM_SPONSORCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
SPONSOR_DESCRIPTIONSponsor Description GM_SPONSOR_DESCRIPTIONCHAR80TEXT80
COMPANY_CODE_TEXTName of Company Code or Company BUTXTCHAR25TEXT25
SPONSORED_PROG_TEXTSponsored Program Description GM_PROGRAM_TEXTCHAR30TEXT30
SPONSORED_CLASS_TEXTSponsored Class Description GM_CLASS_TEXTCHAR30TEXT30
FUND_TEXTDescription of funds FM_FUND_DESCRCHAR40TEXT40
VALUETYPE_TEXTValue Type Text GM_VALUETYPE_TXTCHAR40TEXT40
BILLING_RULERule Used as a Basis for Billing GM_BILLING_RULENUMC4Assigned to domainGM_BILLING_RULEGM_BILLING_RULE
BILLING_RULE_TEXTBilling Rule Description GM_BILLING_RULE_TXTCHAR30TEXT30
ICO_STATUSCarrier field for icons ICON_TEXTCHAR132SYCHAR132
SORTCharacter Field Length = 10 CHAR10CHAR10CHAR10
PGRANT_NBRpartner grant number GM_PARTNER_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRPARTNER_GRANTGRANTS_GENERIC
PFUNDPartner Fund FM_PFUNDCHAR10Assigned to domainBP_GEBERPARTNER_FUND
PSPONSORED_PROGPartner Sponsored Program GM_PARTNER_SPONSORED_PROGCHAR20Assigned to domainGM_SPONSORED_PROGGM_SPONSORED_PROG
PSPONSORED_CLASSPartner Sponsored Class GM_PARTNER_SPONSORED_CLASSCHAR20Assigned to domainGM_SPONSORED_CLASSGM_SPONSORED_CLASS

Key field Non-key field



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

As GMRBIL 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 GMRBIL as there is no data to select.

How to access SAP table GMRBIL

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