ABAP Select data from SAP table /SRMSMC/S_DNB_PR_DB 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 /SRMSMC/S_DNB_PR_DB 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 /SRMSMC/S_DNB_PR_DB. 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 /SRMSMC/S_DNB_PR_DB 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_/SRMSMC/S_DNB_PR_DB TYPE STANDARD TABLE OF /SRMSMC/S_DNB_PR_DB,
WA_/SRMSMC/S_DNB_PR_DB TYPE /SRMSMC/S_DNB_PR_DB,
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: </SRMSMC/S_DNB_PR_DB> TYPE /SRMSMC/S_DNB_PR_DB.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/SRMSMC/S_DNB_PR_DB.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /SRMSMC/S_DNB_PR_DB
INTO TABLE IT_/SRMSMC/S_DNB_PR_DB.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /SRMSMC/S_DNB_PR_DB
* INTO TABLE @DATA(IT_/SRMSMC/S_DNB_PR_DB2).
*--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_/SRMSMC/S_DNB_PR_DB INDEX 1 INTO DATA(WA_/SRMSMC/S_DNB_PR_DB2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SRMSMC/S_DNB_PR_DB ASSIGNING </SRMSMC/S_DNB_PR_DB>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</SRMSMC/S_DNB_PR_DB>-CREA_UNAME = 1.
</SRMSMC/S_DNB_PR_DB>-SRVRTID = 1.
</SRMSMC/S_DNB_PR_DB>-GDA_ID = 1.
</SRMSMC/S_DNB_PR_DB>-CACHE_IND = 1.
</SRMSMC/S_DNB_PR_DB>-PRD_DT = 1.
ENDLOOP. LOOP AT IT_/SRMSMC/S_DNB_PR_DB INTO WA_/SRMSMC/S_DNB_PR_DB. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/SRMSMC/S_DNB_PR_DB-DUNS_NBR, sy-vline,
WA_/SRMSMC/S_DNB_PR_DB-PRIM_NME, sy-vline,
WA_/SRMSMC/S_DNB_PR_DB-POST_TOWN, sy-vline,
WA_/SRMSMC/S_DNB_PR_DB-PRIM_GEO_AREA, sy-vline,
WA_/SRMSMC/S_DNB_PR_DB-POST_CODE, sy-vline,
WA_/SRMSMC/S_DNB_PR_DB-CTRY_CD, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SRMSMC/S_DNB_PR_DB 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_/SRMSMC/S_DNB_PR_DB 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_/SRMSMC/S_DNB_PR_DB INTO WA_/SRMSMC/S_DNB_PR_DB. *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_/SRMSMC/S_DNB_PR_DB_STR,
CREA_UNAME TYPE STRING,
SRVRTID TYPE STRING,
GDA_ID TYPE STRING,
CACHE_IND TYPE STRING,
PRD_DT TYPE STRING,
DUNS_NBR TYPE STRING,
PRIM_NME TYPE STRING,
POST_TOWN TYPE STRING,
PRIM_GEO_AREA TYPE STRING,
POST_CODE TYPE STRING,
CTRY_CD TYPE STRING,
BR_IND TYPE STRING,
ACT_PAY TYPE STRING,
ACT_REC TYPE STRING,
ACTIVITY_TEXT TYPE STRING,
ADDL_SIC TYPE STRING,
ADDL_SIC_TYPE_CD TYPE STRING,
ADR_TENR_TYPE_CD TYPE STRING,
ANN_SALE_CONS_IND TYPE STRING,
ANN_SALE_CRCY_CD TYPE STRING,
ANN_SALE_ESTD_IND TYPE STRING,
ANN_SALE_VOL TYPE STRING,
ANN_SALE_VOL_TEXT TYPE STRING,
ASET TYPE STRING,
AUDT_IND TYPE STRING,
AUDT_QLFN_IND TYPE STRING,
AVG_HIGH_CR TYPE STRING,
BUS_REGN_NBR TYPE STRING,
BUS_REGN_NBR_TYPE_CD TYPE STRING,
BUS_STRU TYPE STRING,
CAPL_AMT TYPE STRING,
CAPL_CRCY_CD TYPE STRING,
CAPL_TYPE_CD TYPE STRING,
CASH_LIQ_ASET TYPE STRING,
CEO_NME TYPE STRING,
CEO_TITL TYPE STRING,
CLM_IND TYPE STRING,
CONS_IND TYPE STRING,
COST_OF_SLS TYPE STRING,
CR_IND TYPE STRING,
CR_SCR TYPE STRING,
CRCY_CD TYPE STRING,
CRIM_IND TYPE STRING,
CURR_CNTL_YR TYPE STRING,
CURR_RATO TYPE STRING,
DBTR_IN_POSN_IND TYPE STRING,
DIVD TYPE STRING,
CR_SCR_CLAS TYPE STRING,
DNB_RATG TYPE STRING,
DOM_ULT_CTRY_CD TYPE STRING,
DOM_ULT_PNT_DUNS TYPE STRING,
DOM_ULT_PNT_NME TYPE STRING,
DSR TYPE STRING,
DSTR_IND TYPE STRING,
EMPL_AT_PRIM_ADR TYPE STRING,
EMPL_AT_PRIM_ADR_ESTD_IND TYPE STRING,
EMPL_AT_PRIM_ADR_MIN_IND TYPE STRING,
EMPL_AT_PRIM_ADR_TEXT TYPE STRING,
ESTD_IND TYPE STRING,
EXPT_IND TYPE STRING,
FAIL_SCR TYPE STRING,
FAIL_SCR_12_MO_AGO TYPE STRING,
FAIL_SCR_6_MO_AGO TYPE STRING,
FAIL_SCR_IND_PCTG TYPE STRING,
FAIL_SCR_NATL_PCTG TYPE STRING,
FAIL_SCR_OVRD_CD TYPE STRING,
FAX_NBR TYPE STRING,
FCST_IND TYPE STRING,
FINL_EMBT_IND TYPE STRING,
FINL_LGL_EVNT_IND TYPE STRING,
FISC_IND TYPE STRING,
FIXD_ASET TYPE STRING,
FLNG_CRCY_CD TYPE STRING,
FLNG_NBR TYPE STRING,
FLNG_TYPE TYPE STRING,
FLNG_VAL TYPE STRING,
FNAL_IND TYPE STRING,
GBL_ULT_CTRY_CD TYPE STRING,
GBL_ULT_PNT_DUNS TYPE STRING,
GBL_ULT_PNT_NME TYPE STRING,
SER_RAT TYPE STRING,
GROS_INCM TYPE STRING,
HIGH_CR TYPE STRING,
HIST_IND TYPE STRING,
HQ_CTRY_CD TYPE STRING,
HQ_DUNS TYPE STRING,
HQ_NME TYPE STRING,
IMPT_IND TYPE STRING,
INCM_STMT_DT TYPE STRING,
INCN_YR TYPE STRING,
INTL_DLNG_CD TYPE STRING,
ITNG_ASET TYPE STRING,
LCL_ACTV_CD TYPE STRING,
LCL_ACTV_CD_TYPE TYPE STRING,
LGL_FORM TYPE STRING,
LOCN_STAT TYPE STRING,
LT_DBT TYPE STRING,
MAX_CR TYPE STRING,
MAX_CR_CRCY_CD TYPE STRING,
NBR_NEG_PMT TYPE STRING,
NET_INCM TYPE STRING,
NET_WRTH TYPE STRING,
NON_POST_TOWN TYPE STRING,
OPEN_IND TYPE STRING,
OPRG_SPEC_EVNT_IND TYPE STRING,
OTHR_SPEC_EVNT_IND TYPE STRING,
OUT_BUS_IND TYPE STRING,
PAYD_3_MO_AGO TYPE STRING,
PAYD_NORM TYPE STRING,
PAYD_SCR TYPE STRING,
PNT_CTRY_CD TYPE STRING,
PNT_DUNS TYPE STRING,
PNT_NME TYPE STRING,
PREV_NET_WRTH TYPE STRING,
PREV_SLS TYPE STRING,
PREV_STMT_DT TYPE STRING,
PREV_WRKG_CAPL TYPE STRING,
PRIM_SIC TYPE STRING,
PRIM_SIC_TYPE_CD TYPE STRING,
PRO_FRMA_IND TYPE STRING,
QK_RATO TYPE STRING,
REGN_TYPE TYPE STRING,
REST_IND TYPE STRING,
RETN_ERNG TYPE STRING,
SCDY_GEO_AREA TYPE STRING,
SCRD_FLNG_IND TYPE STRING,
SD_IND TYPE STRING,
SGND_IND TYPE STRING,
SLS TYPE STRING,
STAT TYPE STRING,
STK TYPE STRING,
STMT_CRCY_CD TYPE STRING,
STMT_DT TYPE STRING,
STMT_FROM_DT TYPE STRING,
STMT_TO_DT TYPE STRING,
STRT_YR TYPE STRING,
SUIT_JDGT_IND TYPE STRING,
TANG_NET_WRTH TYPE STRING,
TANG_NET_WRTH_CRCY_CD TYPE STRING,
TANG_NET_WRTH_ESTD_IND TYPE STRING,
TANG_NET_WRTH_TEXT TYPE STRING,
TLCM_NBR TYPE STRING,
TOT_ASET TYPE STRING,
TOT_CURR_ASET TYPE STRING,
TOT_CURR_LIAB TYPE STRING,
TOT_EMPL TYPE STRING,
TOT_EMPL_ESTD_IND TYPE STRING,
TOT_EMPL_IND TYPE STRING,
TOT_EMPL_MIN_IND TYPE STRING,
TOT_EMPL_TEXT TYPE STRING,
TOT_LIAB TYPE STRING,
TOT_LIAB_AND_EQY TYPE STRING,
TOT_LT_LIAB TYPE STRING,
TOT_PMT TYPE STRING,
TRL_BAL_IND TYPE STRING,
UBAL_IND TYPE STRING,
ADDL_SIC_DESC TYPE STRING,
ENQ_DUNS TYPE STRING,
PRIN_NME TYPE STRING,
PRIN_TTL TYPE STRING,
PFT_BEF_TAX TYPE STRING,
CNGL_DIST_CD TYPE STRING,
HDG TYPE STRING,
BODY TYPE STRING,
LBR_SPLS_AREA_IND TYPE STRING,
LBR_SPLS_AREA_YR TYPE STRING,
SML_BUS_IND TYPE STRING,
SML_BUS_YR TYPE STRING,
WOMN_OWND_IND TYPE STRING,
WOMN_OWND_YR TYPE STRING,
MINY_OWND_IND TYPE STRING,
MINY_OWND_YR TYPE STRING,
DAVD_IND TYPE STRING,
DBAR_CNT TYPE STRING,
DBAR_DT TYPE STRING,
DAVD_YR TYPE STRING,
BKCY_OPEN_CNT TYPE STRING,
BKCY_CLSD_CNT TYPE STRING,
BKCY_OPEN_MSG TYPE STRING,
BKCY_CLSD_MSG TYPE STRING,
SLON_CMNT TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SRMSMC/S_DNB_PR_DB_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_/SRMSMC/S_DNB_PR_DB_STR-CREA_UNAME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SRVRTID sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-GDA_ID sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CACHE_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRD_DT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DUNS_NBR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRIM_NME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-POST_TOWN sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRIM_GEO_AREA sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-POST_CODE sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CTRY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BR_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ACT_PAY sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ACT_REC sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ACTIVITY_TEXT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ADDL_SIC sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ADDL_SIC_TYPE_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ADR_TENR_TYPE_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ANN_SALE_CONS_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ANN_SALE_CRCY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ANN_SALE_ESTD_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ANN_SALE_VOL sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ANN_SALE_VOL_TEXT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ASET sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-AUDT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-AUDT_QLFN_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-AVG_HIGH_CR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BUS_REGN_NBR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BUS_REGN_NBR_TYPE_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BUS_STRU sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CAPL_AMT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CAPL_CRCY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CAPL_TYPE_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CASH_LIQ_ASET sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CEO_NME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CEO_TITL sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CLM_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CONS_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-COST_OF_SLS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CR_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CR_SCR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CRCY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CRIM_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CURR_CNTL_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CURR_RATO sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DBTR_IN_POSN_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DIVD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CR_SCR_CLAS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DNB_RATG sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DOM_ULT_CTRY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DOM_ULT_PNT_DUNS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DOM_ULT_PNT_NME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DSR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DSTR_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-EMPL_AT_PRIM_ADR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-EMPL_AT_PRIM_ADR_ESTD_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-EMPL_AT_PRIM_ADR_MIN_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-EMPL_AT_PRIM_ADR_TEXT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ESTD_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-EXPT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FAIL_SCR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FAIL_SCR_12_MO_AGO sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FAIL_SCR_6_MO_AGO sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FAIL_SCR_IND_PCTG sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FAIL_SCR_NATL_PCTG sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FAIL_SCR_OVRD_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FAX_NBR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FCST_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FINL_EMBT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FINL_LGL_EVNT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FISC_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FIXD_ASET sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FLNG_CRCY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FLNG_NBR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FLNG_TYPE sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FLNG_VAL sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-FNAL_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-GBL_ULT_CTRY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-GBL_ULT_PNT_DUNS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-GBL_ULT_PNT_NME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SER_RAT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-GROS_INCM sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-HIGH_CR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-HIST_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-HQ_CTRY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-HQ_DUNS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-HQ_NME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-IMPT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-INCM_STMT_DT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-INCN_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-INTL_DLNG_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ITNG_ASET sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-LCL_ACTV_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-LCL_ACTV_CD_TYPE sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-LGL_FORM sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-LOCN_STAT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-LT_DBT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-MAX_CR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-MAX_CR_CRCY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-NBR_NEG_PMT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-NET_INCM sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-NET_WRTH sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-NON_POST_TOWN sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-OPEN_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-OPRG_SPEC_EVNT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-OTHR_SPEC_EVNT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-OUT_BUS_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PAYD_3_MO_AGO sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PAYD_NORM sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PAYD_SCR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PNT_CTRY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PNT_DUNS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PNT_NME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PREV_NET_WRTH sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PREV_SLS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PREV_STMT_DT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PREV_WRKG_CAPL sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRIM_SIC sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRIM_SIC_TYPE_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRO_FRMA_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-QK_RATO sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-REGN_TYPE sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-REST_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-RETN_ERNG sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SCDY_GEO_AREA sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SCRD_FLNG_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SD_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SGND_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SLS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-STAT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-STK sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-STMT_CRCY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-STMT_DT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-STMT_FROM_DT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-STMT_TO_DT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-STRT_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SUIT_JDGT_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TANG_NET_WRTH sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TANG_NET_WRTH_CRCY_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TANG_NET_WRTH_ESTD_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TANG_NET_WRTH_TEXT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TLCM_NBR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_ASET sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_CURR_ASET sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_CURR_LIAB sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_EMPL sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_EMPL_ESTD_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_EMPL_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_EMPL_MIN_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_EMPL_TEXT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_LIAB sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_LIAB_AND_EQY sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_LT_LIAB sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TOT_PMT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-TRL_BAL_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-UBAL_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ADDL_SIC_DESC sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-ENQ_DUNS sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRIN_NME sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PRIN_TTL sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-PFT_BEF_TAX sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-CNGL_DIST_CD sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-HDG sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BODY sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-LBR_SPLS_AREA_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-LBR_SPLS_AREA_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SML_BUS_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SML_BUS_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-WOMN_OWND_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-WOMN_OWND_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-MINY_OWND_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-MINY_OWND_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DAVD_IND sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DBAR_CNT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DBAR_DT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-DAVD_YR sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BKCY_OPEN_CNT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BKCY_CLSD_CNT sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BKCY_OPEN_MSG sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-BKCY_CLSD_MSG sy-vline
WA_/SRMSMC/S_DNB_PR_DB_STR-SLON_CMNT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
