Pages

Monday, May 7, 2012

Conditions Copied from Last Purchase Order

While creating a Purchase Order, If Net Price of the order is found to be zero with the calculation schema, System checks data in the last purchase orders and copies values from the last PO. 

The following conditions must be met before system copies price from the previous purchase order 

  1. An Info record exists for the Vendor, Material Combination at the purchase org/ plant. 
  2. The last document is not a request for quotation.
  3. The calculation schema of the last document is the same as the schema for the Purchase Order being created
  4. Net Price of the purchase order is zero based on the calculation schema  

A copy function is executed to copy values from the last document. No checks are made for requirements for the calculation schema.
As a exception to the above, system does not copy the condition records of the subsequent settlement (condition class "C"); instead, they are always determined again to ensure that the condition records are consistent with the field contents 

The copy control can be disabled at user level by maintained EVO parameter as described in SAP Note# 675523

Friday, July 29, 2011

Exchange Rate Based On Document Date for LIV Invoices

For LIV Invoices posted using MIRO transaction the exchange rate defaults based on the posting date, As there is no provision to change the translation date on the MIRO screen, it cannot be substituted with document date.


In order to post all invoices based on exchange rate at the document date instead of the exchange rate at the invoice date, the BADI FI_TRANS_DATE_DERIVE needs to be implemented according to the SAP Note #574583


Detailed steps to implement this BADI are :

  1. Go to transaction SE18, enter implementation name as "FI_TRANS_DATE_DERIVE"  and click "Display"
  2. Click Menu option, "Implementation" > "Create"
  3. Enter an implementation name, for example "Z_BADI_FI_TRANS_DATE_DERIVE"
  4. Add country codes where document date is required as translation date in "Attributes" tab
  5. Go to "Interface" tab
  6. Double click on "DERIVE_WWERT"
  7. Activate the code
  8. Go back to the previous screen and activate the implementation



The SAP note#574583 shows relevance only upto ECC 6.0, but it can be implemented with ECC 6.04 also. 

Friday, March 26, 2010

Grouping of Payment Items in Automatic Payment Program (F110)

When executing an Automatic Payment program (F110), Various open items can be grouped together to be paid with a single payment document.
The grouping of open items for payment is carried out based on the fields in structure ZHLG1. Items are grouped only if all the fields in this structure are identical

for more details on open item grouping, refer to the following SAP Note
Note 164835 - F110: Clearing credit memos and invoices

RFTBFF00: Import Market Data

RFTBFF00 allows to transfer external market data into the SAP system in file form

It can be used to import the following
    • Category 01:  Exchange rates
    • Category 02:  Security price information (stocks quotes, bonds)
    • Category 03:  Reference interest rates (e.g. LIBOR, FIBOR)
    • Category 04:  Indexes

More information on how to use this program and transfer structures is available at the following SAP help link:
http://help.sap.com/saphelp_45b/helpdata/en/35/a7b5629af50d14e10000009b38f9b9/content.htm

With program RFIMPNBS it is possible to automatically import new exchange rates from European Central Bank into the system using an XML file. The following configurations need to be completed before RFIMPNBS can be use: 
Standard quotation for exchange rates,
Exchange rate type,
Translation ratios for currency translation

More details for using this program are available in SAP Note:
Note 1286897 - Import of Exchange Rates from ECB

Tuesday, March 23, 2010

Issue/Solution: Offsetting Account in FBL3N/FAGLL03

Issue:
You need Customer / Vendor Number (KUNNR/LIFNR) to be displayed for the offsetting GL accounts in the GL account line item reports FBL3N or FAGLL03

Soultion
There is no standard configuration to achieve this.
Using Sort key in the GL account will not populate data from the offsetting account
This can be achieved by using a BTE or BADI as described in the following SAP Notes
Note 112312 - Line item: Display of offsetting a/c information
Note 1034354 - FAGLL03: Display of offsetting account information

Further, if Vendor Name or Customer Name are also needed
Refer to the BTE solution provided by Burak in the following SDN thread..
http://forums.sdn.sap.com/thread.jspa?messageID=7848056&tstart=0#7848056