Skip to Content
0
Apr 11, 2014 at 02:51 PM

AMDP exporting table with fields from various sources

1457 Views

I am writing an AMDP that has an output table a list of employees and attributes. These attributes have various sources with various keys. If I cannot with any practicality construct this table with a single select statement, which given my search criteria, I probably can't, must I break my output table into multiple output tables that can be created with a single select?

I declare the structure of output table et_employees in the class as something like

BEGIN OF ty_employee,

emp_id(12) TYPE c,

emp_name(80) TYPE c,

org_unit(8) TYPE c,

region(5) TYPE c,

country(3) TYPE c,

jb_prf_as TYPE c,

sol_gr_as TYPE c,

snippet(1000) TYPE c,

score TYPE integer,

END OF ty_employee,

tt_employes type table of ty_employee.

As far as I can tell, I cannot do an update et_employees in the method to modify individual fields. I can only do the select statement.

I see my choices as

  • elaborate select statement that I may or may not be able to construct (haven't thought this through but it may be doable)
  • more than one output table
  • create multiple local tables and then do a join on them for the output table.

I am seeing the last one as my best option.

To throw in an unrelated issue, AMDP procedure cannot seem to cope with a table that begins with a slash, e.g., /MRSS/D_SQP_ESTR. The USING statement is o.k. but any access in a select or inner join gets an error.