Ask a Fixer: What You Should Know About Material Ledger in S/4 HANA

Ask a Fixer

EXCLUSIVELY FOR ASUG MEMBERS!

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

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

There are several changes that have been made with S/4 HANA for the Financials Modules. One of the major ones is with Material Ledger, which is now mandatory for inventory valuation and contains new data structures and enhanced functionalities that allow you to manage Parallel Valuation and Currencies, Transfer Pricing and Actual Costing in a more efficient and streamlined manner. Attend this webcast and live Q&A with Paul Ovigele and Rogerio Faleiros, FI/CO Experts and authors of the upcoming SAP Press E-bite “Introducing the Material Ledger in S/4 HANA”, to learn more about the following:

  • 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

Speakers:

Paul Ovigele, FI/CO Expert, ERPfixers
Rogerio Faleiros, FI/CO Expert, RFERP

 

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: Analytics-Based Enterprise Performance Management

SAP Help

Watch the prerecorded webcast by pressing play:

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

This presentation by Gary Cokins, a leading practitioner and author will cover:

  • How strategy maps and their companion balanced scorecards communicate strategic objectives with target-setting to help cross-functional employee teams align their behavior to the strategy and better collaborate.

  • Why measures of channel and customer profitability and customer value are now superceding profit and service-line measures – and shifting from product to customer-focused organizations including future potential value – customer lifetime value.

  • How activity-based cost management (ABC/M) provides not only accurately traced calculated costs (relative to arbitrary broad-averaged cost allocations), but more importantly provides cost transparency back to the work processes and consumed resources, and to what drivers cause work activities.

  • Reforming the broken annual budgeting process with performance based budgeting that links strategy to operations and is process volume sensitive rather than simply incremental at each cost center.

  • How EPM/CPM also applies to public sector government to understand their “output costs” and better serve citizens.

  • Why business analytics, with emphasis on predictive analytics and pro-active decision making, is becoming a competitive advantage differentiator and an enabler for trade-off analysis.

  • How all levels of management can quickly see and assess how they are doing on what is important – typically with only a maximum of three key performance indicators (KPIs).

  • How to integrate performance measurement scorecards and ABC/M data with:

    • Strategy formulation.

    • Process-based thinking and operational productivity improvement.

    • Channel/customer profitability and value analysis and CRM.

    • Supply chain management.

  • Quality and lean management (Six Sigma, cost of quality).

Explanation of FI Line Item Texts created by Material Ledger

Explanation of FI Line Item Texts created by Material Ledger.png

If you use Material Ledger’s Actual Costing, then you would know that the Post Closing Step creates accounting documents depending on how the variances for the Material have been distributed. For example, a material with a price (or exchange rate) difference of $100 could be sold, scrapped, used in a production order that is complete, used in a production order that is not complete, transferred to another plant, or left in inventory. And this only refers to the differences that are created on the material itself (single-level), and not the differences that are transferred from other materials (multilevel) which have their own slew of Material Ledger postings. 

Because of this, it is easy to be overwhelmed by the volume of postings that are created by the Material Ledger’s closing entry and what they mean. Some companies choose to label the General ledger accounts appropriately to indicate what the posting is for, but if you do not understand the posting, it is easy to incorrectly label the General Ledger account. Also, you may not need a separate general ledger account for each scenario as that may lead to more General Ledger accounts than you need, and may create even more confusion.

Believe it or not, SAP does try to provide guidance on what each Material Ledger posting is for. It does so by inserting texts into each line item posting to indicate what it is (as described in SAP Note 2397606). The problem, is that these text explanations are sometimes cryptic and do not provide much clarity on what the posting is for. Also, there is very little information (online or elsewhere) that gives a more meaningful explanation for these text descriptions.

In the table below, I will try to explain (as best as I can) what texts are shown in the FI line items created by Material Ledger and what they mean.

SAP Material Ledger
SAP Material Ledger

Ask A Fixer: Analytics-Based Enterprise Performance Management

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.

Q&A: It’s that time of the year! Recommendations for a successful Year-End Closing

