Saturday, May 4, 2013

BAPI for Customer account statement for a given period

To get any customer line items at a given period use the BAPI. 
 CALL FUNCTION 'BAPI_AR_ACC_GETSTATEMENT'
    EXPORTING
      companycode       = p_bukrs
      customer          = p_kunnr
      date_from         = so_budat-low       "from_date
      date_to           = so_budat-high      "to_date
*   NOTEDITEMS        = ' '
* IMPORTING
*   RETURN            =
    TABLES
      lineitems         = i_bapi3007_2 .


How to disable print option in smartforms?

To disable print option change parameter ssfcompop-tdnoprint. User will only able to view the samrtforms.

 DATA: t_ssfcompop TYPE ssfcompop.

       t_ssfcompop-tdnoprint = 'X'.
       t_ssfcompop-tdnoarch  = ' '.
       t_ssfcompop-tdnoprev = ' ' .

  CALL FUNCTION fm_name
    EXPORTING
      output_options     = t_ssfcompop
      p_bukrs            = p_bukrs
      p_kunnr            = p_kunnr
    TABLES
      it_final           = it_final
      so_budat           = so_budat
    EXCEPTIONS
      formatting_error   = 1
      internal_error     = 2
      send_error         = 3
      user_canceled      = 4
      OTHERS             = 5.
  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.

Thursday, May 2, 2013

BAPI for Customer account balance at a key date


To get any customer account balance at any date use the BAPI. You can get opening or closing balance of any customer using this.


CALL FUNCTION 'BAPI_AR_ACC_GETKEYDATEBALANCE'
    EXPORTING
      companycode        = p_bukrs      "Company Code
      customer           = p_kunnr      "Customer Code
      keydate            = v_date       "Date
*   BALANCESPGLI       = ' '
*   NOTEDITEMS         = ' '
* IMPORTING
*   RETURN             =
    TABLES
      keybalance         = i_bapi3007_3 .

 
UA-40152711-1