SAP Reports / Programs

comments icon Comments

/KYK/EXPORT_ROLES_TO_EXCEL SAP ABAP Report - Export Roles in the R3 system to an Excel Sheet







/KYK/EXPORT_ROLES_TO_EXCEL is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Info: Kindly select the Role(s) which you want to export to the excel in the input field 'Role(s)'...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 /KYK/EXPORT_ROLES_TO_EXCEL 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 /KYK/EXPORT_ROLES_TO_EXCEL. "Basic submit
SUBMIT /KYK/EXPORT_ROLES_TO_EXCEL AND RETURN. "Return to original report after report execution complete
SUBMIT /KYK/EXPORT_ROLES_TO_EXCEL 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: R_NAME = Role(s)
Selection Text: NEW_XLS = New Roles File Location
Selection Text: F_PATH = Existing Roles Source File
Title: Export Roles in the R3 system to an Excel Sheet
Text Symbol: 047 = No roles found for the specified search criteria
Text Symbol: 046 = Access defined for source file
Text Symbol: 045 = Target file is locked and cannot be edited
Text Symbol: 043 = To be checked (valid for BPPs!)
Text Symbol: 042 = Authorization Default
Text Symbol: 041 = In Closing Cockpit
Text Symbol: 040 = Transaction Variant
Text Symbol: 039 = Beautified Transaction
Text Symbol: 038 = Transaction Report
Text Symbol: 037 = Transaction replaced by
Text Symbol: 036 = USA
Text Symbol: 035 = Canada
Text Symbol: 034 = Only release 1.3 (please set an 'X' at this column if the entry/row belongs only to AKY
Text Symbol: 033 = Tag: Scope (simplified, generic or empty) Empty means valid for both approaches
Text Symbol: 032 = Role is maintained and transport is released at BSX/105 (set 'X')
Text Symbol: 031 = Role Attribute
Text Symbol: 025 = OBN Parameters
Text Symbol: 024 = BOR object method
Text Symbol: 023 = BOR object Name (used to call target)
Text Symbol: 022 = BOR object type
Text Symbol: 021 = Appl./POWL maintained by
Text Symbol: 020 = Appl./POWL author
Text Symbol: 019 = BPP
Text Symbol: 018 = File path is not specified
Text Symbol: 017 = No roles are found
Text Symbol: 016 = Error in importing the roles
Text Symbol: 015 = Error in xls generation
Text Symbol: 014 = Roles has been imported to the specified URL:
Text Symbol: 010 = Entry is set to invisible at the role
Text Symbol: 009 = POWL (Default Query)
Text Symbol: 008 = POWL (Type)
Text Symbol: 007 = POWL (APPLID)
Text Symbol: 006 = Description for transaction
Text Symbol: 005 = Transactions





Text Symbol: 004 = Kayak Roles (NEW)
Text Symbol: 003 = Composite Roles
Text Symbol: 002 = Kayak Role
Text Symbol: 001 = Export the Roles to Excel


INCLUDES used within this REPORT /KYK/EXPORT_ROLES_TO_EXCEL

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:

TEXT_CONVERT_XLS_TO_SAP
        CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
          EXPORTING
            i_tab_raw_data       = it_raw
            i_filename           = f_path
          TABLES
            i_tab_converted_data = lt_exist_roles[]    "ACTUAL DATA
          EXCEPTIONS
            conversion_failed    = 1
            OTHERS               = 2.

MENU_AGR_TREE_READ_HIERARCHY
        CALL FUNCTION 'MENU_AGR_TREE_READ_HIERARCHY'
          EXPORTING
            activity_group = wa_agr_define-agr_name
          TABLES
            nodes          = lt_hier
            texts          = lt_hiert
            urls           = lt_buffi
            tcodes         = lt_tcode
            add_details    = lt_shier_bor
          EXCEPTIONS
            not_authorized = 1
            OTHERS         = 2.

SAP_CONVERT_TO_XLS_FORMAT
        CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
          EXPORTING
            i_line_header        = 'X'
            i_filename           = lv_full_path
          TABLES
            i_tab_sap_data       = lt_roles_excel
          CHANGING
            i_tab_converted_data = lt_conv_data
          EXCEPTIONS
            conversion_failed    = 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 /KYK/EXPORT_ROLES_TO_EXCEL or its description.


   
 

/KYK/EXPORT_ROLES_TO_EXCEL - Export Roles in the R3 system to an Excel Sheet
/KYK/EXPORT_ROLES_TO_EXCEL - Export Roles in the R3 system to an Excel Sheet
/KYK/DISP_CHAN_QUOTES - Program for object type /KYK/QT : KYK_DISP_CHAN_QUOTES
/KYK/DISP_CHAN_QUOTES - Program for object type /KYK/QT : KYK_DISP_CHAN_QUOTES
/KYK/DEMAND_MANAGEMENT - Program for object type /KYK/CU : KYK_CUSTOMER_BLOCK
/KYK/DEMAND_MANAGEMENT - Program for object type /KYK/CU : KYK_CUSTOMER_BLOCK