INSERTwaINTOTABLEitab. - 案例代码演示 代码语言:javascript 复制 DATA:GT_SFLIGHTTYPESTANDARDTABLEOFSFLIGHT,GS_SFLIGHTTYPESFLIGHT.SELECT*FROMSFLIGHTINTOCORRESPONDINGFIELDSOFTABLEGT_SFLIGHT.WRITE:'追加前内表数据'.LOOPATGT_SFLIGHTINTOGS_SFLIGHT.WRITE:/GS_SFLIGHT-CARRID,GS_SFLIGHT-CONNID,GS_SFLIGHT-...
DATA:GT_SFLIGHT TYPE STANDARD TABLE OF SFLIGHT,GS_SFLIGHT TYPE SFLIGHT.SELECT * FROM SFLIGHT INTO CORRESPONDING FIELDS OF TABLE GT_SFLIGHT.WRITE:'追加前内表数据'.LOOP AT GT_SFLIGHT INTO GS_SFLIGHT.WRITE:/ GS_SFLIGHT-CARRID,GS_SFLIGHT-CONNID,GS_SFLIGHT-FLDATE,GS_SFLIGHT-PRICE.ENDLO...
INSERTwaINTOTABLEitab. - 案例代码演示 DATA:GT_SFLIGHTTYPESTANDARDTABLEOFSFLIGHT,GS_SFLIGHTTYPESFLIGHT.SELECT*FROMSFLIGHTINTOCORRESPONDINGFIELDSOFTABLEGT_SFLIGHT.WRITE:'追加前内表数据'.LOOPATGT_SFLIGHTINTOGS_SFLIGHT.WRITE:/GS_SFLIGHT-CARRID,GS_SFLIGHT-CONNID,GS_SFLIGHT-FLDATE,GS_SFLIGHT-PRICE...
Insert into Internal tables Syntax INSERT <line>|LINES OF <jtab> [FROM <n1>] [TO <n 2>] INTO TABLE <itab> [ASSIGNING <FS> | REFERENCE INTO <dref>]. This statement will insert the lines into an internal table from another internal table. FROM and TO addition will specify the lines...
DATA: int_tab TYPE STANDARD TABLE OF i, ref_tab TYPE HASHED TABLE OF intref WITH UNIQUE KEY table_line. DO 10 TIMES. INSERT sy-index INTO int_tab INDEX 1 REFERENCE INTO DATA(dref). INSERT dref INTO TABLE ref_tab. ENDDO. cl_demo_output=>begin_section( `Integer Table` ). ...
You just need to proper match ABAP data type to your DB (DB2) data type. For some you will need conversion (you can use SQL "conversions"/"functions" or convert data in ABAP before inserting). For example SAP date format to SQL: INSERT INTO table_name ( DATE_FIELD ) VALUES ( to_...
SAP Managed Tags: ABAP Development Hi! I have an structure with a lot of fields and I have a database table with less field. Some of the fields of the structure match the database table fields. is there a way of doing an "INSERT INTO dtbase CORRESPONDING FIELDS FROM struct"?? Or ...
INSERT statement allows to insert one or more rows into the database table. We can only insert row into an ABAP Dictionary view if it is created on one table, and its maintenance status is defined as Read and change. We can specify the database table either statically or dynamically. Ins...
SAP Managed Tags: ABAP Development Hi, By using SM30 or SE16 u can enter datas directly into a table. Otherwise, IN SE38, using APPEND,INSERT stmts u can enter. But in SM30 before entering data,u have to create table maintainance generator then only it will allow u to enter datas....
SAP Managed Tags: ABAP Development ABAP Development Programming Tool View products (1) Hi, I have to insert data from Table A into Table B. Table A is having 100 records and table B is having 10000 records. Condition is if data in Table A is not in table B then I have to inser...