Tuesday, April 12, 2011

Difference between Operational Data Store(ODS) and InfoCube

Infocubes have a multidimensional structure with dimension tables(max 16, 13 custom) and one fact table. they are meant for summarised records.
ODS store data at a more granular level. they have flat structures like a table in R/3. They have a unique feature "overwrite" which is absent in case of cubes.
You can use ODS to load to cube further.
Anyway, one major difference is the manner of data storage. In ODS, data is stored in flat tables. By flat we mean to say ordinary transparent table whereas in a CUBE, it composed of multiple tables arranged in a STAR SCHEMA joined by SIDs. The purpose is to do MULTI-DIMENSIONAL Reporting
Another difference is : In ODS, you can update an existing record given the KEY. In CUBES, theres no such thing. It will accept duplicate records and during reporting, SUM the keyfigures up. Theres no EDIT previous record contents just ADD. With ODS, the procedure is UPDATE IF EXISTING (base from the Table Key) otherwise ADD RECORD.
Stores line item level detail, more granular Can't create aggregates on ODS ODS are based on flat tables Only two dimensional reporting possible on ODS.  Overwrite feature available while loading records
- Stores summarized data, less granular. 
- Aggregates can be created on top of Infocubes for better performance of Queries.  
- Multi-dimensional reporting possible on Infocube.
- Theres no overwrite feature while loading records.
Infocubes are MDM objects that fact table and dimension table are available whereas ODS is not a MDM object there are no fact tables and dimension tables. It consists of flat transparent tables.
In infocubes there are characteristics and keyfigures but in ods key fields and data fields. we can keep non key characteristics in data fields.
Some times we need detailed reports we can get through ODS. ODS are used to store data in a granular form i.e level of detail is more. The data in the infocube is in aggregated form.
From reporting point of view ods is used for operational reporting where as infocubes for multidimensional reporting.
ODS are used to merge data from one or more infosources but infocubes does not have that facility.
The default update type for an ODS object is overwrite for infocube it is addition. ODS are used to implement delta in BW. Data is loaded into the ODS object as new records or updating existing records in change log or overwrite existing records in active data table using 0record mode.
You cannot load data using Idoc transfer method in ODS but u can do in infocube.
You cannot create aggregate on ODS. You cannot create infosets on infocube.
ODS objects can be used.
When you want to use the facility of overwrite.  If you want to overwrite nonkey characteristics and key figures. If you want detailed reports you can use ODS.
If you want to merge data from two or more infosources you can use ODS.  It allows you to drill down from infocube to ODS through RRI interface.
ODS objects can be used in the following scenarios. ODS is not a mandatory but depending on the requirements we have to use it.
When you want to use the facility of overwrite.  If you want to overwrite nonkey characteristics and key figures in the data fields column.
If you want detailed reports, you can use ODS.
If you want to merge data from two or more infosources you can use ODS.
It allows you to drill down from infocube to ODS through RRI interface if u want detailed data from ODS.
If you want to create an external file.
The most important difference between ODS and BW is the existence of key fields in the ODS. In the ODS you can have up to 16 info objects as key fields. Any other info objects will either be added or overwritten! So if you have flat files and want to be able to upload them multiple times you should not load them directly into the info cube, otherwise you need to delete the old request before uploading a new one. There is the disadvantage that if you delete rows in the flat file the rows are not deleted in the ODS.
I also use ODS-Objects to upload control data for update or transfer routines. You can simply do a select on the ODS-Table /BIC/A00 to get the data.
ODS is used as an intermediate storage area of operational data for the data ware house . ODS contains high granular data . ODS are based on flat tables, resulting in simple modeling of ODS .  We can cleanse transform merge sort data to build staging tables that can later be used to populate INOFCUBE .
An infocube is a multidimentionsl dat acontainer used as a basis for analysis and reporting processing. The infocube is a fact table and their associated dimension tables in a star schema. It looks like a fact table appears in the middle of the graphic, along with several surrounding dimension tables. The central fact is usually very large, measured in gigabytes. it is the table from which you retrieve the interesting data. the size of the dimension tables amounts to only 1 to 5 percent of hte size of the fact table. Common dimensions are unit & time etc. 
There are different type of infocubes in BW, such as basic infocubes, remote infocubes etc.  
An ODS is a flat data container used for reporting and data cleansing/quality assurance purpose. They are not based on star schema and are used primaily for detail reporting rather than for dimensional analyais.
An infocube has a fact table, which contains his facts (key figures) and a relation to dimension tables. This means that an infocube exists of more than one table. These tables all relate to each other. This is also called the star scheme, because the dimension tables all relate to the fact table, which is the central point. A dimension is for example the customer dimension, which contains all data that is important for the customer.
An ODS is a flat structure. It is just one table that contains all data.  Most of the time you use an ODS for line item data. Then you aggregate this data to an infocube.
ODS holds transactional level data..Its just as a flat table.  Its not based on multidimensional model. ODS have three tables 1. Active table 2. change log 3. New table
Cube holds aggregated data which is not as detailed as ODS. Cube is based on multidimensional model. Cube have 2 tables 1. E table 2. F table.

More Interview Questions On CIF

1. We have 50 integration models for each object type, since we have 50 plants. Should we define fewer integration models?
Before PlugIn 2002.1, we recommend that you define fewer models for performance reasons. Generally, the size of the integration models depends on the data volume for each plant. To optimize the integration model number, we recommend that you purchase consulting expertise.
As of Plug-In 2002.1, the "Runtime version of the integration model" is available. Using the runtime version guarantees better performance in the online operation (also refer to the documentation for the report RCIFIMAX).
Even though the number of integration models does not affect the performance significantly, we recommend that you keep the number of integration models low, in order not to increase the runtime for generating the runtime model.
That is, do not regularly create new integration models, rather only create new versions of integration models.

You can find release notes for the PlugIn on SAP Service Marketplace at: "http://service.sap.com/R3-PLUG-IN" -> Media Center -> Release Notes PI 2002.1 Release Notes SAP APO.

2. Do we have to transfer the master data of the vendor together with the stock data, so that consignment stocks are transferred?
Yes - this ensures that the consignment stock is correctly linked to the vendor location in SAP APO.

3. Master record objects that were changed since the last transfer are transferred again to SAP APO by initial transfer.
Does this mean that the report RCPTRAN4 (evaluate and send change recordings) does not have to run?
And what about the report RBDCPCLR (delete change pointers) for reorganizing the change pointers?
You do not have to execute the report RCPTRAN4 in this case, since the dataset in SAP APO is up to date due to the initial data transfer.
You should use the report RBDCPCLR to delete "old" change pointers.

4. The master and movement data for a material 4711 is in two active integration models (A+B). Assuming that one of the two is deactivated - what happens then?
The master data and movement data remains active. See also Note 533755 "Description of the delta logic or the program RIMODINI".

5a. What happens if you deactivate an integration model that has master record objects?
Planning in SAP APO is still possible. However, you can no longer transfer the transaction data to SAP R/3.
5b. What happens with the master and movement data in SAP APO after the master data was deactivated?
The master data remains in SAP APO.
5c. What happens with the transaction data if there is another activation?
The transaction data is transferred again. Provided that you reschedule (for example plan automatically (not for plan/manufacturing orders)), the old transaction data is deleted. Note that the integration model for the master data must also be active if the transaction data is transferred again.

6. How do I change from small to large integration models?
You activate the large model (all data already selected in active models is not transferred again) and then deactivate the small models.

7. Why are my orders not transferred from SAP R/3 to SAP APO?
Refer to the information contained in Note 424927 "No order transfer from R/3 to APO" and check your settings accordingly.

8. My material removals are not transferred in the APO order, but the stocks change.
Refer to the information contained in Note 421940 "No reduction of order reservations in APO" and check your settings accordingly.

9. Can data be transferred from SAP R/3 to SAP APO using BTE change pointers (for example from the table MBEW table using user exits)?
Since the APO standard system does not require data from the table MBEW, this is not transferred to the CIF during the transfer of data changes using BTE. Via BTE, data for all SAP standard fields is transferred from SAP R/3 to SAP APO from the table MARA (plant-independent material data), the table MARC (plant-dependent material data), the table MARM (conversion of units of measure) and the table MAKT (material texts). In the customer exit in SAP R/3 also only this data is available. An alternative here is the transfer of the material master changes using ALE change pointers.
For example: Transferring the "floating average price/periodic unit price" (MBEV-VERPR) using the user exit CIFMAT01 does not work. For this, the BD52 Customizing must be changed and the data must be transferred using the ALE method.
Changes to customer-specific fields can also only be transferred to SAP APO using ALE in connection with customer exits.

10. How can I avoid overlaps and thereby inconsistencies during the integration model transfer?
If you use parallel processing for the initial data transfer, transaction data may be transferred to SAP APO before the corresponding master data is available in SAP APO. For example, you can then create in-house production orders in SAP APO without PPM even though this should not be the case. Unfortunately, this cannot be prevented technically. The integration models must be cut accordingly and scheduled in background jobs so that this does not happen. Background jobs also check whether queues have been processed correctly and without errors.

11. Where can I find information about parallel processing during the initial data transfer?
You can find release notes for the PlugIn on SAP Service Marketplace at: "http://service.sap.com/R3-PLUG-IN" -> Media Center -> Release Notes => PI 2002.1 Release Notes SAP APO.
Application log
1. Is there a way of analyzing errors in the partner system directly from the application log?
For information about this, see the following notes:
Note 396838 "R/3: Displaying application log from queue entry"
Note 396839 "APO: Jump to application log from incorrect queue entry"
Note 457399 "Branching to the application log with inbound queues"
Note 457418 "APO: Branching to the application log with inbound queues"

2. How can I find CIF logs?
In the R/3 and APO SAP systems, you can analyze the application log using the following transactions:
SAP R/3 transaction CFG1 (see also Note 544011) and SAP APO transaction /N/SAPAPO/C3 (see also Note 544389).
Interactive user
Question: When do I have to create a dialog user if no ATP check is to be used?
Answer: This is necessary for analyzing the data transfer and for debugging. Also check note 352844
As of PlugIn 2002.2, it is possible to work with separate authorizations for every application.
Question: Are SNP PPMs taken into account in change management?
Answer: No (version PlugIn 2001.2).
Questions on release statuses
1. You want to use a new SAP APO 3.1 with the same system name as your old SAP APO 3.0, which is deactivated. Does this work?
Yes, as long as the "old" APO System is deactivated. The name for a logical system (LOGSYS) can only be assigned once.
You must also consider the following: In the SAP R/3 system, unique GUIDs are created for the mapping between SAP R/3 and SAP APO documents. See the "CIF*MAP"R/3 tables. This may cause discrepancies during the assignment of GUIDs and documents in SAP APO when you start a new initial data transfer.

