ABAP Select data from SAP table PAD_SFEC_CE_JOB_INFO into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP PAD_SFEC_CE_JOB_INFO 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 PAD_SFEC_CE_JOB_INFO. 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 PAD_SFEC_CE_JOB_INFO 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_PAD_SFEC_CE_JOB_INFO TYPE STANDARD TABLE OF PAD_SFEC_CE_JOB_INFO,
      WA_PAD_SFEC_CE_JOB_INFO TYPE PAD_SFEC_CE_JOB_INFO,
      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: <PAD_SFEC_CE_JOB_INFO> TYPE PAD_SFEC_CE_JOB_INFO.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PAD_SFEC_CE_JOB_INFO
*  INTO TABLE @DATA(IT_PAD_SFEC_CE_JOB_INFO2).
*--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_PAD_SFEC_CE_JOB_INFO INDEX 1 INTO DATA(WA_PAD_SFEC_CE_JOB_INFO2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PAD_SFEC_CE_JOB_INFO ASSIGNING <PAD_SFEC_CE_JOB_INFO>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PAD_SFEC_CE_JOB_INFO>-NOTICE_PERIOD_START_DATE = 1.
<PAD_SFEC_CE_JOB_INFO>-VALID_FROM = 1.
<PAD_SFEC_CE_JOB_INFO>-WORK_PERMIT_EXPIRY = 1.
<PAD_SFEC_CE_JOB_INFO>-CONTRACT_DATE = 1.
<PAD_SFEC_CE_JOB_INFO>-PROBATION_PERIOD_END_DATE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PAD_SFEC_CE_JOB_INFO-END_DATE, sy-vline,
  WA_PAD_SFEC_CE_JOB_INFO-START_DATE, sy-vline,
  WA_PAD_SFEC_CE_JOB_INFO-BUSINESS_UNIT, sy-vline,
  WA_PAD_SFEC_CE_JOB_INFO-COMMITMENT_INDICATOR, sy-vline,
  WA_PAD_SFEC_CE_JOB_INFO-COMPANY, sy-vline,
  WA_PAD_SFEC_CE_JOB_INFO-COMPANY_TERRITORY_CODE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PAD_SFEC_CE_JOB_INFO 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_PAD_SFEC_CE_JOB_INFO 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_PAD_SFEC_CE_JOB_INFO INTO WA_PAD_SFEC_CE_JOB_INFO.


*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_PAD_SFEC_CE_JOB_INFO_STR, 
NOTICE_PERIOD_START_DATE TYPE STRING,
VALID_FROM TYPE STRING,
WORK_PERMIT_EXPIRY TYPE STRING,
CONTRACT_DATE TYPE STRING,
PROBATION_PERIOD_END_DATE TYPE STRING,
END_DATE TYPE STRING,
START_DATE TYPE STRING,
BUSINESS_UNIT TYPE STRING,
COMMITMENT_INDICATOR TYPE STRING,
COMPANY TYPE STRING,
COMPANY_TERRITORY_CODE TYPE STRING,
COMPANYENTRYDATE TYPE STRING,
CONTRACT_END_DATE TYPE STRING,
CONTRACT_TYPE TYPE STRING,
CORPORATION TYPE STRING,
COST_CENTER TYPE STRING,
DEPARTMENT TYPE STRING,
DEPARTMENTENTRYDATE TYPE STRING,
DIVISION TYPE STRING,
EDUCATIONAL_ENTITY TYPE STRING,
EMP_RELATIONSHIP TYPE STRING,
EMPLOYEE_CLASS TYPE STRING,
EMPLOYMENT_TYPE TYPE STRING,
EMPLSTATUS TYPE STRING,
ENTRY_INTO_GROUP TYPE STRING,
EVENT TYPE STRING,
EVENT_REASON TYPE STRING,
FGTS_DATE TYPE STRING,
FGTS_OPTANT TYPE STRING,
FGTS_PERCENT TYPE STRING,
VALUE TYPE STRING,
FTE TYPE STRING,
VALUE TYPE STRING,
HARMFUL_AGENT_EXPOSURE TYPE STRING,
HAZARD TYPE STRING,
HEALTH_RISK TYPE STRING,
HIREDATE TYPE STRING,
INITIAL_ENTRY_DATE TYPE STRING,
INTEGRATION_AGENT TYPE STRING,
INTERNSHIP_LEVEL TYPE STRING,
INTERNSHIP_SCHOOL TYPE STRING,
IS_FULLTIME_EMPLOYEE TYPE STRING,
JOB_CODE TYPE STRING,
JOBENTRYDATE TYPE STRING,
LEAVEOFABSENCERETURNDATE TYPE STRING,
LEAVEOFABSENCESTARTDATE TYPE STRING,
LOCATION TYPE STRING,
LOCATIONENTRYDATE TYPE STRING,
MANDATORY_INTERNSHIP TYPE STRING,
MANDATORY_WORK_BREAK_RECORD TYPE STRING,
PAYROLL_EVENT TYPE STRING,
PAYSCALEAREA TYPE STRING,
PAYSCALEGROUP TYPE STRING,
PAYSCALELEVEL TYPE STRING,
PAYSCALELEVELENTRYDATE TYPE STRING,
PAYSCALETYPE TYPE STRING,
PCFM TYPE STRING,
PERMIT_INDICATOR TYPE STRING,
POSITION TYPE STRING,
POSITIONENTRYDATE TYPE STRING,
PROBATIONARY_PERIOD TYPE STRING,
LONG_VALUE TYPE STRING,
STRING_VALUE TYPE STRING,
PROBATIONARY_PERIOD_MEASURE TYPE STRING,
RETIRED TYPE STRING,
SEQ_NUMBER TYPE STRING,
STANDARD_HOURS TYPE STRING,
VALUE TYPE STRING,
TERMINATIONDATE TYPE STRING,
WORKER_CATEGORY TYPE STRING,
WORKINGDAYSPERWEEK TYPE STRING,
VALUE TYPE STRING,
WORKSCHEDULE_CODE TYPE STRING,
_VALUE_LIST TYPE STRING,
_SEQ_NUMBER TYPE STRING,
LONG_VALUE TYPE STRING,
STRING_VALUE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PAD_SFEC_CE_JOB_INFO_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_PAD_SFEC_CE_JOB_INFO_STR-NOTICE_PERIOD_START_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-VALID_FROM sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-WORK_PERMIT_EXPIRY sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-CONTRACT_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PROBATION_PERIOD_END_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-END_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-START_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-BUSINESS_UNIT sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-COMMITMENT_INDICATOR sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-COMPANY sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-COMPANY_TERRITORY_CODE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-COMPANYENTRYDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-CONTRACT_END_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-CONTRACT_TYPE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-CORPORATION sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-COST_CENTER sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-DEPARTMENT sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-DEPARTMENTENTRYDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-DIVISION sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-EDUCATIONAL_ENTITY sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-EMP_RELATIONSHIP sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-EMPLOYEE_CLASS sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-EMPLOYMENT_TYPE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-EMPLSTATUS sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-ENTRY_INTO_GROUP sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-EVENT sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-EVENT_REASON sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-FGTS_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-FGTS_OPTANT sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-FGTS_PERCENT sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-VALUE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-FTE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-VALUE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-HARMFUL_AGENT_EXPOSURE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-HAZARD sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-HEALTH_RISK sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-HIREDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-INITIAL_ENTRY_DATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-INTEGRATION_AGENT sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-INTERNSHIP_LEVEL sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-INTERNSHIP_SCHOOL sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-IS_FULLTIME_EMPLOYEE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-JOB_CODE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-JOBENTRYDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-LEAVEOFABSENCERETURNDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-LEAVEOFABSENCESTARTDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-LOCATION sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-LOCATIONENTRYDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-MANDATORY_INTERNSHIP sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-MANDATORY_WORK_BREAK_RECORD sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PAYROLL_EVENT sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PAYSCALEAREA sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PAYSCALEGROUP sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PAYSCALELEVEL sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PAYSCALELEVELENTRYDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PAYSCALETYPE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PCFM sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PERMIT_INDICATOR sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-POSITION sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-POSITIONENTRYDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PROBATIONARY_PERIOD sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-LONG_VALUE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-STRING_VALUE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-PROBATIONARY_PERIOD_MEASURE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-RETIRED sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-SEQ_NUMBER sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-STANDARD_HOURS sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-VALUE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-TERMINATIONDATE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-WORKER_CATEGORY sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-WORKINGDAYSPERWEEK sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-VALUE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-WORKSCHEDULE_CODE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-_VALUE_LIST sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-_SEQ_NUMBER sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-LONG_VALUE sy-vline 
WA_PAD_SFEC_CE_JOB_INFO_STR-STRING_VALUE sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.