ABAP Select data from SAP table IPPMFGORDITEM into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP IPPMFGORDITEM table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to IPPMFGORDITEM. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the IPPMFGORDITEM table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_IPPMFGORDITEM TYPE STANDARD TABLE OF IPPMFGORDITEM,
      WA_IPPMFGORDITEM TYPE IPPMFGORDITEM,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: <IPPMFGORDITEM> TYPE IPPMFGORDITEM.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_IPPMFGORDITEM.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM IPPMFGORDITEM
  INTO TABLE IT_IPPMFGORDITEM.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM IPPMFGORDITEM
*  INTO TABLE @DATA(IT_IPPMFGORDITEM2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_IPPMFGORDITEM INDEX 1 INTO DATA(WA_IPPMFGORDITEM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_IPPMFGORDITEM ASSIGNING <IPPMFGORDITEM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<IPPMFGORDITEM>-MANDT = 1.
<IPPMFGORDITEM>-MANUFACTURINGORDER = 1.
<IPPMFGORDITEM>-MANUFACTURINGORDERITEM = 1.
<IPPMFGORDITEM>-MANUFACTURINGORDERCATEGORY = 1.
<IPPMFGORDITEM>-MANUFACTURINGORDERTYPE = 1.
ENDLOOP.

LOOP AT IT_IPPMFGORDITEM INTO WA_IPPMFGORDITEM.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_IPPMFGORDITEM-MFGORDERRELEASEDCODE, sy-vline,
WA_IPPMFGORDITEM-MFGORDERISTOBEDELETED, sy-vline,
WA_IPPMFGORDITEM-MFGORDERITEMISFINALLYDELIVERED, sy-vline,
WA_IPPMFGORDITEM-ORDERITEMISNOTRELEVANTFORMRP, sy-vline,
WA_IPPMFGORDITEM-MATERIAL, sy-vline,
WA_IPPMFGORDITEM-PRODUCTIONPLANT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_IPPMFGORDITEM you want to display... WRITE:/ sy-uline. * Aternatively use generic code to Write field values (and NAME) to screen report DO. ASSIGN COMPONENT sy-index OF STRUCTURE wa_IPPMFGORDITEM TO <field>. IF sy-subrc <> 0. EXIT. ENDIF. WRITE:/ 'Field Value', <field>, sy-vline. gd_str = <field> . lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ). lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ). WRITE:/ 'Field Name', lv_fieldname. ENDDO. *Redo loop but convert all fields from internal to out value LOOP AT IT_IPPMFGORDITEM INTO WA_IPPMFGORDITEM. *Write horizonal line to screen report. WRITE:/ sy-uline. *Convert all fields to display/output versions using conversion routines PERFORM convert_all_field_values CHANGING wa_EKKO. ENDLOOP. *&---------------------------------------------------------------------* *& Form convert_all_field_values *&---------------------------------------------------------------------* FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO. DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.