2. Does SAP APO 3.1 work with PI 2001.1?
PI 2001.2 is the minimum requirement in this case. For further questions on the PlugIn release, go to SAP Service Marketplace. Here you will find further information at "http://service.sap.com/R3-PLUG-IN" -> Integration of SAP R/3 and mySAP.com Components.
1 SAP R/3 with several SAP APOs
Question: A client of an SAP R/3 system is to be operated with several SAP APO Systems (Release 3.0 and 3.1). Does this cause problems?
Answer: In theory, this does not cause problems. However, note the following: A planned order or production order (for example order 4711), and a PREQ (PReq 4712, pos 0010) or a sales order item can only be sent to a SAP APO system, in other words a PReq created in SAP APO system 1 is not copied to SAP APO system 2. The SAP APO systems must plan different material/plant combinations.

No stock transfers should occur between the SAP APO systems.

This would cause problems because a transaction date that was sent from the R/3 system to both APO systems may transfer different updates in the retransfer from both APO systems. Even if the updates from both APO systems are the same, these cannot be processed in such a way that a consistent status is achieved afterwards.

In the case of other objects like TP/VS and production campaigns, problems may occur
because updates from APO systems can no longer occur in an indivisible logical unit of work (LUW).

This may be the case if some of the referencing transaction data originates in one of the APO systems and other transaction data originates in the other APO system.

Further problem may occur in the APO systems due to different release levels
if the release level of the APO system is relevant for shipping in the R/3 outbound.

In this case, it cannot be guaranteed that all target systems will always be handled in a loop for all object types before each APO release query.
qRFC monitor (transaction SMQ1/2)
1. Can I restrict the access of the 'Delete' function in transaction SMQ1 using authorizations (the display and processing functions should still be available to the user)?
There are three authorization groups for transactions SMQ1 and SMQ2:
  • * Group 1 cannot call SMQ1 SMQ2 at all.
  • * Group 2 can call SMQ1 SMQ2 but it can only display it (not delete it!) and activate queues The transaction authorization for SMQ1 and SMQ2 is required for this.
  • * Group 3 can call SMQ1, SMQ2 and use all functions. The value NADM must be defined for this in the object S_ADMI_FCD.

2. Is there a better display of the queues than the qRFC monitor for outbound queues (SMQ1) or inbound queues (SMQ2)?
  • Yes, in SAP APO you have the SCM Queue Manager in transaction /N/SAPAPO/CQ (see also Note 419178).
  • As of SCM 4.1, you can also the CIF cockpit (transaction /SAPAPO/CC) that provides an overview of and access to all CIF-relevant transactions and Customizing settings of the APO system and all connected ERP systems.
The CIF Cockpit
As of SCM 4.1, you can use the CIF cockpit (transaction /SAPAPO/CC) in SAP APO. It provides an overview of and access to all CIF-relevant transactions and Customizing settings of the APO system and all connected ERP systems.
CIF queue names
For a list of all current CIF queue names that are used to transfer data between ERP systems and SAP APO, refer to Note 786446.

Friday, January 21, 2011

Nice SCM portal

Hi Guys,
Unfortunately to day i saw one of the blog by Shaun Snapp.Really his articles gives you a very useful info regarding SCM APO.
If possible Visit this link 

Thursday, January 13, 2011

BAPI and ALE Integration

The objective of "Business Application Programming Interfaces" (BAPIs) and "Application Link Enabling" integration is to enable future ALE scenarios to use BAPI interfaces. One advantage is that it will be much easier for both SAP Development and SAP customers to develop new ALE scenarios. Another advantage is that BAPI interfaces will be able to use already existing ALE functions, (e.g. error handling and writing links asynchronously).
Further advantages are:
  • object oriented approach
  • application maintains one interface only
  • reduction of generation program errors
Description of Function
When a BAPI is defined, ALE outbound and inbound interfaces are generated and entered in transport requests, provided that the following functions are generated at the time the BAPI is defined:
  • an IDoc type and its segments (IDoc = intermediate document)
  • a "wrapper" function module which decides whether the BAPI is called locally or from another system (see Overview Graphic). Local calls can call the BAPI immediately or via an IDoc which restarts it.
  • an ALE outbound function module which puts BAPI interface data into an IDoc and triggers ALE outbound processing
  • an ALE inbound function module which transfers BAPI interface data from an IDoc into the BAPI interface structure and calls the BAPI
  • ALE customizing for the new interface.
The flow diagram in the Overview Graphic shows the run time BAPI call flow logic.
The generation can also be used when an R/3 System is connected to a non-R/3 System. "One-way" means that either outbound or inbound but not both is implemented in the R/3 System. This means that a one-way interface cannot be used to exchange data between two R/3 Systems.
The generation can only be used for asynchronous interfaces, i.e. a receiver processes data without return parameters to the sender.
In principle the generation can also be used to support an IDoc interface for Electronic Data Interchange (EDI).

To call up the BAPI "BAPI_X_CREATE" in System 1, the program calls the generated "wrapper" function module "ALE_X_CREATE" whose interface contains all the BAPI interface parameters.
Application Area
All applications which create a write BAPI can use this functionality, especially when the BAPI is to be called from another R/3 System. Customers developing their own ALE scenarios also benefit from these advantages.

Tuesday, November 30, 2010

SAP Supply Network Collaboration (SNC) Overview

Overview of SAP SNC:
SAP Supply Network Collaboration (SNC) is a component of SAP Supply Chain Management (SAP SCM). It was formerly known as SAP Inventory Collaboration Hub (SAP SNC). Because enhancements broadened the collaboration environment, the product was renamed to reflect its extended capabilities for collaboration with suppliers (extending beyond inventory collaboration).
The supplier does not require a specialized electronic data interchange (EDI) infrastructure to integrate the supply network, which SNC makes this solution usable by companies of all sizes. All that is required on the supplier side is Internet access and a web browser. 

It serves as a joint-use platform for all business partners involved in the inventory collaboration process.
Supply Chain Collaboration is a key area in the mySAP SCM solution that supports collaborative planning and the exchange of documents with suppliers and customers. Collaborative planning can be done in the SAP Supply Network Collaboration (SNC) or in APO.
SAP Supply Network Collaboration supports the two collaborative business processes SMI (Supplier
Managed Inventory) and VMI (Vendor Manged Inventory).

Supplier Collaboration:
You can use  SAP Supply Network Collaboration (SNC)to optimize cooperation with your vendors. You and your vendors use SAP ICH as a common platform to control and monitor the replenishment process for materials.
For example, the vendor takes on responsibility for the stocks at your location. You and your business partner make an agreement about the minimum and maximum stock levels for the product at this location. The vendor monitors the stock level you have agreed upon with the SAP ICH system, making sure your stocks are replenished promptly and informs you about waiting deliveries. This ensure production flows smoothly and without any downtimes.Both business partners can check the stock level of all materials using the SAP SNC system. The SAP SNC system generates alerts and informs both partners about critical situations which enable them to react promptly. Employees can make individual settings about how they would like to be informed of these alerts,
like for instance by e-mail. This is especially helpful for employees that do not work with SAP SNC on a daily basis.

Customer Collaboration:
Using the VMI process, a VMI analyst develops an unrestricted forecast about future customer demands. Certain statistical forecasting and extrapolation methods are applied to historical sales data transferred from the customer when making this forecast.By means of replenishment planning, you can then determine quantities to be
delivered to a customer location (such as a distribution center) in order to meet customer demand and maintain the required degree of service. Starting with the requirements forecast, the replenishment process determines the optimum short and medium-term plan, which is required to meet the estimated requirement. This plan contains the quantites to be transported from the vendor distribution center (or production plant) to the customer distribution center (or branch).
Feasible transportation units can then be assembled based on business rules. Such rules concern constraints for the relevant means of transportation. This ensures that the appropriate minimum and maximum capacities are kept to.
In the consumer goods industry, menu pricing agreements bewteen vendors and cusomters are defining for these business rules. These agreements specify how transportation loads are to be put together with respect to logistical parameters such as permitted product and pallet combination, maximum weight and volume.
It is in the interests of both vendors and customers to optimize the cost-use situation in order to increase the overall profitability of the supply chain. In this way, transportation and storage costs are kept to a minimum for vendors.
Customers achieve extremely profitable replenishment intervals without their warehouse becoming overstocked and are at the same time in a position to react quickly to short-term fluctuations in demand.

So where do we collaborate exactly,
Customers at Finished good Replenishment.
Suppliers at Raw Material Procurement.

Integration Levels:

There are three integration levels available in between customer and supplier when we are talking about SAP SNC

1.       Web portal – generally this can be using when in low transaction volumes
2.        File Transfer – When supplies having limited internet connectivity this can be used
3.       B2B – One of the best one for high transaction volumes

Data Flow in SAP SNC:

We know how the data will transfer from ECC to APO system. When we are talking about the data transfer in between these two systems core interface(CIF) plays a vital role while transferring the Master data between ECC and SNC system. But the transactional data can be able to transfer through an middle ware too called Process Integration.

ECC Master Data:
Vendor Master
Info Records
Customer Master
Scheduling Agreements

SNC Master Data:

1.Generic Master Data.
2. Process-specific Master Data

Generic Master Data:
Model 000,
Planning version 000,
Ship-from location,
Customer location,
Transportation Lane between ship from location and customer location.

Process-specific Master Data:

You maintain process specific master data for certain SNC business processes, example for work order collaboration master data is required before we start working on the scenario.
Tcode : /SCA/MFGCFG 

Data Storage in SAP SNC:

SAP SNC has its own data storage model, consisting of Time Series Data Management, or TSDM, which stores and retrieves time series data such as forecasts Order Data Management, or ODM, which stores and retrieves order documents of any type that might occur in an SCM execution or planning process, such as purchase orders or deliveries Lean Inventory Management, or LIME, which stores and retrieves inventory data.

The liveCache in which SAP APO stores transaction data is not used by SAP ICH.
You do not need to configure Time Series Data Management in order to run the basic SNC processes.
You need to activate Order Data Management, but no further configuration is required.

Monday, November 29, 2010

FAQS on Core Interface

Which operations of a routing or recipe in R/3 or ERP are transferred to APO PPMs?
When PPMs are created in APO from Receipes in R/3 only those phases containing non-zero machine times are brought over. Other phases having only labour (resource category 003) or machine time (resource category 001) = 0 does not come through.

What determines the validity period of a resource in liveCache?
CFC9 parameter in R/3 does not set the From/to validity date for Resources when Work Centres are CIFed from R/3 to APO. Actually that is set as per entry in table /SAPAPO/RESLCT - Length of Time Stream or Bucket Vector in liveCache.

