2013年7月3日 星期三

[Link] Foreign Currency Valuation - Resetting Posting on Basis of Valuation History

Foreign Currency Valuation - Resetting Posting on Basis of Valuation History

After postings have been made, you can reset them at a later point in time. For this, the program determines the relevant foreign currency items (line items) and foreign currency balances (accounts) as well as any corresponding valuation differences from the entries in the valuation history. In the case of foreign currency items, the system also creates a reset posting if the items were cleared before or on the specified valuation key date. It is not possible prior to enhancement pack 5 to reset posting, if the items were cleared before or on the specified valuation key date. This new functionality is only available via Enhancement pack 5.
http://wiki.sdn.sap.com/wiki/display/ERPFI/Foreign+Currency+Valuation++-+Resetting+Posting+on+Basis+of+Valuation+History

[Link] Foreign Currency Valuation in SAP ECC 6

Foreign Currency Valuation in SAP ECC 6

This is the process to translate and adjust foreign currency amount of monetary accounts to local amount by a current suitable exchange rate (standard exchange rate).
http://mssmart77-sapfico.blogspot.tw/2012/08/foreign-currency-valuation-in-sap-ecc-6.html

2013年2月4日 星期一

[Code] How to catching selection criteria

How to catching selection criteria

Example: 
  DATAselection_table LIKE rsparams OCCURS 0  WITH HEADER LINE.

  CLEAR selection_tableREFRESH selection_table.

* Get selection criteria
  CALL FUNCTION 'RS_REFRESH_FROM_SELECTOPTIONS'

[Code] How to reference whole itab by name

How to reference whole itab by name

Example: clearing all selection criteria
FORM screen_clearing_all .
  DATAselctab         LIKE rsscr    OCCURS 20 WITH HEADER LINE,
        itabname        TYPE c        LENGTH 30.

  FIELD-SYMBOLS<para> TYPE ANY,
                 <sele> TYPE ANY TABLE.

  CLEAR selctabREFRESH selctab.

* Get selection screen

2013年1月31日 星期四

[Code] How to use subquery to get correct record


Suppose ZSD001 is filled as below:
MATNR         DATAB           APPOINTFEE
----------------------------------------
MA12345       2008/12/01      500
MA12345       2009/12/01      1,000
MA12345       2009/12/15      2,000
Example Code:
SELECT SINGLE APPOINTFEE INTO GT_ITAB-APPOINTFEE
    FROM ZSD001
   WHERE MATNR = 'MA12345'
     AND DATAB = ( SELECT MAX( DATAB )
                       FROM ZSD001
                      WHERE MATNR EQ 'MA12345'
                        AND DATAB LE '20091202'
                 ).

* GT_ITAB-APPOINTFEE == 1,000

Another example: (paste from RVAUFSTA)
SELECT OBJNR FROM JSTO AS APPENDING CORRESPONDING FIELDS OF
                     TABLE ONR_TAB WHERE A~OBJNR LIKE SDCON-OBJNR_VB AND
                                         A~OBJNR IN R_S_OBJNR AND
                                         A~OBTYP EQ SDCON-HEADER AND
                                         A~STSMA NE STSMA_INI AND
             EXISTS SELECT OBJNR FROM JEST WHERE OBJNR EQ A~OBJNR AND
                     STAT LIKE 'E%' AND INACT EQ SPACE ORDER BY OBJNR.