SAP Reports / Programs | Financial Accounting | Localization(FI-LOC) SAP FI

J_1BPOSDB SAP ABAP Report - POS-Database (Brazilian)







J_1BPOSDB is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report read the POS-database data and create for all marked positions one Nota Fiscal for each date/store combination...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_1BPOSDB into the relevant SAP transactions such as SE38 or SE80


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_1BPOSDB. "Basic submit
SUBMIT J_1BPOSDB AND RETURN. "Return to original report after report execution complete
SUBMIT J_1BPOSDB 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: O_BUDAT = Date
Selection Text: O_WERKS = Store
Selection Text: P_ALL = All positions
Selection Text: P_CFOP = CFOP code
Selection Text: P_FORM = Form of Nota Fiscal
Selection Text: P_MAKTX = Article description
Selection Text: P_MATKL = Article group
Selection Text: P_MEINS = Unit of measure
Selection Text: P_NFTYPE = Nota Fiscal Type
Selection Text: P_NOK = Only faulty positions
Selection Text: P_OK = Only correct positions
Selection Text: P_OKNONF = Only correct positions w/o NF
Selection Text: P_PARID = Partner ID
Selection Text: P_PARVW = Partner Function
Title: POS-Database (Brazilian)
Text Symbol: B03 = Display options for Online mode
Text Symbol: B02 = Nota Fiscal fix values
Text Symbol: B01 = POS database selection
Text Symbol: 033 = Coupons datas for Nota Fiscal:
Text Symbol: 032 = Reduction datas for Nota Fiscal:
Text Symbol: 031 = Date:
Text Symbol: 030 = Store:
Text Symbol: 029 = It's not possible to transfer the MAP number ot the Nota fiscal
Text Symbol: 028 = Different MAP numbers at reduction level for:
Text Symbol: 027 = Information
Text Symbol: 026 = Not all lines for store/date are selected !
Text Symbol: 001 = Serial number
Text Symbol: 002 = NF Typ
Text Symbol: 003 = Counter begin
Text Symbol: 004 = Counter end
Text Symbol: 005 = Reduction
Text Symbol: 006 = Serie coupon
Text Symbol: 007 = Amount begin
Text Symbol: 008 = Amount end
Text Symbol: 009 = Cancels
Text Symbol: 010 = Discounts
Text Symbol: 011 = Tax code
Text Symbol: 012 = Base amount





Text Symbol: 013 = Tax value
Text Symbol: 014 = Excl. base amount
Text Symbol: 015 = Other base amount
Text Symbol: 016 = MAP of POS
Text Symbol: 017 = Currency
Text Symbol: 018 = Serie
Text Symbol: 019 = Tax rate
Text Symbol: 020 = Item
Text Symbol: 021 = Quantity
Text Symbol: 022 = Unit
Text Symbol: 023 = Nota fiscal exist already for some lines !
Text Symbol: 024 = Do you although create a new nota fiscal ?
Text Symbol: 025 = Warning


INCLUDES used within this REPORT J_1BPOSDB

No INCLUDES are used within this REPORT code!


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:

REUSE_ALV_HIERSEQ_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_HIERSEQ_LIST_DISPLAY' EXPORTING i_callback_program = g_repid i_callback_pf_status_set = 'SET_STATUS' i_callback_user_command = 'USER_COMMAND' is_layout = layout it_fieldcat = fieldcat i_save = 'X' i_tabname_header = g_header i_tabname_item = g_position is_keyinfo = keyinfo TABLES t_outtab_header = alv_reduction t_outtab_item = alv_coupons EXCEPTIONS program_error = 1 OTHERS = 2.

POPUP_TO_CONFIRM_STEP CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' EXPORTING defaultoption = 'N' textline1 = text-023 textline2 = text-024 titel = text-025 cancel_display = space IMPORTING answer = i_answer.

