Q&A: Transitioning from Costing to Account Based CO-PA

SAP Help

THIS PRESENTATION WITH Paul Ovigele WILL COVER:

  • What is the difference between Costing and Account Based CO-PA?

  • What are the advantages and disadvantages of Costing vs. Account Based CO-PA?

  • What are the implications of activating both types of CO-PA?

  • What are the steps to transition from one type of CO-PA to the other?

Speaker:

Paul Ovigele, FI/CO Expert

Watch the prerecorded webcast by pressing play:

Get answers to the following questions asked in our Q&A:

Q: If you have BW based on Costing Based CO-PA, will this work for Account Based CO-PA?

Q: Can you still use Costing Based COPA in S/4 HANA?

Q: Is there an advantage of going to Account Based COPA before S/4?

Q: Comment on the 1809 release and the sort of merge of account based and cost based COPA

Q: Why activation of actual costing is optional in S4 HANA and can you provide a specific example?

Q: Did I hear you say there is no quantity from SD billing in universal journal in account based PA? 

Q: Costing based COPA allows for than one UoM per transaction.  (e.g.  25 bottles or 2500ml)  In ECC6 it seems account based Copa allows only one UoM per transaction.     How about S4Hana?

Q: If we currently have Costing Based COPA, and if we will shift to dual Costing+Account Based, how will historical data be migrated?


WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

Ask A Fixer: Transitioning from Costing to Account Based CO-PA

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Friday, November 16th, 2018 12:00 PM (CT), 1:00 PM (ET), 11:00 AM (MT), 10:00 AM (PT)

End: Friday, November 16th, 2018 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

Controlling Profitability Analysis (CO-PA) is a great tool for analyzing financial information according to different dimensions which affect an organization’s profitability. There are 2 major types of CO-PA, Costing based and Account Based. There is also a lot of confusion about which one to use and the pros and cons of using one over the other and which type of CO-PA is compatible with the Universal Journal in S/4 HANA. Account based CO-PA has been improved in S/4HANA to offer more information in real time than ever available in the history of SAP. The Universal Journal now contains all account-based CO-PA data to meet most all reporting requirements.

Attend this live Q&A with FI/CO  expert Paul Ovigele, to learn the following:

  • What is the difference between Costing and Account Based CO-PA?

  • What are the advantages and disadvantages of Costing vs. Account Based CO-PA?

  • What are the implications of activating both types of CO-PA?

  • What are the steps to transition from one type of CO-PA to the other?

Speaker(s):

Paul Ovigele, FI/CO Expert, ERPfixers

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

If you cannot attend: The webcast will be recorded. The link to the recording will be posted here and emailed to all registrants.

Q&A: What You Should Know About Converting to Material Ledger

Material_Ledger_Converting.png

THIS PRESENTATION WITH Paul Ovigele WILL COVER:

  • How to prepare your system for a Material Ledger conversion.

  • What questions you need to ask when considering which Material Ledger functionality will be beneficial to your organization.

  • What criteria you can use to determine whether to convert to Material Ledger before or after an S/4 HANA conversion.

  • Typical mistakes that occur with a Material Ledger implementation.

  • What is the recommended point in time in the month/year to convert to Material Ledger?

Speaker:

Paul Ovigele, FI/CO Expert

Watch the prerecorded webcast by pressing play:

Q: Can you activate an additional currencies alongside a Material Ledger conversion?

A: You can activate parallel currencies alongside an ML conversion, but if you want historical data to be populated with the parallel currencies, you will need to do an SLO conversion as well

Q: Can you phase a Material Ledger conversion, for example based on one or more company codes, at different times?• Does Actual Costing work with Split Valuation?

A: Yes, you can phase a Material Ledger conversion, one company code at a time, as long as all plants in that company are converted as well. Note that if you do this, and if you use actual costing, the variances from a "non-ML activated" company will not be transferred to the company that has Ml active. Also note that if you are moving to S/4 HANA you have no choice but to activate all companies.

Q: When you migrate historical data to Material Ledger, does this mean that prior postings are revalued to Actual Cost?

A: No. The migration of historical data only translates Inventory and Purchase Order history into parallel currencies. It does not revalue inventory to Actual Cost retrospectively

Q: Is it better to convert to Material Ledger before or after migrating to S/4 HANA?

A: It depends. If there is a business requirement to have Material Ledger before an S/4 HANA conversion, then it is better to convert beforehand so that you can get used to the functionality.

Q: Does this also include PM orders and other orders not just PP orders?

A: Conversion to ML is for Manufacturing Orders and not PP orders. This is because Manufacturing Orders lead to the creation of inventory (settlement rule type is "MAT") while PP Orders are usually settled to a Cost Center.

Q: By Closed you mean CLSD the Orders?

A: It is better to either archive or set the deletion flag (DLFL) or Deletion Indicator to the production orders, so that they are not considered for an ML Conversion.

Q: Even costing view is changed too when data is converted for ML....correct?

A: Only the Accounting 1 view of the Material master is changed when you convert to Material Ledger. At this point, the Costing View remains the same.

Q: What if RM price control is V? Does this need to be converted to S?