Get answers to the following questions and many more in this co-hosted ASUG webcast:

  • Typical Steps that should be carried out during the Year-End Closing process

  • Which of these steps should occur before others

  • Other modules outside FI/CO that are impacted by the Year-End -

  • Closing process

  • Issues that could crop up with the Year End Closing and how to address them

  • Some changes that occur with Year End Closing, when you are on S/4 HANA

  • If you use MR11 transaction will it affect moving average price and will price adjustments need to be done after this is run?

  • Could you please mention the transaction for reconciling inter-company?

  • Where do you set up the GL account that F.19 uses? When I run it in test mode and look at the postings, I don't see any GL Accounts.

  • Could you give details regarding the GR IR reclass process?

  • Does MR11 when done affect moving average price

Ask A Fixer: It’s that time of the year! Recommendations for a successful Year-End Closing

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.

Q&A: Why An Optimization Project Should Be In Your 2018 Plans

Get answers to the following questions and many more in this co-hosted ASUG webcast:

  • Why is Optimization needed for SAP customers?

  • Which route should you take in an Optimization Project?

  • Typical Methodology for Optimization.

  • Examples of what could go wrong when Best Practices are not followed.

  • Real life example of Optimizing an SAP system.

  • Do you think the SAP tools SAP VLM/Value Discovery/Celonis can supplement the functional optimization?

  • For companies with heavily customized processes, is it always advisable to run the optimization project before they start the project scoping for HANA S/4? Our current process is customized over 70%.

  • How long was the optimization effort at Woodwards?

Ask A Fixer: Why An Optimization Project Should Be In Your 2018 Plans

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 Net Present Value/Mark-to-Market

SAP Consulting

Many users wonder how SAP calculates the Net Present Value or Mark-to-market figures in transaction JBRX. This post seeks to help users gain an understanding and interpret the results that are generated when one executes the transaction.

Background

An investment transaction generates a series of future cash-flows and the Net Present Value (NPV) is the present value of future cash-flows.

Example

Invest in a €500000 Fixed Term Deposit for one year at a monthly interest rate of 12%.

SAP Help

Cash-flows are calculated as below:

SAP Consulting

To calculate the NPV use transaction code JBRX.

SAP Help

On the selection screen, enter the following information:

  1. Evaluation Currency

  2. Evaluation Type- This carries the relevant evaluation parameters that will be used in the calculation of the NPV.

  3. Evaluation Date- This is the date that determines the market data that will be used in the NPV calculation.

  4. Horizon- This is a future date on which future cash-flows are discounted. The horizon date must be greater than the evaluation date.

You can also select to run the NPV analysis using simulated transactions and you can limit the NPV Analysis bases on different characteristics, for example transaction number.

Once you are happy with your selection criteria, you click Execute.

SAP Help

The system now displays the transaction which we entered in the selection characteristics and both the Nominal amount and the NPV amount are displayed as below:

SAP Help

Highlight the transaction and click on Detail log to view the yield curves that have been used in the NPV calculation. The Yield Curve Framework is used to maintain reference interest rates and enter their values. On the basis of the reference interest rates, you can create yield curves to help you determine mark-to-market net present values with the price calculator.

SAP Help

This transaction will be discounted based on the reference interest rates maintained on yield curve 1002.

SAP Help

For detailed calculation parameters, click on the transaction again and select the icon Calculation Bases.

SAP Help

The Calculation Bases screen first shows the fixed cash-flows based on the fixed interest rate of 12% maintained on the transaction. The cash-flows are calculated based on the Interest calculation method specified on the transaction, Act/365 in this case. For the first cash-flow calculation would be: €500,000.00*12 %*( 28/365) =4602.74.

SAP Help

For the NPV Calculation, the system takes the Discounting Factor calculated based on the 1002 yield curve values and applies that to the fixed cash-flow. For the first line, the calculation would be:

€4602.74*0.9999500264= €4600.44

SAP Help

These discounted cash-flows are then added up and the total NPV of the transaction is €549,570.36.

Q&A: FIN REVENUE RECOGNITION - With the Deadline Looming, Are You Ready?

SAP Help

