How to check the Activity Rates at Table level:

It is difficult to validate the acitvity rates using the standard reports. You can check the activity rates at table level using the SAP tables.Tables to use for this are as below.

 

Tables: CSLA,  CSSL, COST

CSLA - Activity master : This gives the data relating to your activity type.
CSSL - Cost Center/Activity Type : This gives the Objectnumber (CSSL-OBJNR) for each activity type & Cost Centre combination you maintained the rate. This values is concatenation of "KL", Controlling area, Cost Centre & Activity type.
COST - CO Object: Price Totals : Here you can see the rate which you entered in the fields with TK" series. TKG" is total price, TKF" is fixed price, TOG" is Variable price.

Please do comment for any suggestions & corrections.

SAP FI SD: Useful SAP Credit Management Programs

In the present modern era of credit & economic crisis, credit management can plays a vital role in day-today business. So, it is essential for the business to have right things right. Streamlining the credit will assist you in streamlining the business process.

Also, Credit management gives you an opportunity to know your customer better in terms of financial facts & payment behavior.

 

So, you can't achieve all success, if a proper mechanism is not in place. Like

- kind of credit check you want
- the events where you want these checks
- change customer creditworthiness
- reorganizing the credit data
- period for which you are look the data

so forth and so on.

 

Following are some Useful program in SAP Credit Management which can come handy.

 

Continue reading here

SAP: Change Documents for SAP Objects (Master Data / Transactional Data)

Program- RSSCD100 (Display Change Documents) : can display the Change Documents related to any master or transactional data in SAP. Yes, that's true… you can display ALL the details of ALL change documents related to few SAP Object, onto a single screen.

Table - TCDOB : To find the Object id for the relevant master data / transactional data table.

 

Continue reading here

SAP FI MM : MR11 : GR/IR Clearing : Possible Scenarios

Possible Scenarios in relation to GR/IR Clearing :

 

1) Invoice  received is Greater than Goods Received (More number of Goods Invoiced).

 

2) Invoice  received is Greater than Goods Received (GR =I R goods receipt, Invoice  contains Freight Charges, transportation charges and any other charges)

 

3) Goods Received is Greater than Invoice Received.

 

4) Invoice Received and Goods not received

 

5) Goods Received, Invoice Received but invoice cleared not against the PO

 

6) Goods Received, Invoice Not Received

 

Please continue read HERE

 

source: sdn. sap. com

SAP FI NEWGL: Real Time COFI Integration Issue !!!

Recently I came across an issue in New GL wherein I have to understand the relation between , Real time COFI integration and Company code validation. If you opt for Company code validation then only you can activate and assign Real time COFI integration, otherwise NO.

 

In this blog, I want to analyse the logic behind the relation and justify SAP's error message.
 

Before proceeding to the analysis,  take a look at the scenario and the error message.

 

continue reading....here

 

source:sdn .sap .com

SAP FI: Alert Before Expiry of Number Range

Ever wondered how to monitor number ranges before reaching the critical limit ?  In this blog, I will explain  how expiry of number ranges are alerted in SAP. 

Number ranges are used for generating numbers while creating Master data, Transaction documents. Business  normally monitors the document numbers. SAP has a feature to give warning before expiry of number range.

 

The procedure is simple and explained in few steps with a sample scenario

 

Continue reading....here

SAP FI: Payment Terms Set Up Example

Payment Terms Issue :

Payment term to be set up as below:

70 days, days of payment 15 and 30

Example:

Date invoice: 01/05/2011      Due date: 15/07/2011
Date invoice: 10/05/2011      Due date: 30/07/2011

SOLUTION:

We have created 3 payment terms with the day limit as 6, 21 and 31.

In the 'payment term' field of OBB8, we have input:

Payment term  Fixed date  Additional months
ZTE6-6            15              2
ZTE6-21          30              2
ZTE6-31          15              3

Required URJENTLY SAP Certified (FICO/SD/MM/PP) or 1 year experience in SAP Implementation / Support

SAP Hirings only in Bangalore for Bangalore on 14 MAY 2011

Please do not forward candidates who are in other locations - if they are willing to travel on their own and only if they meet the below needs please forward.

so why wait, Start forwarding now !!! Please read the requirement and eligibility criteria below :-

Forward your CV who has about  4 to 8 years of experience in their respective domains and also is a SAP Certified professional OR has Minimum of  1 year experience in SAP implementation/support in the following skills: The fast track batches are open only for SD/MM/PP/HR/FICO.

