Using BAPI upload excel file for t-code AS02 in SAP

Using BAPI " BAPI_FIXEDASSET_CHANGE " create a zprogram to upload excel file for mass change fixed asset in SAP.



REPORT ZAS02_ASSET_CHANGE_UPLOAD.

TYPE-POOLS: truxs.

" Structure for Excel data
TYPES: BEGIN OF ty_excel,
         anln1 TYPE anln1,
         bukrs TYPE bukrs,
         kostl TYPE kostl,
         werks TYPE werks,
         prctr TYPE prctr,
       END OF ty_excel.

DATA: lt_excel    TYPE TABLE OF ty_excel,
      ls_excel    TYPE ty_excel,
      ls_time     TYPE bapi1022_feglg003,  " Time-dependent data
      ls_timex    TYPE bapi1022_feglg003x, " Change flags
      ls_return   TYPE bapiret2,           " Holds BAPI response structure
      lv_subnumber TYPE anln2.             " To enforce correct subnumber length

DATA: lv_raw_data TYPE truxs_t_text_data.

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE TEXT-001.
PARAMETERS: p_file TYPE localfile.
SELECTION-SCREEN END OF BLOCK b1.

SELECTION-SCREEN skip 2.

SELECTION-SCREEN COMMENT /1(80) TEXT-002.                     " Excel Format:
SELECTION-SCREEN COMMENT /1(80) TEXT-003.                     " (Purchase Group | Supplying Plant | Article | Plant | Quantity)


AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
  CALL FUNCTION 'F4_FILENAME'
    IMPORTING
      file_name = p_file.

START-OF-SELECTION.

IF p_file IS INITIAL.
    MESSAGE 'Please select an Excel file before executing.' TYPE 'E'.
    EXIT.
  ENDIF.

*--- 1. Upload Excel Data ---*
  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
      i_tab_raw_data       = lv_raw_data
      i_filename           = p_file
    TABLES
      i_tab_converted_data = lt_excel
    EXCEPTIONS
      conversion_failed    = 1
      OTHERS               = 2.

  IF sy-subrc <> 0.
    WRITE: / 'Error: Could not read Excel file.'.
    EXIT.
  ENDIF.

*--- 2. Process and Update Assets ---*
  LOOP AT lt_excel INTO ls_excel.

    CLEAR: ls_time, ls_timex, ls_return.

    " Fix Asset alpha-numeric padding (Ensures 12 characters with leading zeros)
    CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
      EXPORTING
        input  = ls_excel-anln1
      IMPORTING
        output = ls_excel-anln1.

    " Enforce correct 4-character asset subnumber format
    lv_subnumber = '0000'.

    ls_time-costcenter = ls_excel-kostl.
    ls_time-plant      = ls_excel-werks.
    ls_time-profit_ctr = ls_excel-prctr.

    " Mark which fields to update (The 'X' flags)
    ls_timex-costcenter = 'X'.
    ls_timex-plant      = 'X'.
    ls_timex-profit_ctr = 'X'.

    " Call the BAPI
    CALL FUNCTION 'BAPI_FIXEDASSET_CHANGE'
      EXPORTING
        companycode        = ls_excel-bukrs
        asset              = ls_excel-anln1
        subnumber          = lv_subnumber
        timedependentdata  = ls_time
        timedependentdatax = ls_timex
      IMPORTING
        return             = ls_return. " <-- Populates structure directly

    " Check the real response inside ls_return directly
    IF ls_return-type <> 'E' AND ls_return-type <> 'A'.

      " No errors or aborts found, commit the change to the database
      CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
        EXPORTING
          wait = 'X'.

      WRITE: / ls_excel-anln1, ls_excel-bukrs, ls_excel-kostl, ls_excel-werks, ls_excel-prctr, '- Updated successfully'.
    ELSE.
      " If there's a real error, it will now show up here
      WRITE: / 'Error on Asset', ls_excel-anln1, ':', ls_return-message.
    ENDIF.

  ENDLOOP.

Comments

Post a Comment

Popular posts from this blog

New commodity code create in SAP S/4 Hana

Image
Commodity codes are internationally recognized reference numbers. A code describes a specific product when importing or exporting goods. You will use this code on any customs declarations and can find them in the Trade Tariff tool. Before S/4 Hana we can create commodity code by using GUI but from S/4 Hana need to use fiori interface to create commodity code. Let's explore it.   T-Code: /UI2/FLP Launchpad is opening and then select Manage commodity codes Tile. After that need to provide No. Scheme contend and click Go button and then need to click add button. Give commodity code and Description with valid from date to valid To date. After that press save button. That's it, your commodity code is created and now need to assign it against material number. Check /SAPSLL/CLSNR table for commodity code added or not.  Check MARC table stawn field to confirm material level assigned or not.
Read more

BAPI to Change STO PO/ PO Delivery date in SAP

Image
 In SAP, a BAPI (Business Application Programming Interface) serves as a standardized method to allow external applications or custom code to access and interact with data and processes within SAP business objects, essentially providing a way to "call" specific business functions within the SAP system from outside applications, ensuring data integrity and proper business logic execution through a defined interface. Function: BAPIs enable external applications to read, create, update, or delete data within SAP by interacting with the underlying business object model. Implementation: BAPIs are implemented as function modules in the SAP system, which can be called remotely using the Remote Function Call (RFC) protocol. Business Object Repository (BOR): BAPIs are defined as methods of SAP Business Object Types, which are stored and managed within the BOR.  Benefits:     Standardized Access: Provides a consistent way for external applications to interact with SAP fun...
Read more

Decimal remove in a smartforms report

In smart forms this is a common problem in our daily task.Here I am providing you my own experience.I am facing this problem and solve using below step. First of all we remove decimal value for QUAN data type. first one is simple, just using below format. &work_area-field_name(C,0)& Hope this will work. Another way is we need to define variable in Smartforms>Global Definitions. Give a variable name, type and associated type like: XYZ  TYPE P decimals 0. Also need to create a program logic following steps :right click > Create>Flow logic>Program logic. In program logic page we provide our logic and assign variable in our required fields. Clear: variable. XYZ = wa_items-total_val. Also need to assign Input & output parameters in General attributes. Input Parameter                              ...
Read more