J_1B_COLLECTIVE_NF_CREATE CALL FUNCTION 'J_1B_COLLECTIVE_NF_CREATE' EXPORTING i_werks = c_werks_budat-werks i_budat = c_werks_budat-budat i_nftype = p_nftype i_form = p_form * I_CFOP = P_CFOP i_parvw = p_parvw i_parid = p_parid i_waers = t_coupons-currency i_matkl = p_matkl i_maktx = p_maktx i_meins = p_meins i_netwr = i_netwr i_nfnum = e_mapnumber IMPORTING e_docnum = i_docnum TABLES ti_coupons = te_coupons te_return = ti_return EXCEPTIONS form_not_found = 1 werks_not_found = 2 bwkey_not_found = 3 parvw_not_found = 4 nftype_not_found = 5 OTHERS = 6.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' "ACC <<< EXPORTING name = c_icon_led_green IMPORTING result = alv_reduction-icon EXCEPTIONS icon_not_found = 1 outputfield_too_short = 2 OTHERS = 3.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' "ACC <<< EXPORTING name = c_icon_led_red IMPORTING result = alv_reduction-icon EXCEPTIONS icon_not_found = 1 outputfield_too_short = 2 OTHERS = 3.

J_1B_COLLECTIVE_NF_CREATE CALL FUNCTION 'J_1B_COLLECTIVE_NF_CREATE' EXPORTING i_werks = c_werks_budat-werks i_budat = c_werks_budat-budat i_nftype = p_nftype i_form = p_form * I_CFOP = P_CFOP i_parvw = p_parvw i_parid = p_parid i_waers = t_coupons-currency i_matkl = p_matkl i_maktx = p_maktx i_meins = p_meins i_netwr = i_netwr i_nfnum = e_mapnumber IMPORTING e_docnum = i_docnum TABLES ti_coupons = te_coupons te_return = ti_return EXCEPTIONS form_not_found = 1 werks_not_found = 2 bwkey_not_found = 3 parvw_not_found = 4 nftype_not_found = 5 OTHERS = 6.

REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_structure_name = 'BAPIRET2' CHANGING ct_fieldcat = fieldcat_pop EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.

REUSE_ALV_POPUP_TO_SELECT CALL FUNCTION 'REUSE_ALV_POPUP_TO_SELECT' EXPORTING i_title = v_title i_tabname = g_pop it_fieldcat = fieldcat_pop i_callback_program = g_repid TABLES t_outtab = t_return_pop EXCEPTIONS program_error = 1 OTHERS = 2.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' "ACC <<< EXPORTING name = c_icon_ext_help IMPORTING result = alv_reduction-icon EXCEPTIONS icon_not_found = 1 outputfield_too_short = 2 OTHERS = 3.

ICON_CREATE CALL FUNCTION 'ICON_CREATE' "ACC <<< EXPORTING name = c_icon_status_booked IMPORTING result = alv_reduction-icon EXCEPTIONS icon_not_found = 1 outputfield_too_short = 2 OTHERS = 3.

REUSE_ALV_POPUP_TO_SELECT CALL FUNCTION 'REUSE_ALV_POPUP_TO_SELECT' EXPORTING i_title = v_title i_screen_start_column = '2' i_screen_start_line = '2' i_screen_end_column = '130' i_screen_end_line = '25' i_tabname = g_pop it_fieldcat = fieldcat_pop i_callback_program = g_repid TABLES t_outtab = t_detail_header EXCEPTIONS program_error = 1 OTHERS = 2.

REUSE_ALV_POPUP_TO_SELECT





CALL FUNCTION 'REUSE_ALV_POPUP_TO_SELECT' EXPORTING i_title = v_title i_screen_start_column = '2' i_screen_start_line = '2' i_screen_end_column = '130' i_screen_end_line = '25' i_tabname = g_pop it_fieldcat = fieldcat_pop i_callback_program = g_repid TABLES t_outtab = t_detail_position EXCEPTIONS program_error = 1 OTHERS = 2.



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_1BPOSDB or its description.