Goods Receipts for PO does not contain any items

When you try to post a GR against any PO it says that the PO does not contain any items.
But when you display the PO it shows the items in it.

There have been several reasons which can be attributable to this problem -

1) This PO is subject to release strategy and since the final release was not made, this PO is considered as 'blocked'.

2) You have been using the confirmation control category where in respect of the last confirmation category key, the GR assignment checkbox is flagged. In this particular case, GR is only be posted if the confirmation is not maintained.

3) Early delivery date ie. the GR date is coming earlier than the PO delivery date.

One other nasty thing might have happened (mostly in MIGO):

You have accidently changed your default movement type from 101 to 102 during your last movement.
You will experienced this in some cases before installing hotpackage which shows the movement type on the MIGO screen.

read more...

Steps for MM Pricing Procedures

Pricing Procedure :

In MM module, pricing procedure is used during RFQ and PO creation. Total value of material based on all addition and subtraction like discount, surcharge, tax, freight, etc. In this we are defining pricing procedure and linking to vendor and purchase department through the virtual schemas.

Following steps for pricing procedure as,
1. Define conditions.
2. Define pricing procedure.
3. Define virtual purchase organization and vendor.
4. Info Record.

Customization for Pricing Procedure :
1. Definition of Conditions :
/NMEK0---condition type…condition types--- definition (define for basic price, net price, discount, surcharge, tax etc.)

2. Defining pricing procedure :
/NMEK0--- calculation schema---calculation schemas—New entries (Define procedure and put the conditions like formula so that final price will be net price / total value as per company requirement)

3. Linking pricing procedure to independent condition types.
/NMEK0---condition type…condition types--- definition for position for defined conditions (Enter the defined pricing procedure in the each independent conditions “Pricing Procedure” box)

4. Defining Schema group for Vendor :
/NMEK0--- calculation schema---schema groups—vendor—New Entries.

5. Defining Schema group for Purchase Organization--- New entries.
/NMEK0--- calculation schema--- schema groups---- purchasing organization--- new entries.

6. Linking Virtual Purchase Organization to actual Purchase Organization.
/NMEK0--- calculation schema--- schema groups----- Assign P.Org. (in actual P.Org, enter virtual P.Org)

7. Linking Pricing procedure to virtual P.Org and virtual vendor :
/NMEK0--- calculation schema--- Determine Schema--- -Standard --- New entries (Enter virtual schema and P.Org. along with pricing procedure)

8. Linking virtual vendor to actual vendor-- /NXK02 then enter schema group vendor in Purchasing Data )

9. Info Records (/NME11)---- click on “Purch. Org. data1” and enter condition types and pricing procedure

What are the steps in pricing determination in MM? Condition, Access sequence and schema.

In the SAP MM Pricing is more important. Just yesterday I have completed the Pricing as I am doing the SAPMM now. I can give some light on this Topic, not 100%. After 2 days definitely some more I can share.

The Basic thing is Condition Technique. In which there are
1. Access Sequence 2. Condition Record 3. Condition Type 4. Condition Table.

A Access Sequence access a Condition Record of a Condition Type in a Condition Table is a Condition Technique.This is a simple logic

Here the Condition Type is very important like PB00, PBXX,RA01 etc.

In the background every Condition Type has its own defition means the purpose of the Condition Type like, is it for Pricing or Percentage, Quntity base, Accrual Feilds etc is to be defined to work this functions.

Normally we use the existing ones without any risk. But some cases, we have to Create a New Condition Types as per the organisation requirement.

The Pricing Schema is useful to minimise condition types while mention prices for Vendor on the basis of Pricing Schema which we defined according to organisation requirement.

The Pricing Schema means the calculations procedure of Condition Type.

Ex. RA01 - Discoount % is caclulated on PB00 - Gross Price means
RA01 is based on PB00 like that we have to define in the Pricing Schema
which makes easy to use in realtime.
Here PB00 has the Access Sequence - 0002.
But RA01 does not have the Access Sequence.Why because it is a dependent on PB00. But both are Condition Types.

In the system, by default some standard Scheme will be there at Vendor Schema Group in the Vendor Master Screen means the standard one is assigned which is very lengthy which may fullfil our requirement. But some cases which may not fullfil our requirement, in such we have to define.

For the configuration, I may not able to explain properly through here but will give some Idea.

Configuration: SPRO-IMG-Material Management- Purchasing- Conditions-Define Price Deternmination Process
1. Define Access Sequence
2. Define Condition Type
3. Defince Calculation Schema:- Here you have to define the Schema
Define Schema group
1. Define Schema Group vendor
2. Define Pricing Schema group
3. Schema group for Purchase Organisation
4. Assign Schema group to Purchase Organisation

Define Schema determination
1.define calculation schema for Standard purchase organisation

After completion of the Schema Group, we have to assign it to Vendors.
Then whenever we use any transaction with this Vendor, the concerned Schema will work as configured by us.

I think this will help you. Actually the Pricing is a vast. Becuase each Condition have its own importance and each Access Sequence have its own importance. So you need not bother about this. First you learn how to define the Calculation Schema through the above.

Here we can create many Calculation Schemas which can assign one schema to Local vendors
another schema to out side vendor one more schema to foreign vendors like that we can classify.

Definitely it will help you something. Because I have to do R & D on this Topic. Due to lack of time I am not able to do the Practice Properly as I am doing non-related SAPMM job.

read more...

Language Error when creating Purchase Order

This happens when the language in Material Master (MM02 - Purchase Order
Text) and Vendor Master (XD02 - Address - Communication - Language) does not matched.

In the Purchase Order, you can see the language in PO Header - Communications data - Language.

If the Purchase Order have been saved before you change the Vendor Master Language, the PO need to be closed as the language in the PO Header cannot be changed.

This is the SAP Language Error that will appear when creating PO with language mis-matched:

No short text maintained in language CS (please re-maintain material ABCDEFGHIJK)
Message no. ME 095

Diagnosis
No material short text (short description) has been maintained in language CS.

System Response
No short text can be adopted from the material master record.

Procedure
If a material is to be procured from a vendor in a different language, the material short text must first be maintained in this language.

Maintain the short texts in the material master record in those languages in which procurement is normally carried out. In this case, you should at least maintain the short text in language CS.

read more...

Procedure to Define Both Currency USD and EURO

We are purchasing export item, export item currency is USD. Some time same vendor send item with different currency like EURO. I'm facing problem when we pay to vendor.
In Vendor Master Currency is defined as USD. I can pay in USD.
If I want to pay in EURO, again I have to go vendor master and change USD to Euro vice versa.
Everytime I am changing.
Is there any procedure to define both currency USD and EURO.
According to situation I can select currency.
My local currency is different i.e SAR (Saudi Riyal).

This is a common problem in almost all factories in our group. To simply the matters let me explain the method we use with some numbers.

1) Lets say we raise a PO as follows:
2 items @ $10 = $ 20

2) GRN is raised as per PO

3) Invoice comes from the vendor as
2 items @ Euro 0.80 = Euro 1.60

4) What we do is that we check with our purchasing people whether the Euro to $ convertion from the supplier is beneficial to us, if not it is within our tolerance levels.
Then we process the payment for $ but mention the correct EURO amount in narration. Bank instructions goes for EURO and there will be a Exchange diff entry to the bank rec at the month end.

5) As far as I know you can't maintain multi currency in the vendor master.

6) Another effective method we are adopting is to have two vendor accounts for different currencies.

read more...

What are the Types of Inforecords?

You can create purchasing info records for different procurement types as follows:

Standard, Subcontracting, Pipeline, Consignment You use this component if you wish to store information on a vendor and a material as master data at purchasing organization or plant level.

Standard

A standard info record contains information for standard purchase orders.
The info records can be created for materials and services with and without master records.

Subcontracting

