Pages

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

Wednesday, March 17, 2010

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

Wednesday, March 3, 2010

Information: Difference between Business Area and Profit Centers

With the onset of New General Ledger, which provides seamless integration between general ledger and profit center accounting, Business Area seems to have lost the importance it enjoyed with the classical general ledger.

Often we encounter a dilemma on whether to use a Business Area or Profit Center (or Segment) to obtain financial information on an important logical business division or geographical business location.

The following note from SAP clearly classifies the distinction between the functionality available with Business Area and Profit Center to help make the appropriate choice. 

Note 321190 - Difference between business area and profit center