ABAP Select data from SAP table P41_P0542 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 P41_P0542 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 P41_P0542. 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 P41_P0542 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_P41_P0542 TYPE STANDARD TABLE OF P41_P0542,
      WA_P41_P0542 TYPE P41_P0542,
      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: <P41_P0542> TYPE P41_P0542.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM P41_P0542
*  INTO TABLE @DATA(IT_P41_P05422).
*--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_P41_P0542 INDEX 1 INTO DATA(WA_P41_P05422).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_P41_P0542 ASSIGNING <P41_P0542>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<P41_P0542>-PERNR = 1.
<P41_P0542>-INFTY = 1.
<P41_P0542>-SUBTY = 1.
<P41_P0542>-OBJPS = 1.
<P41_P0542>-SPRPS = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_P41_P0542-ENDDA, sy-vline,
WA_P41_P0542-BEGDA, sy-vline,
WA_P41_P0542-SEQNR, sy-vline,
WA_P41_P0542-AEDTM, sy-vline,
WA_P41_P0542-UNAME, sy-vline,
WA_P41_P0542-HISTO, sy-vline.
ENDLOOP. *Add any further fields from structure WA_P41_P0542 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_P41_P0542 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_P41_P0542 INTO WA_P41_P0542. *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.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_P41_P0542_STR,
PERNR TYPE STRING,
INFTY TYPE STRING,
SUBTY TYPE STRING,
OBJPS TYPE STRING,
SPRPS TYPE STRING,
ENDDA TYPE STRING,
BEGDA TYPE STRING,
SEQNR TYPE STRING,
AEDTM TYPE STRING,
UNAME TYPE STRING,
HISTO TYPE STRING,
ITXEX TYPE STRING,
REFEX TYPE STRING,
ORDEX TYPE STRING,
ITBLD TYPE STRING,
PREAS TYPE STRING,
FLAG1 TYPE STRING,
FLAG2 TYPE STRING,
FLAG3 TYPE STRING,
FLAG4 TYPE STRING,
RESE1 TYPE STRING,
RESE2 TYPE STRING,
GRPVL TYPE STRING,
PREVCOMPANYNAME1 TYPE STRING,
PREVCOMPBUSNSNO1 TYPE STRING,
PREVCOMPSALARY1 TYPE STRING,
PREVCOMPBONUS1 TYPE STRING,
PCOMPPREPDINCTX1 TYPE STRING,
PCOMPPREPDRESTX1 TYPE STRING,
PREPDNONTXOVERS1 TYPE STRING,
PREPAIDNONTAXOT1 TYPE STRING,
PRPDOTHRNOTXINC1 TYPE STRING,
MEDLABRINSURNCE1 TYPE STRING,
EMPLOYEINSURNCE1 TYPE STRING,
FIELDENGDEDUCTN1 TYPE STRING,
EXEMPTFOREIGNPC1 TYPE STRING,
EXPTAMTFORGNEMP1 TYPE STRING,
PREVCOMPANYNAME2 TYPE STRING,
PREVCOMPBUSNSNO2 TYPE STRING,
PREVCOMPSALARY2 TYPE STRING,
PREVCOMPBONUS2 TYPE STRING,
PCOMPPREPDINCTX2 TYPE STRING,
PCOMPPREPDRESTX2 TYPE STRING,
PREPDNONTXOVERS2 TYPE STRING,
PREPAIDNONTAXOT2 TYPE STRING,
PRPDOTHRNOTXINC2 TYPE STRING,
MEDLABRINSURNCE2 TYPE STRING,
EMPLOYEINSURNCE2 TYPE STRING,
FIELDENGDEDUCTN2 TYPE STRING,
EXEMPTFOREIGNPC2 TYPE STRING,
EXPTAMTFORGNEMP2 TYPE STRING,
PREVCOMPANYNAME3 TYPE STRING,
PREVCOMPBUSNSNO3 TYPE STRING,
PREVCOMPSALARY3 TYPE STRING,
PREVCOMPBONUS3 TYPE STRING,
PCOMPPREPDINCTX3 TYPE STRING,
PCOMPPREPDRESTX3 TYPE STRING,
PREPDNONTXOVERS3 TYPE STRING,
PREPAIDNONTAXOT3 TYPE STRING,
PRPDOTHRNOTXINC3 TYPE STRING,
MEDLABRINSURNCE3 TYPE STRING,
EMPLOYEINSURNCE3 TYPE STRING,
FIELDENGDEDUCTN3 TYPE STRING,
EXEMPTFOREIGNPC3 TYPE STRING,
EXPTAMTFORGNEMP3 TYPE STRING,
PREVCOMPANYNAME4 TYPE STRING,
PREVCOMPBUSNSNO4 TYPE STRING,
PREVCOMPSALARY4 TYPE STRING,
PREVCOMPBONUS4 TYPE STRING,
PCOMPPREPDINCTX4 TYPE STRING,
PCOMPPREPDRESTX4 TYPE STRING,
PREPDNONTXOVERS4 TYPE STRING,
PREPAIDNONTAXOT4 TYPE STRING,
PRPDOTHRNOTXINC4 TYPE STRING,
MEDLABRINSURNCE4 TYPE STRING,
EMPLOYEINSURNCE4 TYPE STRING,
FIELDENGDEDUCTN4 TYPE STRING,
EXEMPTFOREIGNPC4 TYPE STRING,
EXPTAMTFORGNEMP4 TYPE STRING,
PREVCOMPANYNAME5 TYPE STRING,
PREVCOMPBUSNSNO5 TYPE STRING,
PREVCOMPSALARY5 TYPE STRING,
PREVCOMPBONUS5 TYPE STRING,
PCOMPPREPDINCTX5 TYPE STRING,
PCOMPPREPDRESTX5 TYPE STRING,
PREPDNONTXOVERS5 TYPE STRING,
PREPAIDNONTAXOT5 TYPE STRING,
PRPDOTHRNOTXINC5 TYPE STRING,
MEDLABRINSURNCE5 TYPE STRING,
EMPLOYEINSURNCE5 TYPE STRING,
FIELDENGDEDUCTN5 TYPE STRING,
EXEMPTFOREIGNPC5 TYPE STRING,
EXPTAMTFORGNEMP5 TYPE STRING,
FEEPDOTHRINSURES TYPE STRING,
DATEOTHERINSURES TYPE STRING,
MEDEXPAGEDANDHC TYPE STRING,
MEDEXPEMPDEPENDT TYPE STRING,
DATESUBMITMEDEXP TYPE STRING,
CULTLEDUCEXPSEMP TYPE STRING,
CULTLEDUCEXPSDEP TYPE STRING,
DATFORCLANDEDEXP TYPE STRING,
LEGALDONATIONS TYPE STRING,
DONATTOAPPDASSNS TYPE STRING,
DONATTOPRIVSCHLS TYPE STRING,
DATSUBRECEIPTDON TYPE STRING,
HOUSESAVINGSNAME TYPE STRING,
TOTLAMTHOUSESAVE TYPE STRING,
DATOFACQTNORRENT TYPE STRING,
ANNLPAYHOUSELOAN TYPE STRING,
DATEAPPLNHOUSFEE TYPE STRING,
EXPFORCREDITCARD TYPE STRING,
PLACEEMPLYMNTABD TYPE STRING,
NATUREMPLYMNTABD TYPE STRING,
DURATIONINMONTHS TYPE STRING,
TOTLINCOFEMPABRD TYPE STRING,
NAMETAXPAYMCNTRY TYPE STRING,
KRAMTOFPPDTXABRD TYPE STRING,
DATEGETAPPLOTXCR TYPE STRING,
DATEAPTAPPLOTXCR TYPE STRING,
TXCDTFORHFUNDINT TYPE STRING,
TAXCREDITEMPSTKS TYPE STRING,
PREPDPERSPENSSAV TYPE STRING,
INVESTEDMDSMVTCO TYPE STRING,
NAMEOFCOUNTRY TYPE STRING,
HANDICAPMEDEXP TYPE STRING,
PREMIUMFORHANDICAP TYPE STRING,
PREPDPERSPENSSAV2 TYPE STRING,
INVESTEDMDSMVTCO2 TYPE STRING,
LONGTERMSTOCKSAV TYPE STRING,
SPOUSEFEE TYPE STRING,
LONGTERMSTOCKSAVPREV TYPE STRING,
COMPANYSTOCK TYPE STRING,
SPECIALDONATION TYPE STRING,
HANDICAPPEDFEE TYPE STRING,
DIRECTCARDEXPENSE TYPE STRING,
HOUSINGINSTALLMENTAMOUNT TYPE STRING,
HOUSINGSAVINGAMOUNT TYPE STRING,
EEHOUSINGSAVINGAMOUNT TYPE STRING,
LONGTERMHOUSINGSAVINGAMOUNT TYPE STRING,
30DEDUCTIONDONATIONAMOUNT TYPE STRING,
POLITICALDONATIONAMOUNT TYPE STRING,
MARRAGE TYPE STRING,
REMOVAL TYPE STRING,
FUNERAL TYPE STRING,
EXPENSEPAIDBYCREDITCARD TYPE STRING,
EXPENSEPAIDBYGIROINSTITUTION TYPE STRING,
EXPENSEPAIDBYCASH TYPE STRING,
PREPAIDTAXAMOUNT TYPE STRING,
PREPAIDTAXCURRENCY TYPE STRING,
INTERESTHOUSINGLOAN15 TYPE STRING,
DUPLICATEEXPENSE TYPE STRING,
RETIREMENTPENSION TYPE STRING,
NONHANDI_DEP_EDU_FEE TYPE STRING,
OTHPI TYPE STRING,
ONP01 TYPE STRING,
ONP02 TYPE STRING,
ONP03 TYPE STRING,
ONP04 TYPE STRING,
ONP05 TYPE STRING,
INVESTTHISYEAR TYPE STRING,
INVESTPREVIOUSYEAR TYPE STRING,
DESDO TYPE STRING,
RELDO TYPE STRING,
SMBFI TYPE STRING,
LTSF1 TYPE STRING,
LTSF2 TYPE STRING,
LTSF3 TYPE STRING,
NINVS TYPE STRING,
INDIF TYPE STRING,
INSLN TYPE STRING,
SFENP TYPE STRING,
SFEHI TYPE STRING,
MRNTD TYPE STRING,
INDPL TYPE STRING,
PDCID TYPE STRING,
HSHLD TYPE STRING,
VINVS TYPE STRING,
INTFN TYPE STRING,
INTOT TYPE STRING,
INVST TYPE STRING,
IRLWL TYPE STRING,
EXTAX TYPE STRING,
IYCIT TYPE STRING,
EINTS TYPE STRING,
PSISA TYPE STRING,END OF T_EKKO_STR. DATA: WA_P41_P0542_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_P41_P0542_STR-PERNR sy-vline
WA_P41_P0542_STR-INFTY sy-vline
WA_P41_P0542_STR-SUBTY sy-vline
WA_P41_P0542_STR-OBJPS sy-vline
WA_P41_P0542_STR-SPRPS sy-vline
WA_P41_P0542_STR-ENDDA sy-vline
WA_P41_P0542_STR-BEGDA sy-vline
WA_P41_P0542_STR-SEQNR sy-vline
WA_P41_P0542_STR-AEDTM sy-vline
WA_P41_P0542_STR-UNAME sy-vline
WA_P41_P0542_STR-HISTO sy-vline
WA_P41_P0542_STR-ITXEX sy-vline
WA_P41_P0542_STR-REFEX sy-vline
WA_P41_P0542_STR-ORDEX sy-vline
WA_P41_P0542_STR-ITBLD sy-vline
WA_P41_P0542_STR-PREAS sy-vline
WA_P41_P0542_STR-FLAG1 sy-vline
WA_P41_P0542_STR-FLAG2 sy-vline
WA_P41_P0542_STR-FLAG3 sy-vline
WA_P41_P0542_STR-FLAG4 sy-vline
WA_P41_P0542_STR-RESE1 sy-vline
WA_P41_P0542_STR-RESE2 sy-vline
WA_P41_P0542_STR-GRPVL sy-vline
WA_P41_P0542_STR-PREVCOMPANYNAME1 sy-vline
WA_P41_P0542_STR-PREVCOMPBUSNSNO1 sy-vline
WA_P41_P0542_STR-PREVCOMPSALARY1 sy-vline
WA_P41_P0542_STR-PREVCOMPBONUS1 sy-vline
WA_P41_P0542_STR-PCOMPPREPDINCTX1 sy-vline
WA_P41_P0542_STR-PCOMPPREPDRESTX1 sy-vline
WA_P41_P0542_STR-PREPDNONTXOVERS1 sy-vline
WA_P41_P0542_STR-PREPAIDNONTAXOT1 sy-vline
WA_P41_P0542_STR-PRPDOTHRNOTXINC1 sy-vline
WA_P41_P0542_STR-MEDLABRINSURNCE1 sy-vline
WA_P41_P0542_STR-EMPLOYEINSURNCE1 sy-vline
WA_P41_P0542_STR-FIELDENGDEDUCTN1 sy-vline
WA_P41_P0542_STR-EXEMPTFOREIGNPC1 sy-vline
WA_P41_P0542_STR-EXPTAMTFORGNEMP1 sy-vline
WA_P41_P0542_STR-PREVCOMPANYNAME2 sy-vline
WA_P41_P0542_STR-PREVCOMPBUSNSNO2 sy-vline
WA_P41_P0542_STR-PREVCOMPSALARY2 sy-vline
WA_P41_P0542_STR-PREVCOMPBONUS2 sy-vline
WA_P41_P0542_STR-PCOMPPREPDINCTX2 sy-vline
WA_P41_P0542_STR-PCOMPPREPDRESTX2 sy-vline
WA_P41_P0542_STR-PREPDNONTXOVERS2 sy-vline
WA_P41_P0542_STR-PREPAIDNONTAXOT2 sy-vline
WA_P41_P0542_STR-PRPDOTHRNOTXINC2 sy-vline
WA_P41_P0542_STR-MEDLABRINSURNCE2 sy-vline
WA_P41_P0542_STR-EMPLOYEINSURNCE2 sy-vline
WA_P41_P0542_STR-FIELDENGDEDUCTN2 sy-vline
WA_P41_P0542_STR-EXEMPTFOREIGNPC2 sy-vline
WA_P41_P0542_STR-EXPTAMTFORGNEMP2 sy-vline
WA_P41_P0542_STR-PREVCOMPANYNAME3 sy-vline
WA_P41_P0542_STR-PREVCOMPBUSNSNO3 sy-vline
WA_P41_P0542_STR-PREVCOMPSALARY3 sy-vline
WA_P41_P0542_STR-PREVCOMPBONUS3 sy-vline
WA_P41_P0542_STR-PCOMPPREPDINCTX3 sy-vline
WA_P41_P0542_STR-PCOMPPREPDRESTX3 sy-vline
WA_P41_P0542_STR-PREPDNONTXOVERS3 sy-vline
WA_P41_P0542_STR-PREPAIDNONTAXOT3 sy-vline
WA_P41_P0542_STR-PRPDOTHRNOTXINC3 sy-vline
WA_P41_P0542_STR-MEDLABRINSURNCE3 sy-vline
WA_P41_P0542_STR-EMPLOYEINSURNCE3 sy-vline
WA_P41_P0542_STR-FIELDENGDEDUCTN3 sy-vline
WA_P41_P0542_STR-EXEMPTFOREIGNPC3 sy-vline
WA_P41_P0542_STR-EXPTAMTFORGNEMP3 sy-vline
WA_P41_P0542_STR-PREVCOMPANYNAME4 sy-vline
WA_P41_P0542_STR-PREVCOMPBUSNSNO4 sy-vline
WA_P41_P0542_STR-PREVCOMPSALARY4 sy-vline
WA_P41_P0542_STR-PREVCOMPBONUS4 sy-vline
WA_P41_P0542_STR-PCOMPPREPDINCTX4 sy-vline
WA_P41_P0542_STR-PCOMPPREPDRESTX4 sy-vline
WA_P41_P0542_STR-PREPDNONTXOVERS4 sy-vline
WA_P41_P0542_STR-PREPAIDNONTAXOT4 sy-vline
WA_P41_P0542_STR-PRPDOTHRNOTXINC4 sy-vline
WA_P41_P0542_STR-MEDLABRINSURNCE4 sy-vline
WA_P41_P0542_STR-EMPLOYEINSURNCE4 sy-vline
WA_P41_P0542_STR-FIELDENGDEDUCTN4 sy-vline
WA_P41_P0542_STR-EXEMPTFOREIGNPC4 sy-vline
WA_P41_P0542_STR-EXPTAMTFORGNEMP4 sy-vline
WA_P41_P0542_STR-PREVCOMPANYNAME5 sy-vline
WA_P41_P0542_STR-PREVCOMPBUSNSNO5 sy-vline
WA_P41_P0542_STR-PREVCOMPSALARY5 sy-vline
WA_P41_P0542_STR-PREVCOMPBONUS5 sy-vline
WA_P41_P0542_STR-PCOMPPREPDINCTX5 sy-vline
WA_P41_P0542_STR-PCOMPPREPDRESTX5 sy-vline
WA_P41_P0542_STR-PREPDNONTXOVERS5 sy-vline
WA_P41_P0542_STR-PREPAIDNONTAXOT5 sy-vline
WA_P41_P0542_STR-PRPDOTHRNOTXINC5 sy-vline
WA_P41_P0542_STR-MEDLABRINSURNCE5 sy-vline
WA_P41_P0542_STR-EMPLOYEINSURNCE5 sy-vline
WA_P41_P0542_STR-FIELDENGDEDUCTN5 sy-vline
WA_P41_P0542_STR-EXEMPTFOREIGNPC5 sy-vline
WA_P41_P0542_STR-EXPTAMTFORGNEMP5 sy-vline
WA_P41_P0542_STR-FEEPDOTHRINSURES sy-vline
WA_P41_P0542_STR-DATEOTHERINSURES sy-vline
WA_P41_P0542_STR-MEDEXPAGEDANDHC sy-vline
WA_P41_P0542_STR-MEDEXPEMPDEPENDT sy-vline
WA_P41_P0542_STR-DATESUBMITMEDEXP sy-vline
WA_P41_P0542_STR-CULTLEDUCEXPSEMP sy-vline
WA_P41_P0542_STR-CULTLEDUCEXPSDEP sy-vline
WA_P41_P0542_STR-DATFORCLANDEDEXP sy-vline
WA_P41_P0542_STR-LEGALDONATIONS sy-vline
WA_P41_P0542_STR-DONATTOAPPDASSNS sy-vline
WA_P41_P0542_STR-DONATTOPRIVSCHLS sy-vline
WA_P41_P0542_STR-DATSUBRECEIPTDON sy-vline
WA_P41_P0542_STR-HOUSESAVINGSNAME sy-vline
WA_P41_P0542_STR-TOTLAMTHOUSESAVE sy-vline
WA_P41_P0542_STR-DATOFACQTNORRENT sy-vline
WA_P41_P0542_STR-ANNLPAYHOUSELOAN sy-vline
WA_P41_P0542_STR-DATEAPPLNHOUSFEE sy-vline
WA_P41_P0542_STR-EXPFORCREDITCARD sy-vline
WA_P41_P0542_STR-PLACEEMPLYMNTABD sy-vline
WA_P41_P0542_STR-NATUREMPLYMNTABD sy-vline
WA_P41_P0542_STR-DURATIONINMONTHS sy-vline
WA_P41_P0542_STR-TOTLINCOFEMPABRD sy-vline
WA_P41_P0542_STR-NAMETAXPAYMCNTRY sy-vline
WA_P41_P0542_STR-KRAMTOFPPDTXABRD sy-vline
WA_P41_P0542_STR-DATEGETAPPLOTXCR sy-vline
WA_P41_P0542_STR-DATEAPTAPPLOTXCR sy-vline
WA_P41_P0542_STR-TXCDTFORHFUNDINT sy-vline
WA_P41_P0542_STR-TAXCREDITEMPSTKS sy-vline
WA_P41_P0542_STR-PREPDPERSPENSSAV sy-vline
WA_P41_P0542_STR-INVESTEDMDSMVTCO sy-vline
WA_P41_P0542_STR-NAMEOFCOUNTRY sy-vline
WA_P41_P0542_STR-HANDICAPMEDEXP sy-vline
WA_P41_P0542_STR-PREMIUMFORHANDICAP sy-vline
WA_P41_P0542_STR-PREPDPERSPENSSAV2 sy-vline
WA_P41_P0542_STR-INVESTEDMDSMVTCO2 sy-vline
WA_P41_P0542_STR-LONGTERMSTOCKSAV sy-vline
WA_P41_P0542_STR-SPOUSEFEE sy-vline
WA_P41_P0542_STR-LONGTERMSTOCKSAVPREV sy-vline
WA_P41_P0542_STR-COMPANYSTOCK sy-vline
WA_P41_P0542_STR-SPECIALDONATION sy-vline
WA_P41_P0542_STR-HANDICAPPEDFEE sy-vline
WA_P41_P0542_STR-DIRECTCARDEXPENSE sy-vline
WA_P41_P0542_STR-HOUSINGINSTALLMENTAMOUNT sy-vline
WA_P41_P0542_STR-HOUSINGSAVINGAMOUNT sy-vline
WA_P41_P0542_STR-EEHOUSINGSAVINGAMOUNT sy-vline
WA_P41_P0542_STR-LONGTERMHOUSINGSAVINGAMOUNT sy-vline
WA_P41_P0542_STR-30DEDUCTIONDONATIONAMOUNT sy-vline
WA_P41_P0542_STR-POLITICALDONATIONAMOUNT sy-vline
WA_P41_P0542_STR-MARRAGE sy-vline
WA_P41_P0542_STR-REMOVAL sy-vline
WA_P41_P0542_STR-FUNERAL sy-vline
WA_P41_P0542_STR-EXPENSEPAIDBYCREDITCARD sy-vline
WA_P41_P0542_STR-EXPENSEPAIDBYGIROINSTITUTION sy-vline
WA_P41_P0542_STR-EXPENSEPAIDBYCASH sy-vline
WA_P41_P0542_STR-PREPAIDTAXAMOUNT sy-vline
WA_P41_P0542_STR-PREPAIDTAXCURRENCY sy-vline
WA_P41_P0542_STR-INTERESTHOUSINGLOAN15 sy-vline
WA_P41_P0542_STR-DUPLICATEEXPENSE sy-vline
WA_P41_P0542_STR-RETIREMENTPENSION sy-vline
WA_P41_P0542_STR-NONHANDI_DEP_EDU_FEE sy-vline
WA_P41_P0542_STR-OTHPI sy-vline
WA_P41_P0542_STR-ONP01 sy-vline
WA_P41_P0542_STR-ONP02 sy-vline
WA_P41_P0542_STR-ONP03 sy-vline
WA_P41_P0542_STR-ONP04 sy-vline
WA_P41_P0542_STR-ONP05 sy-vline
WA_P41_P0542_STR-INVESTTHISYEAR sy-vline
WA_P41_P0542_STR-INVESTPREVIOUSYEAR sy-vline
WA_P41_P0542_STR-DESDO sy-vline
WA_P41_P0542_STR-RELDO sy-vline
WA_P41_P0542_STR-SMBFI sy-vline
WA_P41_P0542_STR-LTSF1 sy-vline
WA_P41_P0542_STR-LTSF2 sy-vline
WA_P41_P0542_STR-LTSF3 sy-vline
WA_P41_P0542_STR-NINVS sy-vline
WA_P41_P0542_STR-INDIF sy-vline
WA_P41_P0542_STR-INSLN sy-vline
WA_P41_P0542_STR-SFENP sy-vline
WA_P41_P0542_STR-SFEHI sy-vline
WA_P41_P0542_STR-MRNTD sy-vline
WA_P41_P0542_STR-INDPL sy-vline
WA_P41_P0542_STR-PDCID sy-vline
WA_P41_P0542_STR-HSHLD sy-vline
WA_P41_P0542_STR-VINVS sy-vline
WA_P41_P0542_STR-INTFN sy-vline
WA_P41_P0542_STR-INTOT sy-vline
WA_P41_P0542_STR-INVST sy-vline
WA_P41_P0542_STR-IRLWL sy-vline
WA_P41_P0542_STR-EXTAX sy-vline
WA_P41_P0542_STR-IYCIT sy-vline
WA_P41_P0542_STR-EINTS sy-vline
WA_P41_P0542_STR-PSISA sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.