ABAP Select data from SAP table PJP_HCMPF_DEP 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 PJP_HCMPF_DEP 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 PJP_HCMPF_DEP. 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 PJP_HCMPF_DEP 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_PJP_HCMPF_DEP TYPE STANDARD TABLE OF PJP_HCMPF_DEP,
WA_PJP_HCMPF_DEP TYPE PJP_HCMPF_DEP,
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: <PJP_HCMPF_DEP> TYPE PJP_HCMPF_DEP.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_PJP_HCMPF_DEP.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM PJP_HCMPF_DEP
INTO TABLE IT_PJP_HCMPF_DEP.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM PJP_HCMPF_DEP
* INTO TABLE @DATA(IT_PJP_HCMPF_DEP2).
*--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_PJP_HCMPF_DEP INDEX 1 INTO DATA(WA_PJP_HCMPF_DEP2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PJP_HCMPF_DEP ASSIGNING <PJP_HCMPF_DEP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<PJP_HCMPF_DEP>-D_BD1 = 1.
<PJP_HCMPF_DEP>-D_BM1 = 1.
<PJP_HCMPF_DEP>-D_BY1 = 1.
<PJP_HCMPF_DEP>-D_LI1 = 1.
<PJP_HCMPF_DEP>-D_OL1 = 1.
ENDLOOP. LOOP AT IT_PJP_HCMPF_DEP INTO WA_PJP_HCMPF_DEP. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_PJP_HCMPF_DEP-D_RE1, sy-vline,
WA_PJP_HCMPF_DEP-D_SH1, sy-vline,
WA_PJP_HCMPF_DEP-D_SP1, sy-vline,
WA_PJP_HCMPF_DEP-DEP_NAM1, sy-vline,
WA_PJP_HCMPF_DEP-D_BD2, sy-vline,
WA_PJP_HCMPF_DEP-D_BM2, sy-vline.
ENDLOOP. *Add any further fields from structure WA_PJP_HCMPF_DEP 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_PJP_HCMPF_DEP 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_PJP_HCMPF_DEP INTO WA_PJP_HCMPF_DEP. *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_PJP_HCMPF_DEP_STR,
D_BD1 TYPE STRING,
D_BM1 TYPE STRING,
D_BY1 TYPE STRING,
D_LI1 TYPE STRING,
D_OL1 TYPE STRING,
D_RE1 TYPE STRING,
D_SH1 TYPE STRING,
D_SP1 TYPE STRING,
DEP_NAM1 TYPE STRING,
D_BD2 TYPE STRING,
D_BM2 TYPE STRING,
D_BY2 TYPE STRING,
D_LI2 TYPE STRING,
D_OL2 TYPE STRING,
D_RE2 TYPE STRING,
D_SH2 TYPE STRING,
D_SP2 TYPE STRING,
DEP_NAM2 TYPE STRING,
D_BD3 TYPE STRING,
D_BM3 TYPE STRING,
D_BY3 TYPE STRING,
D_LI3 TYPE STRING,
D_OL3 TYPE STRING,
D_RE3 TYPE STRING,
D_SH3 TYPE STRING,
D_SP3 TYPE STRING,
DEP_NAM3 TYPE STRING,
D_BD4 TYPE STRING,
D_BM4 TYPE STRING,
D_BY4 TYPE STRING,
D_LI4 TYPE STRING,
D_OL4 TYPE STRING,
D_RE4 TYPE STRING,
D_SH4 TYPE STRING,
D_SP4 TYPE STRING,
DEP_NAM4 TYPE STRING,
D_BD5 TYPE STRING,
D_BM5 TYPE STRING,
D_BY5 TYPE STRING,
D_LI5 TYPE STRING,
D_OL5 TYPE STRING,
D_RE5 TYPE STRING,
D_SH5 TYPE STRING,
D_SP5 TYPE STRING,
DEP_NAM5 TYPE STRING,
EMP_ADDR TYPE STRING,
E_BDY TYPE STRING,
E_BMO TYPE STRING,
E_BYR TYPE STRING,
EMP_KANA TYPE STRING,
EMP_NAME TYPE STRING,
E_PS1 TYPE STRING,
E_PS2 TYPE STRING,
EMR_ADDR TYPE STRING,
ER_NM TYPE STRING,
H_DEP TYPE STRING,
HAN_DEP_M TYPE STRING,
H_EMP TYPE STRING,
H_SPO TYPE STRING,
L_DEP TYPE STRING,
LSH_DEP_M TYPE STRING,
L_SPO TYPE STRING,
O_PER TYPE STRING,
SH_DE TYPE STRING,
SHA_DEP_M TYPE STRING,
SH_EM TYPE STRING,
SH_SP TYPE STRING,
SP_WI TYPE STRING,
S_ATT TYPE STRING,
S_BDY TYPE STRING,
S_BMO TYPE STRING,
S_BYR TYPE STRING,
SPO_NAME TYPE STRING,
S_NAT TYPE STRING,
S_ODE TYPE STRING,
ST_WO TYPE STRING,
WIDOW TYPE STRING,
WIDOR TYPE STRING,
OYEAR TYPE STRING,
D_RS1 TYPE STRING,
D_RS2 TYPE STRING,
D_RS3 TYPE STRING,
D_RS4 TYPE STRING,
D_RS5 TYPE STRING,
DEP_RES_BD1 TYPE STRING,
DEP_RES_BM1 TYPE STRING,
DEP_RES_BY1 TYPE STRING,
DEP_RES_RE1 TYPE STRING,
DEP_RES_NAM1 TYPE STRING,
MUNICI_TEXT TYPE STRING,
DEP_RES_BD2 TYPE STRING,
DEP_RES_BM2 TYPE STRING,
DEP_RES_BY2 TYPE STRING,
DEP_RES_RE2 TYPE STRING,
DEP_RES_NAM2 TYPE STRING,
DEP_RES_BD3 TYPE STRING,
DEP_RES_BM3 TYPE STRING,
DEP_RES_BY3 TYPE STRING,
DEP_RES_RE3 TYPE STRING,
DEP_RES_NAM3 TYPE STRING,
DEP_LIVE1 TYPE STRING,
DEP_LIVE2 TYPE STRING,
DEP_LIVE3 TYPE STRING,
DEP_LIVE4 TYPE STRING,
DEP_LIVE5 TYPE STRING,
RES_LIVE1 TYPE STRING,
RES_LIVE2 TYPE STRING,
RES_LIVE3 TYPE STRING,
SPO_LIVE1 TYPE STRING,
H_HLD_NM TYPE STRING,
H_HLD_RE TYPE STRING,
S_ADDR TYPE STRING,
S_REASON TYPE STRING,
D_ADDR1 TYPE STRING,
D_REASON1 TYPE STRING,
D_ADDR2 TYPE STRING,
D_REASON2 TYPE STRING,
D_ADDR3 TYPE STRING,
D_REASON3 TYPE STRING,
D_ADDR4 TYPE STRING,
D_REASON4 TYPE STRING,
D_ADDR5 TYPE STRING,
D_REASON5 TYPE STRING,
C_DEP_CNTS TYPE STRING,
C_DEP_RSN TYPE STRING,
C_EMR_CNTS TYPE STRING,
C_EMR_RSN TYPE STRING,
DEP_EAR_NM1 TYPE STRING,
DEP_EAR_RE1 TYPE STRING,
DEP_EAR_BY1 TYPE STRING,
DEP_EAR_BM1 TYPE STRING,
DEP_EAR_BD1 TYPE STRING,
DEP_EAR_ADDR1 TYPE STRING,
DEP_EAR_RSN1 TYPE STRING,
DEP_EAR_D_NM1 TYPE STRING,
DEP_EAR_D_RE1 TYPE STRING,
DEP_EAR_D_ADDR1 TYPE STRING,
DEP_EAR_NM2 TYPE STRING,
DEP_EAR_RE2 TYPE STRING,
DEP_EAR_BY2 TYPE STRING,
DEP_EAR_BM2 TYPE STRING,
DEP_EAR_BD2 TYPE STRING,
DEP_EAR_ADDR2 TYPE STRING,
DEP_EAR_RSN2 TYPE STRING,
DEP_EAR_D_NM2 TYPE STRING,
DEP_EAR_D_RE2 TYPE STRING,
DEP_EAR_D_ADDR2 TYPE STRING,
DEP_RES_ADDR1 TYPE STRING,
DEP_RES_RSN1 TYPE STRING,
DEP_RES_ADDR2 TYPE STRING,
DEP_RES_RSN2 TYPE STRING,
DEP_RES_ADDR3 TYPE STRING,
DEP_RES_RSN3 TYPE STRING,
SPECDEP_START_YR TYPE STRING,
SPECDEP_END_YR TYPE STRING,
OLDDEP_BIRTH_YR TYPE STRING,
UND16_BIRTH_YR TYPE STRING,
D_BD6 TYPE STRING,
D_BM6 TYPE STRING,
D_BY6 TYPE STRING,
D_LI6 TYPE STRING,
D_OL6 TYPE STRING,
D_RE6 TYPE STRING,
D_SH6 TYPE STRING,
D_SP6 TYPE STRING,
DEP_NAM6 TYPE STRING,
D_BD7 TYPE STRING,
D_BM7 TYPE STRING,
D_BY7 TYPE STRING,
D_LI7 TYPE STRING,
D_OL7 TYPE STRING,
D_RE7 TYPE STRING,
D_SH7 TYPE STRING,
D_SP7 TYPE STRING,
DEP_NAM7 TYPE STRING,
D_BD8 TYPE STRING,
D_BM8 TYPE STRING,
D_BY8 TYPE STRING,
D_LI8 TYPE STRING,
D_OL8 TYPE STRING,
D_RE8 TYPE STRING,
D_SH8 TYPE STRING,
D_SP8 TYPE STRING,
DEP_NAM8 TYPE STRING,
D_BD9 TYPE STRING,
D_BM9 TYPE STRING,
D_BY9 TYPE STRING,
D_LI9 TYPE STRING,
D_OL9 TYPE STRING,
D_RE9 TYPE STRING,
D_SH9 TYPE STRING,
D_SP9 TYPE STRING,
DEP_NAM9 TYPE STRING,
D_BD10 TYPE STRING,
D_BM10 TYPE STRING,
D_BY10 TYPE STRING,
D_LI10 TYPE STRING,
D_OL10 TYPE STRING,
D_RE10 TYPE STRING,
D_SH10 TYPE STRING,
D_SP10 TYPE STRING,
DEP_NAM10 TYPE STRING,
DEP_RES_BD4 TYPE STRING,
DEP_RES_BM4 TYPE STRING,
DEP_RES_BY4 TYPE STRING,
DEP_RES_RE4 TYPE STRING,
DEP_RES_NAM4 TYPE STRING,
DEP_RES_BD5 TYPE STRING,
DEP_RES_BM5 TYPE STRING,
DEP_RES_BY5 TYPE STRING,
DEP_RES_RE5 TYPE STRING,
DEP_RES_NAM5 TYPE STRING,
DEP_RES_BD6 TYPE STRING,
DEP_RES_BM6 TYPE STRING,
DEP_RES_BY6 TYPE STRING,
DEP_RES_RE6 TYPE STRING,
DEP_RES_NAM6 TYPE STRING,
D_ADDR6 TYPE STRING,
D_REASON6 TYPE STRING,
D_ADDR7 TYPE STRING,
D_REASON7 TYPE STRING,
D_ADDR8 TYPE STRING,
D_REASON8 TYPE STRING,
D_ADDR9 TYPE STRING,
D_REASON9 TYPE STRING,
D_ADDR10 TYPE STRING,
D_REASON10 TYPE STRING,
DEP_EAR_NM3 TYPE STRING,
DEP_EAR_RE3 TYPE STRING,
DEP_EAR_BY3 TYPE STRING,
DEP_EAR_BM3 TYPE STRING,
DEP_EAR_BD3 TYPE STRING,
DEP_EAR_ADDR3 TYPE STRING,
DEP_EAR_RSN3 TYPE STRING,
DEP_EAR_D_NM3 TYPE STRING,
DEP_EAR_D_RE3 TYPE STRING,
DEP_EAR_D_ADDR3 TYPE STRING,
DEP_EAR_NM4 TYPE STRING,
DEP_EAR_RE4 TYPE STRING,
DEP_EAR_BY4 TYPE STRING,
DEP_EAR_BM4 TYPE STRING,
DEP_EAR_BD4 TYPE STRING,
DEP_EAR_ADDR4 TYPE STRING,
DEP_EAR_RSN4 TYPE STRING,
DEP_EAR_D_NM4 TYPE STRING,
DEP_EAR_D_RE4 TYPE STRING,
DEP_EAR_D_ADDR4 TYPE STRING,
DEP_RES_ADDR4 TYPE STRING,
DEP_RES_RSN4 TYPE STRING,
DEP_RES_ADDR5 TYPE STRING,
DEP_RES_RSN5 TYPE STRING,
DEP_RES_ADDR6 TYPE STRING,
DEP_RES_RSN6 TYPE STRING,
S_INCOME TYPE STRING,
D_INCOME1 TYPE STRING,
D_INCOME2 TYPE STRING,
D_INCOME3 TYPE STRING,
D_INCOME4 TYPE STRING,
D_INCOME5 TYPE STRING,
D_INCOME6 TYPE STRING,
D_INCOME7 TYPE STRING,
D_INCOME8 TYPE STRING,
D_INCOME9 TYPE STRING,
D_INCOME10 TYPE STRING,
DEP_RES_INC1 TYPE STRING,
DEP_RES_INC2 TYPE STRING,
DEP_RES_INC3 TYPE STRING,
DEP_RES_INC4 TYPE STRING,
DEP_RES_INC5 TYPE STRING,
DEP_RES_INC6 TYPE STRING,
ATT_HD_BUKRS TYPE STRING,
ATT_HD_WERKS TYPE STRING,
ATT_HD_BTRTL TYPE STRING,
ATT_HD_ORGEH TYPE STRING,
EMR_CORPN TYPE STRING,
EMP_INDNR TYPE STRING,
CONFIRM_INDNR TYPE STRING,
SPO_INDNR TYPE STRING,
DEP_INDNR1 TYPE STRING,
DEP_INDNR2 TYPE STRING,
DEP_INDNR3 TYPE STRING,
DEP_INDNR4 TYPE STRING,
DEP_INDNR5 TYPE STRING,
DEP_INDNR6 TYPE STRING,
DEP_INDNR7 TYPE STRING,
DEP_INDNR8 TYPE STRING,
DEP_INDNR9 TYPE STRING,
DEP_INDNR10 TYPE STRING,
DEP_RES_INDNR1 TYPE STRING,
DEP_RES_INDNR2 TYPE STRING,
DEP_RES_INDNR3 TYPE STRING,
DEP_RES_INDNR4 TYPE STRING,
DEP_RES_INDNR5 TYPE STRING,
DEP_RES_INDNR6 TYPE STRING,
SPO_NONRE TYPE STRING,
DEP_NONRE1 TYPE STRING,
DEP_NONRE2 TYPE STRING,
DEP_NONRE3 TYPE STRING,
DEP_NONRE4 TYPE STRING,
DEP_NONRE5 TYPE STRING,
DEP_NONRE6 TYPE STRING,
DEP_NONRE7 TYPE STRING,
DEP_NONRE8 TYPE STRING,
DEP_NONRE9 TYPE STRING,
DEP_NONRE10 TYPE STRING,
SPO_FACT TYPE STRING,
DEP_FACT1 TYPE STRING,
DEP_FACT2 TYPE STRING,
DEP_FACT3 TYPE STRING,
DEP_FACT4 TYPE STRING,
DEP_FACT5 TYPE STRING,
DEP_FACT6 TYPE STRING,
DEP_FACT7 TYPE STRING,
DEP_FACT8 TYPE STRING,
DEP_FACT9 TYPE STRING,
DEP_FACT10 TYPE STRING,
DEP_RES_NONRE1 TYPE STRING,
DEP_RES_NONRE2 TYPE STRING,
DEP_RES_NONRE3 TYPE STRING,
DEP_RES_NONRE4 TYPE STRING,
DEP_RES_NONRE5 TYPE STRING,
DEP_RES_NONRE6 TYPE STRING,
SPO_KANA TYPE STRING,
DEP_KANA1 TYPE STRING,
DEP_KANA2 TYPE STRING,
DEP_KANA3 TYPE STRING,
DEP_KANA4 TYPE STRING,
DEP_KANA5 TYPE STRING,
DEP_KANA6 TYPE STRING,
DEP_KANA7 TYPE STRING,
DEP_KANA8 TYPE STRING,
DEP_KANA9 TYPE STRING,
DEP_KANA10 TYPE STRING,
DEP_EAR_KN1 TYPE STRING,
DEP_EAR_KN2 TYPE STRING,
DEP_EAR_KN3 TYPE STRING,
DEP_EAR_KN4 TYPE STRING,
DEP_RES_KN1 TYPE STRING,
DEP_RES_KN2 TYPE STRING,
DEP_RES_KN3 TYPE STRING,
DEP_RES_KN4 TYPE STRING,
DEP_RES_KN5 TYPE STRING,
DEP_RES_KN6 TYPE STRING,
TAXOF TYPE STRING,END OF T_EKKO_STR. DATA: WA_PJP_HCMPF_DEP_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_PJP_HCMPF_DEP_STR-D_BD1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM5 sy-vline
WA_PJP_HCMPF_DEP_STR-EMP_ADDR sy-vline
WA_PJP_HCMPF_DEP_STR-E_BDY sy-vline
WA_PJP_HCMPF_DEP_STR-E_BMO sy-vline
WA_PJP_HCMPF_DEP_STR-E_BYR sy-vline
WA_PJP_HCMPF_DEP_STR-EMP_KANA sy-vline
WA_PJP_HCMPF_DEP_STR-EMP_NAME sy-vline
WA_PJP_HCMPF_DEP_STR-E_PS1 sy-vline
WA_PJP_HCMPF_DEP_STR-E_PS2 sy-vline
WA_PJP_HCMPF_DEP_STR-EMR_ADDR sy-vline
WA_PJP_HCMPF_DEP_STR-ER_NM sy-vline
WA_PJP_HCMPF_DEP_STR-H_DEP sy-vline
WA_PJP_HCMPF_DEP_STR-HAN_DEP_M sy-vline
WA_PJP_HCMPF_DEP_STR-H_EMP sy-vline
WA_PJP_HCMPF_DEP_STR-H_SPO sy-vline
WA_PJP_HCMPF_DEP_STR-L_DEP sy-vline
WA_PJP_HCMPF_DEP_STR-LSH_DEP_M sy-vline
WA_PJP_HCMPF_DEP_STR-L_SPO sy-vline
WA_PJP_HCMPF_DEP_STR-O_PER sy-vline
WA_PJP_HCMPF_DEP_STR-SH_DE sy-vline
WA_PJP_HCMPF_DEP_STR-SHA_DEP_M sy-vline
WA_PJP_HCMPF_DEP_STR-SH_EM sy-vline
WA_PJP_HCMPF_DEP_STR-SH_SP sy-vline
WA_PJP_HCMPF_DEP_STR-SP_WI sy-vline
WA_PJP_HCMPF_DEP_STR-S_ATT sy-vline
WA_PJP_HCMPF_DEP_STR-S_BDY sy-vline
WA_PJP_HCMPF_DEP_STR-S_BMO sy-vline
WA_PJP_HCMPF_DEP_STR-S_BYR sy-vline
WA_PJP_HCMPF_DEP_STR-SPO_NAME sy-vline
WA_PJP_HCMPF_DEP_STR-S_NAT sy-vline
WA_PJP_HCMPF_DEP_STR-S_ODE sy-vline
WA_PJP_HCMPF_DEP_STR-ST_WO sy-vline
WA_PJP_HCMPF_DEP_STR-WIDOW sy-vline
WA_PJP_HCMPF_DEP_STR-WIDOR sy-vline
WA_PJP_HCMPF_DEP_STR-OYEAR sy-vline
WA_PJP_HCMPF_DEP_STR-D_RS1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RS2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RS3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RS4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RS5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BD1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BM1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BY1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RE1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NAM1 sy-vline
WA_PJP_HCMPF_DEP_STR-MUNICI_TEXT sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BD2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BM2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BY2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RE2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NAM2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BD3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BM3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BY3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RE3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NAM3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_LIVE1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_LIVE2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_LIVE3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_LIVE4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_LIVE5 sy-vline
WA_PJP_HCMPF_DEP_STR-RES_LIVE1 sy-vline
WA_PJP_HCMPF_DEP_STR-RES_LIVE2 sy-vline
WA_PJP_HCMPF_DEP_STR-RES_LIVE3 sy-vline
WA_PJP_HCMPF_DEP_STR-SPO_LIVE1 sy-vline
WA_PJP_HCMPF_DEP_STR-H_HLD_NM sy-vline
WA_PJP_HCMPF_DEP_STR-H_HLD_RE sy-vline
WA_PJP_HCMPF_DEP_STR-S_ADDR sy-vline
WA_PJP_HCMPF_DEP_STR-S_REASON sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON5 sy-vline
WA_PJP_HCMPF_DEP_STR-C_DEP_CNTS sy-vline
WA_PJP_HCMPF_DEP_STR-C_DEP_RSN sy-vline
WA_PJP_HCMPF_DEP_STR-C_EMR_CNTS sy-vline
WA_PJP_HCMPF_DEP_STR-C_EMR_RSN sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_NM1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RE1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BY1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BM1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BD1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_ADDR1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RSN1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_NM1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_RE1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_ADDR1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_NM2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RE2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BY2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BM2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BD2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_ADDR2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RSN2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_NM2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_RE2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_ADDR2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_ADDR1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RSN1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_ADDR2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RSN2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_ADDR3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RSN3 sy-vline
WA_PJP_HCMPF_DEP_STR-SPECDEP_START_YR sy-vline
WA_PJP_HCMPF_DEP_STR-SPECDEP_END_YR sy-vline
WA_PJP_HCMPF_DEP_STR-OLDDEP_BIRTH_YR sy-vline
WA_PJP_HCMPF_DEP_STR-UND16_BIRTH_YR sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP7 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP8 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP9 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BD10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BM10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_BY10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_LI10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_OL10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_RE10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SH10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_SP10 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NAM10 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BD4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BM4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BY4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RE4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NAM4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BD5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BM5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BY5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RE5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NAM5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BD6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BM6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_BY6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RE6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NAM6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_ADDR10 sy-vline
WA_PJP_HCMPF_DEP_STR-D_REASON10 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_NM3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RE3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BY3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BM3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BD3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_ADDR3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RSN3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_NM3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_RE3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_ADDR3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_NM4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RE4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BY4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BM4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_BD4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_ADDR4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_RSN4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_NM4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_RE4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_D_ADDR4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_ADDR4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RSN4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_ADDR5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RSN5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_ADDR6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_RSN6 sy-vline
WA_PJP_HCMPF_DEP_STR-S_INCOME sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME1 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME2 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME3 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME4 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME5 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME6 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME7 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME8 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME9 sy-vline
WA_PJP_HCMPF_DEP_STR-D_INCOME10 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INC1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INC2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INC3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INC4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INC5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INC6 sy-vline
WA_PJP_HCMPF_DEP_STR-ATT_HD_BUKRS sy-vline
WA_PJP_HCMPF_DEP_STR-ATT_HD_WERKS sy-vline
WA_PJP_HCMPF_DEP_STR-ATT_HD_BTRTL sy-vline
WA_PJP_HCMPF_DEP_STR-ATT_HD_ORGEH sy-vline
WA_PJP_HCMPF_DEP_STR-EMR_CORPN sy-vline
WA_PJP_HCMPF_DEP_STR-EMP_INDNR sy-vline
WA_PJP_HCMPF_DEP_STR-CONFIRM_INDNR sy-vline
WA_PJP_HCMPF_DEP_STR-SPO_INDNR sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR7 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR8 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR9 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_INDNR10 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INDNR1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INDNR2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INDNR3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INDNR4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INDNR5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_INDNR6 sy-vline
WA_PJP_HCMPF_DEP_STR-SPO_NONRE sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE7 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE8 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE9 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_NONRE10 sy-vline
WA_PJP_HCMPF_DEP_STR-SPO_FACT sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT7 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT8 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT9 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_FACT10 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NONRE1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NONRE2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NONRE3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NONRE4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NONRE5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_NONRE6 sy-vline
WA_PJP_HCMPF_DEP_STR-SPO_KANA sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA6 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA7 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA8 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA9 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_KANA10 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_KN1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_KN2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_KN3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_EAR_KN4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_KN1 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_KN2 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_KN3 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_KN4 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_KN5 sy-vline
WA_PJP_HCMPF_DEP_STR-DEP_RES_KN6 sy-vline
WA_PJP_HCMPF_DEP_STR-TAXOF sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.