ABAP Select data from SAP table PTH_HTHCTX91_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 PTH_HTHCTX91_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 PTH_HTHCTX91_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 PTH_HTHCTX91_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_PTH_HTHCTX91_DATA TYPE STANDARD TABLE OF PTH_HTHCTX91_DATA,
WA_PTH_HTHCTX91_DATA TYPE PTH_HTHCTX91_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: <PTH_HTHCTX91_DATA> TYPE PTH_HTHCTX91_DATA.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_PTH_HTHCTX91_DATA.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM PTH_HTHCTX91_DATA
INTO TABLE IT_PTH_HTHCTX91_DATA.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM PTH_HTHCTX91_DATA
* INTO TABLE @DATA(IT_PTH_HTHCTX91_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_PTH_HTHCTX91_DATA INDEX 1 INTO DATA(WA_PTH_HTHCTX91_DATA2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PTH_HTHCTX91_DATA ASSIGNING <PTH_HTHCTX91_DATA>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<PTH_HTHCTX91_DATA>-TAXYR = 1.
<PTH_HTHCTX91_DATA>-BDE = 1.
<PTH_HTHCTX91_DATA>-ID = 1.
<PTH_HTHCTX91_DATA>-STX = 1.
<PTH_HTHCTX91_DATA>-G_EMP_SP_DOB_D = 1.
ENDLOOP. LOOP AT IT_PTH_HTHCTX91_DATA INTO WA_PTH_HTHCTX91_DATA. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_PTH_HTHCTX91_DATA-G_EMP_SP_DOB_M, sy-vline,
WA_PTH_HTHCTX91_DATA-G_EMP_SP_DOB_Y, sy-vline,
WA_PTH_HTHCTX91_DATA-G_EMP_DOB_D, sy-vline,
WA_PTH_HTHCTX91_DATA-G_EMP_DOB_M, sy-vline,
WA_PTH_HTHCTX91_DATA-G_EMP_DOB_Y, sy-vline,
WA_PTH_HTHCTX91_DATA-NAME, sy-vline.
ENDLOOP. *Add any further fields from structure WA_PTH_HTHCTX91_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_PTH_HTHCTX91_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_PTH_HTHCTX91_DATA INTO WA_PTH_HTHCTX91_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 KOSTL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_PTH_HTHCTX91_DATA-KOSTL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_PTH_HTHCTX91_DATA-KOSTL.
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_PTH_HTHCTX91_DATA_STR,
TAXYR TYPE STRING,
BDE TYPE STRING,
ID TYPE STRING,
STX TYPE STRING,
G_EMP_SP_DOB_D TYPE STRING,
G_EMP_SP_DOB_M TYPE STRING,
G_EMP_SP_DOB_Y TYPE STRING,
G_EMP_DOB_D TYPE STRING,
G_EMP_DOB_M TYPE STRING,
G_EMP_DOB_Y TYPE STRING,
NAME TYPE STRING,
FAMILY_NAME TYPE STRING,
BUILDING TYPE STRING,
ROOM TYPE STRING,
FLOOR TYPE STRING,
VILIAGE TYPE STRING,
ADDRESS_NO TYPE STRING,
MOO TYPE STRING,
ADD_NO TYPE STRING,
ROAD TYPE STRING,
TAMBOL TYPE STRING,
DISTRICT TYPE STRING,
PROVINCE TYPE STRING,
P_CODE TYPE STRING,
TEL_HOME TYPE STRING,
TEL_OFF TYPE STRING,
NORMAL TYPE STRING,
ADDITIONAL TYPE STRING,
SINGLE TYPE STRING,
MARRIED TYPE STRING,
DIVORCED TYPE STRING,
SP_NAME TYPE STRING,
SP_FAMILY_N TYPE STRING,
SP_JOINCAL TYPE STRING,
SP_SEPERATE TYPE STRING,
SP_NOINCOME TYPE STRING,
PASSPORT_NOM TYPE STRING,
G_EMP_SP_NATION TYPE STRING,
COUNTRY TYPE STRING,
ADDL_TAXB TYPE STRING,
ADDL_TAXS TYPE STRING,
OV_TAXB TYPE STRING,
OV_TAXS TYPE STRING,
ER_ID TYPE STRING,
SAL_WAGEB TYPE STRING,
SAL_WAGES TYPE STRING,
EXPENSEB TYPE STRING,
EXPENSES TYPE STRING,
INC_AF_EXB TYPE STRING,
INC_AF_EXS TYPE STRING,
EXP_40B TYPE STRING,
EXP_40S TYPE STRING,
NT_IAF_EXB TYPE STRING,
NT_IAF_EXS TYPE STRING,
TOTAL_ALLWB TYPE STRING,
TOTAL_ALLWS TYPE STRING,
IAF_EX_ALLB TYPE STRING,
IAF_EX_ALLS TYPE STRING,
CHARITYEDUB TYPE STRING,
CHARITYEDUS TYPE STRING,
TXBL_INCB TYPE STRING,
TXBL_INCS TYPE STRING,
CHARITYB TYPE STRING,
CHARITYS TYPE STRING,
TXBL_INC2B TYPE STRING,
TXBL_INC2S TYPE STRING,
TAX_PAIDB TYPE STRING,
TAX_PAIDS TYPE STRING,
CALC_IMMOB TYPE STRING,
CALC_IMMOS TYPE STRING,
INFTY_IMMOB TYPE STRING,
INFTY_IMMOS TYPE STRING,
CALC_TAXB TYPE STRING,
CALC_TAXS TYPE STRING,
TX_PYBLB TYPE STRING,
TX_PYBLS TYPE STRING,
ADDL_TX TYPE STRING,
OV_TX TYPE STRING,
BLCE_TAXB TYPE STRING,
BLCE_TAXS TYPE STRING,
ADL_TAXB TYPE STRING,
ADL_TAXS TYPE STRING,
OVPD_TXB TYPE STRING,
OVPD_TXS TYPE STRING,
LESS_TAXB TYPE STRING,
LESS_TAXS TYPE STRING,
TAXB TYPE STRING,
TAXS TYPE STRING,
PLUSB TYPE STRING,
PLUSS TYPE STRING,
TOT_TAXB TYPE STRING,
TOT_TAXS TYPE STRING,
PF_ALLWB TYPE STRING,
PF_ALLWS TYPE STRING,
CVLSRVT_FB TYPE STRING,
CVLSRVT_FS TYPE STRING,
SCHTCHR_FB TYPE STRING,
SCHTCHR_FS TYPE STRING,
DI65_ALLWB TYPE STRING,
DI65_ALLWS TYPE STRING,
EXEMPTB TYPE STRING,
NEXEMPTB TYPE STRING,
SEVR_PAYB TYPE STRING,
SEVR_PAYS TYPE STRING,
TAX_PAYERB TYPE STRING,
TAX_PAYERS TYPE STRING,
SPSE_30KB TYPE STRING,
SPSE_30KS TYPE STRING,
CHNO1 TYPE STRING,
CHNO3 TYPE STRING,
CH_15KB TYPE STRING,
CH_15KS TYPE STRING,
CH_17KB TYPE STRING,
CH_17KS TYPE STRING,
FTX_C4 TYPE STRING,
MTX_C4 TYPE STRING,
SFX_C4 TYPE STRING,
SMX_C4 TYPE STRING,
FATHERB TYPE STRING,
FATHERS TYPE STRING,
MOTHERB TYPE STRING,
MOTHERS TYPE STRING,
SP_FATHERB TYPE STRING,
SP_FATHERS TYPE STRING,
SP_MOTHERB TYPE STRING,
SP_MOTHERS TYPE STRING,
DI_60KB TYPE STRING,
DI_60KS TYPE STRING,
FTX TYPE STRING,
MTX TYPE STRING,
PARENT_INSB TYPE STRING,
PARENT_INSS TYPE STRING,
SFX TYPE STRING,
SMX TYPE STRING,
INS_PRB TYPE STRING,
INS_PRS TYPE STRING,
INS_PRPB TYPE STRING,
INS_PRPS TYPE STRING,
PROV_FUNDB TYPE STRING,
PROV_FUNDS TYPE STRING,
MF_ALLWB TYPE STRING,
MF_ALLWS TYPE STRING,
LTEFB TYPE STRING,
LTEFS TYPE STRING,
HSE_ALLWB TYPE STRING,
HSE_ALLWS TYPE STRING,
IMMV_ALLB TYPE STRING,
IMMV_ALLS TYPE STRING,
SOCSOB TYPE STRING,
SOCSOS TYPE STRING,
TUREXB TYPE STRING,
TUREXS TYPE STRING,
CH15_ID1 TYPE STRING,
CH15_ID2 TYPE STRING,
CH15_ID3 TYPE STRING,
CH17_ID1 TYPE STRING,
CH17_ID2 TYPE STRING,
CH17_ID3 TYPE STRING,
TAXEXEMPT_GOODSB TYPE STRING,
TAXEXEMPT_GOODSS TYPE STRING,
CALC_IMMEXB TYPE STRING,
CALC_IMMEXS TYPE STRING,
INFTY_IMMEXB TYPE STRING,
INFTY_IMMEXS TYPE STRING,
SONGKRAN_EXB TYPE STRING,
SONGKRAN_EXS TYPE STRING,
OTOPEXB TYPE STRING,
OTOPEXS TYPE STRING,
TR16_EXB TYPE STRING,
TR16_EXS TYPE STRING,
FLOOD_DOB TYPE STRING,
FLOOD_DOS TYPE STRING,
HEALTH_INSB TYPE STRING,
HEALTH_INSS TYPE STRING,
FLOOD_HOMEB TYPE STRING,
FLOOD_HOMES TYPE STRING,
FLOOD_CARB TYPE STRING,
FLOOD_CARS TYPE STRING,
TXBL_INC3B TYPE STRING,
TXBL_INC3S TYPE STRING,
CH15_ID4 TYPE STRING,
CH15_ID5 TYPE STRING,
CH15_ID6 TYPE STRING,
CH15_ID7 TYPE STRING,
CHNO4 TYPE STRING,
CH_60KB TYPE STRING,
CH_60KS TYPE STRING,
CH60_ID1 TYPE STRING,
CH60_ID2 TYPE STRING,
CH60_ID3 TYPE STRING,
CH60_ID4 TYPE STRING,
CH60_ID5 TYPE STRING,
MATERNITYB TYPE STRING,
MATERNITYS TYPE STRING,
YE_BOOKB TYPE STRING,
YE_BOOKS TYPE STRING,
YE_TYREB TYPE STRING,
YE_TYRES TYPE STRING,
PARTY_DOB TYPE STRING,
PARTY_DOS TYPE STRING,
STORM_HOMEB TYPE STRING,
STORM_HOMES TYPE STRING,
STORM_CARB TYPE STRING,
STORM_CARS TYPE STRING,
TR_MAINB TYPE STRING,
TR_MAINS TYPE STRING,
TR_MINORB TYPE STRING,
TR_MINORS TYPE STRING,
EDUSP_EXPB TYPE STRING,
EDUSP_EXPS TYPE STRING,
OTOP2_EXB TYPE STRING,
OTOP2_EXS TYPE STRING,
BOOKS_EXB TYPE STRING,
BOOKS_EXS TYPE STRING,
RE_VALUEB TYPE STRING,
RE_VALUES TYPE STRING,
RE_EXPB TYPE STRING,
RE_EXPS TYPE STRING,
SSF_EXPB TYPE STRING,
SSF_EXPS TYPE STRING,
SSFX_EXPB TYPE STRING,
SSFX_EXPS TYPE STRING,
ATTACHMENT TYPE STRING,
CHK_H1 TYPE STRING,
CHK_H2 TYPE STRING,
HLINE TYPE STRING,
ER_ADDR TYPE STRING,
EE_YRS TYPE STRING,
GOV_GRAB TYPE STRING,
GOV_GRAS TYPE STRING,
PRO_FUNB TYPE STRING,
PRO_FUNS TYPE STRING,
SEV_PAYB TYPE STRING,
SEV_PAYS TYPE STRING,
TOT_ONEB TYPE STRING,
TOT_ONES TYPE STRING,
LUM_SUMB TYPE STRING,
LUM_SUMS TYPE STRING,
TOT_4T5B TYPE STRING,
TOT_4T5S TYPE STRING,
EXEMPT_OAE TYPE STRING,
NEXEMPT_OAE TYPE STRING,
OLD_EXMB TYPE STRING,
OLD_EXMS TYPE STRING,
BALANCEB TYPE STRING,
BALANCES TYPE STRING,
NET_INCB TYPE STRING,
NET_INCS TYPE STRING,
TAX_CALB TYPE STRING,
TAX_CALS TYPE STRING,
WTH_TAXB TYPE STRING,
WTH_TAXS TYPE STRING,
ADD_TAXB TYPE STRING,
ADD_TAXS TYPE STRING,
OVR_TAXB TYPE STRING,
OVR_TAXS TYPE STRING,
EXM_INCB TYPE STRING,
EXM_INCS TYPE STRING,
AVG_SALB TYPE STRING,
AVG_SALS TYPE STRING,
YRS_SERB TYPE STRING,
SAL_RCDB TYPE STRING,
SAL_RCDS TYPE STRING,
BAS_SALB TYPE STRING,
BAS_SALS TYPE STRING,
EXPNS_1B TYPE STRING,
EXPNS_1S TYPE STRING,
BAL_2_3B TYPE STRING,
BAL_2_3S TYPE STRING,
EXPNS_2B TYPE STRING,
EXPNS_2S TYPE STRING,
TOT_EXPB TYPE STRING,
TOT_EXPS TYPE STRING,
KOSTL TYPE STRING,
ORGEH TYPE STRING,
PERNR TYPE STRING,END OF T_EKKO_STR. DATA: WA_PTH_HTHCTX91_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_PTH_HTHCTX91_DATA_STR-TAXYR sy-vline
WA_PTH_HTHCTX91_DATA_STR-BDE sy-vline
WA_PTH_HTHCTX91_DATA_STR-ID sy-vline
WA_PTH_HTHCTX91_DATA_STR-STX sy-vline
WA_PTH_HTHCTX91_DATA_STR-G_EMP_SP_DOB_D sy-vline
WA_PTH_HTHCTX91_DATA_STR-G_EMP_SP_DOB_M sy-vline
WA_PTH_HTHCTX91_DATA_STR-G_EMP_SP_DOB_Y sy-vline
WA_PTH_HTHCTX91_DATA_STR-G_EMP_DOB_D sy-vline
WA_PTH_HTHCTX91_DATA_STR-G_EMP_DOB_M sy-vline
WA_PTH_HTHCTX91_DATA_STR-G_EMP_DOB_Y sy-vline
WA_PTH_HTHCTX91_DATA_STR-NAME sy-vline
WA_PTH_HTHCTX91_DATA_STR-FAMILY_NAME sy-vline
WA_PTH_HTHCTX91_DATA_STR-BUILDING sy-vline
WA_PTH_HTHCTX91_DATA_STR-ROOM sy-vline
WA_PTH_HTHCTX91_DATA_STR-FLOOR sy-vline
WA_PTH_HTHCTX91_DATA_STR-VILIAGE sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADDRESS_NO sy-vline
WA_PTH_HTHCTX91_DATA_STR-MOO sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADD_NO sy-vline
WA_PTH_HTHCTX91_DATA_STR-ROAD sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAMBOL sy-vline
WA_PTH_HTHCTX91_DATA_STR-DISTRICT sy-vline
WA_PTH_HTHCTX91_DATA_STR-PROVINCE sy-vline
WA_PTH_HTHCTX91_DATA_STR-P_CODE sy-vline
WA_PTH_HTHCTX91_DATA_STR-TEL_HOME sy-vline
WA_PTH_HTHCTX91_DATA_STR-TEL_OFF sy-vline
WA_PTH_HTHCTX91_DATA_STR-NORMAL sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADDITIONAL sy-vline
WA_PTH_HTHCTX91_DATA_STR-SINGLE sy-vline
WA_PTH_HTHCTX91_DATA_STR-MARRIED sy-vline
WA_PTH_HTHCTX91_DATA_STR-DIVORCED sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_NAME sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_FAMILY_N sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_JOINCAL sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_SEPERATE sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_NOINCOME sy-vline
WA_PTH_HTHCTX91_DATA_STR-PASSPORT_NOM sy-vline
WA_PTH_HTHCTX91_DATA_STR-G_EMP_SP_NATION sy-vline
WA_PTH_HTHCTX91_DATA_STR-COUNTRY sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADDL_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADDL_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-OV_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-OV_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-ER_ID sy-vline
WA_PTH_HTHCTX91_DATA_STR-SAL_WAGEB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SAL_WAGES sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXPENSEB sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXPENSES sy-vline
WA_PTH_HTHCTX91_DATA_STR-INC_AF_EXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-INC_AF_EXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXP_40B sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXP_40S sy-vline
WA_PTH_HTHCTX91_DATA_STR-NT_IAF_EXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-NT_IAF_EXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOTAL_ALLWB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOTAL_ALLWS sy-vline
WA_PTH_HTHCTX91_DATA_STR-IAF_EX_ALLB sy-vline
WA_PTH_HTHCTX91_DATA_STR-IAF_EX_ALLS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHARITYEDUB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHARITYEDUS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TXBL_INCB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TXBL_INCS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHARITYB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHARITYS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TXBL_INC2B sy-vline
WA_PTH_HTHCTX91_DATA_STR-TXBL_INC2S sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAX_PAIDB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAX_PAIDS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CALC_IMMOB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CALC_IMMOS sy-vline
WA_PTH_HTHCTX91_DATA_STR-INFTY_IMMOB sy-vline
WA_PTH_HTHCTX91_DATA_STR-INFTY_IMMOS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CALC_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CALC_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TX_PYBLB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TX_PYBLS sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADDL_TX sy-vline
WA_PTH_HTHCTX91_DATA_STR-OV_TX sy-vline
WA_PTH_HTHCTX91_DATA_STR-BLCE_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-BLCE_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADL_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADL_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-OVPD_TXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-OVPD_TXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-LESS_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-LESS_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-PLUSB sy-vline
WA_PTH_HTHCTX91_DATA_STR-PLUSS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-PF_ALLWB sy-vline
WA_PTH_HTHCTX91_DATA_STR-PF_ALLWS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CVLSRVT_FB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CVLSRVT_FS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SCHTCHR_FB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SCHTCHR_FS sy-vline
WA_PTH_HTHCTX91_DATA_STR-DI65_ALLWB sy-vline
WA_PTH_HTHCTX91_DATA_STR-DI65_ALLWS sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXEMPTB sy-vline
WA_PTH_HTHCTX91_DATA_STR-NEXEMPTB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SEVR_PAYB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SEVR_PAYS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAX_PAYERB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAX_PAYERS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SPSE_30KB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SPSE_30KS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHNO1 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHNO3 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH_15KB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH_15KS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH_17KB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH_17KS sy-vline
WA_PTH_HTHCTX91_DATA_STR-FTX_C4 sy-vline
WA_PTH_HTHCTX91_DATA_STR-MTX_C4 sy-vline
WA_PTH_HTHCTX91_DATA_STR-SFX_C4 sy-vline
WA_PTH_HTHCTX91_DATA_STR-SMX_C4 sy-vline
WA_PTH_HTHCTX91_DATA_STR-FATHERB sy-vline
WA_PTH_HTHCTX91_DATA_STR-FATHERS sy-vline
WA_PTH_HTHCTX91_DATA_STR-MOTHERB sy-vline
WA_PTH_HTHCTX91_DATA_STR-MOTHERS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_FATHERB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_FATHERS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_MOTHERB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SP_MOTHERS sy-vline
WA_PTH_HTHCTX91_DATA_STR-DI_60KB sy-vline
WA_PTH_HTHCTX91_DATA_STR-DI_60KS sy-vline
WA_PTH_HTHCTX91_DATA_STR-FTX sy-vline
WA_PTH_HTHCTX91_DATA_STR-MTX sy-vline
WA_PTH_HTHCTX91_DATA_STR-PARENT_INSB sy-vline
WA_PTH_HTHCTX91_DATA_STR-PARENT_INSS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SFX sy-vline
WA_PTH_HTHCTX91_DATA_STR-SMX sy-vline
WA_PTH_HTHCTX91_DATA_STR-INS_PRB sy-vline
WA_PTH_HTHCTX91_DATA_STR-INS_PRS sy-vline
WA_PTH_HTHCTX91_DATA_STR-INS_PRPB sy-vline
WA_PTH_HTHCTX91_DATA_STR-INS_PRPS sy-vline
WA_PTH_HTHCTX91_DATA_STR-PROV_FUNDB sy-vline
WA_PTH_HTHCTX91_DATA_STR-PROV_FUNDS sy-vline
WA_PTH_HTHCTX91_DATA_STR-MF_ALLWB sy-vline
WA_PTH_HTHCTX91_DATA_STR-MF_ALLWS sy-vline
WA_PTH_HTHCTX91_DATA_STR-LTEFB sy-vline
WA_PTH_HTHCTX91_DATA_STR-LTEFS sy-vline
WA_PTH_HTHCTX91_DATA_STR-HSE_ALLWB sy-vline
WA_PTH_HTHCTX91_DATA_STR-HSE_ALLWS sy-vline
WA_PTH_HTHCTX91_DATA_STR-IMMV_ALLB sy-vline
WA_PTH_HTHCTX91_DATA_STR-IMMV_ALLS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SOCSOB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SOCSOS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TUREXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TUREXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH15_ID1 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH15_ID2 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH15_ID3 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH17_ID1 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH17_ID2 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH17_ID3 sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAXEXEMPT_GOODSB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAXEXEMPT_GOODSS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CALC_IMMEXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CALC_IMMEXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-INFTY_IMMEXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-INFTY_IMMEXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SONGKRAN_EXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SONGKRAN_EXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-OTOPEXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-OTOPEXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TR16_EXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TR16_EXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-FLOOD_DOB sy-vline
WA_PTH_HTHCTX91_DATA_STR-FLOOD_DOS sy-vline
WA_PTH_HTHCTX91_DATA_STR-HEALTH_INSB sy-vline
WA_PTH_HTHCTX91_DATA_STR-HEALTH_INSS sy-vline
WA_PTH_HTHCTX91_DATA_STR-FLOOD_HOMEB sy-vline
WA_PTH_HTHCTX91_DATA_STR-FLOOD_HOMES sy-vline
WA_PTH_HTHCTX91_DATA_STR-FLOOD_CARB sy-vline
WA_PTH_HTHCTX91_DATA_STR-FLOOD_CARS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TXBL_INC3B sy-vline
WA_PTH_HTHCTX91_DATA_STR-TXBL_INC3S sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH15_ID4 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH15_ID5 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH15_ID6 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH15_ID7 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHNO4 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH_60KB sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH_60KS sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH60_ID1 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH60_ID2 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH60_ID3 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH60_ID4 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CH60_ID5 sy-vline
WA_PTH_HTHCTX91_DATA_STR-MATERNITYB sy-vline
WA_PTH_HTHCTX91_DATA_STR-MATERNITYS sy-vline
WA_PTH_HTHCTX91_DATA_STR-YE_BOOKB sy-vline
WA_PTH_HTHCTX91_DATA_STR-YE_BOOKS sy-vline
WA_PTH_HTHCTX91_DATA_STR-YE_TYREB sy-vline
WA_PTH_HTHCTX91_DATA_STR-YE_TYRES sy-vline
WA_PTH_HTHCTX91_DATA_STR-PARTY_DOB sy-vline
WA_PTH_HTHCTX91_DATA_STR-PARTY_DOS sy-vline
WA_PTH_HTHCTX91_DATA_STR-STORM_HOMEB sy-vline
WA_PTH_HTHCTX91_DATA_STR-STORM_HOMES sy-vline
WA_PTH_HTHCTX91_DATA_STR-STORM_CARB sy-vline
WA_PTH_HTHCTX91_DATA_STR-STORM_CARS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TR_MAINB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TR_MAINS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TR_MINORB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TR_MINORS sy-vline
WA_PTH_HTHCTX91_DATA_STR-EDUSP_EXPB sy-vline
WA_PTH_HTHCTX91_DATA_STR-EDUSP_EXPS sy-vline
WA_PTH_HTHCTX91_DATA_STR-OTOP2_EXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-OTOP2_EXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-BOOKS_EXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-BOOKS_EXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-RE_VALUEB sy-vline
WA_PTH_HTHCTX91_DATA_STR-RE_VALUES sy-vline
WA_PTH_HTHCTX91_DATA_STR-RE_EXPB sy-vline
WA_PTH_HTHCTX91_DATA_STR-RE_EXPS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SSF_EXPB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SSF_EXPS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SSFX_EXPB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SSFX_EXPS sy-vline
WA_PTH_HTHCTX91_DATA_STR-ATTACHMENT sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHK_H1 sy-vline
WA_PTH_HTHCTX91_DATA_STR-CHK_H2 sy-vline
WA_PTH_HTHCTX91_DATA_STR-HLINE sy-vline
WA_PTH_HTHCTX91_DATA_STR-ER_ADDR sy-vline
WA_PTH_HTHCTX91_DATA_STR-EE_YRS sy-vline
WA_PTH_HTHCTX91_DATA_STR-GOV_GRAB sy-vline
WA_PTH_HTHCTX91_DATA_STR-GOV_GRAS sy-vline
WA_PTH_HTHCTX91_DATA_STR-PRO_FUNB sy-vline
WA_PTH_HTHCTX91_DATA_STR-PRO_FUNS sy-vline
WA_PTH_HTHCTX91_DATA_STR-SEV_PAYB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SEV_PAYS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_ONEB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_ONES sy-vline
WA_PTH_HTHCTX91_DATA_STR-LUM_SUMB sy-vline
WA_PTH_HTHCTX91_DATA_STR-LUM_SUMS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_4T5B sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_4T5S sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXEMPT_OAE sy-vline
WA_PTH_HTHCTX91_DATA_STR-NEXEMPT_OAE sy-vline
WA_PTH_HTHCTX91_DATA_STR-OLD_EXMB sy-vline
WA_PTH_HTHCTX91_DATA_STR-OLD_EXMS sy-vline
WA_PTH_HTHCTX91_DATA_STR-BALANCEB sy-vline
WA_PTH_HTHCTX91_DATA_STR-BALANCES sy-vline
WA_PTH_HTHCTX91_DATA_STR-NET_INCB sy-vline
WA_PTH_HTHCTX91_DATA_STR-NET_INCS sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAX_CALB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TAX_CALS sy-vline
WA_PTH_HTHCTX91_DATA_STR-WTH_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-WTH_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADD_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-ADD_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-OVR_TAXB sy-vline
WA_PTH_HTHCTX91_DATA_STR-OVR_TAXS sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXM_INCB sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXM_INCS sy-vline
WA_PTH_HTHCTX91_DATA_STR-AVG_SALB sy-vline
WA_PTH_HTHCTX91_DATA_STR-AVG_SALS sy-vline
WA_PTH_HTHCTX91_DATA_STR-YRS_SERB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SAL_RCDB sy-vline
WA_PTH_HTHCTX91_DATA_STR-SAL_RCDS sy-vline
WA_PTH_HTHCTX91_DATA_STR-BAS_SALB sy-vline
WA_PTH_HTHCTX91_DATA_STR-BAS_SALS sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXPNS_1B sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXPNS_1S sy-vline
WA_PTH_HTHCTX91_DATA_STR-BAL_2_3B sy-vline
WA_PTH_HTHCTX91_DATA_STR-BAL_2_3S sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXPNS_2B sy-vline
WA_PTH_HTHCTX91_DATA_STR-EXPNS_2S sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_EXPB sy-vline
WA_PTH_HTHCTX91_DATA_STR-TOT_EXPS sy-vline
WA_PTH_HTHCTX91_DATA_STR-KOSTL sy-vline
WA_PTH_HTHCTX91_DATA_STR-ORGEH sy-vline
WA_PTH_HTHCTX91_DATA_STR-PERNR sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