Please send their resumes to sap.vvr@gmail.com before Friday.

 

 

SAP : Define Substitution

Define Substitution:

 

With Substitution, you can define the correct value in a particular field. This happens in the background. Substitution happens for all the accounting documents for which the said prerequisite statement satisfies. Substitution changes the value in that particular field, if it contains any data. This happens even when you change the document also. So, be cautious while designing the scenario in relation to substitution.

 

A substitution step contains the following statements:

 

 

•        Prerequisite statement:

 

a.    The prerequisite statement establishes which conditions must be fulfilled before the substitution can be performed.

 

i.    If the prerequisite statement is false, the transaction is continued without substitution.

 

ii.    If the prerequisite statement is true, the transaction is continued with the substituted values.

 

 

•        Substitution value(s):

 

b.    The substitution value is a numerical value or a string of letters that replace the value entered.

 

c.    A single substitution process can replace more than one value.

 

 

•        Substitution exit:

 

d.    You can specify that substitution is to be performed through a substitution exit.

 

e.    The substitution exit number directs the system to an ABAP program defined by the user.

 

f.     Substitution exits enable you to define more complex substitutions and replace more than one value in a substitution.

 

g.    The prerequisite statement used in a substitution can consist of a simple statement or a complex combination of statements composed of logical statements, rules, and sets.

SAP FI: SWIFT Code details

SWIFT code is a standard format of Bank Identifier Codes (BIC) and it is unique identification code for a particular bank. These codes are used when transferring money and messages between banks.

The SWIFT code consists of 8 or 11 characters. When 8-digits code is given, it refers to the primary office.
First 4 characters - bank code (only letters)
Next 2 characters - ISO 3166-1 alpha-2 country code (only letters)
Next 2 characters - location code (letters and digits) (passive participant will have "1" in the second character)
Last 3 characters - branch code, optional ('XXX' for primary office) (letters and digits)

source: theswiftcodes.com

SAP: ASAP Implementation Check List !!!

ASAP Implementation check list, gives you the details in brief.

 

You can find details each phase wise.

 

Click here for the file.

SAP Cutover Activities : Master Data Uploading Strategies

Master Data Uploading Strategies depends upon when we are going live.  As per that, you have to give the information to Core Team. 

 

--> If you are going live at the middle of the year then you have to upload the all P&L Account items and B/S Items.   
--> If you are going live at the financial year start, you have to upload only the B/S Items.

Activities for Golive: 

1.   G/L Master Upload through BDC or LSMW (Upload using the TC: FS00 and extend one company code to another company code using the TC: FS01)
2.   Vendor Master Upload Thru BDC Or LSMW (Will be taken care by MM Consultant, Reconciliation account anc payment terms at company code level will be provided by FI) 
3.   Customer Master Upload Thru BDC or LSMW (Will be taken care by SD  Consultant, Reconciliation account anc payment terms at company code level will be provided by FI)  4.   Asset Master Upload (TC: AS90) 
5.   Cost Element Master Upload (TC: KSH1) 
6.   Cost Center Master Upload  (TC: KS01)
7.   Profit Center Master Upload  (TC: KE53)
8.   G/L Balances (TC: FB01) 
9.   Vendor Balances (TC: F-43) 
10. Customer Balances (TC: F-22) 
11. Customer Advances (TC: F-29) 
12. Vendor Advances (TC: F-48)
 
In case WHT is activated for the specified comapny code the before uploading Vendor Balances you have to take care of WHT(TDS) Information.

SAP: FI-AP: Possible F110 Errors !!!

