SAP : Batch Input Session

January 16, 2010 by mySAP · 1 Comment
Filed under: SAP Knowledge 

Displaying Session Logs

The batch input system keeps a detailed log of each session that is processed. The log contains not only progress messages from the batch input system itself, but also error messages from the transactions that are processed.

For analyzing an SAP error in a session, you should start by checking the session log for relevant messages. A session log is kept only if the session was generated with the KEEP option or if the session is aborted or contains an error.

Read more

Viewed 8480 times by 2795 viewers

SAP Tip : How to default translation date for Foreign Currency document

January 13, 2010 by mySAP · Leave a Comment
Filed under: SAP Tip 

Normally translation date of SAP document, posting with foreign currency is taken as posting date. So if you want the translation date should be the same to document date.

Go to GGB1 transaction for substitution creation

The next step is create step for substitution: now a popup comes up and you have to select translation date.

If BKPF-WWERT is not in the list you have to change the corresponding entry in table GB01 (BEXCLUDE has to be empty). When you select translation date, you choose field-to-field substitution and you enter BKPF-BLDAT (document date) as source field.

Save then! After that you have to activate in OBBH  transaction as well.

Viewed 8735 times by 3034 viewers

Input and Output Tax Definition

January 10, 2010 by mySAP · Leave a Comment
Filed under: General Ledger Module 

Input / Output Tax:

At month-end, Input tax is offset with output tax and balance have to pay/receive the goverment.

Some countries allow setoff of output tax against inout tax which is called VAT in European countries and MODVAT in India ( hta is tax payable on sold items against tax paid against bought out items) based on materials and products.

Input Tax is receivable account and Output Tax is liability account. Output tax is periodically set off against input tax.

Read more

Viewed 8948 times by 3260 viewers

Parameter ID for User Profile Maintenance

January 8, 2010 by mySAP · 1 Comment
Filed under: SAP Knowledge 

Parameter ID is a field can be filled with proposed values from SAP memory using a parameter ID.

The following parameter IDs are the sample values which SAP will store in memory:

  • [Parameter ID] = AFP (Chart of depreciation) / [Parameter value] = your chart of depreciation
  • [Parameter ID] = BUK (Company code) / [Parameter value] = your Company code
  • [Parameter ID] = CAC (Controlling area) / [Parameter value] = your Controlling area
  • [Parameter ID] = FIK (FM area) / [Parameter value] = your FM
  • [Parameter ID] = FWS (Currency unit) / [Parameter value] = your default Currency
  • [Parameter ID] = GSB (Business Area) / [Parameter value] = your BA
  • [Parameter ID] = KPL (Chart of accounts) / [Parameter value] = your COA
  • [Parameter ID] = PRC (Profit Center) / Parameter value] = your PC
  • [Parameter ID] = WRK (Plant) / [Parameter value] = your Plant

Read more

Viewed 7749 times by 2457 viewers

SAP Tip : How to download data from SAP to Excel

December 24, 2009 by mySAP · Leave a Comment
Filed under: SAP Tip 

How to download data from SAP report to Excel

  • Mostly, SAP standard reports have direct download function to Excel already that can be search for the menu option or the button.
  • SAP Query and SAP QuickViewer are excellent tools for Downloading.
  • SE16N transaction also allows you to access any SAP table and download result to Excel. SAP RFC functions can be called directly from Excel / VBA (requires special authorization).
  • Use querySHUTTLE from Winshuttle product that extracts data from one or many SAP tables, and enforces security rules.
  • Process Runner also offers an easy way to find tables joins via Data Dictionary SOX compliant searchable XML look up of over 80K SAP tables and views. You can even use Excel data as a filter to limit your downloads.

Use BAPI transaction  in SAP to find your business object and study the function.

Read more

Viewed 6980 times by 2869 viewers

SAP Definition : Field Status Group

December 18, 2009 by mySAP · Leave a Comment
Filed under: General Ledger Module 

Enter the field status group in the master record of a G/L account in SAP system. When entering a document in SAP system, the definitions which were stored will be effectived.

Field Status Group in SAP determines the screen layout for document entry in SAP system.

The fields can have the following statuses:

  • Optional Entry – Data can be entered in the field
  • Mandatory Entry – Data must be entered in the field
  • Suppressed – The field will not appear on the SAP screen

Read more

Viewed 7922 times by 2640 viewers

mySAP ERP | SAP Business | SAP Tutorial | SAP Help