Correction of SD Document Status

---

1472007 - Document status has to be corrected

Reorganization of SD Document Index

Reorganization of SD Document Index

---

128947 - Correction of SD document indexes with RVV05IVB

How to read Report selection screen field values before PAI field transport

Function: DYNP_VALUES_READ

---

How to got the field value when you still in selection screen manipulating, example code as below:

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.

[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 

[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

[Link] Output Determination in Inventory Management (IM)

Output Determination in Inventory Management (IM)

---

Content

• Content
• 1. About this document
• 2. General information
• 3. Output records for a material document (table NAST)

[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

[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.

[Link] Consolidation (EC-CS)

Consolidation (EC-CS)

---

SAP Manual: http://help.sap.com/saphelp_erp60_sp/helpdata/en/a6/ece73c2d1011d299250000e8a5999a/frameset.htm

SAP Wiki: Configuration of EC-CS

SAP Note: Note 1223308 - EC-CS in the context of SAP ERP 6.0

[Link] Integrated CO-PA Planning Leveraging Your SOP Forecast

Integrated CO-PA Planning Leveraging Your SOP Forecast

---

URL: http://www.slideshare.net/Alfredh/integrated-copa-planning-leveraging-your-sop-forecast

[Link] Integrating SAP Web Services into Microsoft .NET Environments

http://www.codeproject.com/Articles/172725/Integrating-SAP-Web-Services-into-Microsoft-NET-En

[Link] Consuming SAP Web Services and .NET

http://www.c-sharpcorner.com/uploadfile/chinnasrihari/consming-sap-web-services-and-net/

---

[Link] Posting Goods Issue for cross-company code Stock Transfer

Posting Goods Issue for cross-company code Stock Transfer

---

Source URL: http://www.miglena2s.com/post-goods-issue-for-cross-company.htm

Executed SPRO and then Financial Accounting -> G/L Accounting -> Business Transactions -> Prepare Cross-Company Code Transactons (OBYA)