Payment proposal & & has not yet been created
Payment proposal & & cannot be changed again
Company codes &/& do not appear in proposal & &; correct
Company code & does not exist; correct
Payment method & is not defined in country &; correct
Enter a payment method for incoming payments
Enter a payment method for outgoing payments
Payment method & is not defined in company code &; correct
Payment run & & has not yet been carried out
& is not a house bank for company code &; correct
No G/L account has been specified for & /& for the bank
Customer/vendor does not have suitable bank details for pmnt method &
No bank has been chosen; use different payment method
Select customer's/vendor's bank details
Payment method & is not defined for this payment run
New allocation only possible if item is unblocked
No items found with the relevant values
Account & is contained in proposal & &; release not possible
Account & & is currently blocked; try again later
Special G/L transaction for exception list; it cannot be changed
Inconsistency after error; changes not saved cancelled
Do not place the cursor on a line with exceptions
Block key & cannot be set in the payment proposal
Bank data for house bank & & has been deleted
Required address data missing; please maintain (see long text)
Address data read from master record
Required address data missing from document; choose another payment meth.
There are still bills/exch. for presentation in unprocessed BI sessions
Doc.currency & and country currency & of presenting country are different
No number range could be found for the payment orders
A number could not be assigned for the payment order
Company code & for & & is blocked by user &
Item in excep. list cannot be changed because belongs to sending CoCde &1
Payment proposal being checked against payment budget....
Account & & is blocked against payment
Only the following accounts can be used: &1
Bank data for country & bank key & has been marked for deletion
Missing authorization in company code & (activity &)
Proposal run &1 / &2 does not exist
Payment run &1 / &2 does not exist
Proposal run &1 / &2 processed: &3 vendor(s)/customer(s) blocked
Changeable payment blocks are not allowed in proposal processing
Payment run &1 &2 is intended for cross-payment run payment media
The payment runs selected cannot be processed together
Error when creating the payment medium run
&3 payments were selected
Payment run is not a payment medium run
Payment medium run was reset
No data records found for these selection criteria
No documents can be displayed for proposal run
Only documents for FI payments can be displayed
You are not authorized to delete this object
You have no authorization for company code &
You have no authorization for FI proposal run
You only have authorization for FI payment run
You have no authorization for HR payment runs
You only have authorization for HR payment runs
You have no authorization for FI payment runs
You have no authorization for FI proposal runs
Function module WS_VOLUME_SET with error &
Payment advice note & already exists
Payment document advice note & does not exist
Error during deletion of the payment document advice note
Processing terminated. No payment advice note created.
This function cannot be executed for payment demands.
IDOC & is being called up for display
Not possible to process IDOC data
Incorrect display of IDOC
Only IDoc data can be processed
Data for payment IDoc & archived.
Internal error archiving data for payment IDoc.
Archiving cannot be completed.
... payment not possible because of reported error
Posting for account type & should be carried out with posting key &
For document type &, account type & is not defined
G/L account & does not exist in company code &
Withhld.tax for cntry & curr. & code & withhld.tax cntry & not defined
G/L acct & in comp.code & is not a reconciliation acct for acct type &
No posting keys have been defined for company code clearing &, &
G/L account & & is a reconciliation account, so cannot be posted to
G/L account & & only allows & as foreign currency but not &
For account & & period & / & has not been opened
For company code & period & / & has not been opened
The posting keys are not specified completely for transaction &
Sp.G/L indic. & is not permitted for bill of payment exchange requests
Special G/L indicator & is only permitted for statistical postings
Company code clearing not possible for comp.code & vendor & customer &
Account & & for cash discounts must not have a tax code
Proposal run & & has already been carried out and edited
Payment run & & has already been carried out
Customer & & is already contained in proposal & &
Exchange rate from & to & not maintained at posting date
Document number & & already assigned (incorrect status in no.range &)
In company code &, document number range & is missing for &
Bank acct cannot be determined for co.code & bank & pmnt method & curr.&
In country & the definitions for pmnt method & were deleted
Fiscal year variant & is not defined for comp.code &
In fiscal year variant & no period is allocated for &
Proposal run & & has already been carried out
Customer & & : Alternative payer & is missing, cannot be processed
...none of the payment methods defined can be used for these items
Customer & & is contained in proposal & &; no editing
Vendor & & is contained in proposal & &; no editing
More than 50 accounts are contained in another payment proposal
Processing will be stopped, no items have been edited
Different trading partners & and & in payment document
Purchase order & (assigned to an account) not permitted
Overlap with payment run & &
Parameters could not be read
Customer & & is blocked, editing not possible
Vendor & & is blocked, editing not possible
Company ID not specified for company code &
Business transaction cannot be processed by consolidation
Tax calculation procedure not defined for company code & in country &
Master data for branch or payee & is missing
Payment amount & falls short of minimum amount of & &
In company code & the definitions for pmnt method & were deleted
Vendor & &: No payment due to delete flag or posting block
Customer & &: No payment due to delete flag or posting block
Synchronous update could not be activated
Selected and as yet unassigned bills of exchange (amnt in &): Total &
Payment amount in &: &
Rate from & to & on & for rate type & is missing in rate table
Vendor & & does not exist for company code clearing
Customer &1 &2 for vendor &3 is blocked
Customer &1 &2 for vendor &3 is blocked by &4
Vendor &1 &2 for customer &3 is blocked
Vendor &1 &2 for customer &3 blocked by &4
Document & & &: payment block changed by BTE 00001820 in &
Document & & &: payment method changed by BTE 00001820 in &
Customer &: no payment in company code & due to balance block
Vendor &: no payment in company code & due to balance block
Payment with currency &1, payment method &2: No valid payment procedure
Different payer (customer &) and clearing not possible concurrently
The payment document is to receive too many items
... the execution of the payment program is terminated
Item is blocked for payment
Account is blocked for payment
Alternative payee is blocked for payment
No valid payment method found
Error in creating the payment document; read job log
Error in editing the document; read job log
Payment method in the document should not be considered in this run
A breakdown of the line items on the payment forms was not possible
Minimum amount for payment has not been reached
Item is blocked for payment, lost cash discount imminent
Account is blocked for payment, lost cash discount imminent
Payee is blocked for payment, lost cash discount imminent
Pmnt methods for this run are not specified in master record or in item
Special G/L transaction which only appears on the exceptions list
Payment request: no payment, original document will be paid
Payment request: no payment, original document is cleared
+/- sign for local/for.curr.balances are different, pmnt not possible
Preliminary payment: no clearing, since original document not paid
Clearing document type for debit side transfer posting is not defined
Clearing document type for credit side transfer posting is not defined
Master data is missing for branch or payee
Due date is too early for the bill of exchange payment method in question
Different payer during clearing is not supported
Inconsistency between payment request and document
Account has been flagged for deletion
Payee flagged for deletion
Unconfirmed change to master record
Unconfirmed change to payee master data
Change to master data refused
Refused master record change for payee

