SAP Reports / Programs

comments icon Comments

RWSORT17 SAP ABAP Report - Mass Listing of Value-Only Materials







RWSORT17 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter RWSORT17 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

WSP7 - Mat. grp mat. listing in plant


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 RWSORT17. "Basic submit
SUBMIT RWSORT17 AND RETURN. "Return to original report after report execution complete
SUBMIT RWSORT17 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: VTWEG = Distribution channel
Selection Text: VKORG = Sales organization
Selection Text: S_MATNR = Material
Selection Text: S_MATKL = Material group
Selection Text: SONST2 = List other value-only mats.
Selection Text: SONST1 = Others only in assign. astmnts
Selection Text: SONST = List hierarchy material
Selection Text: PRINT = Print errors and listing only
Selection Text: FREIWERT = Non-assigned value-only mats.
Selection Text: FILIA = Assortment
Selection Text: ALLES = List in full
Title: Mass Listing of Value-Only Materials
Text Symbol: 062 = Result
Text Symbol: 061 = Information
Text Symbol: 050 = End processing
Text Symbol: 044 = Print control
Text Symbol: 043 = Also list hierarchy material and other value-only materials
Text Symbol: 042 = All material groups in all assortments (regardless of communication profile)
Text Symbol: 041 = Function
Text Symbol: 040 = Execute function for
Text Symbol: 031 = No reference material entered
Text Symbol: 030 = No value-only material entered
Text Symbol: 020 = Processed:
Text Symbol: 014 = Insufficient data maintained for material - add more data
Text Symbol: 013 = Information: Update of a data packet has been started
Text Symbol: 012 = Material group not entered in material
Text Symbol: 011 = Value-only material
Text Symbol: 010 = Reference material
Text Symbol: 004 = Material master data maintained / no listing planned
Text Symbol: 003 = Material number listed
Text Symbol: 002 = Profile module created
Text Symbol: 001 = Material no. not available
002 Material group (material) Information
001 Assortment description


INCLUDES used within this REPORT RWSORT17

INCLUDE MWWCONST.
INCLUDE MM07MABC.
INCLUDE RWSORT_LISTVIEW_DATA.


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:

ASSORTMENT_GET_DATA_AND_USER_B
      CALL FUNCTION 'ASSORTMENT_GET_DATA_AND_USER_B'      " COLLETT 4.5B

WLK1_READ_MULTIPLE_FUNCTIONS
          CALL FUNCTION 'WLK1_READ_MULTIPLE_FUNCTIONS'
               EXPORTING
*                   BUFFERS_READ       = ' '
                      WLK1_SINGLE_SELECT = TMP_WLK1
                      FUNCTION           = 'H'
*                   ATTYP              = ' '
*                   SELECT_ASSORTMENT  = 'X'
*              IMPORTING
*                   WLK1_OUTPUT        =
                  TABLES
*                   WLK1_ARRAY_SELECT  =
                      WLK1_RESULTS       = II_WLK1
*                   SAMMEL_ITEM        =
*                   PLANT_LIST         =
               EXCEPTIONS
                    NO_REC_FOUND       = 1
                    OTHERS             = 2.

ASSORTMENT_GET_USERS_OF_ASORT
        CALL FUNCTION 'ASSORTMENT_GET_USERS_OF_ASORT'
            EXPORTING
              VALID_PER_DATE = SY-DATUM                  " note 640416
              DATE_TO        = MAX_DATUM                 " note 640416
*                 SELECT_INVALID_ASORT = ' '
             TABLES
                  ASSORTMENT_USERS     = T_USERS
                  ASSORTMENT_ASORTS    = T_ASORT
             EXCEPTIONS
                  NO_ASORT_TO_SELECT   = 1
                  NO_USER_FOUND        = 2
                  OTHERS               = 3.                 "#EC *

WLK1_READ_MULTIPLE_FUNCTIONS
          CALL FUNCTION 'WLK1_READ_MULTIPLE_FUNCTIONS'
             EXPORTING
*                 BUFFERS_READ       = ' '
                  WLK1_SINGLE_SELECT = TMP_WLK1
                  FUNCTION           = 'H'
*                 ATTYP              = ' '
*                 SELECT_ASSORTMENT  = 'X'
*            IMPORTING
*                 WLK1_OUTPUT        =
             TABLES
*                 WLK1_ARRAY_SELECT  =
                  WLK1_RESULTS       = II_WLK1
*                 SAMMEL_ITEM        =
*                 PLANT_LIST         =
             EXCEPTIONS
                  NO_REC_FOUND       = 1
                  OTHERS             = 2.

ASSORTMENT_CHECK_ENQ_MATNR
  CALL FUNCTION 'ASSORTMENT_CHECK_ENQ_MATNR'
    EXPORTING
      MATNR = MARA-MATNR.