Get answers to the following questions in this co-hosted ASUG webcast:

  • This presentation focused on the use of RAR. But that has only been generally available since Mar, 2015. How many customers are actually using RAR? What about the rest (assumed to be the majority) who are using "old" functionality like basic SD Rev rec?

 

  • In your opinion, how long should the project be for a fortune 500 company to implement RAR, the right way?

 

  • What is software requirement to have implemented RAR in SAP ECC6 EHP6?

 

  • Do companies seem to be also changing all of their internal and management reporting and metrics or do most companies appear to only be changing their external SEC reporting to align with the new standard?

 

  • How does/can RAR handle revenue recognition based on estimates, when customer actuals are submitted a quarter later?

 

  • For a mining company with sales restricted to few customers, do you think RAR is a scope?

 

  • RAR requires a separate license, correct?

 

  • What all criteria need to be met for the company to be required for this reporting?

 

Watch the prerecorded webcast by pressing play:


Is your Contract Roll-Forward external disclosure report ready?

Poll stats from webcast attendees

When is your ASC606 US Adoption Rate?

Poll stats from webcast attendees

Introducing New Asset Accounting in S/4 HANA

Get the background on New Asset Accounting and S/4HANA, and run through some of the key changes that were introduced which distinguish it from Classic Asset Accounting. Next, we will go into some more detail on some of the larger areas, for example how the depreciation areas work with the ledgers to record the different accounting principles.  You may already have heard of the Universal Journal, which is one of the biggest innovations in Finance in S/HANA. We will explain what that is and how New Asset Accounting integrates with it and how the new asset transactions work. I will also run through the depreciation and finally I will briefly touch on the migration of assets.

Ask A Fixer: FIN REVENUE RECOGNITION - With the Deadline Looming, Are You Ready?

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 Functional Optimization

Need and ways to optimize your SAP system.

  1. How customers have suffered from a lack of proper utilization of SAP.
  2. Examples of how a deviation from Best Practices could adversely impact an organization.
  3. Methodology that should be used when performing an optimization project.
  4. How a proper system optimization will help companies with migrating to S/4 HANA 5.

Q&A: What you should know about New Asset Accounting with S/4 HANA

August Post.png

Q: If you do not currently use the Fixed Assets module in SAP, and you are planning on moving to S/4 HANA, is it better to implement Fixed Assets before you move to S/4 or after?

A: Assuming that you are on SAP, it depends whether you have the new GL or not (as New GL is a pre-requisite for New Asset Accounting), whether you plan to have additional accounting principles, and whether you are converting to S/4 HANA on-premise or doing a Greenfield implementation, which version you are planning to move to and when. Uploading an excel file with batch processing via the LSMW is not available at the moment on-premise, but you can use a BAPI.  An asset upload is usually easier at a year end. If you are already on NewGL and planning to convert to S/4HANA at a year end, it may be easier to get the asset upload out of the way before the S/4 HANA migration.  In all cases I would get expert advice to examine all the facts before making a decision.

A: The fiscal year end of asset accounting must agree with the fiscal year end of Finance, (even if the periods differ) but how can you map a depreciation area with one fiscal year end if you have a different fiscal year end for the parallel ledger in finance?

Q: Lets say you have 0L with March year end and 2L with Dec year end. Create a new ledger e.g. NL with March year end and add to a new ledger group so the new ledger group has both 2L and NL in it and mark  NL as the representative ledger and map the depreciation area for the Dec year end to the new ledger group. This should allow you to post from asset accounting to a different year end in finance.

Q: Can you map depreciation areas to appendix or extension ledgers in finance?

A: No this cannot be done at the moment. The extension ledger posts only delta postings in finance.

Q: If you have an asset with different useful lives for example for local GAAP and IFRS, so that the total depreciation calculated to date is different, and you make a sale to a customer, how does the system post the different values to different ledgers, but the same amount to the customer?

A: The system will automatically use the technical clearing account in a similar way to an acquisition to post the different values in different ledgers.

Q: Can you set up asset accounting with Central Finance on S/4HANA?

A: FI documents from Asset Accounting that are sent to Central Finance are only replicated as FI documents and not currently as fixed assets, and some of the fixed asset information may be removed. Therefore, although in the source system, the APC and accumulated depreciation accounts are set up as reconciliation accounts, in the SAP S/4HANA Finance system, they are not and accept only finance postings.

Q: Is it beneficial to implement new asset accounting prior to upgrading to S/4 Hana?

A: Assuming that you are on SAP, it depends whether you have the new GL or not (as New GL is a pre-requisite for New Asset Accounting), whether you plan to have additional accounting principles, and whether you are converting to S/4 HANA on-premise or doing a Greenfield implementation, which version you are planning to move to and when. Uploading an excel file with batch processing via the LSMW is not available at the moment on-premise, but you can use a BAPI.  An asset upload is usually easier at a year end. If you are already on NewGL and planning to convert to S/4HANA at a year end, it may be easier to get the asset upload out of the way before the S/4 HANA migration.  In all cases I would get expert advice to examine all the facts before making a decision.

Q: For parallel ledgers with differing fiscal year variants, is the migration scenario mandatory for new primary ledger with same fiscal year variant as leading ledger?  Or, can new primary ledger be treated as a "technical ledger" only?

A: I think you can use the representative ledger box to get round this. Lets say you have 0L with March year end and 2L with Dec year end. Create a new ledger e.g. NL with March year end and add to a new ledger group so the new ledger group has both 2L and NL in it and mark  NL as the representative ledger and map the depreciation area for the Dec year end to the new ledger group. This should allow you to post from asset accounting to a different year end in finance.

Q: Each currency needs separate Dep. Area.  Can you please elaborate this from with current ECC EHP6 scenario?

A: It is the same principle as in ECC6, if you have two currencies in finance for a ledger you will need two depreciation areas, one for each currency, for that accounting principle. The main difference is that you no longer need any delta depreciation areas.

Q: How is archiving of FI_DOCUMNT impacted?

A: Not sure if this is a question about new asset accounting or asking if an S/4HANA migration affects already archived documents, or how documents are archived on S/4HANA.

Q: Where do you configure technical clearing account? In AO90 - Asset account determination, or somewhere else? Can you please specify.

A: You cannot configure the technical clearing account in AO90. It has its own section in the New Asset Accounting section under Integration with General Ledger Accounting in the IMG.

Q: I heard a new year could not be opened independently in both Finance and Asset Accounting and is done in a single t-code which is balance carry forward. The carry forward transaction to open the new year can’t be processed if the previous year hasn’t been closed. Does this mean that AJAB closing asset has to be performed before we open a new fiscal year?

A: It is correct that transaction FAGLGVTR, which is the general ledger carry forward is now used for asset accounting as well. However it only opens the new year and you can continue to post to the old year. You should not need to close the old year with AJAB before opening the new year. (In ECC6 i have seen the old year closed 10months later in one company).

Q: If LSMW doesn't work, will tools like WinShuttle or SHDB work?

A: It depends on the version of S/4HANA - I believe the Cloud version has its own tools. For on-premise you can use a BAPI, or transaction AS100 if you don't have too many items, or can split the upload into 2 or 3 uploads.I have not used either Winshuttle nor SHDB  to upload to S/4HANA, the Winshuttle website mentions Certified S/4HANA integration including the 1610 version, but I don't know about SHDB.

Q: For Depreciation areas that do not post to FI where is the data kept and what does it look like what tables do reports run against? Is it held in ADOCA and marked as statistical in some way?

A: ACDOCA contains actual data by ledger and therefore if a depreciation area is not mapped to a ledger it can't record data from it. FAAT_DOC_IT will contain statistical data.  Most of the asset reports can be run by depreciation area so you can see data in the asset module for all the depreciation areas in the same way.

Q: Can we change accounting principle on a depreciation area after the initial migration?

A: During the migration you may need to do some changes to the configuration, but if you want to point one depreciation area at a completely different ledger, It would be best to check with SAP as I am not sure of the consequences.

Q: Can we still use calculated depreciation areas in S4 still posting to ledge?

A: Yes, although as with most of my answers, you should carry out extensive testing to make sure that the results are as you expect.

Q: FYI: LSMW is still officially supported for RE and FI-AA legacy conversion. It just requires that you use the BAPI_FIXEDASSET_OVRTAKE_CREATE rather than a screen recording.  Note 2208321 has more information.

A: In the Simplification List issued for the S/4HANA 1610 release, it states: ""The LSMW (Legacy System Migration Workbench) function is still available within SAP S/4HANA, (onpremise edition) but not considered as the migration tool. LSMW might propose incorrect migration interfaces that cannot be used in SAP S/4HANA anymore. The Legacy System Migration Workbench (LSMW) is an SAP NetWeaver tool for data migration that was first introduced with R/2 to R/3 migrations. It uses standard interfaces like BAPIs, IDocs, Direct Input and Batch Input programs and recordings. Due to this nature, the use of LSMW is restricted for migrations to SAP S/4HANA. The Legacy System Migration Workbench (LSMW) can only be considered as a migration tool for SAP S/4HANA using workarounds and careful testing for each and every object. The use of LSMW for data load to SAP S/4HANA is not recommended and at the customer's own risk. However it then goes on to quote the OSS note 2208321 for one of the workarounds - hence the confusion.

Q: Will you still have the tax deprn available for reporting?

A: If I understand the question,  if you have a tax depreciation area set up and you keep that tax depreciation you should be able to continue to report on it after a migration.

Q: Pease could you confirm. I believe you said migration had to occur at fiscal year end and that you could not reopen the prior year once the migration was over. Our tax only books are often re-opened for the prior year.

A: I believe a New GL migration has to occur at a fiscal year end, but an S/4HANA migration,  can occur at any period end. If I mentioned a closed fiscal year could not be re-opened after migration I was referring specifically to a closed fixed asset year end at the time of migration.

Q: Does HANA still support multiple Chart of Accounts? Or are these now unified into a single CoA?

A: If you mean for example an operating chart or accounts, local chart of accounts or group chart of accounts, then they behave the same in S/4HANA. You still have the option to add a local chart of accounts to the company code in global parameters and enter the alternative account number in the GL account master data.

Q: We have to report by tax jurisdiction and have the tax jurisdiction on the asset will that still be there?

A: The tax jurisdiction field is still available in the asset master data.

Q: Is it possible to add parallel ledgers at the same time as S/4HANA migration?

A: You cannot add parallel ledgers during the migration.  I understand that adding parallel ledgers once on S/4HANA is now available since version 1610 on-premise.

Q: Could the AP invoice in the example have been posted w/ different amounts by ledger?

A: The initial AP invoice would have the same amount for each ledger, so for example the whole amount in one ledger could be capitalized and the whole amount in the other ledger could be expensed, but if you wanted to transfer part of the amount to say shipping costs you would need a subsequent journal using FB01L or AB01L posting to just the one ledger.

Q: It seems in 1605 you must add then parallel ledger in separate year.  can you do it in the same year as migration then with 1610?

A: I think it would be safer to check with SAP as I am not 100% sure of when the parallel ledgers can be added.

Q: We calculate tax depreciation each month and report it at the end of the year the the taxing authority we have a special tax depreciation area.

A: I see no reason that this would not work on S/4HANA although would need more detail to be sure what the exact question is.

Q: Can you open the new year with a pending new project adding a parallel ledger?

A: I think it would be safer to check with SAP as I am not 100% sure of when the parallel ledgers can be added.

Q: Heard that carry forward is only needed one time and will update automatically after performed if posting is made to prior year in the ledger. is this correct?

A: This is the carry forward transaction FAGLGVTR - this is how it worked in ECC6 and as far as I am aware should work the same in S/4HANA.

 

Watch the prerecorded webcast by pressing play:

SAP PS Functionality and Integration

SAP Project Systems

This article covers the basic functionality of Project Systems and how it relates in MRP to PS and other logistic integration.

Project System is a highly integrated module whose purpose is more for consolidation and reports.

As its name suggest, it is project oriented, something that has a timeline and will end that you want to track by breakdown basis. Though there are cases where we can just make the project as a receiver for a departmental cost for example, RnD of 2016.

There are 6 main setups for PS

  1. Costing – Project that exist only for the purpose of planning costs at WBS level.

  2. Assets – Project that receive Capital funds from Investment Programs.

  3. Sales – Project that are customer focused.

  4. Manufacturing – Project that are Material / Logistic focused.

  5. Statistical – Project that do not plan or receive costs.

  6. Maintenance – Project that exist for managing Equipment.

Different setup caters for the different industry and usages of the module. Each will have a different configuration and integration with other module. In terms of functionality, PS is used to:

  1. Receive and consolidate Costs and Revenue in WBS (leveled and labeled) manner. A WBS is a CO Object, thus can be a receiver for settlement.

  2. Act as Planning tool for project schedule

  3. Act as demand management

  4. Act as investment and asset management

  5. For logistic execution in term of procurement and scheduling.

For No 2, companies will normally use MS Project to do the scheduling and interface it with SAP PS. There is also a standard interface available that can easily integrate these two applications (Open PS)    

SAP Help

To illustrate the core functionality of Cost & Revenue allocation, (example above) where you want to categorize the cost of building a car into 3 categories. You can easily separate and are able to see the breakdown of the cost of the car by building this structure.

SAP Consulting


You can then attach a network to the engine WBS. With this network we can create activities which enable the creation of elements, where the logistic activities are maintained, as you can see in the picture above.

  1. Work – Defines the internal work done by your own labor. This will use a Work Center and activity type to determine the cost. The rate can be maintain in KP26 (Activity type/Price Planning).

  2. External – Defines the external work done by contractors, outside the company. This will require Vendor, Outline Agreement(optional) and cost element. Price is maintained manually.

  3. Costs – Defines auxiliary costs. This will use a cost element and cost is entered directly.

  4. Service – Defines work/ services using a service master.

  5. Material Component – Specifies the activity requires a Material, and demand will be entered. Based on the MRP View 2 – Procurement Type, purchase requisition / planned order will be created.

SAP Expert

  By putting the Material component into the network activity, it will act as a demand for the material.

There are 5 default standard options to choose from

  1. PEV will enter the demand as PIR and become stock for the WBS. 

  2. PF will trigger purchase requisition its for non stock. Meaning it will be consumed upon GR.

  3. PFS is the same as PF, except its to be deliver directly to the customer or an address. You can choose to select customer address / vendor address or any location from central address management.

  4. PFV will enter the demand as PIR, but its non-stock.

  5. WE will also enter demand as PIR, stock item, at Plant level.

SAP Help

You can see the config in SPRO-Project System-Material-Procurement-Define Procurement Indicators for Material Components.  

SAP Help

By putting 2 KG Demand with requirement date 10.08.2017, it will transfer as a PIR and we can view in MD04 as below.

SAP Consultant

Run MRP and the system will generate procurement proposals.

For investment and asset management, it is mostly used in Oil and Gas industry where the project is a AuC (Asset under construction) which when completed, will become Fixed Asset and starts depreciation.

In conclusion, Project System core function is for Revenue / Cost reporting, however it also can be integrated with logistic functionalities and from there derives the project in all aspects. It’s a highly useful module for a company that operates on Project Basis. Below is an example of Customer Project Setup (uses Cost, Sales and Manufacturing setup). 

SAP Help

Project created with WBS and network. Cost planning, logistic, revenue are done. Baseline budget is set and project is executed. Project runs and confirmation, Goods Receipts starts. This will be repeated until project ends. From there customer can be billed based on the Sales Order using Milestone/Billing plan. Settlement done at the end for closing. If additional items are requested from customer, the whole process will retrigger with different SO and WBS (can be in the same project). After project delivery, warranty period will starts and any cost incur will be collected under warranty. Warranty ends and settlement is done at the end of the project closing.

Ask A Fixer: What you should know About New Asset Accounting with S/4 HANA

EXCLUSIVELY FOR ASUG MEMBERS!

Start: Wednesday August 23rd, 2017 1:00 PM (CT), 2:00 PM (ET), 12:00 PM (MT), 11:00 AM (PT)

End: Wednesday August 23rd, 2017 2:00 PM (CT), 3:00 PM (ET), 1:00 PM (MT), 12:00 AM (PT)

There are several changes that have been made with S/4 HANA Finance. One of the major ones is with the introduction of New Asset Accounting which provides new data structures and enhanced functionalities that allow you to manage and monitor your fixed assets. Attend this webcast and live Q&A with Oona Flanagan, ERPfixers Expert and author of the new SAP Press E-bite “Introducing New Asset Accounting in S/4 HANA”, to learn more about the following:

  • Key changes introduced with New Asset Accounting
  • Depreciation Areas and Ledgers - how they work now
  • Integrated Asset Postings and the Universal journal
  • How Depreciation runs in New Asset Accounting?
  • Migrating to New Asset Accountin

SPEAKERS:

Oona Flanagan, SAP FI/CO Expert

 

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 Profitability Analysis With S/4 HANA Finance

SAP Help

Get answers to these questions:

  • How Account-Based CO-PA is integrated with the Universal Journal

  • The considerations to be taken into account when converting from Account-Based to Costing-Based CO-PA

  • How to perform realtime derivation in CO-PA and reduce the need for month-end settlements

  • The setup needed to break cost of goods sold into cost components using Account-based CO-PA

  • How CO-PA allocations work with the Universal Journal

 

Watch the prerecorded webcast by pressing play:

To be a Savvy Professional You Need SAP Training

SAP Training Help

By Lori Moriarty at Michael Management Corporation


If you want to stay relevant as a technically savvy professional, you need continuing SAP training.

Why?

Because SAP is the 500-pound gorilla of ERP software. According to SAP they have over 350,000 customers in 180 countries and 15,000 partner companies worldwide. 87% of Forbes Global 2000 are SAP customers. There you go. Odds are high that you are going to be working for a company that has SAP.

 

Are you currently an SAP end user?

Great. Now it is time to be trained. Many companies use peer-to-peer training methods to get the new end users up and running. Though it may be enough to get the job done, there is so much more to learn. Imagine being able to use menu short-cuts that you did not know exist. With proper training, you can become your department’s Super User and position yourself for a promotion or raise based on your new level of proficiency. There may be a better (i.e. faster) way to do your reports and queries. You may never know these processes exist until you take an SAP training course.

 

Looking for a new position or a new job?

Your supervisors and future hiring managers will look at your SAP qualifications. Yes, of course, it is great to have experience as an SAP end use user. It is even better to show you went above and beyond and got professional skills training. You can take training for your specific career field. If you are in the human resources field, then earn a certificate as an HR AdministratorHR Manager or HR Payroll Manager. This kind of training is what will put your resume above the rest.

 

Want an impressive resume on LinkedIn?

Then just upload that hard-earned SAP Training certificate and let them know exactly how serious you are about your career. When you become a Certified SAP Professional, your credentials can be verified on-line by a third party. Remember to continuously update your LinkedIn profile as you change positions and take on more job duties. Reach out to others in your field and build your network because you never know who may be hiring. When you add your new SAP Certification be sure that your “share profile changes” button is in the ON position so that everyone can see your updates.

 

How would you like to make more money?

According to PayScale.com SAP Certified consultants earn more than consultants without certification. 137 consultants with SAP training reported their earnings at $75K to $126K and 122 SAP consultants who did not have SAP training or certification reported $49K to $78K. Does this mean that the consultants without training are bad? Of course not, they may be even better at the job than some of the higher paid consultants. The point here is that perception is key. More training looks better.

 

What is motivating you to start continue your SAP training?

Units of Measure and Their Behavior Inside Custom ABAP Code

AdobeStock_102083456.jpeg

One topic that is important in SD, but is often overlooked is the use of units of measure in custom ABAP programming.  In SAP, units of measure are stored in a series of tables that begin with T006:

SAP Answers

The table which controls various language translations of a unit of measure is table T006A.  I’ll explain more on that shortly.

SAP does a lot of work behind the scenes that most developers rarely ever see.  When calling up any item in SAP, a delivery for example, SAP will perform conversions of their data before displaying it to the user.  This is done for several fields, but one of those fields is the unit of measure of the delivery item.  SAP will convert the unit into what’s known as the external, or commercial unit of measure.   This is the unit of measure that is displayed to the user.  On the flipside, when a user enters a unit of measure into the delivery item and saves that data, SAP assumes that the user is entering the unit as the external or commercial unit of measure and will convert that entry into the internal unit of measure, or the unit of measure that is stored in SAP.

The difference between the internal and external units of measure are sometimes very hard to distinguish as they often look the same in English.  What it boils down to is that the internal unit of measure is language independent, meaning that it is the same in ALL languages. The external or commercial unit of measure varies depending upon the language it is being viewed from.  A developer may never know this when dealing with units such as KG or M2 because these are typically stored the same way in all languages.

SAP Answers