A subcontractor info record contains ordering information for subcontract orders.
For example, if you subcontract the assembly of a component, the subcontractor info record would include the vendor's
(subcontractor's) price for assembling the component.

Pipeline

A pipeline info record contains information on a vendor's commodity that is supplied through a pipeline or pipes
(oil or water) or by similar means (electricity through the mains).
The info record contains the vendor's price for the consumption of such commodities by the buyer
("pipeline withdrawals"). You can store withdrawal/usage prices for different validity periods.

Consignment

A consignment info record contains information on a material that vendors keep available at their own cost on the orderer's premises.
The info record contains the vendor's price for withdrawals by the orderer from consignment stock.
As in the case of the pipeline info record, you can store prices for different validity periods.

read more...

Vendor Evaluation for Purchasing

When we create info & Maintain Quotation, by quota we are determining the source. Also in Vendor Evaluation, we are evaluationg vendor. When we are creating PO, from where the vendor will come from? Is it from Quota or Vendor Evaluation?

You define source list requirements at plant level. If a source list requirement exists, you must maintain the source list for each material before you can order it.

The source list serves:

To define a source of supply as "fixed". Such sources count as preferred sources over a certain period of time. For example, the fixed vendor XXXX for material 100XX is ASA Company for the first quarter and BSB Co. for the second quarter of the year.

Select the plants for which you wish to specify a source list requirement

You use the source list to determine the valid source of supply at a certain point in time.
The source list contains all the sources of supply defined for a material and the periods during which procurement from these sources is possible

Following T/Code activities in Material Management module.

Maintain source list - ME01
Display source list - ME03
Display changes to source list - ME04
Analyze source list - ME06
Reorganize source list - ME07
Generate source list - ME05
Display source list for material- ME0M

you make the system settings that are necessary for purchasing operations carried out using source lists.

Source list requirement for materials, It may be necessary to include possible vendors of a material in the source list before the material can be ordered.

The Source list requirement field in the purchasing data of the material master record indicates whether a source list requirement exists for a material.

You can define the Source list requirement at plant level in IMG. Logistics -->Materials management --> Purchasing --> Source list.

read more...

What is : Bex? | Variables? | AWB? | BIW | Flat file | Extractor?

* What is Bex?

* Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.


* What are variables?

* Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.


* What is AWB. What is its purpose?

* AWB stands for Administrtor WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.


* What is the significance of ODS in BIW?

* An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.


* What are the different types of source system?

* SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.


* What is Extractor?

* Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.

read more...

SAP Interview Questions | Difference between OLAP and Data Mining | Extended Star Schema | Drawbacks of SAP

* How can an ERP such as SAP help a business owner learn more about how business operates?

* In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates. Using SAP as a tool to learn about ERP systems will require that the people understand the business processes and how they integrate.


* What is the difference between OLAP and Data Mining?

* OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting.


* What is “Extended Star Schema" and how did it emerge?

* The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.


* Define Meta data, Master data and Transaction data?

* Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data. Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies. Transaction data: Data relating to the day-to-day transactions is the Transaction data.


* Name some drawbacks of SAP?

* Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.

read more...

Open vs Native SQL | Writing BDC | Datasets | Interview Questions

* What should be the approach for writing a BDC program? - Convert the legacy system data to a flat file and convert flat file into internal table. Transfer the flat file into sap system called “sap data transfer”. Call transaction(Write the program explicitly) or create sessions (sessions are created and processed ,if success data will transfer).

* Explain open SQL vs native SQL? - ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system used, SAP has generated its own set of SQL statements known as Open SQL.

* What are datasets? - The sequential files (processed on application server) are called datasets. They are used for file handling in SAP.

* What are internal tables check table, value table, and transparent table? - Internal table: It is a standard data type object, which exists only during the runtime of the program. Check table: Check table will be at field level checking. Value table: Value table will be at domain level checking ex: scarr table is check table for carrid. Transparent table: - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

* What are the major benefits of reporting with BW over R/3? Would it be sufficient just to Web-enable R/3 Reports? - Performance — Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end — now imagine that occurring even more frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.

read more...

What is : IDES | WF | SAP R3 | Database \ Application Servers

* Can BW run without a SAP R/3 implementation? - Certainly. You can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data. Here you simply need to map the transfer structures associated with BW data sources (InfoCubes, ODS tables) to the inbound data files or use 3rd part tool to connect your flat files and other data sources and load data in BW. Several third party ETL products such as Acta, Infomatica, DataStage and others will have been certified to load data in BW.

* What is IDES? - International Demonstration and Education System. A sample application provided for faster learning and implementation.

* What is WF and its importance? - Business Work Flow: Tool for automatic control and execution of cross-application processes. This involves coordinating the persons involved, the work steps required, the data, which needs to be processed (business objects). The main advantage is reduction in throughput times and the costs involved in managing business processes. Transparency and quality are enhanced by its use.

* What is SAP R/3? - A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.

* What are presentation, application and database servers in SAP R/3? - The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.

read more...

SAP Interview Questions | What is ERP? | What is SAP? | Business Content | Why SAP?

* What is ERP? - ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.

* Different types of ERP? - SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the most of the companies implemented or trying to implement SAP because of number of advantages aver other ERP packages.

* What is SAP? - SAP is the name of the company founded in 1972 under the German name (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software package.

* Explain the concept of “Business Content” in SAP Business Information Warehouse? - Business Content is a pre-configured set of role and task-relevant information models based on consistent Metadata in the SAP Business Information Warehouse. Business Content provides selected roles within a company with the information they need to carry out their tasks. These information models essentially contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update rules and extractors for SAP R/3, mySAP.com Business Applications and other selected applications.

* Why do you usually choose to implement SAP? - There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.

read more...

Material Types in Material Master

The following list shows you the material types contained, for example, in the standard SAP R/3 System, and what their different roles are:

DIEN (services)
Services are procured externally and cannot be stored. A material master record of this material type can always contain purchasing data.

FERT (finished products)
Finished products are produced by the company itself. Since they cannot be ordered by Purchasing, a material master record of this material type does not contain purchasing data.

FHMI (production resources/tools)
Production resources/tools are procured externally and used in the manufacture of products. A material master record of this material type can contain purchasing data, but no sales data. It is managed on a quantity basis. Examples of production resources/tools are apparatus, equipment, and measuring and testing devices.

HALB (semifinished products)
Semifinished products can be procured externally (sub-contracting) as well as manufactured in-house. They are then processed by the company. A material master record of this material type can contain both purchasing and work scheduling data.

HAWA (trading goods)
Trading goods are always procured externally and then sold. A material master record of this material type can contain purchasing and sales data.

HIBE (operating supplies)
Operating supplies are procured externally and required for the manufacture of other products. A material master record of this material type can contain purchasing data but no sales data.

NLAG (non-stock material)
Non-stock material is material that is not held in stock because it is consumed immediately. (Office supplies such as stationary. You need to create purchase order and accounting document for payment but the stock balance is always zero as it is issued out immediately to the various department.)

ROH (raw materials)
Raw materials are always procured externally and then processed. Since raw materials cannot be sold, a material master record of this material type contains no sales data.

UNBW (non-valuated materials)
Non-valuated materials are managed on a quantity basis, but not by value.

VERP (packaging materials)
Packaging materials are used to transport goods and come with the goods free of charge. A material master record of this material type is managed both on a quantity basis and by value.

WETT (competitive products)
Competitive products have their own material master records created from the Basic Data view. The competitor's number, which is stored in the material master record, assigns the material to a particular competitor.

read more...

List of SAP MM Transaction codes

Transaction for MM module start with M.

IH09 - Display Material
MM01 - Create Material
MM02 - Change Material
MM03 - Display Material
MM50 - List Extendable Materials
MMBE - Stock Overview
MMI1 - Create Operating Supplies
MMN1 - Create Non-Stock Material
MMS1 - Create Service
MMU1 - Create Non-Valuated Material

ME51N - Create Purchase Requisition
ME52N - Change Purchase Requisition
ME53N - Display Purchase Requisition
ME5A - Purchase Requisitions: List Display
ME5J - Purchase Requisitions for Project
ME5K - Requisitions by Account Assignment
MELB - Purch. Transactions by Tracking No.

ME56 - Assign Source to Purch. Requisition
ME57 - Assign and Process Requisitions
ME58 - Ordering: Assigned Requisitions
ME59 - Automatic Generation of POs

ME54 - Release Purchase Requisition
ME55 - Collective Release of Purchase Reqs.
ME5F - Release Reminder: Purch. Requisition

MB21 - Create Reservation
MB22 - Change Reservation
MB23 - Display Reservation
MB24 - Reservations by Material
MB25 - Reservations by Account Assignment

MB1C - Other Goods Receipts
MB90 - Output Processing for Mat. Documents

MB21 - Create Reservation
MB22 - Change Reservation
MB23 - Display Reservation
MB24 - Reservations by Material
MB25 - Reservations by Account Assignment

MBRL - Return Delivery per Mat. Document

MB1C - Other Goods Receipts
MB90 - Output Processing for Mat. Documents

MB1B - Transfer Posting

MIBC - ABC Analysis for Cycle Counting

MI01 - Create Physical Inventory Document
MI02 - Change Physical Inventory Document
MI03 - Display Physical Inventory Document
MI31 - Batch Input: Create Phys. Inv. Doc.
MI32 - Batch Input: Block Material
MI33 - Batch Input: Freeze Book Inv.Balance
MICN - Btch Inpt:Ph.Inv.Docs.for Cycle Ctng
MIK1 - Batch Input: Ph.Inv.Doc.Vendor Cons.
MIQ1 - Batch Input: PhInvDoc. Project Stock

MI01 - Create Physical Inventory Document
MI02 - Change Physical Inventory Document
MI03 - Display Physical Inventory Document
MI31 - Batch Input: Create Phys. Inv. Doc.
MI32 - Batch Input: Block Material
MI33 - Batch Input: Freeze Book Inv.Balance
MICN - Btch Inpt:Ph.Inv.Docs.for Cycle Ctng
MIK1 - Batch Input: Ph.Inv.Doc.Vendor Cons.
MIQ1 - Batch Input: PhInvDoc. Project Stock

MI01 - Create Physical Inventory Document
MI02 - Change Physical Inventory Document
MI03 - Display Physical Inventory Document
MI31 - Batch Input: Create Phys. Inv. Doc.
MI32 - Batch Input: Block Material
MI33 - Batch Input: Freeze Book Inv.Balance
MICN - Btch Inpt:Ph.Inv.Docs.for Cycle Ctng
MIK1 - Batch Input: Ph.Inv.Doc.Vendor Cons.
MIQ1 - Batch Input: PhInvDoc. Project Stock

MI21 - Print physical inventory document

MI04 - Enter Inventory Count with Document
MI05 - Change Inventory Count
MI06 - Display Inventory Count
MI09 - Enter Inventory Count w/o Document
MI34 - Batch Input: Enter Count
MI35 - Batch Input: Post Zero Stock Balance
MI38 - Batch Input: Count and Differences
MI39 - Batch Input: Document and Count
MI40 - Batch Input: Doc., Count and Diff.

MI08 - Create List of Differences with Doc.
MI10 - Create List of Differences w/o Doc.
MI20 - Print List of Differences

MI11 - Physical Inventory Document Recount

MI07 - Process List of Differences
MI37 - Batch Input: Post Differences

CT01 - Create Characteristic
CT02 - Change Characteristic
CT03 - Display Characteristic

CL01 - Create Class
CL02 - Classes
CL03 - Display Class
CL04 - Delete Class
CL2B - Class Types

read more...

Common tables used by SAP MM | SAP R/3 | Material Management

Below are few important Common Tables used in Materials Management Modules:

EINA Purchasing Info Record- General Data
EINE Purchasing Info Record- Purchasing Organization Data
MAKT Material Descriptions
MARA General Material Data
MARC Plant Data for Material
MARD Storage Location Data for Material
MAST Material to BOM Link
MBEW Material Valuation
MKPF Header- Material Document
MSEG Document Segment- Material
MVER Material Consumption
MVKE Sales Data for materials
RKPF Document Header- Reservation
T023 Mat. groups
T024 Purchasing Groups
T156 Movement Type
T157H Help Texts for Movement Types
MOFF Lists what views have not been created
A501 Plant/Material
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EKAB Release Documentation
EKBE History per Purchasing Document
EKET Scheduling Agreement Schedule Lines
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKPO Purchasing Document Item
IKPF Header- Physical Inventory Document
ISEG Physical Inventory Document Items
LFA1 Vendor Master (General section)
LFB1 Vendor Master (Company Code)
NRIV Number range intervals
RESB Reservation/dependent requirements
T161T Texts for Purchasing Document Types

read more...

Material Management Table | SAP MM

Following are the list of Important MM tables. Please check if its useful.

Inventory Management:
|-------------------------+--------+-----------------------------------------|
| | Table | Description |
|-------------------------+--------+-----------------------------------------|
| Material | MSEG | Material document / transaction details |
| Document/Movements | MKPF | Material document header information |
|-------------------------+--------+-----------------------------------------|
| Material Stock Balances | MARD | Material stock |
| | MBEW | Material stock with valuation |
|-------------------------+--------+-----------------------------------------|
| Sales Order Stock | MSKA | Stock balance with associated sales |
| | | order data |
|-------------------------+--------+-----------------------------------------|
| Stock Transport | EKUB | Index for Stock Transport Orders for |
| | MDUB | Material |
| | | Reading View of Stock Transport Ord. for|
| | | Release Ord. |
|-------------------------+--------+-----------------------------------------|
| Special Stocks | MKOL | Consignment, material provided to |
| | | vendor, etc. |
|-------------------------+--------+-----------------------------------------|

Material Master Data:
|-------------------------+---------+--------------------------------------|
| |Table | Description |
|-------------------------+---------+--------------------------------------|
| Materials | MARA | General Data, material type, group, |
| | | configurable & batch ind. |
| | MAKT | Short Texts, descriptions |
| | MARM | Conversion Factors |
| | MVKE | Sales Org, distribution channel |
| | MLAN | Sales data, tax indicator, tax |
| | MARC | classification |
| | MBEW | Plant Planning Data |
| | MLGN | Valuation Data |
| | MLGT | Warehouse Management Inventory Data |
| | MVER | Warehouse Management Storage Type |
| | MAPR | Data |
| | MARD | Consumption Data |
| | MCHA | Pointer for Forecast Data |
| | MCHB | Storage location data with stock |
| | | balances |
| | | Batches |
| | | Batch Stocks |
|-------------------------+---------+--------------------------------------|

read more...

Planning, Execution, And Collaboration Across The Responsive Supply Network

You face enormous pressure to reduce costs while increasing innovation and improving customer service and responsiveness. SAP Supply Chain Management (SAP SCM) enables collaboration, planning, execution, and coordination of the entire supply network, empowering you to adapt your supply chain processes to an ever-changing competitive environment.

SAP SCM is part of the SAP Business Suite, which gives organizations the unique ability to perform their essential business processes with modular software that is designed to work with other SAP and non-SAP software. Organizations and departments in all sectors can deploy SAP Business Suite software to address specific business challenges on their own timelines and without costly upgrades.

SAP SCM can help transform a linear, sequential supply chain into a responsive supply network – in which communities of customer-centric, demand-driven companies share knowledge, intelligently adapt to changing market conditions, and proactively respond to shorter, less predictable life cycles. SAP SCM provides broad functionality for enabling responsive supply networks and integrates seamlessly with both SAP and non-SAP software. The application:

* Delivers planning and execution functions that are integrated by design.

* Supports best practices and provides preconfigured software for enabling collaborative business, accelerating implementation, and reducing costs.

* Is recognized by key industry analysts as the market-leading SCM application.

read more...

Supply Chain Planning and Collaboration

Supply Chain Planning and Collaboration

SAP SCM includes features and functions to support collaborative supply chain planning processes, including strategic, tactical, and operational planning as well as service parts planning.
Strategic, Tactical, and Operational Planning

With SAP SCM, you can optimize a full range of planning activities, including:

* Demand planning and forecasting – Forecast and plan anticipated demand for products or product characteristics. Use state-of-the-art forecasting algorithms for product life-cycle planning and trade promotion planning.

* Safety stock planning – Assign optimal safety stock and target stock levels in all inventories in the supply network. Meet your desired customer service levels while maintaining a minimum amount of safety stock.

* Supply network planning – Integrate purchasing, manufacturing, distribution, and transportation plans into an overall supply picture – so you can simulate and implement comprehensive tactical planning and sourcing decisions based on a single, globally consistent model. This can involve heuristics and capacity planning, optimization, and multilevel supply and demand matching.

* Distribution planning – Determine the best short-term strategy to allocate available supply to meet demand and to replenish stocking locations. To achieve this, planners can determine which demands can be fulfilled by existing supply elements.

* Supply network collaboration – Work with partners across your supply network. Using collaboration features that improve visibility into supply and demand, you and your partners can reduce inventory buffers, increase the velocity of raw materials and finished goods through the pipeline, improve customer service, and increase revenues.


Service Parts Planning

With SAP SCM, you can also handle service parts planning activities, including:

* Parts demand planning – Improve the accuracy of forecasts through better modeling of demand quantities, events, and their respective deviations. You can select sophisticated forecast models and optimize model parameters to improve forecasting for slow-moving parts or for parts with irregular demand patterns. Through aggregated forecast-parameter profile maintenance, you can make data maintenance more efficient.

* Parts inventory planning – Reduce inventory levels and achieve retail service levels by providing more precise demand modeling. You can distribute inventory optimally within the multi-echelon supply chain to ensure high service levels while keeping inventory levels at a minimum.

* Parts supply planning – Reduce inventory in the supply chain by improving supplier alignment, increasing automation, and developing accurate supply plans. You can also reduce operational cost through efficient purchasing practices.

* Parts distribution planning – Set up stock transfers for parts within a service parts network to reduce stock-out situations and operational costs.

* Parts monitoring – Work with suppliers and customers to exchange information and handle alerts collaboratively.

read more...

Features & Functions of SAP Supply Chain Management

SAP SCM delivers a complete set of features and functions for building adaptive supply chain networks.

The application enables:

* Supply chain planning and collaboration – With SAP SCM, you can model your existing supply chain; set goals; and forecast, optimize, and schedule time, materials, and other resources. Supply chain planning functionality enables you to maximize return on assets and ensure a profitable match of supply and demand.

* Supply chain execution – SAP SCM enables you to carry out supply chain planning and generate high efficiency at the lowest possible cost. You can sense and respond to demand through an adaptive supply chain network in which distribution, transportation, and logistics are integrated into real-time planning processes.

* Supply chain visibility design and analytics – SAP SCM gives you networkwide visibility across your extended supply chain to perform strategic as well as day-to-day planning. The application also enables collaboration and analytics, so you can monitor and analyze the performance of your extended supply chain using predefined key performance indicators (KPIs).

read more...

Business Benefits of SAP Supply Chain Management

SAP SCM can help you transform a traditional linear supply chain into an adaptive network with the following benefits:

* Faster response to changes in supply and demand – With increased visibility into the supply chain and adaptive supply chain networks, you can be more responsive. You can sense and respond quickly to changes and quickly capitalize on new opportunities.

* Increased customer satisfaction – By offering a common information framework that supports communication and collaboration, SAP SCM enables you to better adapt to and meet customer demands.

* Compliance with regulatory requirements – You can track and monitor compliance in areas such as environment, health, and safety.

* Improved cash flow – Information transparency and real-time business intelligence can lead to shorter cash-to-cash cycle times. Reduced inventory levels and increased inventory turns across the network can lower overall costs.

* Higher margins – With SAP SCM, you can lower operational expenses with more timely planning for procurement, manufacturing, and transportation. Better order, product, and execution tracking can lead to improvements in performance and quality – and lower costs. You can also improve margins through better coordination with business partners.

* Greater synchronization with business priorities – Tight connections with trading partners keep your supply chain aligned with current business strategies and priorities, improving your organization's overall performance and achievement of goals.

read more...

Supply Chain Visibility Design and Analytics

SAP SCM supports supply chain visibility design and analytics with features and functions that enable supply chain design and analytics processes, including:

* Strategic supply chain design – With visibility across the entire supply chain network, planners and key decision makers can perform strategic and tactical business planning. They can test scenarios to determine how the supply chain network can address changes in the market, the business, or customer demand.

* Supply chain analytics – SAP SCM enables you to define, select, and monitor KPIs to get an integrated, comprehensive view of performance across the supply chain. You can also use predefined KPIs based on the supply chain operations reference (SCOR) model to monitor sourcing, planning, production, distribution, and returns processes.

read more...

Supply Chain Visibility Design and Analytics

SAP SCM supports supply chain visibility design and analytics with features and functions that enable supply chain design and analytics processes, including:

* Strategic supply chain design – With visibility across the entire supply chain network, planners and key decision makers can perform strategic and tactical business planning. They can test scenarios to determine how the supply chain network can address changes in the market, the business, or customer demand.

* Supply chain analytics – SAP SCM enables you to define, select, and monitor KPIs to get an integrated, comprehensive view of performance across the supply chain. You can also use predefined KPIs based on the supply chain operations reference (SCOR) model to monitor sourcing, planning, production, distribution, and returns processes.

read more...

Components & Tools of NETWEAVER

SAP NetWeaver includes a comprehensive set of components and tools.

Components

* SAP NetWeaver Application Server – Supports platform-independent Web services, business applications, and standards-based development, enabling you to leverage existing technology assets for Web-services-oriented solutions
* SAP NetWeaver Business Warehouse – Enables you to integrate data from across the enterprise and transform it into practical, timely business information to drive sound decision making
* SAP NetWeaver Business Process Management – Provides tools to help you model, execute, and monitor business processes based on a single, consistent process model
* SAP NetWeaver Business Rules Management – Allows you to create and maintain business rules to ensure that processes conform to business policies.
* SAP NetWeaver Process Integration – Delivers SOA-based technology that supports process-centric integration across the extended value chain
* SAP NetWeaver Master Data Management – Ensures cross-system data consistency and helps integrate business processes across the extended value chain
* SAP NetWeaver Mobile – Provides a "future-proof" mobile runtime environment based on open and flexible technology standards and a powerful development environment for building integrated mobile solutions with native or browser-based user interfaces
* SAP NetWeaver Portal – Unifies critical information and applications to give users role-based views that span the enterprise, enabling you to take full advantage of your information resources
* SAP Auto-ID Infrastructure – Gives you all the capabilities you need to integrate all automated sensing devices – including RFID readers and printers, Bluetooth devices, embedded systems, and bar-code devices
* SAP NetWeaver Identity Management – Addresses access and provisioning issues facing a typical enterprise, creates a new opportunity for integrating business processes, and helps you to integrate systems in a heterogeneous IT environment
* SAP NetWeaver Information Lifecycle Management – Allows you to archive data in a readily accessible format according to regulatory retention rules that you define

Tools

* Adaptive Computing Controller – Provides a central point of control for assigning computing resources and optimizing their use
* SAP NetWeaver Composition Environment – Provides a robust environment for design, deployment, and running of composite applications that comply with a service-oriented architecture
* SAP NetWeaver Developer Studio – Offers a convenient user interface and rich functionality for developing J2EE applications
* SAP NetWeaver Visual Composer – Simplifies the creation of portal content and analytics applications, enabling business analysts to build or customize applications using a visual user interface rather than manual coding
* SAP Solution Manager – Facilitates technical support for distributed systems with functionality that covers all key aspects of solution deployment, operation, and continuous improvement

Applications

* SAP NetWeaver Enterprise Search – Provides a simple and secure gateway to enterprise objects and transactions
* Duet – Enables seamless access to SAP business processes and data via Microsoft Office
* Alloy – Simplifies interaction with people, processes, and information by providing intuitive access to SAP software and information via the familiar IBM Lotus Notes
* SAP Central Process Scheduling application by Redwood – Helps companies manage, monitor, and execute business-critical processes from a central location by delivering adaptive, real-time, event-driven job scheduling and process-automation capabilities across distributed and heterogeneous platforms. Designed to integrate process automation for non-SAP and SAP applications, such as SAP Solution Manager, SAP Central Process Scheduling by Redwood provides a central point of control for all processing.
* SAP Enterprise Modeling applications by IDS Scheer – Deliver Web-based components that support the process life cycle for business process design, analysis, optimization, and implementation

read more...

SAP NetWeaver Process Integration

Over 3,000 organizations are using the SAP NetWeaver® Process Integra-tion (SAP NetWeaver PI) offering as their enterprise-class, service-oriented architecture (SOA) middleware to per-form application-to-application and business-to-business (B2B) integration and accelerate composite application development. SAP NetWeaver PI includes:

* Enterprise Services Repository(ES Repository) to build, model, and manage Web services.

* A high-volume enterprise services bus that supports distributed integration.

* Principal propagation for trusted communication and for helping ensure compliance.

* B2B integration functionalities.

* Support for predefined integration scenarios and adapters to jump-start integration projects.

read more...

Unique Business and IT Benefits with NETWEAVER

Business benefits

SAP NetWeaver is the open integration and application platform that aligns people, information, and processes. Business benefits include:

* Flexible business strategies – With SAP NetWeaver, you have the flexibility, visibility, and control to effectively execute, monitor, and refine corporate strategies.
* Innovative business processes – The platform powers innovative, industry-specific software and allows you to recompose existing systems to support innovative processes.
* Superior business value – SAP NetWeaver provides a business-focused infrastructure that supports continuous improvement of processes. It minimizes the risk and cost of introducing new processes, because existing systems remain unchanged while you leverage them for end-to-end enterprise processes.
* Improved business performance – SAP NetWeaver helps you aggregate and analyze information across the organization, so you can gain the insight needed to make the right changes.
* Unmatched user experience – Solutions built with SAP NetWeaver provide an efficient user experience through a role-based portal interface. With SAP NetWeaver, you can extend business processes to all employees, suppliers, and customers.

Unique IT Benefits

SAP NetWeaver also delivers a broad range of IT benefits, including:

* Sustainable cost structure – SAP NetWeaver reduces total cost of ownership across the IT landscape. It enables you to leverage your existing IT investments, including SAP and non-SAP systems. Flexibility reduces the cost of change, while integration knowledge reduces the need for consulting services.
* Improved development – With SAP NetWeaver, you can compose new business processes on top of existing systems by using an enterprise service-oriented architecture based on Web services, Java, and other industry standards.
* Reduced TCO across the entire IT landscape – SAP NetWeaver technology components are integrated in a single platform and come preconfigured with business content, which reduces complexity and supports IT standardization and consolidation. The components also integrate readily with SAP applications, which reduces the need for custom integration.
* Easy development of extensible best practices – SAP NetWeaver supports communication, knowledge management, and collaboration across existing systems. You can take advantage of existing skills to improve current practices or develop new functionality.

read more...

SAP ABAP : Blocking Searchhelp and Create New Searchhelp

How to block a pre-existing search help and create new search help which contains the old ones data and the new one which entered now.

Look at this statement .

parameters :p_pernr like pa0001-pernr MATCHCODE OBJECT new_search.

If you define like this previous search help is gone.

You have to create new search help into the dictionary .

or else .



parameters :p_pernr like pa0001-pernr

define like this
use this event

AT Selection-screen on p_pernr.

under this event call this function module and pass required data .

F4IF_FIELD_VALUE_REQUEST
* F4 help also returning the value to be displayed in internal table

F4IF_INT_TABLE_VALUE_REQUEST

read more...

SAP ABAP : Attach a Search Help to the Screen Field

I have a requirement to attach a search help to the screen field. When I click on the drop-down list, it should automatically pick the company code that is already displayed on the screen and show the results.

It dosent make any sense for search help to wait for user to input the same company code which is already displayed.

Use this functionality to get help.

FORM HELP_CHECK.


*-- Set up fields to retrieve data

ltab_fields-tabname = 'ZFI_PMNTADV'.
ltab_fields-fieldname = 'CHECT'.
ltab_fields-selectflag = 'X'.
APPEND ltab_fields.

ltab_fields-tabname = 'ZFI_PMNTADV'.
ltab_fields-fieldname = 'PMNT_ADV'.
ltab_fields-selectflag = 'X'.
APPEND ltab_fields.

SORT ltab_fields.
DELETE ADJACENT DUPLICATES FROM ltab_fields.

*-- Fill values
SELECT chect
INTO TABLE ltab_values
FROM zfi_pmntadv
WHERE pmnt_adv NE space.
SORT ltab_values.
DELETE ADJACENT DUPLICATES FROM ltab_values.

CALL FUNCTION 'HELP_VALUES_GET_WITH_TABLE'
EXPORTING
fieldname = 'chect'
tabname = 'zfi_pmntadv'
title_in_values_list = 'Select a value'
IMPORTING
select_value = so_chect
TABLES
fields = ltab_fields
valuetab = ltab_values
EXCEPTIONS
field_not_in_ddic = 01
more_then_one_selectfield = 02
no_selectfield = 03.


ENDFORM. "fiscal_year

read more...

Splash Screen in ABAP

I created 2 MODAL screens 0806 & 2009
0806 was for start of job spash & 20009 was an exit SPLASH
Used this effectively in a lrge DOI Excel download program..

2 JPG files with a nice Indian Welcome & fancy Bengali Text!
Each Modal scren had 2 Containers
CUSTOM_1 shaped for Picture control
CUSTOM_2 for CL_GUI_TIMER control



* Create 2 MODAL screens 0806 and 2009
* 1 CUSTOM_1 shaped to hold JPG
* and 1 CUSTOM_2 to hold TIMER


REPORT zpp_r012 LINE-SIZE 160
LINE-COUNT 72
MESSAGE-ID zpp01.

DATA: container1 TYPE REF TO cl_gui_custom_container,
container2 TYPE REF TO cl_gui_custom_container,
picture TYPE REF TO cl_gui_picture.

DATA: graphic_url(255),
g_result TYPE i,
g_linesz TYPE i,
g_filesz TYPE i,
g_name(100).

TYPES: t_graphic_line(256) TYPE x.

DATA: graphic_line TYPE t_graphic_line,
graphic_table TYPE TABLE OF t_graphic_line.


*---------------------------------------------------------------------*
* CLASS lcl_event_handler DEFINITION
*---------------------------------------------------------------------*
CLASS lcl_event_handler DEFINITION.

PUBLIC SECTION.
CLASS-METHODS: on_finished FOR EVENT finished OF cl_gui_timer.
ENDCLASS. "lcl_event_handler DEFINITION

*---------------------------------------------------------------------*
* CLASS lcl_event_handler IMPLEMENTATION
*---------------------------------------------------------------------*
CLASS lcl_event_handler IMPLEMENTATION.
METHOD on_finished.
IF sy-dynnr = 2009.
LEAVE PROGRAM.
ELSE.
PERFORM f_excel_job.
ENDIF.
ENDMETHOD. "on_finished
ENDCLASS. "lcl_event_handler IMPLEMENTATION

DATA timer TYPE REF TO cl_gui_timer.
DATA event_handler TYPE REF TO lcl_event_handler.
DATA timeout TYPE i VALUE '3'.

*&---------------------------------------------------------------------*
* SELECTION-SCREEN DESIGN
*
*&---------------------------------------------------------------------*
SELECTION-SCREEN: BEGIN OF BLOCK b2sels WITH FRAME TITLE text-002.
PARAMETERS: pwerks LIKE mseg-werks OBLIGATORY, "THIS Plant
pbudat LIKE mkpf-budat OBLIGATORY. "THIS Date
SELECTION-SCREEN: END OF BLOCK b2sels.

*&---------------------------------------------------------------------*
* INITIALIZATION EVENT
*
*&---------------------------------------------------------------------*
INITIALIZATION.

*&---------------------------------------------------------------------*
* AT SELECTION-SCREEN EVENT
*
*&---------------------------------------------------------------------*
**Use this EVENT to validate SELECTION-SCREEN
AT SELECTION-SCREEN.


*&---------------------------------------------------------------------*
* START-OF-SELECTION EVENT
*
*&---------------------------------------------------------------------*
START-OF-SELECTION.

CALL SCREEN 0806 STARTING AT 30 4.

*&---------------------------------------------------------------------*
*& Form f_excel_job
*&---------------------------------------------------------------------*
FORM f_excel_job.

* LOTS of Code

CALL SCREEN 2009 STARTING AT 30 4.

ENDFORM. "f_excel_job

** LOTS of CODE

*&---------------------------------------------------------------------*
*& Form getpicurl
*&---------------------------------------------------------------------*
FORM getpicurl.

OPEN DATASET g_name FOR INPUT IN BINARY MODE.

REFRESH graphic_table.
CLEAR g_filesz.

DO.
CLEAR graphic_line.
READ DATASET g_name INTO graphic_line ACTUAL LENGTH g_linesz.

ADD g_linesz TO g_filesz.

APPEND graphic_line TO graphic_table.
IF sy-subrc <> 0.
EXIT.
ENDIF.

ENDDO.

CLOSE DATASET g_name.

CLEAR graphic_url.

CALL FUNCTION 'DP_CREATE_URL'
EXPORTING
type = 'IMAGE'
subtype = 'GIF'
TABLES
data = graphic_table
CHANGING
url = graphic_url
EXCEPTIONS
dp_invalid_parameter = 1
dp_error_put_table = 2
dp_error_general = 3
OTHERS = 4.


IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
EXIT.
ENDIF.


IF graphic_url IS NOT INITIAL.

CALL METHOD picture->clear_picture
EXCEPTIONS
error = 1.

CALL METHOD picture->load_picture_from_url
EXPORTING
url = graphic_url
IMPORTING
RESULT = g_result.

CALL METHOD picture->set_display_mode
EXPORTING
display_mode = picture->display_mode_normal_center
EXCEPTIONS
error = 1.

CALL METHOD cl_gui_cfw=>update_view.
ENDIF.

ENDFORM. "getpicurl

*---------------------------------------------------------------------*
* MODULE zjncpbo OUTPUT screen 0806
*---------------------------------------------------------------------*
MODULE zjncpbo OUTPUT.

MOVE 'NAMASTE.JPG' TO g_name.

CREATE OBJECT: container1 EXPORTING container_name = 'CUSTOM_1',
container2 EXPORTING container_name = 'CUSTOM_2',
picture EXPORTING parent = container1,
timer EXPORTING parent = container2.

SET HANDLER lcl_event_handler=>on_finished FOR timer.

* Start Timer
timer->interval = timeout.
CALL METHOD timer->run.

PERFORM getpicurl.

CALL METHOD cl_gui_cfw=>flush.

ENDMODULE. " PBO

*---------------------------------------------------------------------*
* MODULE zjncpbo2 OUTPUT screen 2009
*---------------------------------------------------------------------*
MODULE zjncpbo2 OUTPUT.

MOVE 'THANKS.JPG' TO g_name.

CREATE OBJECT: container1 EXPORTING container_name = 'CUSTOM_1',
container2 EXPORTING container_name = 'CUSTOM_2',
picture EXPORTING parent = container1,
timer EXPORTING parent = container2.

SET HANDLER lcl_event_handler=>on_finished FOR timer.

* Start Timer
timer->interval = timeout.
CALL METHOD timer->run.

PERFORM getpicurl.

CALL METHOD cl_gui_cfw=>flush.

ENDMODULE.

read more...

What is the difference between SY-UCOMM and OK_CODE in Dialog Program?

sy-ucomm is for doing the functions what the user wishes to do at that particular event. You use it in menus and other place . this mainly in using

ok_code is generally used in screen as of I have used. You will define the function in the screen. and you can use it in the main program.

ok_code acts just as a temporary variable that stores the value of sy-ucomm.


When user interacts with the screen elements, the function code that you have assigned is filled in the sy-ucomm field which is turn gets reflected in OK_CODE.

In your ABAP programs, you should work with the OK_CODE field instead of SY-UCOMM. There are two reasons for this: Firstly, the ABAP program has full control over fields declared within it, and secondly, you should never change the value of an ABAP system field. However, you should also always initialize the OK_CODE field in an ABAP program for the following reason:

In the same way that the OK_CODE field in the ABAP program and the system field SY-UCOMM receive the contents of the corresponding screen fields in the PAI event, their contents are also assigned to the OK_CODE screen field and system field SYST-UCOMM in the PBO event. Therefore, you must clear the OK_CODE field in the ABAP program to ensure that the function code of a screen is not already filled in the PBO event with an unwanted value. This is particularly important when the next PAI event can be triggered with an empty function code (for example, using ENTER). Empty function codes do not affect SY-UCOMM or the OK_CODE field, and consequently, the old field contents are transported.

read more...

Change the Input Fields Dynamically in a Screen ABAP Dialog Programming

ABAP Dialog Programming Questions:

How to change the input fields dynamically in a screen which consists of 9 text fields?
Moreover the user must not enter values in some of the input fields where the values are given.

1.If you want to change the input fields on some user input then use 'user-command ac' after the field on which you want the action.
2.Specify the modif id 'xxx' for each screen object.


3.Then in the event 'AT SELECTION-SCREEN ON OUTPUT' loop at screen. check the screen-group1(modif id ) of screen objects and change the status of the object.
4.You can view all the screen attribute from se11.

The following example may help you:

SELECTION-SCREEN BEGIN OF BLOCK 001.
PARAMETERS: P_MRU RADIOBUTTON GROUP SEL DEFAULT 'X' USER-COMMAND AC,
P_PART RADIOBUTTON GROUP SEL.
SELECT-OPTIONS P1 FOR MODIF ID PRT.
SELECT-OPTIONS G1 FOR MODIF ID MRU.
SELECTION-SCREEN END OF BLOCK 001.

AT SELECTION-SCREEN OUTPUT.
LOOP AT SCREEN.
IF P_MRU = 'X'.
IF SCREEN-GROUP1 = 'PRT'.
SCREEN-INPUT = '0'.
ENDIF.
IF SCREEN-GROUP1 = 'MRU'.
SCREEN-INPUT = '1'.
ENDIF.
ELSEIF P_PART = 'X'.
IF SCREEN-GROUP1 = 'MRU'.
SCREEN-INPUT = '0'.
ENDIF.
IF SCREEN-GROUP1 = 'PRT'.
SCREEN-INPUT = '1'.
ENDIF.
ENDIF.
MODIFY SCREEN.
ENDLOOP.

read more...

ABAP : A Sample Hide & Get Cursor in Interactive Programming

Hide & Get Cursor is used in interactive programming ( in the event AT LINE-selection).
Using Hide in Loop..Endloop, you can get the field name At Line-Select
Event While Double Clicking That Line.

****PROG.BEGIN***************************************************************
*&------------------------------------------------------------
*& Report ZPREM_INTERACTIVE *
*&
*&------------------------------------------------------------*
*&
*&
*&------------------------------------------------------------*

REPORT zprem_interactive .

TYPES : BEGIN OF ty_test,
code TYPE i,
name(10) TYPE c,
amount TYPE p DECIMALS 2,
END OF ty_test.

DATA : it_test TYPE STANDARD TABLE OF ty_test WITH HEADER LINE INITIAL SIZE 10.

DATA : wa TYPE ty_test,
chk1 TYPE c,
fldname(30), fldval(50).

*set pf-status 'PF01'.
*set titlebar 'PF01'.
*

INITIALIZATION.
it_test-code = 300.
it_test-name = 'Ramesh'.
it_test-amount = 5500.
APPEND it_test.

wa-code = 207.
wa-name = 'Prem'.
wa-amount = 5000.
APPEND wa TO it_test.

it_test-code = 117.
it_test-name = 'James Bond'.
it_test-amount = 9900.
INSERT it_test INDEX 3.

it_test-code = 217.
it_test-name = 'Sivaraman'.
it_test-amount = 9900.
INSERT it_test INDEX 3.

it_test-code = 201.
it_test-name = 'Saravanan'.
it_test-amount = 1000.
APPEND it_test.

it_test-code = 210.
it_test-name = 'Shanmugam'.
it_test-amount = 6000.
APPEND it_test.

WRITE : / 'Loop Display ( Appended rows ) :-'.
LOOP AT it_test.
WRITE : / chk1 AS CHECKBOX,
sy-tabix, sy-vline, it_test-code, it_test-name, it_test-amount.
HIDE : it_test-code, it_test-name.
ENDLOOP.
SKIP.

END-OF-SELECTION.
CLEAR : it_test-code, it_test-name.
WRITE : / 'this from end of selection'.


*&--------------------------------------------------------------------*
*& Form DISP1
*&--------------------------------------------------------------------*
* text
*---------------------------------------------------------------------*
FORM disp1.
WINDOW STARTING AT 15 10
ENDING AT 80 15.
DO.
CLEAR chk1.
READ LINE sy-index FIELD VALUE chk1.
IF sy-subrc NE 0.
EXIT.
ELSE.
CHECK chk1 NE space.
WRITE : / it_test-code, it_test-name.
MODIFY CURRENT LINE :
FIELD VALUE chk1 FROM ' '
FIELD FORMAT chk1 INPUT OFF.
ENDIF.
ENDDO.
ENDFORM. "DISP1

***line double click ****
AT LINE-SELECTION.
CHECK sy-lsind = 1.
WINDOW STARTING AT 5 4
ENDING AT 85 20.
WRITE: / 'THE USER DOUBLE-CLICKED A LINE IN THE REPORT'.
WRITE: / sy-lisel.
WRITE : / 'Sometime ',it_test-name, ' is good '.
WRITE : / 'Sometime ',it_test-name, ' is bad '.
WRITE : / 'Sometime ',it_test-name, ' is rich '.
WRITE : / 'Sometime ',it_test-name, ' is poor '.
WRITE : / 'Who knows, who is ',it_test-name, ' ? '.
WRITE : /, / 'we can also use this in SELECT statement'.
CLEAR : it_test-code, it_test-name.

.
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

ULINE.
SKIP.
SKIP.
WRITE : / 'Below from Get Cursor Field...'.
GET CURSOR FIELD fldname VALUE fldval.
CONDENSE fldname.
CONDENSE fldval.
WRITE : / 'You have clicked ', fldname, ' & its value is ', fldval.

***function key press F6 ****
AT PF06.
PERFORM disp1.

*AT USER-COMMAND.
* CASE SY-UCOMM.
* WHEN 'STOP' OR 'CANCEL'.
* LEAVE TO SCREEN 0.
* WHEN 'TESTME'.
* PERFORM DISP1.
* ENDCASE.

read more...

SAP ABAP : Dialog Box : "Common used of Dialog Screen for Display, Change, Delete

It is not required of you to create and maintain different dialog screen for each screen functions for Create, Change, Delete and Dispaly. You can shared the used of a single Dialog Screen and used the MODIFY SCREEN to make the Field to be modify or not. Modifications and maintenance will be easier when user request you to change any screen layout.

PROCESS BEFORE OUTPUT.
MODULE 0250_STATUS.
LOOP.
MODULE STATUS_0120.
ENDLOOP.

LOOP.
MODULE STATUS_0110.
ENDLOOP.

LOOP.
MODULE STATUS_0100.
ENDLOOP.
*
PROCESS AFTER INPUT.
MODULE REFRESH_0250.
LOOP.
MODULE USER_COMMAND_0120.
ENDLOOP.

LOOP.
MODULE USER_COMMAND_0110.
ENDLOOP.

* For example, if the user enter the Delete Screen, you will make all the Fields non-Editable.
*&---------------------------------------------------------------------*
*& Module 0250_STATUS OUTPUT
*&---------------------------------------------------------------------*
* text *
*----------------------------------------------------------------------*
MODULE 0250_STATUS OUTPUT.
SET PF-STATUS 'Z250'.
SET TITLEBAR 'Z250'.
IF OKSAVE = 'DEL'.
* Make the SAVE Menu button inactive
SET PF-STATUS 'Z250' EXCLUDING 'SAVE'.

* Make all the Fields non-Editable
LOOP AT SCREEN.
SCREEN-INPUT = 0.
MODIFY SCREEN.
ENDLOOP.
ENDIF.

* For example, if the user enter the Modify Screen, you will make all the Fields Group 1 that
* have a 'M' non-Editable.
* You specify the 'M' for Group 1 using the Screen Painter Attribute
IF OKSAVE = 'MOD'.
* Make the DELE Menu button inactive
SET PF-STATUS 'Z250' EXCLUDING 'DELE'.

* Make all the Fields Groups 'M' non-Editable
LOOP AT SCREEN.
check screen-group1 = 'M'.
SCREEN-INPUT = 0.
MODIFY SCREEN.
ENDLOOP.
ENDIF.
CLEAR OKCODE.
ENDMODULE.

read more...

SAP Basis & Security Authorization : How to apply OSS notes to my R/3 system?

In order to fix one of the problem in R/3 system, SAP will asked you to download an OSS notes which is a ".car" file.

To work with a CAR File do the following at OS Level:

Get into OS as adm

Copy the .CAR file to a Temporary Directory.

Uncompress the file with SAPCAR

Copy the the data file generated in the data transport directory
( ej: = /usr/Sap/trans/data).

Copy the the cofile file generated in the cofiles transport directory
( = ej: /usr/Sap/trans/cofiles).

Run transaction STMS

Upload the support package with SPAM transaction and the support package will show "New support packages".

Examples of CAR command :-

1) UNIX only:

Log on as user adm.
cd /usr/sap/trans
CAR -xvf tmp/.CAR -V

2) Windows NT only:

