Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CLASS zcl_generate_travel_data_xxx DEFINITION
- PUBLIC
- FINAL
- CREATE PUBLIC .
- PUBLIC SECTION.
- INTERFACES if_oo_adt_classrun.
- PROTECTED SECTION.
- PRIVATE SECTION.
- ENDCLASS.
- CLASS ZCL_GENERATE_TRAVEL_DATA_XXX IMPLEMENTATION.
- METHOD if_oo_adt_classrun~main.
- DATA:itab TYPE TABLE OF ztravel_xxx.
- * read current timestamp
- GET TIME STAMP FIELD DATA(zv_tsl).
- * fill internal travel table (itab)
- itab = VALUE #(
- ( travel_id = '00000022' agency_id = '070001' customer_id = '000077' begin_date = '20190624' end_date = '20190628' booking_fee = '60.00' total_price = '750.00' currency_code = 'USD'
- description = 'mv' overall_status = 'A' created_by = 'MUSTERMANN' created_at = '20190612133945.5960060' last_changed_by = 'MUSTERFRAU' last_changed_at = '20190702105400.3647680' )
- ( travel_id = '00000106' agency_id = '070005' customer_id = '000005' begin_date = '20190613' end_date = '20190716' booking_fee = '17.00' total_price = '650.00' currency_code = 'AFN'
- description = 'Enter your comments here' overall_status = 'A' created_by = 'MUSTERMANN' created_at = '20190613111129.2391370' last_changed_by = 'MUSTERMANN' last_changed_at = '20190711140753.1472620' )
- ( travel_id = '00000103' agency_id = '070010' customer_id = '000011' begin_date = '20190610' end_date = '20190714' booking_fee = '17.00' total_price = '800.00' currency_code = 'AFN'
- description = 'Enter your comments here' overall_status = 'X' created_by = 'MUSTERFRAU' created_at = '20190613105654.4296640' last_changed_by = 'MUSTERFRAU' last_changed_at = '20190613111041.2251330' )
- ).
- * delete existing entries in the database table
- DELETE FROM ztravel_xxx.
- * insert the new table entries
- INSERT ztravel_xxx FROM TABLE @itab.
- * check the result
- SELECT * FROM ztravel_xxx INTO TABLE @itab.
- out->write( sy-dbcnt ).
- out->write( 'Travel data inserted successfully!').
- ENDMETHOD.
- ENDCLASS.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement