SAP Tables for Technical Consultants & also for Function Consultants !!!

Tables on below topics :

Authorisation, objects, Batch input map's, Batch jobs,Correction & transport, Countries, Currency, Data elements, Development classes, Domains, Dynpro areas, Filenames, Function modules, Function groups, Icons, Logical databases, Matchcodes, Messages, Programs, Repository objects, Purchase Requisition, SAPscript, Spool, Status (menu), Switch objects, Tables and views, Texts, Transactions, User parameters, Variants, Accounting, Accounting documents, Bill Of Material, Classification, Classification characteristics, Configurator, Cost elements, centers, activities, Customer,Equipment, Equipment status, Function location, Customising tables, General ledger accounts, Goods movement, Customising, Inventory document, Maintenance Order, Material, Material document, Notifications, Orders,Personel, Production resource tools, Customising tables, Project, Purchase Requisition, Purchasing document, Purchasing info record, Reservation, Sales Document, Sales requirements, Storage locations and stocks, Tasklist, Transfer requirement, User data, Vendor master, WM transfer, Other tables, Useful Transactions, Function modules, Standard data transfer, Helpful reports.

Click on SAP Tables for the document.

Why do we need to DEBUG : BREAK POINT : WATCH POINT

DEBUG

We write programs to achieve certain functionality and like other actions, we make mistakes while writing the code. If they are not trapped at the right time, problem becomes bigger, and bigger and bigger.

BREAK POINT

The BREAK POINT is a debugging aid. When we run a program normally, it is interrupted at the statement, and the system automatically starts the debugger, allowing you to display the contents of any fields in the program and check how the program continues. If the program is running in the background or in an update task, the system generates a system log message.

SAP- CO : Some of the Product Cost Approaches

§ Finished Goods Inventory in Production Plant AAAA

Valuation at moving average price per batch (FIFO batch valuation)
A new batch number will be generated for each production order (work order) producing the finished product
Each batch will have a unique material cost
The material cost of a batch is calculated from semi-finished goods and raw materials that are directly constituting to the finished product according to the BOM

§ Semi-finished Goods Inventory in Production Plant AAAA

Valuation at standard price updated from standard cost estimates
All inventory of each semi-finished product will be valuated the same (at the defined standard cost)
The standard cost can be updated either: 1) manually, or 2) automatically from the cost roll-up (can be using weighted average) of the lower levels of the BOM and can be selectively updated only for certain semi-finished products.
Re-valuation of existing inventories for semi-finished product will happen whenever the standard cost is updated. The gain or loss will post to the P/L accounts

§ Raw Materials Inventory in Production Plant AAAA

Raw materials will be valuated for each batch of the receipts of purchase using the purchase order price.
The batches of raw materials will be issued to production orders at FIFO.
No re-valuation of raw materials will be required.

§ All Inventory in Branches

Inventory will be valuated for each batch of the receipts of STO using the STO price (transfer prices plus the landed costs).
The batches of goods will be delivered to customers at FIFO.
No re-valuation of inventory will happen.

Fiscal Year Change (AJRW) & Year-End Closing (AJAB)

Fiscal Year Change (AJRW)

From a system perspective, a fiscal year change represents the creation of a new fiscal year for a company code.
At the fiscal year change, the asset values from the previous fiscal year are carried forward cumulatively into the new fiscal year.
Once the fiscal year change takes place, you can post to assets using value dates in the new fiscal year. At the same time, you can, however, continue to post in the previous fiscal year, provided this has not been closed as a result of the year-end closing.
The fiscal year change can only be carried out (even in test mode) for the new fiscal year.
The earliest that you can carry out a fiscal year change is in the last month of the old fiscal year.
Before you can change to fiscal year YYYY, you must have already closed fiscal year YYYY-2. You can have a maximum of two fiscal years open for posting at one time.
No business transactions can be posted in a new fiscal year before the fiscal year change.
You can continue to post in the old fiscal year, even after the fiscal year change.
The system automatically corrects any values that have already been carried forward and that are affected by postings in the past.
The fiscal year change has to be carried out as background processing for performance reasons. You can carry out test runs with fewer than 1,000 assets in the foreground.
If the company code has been set to "production" (company code status = blank), you cannot carry out the fiscal year change until the last month of the current fiscal year (in update mode).
If the company code is a test company code (company code status = 2), you can change the fiscal year as and when required. You set the company code status in Customizing for Asset Accounting (OABP).
No more than two fiscal years, however, can be open at the same time.
Carry out the fiscal year change as a test run. If more than 1,000 assets exist in the system, you have to start the program by choosing Program ® Execute in Background. The section on depreciation posting runs contains information on monitoring the job and spool. If fewer than 1,000 assets exist in the system, you can also start the report online
If you started the report in update mode, the asset values from the previous fiscal year are carried forward cumulatively into the new fiscal year. Postings can now be made to the new fiscal year.

Year-End Closing (AJAB)

You can use the year-end closing program to close the fiscal year for one or more company codes from an accounting perspective.
Once the fiscal year is closed, you can no longer post or change values within Asset Accounting (for example, by recalculating depreciation).
The fiscal year that is closed is always the year following the last closed fiscal year. You cannot close the current fiscal year.
The year-end closing in Asset Accounting must be performed before the year-end closing in General Ledger Accounting.
The fiscal year change has to be carried out in Asset Accounting before the year-end closing (SAP FI-AA).
You have to carry out the year-end closing as background processing for performance reasons. Start the program, therefore, as a background job (on the selection screen for the program: Program ® Exec. in Background). You can carry out test runs with fewer than 1,000 assets in the foreground.
The system only closes a fiscal year in a company code if

· The system found no errors during the calculation of depreciation (such as incorrectly defined depreciation keys)

· Planned depreciation from the depreciation areas to be posted has been completely posted to the general ledger

· Balances from depreciation areas that are posted periodically have been completely posted to the general ledger

· All assets acquired in the fiscal year have already been capitalized. Since this check does not make sense for assets under construction, you can prevent it from being performed for these assets by means of the asset class.

· All incomplete assets (master records) have been completed.

The system lists any assets that do not meet the above requirements in the year-end closing log. The log also shows the reason for the errors.
You can undo a year-end closing that has already been performed.
You might need to do this if you establish that fixed assets do have to be corrected after all.
You can undo the year-end closing for the entire company code (OAAQ) or for each depreciation area (OAAR).
If you have performed the year-end closing in update mode, you can no longer post to the closed fiscal year.

Depreciation: AFAB

Use

o A posting to a fixed asset initially causes the planned depreciation to change in Asset Accounting.

o The accumulated depreciation accounts and depreciation accounts of the balance sheet and profit and loss statement are not updated immediately, however. The total planned depreciation is not posted to Financial Accounting until the periodic depreciation-posting run is executed.

o The depreciation posting should be run periodically (annually, semi-annually, quarterly, or monthly).

o When executed as an update run, the program has to be started in the background.

o The system creates posting documents for each depreciation area and account group in accordance with the posting cycles specified in Customizing.

o As the posting date, the system uses

· The last day of the period for normal periods (no special periods)

· The last day of the fiscal year for special periods

Prerequisites

o Document type AF has to define for posting depreciation.

o In definition of the document type, number range 03 has to specify with external number assignment.

o Also specify that the depreciation in depreciation areas

- 01 (book depreciation),

- 03 (reserves for special depreciation), and

- 20 (cost-accounting depreciation) is posted in the general ledger.

o Define the depreciation posting cycle by specifying the length of time in posting periods between two posting runs. The system is set in such a way that depreciation is posted monthly. You do not have to keep strictly to this posting cycle.

o You can also choose an unplanned depreciation-posting run using an indicator on the initial screen of the depreciation posting run. When you set this indicator, you can skip over several periods and post the total depreciation for all of the skipped periods in one period.

o The system supports two different procedures for distributing the forecasted depreciation over the posting periods.

o The difference between the two procedures becomes evident when you process acquisitions within the fiscal year or handle post-capitalization.

o With the catch-up method, depreciation due on a transaction within the fiscal year (from the depreciation start date, according to period control, up to the current period) is posted in one total. The depreciation posting program posts this amount in the period in which the posting date of the acquisition lies.

o With the smoothing method, the annual depreciation amount determined is distributed equally over the periods from the current posting period to the year-end.

o For each depreciation area, you have to specify whether depreciation is to be posted to the cost center and/or to the order. This information is taken from the asset master record and passed on to Financial Accounting as an additional account assignment.

o For depreciation area 20, the system is set to assign the cost-accounting depreciation and interest to the cost center.

Planned Posting Run

You can post to the next period that is specified according to the posting cycle. During a regular posting run of this kind, the system does not allow you to limit the run to particular assets.

Repeat Run

You can request a repeat posting run for the last period posted. You might need to carry out a repeat run if the depreciation terms were changed for individual assets in connection with the year-end closing, for example. During a repeat posting run, the system only posts the differences that resulted between the first posting run and the repeat posting run. You can limit the run to particular assets.

Restart

If a posting run terminated for technical reasons and changes had already been made to the database, you have to restart the program in restart mode. Using the restart mode ensures that all system activities that were interrupted by the termination are repeated.

Unplanned Posting Run

If, for whatever reason, you want to skip over one or more posting periods, you can do this by specifying an unplanned posting run. The system then creates postings for all the periods that were skipped, as well as for the period entered. The posting period that you specify, however, must fit into the posting cycle. If you specify period 7 for a quarterly posting cycle, for example, no posting occurs.

Once you have made all the necessary entries, execute the depreciation posting run in the background (Program ® Execute in Background). You can monitor the job scheduled in the background.

The job always appears under the name RAPOST2000. The Status column shows the current status of the job. Choose Refresh or F8 to update the information. As soon as the status of the job is "Finished", select your job and choose Spool.

To go from the overview to your list, choose F6. When this list was generated, the fixed assets in question were also updated to include the posted depreciation. The planned depreciation for every complex fixed asset is not totaled for each posting level and posted directly to Financial Accounting until the periodic depreciation posting run has been executed.

Result

The planned depreciation is posted to the accounts defined in Customizing. Note that the system always creates collective documents (not individual documents for each asset) when posting depreciation.

Difference between ECC 6.0 vs 4.7EE - SAP FI / SD / MM / ABAP (Functional & Technical)

ECC means Enterprise Central component.

SAP R/3 4.7 is based on the 3-tier architecture. SAP is continuously upgrading the software, which is called as release versions for example SAP R/3 4.6C, SAP 4.7....

Now SAP evolved into using the Internet technology and is called as service oriented architecture (SOA). There are lots of functionalities available in ECC 5.0 and ECC 6.0 compared to R/3 in integrating with other systems. Probably to understand the specific release dependent changes, you can go thro the help documentation. For example to understand the diff between ECC 6.0 and ECC 5.0 please go thro the link:

Release Notes for SAP ERP Central Component (English) – Click here

Some of the differences in SD Module are:

1. Document Flow

In ECC 6.0, the flow of sales documents is seen much better and improved as compared to 4.6C. Once you look at the screen, you will clearly figure out the difference.

2. Sales Order Look and Feel

There are more tabs in ECC 6.0 for Item Level Details.
The Sales Doc. appears as supremely perfect.

3. ECC 6.0 is built on Net Weaver Technology (that possess SOA i.e. service oriented architecture), Hence more reliable and improved as compared to previous one.

Release Notes for SAP ERP Central Component (English) – Click here

Some of the differences ABAP Module side:

For installing ECC 6.0 you required a solution manager key. With out solution manager key you cannot install ECC6.0.
ECC 6.0 is called net weaver component here you have ABAP+JAVA stack & for installing 4.6 you don't require solution manager key. It only having ABAP stack.
ECC6.0 supports UNCODE & 4.6C supports NONUNICODE.
Major difference is ECC6 is net weaver product having WASJAVA+ABAP - secondly support Unicode apart from this we have other diff. you can get from master guide from service.sap.com/instguides.

5. In terms of ABAP some function modules are obsolete in 4.7. e.g. WS_UPLOAD, WS_DOWNLOAD etc. You can find the list of obsolete FMs in the table RODIR. These need to be replaced in the ECC System.

6. Also ECC is very strict in case of EPC Errors. You need to check the EPC and remove the call function interface errors where it says SLIN observes catching of a runtime error. These might work with no issues in 4.7 but will short dump in ECC.

7. If you are doing to a Unicode conversion also. You need to check the transaction UCCHECK for Unicode errors. You also need to replace obsolete statements like >< and => , =< etc.

8. If you want to know more ABAP changes go to transaction ABAPDOCU and there is a node ABAP Changes by Release. You can see more ABAP Changes version by version here.

9. ECC is more towards OOPS concepts, ECC is very developer friendly

10. It has new debugger.

11. New Enhancement Framework is introduced in ECC.

12. It is more efficient to use Adobe forms in ECC.

13. 5.0 ECC - Build in Net Weaver Platform & 6.0 ECC - Build in Net Weaver Platform with Solution Manager

14. ECC has new options in BADIs where you can create your own badis and implement it.

15. You have new concept called Implicit and explicit source code plugins in ECC.

16. Has webdynrpo component accessible from SE80 transaction Itself.

Some of the differences FI Module side:

1. ECC 6.0 enables Business area posting - Segment reporting made easy.

2. Profit center accounting is through new GL.

3. Document splitting: Split of entry to post assets and liabilities to respective profit centers. (Balance sheet items)

4. Enables commitment of FM, improved CRM feature & Mobile sales feature

Here are the list of Transactions not their in ECC 6.0

QAS1 Download Insp. Specs. (Obsolete)
QAS2 Download Basic Data (Obsolete)
QAS3 Upload Results (Obsolete)
QAS4 Upload UD (Obsolete)

WLF1K Report used to generate WLF1K is: SAPLWLF1
O07C Report used to generate O07C is: SSFPSEMAINT

Check the below links to download the PDF files for the release notes of MM Module:

ECC 5.0 - MM Module Release notes

SAP R/3 MM Module Release notes

Some of the differences Basis/Technical Module side:

If you're "Basis/Technical", focusing on the underlying technical "Basis" or "NetWeaver" versions will help you stay on the right track. Technically, ECC 6.0 is 2 "technology" versions higher. Following is the terminology/version information for the last 3 ERP product versions:

SAP R/3 Enterprise (4.7x)
SAP BASIS 6.20

SAP ERP 2004
SAP NetWeaver 2004 (BASIS 6.40)
ECC 5.0

SAP ERP 2005
SAP NetWeaver 2004s (BASIS 7.00)
ECC 6.0

The main technology feature delivered with NetWeaver is the integrated J2EE engine (Web Application Server Java).

You can use the below link for finding the differences between the 2 versions.
http://solutionbrowser.erp.sap.fmpmedia.com/

Can find the difference in release notes of each SAP version. Here are the links.

http://help.sap.com/saphelp_47x200/helpdata/en/fc/e3003deddfae4de10000000a114084/frameset.html

http://help.sap.com/saphelp_scm50/helpdata/en/28/b34c40cc538437e10000000a155106/frameset.html

http://help.sap.com/saphelp_erp2005/helpdata/en/43/68805bb88f297ee10000000a422035/frameset.html

SAP: Asset Accounting: Reversing Documents

You can reverse documents that originated in Asset Accounting.

TCODE: AB08 -> Posting -> Reverse Document.

When you call up the reversal transaction, the system shows you all the transactions for the asset. Select the transaction you want to reverse, and choose the Reverse function.

Postings that Cannot Be Reversed in Asset Accounting

The following postings cannot be reversed in Asset Accounting. They have to be reversed in the integrated application in which they were posted:

Acquisition with vendor (Accounts Payable)

Acquisition with purchase order (goods/invoice receipt)

Retirement with customer (Accounts Receivable)

Stock withdrawal (Materials Management)

Reversal Indicator

Along with the special reversal transaction, the initial screen of the FI-AA posting transaction also offers a reversal indicator. When you set this indicator, you can create a posting that corresponds to the selected posting transaction, but has reversed positive/negative signs.

This posting, however, has no relation to the original document. In addition, when you use this posting, the system newly calculates the proportional value adjustments in accordance with the asset value date of the posting. This is different from the procedure with an actual reversal.

Reversal of the Settlement of an Asset under Construction