Log on as user ADM.
cd \USR\SAP\TRANS
CAR -xvf TMP\.CAR

This Will create two(2) FILES

After you run SPAM you MUST run STMS and check the transport queues

**********

As per 315963 note you can direct made the changes in the program or you can apply the support pack.

a) If you want to apply correction then first you need to register the object in SAP, so that you will get the Access key and then you can make the changes.

b) If you want to import the support pack then you need to down load from SAP market-place. and this is in CAR file. and then you need extract the same using CAR utility.
ex: CAR -xvf abc.car

or

you can directly apply the patch from SAPGUI, login to 000 client and then you can load the patch from Presentation server.

Also check what is your current basis patch level?

For example if you want to apply patch 07 and you are having 05 then you need to apply 06 and then apply 07.

**********

Things to take note of:-

It would definitely be better to apply the latest spam/saint spam manager, tp, R3trans and possibly a new kernel patch.

This is not a simple task to complete on the fly. By applying SAP support packs, you may run into problems with SPDD and SPAU adjustments. Also include the fact that the support packages may break one of your transactions. You may want to test this in your sandbox environment, if you have one, before tackling it.

In most situation when you apply support packages, it can takes about 3 weeks to fully test the support packages before you can apply them to the production system.

Do test your "golden" transactions to make sure that they are not broken. If you are not familiar with SPDD and/or SPAU adjustments than do not attempt to load support packages.

You may be better off just to modify the SAP object in question via OSS note.

read more...

Asset Master Data Upload

1. If the change of the field can be put into an algorithm (e.g., enter XYZ as a super number for all assets in class 1234), you can use a mass change rule. You first define the mass change rule in the same way as you would define an asset substitution (IF something, THEN something else), then you go into the mass change transaction, select the right assets, the proper change rule ... and hit Execute.

2. Very often, it is easier to prepare the data in Excel and use transaction AS02 for the upload. Here, I can recommend transaction LSMW - you simulate (and record) the AS02 transaction on one fixed asset master, then follow all the steps proposed by the system (define fixed values, variables, etc.) and finally upload the Excel (.csv). System will automatically generate a batch input for all assets. It may take some time for you if you do it for the first time, but it is the best way if you would otherwise need to define complex algorithms.

So - use option 1 if you have a simple algorithm for many assets, and option 2 if "each case is different" or if you feel more comfortable in Excel than ABAP. Option 2 is simple, but of course takes some time to generate the upload and then run the batch sessions (while option 1 changes everything instantly in a matter of seconds).

Here are the details:

I. To use mass change:

1. First, define a mass change rule in transaction OA02 (Accounting - Financial accounting - Fixed assets - Environment - Mass change rule). For each company code, you can define one rule (or a sequence of them). However, all of them will always be executed at the same time. Therefore, if you need to define different rules for different assets, you will have to do this repeatedly. Technically, this is done in the same way as AA substititution.

