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...