SAP: Validation & Substitution

Validation, which validates the values entered by the user.

 

Substitution, which substitutes the correct values by removing the wrong values entered by the user.

SAP: HOW TO CHECK THE USER STATUS IN THE TABLE

Defined User Status details are stored in the Table: ENT5854. You can
see the number of status details for one status profile. These details
may differ from client to client. Also differs from one status profile
to another. Against each status(ENT5854-TXT04) you can see the
technical status(ENT5854-ESTAT) details. Here the technical status
(ENT5854-ESTAT) is the main reference to check details further.

In the Table: VICN01, for every RE-Contract (VICN01- RECNNR) you can
see the Object number (VICN01- RECNOBJNR).

Now, use the same object number in the Table: JEST in the Object
number (JEST- OBJNR) field and execute for the entries. Now you can
see multiple entries in the output. For one object number you can see
multiple entries.

To get the latest status relating to the object (JEST-OBJNR), check
the particular entry, which is with 'active' status (JEST-INACT) and
with the latest 'change number' (JEST-CHGNR).

This status check procedure is same even in case of Rental Object,
Internal Order, WBS Element, etc.,

Always user status starts with 'E0001'and system status starts with
'I0001'. Logic to check the status is also same i.e., active status
having the latest change number.

SAP: CO - COPA Document not created

1. COPA not activated in TCODE:KEKE - with this you can transfer actual postings from SD, FI, CO & MM.

 
2. From SD
    - if Condition type not assigned to Value field
    - if Condition type not active
 
3. From MM
    - if Condition type not assigned to Value field
    - if Condition type not active

4. From FI
    - Either source or value field not assigned in the PA transfer structure.
    - In case of "Default account assignment", if PS is activated and value not flown means then the issue must be in derivation.

5. From CO
    - Missing CO Number ranges - TCODE: KEN1

Consolidation SEM BCS Vs EC CS

1. BCS is Business consolidation and Simulation and EC CS is Consolidation and Simulation in ECC 6.0

2. SEM BCS and ECCS both are consolidation applications of SAP System.
3. ECCS is based on R/3 where as SEM BCS is based on BW.
4. BCS is entirely out side R/3 and EC CS is R/3, here they have included some features in R/3 for consolidation and at the same time BCS is out side R/3 and has more features....while taking the reports then you take help of BW... end of the day you will get the data from R/3 even for BCS also.

