ABAP Select data from SAP table FKKBIXINVBILL_I_DATA 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 FKKBIXINVBILL_I_DATA 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 FKKBIXINVBILL_I_DATA. 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 FKKBIXINVBILL_I_DATA 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_FKKBIXINVBILL_I_DATA TYPE STANDARD TABLE OF FKKBIXINVBILL_I_DATA,
      WA_FKKBIXINVBILL_I_DATA TYPE FKKBIXINVBILL_I_DATA,
      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: <FKKBIXINVBILL_I_DATA> TYPE FKKBIXINVBILL_I_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FKKBIXINVBILL_I_DATA
*  INTO TABLE @DATA(IT_FKKBIXINVBILL_I_DATA2).
*--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_FKKBIXINVBILL_I_DATA INDEX 1 INTO DATA(WA_FKKBIXINVBILL_I_DATA2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FKKBIXINVBILL_I_DATA ASSIGNING <FKKBIXINVBILL_I_DATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FKKBIXINVBILL_I_DATA>-BILLDOCNO = 1.
<FKKBIXINVBILL_I_DATA>-REFITEM = 1.
<FKKBIXINVBILL_I_DATA>-BILLDOCITEM = 1.
<FKKBIXINVBILL_I_DATA>-ITEMTYPE = 1.
<FKKBIXINVBILL_I_DATA>-REFITEM = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FKKBIXINVBILL_I_DATA-BILL_AMOUNT, sy-vline,
WA_FKKBIXINVBILL_I_DATA-ITEMTYPE, sy-vline,
WA_FKKBIXINVBILL_I_DATA-BILL_CURR, sy-vline,
WA_FKKBIXINVBILL_I_DATA-BILL_AMOUNT, sy-vline,
WA_FKKBIXINVBILL_I_DATA-ITEM_SIMULATED, sy-vline,
WA_FKKBIXINVBILL_I_DATA-BILL_CURR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FKKBIXINVBILL_I_DATA 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_FKKBIXINVBILL_I_DATA 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_FKKBIXINVBILL_I_DATA INTO WA_FKKBIXINVBILL_I_DATA. *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 SEGMT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FKKBIXINVBILL_I_DATA-SEGMT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FKKBIXINVBILL_I_DATA-SEGMT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field VTREF CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FKKBIXINVBILL_I_DATA-VTREF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FKKBIXINVBILL_I_DATA-VTREF.
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_FKKBIXINVBILL_I_DATA_STR,
BILLDOCNO TYPE STRING,
REFITEM TYPE STRING,
BILLDOCITEM TYPE STRING,
ITEMTYPE TYPE STRING,
REFITEM TYPE STRING,
BILL_AMOUNT TYPE STRING,
ITEMTYPE TYPE STRING,
BILL_CURR TYPE STRING,
BILL_AMOUNT TYPE STRING,
ITEM_SIMULATED TYPE STRING,
BILL_CURR TYPE STRING,
REVERSALITEM TYPE STRING,
POSTREL TYPE STRING,
ITEM_SIMULATED TYPE STRING,
NOT_BPREL TYPE STRING,
REVERSALITEM TYPE STRING,
CORRCAT TYPE STRING,
PRINTREL TYPE STRING,
POSTREL TYPE STRING,
PRINT_SUBSTITUTE TYPE STRING,
DATE_FROM TYPE STRING,
NOT_BPREL TYPE STRING,
DATE_TO TYPE STRING,
PRINTREL TYPE STRING,
FAEDN TYPE STRING,
PRINT_SUBSTITUTE TYPE STRING,
SPART TYPE STRING,
DATE_FROM TYPE STRING,
BUKRS TYPE STRING,
DATE_TO TYPE STRING,
FAEDN TYPE STRING,
GSBER TYPE STRING,
SEGMT TYPE STRING,
SPART TYPE STRING,
BUKRS TYPE STRING,
PRCTR TYPE STRING,
GSBER TYPE STRING,
HVORG TYPE STRING,
BUPLA TYPE STRING,
TVORG TYPE STRING,
KOFIZ TYPE STRING,
SEGMT TYPE STRING,
PRCTR TYPE STRING,
TAX_DET_TYPE TYPE STRING,
HVORG TYPE STRING,
TAX_COUNTRY TYPE STRING,
TVORG TYPE STRING,
TAX_DATE_TYPE TYPE STRING,
KOFIZ TYPE STRING,
TAX_INCLUDED TYPE STRING,
TAX_GROUP TYPE STRING,
TAX_DET_TYPE TYPE STRING,
TAX_COUNTRY TYPE STRING,
EXT_TAX_DATE TYPE STRING,
ERMWSKZ TYPE STRING,
TAX_DATE_TYPE TYPE STRING,
MWSKZ TYPE STRING,
TAX_INCLUDED TYPE STRING,
TAX_GROUP TYPE STRING,
ERMWSKZ_B2B TYPE STRING,
MWSKZ_B2B TYPE STRING,
EXT_TAX_DATE TYPE STRING,
STRKZ TYPE STRING,
ERMWSKZ TYPE STRING,
MWSKZ TYPE STRING,
TXJCD TYPE STRING,
XANZA TYPE STRING,
ERMWSKZ_B2B TYPE STRING,
STAKZ TYPE STRING,
MWSKZ_B2B TYPE STRING,
STRKZ TYPE STRING,
DEFREV_CAT TYPE STRING,
TXJCD TYPE STRING,
DEFREV_PDATE TYPE STRING,
QSSKZ TYPE STRING,
QTY_UNIT TYPE STRING,
XANZA TYPE STRING,
QTY_BW_REL TYPE STRING,
STAKZ TYPE STRING,
QTY_FI_CO_REL TYPE STRING,
VTREF TYPE STRING,
DEFREV_CAT TYPE STRING,
VTPOS TYPE STRING,
DEFREV_PDATE TYPE STRING,
SUBAP TYPE STRING,
DEFREV_STAT TYPE STRING,
RAREL TYPE STRING,
PREPAID TYPE STRING,
PPREFILL TYPE STRING,
BILLAC_TYPE TYPE STRING,
PSCAT TYPE STRING,
SERVICE_TYPE TYPE STRING,
QTY_UNIT TYPE STRING,
ITEM_CRMET TYPE STRING,
QTY_BW_REL TYPE STRING,
BILL_FUNCTION TYPE STRING,
ADD_GROUP TYPE STRING,
QTY_FI_CO_REL TYPE STRING,
PY_GROUP TYPE STRING,
ALTMD_ORIG TYPE STRING,
VTREF TYPE STRING,
SRC_GROUP TYPE STRING,
VTPOS TYPE STRING,
DISC_GROUP TYPE STRING,
SUBAP TYPE STRING,
DISCKEY TYPE STRING,
PREPAID TYPE STRING,
PPREFILL TYPE STRING,
DISCKEY_VERSNO TYPE STRING,
PSCAT TYPE STRING,
DITTYPE TYPE STRING,
BILLACCOUNT TYPE STRING,
ITEM_CRMET TYPE STRING,
BILLITEM_FROM TYPE STRING,
BILLITEM_TO TYPE STRING,
BILL_FUNCTION TYPE STRING,
ADD_GROUP TYPE STRING,
BILLRATECAT TYPE STRING,
BILLRATE TYPE STRING,
PY_GROUP TYPE STRING,
SRC_GROUP TYPE STRING,
BILLRATEITEM TYPE STRING,
BILLINGCAT TYPE STRING,
DISC_GROUP TYPE STRING,
SEC_REASON TYPE STRING,
BILLPROCEDURE TYPE STRING,
BILLREQRSN TYPE STRING,
BILLPERTYPE TYPE STRING,
QUANTITY TYPE STRING,
DISCKEY TYPE STRING,
DISCKEY_VERSNO TYPE STRING,
CONDITION_TYPE TYPE STRING,
QUANTITY TYPE STRING,END OF T_EKKO_STR. DATA: WA_FKKBIXINVBILL_I_DATA_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_FKKBIXINVBILL_I_DATA_STR-BILLDOCNO sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-REFITEM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLDOCITEM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ITEMTYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-REFITEM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILL_AMOUNT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ITEMTYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILL_CURR sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILL_AMOUNT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ITEM_SIMULATED sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILL_CURR sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-REVERSALITEM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-POSTREL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ITEM_SIMULATED sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-NOT_BPREL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-REVERSALITEM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-CORRCAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PRINTREL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-POSTREL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PRINT_SUBSTITUTE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DATE_FROM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-NOT_BPREL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DATE_TO sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PRINTREL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-FAEDN sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PRINT_SUBSTITUTE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SPART sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DATE_FROM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BUKRS sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DATE_TO sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-FAEDN sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-GSBER sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SEGMT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SPART sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BUKRS sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PRCTR sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-GSBER sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-HVORG sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BUPLA sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TVORG sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-KOFIZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SEGMT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PRCTR sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_DET_TYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-HVORG sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_COUNTRY sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TVORG sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_DATE_TYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-KOFIZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_INCLUDED sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_DET_TYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_COUNTRY sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-EXT_TAX_DATE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ERMWSKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_DATE_TYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-MWSKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_INCLUDED sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TAX_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ERMWSKZ_B2B sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-MWSKZ_B2B sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-EXT_TAX_DATE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-STRKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ERMWSKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-MWSKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TXJCD sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-XANZA sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ERMWSKZ_B2B sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-STAKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-MWSKZ_B2B sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-STRKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DEFREV_CAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-TXJCD sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DEFREV_PDATE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QSSKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QTY_UNIT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-XANZA sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QTY_BW_REL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-STAKZ sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QTY_FI_CO_REL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-VTREF sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DEFREV_CAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-VTPOS sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DEFREV_PDATE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SUBAP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DEFREV_STAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-RAREL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PREPAID sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PPREFILL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLAC_TYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PSCAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SERVICE_TYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QTY_UNIT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ITEM_CRMET sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QTY_BW_REL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILL_FUNCTION sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ADD_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QTY_FI_CO_REL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PY_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ALTMD_ORIG sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-VTREF sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SRC_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-VTPOS sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DISC_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SUBAP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DISCKEY sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PREPAID sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PPREFILL sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DISCKEY_VERSNO sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PSCAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DITTYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLACCOUNT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ITEM_CRMET sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLITEM_FROM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLITEM_TO sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILL_FUNCTION sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-ADD_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLRATECAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLRATE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-PY_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SRC_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLRATEITEM sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLINGCAT sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DISC_GROUP sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-SEC_REASON sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLPROCEDURE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLREQRSN sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-BILLPERTYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QUANTITY sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DISCKEY sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-DISCKEY_VERSNO sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-CONDITION_TYPE sy-vline
WA_FKKBIXINVBILL_I_DATA_STR-QUANTITY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.