There is a separate transaction for reversing the settlement of an asset under construction. Enter the number of the asset under construction that was settled. The system then reverses all documents that were posted during the last settlement. If you want to reverse a settlement that was posted before the most recent one, you first have to reverse all the settlements, which were posted after the one you want, in chronological order.

You cannot use this transaction to reverse the settlement of assets under construction that were only managed for cost accounting.

SAP: Dates in Asset Accounting

Asset Value Date: is the value date of an asset transaction from the asset accounting point of view. Each transaction on a capitalized asset triggers the automatic calculation of depreciation on the posting amount. The asset value date, corrected by the period control of the depreciation key, is the key factor in determining the depreciation start date.

Default Values for Asset Value Date

Since the asset value date has a direct influence on the amount of depreciation, the system creates a default value for this date when it can. The overview that follows shows the default asset value date for the most important asset transactions:

Initial acquisition ->	Capitalization date from master record (if in same FY, otherwise posting date)
Subsequent acquisition in the same year->	Asset value date of initial acquisition
Subsequent acquisition in later years->	Document date
Down payment->	Capitalization date from master record (if in same FY, otherwise posting date)
Investment support->	Capitalization date from master record (if in same FY, otherwise posting date)
Revaluation->	Date of revaluation measure
Credit memo at time of invoice receipt->	Value date of the invoice receipt (if in same FY, otherwise posting date)
Later revenue/costs from retirement->	Date of last retirement (if in same FY, otherwise posting date)
Manual adjustments->	First day of fiscal year
Retirement/transfer->	No default value (required entry)
Settlement of AuC->	Posting date

If the capitalization date is not set in the asset master record after the initial acquisition, or if this date is not in the current fiscal year, the system uses the logic below to determine a default value for the asset value date:

If the document date and the posting date are both in the current fiscal year, the system uses the earlier of these two dates as the default asset value date.

If the document date is in a past fiscal year, the system uses the posting date as the default asset value date.

Automatically Set Asset Value Date

In the following posting transactions, you cannot enter an asset value date directly. The system therefore uses the default asset value date automatically. It determines which date it uses based on the table below:

Goods receipt (valuated) ->	Posting date
Invoice receipt with ref. to purchase order(valuated)->	Posting date of goods receipt (if in same FY, otherwise posting date)
Invoice receipt without reference to purchase order (valuated)->	Posting date
Invoice receipt (difference post.)->	Posting date of goods receipt
Stock withdrawal->	Posting date

Defining Your Own Logic for Determining the Asset Value Date

You can set up your own the method for determining the asset value date in Customizing for Asset Accounting (choose Transactions). Or you can use a customer enhancement project (transaction CMOD).

Capitalization Date

You can enter the capitalization date manually when you create the asset master record. The system uses this date as the default asset value date when you post the first acquisition to the asset. If you do not enter a capitalization date in the asset master record, the system automatically adopts the asset value date of the first acquisition posting as the capitalization date. The system inserts the asset value date of the first acquisition posting in the capitalization date field (Capitalized on...) in the asset master record, when a capitalizing transaction type is used.

Depreciation Start Date

The system determines the start period for depreciation calculation from the asset value date and the period control specified in the depreciation key (period control method) of the transaction category. The depreciation start date is the first day of the start period. The system determines the book value of an asset at the point of retirement In a similar fashion.

Date Asset Is Ready for Operation

Along with the date specifications already mentioned, you can also enter the date the asset is ready for operation in the asset master record (in the detail specifications of the depreciation areas). This date is for informational purposes only, and has no influence on the calculation of depreciation. If you do not make an entry in this field, the system automatically enters the capitalization date.

Fiscal Years That Can Be Posted

In the FI-AA component, it is possible to post to the current fiscal year and all previous fiscal years back to the date of the legacy data transfer for assets. When you post to past fiscal years, the system automatically updates all the relevant values in the subsequent fiscal years. Therefore, it is possible to make correction postings in the previous fiscal year, even after the fiscal year change (but before the year-end closing). However, after posting in a previous fiscal year, you need to run the depreciation posting program again for that year and all the following fiscal years up to the current fiscal year.

It is no longer possible to post to fiscal years that have been closed using the report for this purpose (refer to Year-End Closing).