2. Once the rule is defined, you need to select assets for mass change. Go to transaction AR01 (Accounting - Financial accounting - Fixed assets - Environment - Worklist - Generate). Enter selection criteria like on any standard AA report, and run Execute. I cannot simulate this now on my system (we do not have AA), but it should ask what you want to do (mass change, mass retirement, etc.) and ask for a name of the worklist (write anything - e.g., Super number change). The system will show you a list of selected assets in a report format. Check it and make sure that it is correct. You may add or remove single assets from this (now cannot tell you how, but it is possible). If you are happy with the list, save it.

3. The last step is execution of the change. Go to transaction AR31 (same path as above), execute the report and if you are happy with the list (same as in step 2), press Save. System will show you a log of change (what went through, which errors occured). You are done.

II. LSMW
LSMW is a transaction, which will let you mass upload almost any other transaction (FB01, FD01, AS91, etc.). You do it in the following way:
1. Enter into transaction LSMW (no menu path), possibly in a development / test system
2. First, define a project, subproject and object (relatively formal task).
3. On the horizontal menu, go to Goto -> Recordings. Click on "Create recording".
4. Enter the name and description of recording (freely definable).
5. I cannot simulate this now in my system, but SAP will ask you about transaction code (AS02) and will take you into the AS02 transaction. In this step, do the change manually. Make sure you "touch" (change / write something) in all fields which you want to update.
6. Once you are done, save the recording and return on the start page of LSMW. Click "Execute".
7. You will see a list of tasks. Do them one by one. They should be relatively simple (and I cannot help you with them). Important is step 3 (maintain source fields) - here you define the columns of your excel (csv) file in the particular order. In step 5 (field mapping and conversion rule), you assign file columns to SAP fields (note that you will see only those fields which you "touched" during recording). You need to go through all the steps. In the end, you get (and run) a batch session.
8. If you did this in a development system, transport the LSMW object (menu Extras - Export project, Extras - Import project). You have to do it via file, not via standard transports of configuration (it is perhaps more simple).

