SAP Reports / Programs
RGJVBE01 SAP ABAP Report - Billing data selection: Invoice / Statement
RGJVBE01 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The Billing extract program (invoice/statement) extracts the required data from the billing ledger to be used for the creation of an invoice and statement for hardcopy and for EDI...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 RGJVBE01 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
GJ12 - Billing Ledger Extract
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 RGJVBE01. "Basic submit
SUBMIT RGJVBE01 AND RETURN. "Return to original report after report execution complete
SUBMIT RGJVBE01 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: P_ABEND = Cancel if cutback not complete
Selection Text: P_ACTIVE = Only allow active equity group
Selection Text: P_EVENT = Chk compl status in event tabl
Selection Text: P_PERIOD = Accounting period
Selection Text: P_TEST = Test run
Selection Text: P_YEAR = Fiscal year
Selection Text: S_PARTNR = D .
Selection Text: S_VENTRE = D .
Selection Text: S_BUKRS = Company Codes
Title: Billing data selection: Invoice / Statement
Text Symbol: 069 = Suspense
Text Symbol: 068 = Equity groups in suspense
Text Symbol: 067 = Statem. (zero)
Text Symbol: 066 = Statement
Text Symbol: 064 = Statement data selected with error
Text Symbol: 062 = Error
Text Symbol: 065 = Statement data selected without error
Text Symbol: 070 = Unsusp.
Text Symbol: 071 = Partner in suspense
Text Symbol: 075 = In company code
Text Symbol: 080 = Suspended partner:
Text Symbol: 100 = Billing extract (invoice) for
Text Symbol: 101 = Billing extract (invoice/statement) for company
Text Symbol: 102 = and period
Text Symbol: 144 = Group C.(4B):
Text Symbol: 145 = Local C.(4D):
Text Symbol: 146 = Group C.(4D):
Text Symbol: 200 = Errors for Billing extract (Iv/st)
Text Symbol: 201 = INV_EXTRACT
Text Symbol: 202 = INV_ERRORS
Text Symbol: 203 = end of processing
Text Symbol: 302 = Venture
Text Symbol: 303 = Equity group
Text Symbol: 306 = Company
Text Symbol: ETP = ETp
Text Symbol: FRM = from
Text Symbol: HOF = Multiple branches within an equity group for head office
Text Symbol: ITD = Inception to date
Text Symbol: NOS = none
Text Symbol: PTD = Current period
Text Symbol: SP0 = Spool file handling
Text Symbol: SP1 = One spool for all companies
Text Symbol: SP2 = One spool for each company
Text Symbol: SP3 = One spool for each venture
Text Symbol: SUS = Partner in suspense
Text Symbol: TOS = to
Text Symbol: YTD = Year to date
Text Symbol: 029 = Brought Forward Amount
Text Symbol: 028 = No billing data for this Equity Group - zero balances extracted.
Text Symbol: 027 = Invoice not Exported - Zero Amount - for:
Text Symbol: 026 = Statement Information Exported for: Eq. Group Funding Currency.
Text Symbol: 025 = No
Text Symbol: 022 = Statement data (hardcopy)
Text Symbol: 021 = Amount
Text Symbol: 020 = Curr.
Text Symbol: 019 = BI
Text Symbol: 018 = Funding Currency:
Text Symbol: 017 = Invoice data (hardcopy)
Text Symbol: 016 = No suspended Equity Groups or Partners in Venture
Text Symbol: 015 = in Equity Group
Text Symbol: 014 = Partner
Text Symbol: 013 = Suspended
Text Symbol: 012 = Equity Group
Text Symbol: 011 = Equity Group and Partner Suspense Reporting
Text Symbol: 009 = Period
Text Symbol: 005 = Processing options
Text Symbol: 004 = Billing period
Text Symbol: 003 = Selection criteria
Text Symbol: 002 = BILLING LEDGER EXTRACT DETAIL REPORT
Text Symbol: 001 = BILLING LEDGER EXTRACT SUMMARY REPORT
Text Symbol: 061 = Complete
Text Symbol: 060 = Suppl. (EDI)
Text Symbol: 059 = Suppl. (Paper)
Text Symbol: 058 = Inv. (EDI)
Text Symbol: 057 = Inv. (Paper)
Text Symbol: 056 = Vent
Text Symbol: 055 = Invoice data selected without error
Text Symbol: 054 = Invoice data selected with error
Text Symbol: 053 = FCurr
Text Symbol: 052 = Statement data (zero balances only):
Text Symbol: 051 = Partner
Text Symbol: 050 = Invoice supplemental data (EDI)
Text Symbol: 049 = Invoice data (EDI)
Text Symbol: 048 = no data selected for the following ventures:
Text Symbol: 047 = Project
Text Symbol: 046 = Op.Month
Text Symbol: 045 = EqG
Text Symbol: 044 = Local C.(4B):
Text Symbol: 043 = Funding Cur.:
Text Symbol: 042 = Ln
Text Symbol: 041 = Doc.no
Text Symbol: 039 = SDS
Text Symbol: 037 = Invoice supplemental data (hardcopy)
INCLUDES used within this REPORT RGJVBE01
INCLUDE GJV_SCHEDMAN_DATA_DEFINITION.
INCLUDE RGJV_MCC_SPOOL_SELECT2.
INCLUDE RGJV_MCC_SPOOL_SELECT_INIT.
INCLUDE RKASMAWF.
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:
MESSAGES_INITIALIZE CALL FUNCTION 'MESSAGES_INITIALIZE' importing E_IDENTIFICATION = gd_message_identification .
JV_MCC_CHECK CALL FUNCTION 'JV_MCC_CHECK' EXPORTING I_TEST = p_test I_PROCESS_CODE = 'BILLING1' I_T_BUKRS = s_bukrs[] IMPORTING E_MCC_USED = w_mcc_used E_T_MCC = i_mcc * E_NOAUTH = CHANGING C_T_VENTURE = s_ventre[] C_T_PARTNER = s_partnr[] * C_T_EGROUP = * C_T_JOA = EXCEPTIONS NO_SELECTION = 1 INCONSISTENT_SELECTION = 2 OTHERS = 3 .
IS_SUBMIT_TO_SPOOL CALL FUNCTION 'IS_SUBMIT_TO_SPOOL' IMPORTING FLAG = print_status.
JV_WRITE_MESSAGE * CALL FUNCTION 'JV_WRITE_MESSAGE' * EXPORTING * SORT_ORDER = '1' * NO_CO_MESSAGE = 'X'.
KPEP_MONI_CLOSE_RECORD CALL FUNCTION 'KPEP_MONI_CLOSE_RECORD' EXPORTING ls_key = gs_key LS_MESSAGE = ls_message LS_SCMA_EVENT = ls_scma_event TABLES LT_SPOOL = lt_spool changing ld_aplstat = ld_aplstat .
KPEP_MONI_INIT_RECORD CALL FUNCTION 'KPEP_MONI_INIT_RECORD' EXPORTING ls_detail = ls_detail LS_WITEM = ls_witem * LS_APPL = * LD_WORKLIST_FLAG = ' ' * LD_DELAYED_UPDATE = ' ' IMPORTING LS_KEY = gs_key * WILL_BE_SAVED = TABLES LT_SELKRIT = lt_selkrit * LT_PARAM = .
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_NO_CO_CODE STATUS = WS_LIT_C1_STATUS_E IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
VALIDATE_YEAR CALL FUNCTION 'VALIDATE_YEAR' EXPORTING I_YEAR = P_YEAR IMPORTING E_VALID = WS_FLD_N1_VALID_YEAR EXCEPTIONS INCOMPLETE.
CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_INVALID_YEAR STATUS = WS_LIT_C1_STATUS_E IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_INVALID_YEAR STATUS = WS_LIT_C1_STATUS_E IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
VALIDATE_PERIOD CALL FUNCTION 'VALIDATE_PERIOD' EXPORTING I_PERIOD = P_PERIOD IMPORTING E_VALID = WS_FLD_N1_VALID_PERIOD EXCEPTIONS INCOMPLETE.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_INVALID_PERIOD STATUS = WS_LIT_C1_STATUS_E IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_INVALID_PERIOD STATUS = WS_LIT_C1_STATUS_E IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_NO_VENTURE STATUS = WS_LIT_C1_STATUS_E IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_NO_PARTNER STATUS = WS_LIT_C1_STATUS_E IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_NO_VEN_BFORM STATUS = WS_LIT_C1_STATUS_E VAR1 = WS_FLD_C50_VENTURE IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_NO_PAR_BFORM STATUS = WS_LIT_C1_STATUS_E VAR1 = WS_FLD_C50_PARTNER IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_HCOPY STATUS = WS_LIT_C1_STATUS_W VAR1 = P_BUKRS VAR2 = P_YEAR VAR3 = P_PERIOD IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
GET_PRINT_PARAMETERS CALL FUNCTION 'GET_PRINT_PARAMETERS' EXPORTING MODE = 'CURRENT' NO_DIALOG = 'X' DESTINATION = PRI_PARAMS1-PDEST IMMEDIATELY = ' ' NEW_LIST_ID = LS_NEW_SPOOL LAYOUT = 'X_65_132'
LIST_TEXT = LS_COVER_TEXT LINE_COUNT = 65 LINE_SIZE = 132 IMPORTING OUT_PARAMETERS = PRI_PARAMS1 VALID = VALID EXCEPTIONS OTHERS = 4.
JV_AND_FI_CURRENCIES CALL FUNCTION 'JV_AND_FI_CURRENCIES' EXPORTING BUKRS = T8JV-BUKRS IMPORTING HWAER = HWAER HWAE2 = HWAE2 HWAE3 = HWAE3 CURT1 = CURT1 CURT2 = CURT2 CURT3 = CURT3 LDNRH1 = LDNRH1 LDNRH2 = LDNRH2 LDNRH3 = LDNRH3 LDNRF1 = LDNRF1 LDNRF2 = LDNRF2 LDNRF3 = LDNRF3 EXCEPTIONS OTHERS = 1.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_LIT_C3_MSG_NO_BCURR VAR1 = T8JV-VNAME VAR2 = T8JG-EGRUP STATUS = WS_LIT_C1_STATUS_W IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
GET_PRINT_PARAMETERS CALL FUNCTION 'GET_PRINT_PARAMETERS' EXPORTING MODE = 'CURRENT' NO_DIALOG = 'X' DESTINATION = PRI_PARAMS-PDEST IMMEDIATELY = ' ' NEW_LIST_ID = 'X' LAYOUT = 'X_58_170' LIST_TEXT = 'X' LINE_COUNT = 58 LINE_SIZE = 170 IMPORTING OUT_PARAMETERS = PRI_PARAMS VALID = VALID EXCEPTIONS OTHERS = 4.
FI_DOCUMENT_RECORD CALL FUNCTION 'FI_DOCUMENT_RECORD' EXPORTING I_AWTYP = JVSO2-AWTYP I_AWREF = JVSO2-REFDOCNR I_AWORG = JVSO2-AWORG I_BUKRS = JVSO2-RBUKRS TABLES T_DOCUMENTS = INT_OR_DOCNR.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_MSGID_B0 MSGNO = WS_MSG_HEAD_OFFICE STATUS = WS_LIT_C1_STATUS_E VAR1 = WS_FLD_C50_PARTNER IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID MSGNO = WS_MSG_GENERAL STATUS = WS_LIT_C1_STATUS_E VAR1 = WS_HEAD_OFFICE_ERROR VAR2 = WS_FLD_C50_PARTNER IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_MSGID_B0 MSGNO = WS_MSG_HEAD_OFFICE STATUS = WS_LIT_C1_STATUS_E VAR1 = WS_FLD_C50_PARTNER IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
LVC_FIELDCATALOG_MERGE CALL FUNCTION 'LVC_FIELDCATALOG_MERGE' EXPORTING I_STRUCTURE_NAME = 'JVA_RGJVBE01_ALV_INV' CHANGING ct_fieldcat = lt_fcat_1[] EXCEPTIONS INCONSISTENT_INTERFACE = 1 PROGRAM_ERROR = 2 OTHERS = 3.
LVC_FIELDCATALOG_MERGE CALL FUNCTION 'LVC_FIELDCATALOG_MERGE' EXPORTING I_STRUCTURE_NAME = 'JVA_RGJVBE01_ALV_STA' CHANGING ct_fieldcat = lt_fcat_2[] EXCEPTIONS INCONSISTENT_INTERFACE = 1 PROGRAM_ERROR = 2 OTHERS = 3.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID_G5 MSGNO = WS_LIT_INCORRECT_CUTACK_STS STATUS = WS_LIT_C1_STATUS_E VAR1 = wa_t8jev-bukrs VAR2 = wa_t8jev-FYEAR VAR3 = wa_t8jev-POPER IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID_G5 MSGNO = WS_LIT_CORRECT_CUTACK_STS STATUS = 'S' VAR1 = wa_t8jev-bukrs VAR2 = wa_t8jev-FYEAR VAR3 = wa_t8jev-POPER IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
JV_COLLECT_MESSAGE CALL FUNCTION 'JV_COLLECT_MESSAGE' EXPORTING MSGID = WS_LIT_C2_MSGID_G5 MSGNO = '853' STATUS = 'W' VAR1 = wa_t8jev-bukrs VAR2 = wa_t8jev-FYEAR VAR3 = wa_t8jev-POPER IMPORTING MAX_SEVERITY = WS_FLD_C1_MAX_SEVERITY.
LVC_FIELDCATALOG_MERGE CALL FUNCTION 'LVC_FIELDCATALOG_MERGE' EXPORTING I_STRUCTURE_NAME = 'JVA_RGJVBE01_SPL_INV' CHANGING ct_fieldcat = lt_fcat101_1[] EXCEPTIONS INCONSISTENT_INTERFACE = 1 PROGRAM_ERROR = 2 OTHERS = 3.
LVC_FIELDCATALOG_MERGE CALL FUNCTION 'LVC_FIELDCATALOG_MERGE' EXPORTING I_STRUCTURE_NAME = 'JVA_RGJVBE01_SPL_STAT' CHANGING ct_fieldcat = lt_fcat101_2[] EXCEPTIONS INCONSISTENT_INTERFACE = 1 PROGRAM_ERROR = 2 OTHERS = 3.
LVC_FIELDCATALOG_MERGE CALL FUNCTION 'LVC_FIELDCATALOG_MERGE' EXPORTING I_STRUCTURE_NAME = 'JVA_RGJVBE01_SPL_STAZ' CHANGING ct_fieldcat = lt_fcat101_3[] EXCEPTIONS INCONSISTENT_INTERFACE = 1 PROGRAM_ERROR = 2 OTHERS = 3.
MESSAGES_SAVE CALL FUNCTION 'MESSAGES_SAVE' EXPORTING i_balobject = messages_save_balobject I_BALSUBOBJECT = messages_save_balsubobject I_IN_UPDATE_TASK = 'X' i_identification = gd_message_identification IMPORTING E_LOG_HANDLE = ls_message-log_handle EXCEPTIONS NO_MESSAGES = 1 OTHERS = 6.
MESSAGES_STOP CALL FUNCTION 'MESSAGES_STOP' EXCEPTIONS A_MESSAGE = 1 E_MESSAGE = 2 I_MESSAGE = 3 W_MESSAGE = 4 OTHERS = 5.
GET_PRINT_PARAMETERS CALL FUNCTION 'GET_PRINT_PARAMETERS' EXPORTING MODE = 'CURRENT' NO_DIALOG = 'X' DESTINATION = PRI_PARAMS-PDEST IMMEDIATELY = ' ' NEW_LIST_ID = 'X' LAYOUT = 'X_58_170' * LIST_TEXT = 'X' LIST_TEXT = LS_COVER_TEXT "678121 LINE_COUNT = 58 LINE_SIZE = 170 IMPORTING OUT_PARAMETERS = PRI_PARAMS VALID = VALID EXCEPTIONS OTHERS = 4.
JV_WRITE_MESSAGE CALL FUNCTION 'JV_WRITE_MESSAGE' EXPORTING SORT_ORDER = '1' NO_CO_MESSAGE = 'X'.
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 RGJVBE01 or its description.