2022年4月19日星期二

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_vbeln.
*--- Update P_VSTEL
  dyfields-fieldname = 'P_VSTEL'.
  APPEND dyfields.
  CALL FUNCTION 'DYNP_VALUES_READ'
    EXPORTING
      dyname     = sy-cprog
      dynumb     = sy-dynnr
    TABLES
      dynpfields = dyfields.
  READ TABLE dyfields INDEX 1.

  IF dyfields-fieldvalue IS INITIAL.
    MESSAGE i899 WITH 'Please enter Shipping Point first!'.
    EXIT.
  ELSE.
    CLEAR: gr_vstel,  gr_vstel[],
           gt_lipov,  gt_lipov[],
           gt_dn,     gt_dn[].
    gr_vstel-sign   = 'I'.
    gr_vstel-option = 'EQ'.
    gr_vstel-low    = dyfields-fieldvalue.
    APPEND gr_vstel.
  ENDIF.

2014年3月28日星期五

[Link] Timezone changes best practices

http://wiki.scn.sap.com/wiki/display/Basis/Timezone+changes+best+practices


How to check the timezone at different levels

Login to SAP system client  
Run the report from Tcode SA38   -> TZCUSTHELP
Run the report from Tcode SA38   -> RSDBTIME
Run this function module in SE37   -> TZ_SYSTEM_GET_TZONE
Run this report from Tocde SA38  -> TZONECHECK

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年6月20日星期四

[Link] Output Determination in Inventory Management (IM)

Output Determination in Inventory Management (IM)

Content

2013年2月4日星期一

[Code] How to catching selection criteria

How to catching selection criteria

Example:

  DATA: selection_table LIKE rsparams OCCURS 0  WITH HEADER LINE.

  CLEAR selection_table. REFRESH 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 .
  DATA: selctab         LIKE rsscr    OCCURS 20 WITH HEADER LINE,
        itabname        TYPE c        LENGTH 30.

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

  CLEAR selctab. REFRESH 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 A 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.