MAW1_SINGLE_READ
*  CALL FUNCTION 'MAW1_SINGLE_READ'
*       EXPORTING
**           KZRFB      = ' '
**           MAXTZ      = 0
*            MATNR      = MARA-MATNR
*       IMPORTING
*            WMAW1      = MAW1
*       EXCEPTIONS
*            WRONG_CALL = 1
*            NOT_FOUND  = 2
*            OTHERS     = 3.

MAW1_SINGLE_READ
*      CALL FUNCTION 'MAW1_SINGLE_READ'
*         EXPORTING
**           KZRFB      = ' '
**           MAXTZ      = 0
*            MATNR      = T023-WWGDA
*         IMPORTING
*            WMAW1      = *MAW1
*         EXCEPTIONS
*            WRONG_CALL = 1
*            NOT_FOUND  = 2
*            OTHERS     = 3.

ASSORTMENT_WHICH_SEGMENTS
    CALL FUNCTION 'ASSORTMENT_WHICH_SEGMENTS'
         EXPORTING                     " WERKS =
              MATNR             = MARA-MATNR
              ASORT             = I_SORTIM-ASORT
              MATKL             = MARA-MATKL
              MTART             = MARA-MTART
              CHAR_OF_USER      = ' '  "sonstiges Sortiment
         IMPORTING
              MARC_MUST_BE      = MARC_MUST_BE  " HIER_AT_ALL = 'X'
              WLK2_MUST_BE      = WLK2_MUST_BE
              WLK1_MUST_BE      = WLK1_MUST_BE
              MBEW_MUST_BE      = MBEW_MUST_BE
*             kunnr_out         = kunnr_out
              MVKE_MUST_BE      = MVKE_MUST_BE
         TABLES
              MBEW_TABS         = MBEW_TABS  "wint_bwtar
              MVKE_TABS         = MVKE_TABS                 "wint_mvke2
              MARC_TABS         = MARC_TABS  "wint_marc
         EXCEPTIONS
              NO_WERKS_OR_ASORT = 01
              WRONG_ASORT       = 02
              WRONG_WERKS       = 03
              MATKL_MUST_BE     = 04.                       "#EC *

WSOH_READ_PROFILE_MODULE
      CALL FUNCTION 'WSOH_READ_PROFILE_MODULE'
        EXPORTING
          MATKL                 = MARA-MATKL
          ASORT                 = I_SORTIM-ASORT
          ONLY_ACTIVE           = 'X'
        IMPORTING
          EWSOH                 = WSOH
        EXCEPTIONS
          KEY_UNCOMPLETE        = 1
          REC_ENQUEUED          = 2
          REC_NOT_ACTIVE        = 3
          REC_NOT_VALID_IN_TIME = 4
          NO_REC_FOUND          = 5
          OTHERS                = 6.

MODULE_CREATE
        CALL FUNCTION 'MODULE_CREATE'
          EXPORTING
            FUNCTION              = '1'
            LOCATION              = I_SORTIM-ASORT
            MERCHANDISE_GROUP     = MARA-MATKL
            DATE_BEGIN            = SY-DATUM
            DATE_END              = MAX_DATUM
          IMPORTING
            MODULE                = WSOH
            MODULE_TEXT           = WSOT
            WSCOR                 = WSCOR
          EXCEPTIONS
            MODULE_ALREADY_EXISTS = 01
            WRONG_FUNCTION        = 02.                     "#EC *

ASSIGNMENT_POS_TO_SHOP
    CALL FUNCTION 'ASSIGNMENT_POS_TO_SHOP'
      EXPORTING
        ASSORTMENT_HEAD               = WSOH
        ASSORTMENT_POS                = WINT_POS
        FUNCTION                      = '1'
        LOCATION                      = I_SORTIM-ASORT
        MERCHANDISE_GROUP             = MARA-MATKL
      IMPORTING
        WSCOR                         = WSCOR
      EXCEPTIONS
        ASSORTMENT_POS_ALREADY_EXISTS = 01
        ASSORTMENT_POS_NOT_FOUND      = 02
        WRONG_FUNCTION                = 03
        ENQUEUED                      = 04
        NO_MULTIPLE_LISTING           = 05
        RULES_MATCHING_NOT_OK         = 06.                 "#EC *


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


   
 

RWSORT17 - Mass Listing of Value-Only Materials
RWSORT17 - Mass Listing of Value-Only Materials
RWSORT16 - Delete Individual Listing Material/Assortment
RWSORT16 - Delete Individual Listing Material/Assortment
RWSORT15 - Change Individual Listing Material/Assortment
RWSORT15 - Change Individual Listing Material/Assortment