SEM-BCS –Functional advantages compared to EC-CS -

 - Easier integration to remote SAP systems or non-SAP systems via BI
 - Approval workflow for documents **
 - Copy function and flexible upload for all posting levels **
 - Deferred taxes –balance sheet approach **
 - Inter-unit profit elimination in inventory with supply chains
 - Inter-unit profit elimination in inventory with equity method
 - Inter-unit profit elimination in transferred assets
 - Hidden reserves and contingencies
 - C/I –read investment data from totals database
 - C/I –flexible treatment of goodwill in acquisitions
 - C/I –posting of goodwill on subsidiary
 - Allocation
 - Restatement infrastructure **
 - Web-enablement for functionality used by local accountants **

SEM-BCS –Missing functionality compared to EC-CS *

 - Mass change of items and consolidation units
 - Real-time update from FI
 - Sample documents and parked documents **
 - Currency translation –method * is no longer available
 - C/I –statement of changes in equity
 - Encapsulated function modules to be used within custom-defined tasks
 - Multi-period consolidation **

 

* based on ERP 2005
** may be provided via ERP 2005 enhancement package

 

source: sap service market place

IFRS: The Right Next Step for US Business

Overview

International Financial Reporting Standards (IFRS) is the framework used by most publicly traded companies in the world today to report their financial results. With support from important constituencies, the Securities and Exchange Commission (SEC) and the Financial Accounting Standards Board (FASB) have taken first steps toward a transition to IFRS from the accounting and reporting framework currently in place in the US. Is the US really going to set aside US generally accepted accounting principles (US GAAP)? The answer is almost certainly yes. As this white paper shows, within a few years the SEC is likely to designate a date for mandatory adoption of IFRS by all US public companies.

 

Read Full Story --> Click HERE

 

source: sdn. sap. com

Author: pwc

Running new GL and traditional GL at the same time

Refer to the following OSS Note for all migration queries

1070629 - FAQs: New General Ledger Migration

Read question 23 for  "Running new GL and traditional GL at the same time"

23. You want to configure a new company code with the new general ledger. The existing company codes use the classic general ledger. Can company codes use different general ledgers (classic and new) in the same client?

The implementation of a new company code and the transition from the classic general ledger to the new general ledger are two different projects which you must schedule at different times.
You perform the migration from the classic general ledger to the new general ledger at client level and it affects all company codes in this client.

Because the new general ledger is activated at client level, the new general ledger would be active for all company codes, not only for the new company code. This would mean that the new general ledger is active in the old company codes, but there was no migration from the classic general ledger to the new general ledger. This is not possible.

Therefore, it is not possible to start with a new company code in the new general ledger while the classic general ledger is still active in other company codes in the same client.

First implement the new company code. Then set up the project for the transition from the classic general ledger to the new general ledger.

Alternatively: First set up the project for the transition from the classic general ledger to the new general ledger and migrate the data to the new general ledger, then implement the new company code.

Benefits of New General Ledger over the Classic General Ledger

The new General Ledger in mySAP ERP has the following advantages over the classic General Ledger in R/3 Enterprise:

a) In the new General Ledger, you can display the parallel accounting using parallel accounts (as in R/3) or using parallel ledgers. The FI standard functions and reports are available for all parallel ledgers.

b) The 'Segment' entity and the relevant reporting that are required for segment reporting according to IAS and U.S. GAAP are available in the new General Ledger.

c) In addition, you can enhance the new General Ledger flexibly, that is, you can enter user-defined fields and update the relevant totals. Many standard reports can evaluate the information from the user-defined fields.

d) When you use the new 'Document Splitting' function (online split), you can create financial statements at company code level and, if required, for entities, such as the segment. For each document, the system then creates a zero balance
for the relevant entity, for example, for the segment.

e) As a result, you no longer have to carry out time-consuming reconciliation tasks between FI and CO for the end of period since cross-entity processes are transferred in real-time to the new General Ledger in Controlling. Furthermore, you can, for example, navigate from the financial statements report results or the profit and loss statement report results to the relevant CO report.

f) The new General Ledger uses the same interfaces as the General Ledger in R/3. As a result, users do not require any additional training.

g) Due to the new 'multi-dimensional' aspect in the General Ledger, all data that is relevant for the General Ledger is stored in one environment. As a result, reconciliation tasks, for example, between the general ledger and Profit Center Accounting or the consolidation staging ledger, and processing steps that have to be carried out repeatedly in the individual applications (for example, balance carryforward are no longer required. When you use the new General Ledger, you may not have to use the special ledger anymore.