Advertisement
Suncatcher

Read custom code from infoset

Jun 28th, 2019
957
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ABAP 3.59 KB | None | 0 0
  1.   TYPES: BEGIN OF ty_aqgdb_raw,
  2.            clustr TYPE aqgdb-clustr,
  3.            clustd TYPE aqgdb-clustd,
  4.          END OF ty_aqgdb_raw,
  5.          BEGIN OF ty_aqgdb,
  6.            srtfd  TYPE aqgdb-srtfd,
  7.            clustr TYPE aqgdb-clustr,
  8.            clustd TYPE aqgdb-clustd,
  9.          END OF ty_aqgdb.
  10.   DATA: t_aqgdb_raw TYPE STANDARD TABLE OF ty_aqgdb_raw,
  11.         t_aqgdb     TYPE TABLE OF ty_aqgdb,
  12.         w_aqgdb_raw TYPE ty_aqgdb_raw.
  13.  
  14.   DATA:  t_tline TYPE STANDARD TABLE OF tline.
  15.   FIELD-SYMBOLS: <tline> TYPE tline,
  16.                  <aqgdb> LIKE LINE OF t_aqgdb.
  17.  
  18.   SELECT srtfd clustr clustd
  19.      FROM aqgdb
  20.      INTO CORRESPONDING FIELDS OF TABLE t_aqgdb
  21.      WHERE srtfd LIKE '%CUST%'.
  22.  
  23.   LOOP AT t_aqgdb ASSIGNING <aqgdb>.
  24.     CLEAR: t_aqgdb_raw[], t_tline[].
  25.     APPEND VALUE ty_aqgdb_raw( clustr = <aqgdb>-clustr clustd = <aqgdb>-clustd ) TO t_aqgdb_raw.
  26.     IMPORT tline = t_tline FROM INTERNAL TABLE t_aqgdb_raw.
  27.  
  28.     LOOP AT t_tline ASSIGNING <tline>.
  29.       WRITE <tline>-tdline.
  30.     ENDLOOP.
  31.  
  32.   ENDLOOP.
  33.  
  34.   DATA: BEGIN OF headsg.
  35.       INCLUDE TYPE aqhdsg.
  36.   DATA: END OF headsg.
  37.  
  38.   DATA: BEGIN OF clogsg OCCURS 10.
  39.       INCLUDE STRUCTURE aqclsg.
  40.   DATA: END OF clogsg.
  41.  
  42.   DATA: BEGIN OF dbsa OCCURS 40.
  43.       INCLUDE STRUCTURE aqdbsa.
  44.   DATA: END OF dbsa.
  45.  
  46.   DATA: BEGIN OF dbob OCCURS 0.
  47.       INCLUDE STRUCTURE aqdbob.
  48.   DATA: END OF dbob.
  49.  
  50.   DATA: BEGIN OF dbos OCCURS 0.
  51.       INCLUDE STRUCTURE aqdbos.
  52.   DATA: END OF dbos.
  53.  
  54.   DATA: BEGIN OF dbif OCCURS 0.
  55.       INCLUDE STRUCTURE aqdbif.
  56.   DATA: END OF dbif.
  57.  
  58.   DATA: BEGIN OF dbsf OCCURS 100.
  59.       INCLUDE STRUCTURE aqdbsf.
  60.   DATA: END OF dbsf.
  61.  
  62.   DATA: BEGIN OF dbsg OCCURS 40.
  63.       INCLUDE STRUCTURE aqdbsg.
  64.   DATA: END OF dbsg.
  65.  
  66.   DATA: BEGIN OF dban OCCURS 10.
  67.       INCLUDE STRUCTURE aqdban.
  68.   DATA: END OF dban.
  69.  
  70.   DATA: BEGIN OF dbjt OCCURS 10.
  71.       INCLUDE STRUCTURE aqdbjt.
  72.   DATA: END OF dbjt.
  73.  
  74.   DATA: BEGIN OF dbjc OCCURS 40.
  75.       INCLUDE STRUCTURE aqdbjc.
  76.   DATA: END OF dbjc.
  77.  
  78.   DATA: BEGIN OF dbzt OCCURS 50.
  79.       INCLUDE STRUCTURE aqdbzt.
  80.   DATA: END OF dbzt.
  81.  
  82.   DATA: BEGIN OF dbzc OCCURS 50.
  83.       INCLUDE STRUCTURE aqdbzc.
  84.   DATA: END OF dbzc.
  85.  
  86.   DATA: BEGIN OF dbzl OCCURS 100.
  87.       INCLUDE STRUCTURE aqdbzl.
  88.   DATA: END  OF dbzl.
  89.  
  90.   DATA: BEGIN OF dbpa OCCURS  10.
  91.       INCLUDE STRUCTURE aqdbpa.
  92.   DATA: END OF dbpa.
  93.  
  94.   DATA: BEGIN OF dbdp OCCURS 0.
  95.       INCLUDE STRUCTURE aqdbdp.
  96.   DATA: END OF dbdp.
  97.  
  98.   DATA: BEGIN OF dbwr OCCURS  10.
  99.       INCLUDE STRUCTURE aqdbwr.
  100.   DATA: END OF dbwr.
  101.  
  102.   DATA: BEGIN OF dbar OCCURS 10.
  103.       INCLUDE STRUCTURE aqdbar.
  104.   DATA: END OF dbar.
  105.  
  106.   DATA: maxsg_tindx LIKE aqadef-tindx,
  107.         BEGIN OF sgtext OCCURS 100.
  108.       INCLUDE STRUCTURE aqtxsg.
  109.   DATA: END OF  sgtext.
  110.  
  111.   DATA: BEGIN OF dbft OCCURS 50.
  112.       INCLUDE STRUCTURE aqdbft.
  113.   DATA: END OF dbft.
  114.  
  115.   DATA: BEGIN OF sukey,
  116.           'SG',
  117.           variant(1),
  118.           clas       LIKE aqadef-sgname,
  119.         END OF sukey.
  120.  
  121.   DATA: l_sukey LIKE sukey,
  122.         set     TYPE string.
  123.  
  124.   SELECT *
  125.     FROM aqgqcat
  126.     INTO TABLE @DATA(infosets)
  127.     WHERE qnum IN ('query1', 'query2').
  128.  
  129.   LOOP AT infosets ASSIGNING FIELD-SYMBOL(<set>).
  130.  
  131.     set = '%' && <set>-clas && '%'.
  132.     SELECT SINGLE *
  133.      FROM aqgdb
  134.      INTO @DATA(cluster)
  135.      WHERE srtfd LIKE @set.
  136.  
  137.     l_sukey         = cluster-srtfd.
  138.     l_sukey-clas    = <set>-clas.
  139.     l_sukey-variant = 'G'.
  140.  
  141.     IMPORT headsg clogsg dbsa dbob dbos dbif dbsf dbsg dban dbjt dbjc dbzt dbzc dbzl dbdp dbpa dbwr dbar dbft maxsg_tindx
  142.     FROM DATABASE aqgdb(aq) ID l_sukey.
  143.  
  144.   ENDLOOP.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement