BAPI for /ISDFPS/LPL1

[Former Member]

Hi.

There is a requirement, that data should be uploaded from Excel file to SAP. Excel file contains FE (Force Elements) and storage locations. So, basically this is mass data upload and force element default storage location change in tab 'Stock/Pool'. MRP area is already there, so no need to search for it.

As this transaction (/ISDFPS/LPL1) uses "Enjoy SAP" controls, BDC is not possible there.

Can anyone suggest BAPI, BDC workaround or even table update sequence? As far as I know, data is stored in /ISDFPS/FORCE table for it.

Thanks.

Regards,

Aigars

[Former Member]

Hi.

There is a requirement, that data should be uploaded from Excel file to SAP. Excel file contains FE (Force Elements) and storage locations. So, basically this is mass data upload and force element default storage location change in tab 'Stock/Pool'. MRP area is already there, so no need to search for it.

As this transaction (/ISDFPS/LPL1) uses "Enjoy SAP" controls, BDC is not possible there.

Can anyone suggest BAPI, BDC workaround or even table update sequence? As far as I know, data is stored in /ISDFPS/FORCE table for it.

Thanks.

Regards,

Aigars

[Former Member]

Hi. Looks like noone has this type of issue. I have solved this, by using /ISDFPS/CL_FORCE class method FORCE_MAINT. here is the code:

1. SELECT all info from /ISDFPS/FORCE table into structure ls_force.

2. CALL METHOD /isdfps/cl_force=>force_maint

EXPORTING

im_msg_option = /isdfps/cl_const=>msg_opt_none

CHANGING

cs_force = ls_force

EXCEPTIONS

force_lock_error = 1

force_read_error = 2

force_not_exists = 3

force_create_error = 4

OTHERS = 5.

3. Set 'SAVE'.

CALL METHOD /isdfps/cl_fdpwb_cntl=>set_ok_code

EXPORTING

im_ok_code = 'SAVE'.

4. Save changed structure.

CALL METHOD /isdfps/cl_fdpwb_cntl=>save

EXCEPTIONS

OTHERS = 1.

IF sy-subrc <> 0.

MESSAGE s814(/isdfps/fdp).

ELSE.

MESSAGE s815(/isdfps/fdp).

ENDIF.

Cheers.