J_1GGL000 SAP ABAP Report - Detailed Ledger
J_1GGL000 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Legal requirement for Greece...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter J_1GGL000 into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
J1GGL - Detailed Ledger
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT J_1GGL000. "Basic submit
SUBMIT J_1GGL000 AND RETURN. "Return to original report after report execution complete
SUBMIT J_1GGL000 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: S_2CURR = Use 2nd local currency
Selection Text: S_ALTK = Alternative account number
Selection Text: S_BUDAT = Posting date
Selection Text: S_DIFF = 2nd acc.system
Selection Text: S_GSBER = Business area
Selection Text: S_JOIN = Join affiliated accounts
Selection Text: S_LEDSEL = Type of Accounting
Selection Text: S_MAIN = 1st acc.system (main)
Selection Text: S_NONPOS = Include accounts not posted to
Selection Text: S_RLDNR = Ledger
Selection Text: S_RPRADD = Add pr.year bal. to totals
Selection Text: S_RPREVD = Include previous dates sum
Selection Text: S_RPREVY = Include previous year balance
Selection Text: S_SXBLNR = Show sums on reference doc.
Selection Text: S_TCURR = Show amounts in transact.curr.
Selection Text: S_XBLNR = Show only the sums
Selection Text: S_XTITLE = Additional heading
Title: Detailed Ledger
Text Symbol: P13 = DETAILED LEDGER
Text Symbol: P12 = DETAILED A/L LEDGER
Text Symbol: P11 = DETAILED G/L LEDGER
Text Symbol: P04 = REPORTING PERIOD:
Text Symbol: M29 = Results are displayed in the primary chart
Text Symbol: M28 = 2nd local currency not defined in customizing
Text Symbol: M27 = No country Ch. of Acc. defined for comp.
Text Symbol: M26 = Error in Ch. of Acc. structure (table J_1GGS), for
Text Symbol: M25 = Company $ will be excluded:
Text Symbol: M18 = All companies must use the same F.Y.Variant
Text Symbol: M06 = (for account balances)
Text Symbol: M05 = User settings require reading balances from GLT0.
Text Symbol: M04 = NewGL related selections will be ignored...
Text Symbol: 200 = PREVIOUS YEAR BALANCE C/F
Text Symbol: 201 = TOTALS OF PREVIOUS DATES
Text Symbol: 202 = CURRENT ACCOUNT TOTALS
Text Symbol: 203 = PAGE TOTALS
Text Symbol: 204 = COMPANY TOTALS
Text Symbol: 205 = BROUGHT FORWARD
Text Symbol: 206 = CARRY FORWARD
Text Symbol: 207 = GRAND TOTALS
Text Symbol: 600 = ACCOUNT:
Text Symbol: B10 = Further selections
Text Symbol: B11 = Reporting period
Text Symbol: B12 = Accounting systems
Text Symbol: B20 = Control options
Text Symbol: H01 = POST.DATE
Text Symbol: H02 = REFERENCE.NR.
Text Symbol: H03 = DOC.NR.
Text Symbol: H04 = DOCUMENT ITEM TEXT
Text Symbol: H05 = PK
Text Symbol: H06 = DEBIT
Text Symbol: H07 = CREDIT
Text Symbol: H08 = BALANCE
Text Symbol: H09 = DEBIT TR.CURR
Text Symbol: H10 = CREDIT TR.CURR
Text Symbol: H11 = BALANCE TR.CURR
Text Symbol: H12 = CURR
Text Symbol: H13 = COST CENT.
Text Symbol: IS1 = Choose at least one accounting system
Text Symbol: M00 = Internal error!
Text Symbol: M01 = Posting date is not allowed in dynamic selections, and it will be ignored...
Text Symbol: M03 = NewGL is not active.
INCLUDES used within this REPORT J_1GGL000
INCLUDE J_2GCONSTANTS.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
FAGL_GET_GLT0_SETTING call function 'FAGL_GET_GLT0_SETTING' importing ed_read_glt0_user = gf_read_glt0_user.
FAGL_CHECK_IF_LEDGER_IS_GLFLEX call function 'FAGL_CHECK_IF_LEDGER_IS_GLFLEX' exporting i_rldnr = s_rldnr.
J_2GPOPUP_SELLIST call function 'J_2GPOPUP_SELLIST' exporting t_dynsl = gs_dsel-trange[].
DATE_TO_PERIOD_CONVERT call function 'DATE_TO_PERIOD_CONVERT' exporting i_date = l_date * I_MONMIT = 00 i_periv = g_periv importing * E_BUPER = e_gjahr = l_gjahr exceptions input_false = 1 t009_notfound = 2 t009b_notfound = 3 others = 4.
DATE_TO_PERIOD_CONVERT call function 'DATE_TO_PERIOD_CONVERT' exporting i_date = s_budat-low * I_MONMIT = 00 i_periv = g_periv importing e_buper = l_buper e_gjahr = l_gjahr.
FIRST_DAY_IN_PERIOD_GET call function 'FIRST_DAY_IN_PERIOD_GET' exporting i_gjahr = l_gjahr * I_MONMIT = 00 i_periv = g_periv i_poper = l_buper importing e_date = l_date.
call function 'FAGL_GET_GLT0' exporting i_glt0_rldnr = '00' i_rldnr = g_relevant_ledger i_rrcty = '0' i_rvers = '001' i_bukrs = p_bukrs i_ryear = g_gjahr i_racct = p_selection_acct i_range_rbusa = lt_range_gsber i_range_rtcur = lt_range_rtcur it_where_clause = gt_faglfreesel_where importing et_glt0 = lt_glt0.
J_1GWRITE_ACC call function 'J_1GWRITE_ACC' exporting i_ktopl = gt_ci-cofa i_account = gt_ai-dacct importing e_accsl = ls_hkont-sakan.
FI_COMPANY_CODE_DATA call function 'FI_COMPANY_CODE_DATA' exporting i_bukrs = l_bukrs importing e_t001 = t001 exceptions system_error = 1 others = 2.
DATE_TO_PERIOD_CONVERT call function 'DATE_TO_PERIOD_CONVERT' exporting i_date = sy-datum i_periv = t001-periv importing e_buper = l_buper e_gjahr = l_gjahr exceptions input_false = 1 t009_notfound = 2 t009b_notfound = 3 others = 4.
FIRST_DAY_IN_PERIOD_GET call function 'FIRST_DAY_IN_PERIOD_GET' exporting i_gjahr = l_gjahr * I_MONMIT = 00 i_periv = t001-periv i_poper = l_buper importing e_date = l_fdate.
LAST_DAY_IN_PERIOD_GET call function 'LAST_DAY_IN_PERIOD_GET' exporting i_gjahr = l_gjahr * I_MONMIT = 00 i_periv = t001-periv i_poper = l_buper importing e_date = l_ldate.
J_1GGET_STRUCTURE call function 'J_1GGET_STRUCTURE' exporting i_ktopl = gt_ci-cofa exceptions gs_no_data = 1 gs_wrong_data = 2 others = 3.
G_GET_ORGANIZATIONAL_DATA call function 'G_GET_ORGANIZATIONAL_DATA' exporting i_rldnr = g_relevant_ledger i_orgunit = t001-bukrs importing organizational_info = gt_ci-glxi exceptions no_info_found = 1 error_in_setup = 2 error_in_depld = 3 others = 4.
FREE_SELECTIONS_RANGE_2_WHERE call function 'FREE_SELECTIONS_RANGE_2_WHERE' exporting field_ranges = lt_trange importing where_clauses = lt_clauses.
FREE_SELECTIONS_RANGE_2_WHERE call function 'FREE_SELECTIONS_RANGE_2_WHERE' exporting field_ranges = gs_dsel-trange importing where_clauses = gs_dsel-clauses.
FREE_SELECTIONS_RANGE_2_EX call function 'FREE_SELECTIONS_RANGE_2_EX' exporting field_ranges = gs_dsel-trange importing expressions = gs_dsel-texpr.
FAGL_GET_ITEMS_BSIS call function 'FAGL_GET_ITEMS_BSIS' exporting i_selection = gt_selection_full * I_FIELDLIST = * I_BLOCKSIZE = * I_BLOCK_DATA = GUSL_C_FALSE * I_AGGREGATION = GUSL_C_FALSE i_read_bseg = lf_read_bseg * I_MAX_LINES = * IMPORTING * FLAG_CURSOR_OPEN = changing c_t_faglpose = lt_items.
FAGL_GET_ITEMS_BSAS call function 'FAGL_GET_ITEMS_BSAS' exporting i_selection = gt_selection_full * I_FIELDLIST = * I_BLOCKSIZE = * I_BLOCK_DATA = GUSL_C_FALSE * I_AGGREGATION = GUSL_C_FALSE i_read_bseg = lf_read_bseg * I_MAX_LINES = * IMPORTING * FLAG_CURSOR_OPEN = changing c_t_faglpose = lt_items.
FAGL_GET_ITEMS_BSEG call function 'FAGL_GET_ITEMS_BSEG' exporting i_selection = gt_selection_full * I_FIELDLIST = * I_BLOCKSIZE = * I_BLOCK_DATA = GUSL_C_FALSE * I_AGGREGATION = GUSL_C_FALSE * I_MAX_LINES = * IMPORTING * FLAG_CURSOR_OPEN = changing c_t_faglpose = lt_items.
J_1GGSBER_AUTH_CHECK call function 'J_1GGSBER_AUTH_CHECK' exporting i_gsber = p_gsber i_aktvt = '03' exceptions no_authorization = 1 others = 2.
FAGL_AUTHORITY_SEGMENT call function 'FAGL_AUTHORITY_SEGMENT' exporting i_segment = p_segment i_actvt = '03' exceptions no_authority_segment = 1 others = 3.
POSTING_KEY_TEXT_GET call function 'POSTING_KEY_TEXT_GET' exporting * I_LANGU = SY-LANGU i_bschl = p_bschl i_umskz = p_umskz importing e_ltext = l_ltext exceptions text_not_found = 1 others = 2.
READ_HAUPTBUCH_TEXT call function 'READ_HAUPTBUCH_TEXT' exporting kontenplan = gt_ai-cofa sachkonto = gt_ai-dacct sprache = sy-langu importing text_wa = lwskat exceptions text_not_found = 1 others = 2.
RS_SET_SELSCREEN_STATUS call function 'RS_SET_SELSCREEN_STATUS' exporting p_status = '%_00' tables p_exclude = lt_exclude.
J_1GCHECK_DAGRP call function 'J_1GCHECK_DAGRP' exporting i_ktopl = ska1-ktopl i_ktoks = ska1-ktoks importing e_dagrp = l_dflag.
J_1GGET_MACCT call function 'J_1GGET_MACCT' exporting i_ktopl = ska1-ktopl i_bukrs = skb1-bukrs i_dacct = skb1-saknr importing e_macct = l_macct exceptions not_mapped = 1 others = 2.
J_1GGET_TYPE call function 'J_1GGET_TYPE' exporting i_ktopl = gt_ci-cofa i_account = ps_ai-dacct i_only_type = s_ledsel importing e_type = ps_ai-ltype.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name J_1GGL000 or its description.