sap workbench 8

**********************************************************************************

*header 가 없을 경우 table 과 sturcture 를 날릴떄 사용 방법:

DATA : ls_mara       TYPE mara,
      lt_mara like table of mara.

* 
CLEAR ls_mara, 

* internal table이 가지고 있는 data를 나렬버린다.
REFRESH lt_mara 

ls_mara-matnr = 'AA'.
ls_mara-mtart = 'bb'.


APPEND ls_mara TO lt_mara.

ls_mara-mtart = 'cc'.
APPEND ls_mara TO lt_mara.

BREAK-POINT.

**********************************************************************************

 

 

< error message >

 

 

DATA : BEGIN OF ls_sflight,


         carrid   TYPE  sflight-carrid,
         connid   TYPE  sflight-connid,
         fldate   TYPE  sflight-fldate,
         price    TYPE  sflight-price,
         currency TYPE  sflight-currency,

       END OF ls_sflight,

       lt_sflight LIKE TABLE OF ls_sflight.

CLEAR :ls_sflight.
REFRESH  : lt_sflight.


SELECT carrid connid fldate price currency
  INTO TABLE lt_sflight
  FROM sflight.

***********************************************************************************

*DATA : ls_scarr TYPE  sflight,
*       lt_scarr TYPE TABLE OF sflight.
*
*CLEAR : ls_scarr.
*REFRESH :lt_scarr.
*
*SELECT carrid carrname currcode
*  INTO CORRESPONDING FIELDS OF LS_scarr
*  FROM scarr
*  WHERE carrid = 'AA'
*  OR carrid = 'LH'.
*
*ENDSELECT.
*
***********************************************************************************

***********************************************************************************
  
  DATA : ls_data TYPE  sflight,
         lt_data TYPE TABLE of sflight.
  
  clear : ls_data.
  REfresh lt_data.
  
  
  SELECT carrid connid fldate currency planetype
    INTO CORRESPONDING FIELDS OF table lt_data
    FROM sflight
    WHERE currency = 'USD'
    AND planetype = '747-400'.
    
 ***********************************************************************************

 

 

주의사항 > single을 사용할 때에는 corresponding field of 만 사용! corrresponding field of table은 사용이 불가능하다.

 

*  ***********************************************************************************


data :  ls_scarr type scarr.

clear : ls_scarr.

*single 쓰면 fields of 까지만 사용해주세요!   절대 fields of table을 사용하지 마세요
select single carrid carrname currcode
  into CORRESPONDING FIELDS OF ls_carr
  from scarr
  where carrid = 'AA'.


**************************************************************************************  

***************************************************************************************

* <사진 못찍음>
DATA : BEGIN OF ls_data,

         carrid   TYPE sflight-carrid,
         connid   TYPE sflight-connid,
         fldate   TYPE sflight-fldate,
         bookid   TYPE sbook-bookid,
         customid TYPE sbook-customid,
         custtype TYPE sbook-custtype,
       END OF ls_data,


       lt_data LIKE TABLE OF ls_data.


SELECT carrid connid fldate bookid customid custtype
  INTO CORRESPONDING FIELDS OF TABLE lt_data
  FROM sbook
  WHERE carrid ='LH'
  AND connid = '0401'
  AND customid = '25'.


***************************************************************************************

*
** <사진 못찍음>
*DATA : BEGIN OF ls_data,
*
*         carrid   TYPE sflight-carrid,
*         connid   TYPE sflight-connid,
*         fldate   TYPE sflight-fldate,
*         bookid   TYPE sbook-bookid,
*         customid TYPE sbook-customid,
*         custtype TYPE sbook-custtype,
*       END OF ls_data,
*
*
*       lt_data LIKE TABLE OF ls_data.
*
*clear : ls_data.
*REFRESH : lt_Data.
*
*  ne = not equal , <> 포함하지 않는다. X > X보다 큰것
*SELECT carrid connid fldate bookid customid custtype
*  INTO CORRESPONDING FIELDS OF TABLE lt_data
*  FROM sbook
*  WHERE carrid ne 'LH'
*  AND connid = '0401'
*  AND customid = '25'.
*
* LOOP AT lt_data into ls_Data.
*   write : ls_data-bookid, / .
* ENDLOOP.

 

1. data brower 에서  ignore vs  null 찾기

 

이렇게 빈 공간이면 ignore

 

 

더블 클릭후 = 를 클릭하면 다음과 같이 보인다.

이 의미는 공백인 것을 찾아라 라는 의미이다.

 

 

2. abap 관계 연산자 정리

DATA : BEGIN OF ls_data,
         MTART TYPE t134-MTART,
         MTREF TYPE t134-MTREF,
         MBREF TYPE t134-MBREF,
         PSTAT TYPE t134-PSTAT,
         VMTPO TYPE t134-VMTPO,

       END OF ls_data,

       lt_data LIKE TABLE OF ls_data.

SELECT MTART MTREF MBREF FLREF ARDEL
  INTO CORRESPONDING FIELDS OF TABLE lt_data
  FROM t134
  WHERE mtref = 'HAWA'
  AND   mbref = 'ROH'
  AND   flref NE 'WERT'
  AND   ardel >= '0'.

LOOP AT lt_data INTO ls_data.
  WRITE : ls_data-mtart, /.

ENDLOOP.


DATA : BEGIN OF ls_data2,
         BWART TYPE t156-BWART,
         SHKZG TYPE t156-SHKZG,
         KZWES TYPE t156-KZWES,
         SELPA TYPE t156-SELPA,
         XPBED TYPE t156-XPBED,
       END OF ls_data2,

       lt_data2 LIKE TABLE OF ls_data2.

SELECT BWART KZWES KZDRU SELPA
  INTO CORRESPONDING FIELDS OF TABLE lt_data2
  FROM t156
  WHERE KZWES = 'S'
  AND KZDRU = '1'
  AND SELPA ne ' '.


LOOP  : AT lt_data2 INTO ls_data2.
  WRITE ls_data2-BWART.

ENDLOOP.

***refactoring****

LOOP  : AT lt_data INTO ls_data,
  AT lt_data2 into ls_data2.
  
  WRITE : ls_data-mtart, /,
  ls_data2-BWART.

ENDLOOP.