Target Group  SAP PP User and IT Professionals

Summary

The BOM Browser with Master Data Check got even better 🙂

Content

My Add-On BOM Browser with Master Data Check meats considerable customer demand and I implemented enhancements:

  • Multi-plant selection
  • Optional cross-plant BOM explosion. Stock-transfer via special procurement key is treated similar to an extra BOM level. The BOM explosion proceeds in the supplying plant.
  • Display plant stock
  • Visualization of phantom assemblies, subcontracting, stock transfer and regular in-house production with icons
  • MRP Area specific BOM explosion via production version determination and storage location determination
  • Separate counters for WM control cycles and Kanban control cycles
  • Additional report for material evaluation with master data check without BOM explosion. This report contains more material data and is ideal for fast and flexible material evaluation with focus on checking PP/MM master data and viewing material details.
  • Settings for reaction on missing production version or source list: Error, Warning or No Reaction
BOM Browser with Master Data Check – Tree View
BOM Explosion with Plant-to-Plant-Stock_Transfer
Visualizing different types of assemblies: Subcontracting, Phantom Assemblies, Stock Transfer, Normal Inhouse-Production

You find more info here.

I’m looking forward to comments and questions.

Do the SAP standard transactions for mass evaluation of BOMs satisfy your requirements?

How robust is your workflow for creation and maintenance of materials and related master data for production and procurement? How useful would be a mass evaluation of materials with existence information (in form of counters) for assigned master date (routings, BOMs, source list, infor records, control cycles, production versions) for you?

Would you see the benefit of using the BOM Browser with master data check mainly in

  • Master Data Mangement for checking existence of critical master data?
  • In Product Costing for viewing multi-level BOM structures across plants, with plant stock and valuation data?
  • In Logistics, e.g. for monitoring stock in BOM structures or checking existence of WM or Kanban control cycles?
  • In Production Planning as an overview of BOM structures with stock and MRP parameteres. Maybe enhanced with coverage data or summarized requirements and receipt

Do you have ideas for other use cases or improvements?

Download and Upload ALV Layouts

Target Group

SAP Professionals, SAP Key User

Summary

Free report for downloading and uploading ALV Layouts. The report is available on github.

Motivation

The SAP standard allows to transport user independent ALV layouts and to copy ALV layouts to another client in the same system.

However it sometimes happens that you can’t transport to the system where the ALV layouts are needed. I haven’t found a solution for this with SAP standard transactions or via business configuration sets. Internet searches returned some coding fragments which only helped to a small degree.

So I developed a report and provide it free of cost with the so-called MIT Licence via Github.

The report is implemented in an old-fashioned way without using any newer ABAP elements in order to support all usual releases of SAP ERP and S/4HANA. I tested it in ERP 6.0 releases with SAP APPL 6.05 and 6.17 and in S/4HANA 2020 with S4CORE 105. Original language is English, with German translation.

Use Cases

  1. Copy user dependent or independent ALV layouts from one SAP system to another. The systems can have different releases.
  2. Backup and restore ALV layouts.
  3. Copy ALV layouts from one report to another, e.g. after copying or renaming a customer development.

Documentation

Report ZST12_ALV_LAYOUT_UP_DOWNLOAD asks for a report name, a local path name and the choice between download or upload.

Download – Export to local files

All layouts for the report are proposed for download. User dependent layouts are included. You see all existing ALV layouts even if the report uses multiple ALVs with different HANDLE keys.

Field catalog, layout setting, language dependent short texts, sort and filter criteria (if existing) are exported in separate files. The file names are generated automatically.

(1) Selection screen – Download
(2) Popup to select layouts for download
(3) Download Protocol

Upload – Import from local files

The downloaded layouts in the specified folder are proposed for upload to the target report. Source report, source system, layout ID, layout description and download date are automatically determined from file name and content.

(4) Selection Screen – Upload
(5) Popup to select layouts from the local folder for upload
(6) Option to put uploaded layouts in a transport
(7) Upload protocol

Restrictions

  • The imported layout overwrites an existing layout without warning
  • No consistency check when importing layouts to another report
  • No existence check for the user if you import a user dependent layout
  • Currently no function to import a user dependent layout to another user

Coding

The current version is available on github. You can download it with abapgit, other git clients or manually:

