![]() PARAMETERS p_carrid TYPE scarr-carrid.ĭATA scarr_tab TYPE SORTED TABLE OF scarrĭELETE TABLE scarr_tab WITH TABLE KEY carrid = p_carrid.You can define your own key fields when declaring an internal table.ġ9. must be compatible with the data type of the component.ĪBAP Code Snippet must not be specified as a component if it is empty.īy explicitly declaring the primary table key, the table row is deleted that has the same value as p_carrid in the key field carrid. To avoid unexpected results after a conversion, operand1 operand2. If a WHERE condition is used in the statements LOOP, MODIFY, and DELETE, however, the comparison rules do apply, which can produce differing results. This means that the comparison rules do not apply to incompatible data types. are converted to the data type of the columns before the comparison. If WITH TABLE KEY is used, note that the values of incompatible operands operand1 operand2. Latest notes:The pseudo component table_line can be specified as a component for tables with an unstructured row type, if their whole table entry is defined as a table key. If the addition COMPONENTS is specified, the table key specified in keyname is used. ![]() If the addition COMPONENTS is not specified, the primary table key is used. If an arithmetic expression is specified, the calculation type is determined from its operands and the data type of the component and the result, if necessary, is converted to the data type of the component. If necessary, the content of the operands is converted to the data type of the components before the comparison. Duplicate or overlapping keys cannot be specified, nor can columns be specified that are not components of the table key. The first row of the internal table found, whose values in the column of the table key used correspond with the values in the operands operand1 operand2. compatible with the data type of the component or convertible to it must be assigned to every component. If name only contains blanks, this specified component is ignored when the statement is executed. , which contains the name of the component when the statement is executed. or as a parenthesized character-like data object name1 name2. What does it do? Each component of the table key used must be listed either directly as comp_name1 comp_name2. COMPONENTS DELETE TABLE itab WITH TABLE KEYĪBAP Alternative 2.PARAMETERS p_carrid TYPE scarr-carrid.ĭATA: scarr_tab TYPE SORTED TABLE OF scarr Furthermore, USING KEY cannot be specified without USING KEY.Ī work area scarr_wa is used to delete the table row that has the same value as p_carrid in the key field carrid of the primary table. The statement then uses the header line as the work area implicitly. Outside of classes, an obsolete short form is also possible where FROM wa can be omitted if the internal table has a header line itab with the same name. The standard key of a standard table can be empty. Latest notes:When using the primary table key, note that this key can be the standard key, which can also have unexpected consequences:įor structured row types, the standard key covers all character-like and byte-like components. If this is statically identifiable, the syntax check produces a warning. If the primary table key is used to access a standard table and the key is empty, then the first row of the internal table is deleted. ![]() If the USING KEY addition is specified, the table key specified in keyname is used. If the USING KEY addition is not specified, the primary table key is used. If the key fields in wa are empty, no entries are processed. The first row of the internal table found, whose values in the columns of the table key used match those of the corresponding components of wa, is processed. This concerns functional operand positions. What does it do? For wa, a work area compatible to the row type of the internal table must be specified. Al though the rows to be deleted are found quickly, when updating the primary index a linear search for the entry to be deleted must be carried out.ĪBAP Alternative 1. Latest notes:When deleting a row from a standard table using a secondary key, the entire runtime depends linearly on the number of table rows. When the secondary table key is used, a binary scan is used in the sorted key case and a hash algorithm is used in the hash key case. The hash algorithm is used for hashed tables. When the primary table key is used, the table categories are accessed as follows: Standard tables are searched in a linear fashion.īinary scans are used for sorted tables. The values can be declared either implicitly in a work area wa behind FROM or by listing the components of the table key explicitly behind TABLE KEY. ![]() What does it do? Specifying a Table Key as a Search Key Either the primary table key or a secondary table key can be specified. Get Example source ABAP code based on a different SAP tableĪBAP Syntax.
0 Comments
Leave a Reply. |