tabname = ls_zsapfield-saptablename TRANSPORTING NO FIELDS. IF sy-subrc <> 0. SELECT * APPENDING CORRESPONDING FIELDS OF TABLE gt_field FROM dd03l WHERE tabname = ls_zsapfield-saptablename AND keyflag ='X'AND fieldname <>'MATNR'AND fieldname <>'MANDT'. ENDIF. l_statm = ls_zsap...
into CORRESPONDING FIELDS OF table gt_detail where hkont = “2202980000” and budat <= p_budat. select a~hkont a~belnr a~buzei a~shkzg a~budat a~dmbtr b~txt50 from bsas as a join GL_ACCT_CA_TEXT as b on a~hkont = b~SAKNR appending CORRESPONDING FIELDS OF table gt_detail where...
SELECT.INTO|APPENDINGCORRESPONDINGFIELDSOFTABLEitab.该情况下SELECT并不启动循环,因而不需要使用ENDSELECT语句;如果itab非空,则SELECT语句将用读取的数据覆盖其中的内容,使用AP 9、PENDING代替INTO将不覆盖内表,若结构不完全相同,也可使用CORRESPONDINGFIELDS选项将同名区域相对应。SQL编写注意事项-性能实例1直接内表操作...
INTO CORRESPONDING FIELDS OF TABLE ITAB_TX FROM INOB INNER JOIN AUSP ON INOB~CUOBJ = AUSP~OBJEK INNER JOIN CABN ON CABN~ATINN = AUSP~ATINN WHERE INOB~OBJEK in S_MATNR. 此处取的是某个物料所有的特性值,如果要取某个分类的话,可以配合KSML表使用。 也可以调用BAPI:BAPI_OBJCL_GETDETAIL获取 ...
data: gt_ebeln LIKE STANDARD TABLE OF gt_detail WITH HEADER LINE, wa_lname LIKE lfa1-name1. *** * INTERNAL TABLES AND WORK AREAS *** selection-screen begin of block count with frame title text-001. parameters: p_budat like bsis-...
APPENDING 语句 APPENDING语句支持在不删除之前选择的行的情况下增加新的行。 SELECT carrid connid FROM sflight INTO CORRESPONDING FIELDS OF TABLE gt_out.SELECT mandt carrid connid fldate price FROM sflight APPENDING CORRESPONDING FIELDS OF TABLE gt_out. ...
CABN~ATINN"内部特性 CABN~ATNAM"特性名称 IBSYMBOL~ATWRT"特性值 APPENDING CORRESPONDING FIELDS OF TABLE ITAB_TX FROM VBAP INNER JOIN IBIN ON IBIN~INSTANCE = VBAP~CUOBJ INNER JOIN IBINVALUES ON IBINVALUES~IN_RECNO = IBIN~IN_RECNO INNER JOIN IBSYMBOL ON IBSYMBOL~SYMBOL_ID = IBINVALUE...
~ATWRT"特性值APPENDING CORRESPONDING FIELDS OF TABLE ITAB_TX FROM VBAP INNER JOIN IBIN ON IBIN~INSTANCE = VBAP~CUOBJ INNER JOIN IBINVALUES ON IBINVALUES~IN_RECNO = IBIN~IN_RECNO INNER JOIN IBSYMBOL ON IBSYMBOL~SYMBOL_ID = IBINVALUES~SYMBOL_ID ...
INTO CORRESPONDING FIELDS OF wa, ... INTO CORRESPONDING FIELDS OF TABLE itab, and ... APPENDING CORRESPONDING FIELDS OF TABLE itab require a slightly increased runtime - which is, however, independent of the size of the solution set - as compared with the corresponding variants without ...
INTO CORRESPONDING FIELDS OF wa, ... INTO CORRESPONDING FIELDS OF TABLE itab, and ... APPENDING CORRESPONDING FIELDS OF TABLE itab require a slightly increased runtime - which is, however, independent of the size of the solution set - as compared with the corresponding variants without ...