A: If the Raw Material price Control is "V" (Moving Average, it does not need to be changed to "S" (Standard Cost) if you are not doing Actual Costing. However, if the Price Control is "V" then you will not be able to run the Actual Costing program at the end of the month (this is because the Materials with "V" are already at an "Actual Cost". Note that for several reasons (including the timing of Goods Receipts of Raw Materials relative to their consumption in Finished Goods), SAP recommends that if you are using Actual Costing, ALL Materials should have a price control of "S".

Q: This slide of tables old and new applies if ML is already active but transfer to HANA?

A: It depends. If the Old tables begin with "CKML…" or "ML…", then they only relate to companies with ML already active. However, the old tables like MKPF, MSEG, MBEW, QBEW, OBEW, etc. apply to everyone.

Q: What if ML is not active but changing to S4 HANA which has ML? Then how tables from Old ECC tables to New tables?

A: In that case the old ECC tables affected will be the xBEW(H) tables as well as the MKPF, MSEG and PO History tables will populate their respective ML Tables

Q: If Std. Cost (VPRS) is used for COPA , then how Actual cost is linked to COPA?

A: If you are in the ECC system (or use Costing Based CO-PA in S/4 HANA) there are configuration steps which can link the Actual Cost to COPA value fields. Note that these steps do not depend on the Sales Condition. Basically, they take the Actual Cost per unit and multiply by the quantity shipped. Transaction KE27 is then run to populate the respective Value fields. For Account Based CO-PA in S/4 HANA, the Cost of Sales Account (or Cost Component Accounts) are revalued by their proportional variances in Material Ledger.

Q: We have multiple controlling areas (one controlling area per company code) as per old SAP design.  Do we need to first convert to single controlling area before activating Material Ledger.  We are on ECC 6 EHP8.

A: It is technically possible to activate Material Ledger, even if you have multiple controlling areas. However, SAP is moving customers towards consolidating their Controlling Areas (either by using Central Finance or via a Greenfield implementation) so it is better to convert to a single Controlling Area first. Also, with multiple Controlling Areas, any transfers between companies in different controlling areas will not lead to a revaluation of cost in the receiving Controlling Area.

Q: How can FIFO be used with the Material Ledger and Actual Costing?

A: FIFO can be used with or without Material Ledger. There are several configuration steps for this. However, with Material Ledger, the FIFO layers will be based on Actual Cost.

Q: Where to switch off Statistical MAP in ECC?

A: This is done in S/4 HANA with the program "SAPRCKM_NO_EXCLUSIVELY_LOCKING"

Q: Our client wants to convert to actual costing in S4 but they want to know if it is possible to change standard price for materials and activities within the period instead of during month end?

A: Yes, you can change the standard price mid-month in S/4 HANA. Note however, that this leads to mid-month revaluation of inventory which will be adjusted when the Actual Cost is run.

Q: If you don't have actual activity prices until the end of the year, could we go back through and post actual activity prices retroactively for periods 1-12 and use this cumulative AVR to rerun actual costing where it would take these actual activity price differences from the prior periods into account to calculate actual costs as of 12/31.

A: I have not tried this before, but it is possible in theory. The Alternative Valuation Run (AVR) can cumulate the costs from previous months and apply its own logic to the cost calculation. The thing you need to use Parallel COGM to calculate the new Activity price, or if you can use the same ledger for this purpose.


WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

Ask A Fixer: What You Should Know About Converting to Material Ledger

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Wednesday, October 31st, 2018 12:00 PM (CT), 1:00 PM (ET), 11:00 AM (MT), 10:00 AM (PT)

End: Wednesday, October 31st, 2018 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

There are many benefits from implementing Material Ledger, such as better accuracy of Cost Reporting, more granularity of Cost of Sales, ability to view inventory in multiple currencies and valuation views, and so on. This is one of the reasons that over percent of SAP customers are using Material Ledger and why it is now required in S/4 HANA. Having said that, there are still a lot of companies that are nervous about transitioning to Material Ledger because of the potential workload of converting the data from their current tables to the Material Ledger tables. Attend with webcast with Material Ledger expert, and author of the book “Introducing the Material Ledger in SAP S/4HANA” Paul Ovigele to learn the following:

  • How to prepare your system for a Material Ledger conversion.

  • What questions you need to ask when considering which Material Ledger functionality will be beneficial to your organization.

  • What criteria you can use to determine whether to convert to Material Ledger before or after an S/4 HANA conversion.

  • Typical mistakes that occur with a Material Ledger implementation.

  • What is the recommended point in time in the month/year to convert to Material Ledger?

Speaker(s):

Paul Ovigele, FI/CO Expert, ERPfixers

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

If you cannot attend: The webcast will be recorded. The link to the recording is HERE and is also emailed to all registrants.

Q&A: Costing vs. Account Based CO-PA – Understanding the Differences In ECC & S/4 HANA (Part 1)

SAP Help

THIS PRESENTATION WITH Marjorie Wright WILL COVER:

  • What is the difference between Costing and Account Based CO-PA?

  • What are the advantages and disadvantages of Costing vs. Account Based CO-PA?

  • What are the implications of activating both types of CO-PA?

  • What are the steps to transition from one type of CO-PA to the other?

  • Which type of CO-PA is compatible with the Universal Journal in S/4 HANA?

  • How much CO-PA detail is now posted to the Universal Journal?

Speaker:

Marjorie Wright, FI/CO Expert, SimplyFI-CO, LLC

Watch the prerecorded webcast by pressing play:

Q: I have heard that there is something called "Combined Profitability Analysis". Will this also be available in the Universal Journal?

A: Combined Profitability Analysis is a really interesting feature. It’s been around even before S/4 HANA. And the general advice on that feature is it was created by the support people at SAP not by the developers. It was a way for people to have account based and cost based data in one table for reporting. Combined COPA will not be in ACDOCA it has it’s own table structure and reporting feature.

Q: With Attributed profitability segment, what happens when there is a change to one of the characteristics? Does this change get reflected in the Universal Journal?

A: The change does get reflected. It is always possible between the time of creating the settlement rule for an object and the actual settlement it is always possible for a characteristic value to change or for additional characteristic values to be present at settlement. So those will be captured with the real posting to the profitability settlement, and they will be in ACDOCA for reporting purposes.

Q: If a company used Costing Based in ECC, it is not as simple as turning on Account Based CO-PA. There are a lot of "posting" changes that have to happen, correct? How much work is it?

A: Yes you’re right, they are not exactly 1/1 in alignment. So you really have to determine your business process and your cost based CO-PA. For example, there is a KE21N where you can manually create a posting to cost based CO-PA that was not allowed for cost based and would not be allowed going forward. So you’d have to look at your business reason for using a feature like that and find an alternative way around it. You would need to spend some time looking at your historical data and determining how that gets migrated. There isn’t a really good tool provided by SAP right now migrate cost based CO-PA data to the Universal Journal. I think Central Finance has some features so hopefully they’ll make it over to the non-central Finance. Maybe in next year’s release. Yes we definitely have to spend a little time looking at those other processes and determining how we’re going to meet it in a non cost based CO-PA environment.

Q: What if you are shipping from DCs or ICs?  Do the variances and CCS flow through?

A: They should. There are a couple business add ins that might help with that. To use an alternative cost estimate or specifically in drop ships where there are no post goods issue. There are two new business add ins that will help address those problems.

Q: In the configuration screens you showed for the COGS and Prodn Variance accounts, there is a Default field on the right hand side of the screen, what is that for?

By checking the default box for an account, you’re indicating that if there’s something you missed in your mapping. So let’s use the cost for example, if there’s some other cost component that has a small value and you don’t want it to have it’s own GL account number, the default check box means include that value here. So we can say any cost component not specifically assigned to a cost element or a GL account in that view, the default check box would mean put that value here.

Q: How do we get the CO-PA characteristics posted to ACDOCA in S/4 HANA?

A: So the system is going to be deriving characteristics for CO-PA the same way it always has, we have a derivation strategy. When we generate our operating concerns or regenerate our operating concerns, ACDOCA is extended with a column for each characteristic of the operating concern. The system is just accumulating the value the same way it always has been using the derivation strategy except now instead of going to our CO tables, it’s transferring those characteristic values to ACDOCA.

Q: Is there possible the integration between Account Based COPA and others ledgers besides the leading ledger (0L)? For instance, if I want to use more parallel ledgers, am I able to use that information as the base to a COPA Report?

A: The only thing that would be different across parallel ledgers would be the valuation. In ACDOCA all ledgers are listed they’re just a separate document. I believe the value would be there, I might want to do a quick test on that to confirm it, but since each ledger is a separate line in ACDOCA, I think the characteristics are going to be present.

Q: To get all this extra "CO-PA Costing info" in ACDOCA sounds like there can be a lot of extra config steps to analyze and complete.

A: Yes, that’s a good observation. If we think back to the complexity of configuring actual posting for cost based CO-PA, those of you who are familiar with it you can visualize the configuration, there was a separate folder each kind of activity; with order settlement was it FI, what was the source of the activity. So now I don’t need all of those steps, that was a huge folder for actual costing cost based CO-PA, now I need two things. Maybe some variations of those two things. And those two things are the cost of consoled refinement, the splitting structure for that, and the splitting structure for production variances. So it may feel like it's extra config, but to me the cost of consoled refinement and the production variant splitting, they replace that long menu for actual posting in the cost based CO-PA config, so I think it's a win.

Q: What's the benefit using KE24 instead of using any General Ledger Report when using CO-PA account based?

A: If you’re working with account based CO-PA, then KE24 is going to look just like your your FI documents, specifically new GL because they’re the same. Account based COPA only gets a posting when financial accounting gets posting. One of the benefits of people who like to tick and tie. So perhaps in KE24 if I just want to see values by a specific characteristic, and here we’re talking about a non-HANA system. If I want to see values by strategic business unit, that’s not going to be in my general ledger report, because it was only captured in CO table in a non-HANA system. In S/4 HANA we can say that there’s no benefit of using KE24, because ACDOCA holds all of the information.

Q: What replaces KE21N for account based in HANA?

A: KE21N was not available before HANA, F simulation as an actual posting and we weren’t allowed to create posting in account based COPA that did not come from FI, they have to tie. So I think the simulation transaction is still alive and well in HANA. The KE21F simulation can toggle between cost based simulation because they’re often we are trying to prove out our derivation strategy. If KE21S is not in the menu, you an always just simulate your derivation strategy. N was never available for account based COPA, if F is not still there the alternative method would be to simulate the derivation strategy.

Q: So in S4/HANA, the Operating Concern has to be re-generated after the S4 HANA Conversion steps are completed?

A: This question can be answered in Paul Ovigele’s session about conversion (Part 2 to this webcast). He is the expert on conversion and has done several. Register for part 2 to this webcast HERE.

Q: We currently use costing based COPA to provide CM reports for comparison of actual to budget.  How will we be able to load Plan/Budget data into Account Based COPA?

A: Plan values are still on my open concern list. There is an equivalent to ACDOCA, there’s an ACDOCP table. However, on the account based side, all of the planning needs to come from the new integrated BPC planning product. So we don’t use the same planning tools we knew and loved from the ERP system. That’s still an open question for me to see the SAP address how can we streamline our planning process for COPA.

Q: Can characteristic realignment (KEND) still be done to change history?

A: It can be but it’s still imperfect. The characteristic realignment is still available but many features that we relied on in the legacy SAP system are still on the development list for S4 HANA. Some characteristics can be realigned , others still under development.

Q: In ECC, when you post to a cost center and CO-PA at the same time, the cost center posting is statistical. In S/4 HANA with Attributed profitability segment on a cost center, is the cost center posting real or statistical?

A: In that case, the cost center posting would be real. SAP still uses the same logic of one real CO accounts assignments, so the attributed profitability segment would be the statistical object and the cost center would be the real object. At the time of assessments, most likely for the cost center at period ends, going from cost center to profitability segment, the probability segment would then become the real cost object.

Q: Can the COGS account split be done for the main cost component structure only or can it be done for the auxiliary cost component structure?

A: It can be done for any cost component structure. That is one of the parameters of a splitting profile in addition to chart of accounts and controlling areas. So yes, it can be split using any cost component structure.

Q: Will a posting that does not come from PGI, such as Material Ledger Revaluation of Consumption, also be split in the COGS account?

A: That kind of posting can be split. There is a new business add in to include posting that don’t necessarily come from a PGI get the split for cost of goods sold. We would use that business add in to meet that requirement.


WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

What's Changing in FSCM - Dispute Management in S/4HANA Compared to ECC

SAP Help

I wish for a world without any dispute, but the reality is that in every sphere of business there are chances of dispute. While running a business, customer disputes can impact organization’s financial stability and creditability.

SAP FSCM - Dispute Management helps in identifying and documenting disputes earlier in the payment cycle, track and monitor reasons that drive DSO (Days Sales Outstanding) and streamline process of dispute resolution while fully integrated with FI. Key process steps in FSCM - Dispute Management are as below:

Screen Shot 2018-10-03 at 10.29.01 AM.png

FSCM - Dispute Management is not a new functionality and was existing in ECC environment also, so what’s really changing in FSCM is of great interest for organizations converting/adopting S/4HANA. Let’s see key changes in detail:

Transactional Simplifications

  • The core attributes of dispute case are the same in S/4HANA as in ECC, but the transaction processing has been simplified a lot in S/4HANA. See below highlights of such transactional changes:

    Process Receivables (Fiori ID F0106)

Process receivables Fiori application is under FSCM - Collection Management, but fully integrated to FSCM - Dispute Management. E.g. in below Figure 1 for Process Receivables app, you have the option to see the dispute cases for the customer and can also create new dispute cases for outstanding items. 

  Figure 1:  Dispute Management integrated to Collection Management

Figure 1: Dispute Management integrated to Collection Management

When creating the dispute case, the screen as showing in Figure 2 below is also having very specific relevant fields for user to create the dispute case: 

  Figure 2:  Simplified entry screen for dispute case creation

Figure 2: Simplified entry screen for dispute case creation

Various disputes for the custom will appear at the same place as shown in Figure 3 below:

  Figure 3:  Displaying dispute cases for the customer in Process Receivables app

Figure 3: Displaying dispute cases for the customer in Process Receivables app

  • Manage Dispute Cases (Fiori ID F0702)

This fiori application helps in managing the dispute cases as shown in Figure 4 below. Here you can change the processor for multiple dispute cases in single go. Or can go inside the particular dispute case to change its’ attributes:

  Figure 4:  Unified dashboard to show various dispute cases to process

Figure 4: Unified dashboard to show various dispute cases to process

On opening a dispute case, you can change the other attributes like root cause code, person responsible, reason etc. as shown in Figure 5 below (The attributes are same as in ECC environment.)

  Figure 5:  Changing the attributes of a dispute case

Figure 5: Changing the attributes of a dispute case

  • Other Fiori Applications of GUI type:

There are various other fiori applications available, like Write off dispute cases (Fiori ID UDM_AUTOWRITEOFF) which are of GUI type, i.e. the look and feel is similar to SAP GUI transaction codes so the processing will not be impacted in S/4HANA environment for such transactions. For example, Figure 6 show the screen like GUI transaction UDM_AUTOWRITEOFF

  Figure 6:  Fiori application of GUI type

Figure 6: Fiori application of GUI type

Analytical Innovations

Analytical power is core capability in S/4HANA and it provides a lot of out-of-the-box analytical applications, which shows the key KPIs on the tiles page as shown in Figure 7 below: 

  Figure 7:  Analytical apps showing KPI information for dispute management

Figure 7: Analytical apps showing KPI information for dispute management

Let’s see some more drilldown into these analytical apps on what kind on information these are showing:

  • Overdue Receivables in Dispute (Fiori ID F2540

Figure 8 show the overdue receivables in dispute cases and thus represent directly the working capital having less probability of realization. The analysis can be done from various angles, like by company code, by customer, by processor etc.:

  Figure 8:  Fiori application - Overdue Receivables in Dispute

Figure 8: Fiori application - Overdue Receivables in Dispute

  • Open Disputes (Fiori ID F1752)

Figure 9 show the open dispute cases and analysis can be done from various angles, like by customer, by processor etc.:

  Figure 9:  Fiori application - Open Disputes

Figure 9: Fiori application - Open Disputes

  • Solved Disputes (Fiori ID F2521)

Figure 10 show the closed dispute cases and analysis can be done from various angles, like by processor, by dispute case, by processor etc.: 

  Figure 10:  Fiori application - Solved Disputes

Figure 10: Fiori application - Solved Disputes

  • Processing Days of Open Disputes (Fiori ID F2522

Figure 11 show the processing days of open disputes and thus helps in prioritization of the cases for follow-up. The analysis can be done from various angles, like by coordinator, by dispute case, by customer etc.:

  Figure 11:  Fiori application - Processing Days of Open Disputes

Figure 11: Fiori application - Processing Days of Open Disputes

Role based menu in Fiori Launchpad

SAP S/4HANA provides Fiori Launchpad and thus all the related fiori applications for the user to manage dispute cases can be placed in single catalogue for ease of processing as illustrated in below Figure 12:

  Figure 12:  Fiori application - Processing Days of Open Disputes

Figure 12: Fiori application - Processing Days of Open Disputes

Integration with external application(s)

You can define external applications that allow you to process dispute cases outside of SAP Dispute Management. In the out-of-the-box settings, the SAP application “CRM Claims Management” is defined as an external application.

Lighting fast processing powered by HANA platform

FSCM – Dispute Management is also not secluded from proven processing speed benefit of HANA. 

The processing in new transactional apps is faster because of simplified accounting data structure in backend, fewer data fields to fill and fewer steps to perform the dispute transactions.

In a nutshell, S/4HANA increases the utility for dispute management function and intensify the business case compared to using any third-party tool for this function.

Ask A Fixer: Costing vs. Account Based CO-PA – Understanding the differences in ECC & S/4 HANA

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Thursday, September 27th, 2018 12:00 PM (CT), 1:00 PM (ET), 11:00 AM (MT), 10:00 AM (PT)

End: Thursday, September 27th, 2018 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

Controlling Profitability Analysis (CO-PA) is a great tool for analyzing financial information according to different dimensions which affect an organization’s profitability. There are 2 major types of CO-PA, Costing based and Account Based. There is also a lot of confusion about which one to use and the pros and cons of using one over the other and which type of CO-PA is compatible with the Universal Journal in S/4 HANA. Account based CO-PA has been improved in S/4HANA to offer more information in real time than ever available in the history of SAP. The Universal Journal now contains all account-based CO-PA data to meet most all reporting requirements.

Attend this live Q&A with FI/CO experts Marjorie Wright and Paul Ovigele, to learn the following:

  • What is the difference between Costing and Account Based CO-PA?

  • What are the advantages and disadvantages of Costing vs. Account Based CO-PA?

  • What are the implications of activating both types of CO-PA?

  • What are the steps to transition from one type of CO-PA to the other?

  • Which type of CO-PA is compatible with the Universal Journal in S/4 HANA?

  • How much CO-PA detail is now posted to the Universal Journal?

Speaker(s):

Marjorie Wright, FI/CO Expert, SimplyFI-CO, LLC

Paul Ovigele, FI/CO Expert, ERPfixers

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

If you cannot attend: The webcast will be recorded. The link to the recording will be posted here and emailed to all registrants.

Q&A: Migration Options for New G/L on S/4 HANA

SAP S/4 Hana

This presentation with Paul Ovigele will cover:

  • How the new G/L functionalities, such as document splitting, and parallel ledgers fit into S/4 HANA

  • Using the Extension Ledger in S/4 HANA

  • Active, Passive and Zero-balancing document splitting in S/4 HANA

  • Options for New G/L Activation on the S/4 HANA Adoption Path

  • Migration of Classic to New G/L

Watch the prerecorded webcast by pressing play:

Get answers to the following questions and many more by watching the webcast video above.

Q&A questions answered by Paul Ovigele.

Q: Is CO-PA part of New G/L in S/4 HANA?

A: No, CO-PA is not part of Suite on HANA. Only when you are on S/4 HANA, will Account-Based CO-PA be part of the Universal Journal (which New GL is also a part of).

Q: Do you get any New G/L functionalities automatically with Suite on HANA?

A: If you are on classic G/L with Suite on HANA you will not get any New G/L functionalities.

Q: Do you need to migrate to New G/L at year end if you need Document Splitting?

A: Yes, you need to migrate to New G/L at year end if you need document splitting. Note, as mentioned in the Webcast, the actual migration does not take place at year-end but a few months after. However, the year-end is a cutoff date which determines which postings will be migrated with document splitting and which will be migrated as a balance only.

Q: How long does a typical New G/L implementation take?

A: It depends on the number of company codes and the functionality being implemented. Between six to nine months is probably realistic in most cases.

Q: Can you implement both an extension ledger and a parallel ledger?

A: Yes, you can. They serve different purposes. Parallel ledger is normally used for Legal reporting purposes, while the extension ledger is normally used for management reporting purposes.

Q: Can you explain if future BSEG BKPF table will be replaced by ACDOCA?

A: BSEG and BKPF are not replaced by ACDOCA. They still exist in S/4 HANA, and contain some of the same limitations. However, ACDOCA replaces GLT0, GLPCA, COEP, etc.

Q: Are extension ledgers used for local reporting for local Statutory purposes?

A: Extension ledger can be used for Local reporting, but is more suited for management reporting.

Q: We have been on the classic ledger for nearly 20 years and need to determine if we nee to go to the New G/L prior to the S/4  HANA implementation to reduce risk.

A: This really depends on the situation in your company. The webcast presentation discusses the pros and cons of implementing New G/L functionality before or after S/4 HANA. Remember that New G/L is automatically active when you migrate to S/4. It is the functionality such as Document Splitting and Parallel Ledger that require a separate migration.

Q: If we have New GL and we have to move to S4 HANA.  How the migration steps should be carry out?

A:

Q: If you choose option 1 and turn on document splitting later, does that have to coincide with a FY migration date?

A: The migration will be a typical S/4 HANA migration, with the New G/L tables (e.g. FAGLFLEXT) being replaced with the Universal Journal table (ACDOCA). If you are already on New G/L before moving to S/4 there will be greater compatibility because the New G/L tables already combine a few Classic tables such as GLPCA, GLFUNCT. etc.

Q: For a Company with Jan-Dec Fiscal Year, hwat is the average month of data they usually have to migrate after document splitting has been configured?

A: The rule is that, any accounts that are open-item managed will have ALL the data migrated to document splitting, while non-open item managed accounts will have only balances brought over. This means that if an open managed account has data from 10 years ago, all this data will be migrated. This is why it is recommended to clear as many open items as possible before the migration so that the runtime is not impacted. For the current year (e.g. For Jan to Dec 2018, you actual Migration will probably be in April 2019) all documents will be migrated.

Q: The Migration cockpit service in Phase 2, does it takes data from Classic GL after the migration date until the activation date and moves the data to either FAGL or ACDOCA form GLT0?

A: Note, no migration is done on phase 2 (unless you are subsequently implementing document splitting). The migration is done in phase 1 during the migration weekend. During this time, all the data before and after the migration date are transferred to FAGL or ACDOCA. Think of the migration date as a cutoff point that determines how the documents will be migrated. 

Q: For option 1  - new GL migration, will it be the same approach if without SoH Migration (Run with Classic).

A: It will typically be the same in terms of functionality. However, since you will not be on a HANA database the migration runtime will be slower.

Q: We are using new GL and document splitting is activated, but we are planning to create more ledgers, is it good for after S4 upgrade or before S4 upgrade.

A: If your S/4 HANA upgrade is imminent, I would suggest waiting until after you migrate as you will have more flexibility with the ledgers.

Q: Three options were provided for going to NEW GL and S4HAHA.  Is one option recommended or strongly preferred over the others?

A: It depends on the organization's situation, budget, other conflicting projects in the pipeline, and so on. It is easier to migrate to S/4 HANA if you are already on New G/L, but there could also be downsides of migrating to New G/L first if the organization is not prepared for the change.

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

Ask A Fixer: Migration Options for New G/L on S/4 HANA

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Wednesday, August 29th, 2018 12:00 PM (CT), 1:00 PM (ET), 11:00 AM (MT), 10:00 AM (PT)

Start: Wednesday, August 29th, 2018 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

For customers that are still on the Classic General Ledger, there are questions about what approach they should take to activate the SAP (New) General Ledger with regards to an S/4 HANA Migration. Since S/4 HANA automatically provides a New G/L activation, is it better to wait until the S/4 HANA Migration before activating New G/L or is it better to migrate beforehand? Also, in either case, should you implement the New G/L functionalities (such as Document Splitting and Parallel Ledgers) before during or after Migrating to S/4 HANA?

Attend this live Q&A with FI/CO expert, Paul Ovigele to learn the following:

  • How the new G/L functionalities, such as document splitting, and parallel ledgers fit into S/4 HANA

  • Using the Extension Ledger in S/4 HANA

  • Active, Passive and Zero-balancing document splitting in S/4 HANA

  • Options for New G/L Activation on the S/4 HANA Adoption Path

  • Migration of Classic to New G/L

Speaker:

Paul Ovigele, FI/CO Expert, ERPfixers

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

If you cannot attend: The webcast will be recorded. The link to the recording will be posted here and emailed to all registrants.

Q&A: Business Intelligence and Analytics for Decision Making

SAP Help Consulting

This presentation with Gary Cokins will cover:

  • Learning why business analytics and leveraging Big Data provide a competitive advantage.
  • Understanding the difference between business intelligence (BI) and business analytics.
  • How to imbed statistics and analytics into enterprise performance management (EPM) methods.
  • How to differentiate forecasting from predictive modeling.
  • Learning alternative approaches to accelerating the adoption rate of business analytics.

Watch the prerecorded webcast by pressing play:

GET ANSWERS TO THE FOLLOWING QUESTIONS AND MANY MORE by watching the webcast video above.

Q&A questions answered by Gary Cokins.

Q: Based on your observations what is a major lesson learned by organizations attempting to broaden the adoption rate of applying analytics?

Q: Why is the CFO and accounting function so many years behind with embracing the use of advanced analytics.

 

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

SAP S/4HANA Finance – Hierarchies

With their latest product, SAP S/4HANA, SAP is revolutionizing how we approach finance by re-architecting data persistency and merging accounts and cost elements. This book offers a fundamental introduction to SAP S/4HANA Finance. Dive into the three pillars of innovation including SAP Accounting powered by SAP HANA, SAP Cash Management, and SAP BI Integrated Planning. Find out about the new configuration options, updated data model, and what this means for reporting in the future. Get a first-hand look at the new user interfaces in SAP Fiori. Review new universal journal, asset accounting, material ledger, and account-based profitability analysis functionality. Examine the steps required to migrate to SAP S/4HANA Finance and walk through the deployment options. By using practical examples, tips, and screenshots, this book helps readers to:

- Understand the basics of SAP S/4HANA Finance
- Explore the new architecture, configuration options, and SAP Fiori
- Examine SAP S/4HANA Finance migration steps
- Assess the impact on business processes

Ask a Fixer: Business Intelligence and Analytics for Decision Making

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Wednesday, June 27th, 2018 12:00 PM (CT), 1:00 PM (ET), 11:00 AM (MT), 10:00 AM (PT)

Start: Wednesday, June 27th, 2018 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

Volatility and complexity are the new normal. Most companies are far from where they want and need to be when it comes to implementing analytics and are still relying on gut feeling, rather than hard data, when making decisions. What is needed today is the seamless integration of managerial methodologies. Analytics with statistics, including regression and correlation analysis, provide organizations with insights to make better decisions and take actions.Business intelligence (BI) reporting consumes stored data that is transformed into information. Business analytics produces new information from the transformed information. There is a common misconception that equates business intelligence (BI) technologies, such as query and reporting techniques, with advanced analytics like data mining and forecasting. But in practice experienced analysts don’t use BI like searching for a diamond in a coal mine and flogging the data until it confesses with the truth. Analysts require easy and flexible access and manipulation of data and software to support their investigation and discovery.This presentation by Gary Cokins, a leading practitioner and author will cover:

  • Learning why business analytics and leveraging Big Data provide a competitive advantage.
  • Understanding the difference between business intelligence (BI) and business analytics.
  • How to imbed statistics and analytics into enterprise performance management (EPM) methods.
  • How to differentiate forecasting from predictive modeling.
  • Learning alternative approaches to accelerating the adoption rate of business analytics.

Speaker:
Gary Cokins
, President, Analytics-Based Performance Management LLC

Paul Ovigele, FI/CO Expert, ERPfixers

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

If you cannot attend: The webcast will be recorded. The link to the recording will be posted here and emailed to all registrants.

Q&A: Improve Productivity of Your SAP Controlling Implementation

SAP Controlling

This presentation with Ashish Sampat, Expert Fixer and FI/CO Consultant, will cover:

  • Evaluate the Right Cost Object to use in your company
  • Discover how you can use a separate GR/IR account for Intercompany transactions
  • Learn how to automate WIP, Variance, Settlement transactions
  • Find out how to capture a Trading Partner on relevant transactions
  • Utilize the Material Status field in reporting and analysis

Watch the prerecorded webcast by pressing play:

GET ANSWERS TO THE FOLLOWING QUESTIONS AND MANY MORE by watching the webcast video above.

Q&A questions answered by Ashish Sampat.

 

Q: We already use Process Orders in our current SAP system. We have acquired a business unit that is on another SAP system, but they use Production Orders. We now want to migrate them on our SAP platform. We are wondering if there is any value in have this new business unit switch to Process Orders when they move to our system?


Q: Is it possible to setup separate GR/IR Account for each type of material – say Raw, Packaging, Supplies, Semi-Finished, Finished Materials?

 

Q: We are planning to implement separate GR/IR for Intercompany. However, we do not know how to handle historical transactions that are open at the time of go-live. Do you have any suggestions on how to handle them?

 

Q: Our company has struggled with the performance of WIP, Variance and Settlement jobs – sometimes they take 3-4 hours to complete, thereby delaying our close at times. Apart from running these resource-intensive jobs at off-peak times, what other suggestions do you have to overcome this issue?


Q: We do want to see Trading Partner captured on Intercompany Transactions and want to activate the user exit. However, we do not know what will happen to clearing of earlier transactions. Is there a way we can incorporate a date logic?


Q: Material Status sounds like a useful functionality, but is it correct to state that it is more of a cross-functional feature than merely a Controlling feature?

 

Q: The Order Settlement jobs can sometimes take a long time, are there any tips to reduce the run-times?


Q: In table t030 how do you map from a MM Movement Type to the MM Transaction/ Account Modifier?

 

Q: Are these features are still valid and applicable in S/4HANA? 


Q: Is there anything particular in S_ALR_87013127 that use to identify orders that missed closing?


Q: It is hard to read the table of transactions on slide number 7 (cost object: transaction codes).  How can I obtain a copy of the table?

A:

Ask a Fixer: Improve Productivity of Your SAP Controlling Implementation

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Thursday, April 19th, 2018 12:00 PM (CT), 1:00 PM (ET), 11:00 AM (MT), 10:00 AM (PT)

Start: Thursday, April 19th, 2018 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

The Controlling (CO) module is the Management Accounting module of SAP. It allows you to plan, monitor and control processes and operations in order to assist management with the implementation of the organization’s strategy. It is also usually the less utilized and understood of the Accounting modules in SAP. Is your SAP Controlling implementation optimized to make the most of the available functionality? Are you taking advantage of the integrated nature of the SAP system and making the most out of this module? Attend this webcast with Ashish Sampat, CO Expert and author of “Expert tips to Unleash the Full Potential of SAP Controlling”, to learn more about the following:

  • Evaluate the Right Cost Object to use in your company
  • Discover how you can use a separate GR/IR account for Intercompany transactions
  • Learn how to automate WIP, Variance, Settlement transactions
  • Find out how to capture a Trading Partner on relevant transactions
  • Utilize the Material Status field in reporting and analysis

Speakers:

Ashish Sampat, FI/CO Consultant

Paul Ovigele, FI/CO Expert, ERPfixers

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

If you cannot attend: The webcast will be recorded. The link to the recording will be posted here and emailed to all registrants.

Q&A: What’s New in Transfer Pricing and Actual Costing in S/4 HANA

SAP Consulting

GET ANSWERS TO THE FOLLOWING QUESTIONS AND MANY MORE IN THIS CO-HOSTED ASUG WEBCAST.

This presentation with Janet Salmon, Chief Product Owner Management Accounting at SAP, will cover:

  • What are the latest changes to Transfer Pricing and Actual Costing in S/4 HANA?
  • How is Material Ledger Connected with the Universal Journal?
  • What are the Currency and Valuation options for Material Ledger in S/4 HANA?
  • What is the difference between Single Valuation and Multi Valuation Ledgers
  • What Fiori reports can be utilized for Actual Costing and Transfer Pricing?

Watch the prerecorded webcast by pressing play:

Q&A questions answered by Janet Salmon.

Q: Do we need to convert to ML before moving to S/4 HANA?

A: No you do not. The conversion to ML will take place automatically as you convert to S/4HANA. However, if you want to add valuation views (such as introducing group valuation) you should do that prior to converting to S/4HANA.


Q: When we move to S/4 HANA, and we have custom reports will we need to modify the reports to map to the new tablets or are there new compatibility views?

A: No Compatibility views for Actual Costing.


Q: If we move to S/4 HANA and we want to activate group valuation, do we need to do an SLO beforehand or can we convert automatically when we go to S/4 HANA?

A: It is best to do the SLO conversion in your local system and then migrate. It is on the roadmap to activate Group Valuation when you convert to S/4 HANA, but there is not yet a scheduled delivery date for such tools.

Q: Since there are now 8 currencies in the Universal Journal, does that mean that we can combine each of these currencies with any of the valuation views?

A: In principle, yes. You have always had the choice of keeping group valuation in group currency (31) or local currency (11) and some customers are looking at keeping group valuation in functional area currency. Beware however that Actual Costing currently only handles three currencies and any additional currencies will be converted on the fly at the time of the posting run.

Q: Will the Actual Costing have the availability to integrate FIFO valuation via using an alternative valuation method thru config using the "Key Figure Scheme" defining an External ending Inventory Valuation ....using FIFO.

A: You can set up an alternative valuation run that reads FIFO values or enter values for valuation in table CKMLPR_EB.


Q: Do we have information by storage location?

A: "In the Material tables you do, but no, Actual Costing does not split by storage location, only by Procurement alternative, and type of stock.
   
Q: Can we turn on Transfer Pricing & Multiple Valuations AFTER an S/4 Conversion / Migration?

A: At the moment, no. We get a lot of questions about this, but right now you need to do the SLO first and then migrate

Q: Please repeat OSS note numbers again.

A: You can always find OSS notes relating to the S/4 conversion by searching S4TWL. See https://launchpad.support.sap.com/#/notes/2267834, https://launchpad.support.sap.com/#/notes/2332591, https://launchpad.support.sap.com/#/notes/2354768 and https://launchpad.support.sap.com/#/notes/2337383


Q: As ML will be active for all company codes, will CKM3N be available for units without actual cost?

A: If units do not have actual cost, the Information will exist in CKM3N but you will not have the cost component split and no quantity structure being updated.

Q: Having calculated the IC Profit does SAP provide any support for deferred tax calculation on Profit in Transfer Price till the goods are sold to 3rd party.

A: If units do not have actual cost, the Information will exist in CKM3N but you will not have the cost component split and no quantity structure being updated.

Q: I assume the IC profit can only be eliminated if the affiliate entities are on the same instance of SAP, correct?

A: At the moment, the requirement for multilevel Actual Costing is that all entities are on the same instance. Central Finance can be used, to bring the financials into a single instance, but at the moment, you cannot eliminate IC profit if the entities are on different instances.

Q: When converting to S4 Hana, only the current year, plus the previous year, plus Dec of the year before that is migrated to S4, why only those periods?

A: That sounds like a Central Finance conversion, where only data from the most recent years is included in the initial load. If it is a Universal Journal conversion it should convert all the history (every document on the system).


Q: If my consolidation tool is BPC where the elimination occurs, can the group currency in S/4 incorporate these eliminations from BPC?

A: Elimination will happen in the consolidation tool. Going forward SAP working out what you can do locally versus in the consolidation tool. There is movement in this area to determine where you can do consolidation. The difference between a value chain consolidation and a typical legal consolidation is that with Group Valuation you are looking at elimination on a very granular material by material level.


Q: Is there any tool today or on the roadmap that helps drive transfer pricing determination?

A: For the actual calculation for transfer prices, at the moment there is no tool on the Roadmap. You would need to use a separate tool for this. Things might change but not at the moment.

Q: We produce aircraft, we activated ML-ACT but company is thinking on deactivate ACT because of the complexity, specifically on the accounting side. What is your recommendation? Is going to be less complex on HANA?

A: We would need to look at the situation specifically as it requires a little more information to understand the requirement better. It is hard to make a generalization without understanding the business. It should be easier because everything is on one table, but we need more information.

Q: Has any move been made to make inventory issued to vendor or inventory issued to customer non-plant specific?

A: Not that I know of. But we may need more background of the requirement.

Q: Is GAAP conversion inbuilt (i.e. IFRS/ Global GAAP vs Local GAAP views)?

A: You can add additional ledgers retrospectively now (subsequent implementation of an additional accounting principle).

SAP HANA Implementation Guide: Disaster Recover Concepts

Backup Using Storage Snapshots

Storage snapshots are taken at storage level and are a backup or copy of all disks in a storage group at the same point in time.

Storage snapshots have the following benefits:

  • They can be created with minimal impact on the system. This is because storage snapshots are created in the storage system and do not consume database services.
  • Recovery from a storage snapshot is faster than recovery from a data backup.
  • An SAP HANA database can be recovered to a specified point in time using a storage snapshot only or using storage snapshot in combination with log backups. This enables you to recover to a specified point in time.
ERPfixers Help

Storage snapshots and SAP HANA MDC

Backup and recovery using snapshots is not yet available for Multi Database Containers (MDC). There are two types of snapshots: database aware and database unaware snapshots.

Database Unaware Snapshots

A database unaware snapshot is a storage snapshot taken without notifying the database. When a recovery to the snapshot is done and the database restarted, the database assumes that a power-failure occurred and performs an online recovery. Database unaware snapshots are, by definition, inconsistent because the snapshot was taken while the database was running.

Database Aware Snapshots

A database aware snapshot is a storage snapshot which, when taken, notifies the database. As the database is warned, it can save a consistent state to disk. Database aware snapshots are, therefore, preferred over database unaware snapshots.

From an SAP HANA perspective, the storage snapshot captures the content of the SAP HANA data area at a particular point in time. Only use database aware snapshots. A snapshot is created by first creating an internal database snapshot. The database snapshot provides a view of the database with a consistent state at the point in time when it was created. The database snapshot is used to ensure the consistent state of the storage snapshot, regardless of the physical layout of the data area with respect to the number of disks, controllers, etc.

The following steps are needed to create a Storage Snapshot (see Figure 4.3):

  1. Use the SAP HANA Studio or the Command Line Tool to initiate the database snapshot. DISASTER RECOVERY
  2. Use storage tools to create a storage snapshot.
  3. Use the SAP HANA Studio or the Command Line Tool to confirm that the storage snapshot was created successfully. An ID is written to the backup catalog and the snapshot is released.
  Figure 4.3: Steps for database aware snapshots

Figure 4.3: Steps for database aware snapshots

SAP Help

Integration between SAP HANA and Storage

Database snapshots can be created via the SAP HANA Studio or the SQL command line. Both options are easy to use. For daily backups, the creation of the database snapshot will have to be automated by developing two scripts; one script to initiate the database snapshot and another to release the same snapshot. Both scripts will then have to be called from within the storage solution. Fortunately, most storage vendors provide such scripts by default. 


espresso-tutorials-logo.png

This excerpt is from the SAP HANA – Implementation Guide complements of Espresso Tutorials!

Ask a Fixer: What’s New in Transfer Pricing and Actual Costing in S/4 HANA

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Tuesday, March 27th, 2018 12:00 PM (CT), 1:00 PM (ET), 11:00 AM (MT), 10:00 AM (PT)

End: Tuesday, March 27th, 2018 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

Transfer Pricing and Actual Costing is becoming a more important topic due to increased globalization, mergers and acquisitions and complex internal supply chains that exist within organizations. This is combined with a growing desire to move all the legal entities of an organization into a single instance. The Material Ledger functionality has been improved and streamlined in S/4 HANA, allowing for huge volumes of intercompany transactions between various entities without affecting performance, and the ability to access real-time information on the fly. Attend this webcast with Janet Salmon, Chief Product Owner Management Accounting at SAP, to learn more about the following:

  • What are the latest changes to Transfer Pricing and Actual Costing in S/4 HANA?
  • How is Material Ledger Connected with the Universal Journal?
  • What are the Currency and Valuation options for Material Ledger in S/4 HANA?
  • What is the difference between Single Valuation and Multi Valuation Ledgers
  • What Fiori reports can be utilized for Actual Costing and Transfer Pricing?

Speakers:

Janet Salmon, Chief Product Owner Management, Accounting, SAP

 

WHAT IS "ASK A FIXER" WEBCAST SERIES?

Ask a Fixer is a live ASUG-hosted Q&A session with one of ERPfixers’ top-rated SAP experts (“Fixers”) in a specific module or topic. In this real-time discussion session, you have the opportunity to pose your specific questions to a Fixer, who will provide an immediate answer during the forum. This is a great way to get quick answers to your pressing issues, as well as learn from questions posted by other users during the forum.

If you cannot attend: The webcast will be recorded. The link to the recording will be posted here and emailed to all registrants.

Q&A: What You Should Know About Material Ledger in S/4 HANA

SAP Consulting

GET ANSWERS TO THE FOLLOWING QUESTIONS AND MANY MORE IN THIS CO-HOSTED ASUG WEBCAST.

This presentation by Paul Ovigele and Rogerio Faleiros will cover:

  • Why Material Ledger is Mandatory with S/4 HANA
  • The difference between using Material ledger for Actual Costing and Parallel Valuation
  • The improvements that have been made to the Actual Costing closing cockpit
  • The improved reporting that exists for Material ledger within SAP S/4HANA
  • Migrating to Material Ledger in S/4 HANA

Watch the prerecorded webcast by pressing play:


Q&A questions answered by ERPfixers expert Fixers Rogerio Faleiros & Paul Ovigele.

Q: So any MB type transaction where a BDC is used will need to be reworked then correct? 

A: Yes, any transactions that began with MB… (e.g. MB1C, MB1A, etc.) are now replaced with MIGO, and therefore any BDC sessions would need to be updated accordingly. It is better to transfer this transaction to a BADI or BAPI

Q: Can we use material ledger with different fiscal year variant than core ledger (FI) ? 

A: There is no concept of a Fiscal year variant in Material Ledger itself. Fiscal year variants are based on Ledgers in the Universal Journal. If you use Multi-valuation Ledger, then your Fiscal Year variant of the leading ledger will be the same in all Valuations of material ledger. If you use Single Valuation Ledger, then you should be able to have different Fiscal Year variants for the different ledgers (which represent separate valuation views in the Material ledger).

Q: Another question is do we need to close actual costing before we start posting in new period?

A: No. In both S/4 HANA and ECC, you will normally be closing actual costing after the new period has been opened. One of the reasons for this is that the Actual Costing “Post Closing” step reversed the inventory postings with a posting date of the beginning of the new period, therefore this new period needs to be open.

Q: Does ML in S/4 HANA allow negative inventory?

A: ML in S/4 HANA allows negative inventory, however, this needs to be specified in the Material Master and MM Period opening program.

Q: Is it easier to change Material Type or Valuation Classes than in ECC6? 

A: As far as I know, there is no difference with the process of changing Material Type or Valuation classes, as with in ECC 6.0.

Q: The same question about actual material ledger activated and Transfer Price, any point for attention?

A: The configuration for activating Material Ledger is the same as in ECC. One difference is that you need to specify the FI currency types that you want to use in ML. this is because FI now has eight extra currency types, while ML has only three. Transfer Pricing has been much more streamlined with S/4 HANA and you now have the option of having a separate ledger for each valuation view.

Q: Can you explain the differences from ECC to 1709 for how to setup LIFO or other balance sheet valuations?  Any thoughts on how to automate LIFO calculations?

A: To calculate LIFO you will need to define an accounting principle and assign LIFO method to it, and this assinged to material ledger.

Q: Everything was shown using the classic GUI.  Are there Fiori apps to process material ledger yet?

A: There are a few Fiori apps such as “Material Inventory Values” which can be used to view the data in the ML tables, however, there isn’t a Fiori App to process Material  Ledger as of yet.

Q: Are the MBEW EBEW tables going to be maintained as "views" in S/4Hana, or are they deleted?

A: Yes, the MBEW, EBEW, etc. tables will be maintained as compatibility views so that they can still be read with custom programs.

Q: Similar question, are the old ML tables MLHD, MLIT CKMLPP maintained as "views so that old programs & reports still work in S/4Hana?

A: Yes, these old ML tables are also maintained as compatibility views in S/4 HANA.

Q: Do we have to do new ML config before we execute the Migration steps?

A: yes, you at least need to reconfigure the currency type, if you used 0000. Also there is a new account modification PRL which is to be set up as the offset account key that is used for cost center credit posting (GBB-AUI).

Q: Is it mandatory to activate ML if I don't have it in my company?

Yes, it is mandatory to activate ML when you move to S/4 HANA even if you did not have it in ECC. Remember however, that Material Ledger is replacing the tables that were used in ECC for Inventory Valuation, therefore there probably is already relevant data in your current system for Material Ledger, even if you do not have it activated. Material Ledger is now the new subledger for inventory valuation but you do not have to activate Actual Costing, if it is not needed.

Q: What is the impact of activating ML in ECC before moving to S/4 if you don't have ML activated for materials?

A: If you want to activate ML in ECC before moving to S/4, you will need to perform a conversion of Inventory Valuation and Purchase Order history tables to Material Ledger tables. Note that, this this will need to be done anyway when you eventually move to S/4 HANA. The difference is that converting before hand gives the business some time to get used to material Ledger functionality, fosters user adoption, and provides historical information that can be accessed when you move to S/4 HANA. Note that if you Activate Actual Costing in ECC, the Actual Costing Run (CKMLCP) will be revamped when you move to S/4 HANA.

Q: What are steps we need to do before migrating ML from ECC to S4 Hana?

A: ML is now part of the conversion steps for S/4 HANA, so the ML activation will be included in the migration process. What is more important is that you understand how you can leverage Material Ledger functionality, and plan and design your S/4 HANA migration accordingly. You can take advantage of the Multi-valuation or Single valuation ledger approach; Company Code transfer pricing; Profit Center Transfer Pricing; Alternative Valuation Run to cumulate prices over several periods; Revaluing Inventory according to FIFO, LIFO, or NRV prices; and much more. Once you come up with the functionalities that will be beneficial to your business, you can then set up the system accordingly.

Q: Do we have view to old tables?

A: You can view the old Inventory and ML tables because the custom programs which accessed these tables will be able to access the compatibility views of these tables so that there is no disruption. However, you will not be able to write new data to these old tables.

Q: We use FIFO calculation and are there any steps we need to take care during Migration?  

A: No it is the same process as a company that does not use FIFO.

Q: We are moving to Hana Enterprise Cloud first just o get to  more current platform than our old ECC6.  will upgrade of material ledger come along with that, or not until we do the upgrade to S/4 Hana which will follow this system upgrade?

A: The new functionality of Material Ledger is only available with S/4 HANA. Even if you have HEC, this will only enable faster processing and reporting in the current ECC system but not add any extra functionality.

Q: Hi - Does the COGS split happen for the COGS variances also since ML has the variances data for this?

A: As of now, the COGS split (or Cost Component Split for Cost of Sales) does not happen with COGS variances. Instead, the Variance Categories (Input Price, Input Quantity, Resource Usage, etc.) can now be mapped to separate accounts in the Universal Journal.

Q: Will there be new functionality on non-distributed items?

A: Due to the revamped processing logic in Material Ledger on S/4 HANA, the “Not Distributed” items have been seriously reduced.

Q: Can we have material ledger activate for variant material (variant configuration active)?

A: Yes, you can have Material Ledger active along with Variant Configuration, in both ECC and S/4 HANA.

Q: We are currently on SAP ECC 6.0 on HANA with material ledger active. Will we have any disruption if we migrate to S/4?

A: No, there should not be any problem with migrating to ML on S/4 when you are already on the HANA database. You may not see much of a difference with the processing speed, since you already have the fast database, but you will go through the S/4 migration as normal and be able to leverage the new functionalities.

Q: We are on SAP ECC 6.0 on HANA with Material Ledger and Split Valuation active. Any anything we need to worry?

A: There should be no negative impact of having Material ledger and Split valuation when you move to S/4 HANA.

Q: Does ML or Actual costing support LIFO calc?

A: Yes, this is based on accounting principle.

Q: Does ML have capability to have LIFO valuation in parallel with FIFO valuation?

A: You have the option to have one material ledger run (e.g. CKMLCP) as FIFO and a second one using alternative valuation run (e.g. CKMLCPAVR) as LIFO.

Q: In ECC, the customer is able to choose whether the revolution will be done inside or outside ML. Is that option available in ML S/4 HANA?

A: If you use Actual Costing with S/4 HANA, you will need to run the Actual Costing program every month in ML. You can choose whether you want to revalue inventory with the actual cost or not. If however, you do not want to revalue inventory within ML (but say, in another system) then this will need to be a separate customized process.

Q: In ECC, the customer is able to use one single PRD Account. 3 or 4 slides before the end of the presentation, there is a slide with some hints about variances accounts and I am wondering whether in S/4 HANA we would be able to configure more than one single PRD Account. Is that possible? For instance: Price Variance, Freight Variance, etc...

A: At the moment, there is still no distinction between the cost components of a Price Variance Account. The COGS accounts can be split into different accounts by Cost Components, but this logic does not yet apply to inventory variance accounts. The slide being referred to is about the combining of single and multilevel price and exchange rate variances, and thereby not needing account keys PRV and KDV.

Q: I am presuming there is a package of transactions for conversion from ECC to S/4 HANA. Is that correct? Any information about it?

A: Yes , with the S/4 HANA migration there is a specific cockpit for Material ledger. This can be found in SAP Notes 2694618 and 2352383


Q&A questions answered by ERPfixers expert Fixers Rogerio Faleiros & Paul Ovigele.

 

Author: Rogerio Faleiros

Rogerio is an independent SAP consultant specializing in controlling functionality. He has worked with SAP technology for more than 10 years, implementing controlling solutions in the food processing, chemical, construction and agribusiness industries. Roger has been working with IFRS and integration with product costing and material ledger minimizing the impact of the changes in SAP for companies in different locations.He has participated in rollouts in several countries such as United States, Germany, Switzerland, Italy, Turkey, UK, France, Spain, Egypt, UAE, India Sweden and Finland. Rogerio has an MBA in IT from Getulio Vargas Foundation and is a frequent presenter providing training for new consultants in Brazil. Rogerio is the author of Configuring Controlling in SAP ERP.

All New SAP S/4 HANA Transaction Codes

  This excerpt is from our friends at Michael Management Corp.

This excerpt is from our friends at Michael Management Corp.

A few months ago, we received a live chat on our website asking if we had a list of all SAP transaction codes – we didn’t and so I wrote a blog where you can download all SAP tcodes. This blog turned out to be the most visited article of the year – who would have known?

Then recently someone asked me about this list on our Twitter feed, specifically, if our list also included the transaction codes for SAP’s newest release, S/4 HANA (it didn’t). So I went into our S/4 system and downloaded all transaction codes to an Excel spreadsheet and compared the 2 lists.

As a reminder, a transaction code in SAP is a shortcut to an activity. For example, AS01 is the code to create a new fixed asset master record, FB01 lets you post a financial document or use ME21 to create a purchase order, etc. pp.

You can see a complete list of all transaction codes by displaying the contents of table TSTCT – this is where SAP stores all tcodes and their description in all installed languages.

It turns out that there are about 7600 new transactions in S/4 (and that’s on top of the roughly 100,000 tcodes that exist in SAP’s ECC 6 release) …that’s somewhat surprising to me – I would have guessed a lot higher.

Anyway, download all new SAP S/4 transaction codes and take a look for yourself.

Once downloaded, play around with it – for example, you can search for the string /ui2/ (=user interface 2) to find all new Fiori-related transaction codes quickly.

I hope you’ll find the list useful and, as always, please comment below and share this post.

Cheers,

Thomas Michael