Make sure you test it first in development or quality system!

Fiscal Year Variant

Assuming that you are newly implemention with go live date of Sept 1st 2006 and Fiscal year January - December, what will be the best way?
Would it be better to define a Shortened Fiscal year for Sept-Dec 2006 and then regular Fiscal years OR Define a full Fiscal year for the entire 2006 and future FYs

Normally, the best way is to keep it simple and leave the first year "normal" (12 + 4 months starting January). You convert old data as of August 31 (unless the client requests opening balance as of December 31, 2005 and then monthly movements - I have experienced both options) and then start normal bookings in month 9 on September 1.

We never tried shortened fiscal year in this context and it is surely not needed here. It just adds complexity.

If we create the normal Jan-Dec Fiscal Year for 2006 also, how will we handle the assets when we go live in Oct 2006? Do we load the book value at that time or we load the book value for January 2006 and depreciate in the system for January to September

The ordinary way is to load fixed assets which exist on September 30 (if you go live with AA module on October 1) with trans. AS91.
- First, you need to set in configuration that the last closed fiscal year for legacy data upload is 31.12.2005 and the last period for depreciation will be 9/2006. (Do it in IMG: Financial accounting - Asset accounting - Asset data transfer - Parameters for data transfer - Date specifications)

Within trans. AS91, you enter the following values:
- acquisition value and accummulated depreciation as of 01 January 2006
- all asset movements (acquisitions, retirements, but not ordinary depreciations) between January 1 and September 30 with their respective dates
- already posted depreciation in 2006 until September 30