What needs to be done to debug CIF related enhancements?
In order to debug CIF related user exits or other CIF queues, set the R/3 RFC user (e.g. STGUSER) to Dialog user and then set queues to Debugging On/Record T/QRFCs in the transaction CFC2 in R/3. This is for queues coming inbound to APO. For queues coming inbound to R/3 set the APO RFC user id (e.g. APSUSER)

How can transaction data be reconciled with APO from R/3 or ERP side?
Program RCIFORDT can be used to reconcile transaction data form R/3 side. Refer 733110 - as a long term solution implement this BADI on APO side
OSS Notes 627630, 804034 on R/3 side and with the BADI OSS note 800286 to be applied
Which table stores Change Pointers in ERP or R/3?
The table BDCPV is to store Change Pointers in both APO and R/3.
Refer OSS Note 329110.

Which report can be used to clear Change Pointers in ERP or R/3?
Program RBDCPCLR can be used to clear change pointers from the Change Pointer table. The message type CIFSRC is for changes to Source of Supply (i.e. Purchasing Inforecords). The CIF Change Transfer program (CFP1) can fail due to a large number of records in the Change Pointer table. Other message types are CIFMAT for material, CIFVEN for Vendor Master, CIFCUS for Customer master.
What is Customer Consignment Stock and how is it transferred to APO?
Consignment stock at Customer is stock at customer premises but owned by the supplier. Prerequisite to have Consignment Stock at Customer is Customer as a Location and Product Master at that Customer Location. To transfer Customer Consignment Stock from ERP to APO both "Customer" and "Special Stock at Customer" should be part of an Integration Model during Initial Transfer. For Consignment Stock Batches "Storage Location Stock" object must be included in the Integration Model.
Reference: Note 409298

What is Vendor Consignment Stock and how is it transferred to APO?
Vendor Consignment stock is stock at the plant location and treated as normal storage location stock but owned by vendor. Vendor Consignment Stock is transferred from ERP to APO as part of "Storage Location Stock" Integration Model. However the Vendor must be part of an active
Integration Model.

How is Stock information stored in APO?
Stock in SCM APO system (upto 4.1) consists of Stock Anchor stored in Database and Stock Item stored in liveCache. The liveCache Consistency Check (transaction /SAPAPO/OM17) carries out the consistency check between the APO Database and liveCache. It should be executed periodically to delete obsolete stock anchors from the database.
Reference: Note 492591
As of SCM 5.0 Stock information is stored in liveCache table /SAPAPO/STOCKANC.
Reference: Note 837744

What are the userexits for Integration of Stocks?
On R/3 side the userexit is enhancement CIFSTK01 while on APO side it is enhancement APOCF011. The source code in the userexit should be copied to the CIF Compare/Reconcile Report (Delta Report) BAdI (method RELEVANT_FOR_COMPARE_R3_STOCK of BAdI definition /SAPAPO/CIF_DELTA3) for correctness of the report.
Reference: Note 492591

How is Inspection Lots handled in APO?
From SCM 4.0 Inspection Lots are separate objects in APO retaining the end dates. Hence Inspection Lots quantities does not shows up as Stock in Quality Inspection.
How is Cross-company Stock In Transit handled in APO?
Cross-company Stock In Transit is determined dynamically in R/3 and hence not transferred to APO. In APO Stock In Transit at the receiving plant can be handled by transferring Inbound Shipping Notification or Goods Confirmations from R/3.

What is the Data Load for Transaction Data that the CIF can typically handle in a day?
"It Depends" (need better answer here)

Configuring E-Mail Alerts in SAP SNC

SAP Supply Network Collaboration (SAP SNC) is an innovative, Web-based component that supports SAP's global vision for adaptive supply chain networks. The component, based on the mySAPTM Supply Chain Management (mySAP SCM) solution, supports a range of cutting-edge business scenarios in supplier and customer collaboration environments. SAP SNC provides a powerful and comprehensive means of enhancing cooperation, efficiency, and knowledge sharing throughout the supply chain.

This example demonstrates creation of Alerts for New Purchase Orders received in SAP SNC and sending E-Mail Alerts to the Supplier informing him about the new PO created in SNC.

For Configuring a Supplier Collaboration Scenario specific E-Mail Alerts, we need to configure a Message profile with the information of Fields which needs to be sent in an E-Mail.

For Creating Message Profile from SAP Easy Access Menu of SCM (SNC), use the following path.
SAP Menu -> SCM Basis -> Alert Notification Engine -> Settings -> Create/Change Message Profile or T.Code "/SCMB/ANOTMP" as shown in the following fig.

In the Change view Click "New Entries" Button to create a new Message Profile.

Create the Message Profile with the details as shown below.

After Creating Message Profile, add parameters to Profile by selecting the Message Profile and clicking on "Message Parameters" in left side tree. Click New Entries and add Parameters.

After Creating Message Profile, create Alert Profile using Alert Monitor using the following menu Path.
SAP Menu -> SCM Basis -> Alert Monitor -> Alert Monitor or T.Code "/SAPAPO/AMON1".

In the following screen, select the Button "Overall Profile" to create Alert Notification Profile and Alert Profile.

In the next screen, Use menu Option Goto -> Automatic Messaging

In the Create/Change Alert Notification Profile, click "Generate New Profile" button.

Provide the name and parameters for Alert Notification profile as shown below.

After creating Alert Notification Profile, Click the "Confirm Profile" Button.

Click "Back" button or Function key F3 and create Alert Profile as shown below.

Provide a name for Alert Profile and select the tab "SNC-SMI". In the Alert types, select Purchase Order and check the items New Purchase Order Item, Change Purchase Order Item checkboxes. Click the "Save SNC-SMI Alert Profile" button under Application Specific Alert Profile.

After creating Alert Profile, the Profile needs to be applied to Suppliers using web UI of SNC using the following Menu Path.

SAP Menu -> Supply Network Collaboration -> Web UIs for SAP SNC -> Special Views -> Customer View or T.Code "/SCA/ICH_C".

Log on to web UI by providing ID and password. Select the Alert Monitor under Menu "Exceptions". In the Alert Monitor screen, select the button next to button "Reset" and select option "Save as" as shown below.

In the pop up window provide a Name and select "Partner-Specific" from the dropdown list and click "OK" Button.

Select Supplier Number, Alert Category and Alert Type as shown below and "SAVE" the selection as shown below.

After creating the Selection variant, click "Set Notification" button to create Profile.

Provide the details like E-Mail ID, Message Profile, and Minimum Priority as shown below and click "Save".

After this configuration, the profile can be tested by sending a Purchase Order to SNC. As soon as SNC receives Purchase Order and E-Mail will be triggered and sent out to Supplier informing him about the new Purchase order received in SNC.

Sunday, November 28, 2010

APO Interview Questions with Answers