*Conversion exit ALPHA, internal->external for field MANUFACTURINGORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-MANUFACTURINGORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-MANUFACTURINGORDER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field MATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-MATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-MATERIAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field SALESORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-SALESORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-SALESORDER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field WBSELEMENTINTERNALID CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-WBSELEMENTINTERNALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-WBSELEMENTINTERNALID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field QUOTAARRANGEMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-QUOTAARRANGEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-QUOTAARRANGEMENT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field PRODUCTIONUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-PRODUCTIONUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-PRODUCTIONUNIT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PLANNEDORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-PLANNEDORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-PLANNEDORDER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BASEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_IPPMFGORDITEM-BASEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_IPPMFGORDITEM-BASEUNIT.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_IPPMFGORDITEM_STR,
MANDT TYPE STRING,
MANUFACTURINGORDER TYPE STRING,
MANUFACTURINGORDERITEM TYPE STRING,
MANUFACTURINGORDERCATEGORY TYPE STRING,
MANUFACTURINGORDERTYPE TYPE STRING,
MFGORDERRELEASEDCODE TYPE STRING,
MFGORDERISTOBEDELETED TYPE STRING,
MFGORDERITEMISFINALLYDELIVERED TYPE STRING,
ORDERITEMISNOTRELEVANTFORMRP TYPE STRING,
MATERIAL TYPE STRING,
PRODUCTIONPLANT TYPE STRING,
MRPPLANT TYPE STRING,
MRPCONTROLLER TYPE STRING,
PRODUCTIONSUPERVISOR TYPE STRING,
RESERVATION TYPE STRING,
PRODUCTIONVERSION TYPE STRING,
MRPAREA TYPE STRING,
SALESORDER TYPE STRING,
SALESORDERITEM TYPE STRING,
WBSELEMENTINTERNALID TYPE STRING,
QUOTAARRANGEMENT TYPE STRING,
QUOTAARRANGEMENTITEM TYPE STRING,
SETTLEMENTRESERVATION TYPE STRING,
SETTLEMENTRESERVATIONITEM TYPE STRING,
COPRODUCTRESERVATION TYPE STRING,
COPRODUCTRESERVATIONITEM TYPE STRING,
MATERIALPROCUREMENTCATEGORY TYPE STRING,
MATERIALPROCUREMENTTYPE TYPE STRING,
SERIALNUMBERASSGMTPROFILE TYPE STRING,
NUMBEROFSERIALNUMBERS TYPE STRING,
MFGORDERITEMREPLNMTELMNTTYPE TYPE STRING,
PRODUCTCONFIGURATION TYPE STRING,
CONFIGURATIONSIDEEFFECT TYPE STRING,
MANUFACTURINGOBJECT TYPE STRING,
QUANTITYDISTRIBUTIONKEY TYPE STRING,
EFFECTIVITYPARAMETERVARIANT TYPE STRING,
MFGORDERITEMGDSRCPTISALLOWED TYPE STRING,
MFGORDERITEMGDSRCPTISNONVLTD TYPE STRING,
MATERIALGOODSRECEIPTDURATION TYPE STRING,
MFGORDERITMALLOWEDUNDERDELYPCT TYPE STRING,
MFGORDERITEMALLOWEDOVERDELYPCT TYPE STRING,
MFGORDITMHASUNLMTDOVERDELIVERY TYPE STRING,
STORAGELOCATION TYPE STRING,
BATCH TYPE STRING,
INVENTORYVALUATIONTYPE TYPE STRING,
INVENTORYVALUATIONCATEGORY TYPE STRING,
INVENTORYUSABILITYCODE TYPE STRING,
INVENTORYSPECIALSTOCKTYPE TYPE STRING,
INVENTORYSPECIALSTOCKVALNTYPE TYPE STRING,
CONSUMPTIONPOSTING TYPE STRING,
GOODSRECIPIENTNAME TYPE STRING,
UNLOADINGPOINTNAME TYPE STRING,
STOCKSEGMENT TYPE STRING,
MFGORDERPLANNEDSTARTDATE TYPE STRING,
MFGORDERPLANNEDSTARTTIME TYPE STRING,
MFGORDERSCHEDULEDSTARTDATE TYPE STRING,
MFGORDERSCHEDULEDSTARTTIME TYPE STRING,
MFGORDERACTUALSTARTDATE TYPE STRING,
MFGORDERACTUALSTARTTIME TYPE STRING,
MFGORDERPLANNEDENDDATE TYPE STRING,
MFGORDERPLANNEDENDTIME TYPE STRING,
MFGORDERSCHEDULEDENDDATE TYPE STRING,
MFGORDERSCHEDULEDENDTIME TYPE STRING,
MFGORDERCONFIRMEDENDDATE TYPE STRING,
MFGORDERCONFIRMEDENDTIME TYPE STRING,
MFGORDERACTUALENDDATE TYPE STRING,
MFGORDERSCHEDULEDRELEASEDATE TYPE STRING,
MFGORDERACTUALRELEASEDATE TYPE STRING,
MFGORDERITEMPLANNEDENDDATE TYPE STRING,
MFGORDERITEMSCHEDULEDENDDATE TYPE STRING,
MFGORDERITEMPLNDDELIVERYDATE TYPE STRING,
MFGORDERITEMACTUALDELIVERYDATE TYPE STRING,
MFGORDERITEMTOTALCMTMTDATE TYPE STRING,
PRODUCTIONUNIT TYPE STRING,
MFGORDERITEMPLANNEDTOTALQTY TYPE STRING,
MFGORDERITEMPLANNEDSCRAPQTY TYPE STRING,
MFGORDERITEMPLANNEDYIELDQTY TYPE STRING,
MFGORDERITEMGOODSRECEIPTQTY TYPE STRING,
MFGORDERITEMACTUALDEVIATIONQTY TYPE STRING,
MFGORDERITEMOPENYIELDQTY TYPE STRING,
MFGORDERCONFIRMEDYIELDQTY TYPE STRING,
MFGORDERCONFIRMEDSCRAPQTY TYPE STRING,
MFGORDERCONFIRMEDREWORKQTY TYPE STRING,
MFGORDERCONFIRMEDTOTALQTY TYPE STRING,
MFGORDERPLANNEDTOTALQTY TYPE STRING,
MFGORDERPLANNEDSCRAPQTY TYPE STRING,
PLANNEDORDER TYPE STRING,
PLNDORDERPLANNEDSTARTDATE TYPE STRING,
PLANNEDORDEROPENINGDATE TYPE STRING,
BASEUNIT TYPE STRING,
PLNDORDERPLANNEDTOTALQTY TYPE STRING,
PLNDORDERPLANNEDSCRAPQTY TYPE STRING,
BUSINESSAREA TYPE STRING,
ACCOUNTASSIGNMENTCATEGORY TYPE STRING,
PRODUCTSEASONYEAR TYPE STRING,
PRODUCTSEASON TYPE STRING,
PRODUCTCOLLECTION TYPE STRING,
PRODUCTTHEME TYPE STRING,END OF T_EKKO_STR. DATA: WA_IPPMFGORDITEM_STR type T_EKKO_STR. DATA: ld_text TYPE string. LOOP AT IT_EKKO INTO WA_EKKO. MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR. CONCATENATE: sy-vline
WA_IPPMFGORDITEM_STR-MANDT sy-vline
WA_IPPMFGORDITEM_STR-MANUFACTURINGORDER sy-vline
WA_IPPMFGORDITEM_STR-MANUFACTURINGORDERITEM sy-vline
WA_IPPMFGORDITEM_STR-MANUFACTURINGORDERCATEGORY sy-vline
WA_IPPMFGORDITEM_STR-MANUFACTURINGORDERTYPE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERRELEASEDCODE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERISTOBEDELETED sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMISFINALLYDELIVERED sy-vline
WA_IPPMFGORDITEM_STR-ORDERITEMISNOTRELEVANTFORMRP sy-vline
WA_IPPMFGORDITEM_STR-MATERIAL sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTIONPLANT sy-vline
WA_IPPMFGORDITEM_STR-MRPPLANT sy-vline
WA_IPPMFGORDITEM_STR-MRPCONTROLLER sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTIONSUPERVISOR sy-vline
WA_IPPMFGORDITEM_STR-RESERVATION sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTIONVERSION sy-vline
WA_IPPMFGORDITEM_STR-MRPAREA sy-vline
WA_IPPMFGORDITEM_STR-SALESORDER sy-vline
WA_IPPMFGORDITEM_STR-SALESORDERITEM sy-vline
WA_IPPMFGORDITEM_STR-WBSELEMENTINTERNALID sy-vline
WA_IPPMFGORDITEM_STR-QUOTAARRANGEMENT sy-vline
WA_IPPMFGORDITEM_STR-QUOTAARRANGEMENTITEM sy-vline
WA_IPPMFGORDITEM_STR-SETTLEMENTRESERVATION sy-vline
WA_IPPMFGORDITEM_STR-SETTLEMENTRESERVATIONITEM sy-vline
WA_IPPMFGORDITEM_STR-COPRODUCTRESERVATION sy-vline
WA_IPPMFGORDITEM_STR-COPRODUCTRESERVATIONITEM sy-vline
WA_IPPMFGORDITEM_STR-MATERIALPROCUREMENTCATEGORY sy-vline
WA_IPPMFGORDITEM_STR-MATERIALPROCUREMENTTYPE sy-vline
WA_IPPMFGORDITEM_STR-SERIALNUMBERASSGMTPROFILE sy-vline
WA_IPPMFGORDITEM_STR-NUMBEROFSERIALNUMBERS sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMREPLNMTELMNTTYPE sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTCONFIGURATION sy-vline
WA_IPPMFGORDITEM_STR-CONFIGURATIONSIDEEFFECT sy-vline
WA_IPPMFGORDITEM_STR-MANUFACTURINGOBJECT sy-vline
WA_IPPMFGORDITEM_STR-QUANTITYDISTRIBUTIONKEY sy-vline
WA_IPPMFGORDITEM_STR-EFFECTIVITYPARAMETERVARIANT sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMGDSRCPTISALLOWED sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMGDSRCPTISNONVLTD sy-vline
WA_IPPMFGORDITEM_STR-MATERIALGOODSRECEIPTDURATION sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITMALLOWEDUNDERDELYPCT sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMALLOWEDOVERDELYPCT sy-vline
WA_IPPMFGORDITEM_STR-MFGORDITMHASUNLMTDOVERDELIVERY sy-vline
WA_IPPMFGORDITEM_STR-STORAGELOCATION sy-vline
WA_IPPMFGORDITEM_STR-BATCH sy-vline
WA_IPPMFGORDITEM_STR-INVENTORYVALUATIONTYPE sy-vline
WA_IPPMFGORDITEM_STR-INVENTORYVALUATIONCATEGORY sy-vline
WA_IPPMFGORDITEM_STR-INVENTORYUSABILITYCODE sy-vline
WA_IPPMFGORDITEM_STR-INVENTORYSPECIALSTOCKTYPE sy-vline
WA_IPPMFGORDITEM_STR-INVENTORYSPECIALSTOCKVALNTYPE sy-vline
WA_IPPMFGORDITEM_STR-CONSUMPTIONPOSTING sy-vline
WA_IPPMFGORDITEM_STR-GOODSRECIPIENTNAME sy-vline
WA_IPPMFGORDITEM_STR-UNLOADINGPOINTNAME sy-vline
WA_IPPMFGORDITEM_STR-STOCKSEGMENT sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERPLANNEDSTARTDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERPLANNEDSTARTTIME sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERSCHEDULEDSTARTDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERSCHEDULEDSTARTTIME sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERACTUALSTARTDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERACTUALSTARTTIME sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERPLANNEDENDDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERPLANNEDENDTIME sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERSCHEDULEDENDDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERSCHEDULEDENDTIME sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERCONFIRMEDENDDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERCONFIRMEDENDTIME sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERACTUALENDDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERSCHEDULEDRELEASEDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERACTUALRELEASEDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMPLANNEDENDDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMSCHEDULEDENDDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMPLNDDELIVERYDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMACTUALDELIVERYDATE sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMTOTALCMTMTDATE sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTIONUNIT sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMPLANNEDTOTALQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMPLANNEDSCRAPQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMPLANNEDYIELDQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMGOODSRECEIPTQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMACTUALDEVIATIONQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERITEMOPENYIELDQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERCONFIRMEDYIELDQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERCONFIRMEDSCRAPQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERCONFIRMEDREWORKQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERCONFIRMEDTOTALQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERPLANNEDTOTALQTY sy-vline
WA_IPPMFGORDITEM_STR-MFGORDERPLANNEDSCRAPQTY sy-vline
WA_IPPMFGORDITEM_STR-PLANNEDORDER sy-vline
WA_IPPMFGORDITEM_STR-PLNDORDERPLANNEDSTARTDATE sy-vline
WA_IPPMFGORDITEM_STR-PLANNEDORDEROPENINGDATE sy-vline
WA_IPPMFGORDITEM_STR-BASEUNIT sy-vline
WA_IPPMFGORDITEM_STR-PLNDORDERPLANNEDTOTALQTY sy-vline
WA_IPPMFGORDITEM_STR-PLNDORDERPLANNEDSCRAPQTY sy-vline
WA_IPPMFGORDITEM_STR-BUSINESSAREA sy-vline
WA_IPPMFGORDITEM_STR-ACCOUNTASSIGNMENTCATEGORY sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTSEASONYEAR sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTSEASON sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTCOLLECTION sy-vline
WA_IPPMFGORDITEM_STR-PRODUCTTHEME sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.