ABAP Select data from SAP table OIRC_SOCDIP 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 OIRC_SOCDIP 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 OIRC_SOCDIP. 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 OIRC_SOCDIP 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_OIRC_SOCDIP TYPE STANDARD TABLE OF OIRC_SOCDIP, WA_OIRC_SOCDIP TYPE OIRC_SOCDIP, 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: <OIRC_SOCDIP> TYPE OIRC_SOCDIP. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_OIRC_SOCDIP. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM OIRC_SOCDIP INTO TABLE IT_OIRC_SOCDIP. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM OIRC_SOCDIP * INTO TABLE @DATA(IT_OIRC_SOCDIP2). *--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_OIRC_SOCDIP INDEX 1 INTO DATA(WA_OIRC_SOCDIP2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_OIRC_SOCDIP ASSIGNING <OIRC_SOCDIP>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<OIRC_SOCDIP>-MANDT = 1.
<OIRC_SOCDIP>-SOCNR = 1.
<OIRC_SOCDIP>-ETMSTM = 1.
<OIRC_SOCDIP>-SOCEV = 1.
<OIRC_SOCDIP>-SLVNR = 1.
ENDLOOP. LOOP AT IT_OIRC_SOCDIP INTO WA_OIRC_SOCDIP. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_OIRC_SOCDIP-SLVIND, sy-vline,
WA_OIRC_SOCDIP-TOTALHEIGHT, sy-vline,
WA_OIRC_SOCDIP-TOTALHEIGHT_FLTP, sy-vline,
WA_OIRC_SOCDIP-WATERHEIGHT, sy-vline,
WA_OIRC_SOCDIP-WATERHEIGHT_FLTP, sy-vline,
WA_OIRC_SOCDIP-MDICH, sy-vline.
ENDLOOP. *Add any further fields from structure WA_OIRC_SOCDIP 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_OIRC_SOCDIP 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_OIRC_SOCDIP INTO WA_OIRC_SOCDIP. *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 CUNIT, internal->external for field DNSUN CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-DNSUN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-DNSUN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MEINS CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MEINS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MEINS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field SHTEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-SHTEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-SHTEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field VOLUN CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-VOLUN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-VOLUN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field LENUN CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-LENUN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-LENUN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field FDICHEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-FDICHEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-FDICHEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field BDICHEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-BDICHEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-BDICHEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field BHVALEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-BHVALEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-BHVALEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field TSTEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TSTEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TSTEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MTTEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MTTEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MTTEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field TDICHEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TDICHEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TDICHEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MTPRESEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MTPRESEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MTPRESEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field TPREDEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TPREDEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TPREDEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field TPRHVEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TPRHVEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TPRHVEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field TTMPHVEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TTMPHVEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TTMPHVEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field ATPRESEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-ATPRESEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-ATPRESEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field VAPRESEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-VAPRESEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-VAPRESEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field THVALEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-THVALEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-THVALEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MTCOMBTEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MTCOMBTEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MTCOMBTEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MTCOMBPRESEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MTCOMBPRESEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MTCOMBPRESEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field TSTMPCALEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TSTMPCALEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TSTMPCALEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field TPREDCALEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TPREDCALEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TPREDCALEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field BSWCNEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-BSWCNEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-BSWCNEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field GASCOMPRATEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-GASCOMPRATEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-GASCOMPRATEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MOLDENEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MOLDENEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MOLDENEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field MOLWEIGHTEH CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MOLWEIGHTEH IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MOLWEIGHTEH.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field CUSTEH1 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-CUSTEH1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-CUSTEH1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field CUSTEH2 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-CUSTEH2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-CUSTEH2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field CUSTEH3 CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-CUSTEH3 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-CUSTEH3.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field MATNR CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-MATNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-MATNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field TNKNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-TNKNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-TNKNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field LINKYEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-LINKYEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-LINKYEAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PBLNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_OIRC_SOCDIP-PBLNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_OIRC_SOCDIP-PBLNR.
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_OIRC_SOCDIP_STR,
MANDT TYPE STRING,
SOCNR TYPE STRING,
ETMSTM TYPE STRING,
SOCEV TYPE STRING,
SLVNR TYPE STRING,
SLVIND TYPE STRING,
TOTALHEIGHT TYPE STRING,
TOTALHEIGHT_FLTP TYPE STRING,
WATERHEIGHT TYPE STRING,
WATERHEIGHT_FLTP TYPE STRING,
MDICH TYPE STRING,
DNSUN TYPE STRING,
QUAN_SKU TYPE STRING,
MEINS TYPE STRING,
QUAN_LVC TYPE STRING,
WATR_LVC TYPE STRING,
SHTMP TYPE STRING,
SHTEH TYPE STRING,
UL_IN_IND TYPE STRING,
VOLUN TYPE STRING,
LENUN TYPE STRING,
UMRSL TYPE STRING,
CMODE TYPE STRING,
FDICHEH TYPE STRING,
FDICH TYPE STRING,
COEFF TYPE STRING,
BDICHEH TYPE STRING,
BDICH TYPE STRING,
BHVALEH TYPE STRING,
BHVAL TYPE STRING,
TSTMP TYPE STRING,
TSTEH TYPE STRING,
MTTMP TYPE STRING,
MTTEH TYPE STRING,
THVAL TYPE STRING,
TDICHEH TYPE STRING,
TDICH TYPE STRING,
MTPRES TYPE STRING,
MTPRESEH TYPE STRING,
TPRED TYPE STRING,
TPREDEH TYPE STRING,
TPRHV TYPE STRING,
TPRHVEH TYPE STRING,
TTMPHV TYPE STRING,
TTMPHVEH TYPE STRING,
ATPRES TYPE STRING,
ATPRESEH TYPE STRING,
VAPRES TYPE STRING,
VAPRESEH TYPE STRING,
THVALEH TYPE STRING,
MTCOMBTMP TYPE STRING,
MTCOMBTEH TYPE STRING,
MTCOMBPRES TYPE STRING,
MTCOMBPRESEH TYPE STRING,
TSTMPCAL TYPE STRING,
TSTMPCALEH TYPE STRING,
TPREDCAL TYPE STRING,
TPREDCALEH TYPE STRING,
HYDRO TYPE STRING,
ABIND TYPE STRING,
ABFAC TYPE STRING,
MCF TYPE STRING,
BSWCN TYPE STRING,
BSWCNEH TYPE STRING,
HVCLS TYPE STRING,
HVCLS_TO TYPE STRING,
DEFAULT_GUID TYPE STRING,
ERDAT TYPE STRING,
ERZEIT TYPE STRING,
ERNAM TYPE STRING,
AEDAT TYPE STRING,
AEZEIT TYPE STRING,
AENAM TYPE STRING,
BLOIND TYPE STRING,
DELIND TYPE STRING,
CH4RATIO TYPE STRING,
N2RATIO TYPE STRING,
CO2RATIO TYPE STRING,
C2H6RATIO TYPE STRING,
C3H8RATIO TYPE STRING,
H2ORATIO TYPE STRING,
H2SRATIO TYPE STRING,
H2RATIO TYPE STRING,
CORATIO TYPE STRING,
O2RATIO TYPE STRING,
ISOC4H10RATIO TYPE STRING,
NC4H10RATIO TYPE STRING,
ISOC5H12RATIO TYPE STRING,
NC5H12RATIO TYPE STRING,
C6H14RATIO TYPE STRING,
C7H16RATIO TYPE STRING,
C8H18RATIO TYPE STRING,
C9H20RATIO TYPE STRING,
C10H22RATIO TYPE STRING,
HERATIO TYPE STRING,
ARRATIO TYPE STRING,
GASCOMPRATEH TYPE STRING,
MOLDEN TYPE STRING,
MOLDENEH TYPE STRING,
MOLWEIGHT TYPE STRING,
HYDROCARBMOLFRAC TYPE STRING,
MOLWEIGHTEH TYPE STRING,
CUSTPARCHAR1 TYPE STRING,
CUSTPARFLOAT1 TYPE STRING,
CUSTEH1 TYPE STRING,
CUSTPARCHAR2 TYPE STRING,
CUSTPARFLOAT2 TYPE STRING,
CUSTEH2 TYPE STRING,
CUSTPARCHAR3 TYPE STRING,
CUSTPARFLOAT3 TYPE STRING,
CUSTEH3 TYPE STRING,
BUKRS TYPE STRING,
MATNR TYPE STRING,
TNKNR TYPE STRING,
DRDATE TYPE STRING,
DRTIME TYPE STRING,
TIME_ZONE TYPE STRING,
PR_NUMBER TYPE STRING,
WERKS TYPE STRING,
LGORT TYPE STRING,
RELSTOCK TYPE STRING,
QTYPER TYPE STRING,
TOL_STATUS TYPE STRING,
MM_QUAN TYPE STRING,
LINKNR TYPE STRING,
ITLINKNR TYPE STRING,
LINKYEAR TYPE STRING,
CHECK_STATUS TYPE STRING,
ACTSTOCK TYPE STRING,
MM_QUAN_POSTED TYPE STRING,
PROC_ONLINE TYPE STRING,
PBLNR TYPE STRING,
RNBT TYPE STRING,END OF T_EKKO_STR. DATA: WA_OIRC_SOCDIP_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_OIRC_SOCDIP_STR-MANDT sy-vline
WA_OIRC_SOCDIP_STR-SOCNR sy-vline
WA_OIRC_SOCDIP_STR-ETMSTM sy-vline
WA_OIRC_SOCDIP_STR-SOCEV sy-vline
WA_OIRC_SOCDIP_STR-SLVNR sy-vline
WA_OIRC_SOCDIP_STR-SLVIND sy-vline
WA_OIRC_SOCDIP_STR-TOTALHEIGHT sy-vline
WA_OIRC_SOCDIP_STR-TOTALHEIGHT_FLTP sy-vline
WA_OIRC_SOCDIP_STR-WATERHEIGHT sy-vline
WA_OIRC_SOCDIP_STR-WATERHEIGHT_FLTP sy-vline
WA_OIRC_SOCDIP_STR-MDICH sy-vline
WA_OIRC_SOCDIP_STR-DNSUN sy-vline
WA_OIRC_SOCDIP_STR-QUAN_SKU sy-vline
WA_OIRC_SOCDIP_STR-MEINS sy-vline
WA_OIRC_SOCDIP_STR-QUAN_LVC sy-vline
WA_OIRC_SOCDIP_STR-WATR_LVC sy-vline
WA_OIRC_SOCDIP_STR-SHTMP sy-vline
WA_OIRC_SOCDIP_STR-SHTEH sy-vline
WA_OIRC_SOCDIP_STR-UL_IN_IND sy-vline
WA_OIRC_SOCDIP_STR-VOLUN sy-vline
WA_OIRC_SOCDIP_STR-LENUN sy-vline
WA_OIRC_SOCDIP_STR-UMRSL sy-vline
WA_OIRC_SOCDIP_STR-CMODE sy-vline
WA_OIRC_SOCDIP_STR-FDICHEH sy-vline
WA_OIRC_SOCDIP_STR-FDICH sy-vline
WA_OIRC_SOCDIP_STR-COEFF sy-vline
WA_OIRC_SOCDIP_STR-BDICHEH sy-vline
WA_OIRC_SOCDIP_STR-BDICH sy-vline
WA_OIRC_SOCDIP_STR-BHVALEH sy-vline
WA_OIRC_SOCDIP_STR-BHVAL sy-vline
WA_OIRC_SOCDIP_STR-TSTMP sy-vline
WA_OIRC_SOCDIP_STR-TSTEH sy-vline
WA_OIRC_SOCDIP_STR-MTTMP sy-vline
WA_OIRC_SOCDIP_STR-MTTEH sy-vline
WA_OIRC_SOCDIP_STR-THVAL sy-vline
WA_OIRC_SOCDIP_STR-TDICHEH sy-vline
WA_OIRC_SOCDIP_STR-TDICH sy-vline
WA_OIRC_SOCDIP_STR-MTPRES sy-vline
WA_OIRC_SOCDIP_STR-MTPRESEH sy-vline
WA_OIRC_SOCDIP_STR-TPRED sy-vline
WA_OIRC_SOCDIP_STR-TPREDEH sy-vline
WA_OIRC_SOCDIP_STR-TPRHV sy-vline
WA_OIRC_SOCDIP_STR-TPRHVEH sy-vline
WA_OIRC_SOCDIP_STR-TTMPHV sy-vline
WA_OIRC_SOCDIP_STR-TTMPHVEH sy-vline
WA_OIRC_SOCDIP_STR-ATPRES sy-vline
WA_OIRC_SOCDIP_STR-ATPRESEH sy-vline
WA_OIRC_SOCDIP_STR-VAPRES sy-vline
WA_OIRC_SOCDIP_STR-VAPRESEH sy-vline
WA_OIRC_SOCDIP_STR-THVALEH sy-vline
WA_OIRC_SOCDIP_STR-MTCOMBTMP sy-vline
WA_OIRC_SOCDIP_STR-MTCOMBTEH sy-vline
WA_OIRC_SOCDIP_STR-MTCOMBPRES sy-vline
WA_OIRC_SOCDIP_STR-MTCOMBPRESEH sy-vline
WA_OIRC_SOCDIP_STR-TSTMPCAL sy-vline
WA_OIRC_SOCDIP_STR-TSTMPCALEH sy-vline
WA_OIRC_SOCDIP_STR-TPREDCAL sy-vline
WA_OIRC_SOCDIP_STR-TPREDCALEH sy-vline
WA_OIRC_SOCDIP_STR-HYDRO sy-vline
WA_OIRC_SOCDIP_STR-ABIND sy-vline
WA_OIRC_SOCDIP_STR-ABFAC sy-vline
WA_OIRC_SOCDIP_STR-MCF sy-vline
WA_OIRC_SOCDIP_STR-BSWCN sy-vline
WA_OIRC_SOCDIP_STR-BSWCNEH sy-vline
WA_OIRC_SOCDIP_STR-HVCLS sy-vline
WA_OIRC_SOCDIP_STR-HVCLS_TO sy-vline
WA_OIRC_SOCDIP_STR-DEFAULT_GUID sy-vline
WA_OIRC_SOCDIP_STR-ERDAT sy-vline
WA_OIRC_SOCDIP_STR-ERZEIT sy-vline
WA_OIRC_SOCDIP_STR-ERNAM sy-vline
WA_OIRC_SOCDIP_STR-AEDAT sy-vline
WA_OIRC_SOCDIP_STR-AEZEIT sy-vline
WA_OIRC_SOCDIP_STR-AENAM sy-vline
WA_OIRC_SOCDIP_STR-BLOIND sy-vline
WA_OIRC_SOCDIP_STR-DELIND sy-vline
WA_OIRC_SOCDIP_STR-CH4RATIO sy-vline
WA_OIRC_SOCDIP_STR-N2RATIO sy-vline
WA_OIRC_SOCDIP_STR-CO2RATIO sy-vline
WA_OIRC_SOCDIP_STR-C2H6RATIO sy-vline
WA_OIRC_SOCDIP_STR-C3H8RATIO sy-vline
WA_OIRC_SOCDIP_STR-H2ORATIO sy-vline
WA_OIRC_SOCDIP_STR-H2SRATIO sy-vline
WA_OIRC_SOCDIP_STR-H2RATIO sy-vline
WA_OIRC_SOCDIP_STR-CORATIO sy-vline
WA_OIRC_SOCDIP_STR-O2RATIO sy-vline
WA_OIRC_SOCDIP_STR-ISOC4H10RATIO sy-vline
WA_OIRC_SOCDIP_STR-NC4H10RATIO sy-vline
WA_OIRC_SOCDIP_STR-ISOC5H12RATIO sy-vline
WA_OIRC_SOCDIP_STR-NC5H12RATIO sy-vline
WA_OIRC_SOCDIP_STR-C6H14RATIO sy-vline
WA_OIRC_SOCDIP_STR-C7H16RATIO sy-vline
WA_OIRC_SOCDIP_STR-C8H18RATIO sy-vline
WA_OIRC_SOCDIP_STR-C9H20RATIO sy-vline
WA_OIRC_SOCDIP_STR-C10H22RATIO sy-vline
WA_OIRC_SOCDIP_STR-HERATIO sy-vline
WA_OIRC_SOCDIP_STR-ARRATIO sy-vline
WA_OIRC_SOCDIP_STR-GASCOMPRATEH sy-vline
WA_OIRC_SOCDIP_STR-MOLDEN sy-vline
WA_OIRC_SOCDIP_STR-MOLDENEH sy-vline
WA_OIRC_SOCDIP_STR-MOLWEIGHT sy-vline
WA_OIRC_SOCDIP_STR-HYDROCARBMOLFRAC sy-vline
WA_OIRC_SOCDIP_STR-MOLWEIGHTEH sy-vline
WA_OIRC_SOCDIP_STR-CUSTPARCHAR1 sy-vline
WA_OIRC_SOCDIP_STR-CUSTPARFLOAT1 sy-vline
WA_OIRC_SOCDIP_STR-CUSTEH1 sy-vline
WA_OIRC_SOCDIP_STR-CUSTPARCHAR2 sy-vline
WA_OIRC_SOCDIP_STR-CUSTPARFLOAT2 sy-vline
WA_OIRC_SOCDIP_STR-CUSTEH2 sy-vline
WA_OIRC_SOCDIP_STR-CUSTPARCHAR3 sy-vline
WA_OIRC_SOCDIP_STR-CUSTPARFLOAT3 sy-vline
WA_OIRC_SOCDIP_STR-CUSTEH3 sy-vline
WA_OIRC_SOCDIP_STR-BUKRS sy-vline
WA_OIRC_SOCDIP_STR-MATNR sy-vline
WA_OIRC_SOCDIP_STR-TNKNR sy-vline
WA_OIRC_SOCDIP_STR-DRDATE sy-vline
WA_OIRC_SOCDIP_STR-DRTIME sy-vline
WA_OIRC_SOCDIP_STR-TIME_ZONE sy-vline
WA_OIRC_SOCDIP_STR-PR_NUMBER sy-vline
WA_OIRC_SOCDIP_STR-WERKS sy-vline
WA_OIRC_SOCDIP_STR-LGORT sy-vline
WA_OIRC_SOCDIP_STR-RELSTOCK sy-vline
WA_OIRC_SOCDIP_STR-QTYPER sy-vline
WA_OIRC_SOCDIP_STR-TOL_STATUS sy-vline
WA_OIRC_SOCDIP_STR-MM_QUAN sy-vline
WA_OIRC_SOCDIP_STR-LINKNR sy-vline
WA_OIRC_SOCDIP_STR-ITLINKNR sy-vline
WA_OIRC_SOCDIP_STR-LINKYEAR sy-vline
WA_OIRC_SOCDIP_STR-CHECK_STATUS sy-vline
WA_OIRC_SOCDIP_STR-ACTSTOCK sy-vline
WA_OIRC_SOCDIP_STR-MM_QUAN_POSTED sy-vline
WA_OIRC_SOCDIP_STR-PROC_ONLINE sy-vline
WA_OIRC_SOCDIP_STR-PBLNR sy-vline
WA_OIRC_SOCDIP_STR-RNBT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.