In the example above, the first unit is the internal unit, while the second unit (MSEH3) is the commercial unit.  Both the internal and commercial units are the same in all languages.  The problem begins to occur with units that vary in different languages.

One example is a crate.  In German, a crate is “Kiste”, so the internal unit of measure is “KI”.  Since SAP is a German system, the commercial unit is also “KI”.  However, in English, we would not identify it as a “KI”, but rather something like “CRT”.  We now have a difference.  Also, in this example, the Japanese unit is in kanji:

SAP Answers

One mistake a developer may do is create a custom field using the external, or commercial unit of measure.  Another is to define a unit of measure variable as a CHAR3 with the intent of writing this value to a text file.  This will cause the field to take the form of whatever is found in the table.  If a user has pulled this data straight from a delivery and writes it directly to the CHAR3 variable, SAP hasn’t converted that text yet, and because the data has been assigned a variable without a conversion exit, it never will be converted. 

For illustration purposes, I built a custom program and table.  This program takes an input, and writes the data to the screen.  Here are few examples. 

SAP Answers

Note that I’ve entered the commercial unit of measure here.

SAP Answers

What just happened?  The unit of measure was converted when assigned the field in the table to be added to the database, however, when it was written to a character variable, it was not converted back before output.

SAP Answers

This example writes the unit of measure from the internal unit of measure field

SAP Answers

Again, what happens here is that SAP converts it to the internal unit so that it can store the correct value in the table, however, before it is written to the screen, it is converted to the commercial unit of measure automatically.

SAP Answers
SAP Answers

Simply put, the reason this happened is because the commercial unit of measure (MSEH3) does not contain a user exit.  Therefore, when the converted unit of measure is assigned to this field, it is currently in its internal format, and does not get converted to it external format.  The issue is that SAP will not automatically perform this conversion when assigning values to variables without the proper conversion exit.

Let’s take another issue that can occur with improper conversions.  This can be seen when a developer writes a custom program to mass load data into a table.  As an example, I made modifications to my existing program to also store records.  

As you can see, when you look at the records SE16N, the new record from the above example appears. 

SAP Answers

However, when attempting to find the record:

SAP Answers
SAP S/4 HANA

This is caused by storing the improper unit of measure here.  The commercial unit was not converted before it was added to the database.  So, when running SE16N, when the user enters the unit of measure in the search criteria, SAP automatically converts that into the internal unit of measure.  Since the commercial unit is the one that got stored, SAP cannot find a match.

When writing custom programs, a developer must take caution when dealing with units of measure.  In many cases, it will be responsibility of the developer to perform the conversion of the units manually, especially when failing to use the correct variable with the conversion exit built in.  Fortunately, SAP is good at providing the needed tools to accomplish this.  From SE11, the data element for the internal unit of measure(MSEHI) has the domain MEINS.

SAP Help

Double clicking the domain name and clicking on the definition tab will show the conversion routing of the data element.

SAP Consulting

In this example, it is “CUNIT”.  Double-clicking the conversion routine name will show the INPUT and OUTPUT conversion routines for this field. 

SAP Answers

The typical naming convention of a conversion routine is “CONVERSION_EXIT_” followed by the conversion exit name, followed by a final piece to explain the purpose of the function.

For example, CONVERSION_EXIT_CUNIT_OUTPUT is the conversion exit used to convert an internal unit of measure to the commercial unit for user display, while CONVERSION_EXIT_CUNIT_INPUT is the conversion exit used to convert a commercial unit entered by the user to the SAP internal unit of measure when used for storage.  As a rule of thumb, OUTPUT is used data is written to a screen, document, etc.  While INPUT is used when using that data as input for interacting with SAP table data.

When using the conversion exit for units of measure, one key piece of information is the language.  When using the conversion exits, it is best to avoid constants for the language and to use the system variable SY-LANGU.  This will always provide the logon language when converting units of measure.

Going back to our example, I’ve added the needed conversion routines to my code.  Now, let’s run the report again:

SAP Help

As you can see, both the internal and external units of measure show correctly, and SE16 is able to successfully find the record.

It’s a little confusing at first to distinguish between the internal and external units of measure, but after some time, this will become very clear and will allow for any custom development to handle unit of measure information coming and going.