ABAP Select data from SAP table CVISUALNOM 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 CVISUALNOM 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 CVISUALNOM. 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 CVISUALNOM 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_CVISUALNOM TYPE STANDARD TABLE OF CVISUALNOM,
      WA_CVISUALNOM TYPE CVISUALNOM,
      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: <CVISUALNOM> TYPE CVISUALNOM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CVISUALNOM
*  INTO TABLE @DATA(IT_CVISUALNOM2).
*--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_CVISUALNOM INDEX 1 INTO DATA(WA_CVISUALNOM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CVISUALNOM ASSIGNING <CVISUALNOM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<CVISUALNOM>-MANDT = 1.
<CVISUALNOM>-NOMINATIONDOC = 1.
<CVISUALNOM>-NOMINATIONDOCITEM = 1.
<CVISUALNOM>-NOMINATIONDOCDISCHARGEITEM = 1.
<CVISUALNOM>-LOCATIONID = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CVISUALNOM-LOCATIONNAME, sy-vline,
WA_CVISUALNOM-LOCATIONDISCHARGEID, sy-vline,
WA_CVISUALNOM-DESTINATIONLOCATIONNAME, sy-vline,
WA_CVISUALNOM-NOMINATIONMODEOFTRANSPORT, sy-vline,
WA_CVISUALNOM-VEHICLEID, sy-vline,
WA_CVISUALNOM-VEHICLEDESCRIPTION, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CVISUALNOM 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_CVISUALNOM 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_CVISUALNOM INTO WA_CVISUALNOM. *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 NOMINATIONDOC CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CVISUALNOM-NOMINATIONDOC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CVISUALNOM-NOMINATIONDOC.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field DISCHARGEDEMANDMATERIALID CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_CVISUALNOM-DISCHARGEDEMANDMATERIALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CVISUALNOM-DISCHARGEDEMANDMATERIALID.
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_CVISUALNOM_STR,
MANDT TYPE STRING,
NOMINATIONDOC TYPE STRING,
NOMINATIONDOCITEM TYPE STRING,
NOMINATIONDOCDISCHARGEITEM TYPE STRING,
LOCATIONID TYPE STRING,
LOCATIONNAME TYPE STRING,
LOCATIONDISCHARGEID TYPE STRING,
DESTINATIONLOCATIONNAME TYPE STRING,
NOMINATIONMODEOFTRANSPORT TYPE STRING,
VEHICLEID TYPE STRING,
VEHICLEDESCRIPTION TYPE STRING,
TRANSPORTSYSTEM TYPE STRING,
MODEOFTRANSPORTTEXT TYPE STRING,
NOMINATIONHEADERSTATUS TYPE STRING,
NOMINATIONEXTNUMBER TYPE STRING,
NOMINATIONTYPE TYPE STRING,
SCHEDULEDMATERIAL TYPE STRING,
MATERIALDESC TYPE STRING,
MATERIALGROUP TYPE STRING,
MATERIALGROUPNAME TYPE STRING,
PRODUCTHIERARCHY TYPE STRING,
PRODUCTHIERARCHYNAME TYPE STRING,
NOMINATIONCARRIER TYPE STRING,
CARRIERNAME TYPE STRING,
COMPANYCODE TYPE STRING,
SCHEDULEDBATCHSTARTDATETIME TYPE STRING,
NOMINATIONSCHEDULEDATE TYPE STRING,
NOMINATIONSCHEDULEDTIME TYPE STRING,
DISCHARGEBATCHSTARTDATETIME TYPE STRING,
PLANNEDDISCHARGEDATE TYPE STRING,
NOMINATIONDISCHARGETIME TYPE STRING,
SCHEDULEDBATCHENDDATETIME TYPE STRING,
NOMINATIONEVENTCHANGEDDATE TYPE STRING,
NOMINATIONEVENTCHANGEDTIME TYPE STRING,
SCHEDULEDQUANTITY TYPE STRING,
SCHEDULEDQUANTITYUNIT TYPE STRING,
ACTUALSCHEDULEDQUANTITY TYPE STRING,
ACTUALSCHEDULEDQUANTITYUNIT TYPE STRING,
DISCHARGESCHEDQUANTITY TYPE STRING,
DISCHARGEQUANTITYUNIT TYPE STRING,
ACTUALDISCHARGEQUANTITY TYPE STRING,
ACTUALDISCHARGEQUANTITYUNIT TYPE STRING,
ISREFERENCEDOCUMENT TYPE STRING,
NOMINATIONSCHEDULETYPE TYPE STRING,
NOMINATIONREFERENCEDOCUMENT TYPE STRING,
NOMINATIONREFERENCEDOCITEM TYPE STRING,
NOMINATIONREFERENCEDOCTYPE TYPE STRING,
DISCHARGEREFERENCEDOCUMENT TYPE STRING,
NOMINATIONDISCHARGESCHEDTYPE TYPE STRING,
CONTRACTPARTNER TYPE STRING,
LOCATIONPARTNER TYPE STRING,
LOCATIONPLANT TYPE STRING,
DISCHARGECONTRACTPARTNER TYPE STRING,
DISCHARGELOCATIONPARTNER TYPE STRING,
DISCHARGELOCATIONPLANT TYPE STRING,
CUSTOMER TYPE STRING,
CUSTOMERNAME TYPE STRING,
CUSTADDRESSNUMBER TYPE STRING,
CUSTOMERCITYNAME TYPE STRING,
CUSTOMERCOUNTRY TYPE STRING,
ADDRESSNUMBER TYPE STRING,
SUPPLIERACCOUNT TYPE STRING,
SUPPLIERNAME TYPE STRING,
SUPPLIERCITYNAME TYPE STRING,
SOURCELOCATIONCOUNTRY TYPE STRING,
CITYNAME TYPE STRING,
COUNTRYNAME TYPE STRING,
REGION TYPE STRING,
FROMLATITUDE TYPE STRING,
FROMLONGITUDE TYPE STRING,
TOLATITUDE TYPE STRING,
TOLONGITUDE TYPE STRING,
CONNECTIONPOINTS TYPE STRING,
LOCATIONPOSITION TYPE STRING,
SHIPPINGROUTE TYPE STRING,
ISALERT TYPE STRING,
ALERTTEXT TYPE STRING,
DISCHARGEQTYALERTTEXT TYPE STRING,
ISLOADTIMEALERT TYPE STRING,
LOADTIMEALERTTEXT TYPE STRING,
ISDISCHARGETIMEALERT TYPE STRING,
DISCHARGETIMEALERTTEXT TYPE STRING,
ISLOCATIONALERT TYPE STRING,
LOCATIONALERTDESC TYPE STRING,
ISDISCHARGELOCALERT TYPE STRING,
DISCHARGELOCALERTDESC TYPE STRING,
SAFETYSTOCK TYPE STRING,
CAPACITYSTOCK TYPE STRING,
NOMINATIONEVENTNUMBER TYPE STRING,
NOMINATIONEVENTTYPE TYPE STRING,
NOMINATIONEVENTSEQUENCE TYPE STRING,
ACTUALSTARTDATEFROM TYPE STRING,
ACTUALSTARTTIMEFROM TYPE STRING,
ACTUALSTARTDATETIME TYPE STRING,
DISCHARGEEVENTNUMBER TYPE STRING,
DISCHARGEEVENTTYPE TYPE STRING,
DISCHARGEDATE TYPE STRING,
DISCHARGETIME TYPE STRING,
DISCHARGESTARTDATETIME TYPE STRING,
ACTUALENDDATETO TYPE STRING,
NOMINATIONTICKETLOADSTARTDATE TYPE STRING,
NOMINATIONTICKETLOADSTARTTIME TYPE STRING,
NOMINATIONTICKETDISCHARGEDATE TYPE STRING,
NOMINATIONTICKETDISCHARGETIME TYPE STRING,
DESTINATIONLOCATION TYPE STRING,
ROUTETEXT TYPE STRING,
ISLOAD TYPE STRING,
ISNOMINATIONDOCITEM TYPE STRING,
ISPEGGED TYPE STRING,
ISVARIANT TYPE STRING,
ISNOMINATIONLOAD TYPE STRING,
ISNOMINATIONDISCHARGE TYPE STRING,
BUSINESSPARTNERROLETYPE TYPE STRING,
VALUATIONTYPE TYPE STRING,
NOMINATIONPEGID TYPE STRING,
NOMINATIONPEGGINGTYPEUSAGE TYPE STRING,
TRANSSHIPMENTGROUPID TYPE STRING,
ISNOMINATIONACTUAL TYPE STRING,
ISBOOKEDTRANSPORTSYSTEM TYPE STRING,
NOMINATIONITEMISCOMPLETE TYPE STRING,
NOMINATIONITEMSTATUS TYPE STRING,
NOMINATIONITEMSTATUSDESC TYPE STRING,
DISCHARGENOMINATIONITEMSTATUS TYPE STRING,
ITEMDISCHARGESTATUSTEXT TYPE STRING,
INDICATORVALUE TYPE STRING,
NOTIFICATIONSTATUSOBJECT TYPE STRING,
STATUSOBJECT TYPE STRING,
NOTIFICATIONDATETIME TYPE STRING,
NOTIFICATIONTEXT TYPE STRING,
MAINTENANCENOTIFICATIONTEXT TYPE STRING,
ISCLOUDSYSTEM TYPE STRING,
SIMULATION TYPE STRING,
COMMENTS TYPE STRING,
LOADDEMANDMATERIALID TYPE STRING,
DISCHARGEDEMANDMATERIALID TYPE STRING,
LOADDEMANDMATERIALDESC TYPE STRING,
DISCHARGEDEMANDMATERIALDESC TYPE STRING,
SHIPMENTLOADCOST TYPE STRING,
SHIPMENTLOADCOSTCRCY TYPE STRING,
SHIPMENTDISCHARGECOST TYPE STRING,
SHIPMENTDISCHARGECOSTCRCY TYPE STRING,END OF T_EKKO_STR. DATA: WA_CVISUALNOM_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_CVISUALNOM_STR-MANDT sy-vline
WA_CVISUALNOM_STR-NOMINATIONDOC sy-vline
WA_CVISUALNOM_STR-NOMINATIONDOCITEM sy-vline
WA_CVISUALNOM_STR-NOMINATIONDOCDISCHARGEITEM sy-vline
WA_CVISUALNOM_STR-LOCATIONID sy-vline
WA_CVISUALNOM_STR-LOCATIONNAME sy-vline
WA_CVISUALNOM_STR-LOCATIONDISCHARGEID sy-vline
WA_CVISUALNOM_STR-DESTINATIONLOCATIONNAME sy-vline
WA_CVISUALNOM_STR-NOMINATIONMODEOFTRANSPORT sy-vline
WA_CVISUALNOM_STR-VEHICLEID sy-vline
WA_CVISUALNOM_STR-VEHICLEDESCRIPTION sy-vline
WA_CVISUALNOM_STR-TRANSPORTSYSTEM sy-vline
WA_CVISUALNOM_STR-MODEOFTRANSPORTTEXT sy-vline
WA_CVISUALNOM_STR-NOMINATIONHEADERSTATUS sy-vline
WA_CVISUALNOM_STR-NOMINATIONEXTNUMBER sy-vline
WA_CVISUALNOM_STR-NOMINATIONTYPE sy-vline
WA_CVISUALNOM_STR-SCHEDULEDMATERIAL sy-vline
WA_CVISUALNOM_STR-MATERIALDESC sy-vline
WA_CVISUALNOM_STR-MATERIALGROUP sy-vline
WA_CVISUALNOM_STR-MATERIALGROUPNAME sy-vline
WA_CVISUALNOM_STR-PRODUCTHIERARCHY sy-vline
WA_CVISUALNOM_STR-PRODUCTHIERARCHYNAME sy-vline
WA_CVISUALNOM_STR-NOMINATIONCARRIER sy-vline
WA_CVISUALNOM_STR-CARRIERNAME sy-vline
WA_CVISUALNOM_STR-COMPANYCODE sy-vline
WA_CVISUALNOM_STR-SCHEDULEDBATCHSTARTDATETIME sy-vline
WA_CVISUALNOM_STR-NOMINATIONSCHEDULEDATE sy-vline
WA_CVISUALNOM_STR-NOMINATIONSCHEDULEDTIME sy-vline
WA_CVISUALNOM_STR-DISCHARGEBATCHSTARTDATETIME sy-vline
WA_CVISUALNOM_STR-PLANNEDDISCHARGEDATE sy-vline
WA_CVISUALNOM_STR-NOMINATIONDISCHARGETIME sy-vline
WA_CVISUALNOM_STR-SCHEDULEDBATCHENDDATETIME sy-vline
WA_CVISUALNOM_STR-NOMINATIONEVENTCHANGEDDATE sy-vline
WA_CVISUALNOM_STR-NOMINATIONEVENTCHANGEDTIME sy-vline
WA_CVISUALNOM_STR-SCHEDULEDQUANTITY sy-vline
WA_CVISUALNOM_STR-SCHEDULEDQUANTITYUNIT sy-vline
WA_CVISUALNOM_STR-ACTUALSCHEDULEDQUANTITY sy-vline
WA_CVISUALNOM_STR-ACTUALSCHEDULEDQUANTITYUNIT sy-vline
WA_CVISUALNOM_STR-DISCHARGESCHEDQUANTITY sy-vline
WA_CVISUALNOM_STR-DISCHARGEQUANTITYUNIT sy-vline
WA_CVISUALNOM_STR-ACTUALDISCHARGEQUANTITY sy-vline
WA_CVISUALNOM_STR-ACTUALDISCHARGEQUANTITYUNIT sy-vline
WA_CVISUALNOM_STR-ISREFERENCEDOCUMENT sy-vline
WA_CVISUALNOM_STR-NOMINATIONSCHEDULETYPE sy-vline
WA_CVISUALNOM_STR-NOMINATIONREFERENCEDOCUMENT sy-vline
WA_CVISUALNOM_STR-NOMINATIONREFERENCEDOCITEM sy-vline
WA_CVISUALNOM_STR-NOMINATIONREFERENCEDOCTYPE sy-vline
WA_CVISUALNOM_STR-DISCHARGEREFERENCEDOCUMENT sy-vline
WA_CVISUALNOM_STR-NOMINATIONDISCHARGESCHEDTYPE sy-vline
WA_CVISUALNOM_STR-CONTRACTPARTNER sy-vline
WA_CVISUALNOM_STR-LOCATIONPARTNER sy-vline
WA_CVISUALNOM_STR-LOCATIONPLANT sy-vline
WA_CVISUALNOM_STR-DISCHARGECONTRACTPARTNER sy-vline
WA_CVISUALNOM_STR-DISCHARGELOCATIONPARTNER sy-vline
WA_CVISUALNOM_STR-DISCHARGELOCATIONPLANT sy-vline
WA_CVISUALNOM_STR-CUSTOMER sy-vline
WA_CVISUALNOM_STR-CUSTOMERNAME sy-vline
WA_CVISUALNOM_STR-CUSTADDRESSNUMBER sy-vline
WA_CVISUALNOM_STR-CUSTOMERCITYNAME sy-vline
WA_CVISUALNOM_STR-CUSTOMERCOUNTRY sy-vline
WA_CVISUALNOM_STR-ADDRESSNUMBER sy-vline
WA_CVISUALNOM_STR-SUPPLIERACCOUNT sy-vline
WA_CVISUALNOM_STR-SUPPLIERNAME sy-vline
WA_CVISUALNOM_STR-SUPPLIERCITYNAME sy-vline
WA_CVISUALNOM_STR-SOURCELOCATIONCOUNTRY sy-vline
WA_CVISUALNOM_STR-CITYNAME sy-vline
WA_CVISUALNOM_STR-COUNTRYNAME sy-vline
WA_CVISUALNOM_STR-REGION sy-vline
WA_CVISUALNOM_STR-FROMLATITUDE sy-vline
WA_CVISUALNOM_STR-FROMLONGITUDE sy-vline
WA_CVISUALNOM_STR-TOLATITUDE sy-vline
WA_CVISUALNOM_STR-TOLONGITUDE sy-vline
WA_CVISUALNOM_STR-CONNECTIONPOINTS sy-vline
WA_CVISUALNOM_STR-LOCATIONPOSITION sy-vline
WA_CVISUALNOM_STR-SHIPPINGROUTE sy-vline
WA_CVISUALNOM_STR-ISALERT sy-vline
WA_CVISUALNOM_STR-ALERTTEXT sy-vline
WA_CVISUALNOM_STR-DISCHARGEQTYALERTTEXT sy-vline
WA_CVISUALNOM_STR-ISLOADTIMEALERT sy-vline
WA_CVISUALNOM_STR-LOADTIMEALERTTEXT sy-vline
WA_CVISUALNOM_STR-ISDISCHARGETIMEALERT sy-vline
WA_CVISUALNOM_STR-DISCHARGETIMEALERTTEXT sy-vline
WA_CVISUALNOM_STR-ISLOCATIONALERT sy-vline
WA_CVISUALNOM_STR-LOCATIONALERTDESC sy-vline
WA_CVISUALNOM_STR-ISDISCHARGELOCALERT sy-vline
WA_CVISUALNOM_STR-DISCHARGELOCALERTDESC sy-vline
WA_CVISUALNOM_STR-SAFETYSTOCK sy-vline
WA_CVISUALNOM_STR-CAPACITYSTOCK sy-vline
WA_CVISUALNOM_STR-NOMINATIONEVENTNUMBER sy-vline
WA_CVISUALNOM_STR-NOMINATIONEVENTTYPE sy-vline
WA_CVISUALNOM_STR-NOMINATIONEVENTSEQUENCE sy-vline
WA_CVISUALNOM_STR-ACTUALSTARTDATEFROM sy-vline
WA_CVISUALNOM_STR-ACTUALSTARTTIMEFROM sy-vline
WA_CVISUALNOM_STR-ACTUALSTARTDATETIME sy-vline
WA_CVISUALNOM_STR-DISCHARGEEVENTNUMBER sy-vline
WA_CVISUALNOM_STR-DISCHARGEEVENTTYPE sy-vline
WA_CVISUALNOM_STR-DISCHARGEDATE sy-vline
WA_CVISUALNOM_STR-DISCHARGETIME sy-vline
WA_CVISUALNOM_STR-DISCHARGESTARTDATETIME sy-vline
WA_CVISUALNOM_STR-ACTUALENDDATETO sy-vline
WA_CVISUALNOM_STR-NOMINATIONTICKETLOADSTARTDATE sy-vline
WA_CVISUALNOM_STR-NOMINATIONTICKETLOADSTARTTIME sy-vline
WA_CVISUALNOM_STR-NOMINATIONTICKETDISCHARGEDATE sy-vline
WA_CVISUALNOM_STR-NOMINATIONTICKETDISCHARGETIME sy-vline
WA_CVISUALNOM_STR-DESTINATIONLOCATION sy-vline
WA_CVISUALNOM_STR-ROUTETEXT sy-vline
WA_CVISUALNOM_STR-ISLOAD sy-vline
WA_CVISUALNOM_STR-ISNOMINATIONDOCITEM sy-vline
WA_CVISUALNOM_STR-ISPEGGED sy-vline
WA_CVISUALNOM_STR-ISVARIANT sy-vline
WA_CVISUALNOM_STR-ISNOMINATIONLOAD sy-vline
WA_CVISUALNOM_STR-ISNOMINATIONDISCHARGE sy-vline
WA_CVISUALNOM_STR-BUSINESSPARTNERROLETYPE sy-vline
WA_CVISUALNOM_STR-VALUATIONTYPE sy-vline
WA_CVISUALNOM_STR-NOMINATIONPEGID sy-vline
WA_CVISUALNOM_STR-NOMINATIONPEGGINGTYPEUSAGE sy-vline
WA_CVISUALNOM_STR-TRANSSHIPMENTGROUPID sy-vline
WA_CVISUALNOM_STR-ISNOMINATIONACTUAL sy-vline
WA_CVISUALNOM_STR-ISBOOKEDTRANSPORTSYSTEM sy-vline
WA_CVISUALNOM_STR-NOMINATIONITEMISCOMPLETE sy-vline
WA_CVISUALNOM_STR-NOMINATIONITEMSTATUS sy-vline
WA_CVISUALNOM_STR-NOMINATIONITEMSTATUSDESC sy-vline
WA_CVISUALNOM_STR-DISCHARGENOMINATIONITEMSTATUS sy-vline
WA_CVISUALNOM_STR-ITEMDISCHARGESTATUSTEXT sy-vline
WA_CVISUALNOM_STR-INDICATORVALUE sy-vline
WA_CVISUALNOM_STR-NOTIFICATIONSTATUSOBJECT sy-vline
WA_CVISUALNOM_STR-STATUSOBJECT sy-vline
WA_CVISUALNOM_STR-NOTIFICATIONDATETIME sy-vline
WA_CVISUALNOM_STR-NOTIFICATIONTEXT sy-vline
WA_CVISUALNOM_STR-MAINTENANCENOTIFICATIONTEXT sy-vline
WA_CVISUALNOM_STR-ISCLOUDSYSTEM sy-vline
WA_CVISUALNOM_STR-SIMULATION sy-vline
WA_CVISUALNOM_STR-COMMENTS sy-vline
WA_CVISUALNOM_STR-LOADDEMANDMATERIALID sy-vline
WA_CVISUALNOM_STR-DISCHARGEDEMANDMATERIALID sy-vline
WA_CVISUALNOM_STR-LOADDEMANDMATERIALDESC sy-vline
WA_CVISUALNOM_STR-DISCHARGEDEMANDMATERIALDESC sy-vline
WA_CVISUALNOM_STR-SHIPMENTLOADCOST sy-vline
WA_CVISUALNOM_STR-SHIPMENTLOADCOSTCRCY sy-vline
WA_CVISUALNOM_STR-SHIPMENTDISCHARGECOST sy-vline
WA_CVISUALNOM_STR-SHIPMENTDISCHARGECOSTCRCY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.