Generic Withholding Tax Reporting

· Select Accounting -> Financial Accounting -> Accounts Payable -> Withholding Tax General -> S_P00_07000134.

Transaction Code

S_P00_07000134

Tips and Tricks

· If you cannot see the S_P00_07000134 transaction code by the description "Generic Withholding Tax Reporting", do the following steps:

0.1 From the SAP Easy Access menu, from the menu toolbar at the top of the screen, click on Extras -> Setting or click on Shift + F9. The following screen will appear:

Technical Settings

0.2 Check the "Display technical names" check box.

0.3 Click to continue and the SAP Easy Access menu will be reset.



· Select Accounting -> Financial Accounting -> Accounts Payable -> Withholding Tax General -> S_P00_07000134.

Transaction Code

S_P00_07000134

Tips and Tricks

· If you cannot see the S_P00_07000134 transaction code by the description "Generic Withholding Tax Reporting", do the following steps:

0.1 From the SAP Easy Access menu, from the menu toolbar at the top of the screen, click on Extras -> Setting or click on Shift + F9. The following screen will appear:

Technical Settings

0.2 Check the "Display technical names" check box.

0.3 Click to continue and the SAP Easy Access menu will be reset.
· If you know the transaction code (t-code) then you may type the code in the entry box in the upper left-hand corner of the SAP Easy Access screen and hit the Enter Key or icon to proceed.


You can save this transaction to your Favorites list by going to the SAP Easy Access window and left-clicking on the Transaction code. While holding the mouse button down, drag it to the top of the window into the Favorites folder.

· Create your own variant if the variant in this demo does not meet your needs.

· To navigate a report with multiple pages, utilize these buttons: . The first takes you to the first page. The second takes you to the previous page. The third takes you to the next page. The fourth takes you to the last page.



Procedure


Your Favorites folder may have different t-codes saved. Ignore the Favorites folder of the above menu path.

read more...

SAP DB FAQ - 2

What is data quality?
Within SAP, data quality is defined as postal validation, duplicate checking, and error tolerant searching. Postal Validation enhances address information by comparing data against address directories provided from local postal authorities around the world. Duplicate Check avoids duplicate entries by scanning the database for potential duplicates before new customer data is committed to the database. Finally, Error Tolerant Searching provides flexibility by giving users the ability to conveniently search their SAP system for business information as required. Involvement of a data quality initiative helps you maintain a reliable source of information for all departments within your own organization while simultaneously maximizing interactions with your vendors, customers, and business partners.

When and where should I integrate data quality into my SAP Suite of applications or other projects in my enterprise?


What is data quality?
Within SAP, data quality is defined as postal validation, duplicate checking, and error tolerant searching. Postal Validation enhances address information by comparing data against address directories provided from local postal authorities around the world. Duplicate Check avoids duplicate entries by scanning the database for potential duplicates before new customer data is committed to the database. Finally, Error Tolerant Searching provides flexibility by giving users the ability to conveniently search their SAP system for business information as required. Involvement of a data quality initiative helps you maintain a reliable source of information for all departments within your own organization while simultaneously maximizing interactions with your vendors, customers, and business partners.

When and where should I integrate data quality into my SAP Suite of applications or other projects in my enterprise?
Data quality should be integrated any place where data is entered, loaded, processed, or updated. Data quality should be built into the beginning phases of all Enterprise Resource Planning, Customer Relationship Management, and Business Intelligence projects. Too many projects focus on data quality as an afterthought, at the back-end of a data repository or when a project has failed. By not incorporating data quality measures at every customer touch point, on both front and back-end operations, the cost of cleansing the data dramatically increases as well as how long the cleansing process takes to complete.

Can I integrate a data quality solution within other software applications?
Data quality solutions can be fully integrated into CRM , ETL (Extract Transform Load), ERP, or BI solutions and have the advantage of being "seamless" to the end user - reducing the learning curve, as well as decreasing the implementation timeframes. Your data process flow should not have to be modified to add a new data quality solution. Through integration and strategic partnerships you are assured that you are getting a best-of-breed solution. However, keep in mind it is not absolutely necessary for the solution to be fully integrated. Firstlogic also provides tools that your organization can easily integrate on your own, and oftentimes stand-alone solutions may be more effective for specific projects.

Will Firstlogic's Global Data Quality Connector for SAP manage my international data?
Yes. Built on a global framework capable of validating address information for over 190 countries in a single processing pass, Firstlogic's Global Data Quality Connector for SAP allows you to identify country names, format and standardize addresses, correct missing address information, and assign postal codes for each respective country. Furthermore, Firstlogic's Easy IQ technology offers the ability to complete/populate addresses with minimal data or offer suggestions for possible matches. This easy address system is ideal in Call Centers or any transactional environment where data needs to be cleansed at the point-of-entry. The software improves real-time transactions for your call centers, sales, and support centers by providing accurate address data for your customer facing employees.

How easy is it to maintain Firstlogic's Global Data Quality Connector for SAP after implementation?
Ongoing maintenance should be minimal. Once the solution is implemented and configured, typically maintenance will only be required when you receive postal directory updates, upgrade to a new data quality release, or decide to change your application or business rules.

What are the benefits of a data quality solution?
The biggest benefit is the confidence you have that your data is accurate. A data quality solution also allows you to:

* Manage customer data in different formats initially residing in separate databases
* Build and maintain successful relationships
* Better understand and service your customers
* Enhance knowledge management and business intelligence initiatives with reliable and accurate information
* Deliver clean, reliable data throughout your expanding information supply chains to all varieties of operational and analytical applications throughout your enterprise

How does Firstlogic's Global Data Quality Connector for SAP Systems work?
Firstlogic's Global Data Quality Connector is integrated at the BASIS layer and communicates with the SAP Applications via TCP/IP leveraging SAP's Remote Function Call (RFC) interface. As users make postal validation inquiries in either batch or real-time, calls are made outside of the SAP Application to Firstlogic's RFC Server. Once the customer's address has been received by Firstlogic's technology, our Information Quality Suite parses, standardizes, and corrects records according to configurable business rules and local postal authority standards. To ensure your customer view is optimized, Firstlogic's technology catches duplicates at the point of entry; not after redundant information has infected your SAP Environment. Before any customer, vendor, or business partner is committed to the database , Firstlogic's Information Quality suite will immediately inspect the data upon input. The connector scans the entire database for duplicates and assigns a similarity match score to potential duplicates. At that point, the user can determine whether the entered record is unique or a duplicate that should be eliminated from the system. In addition, convenient Error Tolerant Searching is available for prompt and precise address recognition. This improves transaction processing, saves time locating records, and optimizes system efficiency.

Explain the architecture of Firstlogic's Global Data Quality Connector for SAP Systems.
Integrated at the BASIS/WAS layer, Firstlogic has developed Business Add-Ins (BAdI's) that can be leveraged with a single instantiation; allowing for all SAP modules that utilize SAP's Business Address Services framework to leverage the compelling advantages of Firstlogic technology. Furthermore, Firstlogic's Information Quality Suite has been developed as a Remote Function Call (RFC) Server: the most common integration component of SAP software. Utilizing SAP's RFC interface, SAP makes calls to Firstlogic technology for address check, updates, duplicate checks, and error tolerant searches.

read more...

SAP DB FAQ - 1

General

Why has SAP DB been released as Open Source?

SAP believes that times have changed, that databases are becoming part of the basic technology infrastructure, and as such, they need not be proprietary or complex. SAP sees that the time is right to drive open-source development of database technology and contribute to this effort by making SAP DB Open Source. Open-source development is revolutionizing the way software is created, as shown by the success of Linux, and SAP - which is already providing the first comprehensive e-business solution on Linux - wants to encourage this development.

There are other open-source databases - why SAP DB?

SAP DB is a state-of-the art, SQL-based, industrial-strength database system. SAP DB is platform-independent, so users can deploy it for a wide array of projects. SAP DB is highly scalable, easy to use and maintain, and provides full transaction support. Companies can deploy SAP DB together with SAP applications for a complete out-of-the-box business solution. SAP DB also goes beyond relational processing by offering object orientation as well as support for managing unstructured data. This comprehensive set of features and their availability as Open Source will benefit the entire database development community.

How many people are developing SAP DB?

Since mid-1997, SAP has made considerable investments into SAP DB, which is maintained and continuously enhanced by a dedicated team of about 100 SAP developers.

Where can I get SAP DB?

SAP DB software can be downloaded, together with a sample database.

With which database release did the Open Source era begun?

With SAP DB Release 7.2

Where can I find the latest information about SAP DB?

SAP is launching an online community at the SAP DB homepage for developers and users to share and exchange enhancements to SAP DB, take part in mailing lists, newsgroups, and chat forums, download software updates, share tips about the software, and locate service and support offerings provided by SAP or other organizations. Those interested can subcribe to two mailing lists:
To receive the latest information on SAP DB as soon as they are available subscribe to the mailing list sapdb-announce@listserv.sap.com.
The mailing list maxdb@lists.mysql.com is the News Forum of the SAP DB Community. You can use this address for discussions and exchanging experiences with other people interested in SAP DB. This mailing list will be used as the basis for a newsgroup.

How many SAP DB installations are there?

Currently, there are about 2000 SAP DB installations with more than 1000 customers running, not included SAP liveCache and Content Server installations, which are also SAP DB products.

Are there restrictions in terms of the number of database users or of the database size?

No. SAP DB runs successfully on large, medium-sized, and small installations.

Is this a special limited version?

No. The software released as Open Source is the unlimited and current release as used by customers of SAP solutions.

How much do you have to pay for licenses, service, and administration when you use SAP DB?

You don’t have to pay for SAP DB database licenses. When you use SAP DB as a database for mySAP.com solutions, you pay a mandatory maintenance fee but thanks to the easy administration and low space requirements of SAP DB, additional costs are kept to a minimum.

What about customers that have already purchased SAP DB?

The availability as open-source software does not affect existing SAP DB customers' licensing and maintenance agreements with SAP. New SAP DB installations in combination with SAP applications will be handled by a new business model, which only charges for service and support. For non-SAP applications, customers have the option of purchasing service and support offerings from SAP or other organizations for a fee, which is a common business model for open-source software.

Which database version shall I use?

SAP DB version 7.4 is the latest official release of SAP DB software. All new users of SAP DB are recommended to start with version 7.4, since it offers a number of valuable new features.
Nevertheless, version 7.3 will continue being developed for those using it in productive systems.

---

Open Source Process

Does SAP just want to dump SAP DB on the open-source community and walk away?

Not at all. On the contrary, SAP will continue to develop and support SAP DB to drive future enhancements in cooperation with the open-source community. Leveraging database technology is important for delivering comprehensive and innovative SAP components. Basis development in Berlin contributes to the Supply Chain Management/liveCache, Knowledge Management/Info DB, and SAP DB for SAP solutions among other tasks.

Where can I submit bug reports?

SAP DB's web-based problem tracking system can be used for bug reports and change requests.

How will contributions be handled?

At present, you are invited to send everything to the mailing list . Dependent on the amount of submissions, the contribution traffic may be moved to a separate mailing list or into the error tracking system.

Will applications using SAP DB have to be Open Source as well?

No. Applications are using SAP DB as a service similar to the way they are using the operating system. The programming interfaces are released under the GNU LGPL (Library or Lesser General Public License). Software linked with the programming interfaces is not required to be released as Open Source.

---

Technical

What are the key characteristics of SAP DB?

SAPDB is a state-of-the-art enterprise database system with a high level of performance, scalability, robustness and reliability. It is very easy to use and maintain, for example, no reorganization is required and the database allows for uninterrupted 24x7 operation.
Thanks to its automatic, dynamic memory management, SAP DB also needs less disk space than other database systems such as Oracle or Informix. System resources do not require constant attention.
All this, together with the fact that SAP DB is an open source solution, keeps total cost of ownership (TCO) at an all-time low compared to other database systems.

Where can I find a summary of the differences between SAP DB and other database systems?

At the moment, no general summary is available. However, in terms of functionality and performance, SAP DB meets all the requirements needed to ensure smooth operation of all SAP solutions.

Which platforms does SAP DB support?

SAP DB currently supports Linux (Intel), Windows NT / Windows 2000 / Windows XP, IBM-AIX, SUN-Solaris, Tru64-Unix and HP-UX. OS/390, ZLinux and Microsoft .NET will also be supported in the near future.

Can I run SAP DB on 64-bit platforms??

Yes, but the 64-bit Linux and Intel ia64/Windows version are not yet available for productive use. We expect those during the first half of 2003.

Which SQL standard does SAP DB support?

ANSI 92 Entry-Level

Which interfaces are supported?

ODBC (3.5.1), JDBC (2.0/3.0), C/C++ precompiler, and others.

Are there restrictions in terms of the number of database users or the database size?

ANSI 92 Entry-Level

Which reorganization actions are necessary in a running SAP DB operation?

None. Due to its fully automatic memory administration, SAP DB is completely reorganization free.

Can SAP DB systems be run 24 hours a day, 7 days a week?

Yes. Using SAP DB, all necessary backup activities can be executed online.

Is there a C-API to access SAP DB?

ODBC is the official C-API. There is no performance loss because ODBC is not implemented as a wrapper around a lower level API. In UNIX, programmers can use either one of the available driver managers or link them directly with the libraries provided with SAP DB.

What are the backup and recovery characteristics of SAP DB?

Backup and recovery are also part of our ease-of-use approach. The Database Manager, an SAP DB tool, offers intuitive backup scenarios and guides you through recovery processes. If you are running an SAP system with SAP DB, you can also schedule and execute your database administration tasks in the SAP Computing Center Management System (CCMS).

Can I use Legato/IBM/Tivoli backup utilities?

Yes, you can also use external backup tools. The Database Manager currently supports the following backup tools: TSM (IBM), Backint for Oracle, Backint for SAP DB, and NetWorker (Legato).

Are there any monitoring tools for SAP DB?

The Database Manager, an SAP DB tool, offers monitoring features for administration purposes. There is also a new special monitoring tool, Database Analyzer, delivered with SAP DB Version 7.4 upwards. The Database Analyzer has default configurations for standard use but can also be used by experienced administrators to make more sophisticated analyses.

What about scalability?

SAP DB provides state-of-the-art performance and scales well on multi-processor architectures.

---

Documentation, Training and Support

Where can I find up-to-date documentation?

You can find all SAP DB documentation in English under Documentation. You can read the documentation online or download it. For a basic overview of the database system architecture, user and security concepts and the available database tools, please consult the documentation The Database System SAP DB.
If you are looking for documentation describing features that are specific to SAP applications such as the Computing Center Management System (CCMS) for database administration.

Does SAP offer courses on SAP DB administration?

SAP offers two courses on SAP DB administration, the basic course BC515 (will be renamed ADM515) and workshop WB550 that goes into more technical details.

Where and how can I obtain SAP DB support?

The SAP DB support models for SAP applications and non-SAP applications are different.
SAP applications: If you use SAP DB in combination with an SAP application, you are entitled to SAP support through your maintenance contract with SAP.
Non-SAP applications: For non-SAP applications, customers have the option of purchasing services and support from SAP (Premium Support) or other organizations. Open source users can also ask for support via the SAP DB Open Source mailing list,which is free of charge.

What does Premium Support mean?

A Premium Support Contract gives SAP DB users running non-SAP applications access to the SAP service infrastructure for problem reporting and solving, including performance problems. The customer is requested to set up a Customer Competence Center (CCC) with a limited number of contact persons. The support fee is 60,000 euros per year per CCC. If you already have an SAP DB maintenance contract for an SAP solution, this fee is reduced.

How does the SAP DB Open Source model work?

With SAP DB, SAP provides a professional product that can be downloaded and used as free software for non-SAP applications by anyone. Binaries, source code, tools and programming interfaces are published under the GNU LGPL/GPL (Lesser General Public License/General Public License) , together with information and documentation.

---

High Availability

Does SAP DB offer High Availability/Hot Standby Server solutions?

SAP DB supports a couple of standby solutions. Which one you choose depends on your requirements.

• SAP DB supports Snapshot and Split Mirror Techniques (see SAP Note 371247)
• SAP DB supports Cluster solutions, which are implemented by the hardware suppliers. The Microsoft Cluster Server is directly supported by SAP DB (see SAP Notes 319835 and 508979).
• You can build a shadow database with SAP DB versions 7.2.05 upwards. In addition, the Libelle company offers a tool called DBShadow, which will soon be available for SAP DB.
• The support of a Hot Standby Configuration with logshipping via a storage system is planned for version 7.4.4, which is scheduled for the first or second quarter of 2003.

For documentation on standby solutions see the documentation The Database System SAP DB.

---

Migration from Other Databases to SAP DB

I want to move my SAP system to SAP DB. Will this pose any problems?

No, your system will run as smoothly on SAP DB as it does on your current database. You can migrate your system by performing a heterogeneous system copy (that is, exporting the database with the R3Load program, re-installing the SAP system and then re-importing the database). All conversions and adjustments of data are covered by the R3Load program.
Of course, any migration to another database will lead to some additional customizing on secondary keys, etc.

What do I have to do to move my productive environment to SAP DB?

SAP offers a service called OS/DB Migration Check containing, among other things, a migration test, Early Watch sessions, and consulting. The customer checks in a test environment whether the migration results fulfill his expectations in terms of performance and duration, and carries out operative tests with an avarage amount of users. This service is mandatory to get post-migration support. SAP customers can find additional information in SAPNet, alias osdbmigration.

I am currently running a very large database system. What will happen when I migrate to SAP DB?

Over the past few years, we have been investing constantly in the development of automatic space management. This means that your SAP DB will actually need up to 40 percent less space than, for example, an Oracle or Informix database. This in turn means less cost and better performance.

Will SAP DB offer the same features as my current database system?

SAP DB conforms to standards in every respect and provides all the interfaces that you would expect of an open database system. SAP DB meets official ISO/ANSI SQL 92 Standards (entry Level plus extensions), so that SQL programs created for other database systems can be easily ported to SAP DB, and is compatible with Oracle7. The ODBC driver allows you to use Microsoft Windows-based office tools or reporting tools. Using the JDBC driver, you can easily connect SAP DB as a database engine to Java-based application servers. There is a precompiler for C/C++. Interfaces are available for the script languages Perl, Python and PHP.

Does SAP DB run with the SAP Business Information Warehouse (BW)?

We know from experience with 46 installations, 7 of which are productive systems, that small and medium-sized BW installations run smoothly on SAP DB.
Version 8.0, which will be released in the third quarter of 2003, will also feature architectural improvements especially for BW operation.

What will be the cost and time effort of migrating my current database to SAP DB?

If you take into account all preparations, migration checks, setting up the new environment and testing, the process generally requires two weeks, but the migration itself (that is, system downtime) only takes one or two days. Always bear in mind the benefit of switching to a database system that offers the same performance at significantly lower costs, is free of reorganisation tasks and requires an outstandingly easy administration.

Are there any plans to make switching from a different database to SAP DB easier?

We are thinking about offering a tighter bracket of processes, but all in all it will remain a heterogeneous migration.

Are there any SAP products that require SAP DB?

SAP APO (SAP Advanced Planner and Optimizer) is shipped with SAP liveCache, a special, object-oriented version of SAP DB.
SAP DB has become an important element of the SAP technology stack and will be used as the default database in more and more SAP solutions.

read more...

What is Data Archieving and its procedure?

Right Retrieval Strategy

An important challenge for SAP administrators is to find out the appropriate data for archiving. It is important to have knowledge of the business processes involved in the enterprise, prior to data archiving, so that appropriate archive objects are created. This helps in identifying database table growth and simplifies the process of identifying objects for archiving.

Three Phase Archiving Process

Data archiving process comprises three major phases. They are:

* Creating an archive file
* Removing the archived data from the database
* Transferring the archived files to a location outside the SAP database


Currently, a large number of enterprises use SAP R/3 as a platform for integration of business processes. The continuous usage of SAP results in huge amounts of enterprise data, which is stored in SAP R/3. With passage of time, the new and updated data is entered into the system while the old data still resides in the SAP enterprise system.

Since some of the old data is critical, it cannot be deleted. The difficulty is keeping the data you want, and deleting the data you do not want. Hence, a SAP database keeps on expanding rapidly and enterprise systems, which have limited data retention abilities for a few years, suffer from problems such as data overflow, longer transaction processing times, and performance degradation.

The solution of this problem has led to the concept of Data Archiving in SAP. Data Archiving removes out-of-date data from the SAP database that the R/3 system does not need online, but can be retrieved on a later date, if required. This data is known as archived data and is stored at an offline location. Data Archiving not only consistently removes data from the database but also ensures data availability for future business requirements.

One rule of thumb is that in a typical SAP enterprise system, the ratio of data required to be online and instantly accessible to old data, which could be archived, and stored offline is 1:6. For example, if an enterprise has 2100 GB of SAP database, the online data, which is frequently used by SAP users will be 300 MB and the rest (1800 MB) will be scarcely used and hence can be archived.

Data Archiving – Features

* It provides a protection layer to the SAP database and resolves underperformance problems caused by huge volumes of data. It is important that SAP users should keep only minimal data to efficiently work with database and servers. Data archiving ensures that the SAP database contains only relevant and up-to-date data that meet your requirements.

* Data archiving uses hardware components such as hard disks and memory. For efficient data archiving, minimum number of disks and disk space should be used.

* It also reduces the system maintenance costs associated with the SAP database. In the SAP database there are various procedures such as, data backup, data recovery, and data upgrade.

# SAP data archiving complies with statutory data retention rules that are common and well-proven techniques.

Right Retrieval Strategy

An important challenge for SAP administrators is to find out the appropriate data for archiving. It is important to have knowledge of the business processes involved in the enterprise, prior to data archiving, so that appropriate archive objects are created. This helps in identifying database table growth and simplifies the process of identifying objects for archiving.

Three Phase Archiving Process

Data archiving process comprises three major phases. They are:

• Creating an archive file
• Removing the archived data from the database
• Transferring the archived files to a location outside the SAP database

Phase I - Creating Archive Files

The archived files of data are created in the SAP database by the Archiving Management system. The Management system reads the data from the database and writes it to the archive files in the background. In instances of archived files exceeding the maximum specified limit, or if the number of data objects exceed the stipulated limit in the system, then the system automatically creates new archive files.

At the end of the process of saving data into archive files, ADK triggers the system event SAP_ARCHIVING_WRITE_FINISHED, which is an indicator to the system to start next phase of archiving process.

Phase II - Deleting files from the Database

While archiving management system writes data on the archive files, another program deletes it from the database permanently. The program checks whether the data has been transferred to the archive. It is quite important too as it is the last check performed by the system before deleting data permanently from the database. Several deletion programs run simultaneously, because the archiving program is much more faster than the deletion programs. This is important as it increases the efficiency of archiving process.

Phase III - Transferring Archive Files

Once the Archive management system has finished archiving the data, the next step is to save the archived files at a different location other than the SAP database. This can be accomplished by an automated process in the system or by a manual process. This step is optional since many enterprises may wish to keep the archived files within the current database. However, large enterprises transfer their data periodically as a part of their data archiving processes.

read more...

What is Forward and Backward Scheduling?

Precise scheduling calculated down to the day, hour and minute is supported. This allows the scheduling of a delivery within a single day. It is activated by maintaining the working hours for a particular shipping point.

Backward scheduling is always carried out first. If the material availability date or transportation scheduling date is calculated to be in the past, the system must then use forward scheduling.

Forward scheduling is also done if no product is available on the material availability date calculated by backward scheduling. The system does an availability check to determine the first possible date when product will be available. This new material availability date forms the starting point for scheduling the remaining activities. The loading time, pick/pack time, transit time, and transportation lead time are added to the new material availability date to calculate the confirmed delivery date.

Backward scheduling is the calculation of deadline dates: the arrival time at the customer site is calculated as the earliest possible goods receipt time at the customers unloading point on the requested delivery date. All four of the delivery and transportation scheduling lead times are subtracted from the customer’s requested delivery date to determine if this date can be met.

The transit time, loading time, and pick/pack time are subtracted from the customer’s requested delivery date to calculate the required material availability date.

The system calculates backward scheduling as follows:

Requested delivery date minus transit time = Goods issue date
Goods issue date minus loading time = Loading date
Loading date minus transportation lead time = Transportation scheduling date
Loading date minus pick/pack time = Material availability date

By default, the system will calculate delivery dates the closest day, taking into consideration the working days of the shipping point and a rounding profile. In this case the system assumes a 24 hour work day and lead times can be entered in days up to 2 decimal points. This is referred to as daily scheduling.

Precise scheduling calculated down to the day, hour and minute is supported. This allows the scheduling of a delivery within a single day. It is activated by maintaining the working hours for a particular shipping point.

Backward scheduling is always carried out first. If the material availability date or transportation scheduling date is calculated to be in the past, the system must then use forward scheduling.

Forward scheduling is also done if no product is available on the material availability date calculated by backward scheduling. The system does an availability check to determine the first possible date when product will be available. This new material availability date forms the starting point for scheduling the remaining activities. The loading time, pick/pack time, transit time, and transportation lead time are added to the new material availability date to calculate the confirmed delivery date.

read more...

SD - Finance Table

AGKO Cleared Accounts

ANAR Asset Types

ANAT Asset type text

ANEK Document Header Asset Posting

ANEP Asset Line Items

ANEV Asset downpymt settlement

ANKT Asset classes- Description

ANLA Asset Master Record Segment

ANLB Depreciation terms

ANLC Asset Value Fields

ANLH Main asset number

AT02T Transaction Activity Category- Description

AT02A Transaction Code for Menu TIMN...........

AGKO Cleared Accounts

ANAR Asset Types

ANAT Asset type text

ANEK Document Header Asset Posting

ANEP Asset Line Items

ANEV Asset downpymt settlement

ANKT Asset classes- Description

ANLA Asset Master Record Segment

ANLB Depreciation terms

ANLC Asset Value Fields

ANLH Main asset number

AT02T Transaction Activity Category- Description

AT02A Transaction Code for Menu TIMN

AT10 Transaction type

AT10T Name of Transaction Type

BKDF Document Header Supplement for Recurring Entry

BKORM Accounting Correspondence Requests

BKPF Accounting Document Header

BLPK Document log header

BLPP Document log item

BLPR Document Log Index and Planned Order (Backflush)

BNKA Bank master record

BP000 Business Partner Master (General Data)

BPBK Doc.Header Controlling Obj.

BPEG Line Item Total Values Controlling Obj.

BPEJ Line Item Annual Values Controlling Obj.

BPEP Line Item Period Values Controlling Obj.

BPGE Totals Record for Total Value Controlling obj.

BPJA Totals Record for Annual Total Controlling Obj.

BSAD Accounting- Secondary Index for Customers (Cleared Items)

BSAK Accounting- Secondary Index for Vendors (Cleared Items)

BSAS Accounting- Secondary Index for G/L Accounts (Cleared Items)

BSEC One-Time Account Data Document Segment

BSEG Accounting Document Segment

BSID Accounting- Secondary Index for Customers

BSIK Accounting- Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting- Secondary Index for G/L Accounts

CEPC Profit Center Master Data Table

CEPCT Texts for Profit Center Master Data

COBRA Settlement Rule for Order Settlement

COBRB Distribution Rules Settlement Rule Order Settlement

COKA CO Object- Control Data for Cost Elements

COSP CO Object- Cost Totals for External Postings

COSS CO Object- Cost Totals for Internal Postings

CRCO Assignment of Work Center to Cost Center

CSKA Cost Elements (Data Dependent on Chart of Accounts)

CSKB Cost Elements (Data Dependent on Controlling Area)

CSLA Activity master

FEBEP Electronic Bank Statement Line Items

FPLA Billing Plan

FPLT Billing Plan- Dates

GLPCT EC-PCA- Totals Table

KNA1 General Data in Customer Master

KOMK Pricing Communication Header

MAHNV Management Records for the Dunning Program

REGUT TemSe - Administration Data

SKA1 G/L Account Master (Chart of Accounts)

SKAT G/L Account Master Record (Chart of Accounts- Description)

SKB1 G/L account master (company code)

T003T Document Type Texts

T007S Tax Code Names

T087J Text

TAPRFT Text tab. for investment profile

TKA01 Controlling Areas

TKA09 Basic Settings for Versions

TKVS CO Versions

TZB0T Flow types text table

TZPAT Financial Assets Management product type texts

VBSEGS Document Segment for G/L Accounts Document Parking

VTBFHA Transaction

VTBFHAPO Transaction Flow

VTBFHAZU Transaction Activity

VTBFINKO Transaction Condition

VTIDERI Master Data Listed Options and Futures

VTIFHA Underlying transaction

VTIFHAPO Underlying transaction flows

VTIFHAZU Underlying transaction status table

VTIOF Options Additional Data

VWPANLA Asset master for securities

read more...

What is Step Loop?

Step by Step Process :
A step loop is a repeated series of field-blocks in a screen. Each block can contain one or more fields, and can extend over more than one line on the screen. Step loops as structures in a screen do not have individual names. The screen can contain more than one step-loop, but if so, you must program the LOOP…ENDLOOPs in the flow logic accordingly. The ordering of the LOOP…ENDLOOPs must exactly parallel the order of the step loops in the screen. The ordering tells the system which loop processing to apply to which loop. Step loops in a screen are ordered primarily by screen row, and secondarily by screen column.

Transaction TZ61 (development class SDWA) implements a step loop version of the Table you saw in transaction TZ60.

Static and Dynamic Step Loops

A step loop is a repeated series of field-blocks in a screen. Each block can contain one or more fields, and can extend over more than one line on the screen. Step loops as structures in a screen do not have individual names. The screen can contain more than one step-loop, but if so, you must program the LOOP…ENDLOOPs in the flow logic accordingly. The ordering of the LOOP…ENDLOOPs must exactly parallel the order of the step loops in the screen. The ordering tells the system which loop processing to apply to which loop. Step loops in a screen are ordered primarily by screen row, and secondarily by screen column.

Transaction TZ61 (development class SDWA) implements a step loop version of the table you
saw in transaction TZ60.

Static and Dynamic Step Loops

Step loops fall into two classes: static and dynamic. Static step loops have a fixed size that cannot be changed at runtime. Dynamic step loops are variable in size. If the user re-sizes the window, the system automatically increases or decreases the number of step loop blocks displayed. In any given screen, you can define any number of static step loops, but only a single dynamic one.

You specify the class for a step loop in the Screen Painter. Each loop in a screen has the attributes Looptype (fixed=static, variable=dynamic) and Loopcount. If a loop is fixed, the Loopcount tells the number of loop-blocks displayed for the loop. This number can never change.

Programming with static and dynamic step loops is essentially the same. You can use both the LOOP and LOOP AT statements for both types.

Looping in a Step Loop

When you use LOOP AT with a step loop, the system automatically displays the step loop with vertical scroll bars. The scroll bars, and the updated (scrolled) table display, are managed by the system.

Use the following additional parameters if desired:

* FROM and TO
* CURSOR

read more...

Complete Transaction Set

Transactions

* search_sap_menu - Finds the menu path to a transaction - Can either type in TX code in the search criteria or a description- ie. 1st try SE38 and then ABAP.... the returned result is 'bottom to top'.

EDI Specific Transactions

* VOE1 - Translation between EDI categories and SD item categories
* VOE2 - Table EDSC view. Customer link to sales area detail
* VOE3 - Table view EDPVW. Add partner types that will be transferred to the IDoc
* VOE4 - Table view EDPAR. Link external partner number with our internal number
* WEDI- EDI Administrator Menu
* BALE - Idoc Administration

Scheduling agreements

* OVA9 Create entries for each sold-to customer for which you will receive EDI schedule releases. At implementation, the only field that needs to be maintained is "Check PO number," which causes SAP to make sure that the PO number sent on the release matches the PO number on the schedule agreement. This transaction updates table T663A. SAP will not post an EDI schedule release, if this record is missing.


Transactions

* search_sap_menu - Finds the menu path to a transaction - Can either type in TX code in the search criteria or a description- ie. 1st try SE38 and then ABAP.... the returned result is 'bottom to top'.

EDI Specific Transactions

* VOE1 - Translation between EDI categories and SD item categories
* VOE2 - Table EDSC view. Customer link to sales area detail
* VOE3 - Table view EDPVW. Add partner types that will be transferred to the IDoc
* VOE4 - Table view EDPAR. Link external partner number with our internal number
* WEDI- EDI Administrator Menu
* BALE - Idoc Administration

Scheduling agreements

* OVA9 Create entries for each sold-to customer for which you will receive EDI schedule releases. At implementation, the only field that needs to be maintained is "Check PO number," which causes SAP to make sure that the PO number sent on the release matches the PO number on the schedule agreement. This transaction updates table T663A. SAP will not post an EDI schedule release, if this record is missing.

*OVAI Create entries for each Vendor / Partner description combination. (Vendors must match sold-to Acct. at Cust., and Partner descriptions must match ship-to Partner descriptions.) This transaction updates table T661W. SAP uses this table to determine the schedule agreement sold-to partner.

* OVAJ If you would like SAP to post schedule requirements using discrete dates only, instead of weekly and/or monthly buckets, you can indicate the days of the week that you deliver to this customer. SAP will divide the customer's quantity for a week or month evenly into the days of the week specified by the distribution function code. This code must be sent in the DELINS IDoc in field E1EDP16-ETVTF.

IDoc Transactions

* WE09 / WE02 IDoc lists according to content. View IDocs via specific IDoc number or business application detail contained within the contents of a segment.
* WE05 View IDocs
* WE19 EDI test tool. Use to test inbound Function module changes.
* WE20 Partner profile configuration. Add partner detail together with inbound and outbound relationships. We also incorporate message control on the outbound IDocs. Utilize the organizational units to trap functional errors for further processing
* WE30 Create IDoc extension type
* WE31 Segment create
* WE57 Assign function module to logical message and IDoc type
* WE60 IDoc type documentation tool
* WE82 Link Release detail to Extension IDoc Type
* BD55 Conversion rule user exit. Link conversion rule user exit to the different system \ partner combinations
* BD87 Reprocess IDocs in error or waiting for action. (Both inbound and outbound in 4.6. Use BD88 in prior versions)
* BALA ALE Application Distribution
* BALM ALE Master Data Distribution

Output determination
856 - ASN

* V/36 Maintain output determination for deliveries (Output determination procedures). V10000 (Header output) has condition type LAVA (usually with requirement 1 NB: Use V/84 – V7ALLE – SHAD for grouped ASNs. I.e. Group deliveries into shipments
* VV21,VV22,VV23 Create output condition records for shipping. LAVA – WE (Partner function) - We must add each new partner with VV21
* VL71 Reissue output for deliveries

810 - Invoice

* V/54 Maintain access sequence for billing documents
* VV31,VV32,VV33 Create condition records for billing documents. (RD00 – RE Billing party)
* VF31 Reissue output for billing documents

855 – Order Response

* V/30 Sales document output types (BA00)
* V/48, V/32, V/43 Maintain access sequence for sales documents
* VV11,VV12,VV13 Create condition records for sales documents. (BA00 – SP Sold to party)
requirements coding

* V/27 Create code to check requirements for output control. Used to check ZBA0 against BA00 output.

Sales & Distribution
Sales order / Quote / Sched Agreement / Contract

* VA02 Sales order change
* VA05 List of sales orders
* VA22 Quotation change
* VA32 Scheduling agreement change
* VA42 Contract change

Billing
* VF02 Change billing document
* VF11 Cancel Billing document
* VF04 Billing due list
* FBL5N Display Customer invoices by line
* FBL1N Display Vendor invoices by line

Delivery

* VL02N Change delivery document
* VL04 Delivery due list
* VKM5 List of deliveries
* VL06G List of outbound deliveries for goods issue
* VL06P List of outbound deliveries for picking
* VL09 Cancel goods issue
* VT02N Change shipment
* VT70 Output for shipments

General

* VKM3, VKM4 List of sales documents
* VKM1 List of blocked SD documents
*VD52 Material Determination

Workflow

* SWEAD Event queue administration
* SWE2 Event type linkages
* SWE3 Event linkages
* PPOME Organizational Unit Maintenance
* SWE5 Consistency Checks for Event Linkages
* SWUD Workflow Diagnostic Tool

General

The following section provides detail on other useful SAP areas.
Create delivery via transfer orders

Once the order is saved proceed through the following steps. The process assumes the item has values in the warehouse bin.

* VL04 Delivery due list. Run the delivery due with your order number to create the delivery
* LT03 Create Transfer Order. EG. Warehouse: 101 and enter. Picking background. Save
The Transfer order should now be saved. It now needs to be confirmed.

* In LT03 go to menu option Transfer Order -> Confirm – Transfer Order
* Enter
* Save

The transfer order is now confirmed.

* VL02N Delivery change. EG: Edit the delivery to do the following Pack – External customer material number = COO. External delivery number – Waybill number. BOL – Transport tag. Carrier – Header partner – SP (E.G. FXP). Tracking number = Packing Unit

Purchase Orders

* ME22N PO Change
* ME57 Create PO from purchase requisition

ATP

* CO09 Availability overview

Goods Movement

* MIGO Post goods receipt
* MB51 Material document list
* MB01 Goods Movement

Other

* MD04 Material Requirements. Shows material requirements and releases against materials
* SE38 ABAP Editor. Used to modify ABAP programs
* SM01 Transaction list. Lock transactions in the system. Also a good tool to see what transactions are available
* SHDB Transaction recorder (BDC)
* CMOD User exit \ project tool. Coordinates your changes into projects for the purpose of activating all user exits for a particular project. A user exit needs to be modified before it will work
* SE16 Table contents display
* SOST View mails sent externally from SAP
* SU53 Check authorization object
* SQVI Table Quickviewer – Used to created quick client dependent reports
* ST22 ABAP Dump Analysis
* ST01 System trace
* ST11 Display developer trace
* ST05 SQL Trace
* SM21 System log
* ST22 Display short dumps
* SM12 Display locked entries

Programs

* List of ABAP Reports

Idoc

* RBDAPP01 Post inbound Idocs to application documents
* RBDAGAI2 Re-processing of IDocs after ALE input error
* RBDAGAIE Reprocessing of edited IDocs
* RBDMANIN Start error handling for non-posted Idocs
* RSEINB00 Idoc inbound processing by file
* RSEOUT00 Process outbound IDocs

General

* RV80HGEN Report 'RV80HGEN' for including customer-specific routines in the SAP standard source code is not included automatically as an XPRA in the object list of the transport request. See OSS note 0385067. This report needs to be run in target clients once you have implemented a custom requirements definition.
* RSWUWFML Report that interrogates the Workflow inbox, based on certain selections, and then forwards a notification to the respective users that they have email waiting in the SAP system. The auto-forwarding assignment of an email address to a user can be accomplished by the administrator and tx: SO36 or by the user themselves using tx: SO13. Use tx: SOST to view email status’ sent from SAP.
* RHSOBJCH Corrects the following error in workflow customizing:

Transport object PDST

Information Table SOBJ is consistent as regards key tables

***Error*** Table HRP1600 Not an entry in table SOBJ

Information Table SOBJ is consistent as regards PAD tables

See note 134311 (point 2). Note 60801 also recommends the same steps regarding RHSOBJCH.

* RSPO0075 Run report RSPO0075 to activate access method M for device types.

read more...

ABAP - Sample Resume

Career Profile:
IT Professional with three years of experience in programming, database
management, network administration and SAP R/3 ABAP Workbench
Development.

Technical Skills & Applications:
ERP: SAP R/3 Ver. 4.0B
ABAP: Reporting, SAPScript, Dialog Programming, BDC, Logical Databases,
ABAP Query, RFC, ALE-EDI, IDOC, BAPI, jCO
Programming Languages: ABAP Workbench, Visual Basic.
RDBMS: Oracle, or MS SQL Server, or MySQL
Operating Systems: MS Windows 9x, NT, Red Hat Linux

Professional Experience:
Your currently working company and experience
Company Name And Address
Position(XXXXXXXX)
From Period till Today

Career Profile:
IT Professional with three years of experience in programming, database
management, network administration and SAP R/3 ABAP Workbench
Development.

Technical Skills & Applications:
ERP: SAP R/3 Ver. 4.0B
ABAP: Reporting, SAPScript, Dialog Programming, BDC, Logical Databases,
ABAP Query, RFC, ALE-EDI, IDOC, BAPI, jCO
Programming Languages: ABAP Workbench, Visual Basic.
RDBMS: Oracle, or MS SQL Server, or MySQL
Operating Systems: MS Windows 9x, NT, Red Hat Linux

Professional Experience:
Your currently working company and experience
Company Name And Address
Position(XXXXXXXX)
From Period till Today

Your Previous working company and experience
Company Name And Address
Position(XXXXXXXX)
From Period to period


-Worked on projects as an ABAP consultant in an ERP team
-Developed custom ABAP reports(classic and interactive) for management
as needed
-Worked in FI, PP, MM modules
-Designed dialog programs using ABAP workbench tools
-Produced most of the new business forms with SAPscript
-Assisted in migrating legacy data to R/3 using BDC
-Configured ALE Process across two application servers and sent master
data(material master, vendor master) through
Application Link Enabling(ALE)
-Facilitated printing of documents posted in FI module.
-Created a Sales Order form in Visual Basic using BAPI


ABAP Certifications:
Year. Certified ABAP Consultant
Year. Other Skill Certification.


Hope this will help u creating ur resume...

Any Suggestions.... Share it in Comments.

read more...

Resume Preparation Tips

Tip 1 - Use Titles or Headings That Match The Jobs You Want
With employers receiving hundreds of resumes you must make sure that your resume hooks an employer's attention
within a 5-second glance. A great way to do this is to use job titles and skill headings that relate to and match the jobs
you want. For example, compare the headings Roger used in his before resume to the headings used in his after resume.
Before Resume:
Accounting / Recordkeeping
Administrative
Computer Skills After Resume:
Management of A/R and A/P Accounts
Computerized Accounting Applications
Departmental Administration / Recordkeeping
Which set of headings are the strongest for an Accounts Payable / Receivable Manager position?..........

Tip 1 - Use Titles or Headings That Match The Jobs You Want With employers receiving hundreds of resumes you must make sure that your resume hooks an employer's attention within a 5-second glance. A great way to do this is to use job titles and skill headings that relate to and match the jobs you want. For example, compare the headings Roger used in his before resume to the headings used in his after resume.
Before Resume:
Accounting / Recordkeeping
Administrative
Computer Skills After Resume:
Management of A/R and A/P Accounts
Computerized Accounting Applications
Departmental Administration / Recordkeeping
Which set of headings are the strongest for an Accounts Payable / Receivable Manager position?

Even though Roger's title was Accounting Assistant, he actually managed over 1,000 A/R and A/P accounts. Using skill headings that market the true nature of Roger's job duties will generate him more interviews and higher salary offers. For more examples, like this one and the ones discussed below, click on 60 Free Online Resume and Job Search Workshops at ProvenResumes.com.

Tip 2 - Use Design That Grabs Attention
Employers make snap judgments when glancing at your resume. If they see unrelated job titles or skills the likelihood is very high that they will make an immediate assumption that you are not qualified for the job you want. Adding to this problem is the fact that employers don't have the time to read through each of your job descriptions to determine if you have the skills they need.

You Must Do That For Them! The design of your resume must highlight the most important information about your work experience, skills and education. At first glance this information forms the image that employers have of your skills and abilities.

Tip 3 - Create Content That Sells
Resume design should get attention but it's really the content of your resume, the descriptions you include of your skillsand abilities, that determine how many interviews you generate--as well as the level of salary offers you receive.
Compare the before and after statements from Roger's resume shown below:
Before Resume:
Maintained records for accounts receivable and accounts payable accounts.
After Resume:
Managed over 1,000 accounts receivable and payable accounts working directly with the Chief Financial Officer. Which of these examples presents Roger as being more qualified, having higher skills and worth a higher salary? As this example illustrates, our image of Roger is changed and elevated when we read the after example.

Tip 4 - Quantify and Use Power Words
As Roger's after statement demonstrates, using numbers to describe your achievements and responsibilities can greatly expand and elevate your image. Using numbers and quantifying creates vivid images in our mind when we read them, whereas general statements like the before examples are easy to skip over or forget. Typically the more specific you can be in describing your duties the better.

Another strategy that is extremely important in controlling the image that employers develop about you--is to use Power Words or verbs that match the level of position you want. For example, Roger wants to use the experience he's gained to move into a management position. To strengthen his image he should use as many "management oriented" words as possible. Which example below do you think is the strongest?

Typical Verbs:
Gave work assignments to staff of entry level accounting clerks.

Power Words: Directed workflow, supervised and trained accounting staff performing posting to general ledger, accounts receivable and
payable accounts.


Tip 5 - Analyze Ads and Job Descriptions to Identify Key Words
Learning how to analyze the key words that employers provide in help wanted ads and job descriptions is a key element in creating powerful resumes. For example, read the ad Roger found for an Accounts Receivable Manager below and see how many key words, phrases, or skill descriptions that it includes. Accounts Receivable Manager Seeking experienced A/R Manager to oversee accounts, manage billing and collections, train accounting and clerical staff, develop status reports for management and prepare monthly balance sheets. B.A. Degree or A.A. Degree with minimum of 2 years experience required.


Even though this ad is small it contains 12-13 key words or phrases that should be addressed in Roger's resume. Roger can also key words from an ad like this to create headings for his resume such as: Key Word Skill Headings
Management of A/R Accounts
Billing and Collections
Supervision of Accounting and Administrative Staff
Balance Sheet and Management Status Reports


Tip 6 - Identify and Solve Employer's Hidden Needs
In addition to the skills or needs listed in the ad shown above, the employer will have many more needs that Roger should identify and address in his resume and cover letter. For example, this employer will need someone who can deal effectively with other departments, research accounting issues and records to solve problems. To beat today's heavy competition for jobs, it's important that you identify and anticipate the full range of needs each employer faces and show
how you can solve those needs.

Tip 7 - Sell the Benefits of Your Skills
Most resumes provide a list of duties that each applicant has been responsible for--without explaining the benefit of those skills to employers. For example, a secretary's resume might state she can type 80 wpm and is extremely accurate. This statement lacks an explanation of how her typing speed and accuracy benefit an employer's bottom line. The real benefit is that the employee can produce more work and ultimately save the employer money. A better statement for this person's resume would be:
Selling The Benefits of Skills
· Achieved top production volume by maintaining high degree of accuracy with typing speed at 80 wpm.
· Cut labor expense over $6,000 annually by eliminating the need for part-time wordprocessing staff.

Tip 8 - Create An Image That Matches The Salary You Want
As you write your resume, keep in mind the level of job and salary you want. Be sure to create an image that presents you at the appropriate level. For example, language used in a resume for an $8 an hour position is much different than the language used for a $16 an hour position. I recently met Lynn, who had held a Health Insurance Claims Management position making $42,000 per year. She had retrained for the accounting field and hadn't yet gained any "direct accounting experience" although she had prepared monthly accounting reports as a Department Manager.

I was appalled when she shared the resume she had been counseled to create. It began with this statement:
Seeking an entry level position in the accounting field.

Now what pay rate do you think this statement would motivate employers to offer Lynn? A much better statement would
be:
Seek an Accounting position utilizing my experience:

· Managing a department and accounting for up to $250,000 in monthly claims.
My goal is to help people either stay at their current salary level or move up--not go backwards. As you can see, the last
statement greatly elevates Lynn's image and will be much more likely to generate salary offers comparable to her last pay
rate.

Tip 9 - Prioritize the Content of Your Resume
Another big mistake that job seekers make is to list very important data in the lower sections of their job descriptions. As you compile statements for your resume, prioritize them by importance, impressiveness and relevance to the job you want. Remember that a strong statement which uses power words and quantifies will affect every statement under it.
Read the two examples below.
Which one has the most impact? Unprioritized
Maintained records control, filing, office supply purchasing and equipment maintenance.
Managed front office functions to support the President, Vice President and staff of 20 Sales Representatives.

Prioritized
Managed front office functions to support the President, Vice President and staff of 20 Sales Representatives. Maintained records control, filing, office supply purchasing and equipment maintenance.


Tip 10 - Tweak and Target Your Resumes and Cover Letters
You will generate many more interviews by tweaking your resume and cover letter so that they address the specific skills each employer requests. For example, Sally originally wanted a customer service position, then found an ad for a Retail Management opening. How well qualified do the headings in the left hand column present her for the Retail Management
position? Do you think the headings in the right hand column will generate more and better interviews for Retail Management positions? Customer Service
Cash Accountability
Computer Skills Retail Management / Customer Service
Cash Accountability / Supervision of Retail Stations
Retail Accounting Applications
Sally's actual title had been Lead Cashier, even though she managed her own retail cashiering station in addition to 6 other cashiers and stations. Once Sally had created her original resume, it only took about 5 minutes to tweak and relabel her skill descriptions to fit Retail Management positions. This "relabeling" is entirely truthful and is extremely important in landing more interviews because it allows job seekers to apply for, and look qualified for, a wider range of jobs.

read more...