Then you enter GL movements per month (either you temporarily change the asset reconciliation accounts for direct booking with trans. OAMK, then book with FB01 and finally reset with OAK5, or you book there directly with trans. OASV). This way, your asset accounts (acquisition value and accummulated depreciation) are the same as asset module as of September 30.

You can also let the system recalculate the depreciation from the beginning of the year, but then you may end up with a different value as of September 30 than your legacy system calculated. So, I would not recommend it unless there is no reliable source data.

read more...

Mass Change For Assets and Data Reset

How to reset Asset Data?

You can reset the entire AA data from Img->FA-> AA-> Preparing for production startup ->Tools -> Reset
company code.

This will reset only the asset accounting data from the company code. But before you perform this you have to make sure that you reverse all the transaction you have posted and have gone to the FI. As this reset will not effect FI GL data.

You can then reset the depreciation posted and then the recon accounts.

When you reset the recon accounts, it will enable you to post directly to the account like normal GL. Then you have to post JV and rectify you GL(recon account).

Then upload the correct data. After the data is uploaded set the recon accounts. this will reconcile the amount with the assets and activate the company code (in asset area).

Mass change for assets

I am experiencing problems in OA02, Asset Mass Change. I am using 4.6C.

What happened was that I created the Substitution, then created the Step, and I then SAVED. I am not sure if I need to create a RULE or not. I have already defined in a STEP, (using Formula Builder) that most assets belonging to a certain asset class, 9011 with a current Cost centre, Z01, are to be assigned to another Cost Centre Z02, within the same Co.
Code. I then saved the Substitution, although I noticed that there was a "?" icon next to the RULES folder. I am well aware that for Time Dependent Data, we would need to specify a "Valid From" date. (ADATU, in Table ANLZ) But, do we need to specify a "Valid To" date as well ?

