Practical SAP Interview Questions

Select header data with modern ABAP SQL into an inline table, then show it with the SALV class. REPORT zpo_list. PARAMETERS p_lifnr TYPE lifnr OBLIGATORY. START-OF-SELECTION. SELECT ebeln, bukrs, bedat, lifnr FROM ekko WHERE lifnr = @p_lifnr INTO TABLE @DATA(lt_po). TRY. cl_salv_table=>factory( IMPORTING r_salv_table = DATA(lo_alv) CHANGING t_table = lt_po ). lo_alv->display( ). CATCH cx_salv_msg. MESSAGE 'ALV error' TYPE 'E'. ENDTRY.

Use a table expression with a TRY block, or READ TABLE with a key. For sorted or hashed tables use the key for fast access. TRY. DATA(ls_po) = lt_po[ ebeln = '4500000010' ]. CATCH cx_sy_itab_line_not_found. " row not found ENDTRY. READ TABLE lt_po INTO DATA(ls_row) WITH KEY ebeln = '4500000010'. IF sy-subrc = 0. " found ENDIF.

A view entity joins header and item with an association and exposes fields with aliases. @AccessControl.authorizationCheck: #CHECK @EndUserText.label: 'Sales order items' define view entity ZI_SalesOrderItem as select from vbap as Item association [1..1] to vbak as _Header on $projection.SalesOrder = _Header.vbeln { key Item.vbeln as SalesOrder, key Item.posnr as SalesOrderItem, Item.matnr as Material, Item.kwmeng as OrderQuantity, _Header.kunnr as SoldToParty, _Header }

Read all needed rows once with a join or FOR ALL ENTRIES, then read from the internal table in the loop. SELECT ebeln, ebelp, matnr FROM ekpo WHERE ebeln IN @s_ebeln INTO TABLE @DATA(lt_items). IF lt_items IS NOT INITIAL. SELECT matnr, maktx FROM makt FOR ALL ENTRIES IN @lt_items WHERE matnr = @lt_items-matnr AND spras = @sy-langu INTO TABLE @DATA(lt_text). ENDIF. SORT lt_text BY matnr. Always check the driver table is not empty before FOR ALL ENTRIES.

Call the BAPI, check the RETURN table for errors, then commit or roll back. CALL FUNCTION 'BAPI_PO_CREATE1' EXPORTING poheader = ls_head poheaderx = ls_headx IMPORTING exppurchaseorder = lv_ebeln TABLES poitem = lt_item poitemx = lt_itemx return = lt_return. IF line_exists( lt_return[ type = 'E' ] ) OR line_exists( lt_return[ type = 'A' ] ). CALL FUNCTION 'BAPI_TRANSACTION_ROLLBACK'. ELSE. CALL FUNCTION 'BAPI_TRANSACTION_COMMIT' EXPORTING wait = abap_true. ENDIF.

Annotations on a projection view define the table columns and filters. @UI.headerInfo: { typeName: 'Sales Order', typeNamePlural: 'Sales Orders' } define view entity ZC_SalesOrder as projection on ZI_SalesOrder { @UI.lineItem: [{ position: 10 }] @UI.selectionField: [{ position: 10 }] key SalesOrder, @UI.lineItem: [{ position: 20 }] @UI.selectionField: [{ position: 20 }] SoldToParty, @UI.lineItem: [{ position: 30 }] NetAmount, TransactionCurrency }

Use GROUP BY and aggregate functions in the SELECT instead of looping and summing in ABAP. SELECT bukrs, gjahr, SUM( hsl ) AS amount FROM acdoca WHERE rldnr = '0L' AND bukrs IN @s_bukrs AND gjahr = @p_gjahr GROUP BY bukrs, gjahr INTO TABLE @DATA(lt_totals). Only the totals travel to the application server, which is far faster than reading every line item of the Universal Journal.