SAP APO Interview Questions

SAP APO is widely used by many companies for supply chain planning and optimization. By acquiring skills in SAP APO, you can enhance your career prospects, especially if you are interested in supply chain management, logistics, or operations management roles. This article will discuss the top SAP APO Interview Questions that will help you ace even difficult interviews and land your dream job.

Rating: 4.5
15661

If you're looking for SAP APO Interview Questions & Answers for Experienced & Freshers, you are in the right place. There are a lot of opportunities from many reputed companies in the world. According to research SAP, APO has a market share of about 1.6%. So, You still have the opportunity to move ahead in your career in SAP APO. MindMajix offers advanced SAP APO Interview Questions 2023 that help you in cracking your interview & acquire your dream career as an SAP APO Developer.

Top 10 Frequently Asked SAP APO Questions 

  1. What is Release Profile?
  2. Do dynamic alerts show up in Alert Monitor?
  3. What is the shortcut to changing location type in APO?
  4. How to copy a Process Chain?
  5. How does the user create a planning book with two tables?
  6. How do I fix these errors?
  7. Loading text and master data
  8. Storage bucket profile
  9. How many databases into the APO system?
  10. How to find out whether one organization uses multi-org or single-org?

SAP APO Interview Questions For Freshers

1. How can a planning version be frozen and unfrozen?

A Planning Version can be frozen and unfrozen using Function Module /SAPAPO/TS_PAREA_VERSIO_FREEZE so that no further changes to the planning version can be done.

2. What is Release Profile?

Release Profile is used to release timeseries data from DP to SNP/PPDS. You need to define the DP Planning Area and time series key figure the data in which is released and the SNP Category Type (typically FA) to which data is released. You may maintain a Daily Buckets Profile it will define the number of working days (working days determined based on Shipping Calendar maintained for the location master) starting on and from the From Date if released online/ interactively or that many workdays of the planning horizon when release is carried out in the background. The Period Split (blank, 1 and 2) field in the SNP2 tab of the location-product master determines how the demand plan is released to SNP from DP (how bucketed data is disaggregated to the workdays).

3. What is the usage of Period Factor?

Period Factor maintained in the SNP PPM or Transportation Lane determines the Availability Date of a Receipt element within a time bucket (period). The system determines the exact availability date/time of the receipt elements within a period, by adding a time interval (that it gets by multiplying the period factor with the period length) to the start time of the period. You can enter a factor between 0 and 1, where 0 is the start of the period, 0.5 the middle, and 1 the end of the period. When calculating the availability date/time, the system takes into consideration all weekdays, meaning that it does not take into consideration any days that have been defined as non-workdays in the calendars.
The period Factor used is .71 = 7×0.71 = 4.97 or 5 days from optimizer of the weekly bucket resulting in a Friday.
If Period Factor is not maintained in PPM or Transportation Lane then the User Period Factor indicator and the Period Factor value maintained in the Lot Size tab of the location-product combination is used. If this is not maintained a default value of 0.5 is used.

4. What determines stock categories displayed in the Stock on Hand key figure?

The categories defined in Category Group ST1 (can be maintained in table /SAPAPO/APOCGC) determine the stock categories that are displayed in the Initial bucket in the Stock on Hand keyfigure. Subsequent buckets are dynamically computed.

MindMajix Youtube Channel

5. Does dynamic alerts show up in Alert Monitor?

Dynamic Alerts do not show up in the stand-alone alert monitor. Network alerts are to show pegging relationships.

6. What is the report to execute MASSD?

The report for executing MassD in the background job is MASSBACK.

7. What is the shortcut to changing the location type in APO?

Report /SAPAPO/CHECK_LOCATION_TYPE can be used to change location type (say from 1001 to 1002 or vice-versa) of existing locations in APO. The table to refer is /SAPAPO/LOCMAP. SAP does not recommend this process.
Remark: Can you check if this works – cos I think you need to use/SAPAPO/CHANGE_LOCTYPE

8. How can a transaction be executed even when no authorization?

SE93 – Transaction code for Transaction Code E.g. CRC1 Create Resource has txn code CRAH. So if you do not have the authorization to create a resource you can use SE93 and enter txn CRAH and then the Test F8 button to go to the txn.

9. How to copy a Process Chain?

To copy a process chain to another process chain, go to the Process Chain you want to copy and then type copy in the tool tar and hit enter. It will allow you to copy the Process Chain to another Process Chain that can be modified as per the user’s requirement, saved, activated, and used.
Remark: To copy a process chain to another process chain, go to the Process Chain you want to copy and then type copy in the tool tar also… if you dropdown on the toolbad under process chain you have a copy option… but this looks cool