PREREQUISITES: Asset Class =3D '9011'

SUBSTITUTION: Valid From is substituted by Constant '19.08.2001'
Cost Centre is substituted by Constant 'ZB02'

If I need to create a Rule, What would I need to enter ? I then created a WorkList, and assigned the Substitution to it. After this, I generated the Worklist in Background using AR31. Everything seems ok, but when I check the Assets, I still see the old Cost Centre, NOT the New Cost Centre.

--------------

Rules are not required. You get a ? because you probably started to create one and did not finish.

For a Cost centre mass change, if you want to have it time dependent, you must specify 'valid from' and 'valid to' in the substitution rule. In config you determine if you want to use the time dependency or not (default is : Yes)

read more...

Asset Reverse Year-End Closing

If you closed a fiscal year too soon, and still need to make corrections, you can reset the last closed fiscal year in Customizing for :-

Asset Accounting (Periodic processing -> Year-end closing -> Reverse).

Using this function, you can re-open the last closed fiscal year, either for selected depreciation areas in a company code, or for all depreciation areas in a company code. You do this by changing the field for the last closed fiscal year.

Be careful if you re-open a fiscal year only for certain depreciation areas, and you need to make adjustment postings only in these areas. You cannot use the standard transaction types for these postings, since the standard transaction types post to all depreciation areas. Instead, you have to define your own transaction types in Customizing for Asset Accounting (Transactions), limiting them to the required depreciation areas.

OAAQ - Reverse year-end closing for deprciation area

At the desired company code, change the fiscal year in 'Closed fiscal year' column.

Save entries and create a new request.


Change Asset fiscal year

AJRW - Asset fiscal year change

Company code : Your Company code

New fiscal year : Last closed fiscal year

Uncheck 'Test run' if this is a production run

At menu bar, click Program -> Execute in background.

read more...

SAP FI/CO : Asset Year-end Closing

The year-end closing enable the company to produced the final balance sheet and profit and loss statement for its annual report, which has to be created to meet the particular legal obligations in each country.

Once the fiscal year is closed, you can no longer post or change values within Asset Accounting (for example, by recalculating depreciation). The fiscal year that is closed is always the year following the last closed fiscal year. You cannot close the current fiscal year.

AJAB - Year-End Closing Asset Accounting

Company code : Your Company code

Asset classed asset u. const. : Optional

For fiscal year : Last closed fiscal year

Uncheck 'Test run' if this is a production run

At menu bar, click Program -> Execute in background.


Perform Fiscal year close for fixed Assets.

While doing a Test run, message is that fiscal year close could not be performed but it does not display any Asset details .It says Other Error. I am not able to identify what those other Errors could be.

Also, I have checked Incomplete Assets list As well but that list is empty as well. Also while running tcode AUVA there is a tab correct incomplete Assets, can anyone tell what deos that mean and when its to be used.

You can check and edit Asset accounting closing status using tcode OAAQ.

But you seem to be not clear on process.

AJAB is for closing Asset Accounting books.
AJRW is a technical step of changing fiscal year in system. If not done, it will not allow you to view asset reports in current fiscal.

Now, your error says incomplete asset. Please run ajab in test mode, check for details. It will give you asset details and error details as well. Go to asset explorere and check if the asst in question has been fully depreciated for the year.

If not run repeat deprecation for the asset in period 12 and then try closing asset books. You can also check asset and GL inconsitency using tcode ABST.

read more...

SAP FI/CO : Process Fixed Asset Depreciation

Every asset transaction immediately causes a change of the forecasted depreciation. However, it does not immediately cause an update of the depreciation and value adjustment accounts for the balance sheet and profit and loss statements. The planned depreciation is posted to the general ledger when you run the periodic depreciation posting run. This posting run uses a batch input session to post the planned depreciation for each posting level for each individual asset as a lump sum amount.

The calculation and scheduling of depreciation, interest and revaluation are automatically controlled by keys in the system, or you can control them manually using a special posting transaction. In both cases, planned depreciation from Asset Accounting must be periodically posted to the corresponding asset and expense accounts of the general ledger. You carry out this posting using a batch input session. In addition to the various depreciation types, interest and revaluation, this batch input session also posts the allocation and writing off of special reserves.

When the system posts depreciation, it creates collective documents. It does not create separate documents for each asset.

Depreciation Posting Run is done via transaction code 'AFAB'.

The program creates batch input sessions for posting depreciation and interest to the G/L accounts in Financial Accounting and/or to Controlling.

Fields Description :-

Company code : Your Company Code

Fiscal Year : Your fiscal year

Posting period : Your depreciation period

Reason for posting run (choose one)

Planned posting run : X (default)

List assets : (tick if you want to see the detail)

Test run : (tick if you run in test mode else untick for production run)

Main asset number : (you can specify certain asset number if you click repeat run or test run)

Note :
Click the execute button if this is a test run.
Click the menu bar -> Program -> Execute in background if this is a production run.

You should get this message :
Background job was scheduled for program RABUCH00 and print out the output.

Release and Process the Batch Input Session in transaction code 'SM35'.

Process Session RABUCH00
X - Display errors only
Additional functions
X - Dynpro standard size

Click the Process button

If there is error, the system will pop up the error message.

Correct the error and recreate the session in transaction 'AFBD'.

read more...

SAP FI/CO : Posting to Cost Center and Internal Order

If you have added the field Internal order in the Asset Master as a statistical order and you want your depreciation
posted not only to the cost center but also to this order.

In transaction OAYR in the IMG you define how depreciation posts to the depreciation posting rules - there is a CO assignment box where you have to tick both cost centres and internal orders.

What is internal order? Explain with example and how it is related to cost center.

An internal order is used to accumulate cost for a specific project or task for a specific time period. An internal order is therefore used for a short period with a specific deadline.

Your internal order will usually settle to cost centers (and not visa versa) according to the settlement rule in the order setup.

An internal order can therefore be used to group all the expenses incurred to plan and hold a conference over a 3 month period. The order can be settled on a monthly basis to cost centers. When the conference is finished the order can be settled finally. The cost of the conference will then be spread over 2 or more cost centers, but can be viewed in total on the internal order when needed.

Internal Orders - It is an instrument used to monitor costs and, in some instances, the revenues of an organization.

Uses of Internal orders
- Monitoring the costs of short-term jobs
- Monitoring the costs and revenues of a specific service
- On going cost control

Internal order categories
- Overhead Orders
- Investment Orders
- Accrual Orders
- Orders with revenue

Cost centers are not for specific job. e.g If you have open Trade-fair / exhibition (1 month period), then to allocate cost, you can use Internal Orders (Say IO) you can post to IO, and from their to various cost centers. If management were to ask you the cost of that exhibition, Internal Order will help you

Cost center is a responsible center in SAP. It cannot be defined as statistical but in transactions it may become as per other co objects.You will be able to find out the performance of the cost center using activities and plan values with actual value. This is lowest cost object in SAP. This will become a statistical object when you allocate the cost to other higher objects. Cost can be allocated to other cost centers or co objects but not fi objects like GL,assets, inventory etc. can be defaulted in transactions through cost element. It cannot be a cost object for a revenue element, revenues are always taken for other higher CO objects. No budget functionality is available but planning functionality is available and is always measured for a year in business.

Internal order is the second CO object - which can be defined as statistical or real. You will be able to define Budget and planning figures - more than one year also. Can control the postings of FI through budget controls. You can have the report of Plan vs actual including commitment. Cost cannot be allocated but settled through settlement rules and profiles. The receiver of the values can be any object not like Cost center - can be CO objects and FI objects. Ideal for R&D expenses capitalization, etc. Status profile is linked to this which controls many individual transactions in each status which is a part of this Internal order. It can also receive postings of activities from Cost center. Settlement profile is an wonderful tool for variety of settlement - needed for FI and CO - legal requirements also and Revenue requirements also for any country.

All SAP CO orders like Production order, Plant maintenance order, etc will behave like Internal order with more functionality.

read more...