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. 

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

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

Information: RFBIBL00 - Batch document processing program

RFBIBL00 is a program which can be used to post documents or clear open items based on an input UNIX file. The programs supports the following transactions

• FB01 Post document

• FBB1 Foreign currency valuation

• FBS1 Enter accrual/deferral document

• FBV1 Park document

• FB05 Posting with clearing

One of the basic advantages of using this program over a posting with BAPI is that it can also process profitability segment characteristic selection, which is not supported with BAPI for document posting.It also supports fields for one-time data and the data for the coding block fields.   

The Unix file structure details and more information required to implement this program can be found at the following link from SAP help portal:
http://help.sap.com/saphelp_45b/helpdata/en/35/a47e63763e0392e10000009b38f9b7/content.htm