10. What is the process to copy planning versions in R/3?

Use OLIX to first delete previous MRP planning versions. Then use MCB& to create the new MRP planning versions by choosing the appropriate version you want to create as ICO Version. The info structure, in this case, is S094.

11. How to use create a planning book with two tables?

To use two tables on one screen of Planning Book/Data View – select the indicator next to the second-page title and give a name. An additional tab page is displayed in the Planning Book Maintenance wizard to define the key figures for the second table.

12. Data load errors

“I am getting the following errors in the data loads In the APO Quality system during monitoring checks: This is a quality client copied system from the APO production system.

  • There is no PSA for info source LISVCIT and source system AP900.
  • A system error occurred (RFC call).
  • Activation of data records is terminated.

SAP APO Interview Questions For Experienced

13. How do I fix these errors?

You actually describe 3 different problems. To solve the first error, check that the InfoPackage is not loading directly into the InfoCube. Make sure that it is loading to PSA first before going into 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 basic team to rectify RFC errors. If all efforts don’t lead to the desired results you probably will have to open an OSS message to SAP.

14. Sales History for DP

Having the Sales History stored in APO does not necessarily mean that you have duplicate data. The central BW (non –APO) is the leading system where the Sales History is stored. The only reason why it is “stored” in the APO-BW is to load it into liveCache. Typically Sales History in APO is updated at the beginning of each planning cycle (e.g. over the weekend) and the previous week's one is deleted.
- If you want to avoid having Sales Order History data stored in an InfoCube in APO you can use a remote cube in the APO BW. For example, the Sales Order History Cube is maintained in the main BW System and a remote cube is created in the APO BW system based on the Sales Order History cube in the main BW system.

15 No Entry for BW_USER in the table RSADMIN

In a situation like this, you should check for the following:
- Verify if you have the BW_USER set up for both, the R/3 system and the APO system. They need to have the same password set for both systems.
- Double-check if you do not have a BWREMOTE user.  If you don’t have it, go create a remote user (in IMG) and that will fix the problem. Depending on your authorization set-up, this task might have to be performed by your Basis or Administration team.

16. Loading text and master data

