If you have a classification as ‘MODEL’ you can read the data as below.
You need to join Ausp and Cabn table.
DATA: BEGIN OF i_ausp OCCURS 0, atnam LIKE cabn-atnam, objek LIKE ausp-objek, atwrt LIKE ausp-atwrt, atflv LIKE ausp-atflv, END OF i_ausp.
CLEAR: i_ausp, i_ausp[].
SELECT cabn~atnam ausp~objek ausp~atwrt ausp~atflv FROM ausp JOIN cabn ON ausp~atinn = cabn~atinn AND ausp~adzhl = cabn~adzhl INTO TABLE i_ausp WHERE ausp~adzhl = ‘0’ AND ausp~klart = ‘001’ AND cabn~atnam = ‘MODEL’.
Firstly open SE11 transaction code, write the search help name that you want to create.
Selection method is the table that you reference. QPCD is our example.
Dialog type is: “Display Values Immediately” This means when you push search help button, values are displayed immediately. Other options are listed below.
You can filter data set by giving default values. In this example Katalogart is ‘D’ and Codegruppe is ’01’.
If you don’t want to see the values when you open the search help, don’t choose IMP(import) and EXP(export) parameters.
In this example Code and Kurztext values will be listed where Katalogart equals ‘D’ and Codegruppe equals ’01’.
You can also use this search help in screen painter.
Customer number, sales organization, distrubution channel and division are the selection parameters.
DATA lt_knvp LIKE TABLE OF knvp WITH HEADER LINE.
SELECT * FROM knvp INTO TABLE lt_knvp WHERE kunnr = i_out-kunnr “Customer Number AND vkorg = p_vkorg “Sales Organization AND vtweg = p_vtweg “Distribution Channel AND spart = p_spart. “Division
SO15 and SO23 transaction codes can be used for creating and modifying Distribution Lists. If you do not see the list, you need to extend Shared Distribution List.
You can also use SBWP transaction code. You should open Shared Folders.