www.github.com/Martin-Preiss/SAP_ALV_LAYOUT_DOWNLOAD_UPLOAD

Classic Kanban in S/4HANA – first Test

Target group Anybody with basic SAP PP knowledge and interest in Kanban

Summary:  Kanban test description for classic Kanban in S/4HANA. There is a change compared to SAP ERP caused by the termination of the ‘Storage Location excluded from MRP’ function in S/4HANA and the Kanban board is available as Fiori UI5 app. Otherwise Kanban is the same as before

I have a subscription to a S/4HANA 2020 system from MMC and do some tests and development there. My first Kanban test covers external procurement for bulk material with classic Kanban.

We want to consume the material from a production storage location without WM. The vendor delivers it to the supply area in Kanban boxes with 1000 PC each. We chose not to plan procurement by MRP but to trigger the supply by Kanban impulse (setting Kanban to Empty).

I assume that the start situation in my system is as delivered by SAP so I mention the org units used. I start with customizing a storage location 171P ‘production storage location’ for plant 1710 with supply area ZST12_01.

Then I created material ZST12_BULK with material type ROH, set bulk indicator and MRP type to ND (no planning). And maintained a purchasing info record for supplier 17300003. Creation of Kanban control cycle follows: Here we have to overcome a hurdle which probably is deterring quite a few potential Kanban users. After selecting replenishment strategy type ‘external procurement’ you can only select PDA7 ‘Summarized JIT Call (MRP, Alerts)’ as strategy. Why don’t we see an entry for procurement with purchase orders? The entry exists in customizing. The reason is that SAP shows only the strategies which are considered to make sense. In this case only replenishment strategies can be selected which should be used in combination with MRP.

Procurement Strategies with MRP (despite material having MRP type ND on plant) level

(Remark as software developer: Well-meant restrictions of input options are helpful only it the restriction logic is obvious for the user. Otherwise it is better to allow the user to select invalid input and explain in a error dialog why this input is not valid in the given context. This informs the user in which context the requested option would become available)  

The strange thing here is that my material isn’t planned by MRP (due to MRP type ‘ND’) so the SAP behavior looks wrong to me here. It would expect it to take the MRP type on plant level into consideration.

The solution in SAP ERP would be to exclude the storage location of the target supply area from MRP. We can’t do this in S/4HANA. Excluding storage location from MRP by setting the ‘Storage Location MRP indicator = 1 in the material master MRP 4 view is not supported anymore. You need to use a storage location MRP area.

So I created MRP Area 1710-171P for storage location 171P, assigned the material and set MRP type ‘ND’ in the MRP area parameters.

The MRP type on MRP area level is taken into consideration (as the MRP type on plant level should be as well) and I can create the control cycle for classic Kanban with purchase orders.

procurement strategies for external procurement without MRP
Kanban Control Cycle for external procurement with purchase orders

After assigning a printer I immediately can print Kanban cards with the SAP default layout.

Kanban card printout (SAP Default)

In PK13N (Kanban board, Demand view) I try to set the first Kanban to empty. This fails with message ‘In case of evaluated receipt settlement, please enter tax code’ and the Kanban goes to error status. This makes sense, so I add the tax code in the info record and repeat the status change with the Kanban Correction function (‘Do you want to repeat the failed status change?’).

Now the purchase order is created:

Kanban Detail for Empty Kanban with Purchase Order

Kanban Status Change to Full posts the Goods Receipt to storage location 171P and after further Status Changes and tests with other materials my Kanban board looks colorful:

Kanban Demand View with further control cycles
MD04 for the Kanban example

Conclusion: No surprises. Kanban functionality is the same as in SAP ERP, with the exception of the change due to the replacement of ‘Exclude Storage Location from MRP’ by MRP area.

(Further Kanban tests confirmed this).

Finally I have a look at the Fiori Apps. The Kanban board is available as new Fiori UI5 App for. It is a single-screen transaction with selection, overview and detail data on the same screen. It covers both demand and source view.

Kanban Board as Fiori UI5 App

Defining personal and public filter helps to realize different selections for demand or source views. The selection options correspond to the ERP functionality but the integration of Kanban correction is missing and we have less flexibility in adapting the graphics. For me the SAP Gui works better than Fiori, not only because it works faster and more reliable on my system.