No, you should not have to create a custom data source to read the /SAPAO/* tables. You should be able to load text since 9ALOCNO has a text table and in Interactive Demand Planning, you then would be able to see both, the code and the text.
- If you are using the standard SAP APO object 9ALOCNO, however, then you will indeed have no attributes since this InfoObject doesn’t have attributes defined and hence you can’t load any attributes (codes or texts). What you could do, however, create a new InfoObject, i.e. ZALOCNO, as a copy from 9ALOCNO and add the attributes you need for your planning scenario.

17. User Exit for /SAPAPO/TS_PLOBS_GENERATE

Use the BADI: /SAPAPO/SDP_MASTER exit for your purpose. This should solve your problem.

18 Creating a new key figure for a planning book

If the 2 functionalities (“Administrator Workbench” and “Administration of Supply and Demand Planning”) required to create a key figure for a planning book are mixed, like in this question, you should watch out. It might either be because the questioner doesn’t have a strong APO Demand Planning knowledge or it is intended to be a trick question!
There are 2 possible solutions, depending on the purpose of the key figure. If the new key figure is only needed to show the result of a macro calculation but there is no need to save the result, you should use the auxiliary key figure within the planning book. No other points to watch out for and no other actions to be taken.
If the new key figure is supposed to hold data (as a result of a macro calculation or a manual input), which needs to be saved, you need to create a new liveCache key figure.
The first step is to create the key figure InfoObject in the Administrator Workbench (RSA1). It is not possible to assign a key figure to a planning book from the Administrator Workbench!
You will have to add the new key figure InfoObject first to the Planning Area before adding it to the Planning Book. To change the Planning Area you use the “Administration of Demand and Supply Planning”

  • (/sapapo/msdp_admin).
    As of SCM 5.0 you are able to add – and even delete – a key figure from the Planning Area without deactivating it as long as the key figure is not in use in a planning book or macro.

  • In any previous SCM version you will have to work around the fact that you can only chance INACTIVE Planning Areas. To deactivate the Planning Area you will have to delete the time series object, which will cause the loss of ALL planning data. In order to preserve your production planning data, you will have to backup it into an InfoCube.

  • AFTER the data is backed up, you can proceed to deactivate the Planning Area. Right-click on the planning area and select “Delete Time Series Objects”. After confirming the warning message the icon next to the Planning Area will change from a green circle to a red square. The Planning Area is now inactive and you can add the new key figure InfoObject.

  • After you have done the required changes to the Planning Area you can initialize a new time series and you can upload your planning data again from the backup InfoCube.-

  • As the last step you enter the design of the planning book and add the new key figure to your planning book and planning view. After activating the changed Planning Book you will see the new key figure in your Planning View.

  • Ideally, this should be done in your DEV environment first and the changed Planning Area and Planning Book should then be transported into QA and Production. PRIOR to transporting you have to back up the planning data to avoid data losses!

19. Characteristic drill down

This is very easy to achieve because all you have to do is change the pivot sorting. You can do this by right-clicking on the name field of your planning table and select Pivot sorting.

  • It might happen that Pivot sorting is grayed out. Then you have to make sure your header row is on and “Details All” is selected for a characteristic, you’re for your product. This is required before the system will allow pivot sorting.

  • In previous APO versions, Pivot sorting couldn’t be saved and the users had to set up their sorting every time they entered a planning book or loaded data. As of SCM 4.0, Pivot sorting can be saved user-specific and as of SCM 4.1, even a Pivot sorting for key figures is possible.

  • If your business process requires the users to drill down to the “work” level they either can use the interactive drill-down functions via the head or the shuffler or you can develop a macro that would bring the user straight to the “right” level. In general, you should test the performance of your drill-downs.

20. Storage bucket profile

It is common practice to activate the “Storage Bucket Profile” several years out prior to a go-Live – exactly to avoid this situation. The activated horizon should give you about 10 years of planning horizon where there wouldn’t be a need to carry out a “Storage Bucket Profile” maintenance. When setting up the storage bucket profile keep also your intended planning horizon in mind.

  • If you have reached now the point in time to carry out a Storage Bucket Profile maintenance, however, it also might be a good moment to analyze a possible upgrade to the latest release._

  • If a Storage Bucket Profile maintenance can’t be avoided, however, 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 MPOS, Storage buckets, and planning buckets. Planning books will also get transported if you do not remove them manually from the transport request.

  • If you don’t want to transport the new settings to your production system you also could just change the storage buckets directly in production. Depending on your system setup you might have to “open” it for this step, which might not be an option.

  • In general, I would suggest being consistent: transport as much as possible and do a few changes in the production system. As of SCM 5.0, you also have several new options when performing transports.

21. Inputting a Macro Note

A rather simple question which is a little tricky to answer. In the Macro Workbench, select the row with the Planning Book/View that contains the macros for which you want to create notes so it is highlighted. Now do a right-click and select “Display Macros” from the menu.

  • Now the screen splits and in the bottom half, you see your planning book with all the macros in it. Right-click on the macro for which you want to attach a note and select “Edit Macro Note”.

  • The screen splits in half, this time vertically, and on the right side, you have now the chance to enter a note about the macro. Edit your note and don’t forget to save it before you leave the screen using the button “Close All” ( )

Note:

The question is only referring to attaching a note to macro and not to a cell in the planning grid! To add a note to a cell to the planning grid you load the data, right-click to the cell you want to add the note and chose “Display Note”. On the bottom of the screen, a window appears where the user can enter his notes or read other users' notes. An icon, as well as the cell color (standard setting), will indicate if the cell contains a note.

22. Proportional Factor

There are two possible ways to approach this:

  • Create a new key figure that will hold your proportional factors and make your changes in it – or simply just the values that you don’t want APODPDANT to overwrite.

Then copy this key figure back into APODPDANT using a copy macro. Every time you regenerate your prop factors, remember to run a background job that will re-copy the manually adjusted proportional factor back into APODPDANT. Don’t keep your APODPDANT key figure row open for editing. Keeping only the manual proportional factor key figure open to edit should be enough.

  • Instead of having macros copying values back and forth you also could try to disaggregate APODPDANT as well as the key figures you want to disaggregate based on a manual maintained “new proportional factor” (NPF) key figure. That way you only use APODPDANT as a reference and copy it to NPF using a macro only when and on whatever you want it. All changes are made in the new proportional factor key figure.
 Explore SAP APO Sample Resumes Download & Edit, Get Noticed by Top Employers!  

23. How many databases into the APO system?

SCM APO has 2 databases.

1. Data Base server- master data stored.
2. Livecache server- Transnational data stored.
The first one is in BW as Info Cubes and the second data is stored in Live Cache. The data stored in Live Cache is used for planning and processing during transactions. Cubes are only for storing data and backing up data. The whole reason for making APO a different server (box) is to make the process of simulation faster using the Live Cache memory database which is faster than accessing the data stored in tables in other ECC modules.

24. How to find out one organization using multi-org or single org?

If I am not wrong looking at the company code available on the system will tell us whether its a single or multiple organization.

About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read less