I have to upload data in the DP planning book from a legacy
system. The different options available regarding the update
type from this field are as follows:
OW1 - Overwrite Completely, First Period distribution
OW2 - Overwrite Completely, Consistent distribution
PW1 - First: Overwrite partially Period Distribution
PW2 - Overwrite partially: Consistent Distribution
DL1 - Delta Update: First Period Distribution
DL2 - Delta Update: Consistent Distribution
My question is where can I find the PUPDATE field in APO to
specify the nature of update type for the DP planning book?
You can do the following for update purposes:
1. Change this template: /SAPAPO/TS_PSTRU_SAMPLE_
MD_GEN in order to load with zeros.
2. Use the flag [X] Ignore zero values.
3. Update the values in table: RSSGTPCLA.
SAP SCM Interview Questions
- 1 -
SAP SCM Interview Questions
- 2 -
I am using APO to forecast negative values, but I don’t see any
option in my forecast profiles to allow for negative values.
There also seems to be a system setting that automatically
changes negative values to zero, which leads me to believe
that I can turn it off as well. How do I enable my forecast
profiles to allow negative value settings?
If you are working with APO 4.0, you can produce negative
values in forecasting MLR. Working with logarithms is
reasonable as well. That is, if you mean non-negatives with
time series.
SAP SCM Interview Questions
- 3 -
Creating a new key figure for a planning
I started adding a new key figure in the planning book in
DP by using BW admin (rsa1) but it doesn’t show in the
interactive demand planning book. How do I create or add a
new key figure in a planning book in DP?
I did try to go in /sapapo/msdp_admin and select my planning
area to add new key figures in there but the system said that
there are some active versions and that I can only go in
display mode. How can I go in change mode?
If you intend to do some calculations and do not intend to
save that data after exiting the planning book, you can use
auxiliary Key figures. Also, keep in mind that you can only
change inactive planning areas.
This being said, BEFORE you begin, please ensure that you
have a backup of your live cache and info cube information
required to rebuild the planning area when you have
You will then have to delete the time series objects against
the planning area (right click on the planning area and select
delete), this will delete ALL values in the planning area hence
the backup that is required.
Once this has been done the symbol next to the planning
SAP SCM Interview Questions
- 4 -
area should change from a green circle to a red square, you
should now be able to make your changes.
When you have completed the changes you will have the
pleasant task of uploading your data again.
I suggest that you try this several times in your DEV
environment before being sure of moving onto QA and
SAP SCM Interview Questions
- 5 -
In the data view of the planning book, we have a number of
key figures. When I drill down by product, I get the first key
figure and the product drilldown. From there, the next key
figure appears and the list goes on.
I would like to swap the drilldown between the characteristics
and the drilldown.
Is there a way to change the format so that I can drilldown
by the product and show all key figures for each product
Take the following steps to reformat according to your
1. First, set up the macro to do this. In the macro use
statement DRILL_DOWN and specify the level (Product).
When you run the macro it will show you the options.
2. You will need to have your header row displayed, and a
header button created (i.e. for your product). Also make
sure to have selected more than one product from the
drop-down (or details) menu. This is required before it
will allow pivot sorting.
3. Lastly, right-click in the top left hand corner of the
dataview and select Pivot Sorting. From here, you can
proceed to reformat.
SAP SCM Interview Questions
- 6 -
Choosing day in period for lc order in the
DP to SNP order
We have a monthly bucket in DP and SNP. When forecast is
transferred from DP to SNP, it is created as one live cache
order on the first day of the period covering the month. Is
there a way to change the transfer so that the forecast order
is on the 3rd or 4th day of the period?
For Example:
>DP 01/2006 forecast 100;
>Transfer to SNP;
>Forecast order created for 01/01/2006;
Instead, we would like it to be created for 01/04/2006.
You can do two things to make the changes. First option is
to check the forecast horizon field in the SNP2 tab of the
product master. The second option is, if you are using CTM
and have one forecast a month, change the CTM time stream
to weekly and aggregate the forecast to this period via the
aggregation tab in CTM. From there, choose the CTM global
configuration setting to middle of the period. CTM will then
treat the forecast at the beginning of the month (FI period
actually) as if it was on the Wednesday of the first week of
the month, instead of Monday.
SAP SCM Interview Questions
- 7 -
SCEM Triggers
What transaction is used to change the configuration of event
handlers? How do I set the triggers of the event handlers to
be inactive?
Go to SPRO> Integration with other mySAP.com Components
> Event Management Interface > Define Application
interface> Define SAP EM interface functions. From there,
you can set the triggers of the event handler.
SAP SCM Interview Questions
- 8 -
I was trying to convert planned orders created in APO to
production orders in R/3. I have placed the transfer indicator
in the orders and when I execute the transaction for transfer
it says transfer has taken place but I still cannot find the
orders in R/3. How do I effect the change?
If you have the Im in place, proceed to check the r3 inbound
and outbound queues for any blocks.
The R3 conversion to process orders would have caused a
change in the order number so you can’t find the same order
number in R3.
SAP SCM Interview Questions
- 9 -
Data load errors
I am getting the following errors in the data loads In APO
Quality system during monitoring checks: This is a quality
client copied system from the
APO production system.
1. There is no PSA for info source LISVCIT and source
system AP900.
2. System error occurred (rfc call).
3. Activation of data records is terminated.
How do I fix these errors?
First, check that the info package is not loading directly
to the cube. Make sure that it is loading to PSA first before
going to the cube.
With errors 2 and 3, there seems to be a problem with
whichever system is calling your client, and you should talk
to your basis team to rectify rfc errors.
SAP SCM Interview Questions
- 10 -
We are using the Custom Key Figure in DP and I am using
the same custom characteristic figure in the transfer profile
for the transfer of forecast from APO to R/3. It is not getting
transferred nor does it throw any error log, and the other
settings are fine (Publication types etc). What I would like to
know is if it is possible to use the Custom KF in the transfer
profile? Or should we use 9AMATNR only for the transfer of
forecast requirements?
You can use the custom characteristics to replace product
(9AMATNR) and location (9ALOCNO) in APO. However,
you have to define those characteristics when you build the
You can do this in the screen of Configuring POS using
EXTRA-->Assign Prod/LOC.
This should solve your release problem.
SAP SCM Interview Questions
- 11 -
We are required to carry out storage bucket profile
maintenance in Production system as the horizon of storage
bucket profile is getting expired (data backup from planning
area has already been taken into cubes). Can I transport it
to production by defining a new storage bucket profile into
the development system? Or do I have to define it in the
Production system directly? If I can transport the storage
bucket profile, what is the Tcode for that?
You can use the standard transport connection for DP and
SNP using the transaction /SAPAPO/TSOBJ. You will also
have to transport the planning area from dev to Prod plus all
the relevant details like POS, Storage buckets, and planning
buckets. Planning books will also get transported if you do
not remove them manually from the request.
From hereon, it’s your call to transport these things or just
change the storage buckets directly in production.
SAP SCM Interview Questions
- 12 -
We are trying to remove the duplicate storage of sales history
data in two places and the consequent system overheads of
loads and other similar items. Is it always necessary to load
sales history into APO or can it be stored in the central BW
(non-APO) and referenced via a remote cube in APO?
This should be possible using BAPI “ PlanningBookAPS” and
using the methods “ GetDetail” and “ChangeKeyfigureValue”.
Similarly, this procedure also works for uploading data from
excel to live cache without using info cube.
SAP SCM Interview Questions
- 13 -
How can I enter or attach a note to a macro in APO 4.1 Macro
Workbench or MacroBuilder?
Note can be maintained by clicking Macro workbench ->
Planning Book.
When you click this, window is split in two and you get all
the macros available.
From here right click the macro, you will get the option to
add a note to macro.
Then, choose the change mode of the planning book>Right
Click on any value in the planning table>choose ‘display
notes’. From there, you will see the notes and be able to give
your own notes too.
SAP SCM Interview Questions
- 14 -
We have a requirement to see and keep track which Alerts
User was worked on.
For Example: we have 19 alerts and want to see on which
alerts (the number of alerts) the user worked on and how
many more remaining alerts he/she needs to conclude the
How do I track, monitor and identify these alerts?
The alerts have status which tells you whether they have
been processed or not. If you look at the alert monitor screen
you will find that there is a prompt whether to accept the
alerts or undo it. Therefore, your option is on ‘alert’ monitor
screen. Meanwhile, ‘alert’ status is stored in a structure. You
can easily do a little research and put these all together to
fulfill your requirement.
SAP SCM Interview Questions
- 15 -
How can I resolve the parameter conversion error when
running alerts?
You can run a consistency check on the alert and then reactivate
SAP SCM Interview Questions
- 16 -
We just started testing APO Optimizer v4.1 and have the
following issue:
EXAMPLE: We have a Sales Order with due dates in the past.
This shows up in the INITIAL column of the planning table
(transaction SNP94). When we run the optimizer, it ignores
these Sales Orders (and any other past due demands). This
action results in Supply Shortages throughout the entire
planning horizon.
Heuristics does consider past due demands. Unfortunately, it
does not meet our needs for developing a constrained supply
How can we fix this problem so that the APO optimizer will
reflect Past Due Demands (Backorders)?
There are some settings in the optimizer profile that are
used when building the model to send to the optimizer. If the
demands are not met when sending the optimizer model, a
value needs to be passed so that the system can recognize
that it is possible to build a pegging link, which can then be
analyzed and incorporate a ‘waiting’ program for possible
backorder delays.
SAP SCM Interview Questions
- 17 -
If not using DP and PPDS, how does SNP Work? I understand
that Demand Plan has to be fed to SNP in order for SNP to
do short to mid term planning. I also assume that PPMs
came thru PPDS and if not using PPDS, we can use PPMs as
APO Master data. If my knowledge of R/3 is accurate, then I
further assume that we can transfer the demand plan from
R/3 to APO and then execute SNP. However, I am not sure if
these assumptions are accurate. Am I on the right track? If
not, can I have some inputs so I may adjust accordingly?
These are some facts about SNP:
1. SNP has CTM, where you could actually use PP/DS
2. For Heuristics you’d need SNP PPMs only if you have inhouse
3. You can plan for Demand (as you said can be transferred
from R/3) as well as sales orders, depending on the above
2 scenarios.
SAP SCM Interview Questions
- 18 -
My CTM run produces no result. I have created PPMs and
assigned them to a model.
I am using standard planning book 9ASNP94. I am able to
see my resources having capacity of 8 hours a day and also
initial demand with stock on hand for my products.
I didn’t make many changes to the CTM engine (all I
mentioned is VERSION) and selected all master data. The
log does not show any errors.
What could be the problem?
Check your master data selection. Incorrect master data
selection reflects no errors in Evaluation and yet does not
produce any planning results either.
SAP SCM Interview Questions
- 19 -
PPDS quantity alerts
I found the results of the PPDS quantity alerts to be difficult
to interpret in a real time business situation. Is there a
way for these alerts for receipts and requirements to be
programmed so as to reflect actual shortage and surplus in
terms of percentages?
The PPDS alerts are based on the pegging situation of the
requirements and receipts. You can change the pegging
windows and the alert windows mode on the demand tab/
pegging sub tab. This will change the results significantly. In
general, set a broad range on the pegging limits that lets the
receipts peg to the requirements. Afterwards, set the alert
limits to see if things are late or early. This should take care
of your concern.
SAP SCM Interview Questions
- 20 -
How to CIF the PPM without operations
We have setup a subcontracting flow. However, I need to
plan it in APO. I need to start from a DP forecast, in PPDS
to create a subcontracted PR (I have the subcontracted info
record in APO) I need a PPM with the BOM. But, I can’t CIF
the BOM (ProdVersion) since it doesn’t contain an operation.
Must a PPM always contain an operation? I don’t need that
operation in APO, for the simple reason that there are no
activities (except for the handling), and the service cost is in
the info record. I would like to know what the best way is to
go about it.
Should I create a dummy WorkCenter, and some dummy
activity, just for the sake of being able to CIF the PPM?
Proceed to create a dummy, infinite resource and a master
recipe with 1 phase with a fast duration e.g. 1,000/hr.
As the PPM is used for the BOM explosion, the details of the
task list are irrelevant.
SAP SCM Interview Questions
- 21 -
We are trying to figure out how to handle a complex
calculation of setup times. We are working in a metal mill
industry and setup times depend on dimensions. This means
that setup is a very big factor for increasing width, but zero
for decreasing width. As far as I know it is not possible to
model something like that using setup groups and setup keys
because this could lead to an infinite number of combinations.
If you also consider thickness or other characteristics like
color and even process characteristics like temperature,
then the whole thing gets too complicated to handle via
setup keys. How can I find a simpler method to approach
this and fulfill the requirement of setting up a program that
will automatically set up complex time calculations?
You might be interested in some SCM 5.0 developments
where the system can generate its own composite matrices
based on matrices that you enter for swaps between
individual characteristic evaluations. I mean characteristic
evaluations, not setup groups. In this development, you can
maintain a setup matrix for setup swaps between thickness
characteristics, and another for length.
The system can then generate a composite matrix that will
have many more entries (but it saves you from doing it), and
it’s possible to specify that the composite swap should either
be the max, sum or badi dependent value with regard to the
SAP SCM Interview Questions
- 22 -
The system also generates its own ‘setup group’ which it
applies to the order that can then be used to build the swap
time for the order in planning.
There are some restrictions, and you’ll need to contact SAP to
get some consulting if you are interested in taking it further.
SAP SCM Interview Questions
- 23 -
No Entry FOR bw_user in the table RSADMIN
I am maintaining a source system in the Administration
workbench of the APO by the Menu Supply chain planning-
Demand Planning-Basic setting-Administrator workbench.
Once I create source system type Sap-r/3 Manual creation
selection and selected the R/3 Destination and logical system
name from the Popup menu, the system indicates ‘No entry
for BW_USER in the table RSADMIN is available’.
When I check for details, the following information is given:
‘No entry for BW_USER in table RSADMIN available;
Message no. RSAR 059
Diagnosis: Missing entry in table RSADMIN
System Response: Process for creating a source system
I then went to the table RSADMIN. It is having entry for BW_
‘Object BW_USER’ and further indicated: ‘Value ALLREMOTE’
When I need to maintain another entry in this table, I plan to
load the data from Sap/r3 Info structure to APO Info cube.
For this I am going to do the following setting:
Procedure: In Customizing> maintain Proposal for Users in
the Source System:
BW Customizing Implementation Guide -> Business Information
Warehouse ->
SAP SCM Interview Questions
- 24 -
Connections to Other Systems -> Connection between SAP
Systems and BW ->
Maintain Proposal for Users in the Source System (ALE
I am concerned though that I might encounter the same
response from the system. How do I resolve this issue?
Check for the following:
1. Verify if you have the BW_USER set up both for the R/3
system and the APO system. They need to have the same
password set for both systems.
2. Double check if you do not have BWREMOTE user. If you
don’t have it, go create a remote user (in IMG) and that
will fix the problem.
SAP SCM Interview Questions
- 25 -
Location transfer via CIF
We have a new plant and we are trying to CIF to APO at CFM2
system. It is showing the error ‘Location does not exist for
external location number EF00, type 1001, BSG’. How do we
correct this error?
First thing to do is to make sure you assigned the correct
logical system (R/3) to a business system group. Secondly,
check the Planning version attached to the plant. It should
reflect ‘000’.
SAP SCM Interview Questions
- 26 -
I need to set the proportion factor between a pack size (level
higher) and product for the entire forecasting period.
Example: Under pack size PK1 give 100% for product A for
months 1, 2 and 3 and 100 % for product B for the remaining
months. This will help me so that after every monthly
forecasting run, the plan numbers are disaggregated to the
correct product (i.e. the active one for that month).
I can make the changes directly to the proportional factor
key figure to achieve the above result but the problem is that
every month, the proportional factors will be regenerated
(i.e. new sales month included) and because of this, the
percentage settings will be lost.
Can anyone suggest a clean approach to handle this
problem? I need for the end user to maintain this and not the
IT maintenance team. If I need to use macros, can you please
give details on how it should work (i.e. the logic)?
There are two possible ways to approach this:
1. Create a new key figure that will hold proportional
factors and make your changes in it. Then copy that to
the proportional factors row using a copy macro. Every
time you regenerate your prop factors, remember to run
a background job that will rewrite the proportional factor
based on the new prop factors row. Don’t keep your
SAP SCM Interview Questions
- 27 -
original prop factors row open to editing. Keeping the
new proportional factors open to edit must be enough.
2. Another solution is to use a new Key Figure. Store values
that you do not want APODPDANT to overwrite in this
KF and allow manual editing for this. Then overwrite
this MANUAL KF with APODPDANT with a mass job
or interactive fashion. Write batch planning books with
minimal rows and macros for the mass job.
SAP SCM Interview Questions
- 28 -
Using fact sheet from one product to
determine sales of another product
The sale of some of our products is based on the sale of
another product. For example: a sale of product A will lead
to 2 sales of product B. So we should not have to forecast
product B since it will be derived from product A.
How do I factor this in APO DP so that forecasting should be
automatic for product B?
Check the DP BOMS. It might present some possible
SAP SCM Interview Questions
- 29 -
Global view of Demand
We have created demand planning areas for different regions
in Europe, Americas, and Asia.
If I want to have a Global view of my demand, what do I need
to do?
Is there a similar concept to a BW multicube available in
APO, kind of a “Multi Planning Area” or something?
You should only create one planning area for different
regions. But since you have already created a Multiplan,
copy the data from one planning area to another to be able
to show them together in data views. Or extract to BW in
different info cubes and create a multi cube on top.
SAP SCM Interview Questions
- 30 -
Deleting product master from APO
How can I mass permanent delete product master (not just
set the deletion flag) from APO? I have tried to use BDC and
done /sapapo/mat1> Mark for deletion but the result comes
out to set the deletion flag as supposed to permanent delete
when you do it manually. Is there another way to do it?
After setting the deletion flag just use the report to delete
product master.
Try this menu path:
Master Data > Product Master > “Delete Products” off the
Extras tab within the Product Master.
SAP SCM Interview Questions
- 31 -
Product Interchange
We have activated product interchangeability function.
We want to have a range of substitution (one to many
or vice versa). For example: A -> B, C ->B with different
validity from date. Currently, system is not permitted when
we create substitution C->B. It states: ‘Error occurred:
Interchangeability not continuous’.
What does this mean?
The problem might have occurred because the assumptions
are not supported. PP/DS only supports linear super session
chains. In a linear super session chain, each product in the
super session chain can have only one predecessor and
one successor. The products in a super session chain are
therefore linked by 1:1 relationships. Super session chains
in which a product has several successor products (1:N), or
several products have one successor product (N:1) are not
SAP SCM Interview Questions
- 32 -
I am trying to create PPMs in APO but then I am not able to
understand as to how to satisfy this requirement. Is there
a way to create PPMs manually in APO without getting
anything transferred from R/3?
If you have the products and the resources created in APO
then you can create a plan (PPM).
First, you need to create the master data product and location
manually. Then you can be able to create PPM manually, or
get the master data CIF ed. One prerequisite of the PPM is
having the master data.
SAP SCM Interview Questions
- 33 -
We have installed SCM 4.1 on windows 64 bits (live cache
I noted that there is no AUTOLOG file on operating system.
I have defined AUTOLOG Medium and it is in status AUTOLOG
ON, but there is no file on operating system.
DEVLog is 2GB and LOG_SEGMENT_SIZE is 85333.
I think there is not a lot of activity on this system (it is not yet
in production life).
But why there is no file on operating system?
What problem could it generate?
I do a DATA backup one time by day and LOG backup 3 times
by day.
I think when I do a LOG backup (and stop AUTOLOG before
and restart it after), the log is empty? (And data are put in
So may be it is normal there is no file in AUTOLOG.
Is it a problem for a restoration of warm backup?
SAP SCM Interview Questions
- 34 -
You will only get a log when the LOG is filled or if you force
it to write it on logs. To force a log switch:
DBMCLI -d LCA -u control, control -uUTL -c autolog_off
DBMCLI -d LCA -u control, control -uUTL -c autolog_on
Create a media:
dbmcli -u control,control medium_put LOGS X:\LOGS FILE
Start backup on disk:
DBMCLI -d LCA -u control, control -uUTL -c autolog_off
DBMCLI -d LCA -u control, control -uUTL -c backup_start
DBMCLI -d LCA -u control, control -uUTL -c autolog_on
SAP SCM Interview Questions
- 35 -
We are now in the process of testing various history data
models to see what forecast APO will give us. So far we were
not impressed with the auto models. Most of the time, they
are just giving us constant models. Meanwhile, the history
data clearly shows a trend and/or seasonality.
How we can make the forecast more accurate and reflective
of relevant trends to enable the auto models to show it?
Forecast models in APO are just the Statistical tools to
help you arrive at forecast. So try playing with the forecast
parameters for better accuracy
In case of Auto Model 2, try the following:
- Use an appropriate forecast horizon (> 2 years) if you
are having a 1 year seasonal cycle;
- Clean the data to get rid of the known values of overselling
or underselling (Promotions/Stock outs);
- Use APO outlier correction and sigma value of 1.25;
In case if you are not satisfied with the APO forecast values
you can also use some external forecast models and bring
the data back to APO using the User exits.
SAP SCM Interview Questions
- 36 -
I am in need of a selection ID in macro to send the information
or save the information in a z table. The objective for this
is to essentially monitor which selection ids are being used
and by whom, in the interactive planning. How do I fetch a
selection ID in macro?
The solution is simple enough. Use table /SAPAPO/TS_
SAP SCM Interview Questions
- 37 -
Live cache returns error 4016 when executed
Live cache returns error – ‘4016 An SQL error occurred’ when
executed (while /SAPAPO/OM03).
It seems that live cache installation program do not create
procedures in MaxDB and are not initialized properly. Is it
possible to somehow initialize them manually? How do I
create a clear instalation procedure?
I am currently using Platform win64, live cache version 7.4...,
SCM version 4.1.
Is it easier to install & run it on win32?
The best way to resolve this is to check initialization log
and go from there. However, since you have SCM4.1 which
is supported only with Live Cache 7.5, you’ll have difficulty
doing this even if attempted on win32. An upgrade review
maybe in order to resolve the issue.
SAP SCM Interview Questions
- 38 -
APO relevance
I am getting one warning message saying that ‘work center/
resource is not APO relevant while creating integration
model’. What does this mean?
During the transmission of PPM, every operation of routing
is checked. If a work center does not have a control key
which shows that it is relevant both for capacity planning
and scheduling, and both formulas are maintained in the
work center to calculate capacity demand and scheduling
time, the system tells you that it is not relevant for APO.
SAP SCM Interview Questions
- 39 -
Stock in transit
How to reflect the values in Intransit key figure of planning
book for SNP (std). I have two location - One is shipping
location A and the other one is Receiving Location.
I have created an STO IN TLB from A location and created GI.
Delivery from location A STO disappeared from the location
A. But I am not seeing any values in key figure in transit at
location A OR B. I have an integration model for stock in
transit active. How do I fix this?
You must create an inbound delivery at the receiving location
for the stock to show up being in transit. The inbound delivery
is SAP’s standard way of showing it in transit.
SAP SCM Interview Questions
- 40 -
Planning book problems
I encountered two problems in my planning book design:
1) I want certain key figures to be input/output and others as
output only in my data view. When I went into design view
of the Planning book and right clicked on the selected
key figure and made it as output, all the other key figures
were also grayed out. Not trusting the design view, I
checked in interactive planning and it is indeed setting
all of the key figures to output only. I further checked
and found there is no grouping on the key figures.
2) Typically, in interactive planning, those time buckets in
the history are grayed out (output only) yet this is not
occurring. I have checked my storage bucket profile and
periodicities and all seem fine.
As far as I am aware this is not a GUI problem, as I am on a
recent GUI patch. How do I resolve these issues?
This can be fixed by going to a newer release of the GUI.
Build 779065 patch 13 add on that comes with the new GUI
and SCM will resolve the issues mentioned.
SAP SCM Interview Questions
- 41 -
SAP SCM Components
As far as I know SAP SCM has APO, EM and ICH as its
components. However, when I checked with on-service.sap.
com, it gave this list?
1. Demand and Supply Planning
2. Service Parts planning
3. Procurement
4. Manufacturing
5. Warehousing
6. Order Fulfillment
7. Transportation
8. Analytic
9. Supply Chain Event management
10. Supply Chain collaboration
I can understand that these are the processes in any supply
chain. But are these all part of mySAP SCM 4.0?
The SCM portal in SAPNet views the Supply Chain
Management as the combination of the SCM components
and the R3 Logistics components working together. That is
the reason why when you open Procurement you get a link
to Materials Management.
SAP SCM Interview Questions
- 42 -
Extending selection conditions for prod
orders in cfm1
The selection conditions for production orders do not meet
the requirements of my customer when the integration
model was generated. I am aware that OSS Note 507696 can
be used to extend the selection criteria for MARC fields in
cfm1. But information regarding this is not readily available
in the production order selection. Is there a way to extend
the selection criteria for production orders
(i.e. with order type AUART)? If utilizing a user exit, which
For the first question on extending the selection criteria
for production orders, I am not aware of such functions to
comply with the requirement. For the second query, you can
try the user exit CIFORD02 with ZXCIFU07.
SAP SCM Interview Questions
- 43 -
SAP SCM Interview Questions
- 44 -
Periodic date Function in Macro
In my date view I got weekly buckets. I am working on a
macro, wherein I need to know the week’s placement in a
month. The week is either the first of week of the month
or the second week of the month. I saw the function which
can give me the week’s position in a year. However, it does
not show the week’s position in a month. I tried using both
MONTH and WEEK function but did not yield the needed
results. How can I derive the requirement of either first or
second week of the month?
There is no direct function to calculate this. However you
can use the functions WEEK {BUCKET_BDATE (ACT_
COLUMN)} for the week period requirement. Use a similar
formula to place the week within the monthly period
requirement. Afterwards, use EVAL to get the desired results
from the above two functions.
SAP SCM Interview Questions
- 45 -
cfm1 (integration model)
I am trying to transfer a plant from R/3 to APO but while
doing so, I am getting the error:
‘Error when creating address of location -- type Production
I have checked the address of the plant in R/3 but I didn’t find
anything wrong with it. What can be the problem and how do
I resolve it?
There are several ways to approach this issue. You may
check any of these:
1) Have you copied the same factory calendars you are
using in R/3 to APO? It is because, if they do not exist in
APO it will not create the location.
2) Check the Time Zones. Ensure consistency between R/3
and APO.
3) This is a slight possibility - do you have Geo-coding set?
If so, have you given the Plant the correct level to define
the Geo-code in APO?
4.) Check up the region code in the location R/3. If there are
special characters ‘o’ with a dot on top, then the plant
can not be transferred to APO. There is a BW setting to
permit that.
SAP SCM Interview Questions
- 46 -
Demand Planning
We are doing implementation for Demand planning (Version
3.0A).The requirement is, they have seven (7) states for
which they want to do forecasting, promotion planning, life
cycle planning, etc. for each individual state based on the
history data of each one. After which they want to add up the
final forecast of all the states and use it for R/3. (There is no
connection between R/3 and APO).
The question is, is it feasible to define seven (7) info cubes
to have history data for each state and seven (7) Planning
books (one for each state) to take the forecast run separately
and then add up all these states’ final forecast to arrive at
a national level forecast? After this, the promotions will be
added again at the national level to arrive for a final forecast.
This will be downloaded and will be sent to R/3.
Is there a way to make it more feasible or easier to configure
rather than doing the run around?
To simplify things and still meet your requirements, instead of
having 7 separate info cubes for each state, you can have the
same results by having a single cube fed from 7 different info
sources (if required). You can then have 7 planning books to
control access for each state and as long as you have ‘State’ as
a characteristic you can then forecast each state individually
but still allow a higher view of the combined forecast within
an overall planning book.
SAP SCM Interview Questions
- 47 -
Currency Conversion in APO DP
I want to convert the volume level data into ‘Value’ by
converting the volume into a corresponding value. One
way of doing this is by maintaining the conversion factor in
the product master and setting the unit of measure in the
planning book. But the problem is I want to show value in
only one key figure and the rest will all be key figures that
should show the volume data only. I also want to show the
Key Figure in currency terms by setting the Info object Unit
as currency. However, it doesn’t display the same way in the
planning book and shows the Planning Area UoM as the Key
Figure. How can I resolve this?
A corollary question is the standard SAP demo shows value
and volume information in the same planning book but I am
not able to decipher how they manage to do it. How can I
find a way to decipher this function?
Try the following measures:
1) Do not define UOM for the Info object.
2) While creating the Planning area, define the UOM as currency
(in the details of Key Figure, Unit of Measure column).
Ideally this should allow you to use the defined Unit.
3) Ensure that you have unchecked the UOM check BOX.
4) Now write a macro to derive the value of this KF.
SAP SCM Interview Questions
- 48 -
Reminders while doing the first four tasks:
1) When you define the KF (in which you have to put the
values), define it as number and not quantity. Say this KF
as KF1
2) Now while creating the Planning area, in the Key Figure
TAB click details and remove UOM check Box. Next to
this will be another column named “Unit of measure”.
Define the VALUE UOM here.
3) Save and generate the time series and the newly defined
UOM will appear in planning book. However, no automatic
conversion will happen here. If the conversion factors
are the same, then you can write a macro to convert. Try
some macros like DISPLAY_CONV_FACTOR or UNIT_
CONV_FAC (I am not sure about these macros) to get
the data from the product master of possible.
If the data ‘quantity’ is uploaded from a flat file to cube and
then to PA, then you can write a small ABAP in the transfer
rules to derive the value in another KF and then upload the
same to PA.
SAP SCM Interview Questions
- 49 -
Loading Purchase info into Live Cache
I have been asked to load SNP data (purchase orders) into
APO 3.10 from a flat file so that the client can view it in the
Planning Book [Live] SNP interactive planning/SNO plan
Is this possible? If so, how could is this accomplished?
You can upload the information using a BAPI -BAPI_
POSRVAPS_SAVEMULTI2. This can be used for the purpose
but you would need the help of an ABAPer to do the task.
Another option is to load them into the planning area as time
series key figures and proceed from there.
SAP SCM Interview Questions
- 50 -
Changing values in a Key figure
I have a requirement from a user wherein he wants to change
the values for the key figure basing on a set of drill down. The
same key figure is computed by a Macro which is a default
macro. Is there a way or a Macro to achieve this? If so, how
is the process done?
If you are using the standard workbook, you can make a
copy of it and use that one instead. Then go to the macro
workbench and change the macro so it does exactly what
you want it to do.
There is a standard macro Drill down (***). Create a collective
macro and put the drill down as first step. Afterwards,
execute the macro. Ensure that the collective macro is the
default macro.
SAP SCM Interview Questions
- 51 -
Year Dependant Fiscal Year Variant in APO
Our client wishes to do demand planning based on a production
month calendar. The calendar is based on 12 periods per year
with some periods containing 4 weeks while others contain 5
weeks. The start date and end of each period is not the same
year to year. For example the “December” production month
for 2005 runs from 27 Nov - 31 Dec, whereas the “December”
production month for 2006 runs from 3 Dec - 30 Dec. I have
created Fiscal year variants for these because the periods are
not consistent year to year. I did this through the creation of
a year-dependent fiscal year.
So I have managed to create the fiscal year without a
problem. However, when I attempt to assign the fiscal year
to the Planning Buckets profile, I get the following error:
‘Input error 8 in row 1: See long text
Message no. /SAPAPO/MA 840’
Further, I managed to create the Storage buckets profile
without a hitch but when I try and create time series objects
for the planning area, I get this error:
‘Period 2006006 is invalid for periodicity P P1
Message no. /SAPAPO/PRP104’
Diagnosis indicated that the period 2006 is not consistent
with periodicity P that was entered in the storage buckets
profile for the planning area. What could possibly be done to
correct these errors?
SAP SCM Interview Questions
- 52 -
After changing the FY, make sure that you de-initialize and
re-initialize your planning area. The definition of the FYV
should be one year more for each in future and past period.
The same applies for the initializing horizon of the planning
SAP SCM Interview Questions
- 53 -
Interactive Demand Planning
Is it possible to disable the selection window in Interactive
Demand Planning? I want the user to work directly with the
data selection already created. Bottom line – I don’t want the
user to load data of his/her choice.
This can be managed with authorizations. Have a look at
note 400434. I think the object you are looking for is APO_
SAP SCM Interview Questions
- 54 -
Collaborative Demand Planning
I am working on collaborative demand planning scenario in
APO and need some clarification on the integration process
between APO and ITS.
1. We have configured demand planning in APO and ITS
has been integrated with APO system.
2. We are planning to give the access to external major
customers to input and share the data.
How can this be achieved? What are the steps to be followed
to achieve this?
You will have to do some prior requirements:
1. First is to maintain the partner settings.
2. Second, you will have to convert your normal DP planning
book into a HTML based workbook including the alerts.
3. Lastly, you should also have a collaborative planning
The second phase of the task is to do a whole of setting
1. Install the Internet Transaction Server (ITS)
SAP SCM Interview Questions
- 55 -
Before you begin with the installation, see the ITS
documentation provided on the Server Components CD
which is delivered together with the software.
In order to display the texts on the initial LOGON screen in
the desired language, you must first set the default language
in the global ITS data service using ITS parameter ~ language
and the language abbreviation of the SAP system.
File Name: global.srvc
Example: ~language EN (for english text display)
Requirement: ITS version 4.6D
2. Publish the Collaborative Planning HTML templates on
the ITS server.
Follow the standard procedure for publishing HTML templates
together with Internet Application Components (IACs) / Easy
Web Transactions (EWT). See the relevant documentation for
ITS and SAP@web-studio or ABAP workbench.
The following HTML service templates are required:
The templates can be obtained in the following ways:
CAR files /File Name: 30a_apo on SAPSERV3
See OSS Note 327567 (2000)
Check out templates from APO 3.0 system using SAP@webstudio
or ABAP workbench (transaction SE80).
See documentation for ITS and SAP@web-studio or ABAP
SAP SCM Interview Questions
- 56 -
You must also install the WEBGUI and MINIALV service
templates that come with the ITS installation package.
Third phase requires more setting changes:
1. General requirements for interactive Supply & Demand
Planning (for ALL types of data exchange)
2. Maintain the following settings.
2.1 Assign a planning book to the user (Demand Planning
® Environment ® Current Settings ® Assign User to
Planning Book)
See also: Planning Book Maintenance
2.2 Assign selection profiles to the user (Demand
Planning ® Environment ® Selection Organization ®
Maintain Selection Assignments)
See also: Selection Management
2.3 Settings for drill down in the Internet planning books
Maintain the header information of the planning view
(Demand Planning ® Planning ® Interactive Demand
Planning ® Settings ® Header Information).
Choose the characteristics for which you wish to enable drill
down and select the Changeable indicator.
This setting must be made by the user. Otherwise the settings
have no effect.
1. Display graphic in Internet planning books
2. Maintain the following data under System ® User
Defaults ® Own Data on the Parameters tab page:
Parameter /sapapo/clp_webgraph, value X.
SAP SCM Interview Questions
- 57 -
In the Internet planning book, you can then show or hide a
graphical representation of your data by clicking.
If you are working with the drill down facility and wish
to hide totals lines for individual key figures, click in the
relevant line.
Then, use these settings for notes in Internet planning
→ Maintain the following data under System ® User Defaults
® Own Data on the Parameters tab page:
→ Parameter /sapapo/clp_webnote, value X
In the Internet planning book, you can then click to switch to
note mode in order to enter notes on your data.
To be able to enter notes, you must use a unique selection
(i.e. you must uniquely identify all characteristics).
Use these settings for the export of data:
>Maintain the following data under System ® User Defaults
® Own Data on the Parameters tab page:
Parameter /sapapo/clp_webdown, value:
XLS (if you want to process the data in Microsoft Excel)
CSV (if you want to process the data using other software)
In the Internet planning book, you can then export the data
Settings for sorting the data in the case of drill down
Maintain the following data under System ® User Defaults ®
Own Data on the Parameters tab page:
SAP SCM Interview Questions
- 58 -
Parameter /sapapo/clp_pivot, value X
When you have chosen drill down for a characteristic, you
can then switch between the following two displays in the
Internet planning book with:
Sorting of data by key figures
Sorting of data by the drill-down characteristic (e.g.
Settings for header lines in drill down
Maintain the following data under System ® User Defaults ®
Own Data on the Parameters tab page:
Parameter /sapapo/clp_rephead, value X
The header line is then shown in the Internet planning book
between the objects for which you have chosen drill down.
Choose a drill down by products and maintained the value
x for the parameter /sapapo/clp_rephead. The data on the
products is then separated by the header line.
Settings for header lines:
>Maintain the following data under System ® User Defaults
® Own Data on the Parameters tab page: Parameter /sapapo/
clp_webbhead, value X
The header line is then repeated as a footer line in the Internet
planning book.
Settings for column width:
>Maintain the following data under System ® User Defaults
® Own Data on the Parameters tab page: Parameter /sapapo/
SAP SCM Interview Questions
- 59 -
clp_row_wi, values S, M, L, XL and ‘ ‘ (default).
This user parameter enables you to adjust the width of the
fixed columns (key figure and characteristic descriptions) in
the event of display problems in an Internet planning book.
Do S and M, if you want to display more columns.
This may result in the descriptions of the key figures and
characteristics being incompletely displayed.
Do L and XL, if you need wider columns for more text.
Maintain APO settings for data exchange between planning
books. Then, define the time series data exchange.
While APO Customizing for workflow, maintain the following
Customizing settings:
→ Create users for external partners
→ Assign user names to the collaboration partners
→ Create a Collaborative Planning Workflow.
→ Supply and Demand Planning via Web access
→ Install the CLP Internet component.
If you wish to view APO alerts, see the requirements listed
SAP SCM Interview Questions
- 60 -
Conversion of PP/DS PPM to SNP PPM
I am encountering complications when converting a PP/DS
PPM to an SNP PPM – that is, the primary resource is not
getting carried over. When I look at the SNP mode, there is
duration but the Primary Resource field is blank.
The resource in question is Multimixed, and the “Not SNP
Relevant” flag is not checked.
After further investigation, I called up the PP/DS PPM and
did a “check plan” - which gave me several errors...namely
“no bucket consumption maintained for resource”....or
something to that effect.
What could be causing these errors? How can these be
When the PP/DS PPM converts to a SNP PPM, it is the bucket
consumption that it uses not the variable consumption that
shows. You will need to add this in your PP/DS PPM.
SAP SCM Interview Questions
- 61 -
Transferring data from R/3 to APO
I was trying to transfer data from R/3 enterprise to APO 4.0.
However, even though I have inferred from help.sap.com, I
still wasn’t able to do this function successfully. How do I
transfer data from r/3 to APO?
Do the following steps:
1. Create integration models for master data and transaction
2. Activate the integration models and select CFM1.
3. Enter the model name> select the logical system > select
APO application.
Then, select each master data and enter the relevant data
for each master data.
4. After creating the model go to CFM2 to activate the
5. Enter the model, logical system, and the APO
6. Execute the transaction.
After these, you will get the model in that page. You can now
select the model and activate it.
Take note that you can create location in APO or you can
make one integration model for location by selecting plant
in CFM1.
SAP SCM Interview Questions
- 62 -
Changing PPMs thru BAPI_PPMSRVAPS_
I want to change existing PPMs by using BAPI_PPMSRVAPS_
SAVEMULTI_30A. After setting up the itabs and calling the
BAPI and the necessary COMMIT WORK everything looks
fine (return - table is empty). However, the values to be
changed stay unmodified (checked through /SAPAPO/SCC03-
transaction). With the debugger, I could find out a place in
the source code where a flag is queried whether COMMIT
WORK should be done inside the BAPI - after switching it on
(= COMMIT WORK inside the BAPI) the new value was set
and showed up in SCC03! Is there any way to turn this flag
on programmatically?
If you wanted to change a field the capacity requirements
structure should indicate:
You would also need to set an X in the corresponding entry
of the additional structure (below):
The German documentation of parameter PPM reads as if
for every entry in PPM a corresponding entry in capacity_
req is needed, independent of whether the capacity_req shall
be changed or not. In fact, this is not true. After leaving out
the capacity_req and capacity_req_x - tables, changes to the
SAP SCM Interview Questions
- 63 -
PPMs should be accepted by the BAPI and written to the
✍ Answer
If you wanted to change a field the capacity requirements
structure should indicate:
You would also need to set an X in the corresponding entry
of the additional structure (below):
The German documentation of parameter PPM reads as if
for every entry in PPM a corresponding entry in capacity_
req is needed, independent of whether the capacity_req shall
be changed or not. In fact, this is not true. After leaving out
the capacity_req and capacity_req_x - tables, changes to the
PPMs should be accepted by the BAPI and written to the
SAP SCM Interview Questions
- 64 -
CIF: Transferring Sales Orders from R/3 to
I am trying to transfer sales orders from R/3 to APO. I am
able to transfer purchase orders, but not sales orders.
Once I activate the Integration Model in R/3, I am not able to
see the sales order in R/3 that has to be transferred to APO.
I am looking at the right place in APO for the transferred
sales orders (/SAPAPO/RRP3 - Product View). What could be
the reason why sales order cannot be viewed?
You need to check some items on this:
1. Check your outbound q in R/3 and inbound in APO. You
will get more explanation there. May be some master
data or UOM may be missing. Check the q errors first.
2. If #1 is not the problem, check whether the integration
model is active and verify the inbound and out bound
SAP SCM Interview Questions
- 65 -
APO Reporting
Does anyone know if there is a way to get at the APO or
Live cache database via some sort of reporting tool without
having to use BW?
I understand that the mySAP suite of products was designed
to have all of the analytics come from BW.
You can use Business Explorer (BeX) which loads on MS
excel - needs to be setup. Or back up planning area data to a
remote cube and read it using list cube.
SAP SCM Interview Questions
- 66 -
Data load into APO-DP planning book from
Is it possible to load data from an Excel file into planning
book in version 3.0A? I know this facility was provided in
APO 4.0 onwards (readings from sap.com).
There is an ‘easy’ way to do it using the normal BIW tools
1. Create a Data Target with all needed characteristics and
key figures.
2. Create a Source System for a PC Flat File.
3. Create a Info source and a Info package.
Now load the Data from the CSV file into the Data Target and
use transaction TSCUBE to upload the data from the Data
Target into the planning area (DP).
SAP SCM Interview Questions
- 67 -
SNP Optimizer take a lot of time running
I’m running the SNP optimizer and the solution is ok at the
end, but it takes a long time in order to get the solution
(around 6 hours).
We are running the optimizer for some like 4,000 SNP orders
with 2 level components.
Besides to check only the required parameters in the
Optimizer, what else can I do in order to shorten the planning
run time?
The running time depends on the optimization technique you
are using. Linear is usually quicker than discretization. If you
are using discretization, then the more discrete functions you
use, the longer it will take. I recommend no more than 2.
SAP SCM Interview Questions
- 68 -
Saving Data in Planning Book SAP APO DP
Do you know how can I recover the Live cache data after
an Initialization has been done? Is there any other option
besides restoring it from the backup?
Are you using Basis? If so, you can always rebuild it from
data in your SAP APO system. It also depends on what was
lost. If you lost order data (snp) and you have a connection
to R3 you can rebuild almost all the results using the CIF and
your R3 connected client. If it is demand planning data that
is only in your dp planning area, I hope you have a back up
info cube of your planning area. It is because from there, you
can reload everything that was lost. If you have not yet made
a back-up info cube of your planning area, then I think your
best option is a system restore to a back-up.
SAP SCM Interview Questions
- 69 -
Undoing a Live cache Initialization
Why is the data not saved in the key figure when the disaggregation
type is set to “N” (No dis-aggregation) in the
planning area? Each time the ‘save’ button is clicked in the
planning book, the data is lost.
If you have dis-aggregation turned off, the only place you
can save data would be at the lowest level. Figure out
where your lowest level is and you’re your data there.
Or you could also try to save data at the level that you had
an aggregate function.
SAP SCM Interview Questions
- 70 -
Product Planning Table set up
I’m working with APO 3.0. Using transaction /SAPAPO/PPT1
(Product planning table) on screen “Product view: periodic”
some PlOrd rows are modifiable (input/output) while some
are not (output only). The PPMs are different. PlOrd-s with
input possibility connects to different resources than others.
I want to modify all PlOrd quantity. What is missing here?
Check the resource operating time assigned to resource. The
planed orders connecting to resource are used as output only
in the planning table if no time is assigned.
SAP SCM Interview Questions
- 71 -
One or more planning areas/book in DP
I have 10 different countries set up in my system. Each of
them has their own demand planners. I have set up a planning
area and a planning book for one of them and my idea is to
set up identical planning books and areas for the rest. The
result will then to produce 10 different planning areas with
the same exact structure.
I want to know if that is the best practice (or option), or shall
I try to set up just one planning area for all of them? If so, are
the users going to be blocked when they start working?
I would recommend one planning area/book. You can control
who accesses data via the selection profiles. As long as the
selection profiles don’t overlap, the users will not be able to
lock each other out.
There are some things that you have to look out for though:
1) If there is any change in process requested by a single
country it would become difficult to manage considering
the fact that all other countries also share the same
2) Using a single planning area and POS will also increase
the CVCs handled and can cause a lag in performance.
3) The data management will be a bit tricky and functions like
realignment (if required) should be handled carefully.
SAP SCM Interview Questions
- 72 -
4) Impact of mismanagement (scheduling a wrong
background job for instance) would me on higher side
with such set of configuration.
Given the above, you can evaluate the pros and cons of both
approaches and go from there.
SAP SCM Interview Questions
- 73 -
Assigning characteristic value for PPMs via
I’m trying to find a way to automatically assign characteristics
to the PPMs when CIF occurs. How can this be done?
Try developing a user exit for the note 495825.
SAP SCM Interview Questions
- 74 -
SNP standard planning areas- issues
I encountered some issues while doing SNP standard
planning areas:
1) The default UOM assigned to 9aSNP02 is PC, we don’t use
that unit of measure. What is the best option to go about
it? I need to create a new planning area of 9aSNP02.
2) When we initialize 9asnp02 it doesn’t ask for a date from
and to, like it does for 9aSNP01. Is this normal?
3) Initialization of 9asnp01 takes a long time while 9asnp02
is done in a few minutes. Why so?
The responses are numbered accordingly:
1.) Yes. Create a copy of the 9ASNP02 planning area and
change the default UoM.
2.) The planning area 9ASNP02 is an order based planning
area and therefore doesn’t require a time series like
3.) This is related to the generation of time series (see
response to number 2).
SAP SCM Interview Questions
- 75 -
APO -DP Inability to track quantity changes
in forecasts
APO - Demand Planning
Does anyone know if there is a method to track quantity
changes in forecasts? When a person changes an entry in a
planning book, the system does not automatically create a
historical record of the change. Does anyone know if there
is a way to handle the changes?
There can be two (or more) solutions, depending on your
exact requirement.
If you need to capture the how, what, and when of a forecast
change, you’ll need audit trail functionality. Although no
such functionality exists out of the box, it can be developed
using macros. You can create a default macro that validates
whether a key figure value has changed. If it does change,
you can create an entry in a z-table that records the original
value, the new value, the user, and the date (or any other
data you might need). Then create a BW report that reports
this data.
If you just need to capture the values of all key figures at a
periodic interval, extract the planning area contents to an Info
Cube. By using a timestamp for the extraction period, you
can run reports that compare the values of key figures during
points in time. This is normally called a waterfall report.
SAP SCM Interview Questions
- 76 -
Key figures in Planning book
I have created a Planning book with all custom key figures.
I want certain key figures to be input/output and others as
output only (so that they are grayed out in the book). When
I went into design view of the Planning book (from the
planning book) and right clicked on the selected key figure
and made it as output only I was surprised to see that all
the other key figures also were grayed out (in the sense, the
input output key figures that really needs to be made as input
key figure was also grayed out). I checked and there is no
grouping. Is there any grouping at Planning book level for
key figures?
You should have the latest SAPGUI patches and SCM Add-in
patches. This will solve the problem.
SAP SCM Interview Questions
- 77 -
ATP Horizon
Any idea where we can define the ATP horizon? For example,
the period for which ATP check would be carried out. I
believe it must be somewhere while initializing the ATP time
series. Where can I find this function and how should we go
about it?
The ATP Checking Horizon is defined per product/location
combination in the Checking Horizon Field on the product
master. Remember to use an ATP Group that takes the
horizon into account
SAP SCM Interview Questions
- 78 -
Dynamic pegging
How do we change the dynamic pegging relationship
My problem is I have stocks dynamically pegged to say sales
order no 1.
Later on I have a sales order no. 2 which is to be confirmed
and delivered before sales order no 1. The system doesn’t
confirm any quantities due to the fact that the quantities are
dynamically pegged to sales order no1.
How can I change the dynamic pegging relation?
You can do it from product view. Double click on element to
go to details. Over there you can see the details of pegging
relationship, and you can also see alternatives for pegging,
which you can fix.
From your description though, it seems this is not a pegging
issue, but an ATP issue. If the above does not work for you,
try using Tcode /SAPAPO/BOPI to switch confirmation from
one order to another (If you are using Global-ATP, otherwise
you should use CO06 in R/3).
SAP SCM Interview Questions
- 79 -
I have encountered some difficulties regarding uploading
text and master data in BW Info Object. My client wants to
create his own report on the BW embedded on APO (3.0).
For example, 9ALOCNO has the code but contains no
description nor attributes. What kind of activity is necessary
for it to work in APO? Do I have to create a custom data
source reading /SAPAPO/* tables?
You can load text since 9ALOCNO has a text table. But you
can’t load any attributes. It is because 9ALOCNO does not
have any attributes in its definition.
SAP SCM Interview Questions
- 80 -
/SAPAPO/TSM 219: Invalid Data Status
When I try to load a particular product group in the planning
book, I am getting the following Error Message. This happens
only for 3 product groups but it works fine for the rest of the
other product groups:
‘/SAPAPO/TSM 219: Invalid Data Status.’
This Error should not occur during normal processing. If it
does occur, contact the System Administration or call the
SAP Hotline Number.
Application Area: /SAPAPO/TSM
Message No: 219
Is this a functional/configuration/master data problem or
does it have something to do with System Administration or
support packs?
There are numerous reasons why this can occur. Data
inconsistencies in the system are usually the main culprit.
The solution will depend on the exact functionality that
is causing the message and also your APO release/service
The best bet for you is to go onto SAP service place and do
a notes search on that error message number and then apply
the notes that are relevant for your release/patch level.
SAP SCM Interview Questions
- 81 -
Usually the construction check program repairs the LC
errors with invalid data status. Run the program /SAPAPO/
TS_LCM_CONS_CHECK with the ‘Repair’ option.
SAP SCM Interview Questions
- 82 -
User Exit for /SAPAPO/TS_PLOBS_
In order to create Character Combinations (CC) in the
background, it is possible to use the standard report “/
SAPAPO/TS_PLOBS_GENERATE” on the basis of an info
The report also offers obviously the possibility to use a user
exit. However, I can’t find the right user-exit. Where can I
find the right user exit?
Use the BADI: /SAPAPO/SDP_MASTER exit for your purpose.
SAP SCM Interview Questions
- 83 -
Forecast in weeks and months
My time bucket profile is 12 months of which the first three
months are in weeks and the rest are indicated in months.
The last week of the current month is common between
current month and next month.
For example:
Technically the last day of week 4 of August 2005 is September
2005. How can we make the system consider Aug 31st as the
last day of week 4 and Sept 1st as the beginning of the new
You can use the fiscal year variants and associate them with
your storage bucket profile. This will produce the results you
are looking for.
SAP SCM Interview Questions
- 84 -
Blocked stock in APO
We are implementing APO 3.1 with SAP R/3 4.7. Blocked
stock is not recognized in APO 3.1 as available stock. I know
that it is recognized in 4.x but we can’t upgrade to 4.x at
present. So, I am looking for some help. How do I resolve
the blocked stock in 3.1?
You can use the exit described in note 487166 for enhancement
of APOCF011.
SAP SCM Interview Questions
- 85 -
Classification view of Product master in
We would like to use the Characteristics in the Classification
view of the product master in APO. Normally, when I
create a characteristic in R/3 and attach it to a class within
the classification view of the Material master, the relevant
characteristic will be displayed out - of which I can select a
For example:
If my Characteristic is color that I have attached to a class,
when this class is called in the Classification view of the
Material master, the Characteristic is called in which I can
either select RED or YELLOW etc. But in APO, I have done
the same thing by creating a Characteristic, attaching it to
a Class. However, when I called the Class in Classification
view of the product master and clicked the details icon, I
see only the Characteristic Name (but not the values) which
means that I cannot assign a value to that particular part
number (product) in APO.
I am not sure where I went wrong in any step. How do I
determine where I went wrong and how can I fix this?
Note that I have tried transferring the Class & Characteristics
using CIF - that too didn’t work. We are in APO3.1.
SAP SCM Interview Questions
- 86 -
You need to maintain the Customizing in R/3 and the same
in APO as the Customizing are not CIFed throughout the
Integration models.
Please enter the organizational area at the level of the Class
and at the level of individual characteristic identifying it as
those that are supposed to go to APO.
In APO, select the table /SAPAPO/MATKEY and choose
Organizational Areas.
Choose ‘new Entries’ to create organizational areas. If you
have not maintained the system, it will still transfer but you
may not be able to display the input.
These things are primarily done since these customizing are
not transferred through CIF.
SAP SCM Interview Questions
- 87 -
Stop live cache versus stopSAP
My question is regarding the activation of a parameter change
in Live cache.
Will stopping (stopSAP ALL) SAP have the same effect as
stopping Live cache to activate the parameter change? Or is
it entirely different?
Do changes to Live cache parameter require stop&start
Live cache only? Can it possibly be activated even after a
If you restart just the lc, then that is all you do - restart the
Live cache.
If you do a ‘stopSAP ALL’ then it depends:
As of SCM 40, then everything is stopped, including lc.
However, be careful with earlier SCM/APO versions - only the
app server and underlying database (i.e. oracle) is actually
stopped - the Live cache is still there.
You should have no reason to restart the whole system
just to activate some lc parameter changes. Simply use the
functionality in LC10. It is also safer than using the DBMGUI
(especially with older lc / APO versions).
SAP SCM Interview Questions
- 88 -
Live Cache to APO tables
I need to know if there is a function modules/BADI that reads
the data from Live cache to APO tables.
For Example:
How does the SA line derive from the Live cache and stored
in transparent table?
COM routines are called from the ABAP function modules to
perform actions on any lc data which is stored in the object
oriented data areas. For all other (relational) data you can
use native SQL calls.
If you want to view the lc data you can use /SAPAPO/OM16.
SAP SCM Interview Questions
- 89 -
Connection between Live cache & BW
We have separate Live cache server, APO server and BW
server. The process we follow now is that after running
different programs in Live cache for demand planning, we
load the data to a cube (say cube xyz) in the APO server for
back up of the Live cache data. We then load the data from
cube xyz from the APO server to a cube in BW server for
Is there a way to load data directly from the Live cache to
BW, without loading the APO server? If yes, what do I need
to do in Live cache to set up the connection to BW?
You need to define your planning area in APO as a data source
for BW. IN APO, run transaction /SAPAPO/MSDP_ADMIN
and right click on your planning area. Use option ‘generate
data source’. In BW, in transaction RSA1, select APO as your
source system, replicate to see the data source you have just
created and build your system from there on.
However, if you mean connecting the Live cache directly to
the BW system, instead of saving the planning results into the
local APO system then copying them across to the remote
cube, then No, you definitely can’t!!!
SAP SCM Interview Questions
- 90 -
Stock in transit Upload
Can anyone tell me what BAPI or RFC can be used to upload
Stock in transit data from the External source?
Take BAPI_GOODSMVT_CREATE plus an integration
Stock would be entered into the R/3 system via a goods
movement created by the above BAPI and an integration
model would transfer the stock information to APO.
SAP SCM Interview Questions
- 91 -
Changing a resource in a Heuristic
I am using a Customer Heuristics in which I change the
resource for a specific order operation before the Function
When I debug the Function I noticed it calls another
Function “/SAPAPO/OM_ACT_SCHEDULE”. This function
in turn connects to Live Cache & calls the stored procedure
“SAPAPO_PT_ACT _SCHEDULE2” with the changed resource
data. However, it schedules the order operation with the
wrong resource.
I assume that the stored procedure uses the resource data
found in Live Cache and not the data passed to it by the last
How do I solve this problem?
My first guess is to change the order prior to calling the “/
What function do I use (if at all) to change the order?
In the Internal Table containing the Capacity Requirements,
you should also change the MODE_NO to -1 prior to calling the