Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG Internal Order planning in SAP S/4HANA with SAP Analytics Cloud

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
986
Tepki puanı
6
Internal order planning is now also part of the Integrated Financial Planning for SAP S/4HANA business content that is delivered in SAP Analytics Cloud (SAC). Internal order planning is used to plan costs that you expect to incur during the life cycle of an order. With internal order planning you can plan and compare your costs on G/L account basis for certain periods.

In this blog post I will show you a detailed example with screenshots for internal order planning in SAP Analytics Cloud and integration to SAP S/4HANA. My intention is not to provide a documentation for end users but to give insights into the overall process and integration between SAP S/4HANA and SAP Analytics Cloud. It is a step-by-step guide including relevant technical information to setup Internal Order planning in SAP S/4HANA with SAP Analytics Cloud. Let me start with a short overview of the architecture of Financial Planning in SAP S/4HANA with SAP Analytics Cloud.

As introduction to Financial Planning in SAP S/4HANA you can start reading these blog posts first:

Overview Financial Planning in SAP S/4HANA​


The following graphic gives an overview of the architecture of financial planning in SAP S/4HANA (read more on SAP Help – Architecture Overview: Financial Planning):

overview%20of%20the%20architecture%20of%20financial%20planning%20in%20SAP%20S/4HANA


In SAP S/4HANA production and process orders already write plan data into the new planning table ACDOCP when you calculate plan costs and save these orders (e.g. transaction CO01 or CO02). Read more about Production Cost Analysis based on New Financials Planning Solution in SAP Help Categories for Order Plan/Standard Costs.

The classical internal order planning transaction KPF6/KPF7 can still be used in SAP S/4HANA (see SAP note 2270407 – S4TWL – Profit and Loss Planning, profit center planning, cost center planning, order planning, and project planning). But as they are still based on the classical CO-planning tables, these plan data would not be available in new reporting with new Analytical Apps (see SAP note 2349297 – S4TWL – Reporting/Analytics in Controlling). As an alternative you can also use the Import Financial Plan Data app to upload plan data into ACDOCP.

With Content Innovation 16 there is also a new content available for internal order planning in SAP Analytics Cloud delivered with the Integrated Financial Planning for SAP S/4HANA business content:

  • Model:
    • SAP__FI_BPL_IM_INTERNAL_ORDER
  • Stories:
    • SAP__FI_BPL_IM_INTERNAL_ODER_PLAN_ADMIN
    • SAP__FI_BPL_IM_INTERNAL_ODER_PLANNING
  • Data Actions (Planning functions):
    • SAP__FI_BPL_IM_INTERNAL_ORDER_CLEAR_VERSION
    • SAP__FI_BPL_IM_INTERNAL_ORDER_CREATE_PLAN_SAMPLE_DATA
    • SAP__FI_BPL_IM_INTERNAL_ORDER_PCTR_DERIVATION

More information about the content is available on SAP Help – Internal Order Planning in SAP Analytics Cloud. Prerequisites for the integration see SAP Note 2753796 – Integration scenario: SAP Analytics Cloud for Planning with SAP S/4HANA. (Further information and documentation I will provide also at the end of this blog post.)

Process for Internal Order planning in SAP S/4HANA with SAP Analytics Cloud​


I will show you screenshots and explain the following process steps for internal order planning in SAP S/4HANA with SAP Analytics Cloud as illustrated in the picture:

  1. Create internal order in SAP S/4HANA
  2. Import internal order from SAP S/4HANA to SAC
  3. Plan internal order in SAC
  4. Derive profit center from internal order in SAC
  5. Export plan data from SAC to SAP S/4HANA
  6. Check plan data in ACDOCP in SAP S/4HANA
  7. Reporting Order Plan/Actual

Process%20for%20Internal%20Order%20planning%20in%20SAP%20S/4HANA%20with%20SAP%20Analytics%20Cloud


Please note: Not all of these steps are performed by a planner as end user. I also included technical and optional steps that are done by an administrator to show the integration. End users only create, plan and report internal orders (steps 1,3 and 7).

For a quick start, you can also create sample data in SAP Analytics Cloud and explore the new UX and all the capabilities of SAC without any data import/export. But the integration is exactely what I want to demonstrate in this blog post.

1. Create Internal Order (KO01)​


Objectives: In the first step I create two internal orders in SAP S/4HANA.

Create internal orders in SAP S/4HANA (transaction KO01) and assign a profit center:

Create%20internal%20orders


Create%20internal%20orders%20in%20SAP%20S/4HANA




2. Import Internal Order from S/4HANA into SAC​


Objectives: In the second step I import the internal order master data into SAP Analytics Cloud.

This step can also be automated via a job. But I do the import manually to show you how it works.

SAP Help: How to import master data into SAC – Importing Master Data

Log on to SAP Analytics Cloud. In the Main Menu go to Browse -> Files.

Main%20Menu%20go%20to%20Browse%20-%20Files


Search for and open the model SAP__FI_BPL_IM_INTERNAL_ORDER:

model%20SAP__FI_BPL_IM_INTERNAL_ORDER


TIP: You can also add this model to your favorites for faster access next time and you will also see it under recent files on your home screen.

The model SAP__FI_BPL_IM_INTERNAL_ORDER is displayed:

model%20SAP__FI_BPL_IM_INTERNAL_ORDER%20is%20displayed


The model is rather simple and contains the measures like amount and only the dimensions company code, profit center, G/L-account and internal order.

Go to the Internal Order dimension (click on SAP_FI_BPL_INTERNAL_ORDER) and select the Data Management tab:

Data%20Management%20tab


As this is a public dimension, it can be reused in other models. Refresh the Job to import internal orders (select the refresh icon at the right-hand side of the job) or create a new import job:

Import Data->Datasource

Import%20Data-Datasource


Select SAP S/4HANA as datasource

datasource


Select your data source and your connection for your SAP S/4HANA system.

How to create a connection in SAC, see SAP Help:

Creating a Connection in SAP Analytics Cloud

Select%20your%20data%20source%20and%20your%20connection


Enter credentials (if not already maintained in the connection) and create a new query:

Enter%20credentials


Select API for Internal Order (A_Internal Order), enter a query name (e.g. A_InternalOrder_Query) and click next:

new%20query%20io




Select required fields by drag & drop from available data in source:

Company Code, Functional Area, Internal Order Description, Order and Profit Center

You can also set filters to limit selected data from source. I also set filters to import orders only from company code 1710 with order type Y400. Simply drag & drop the respective fields to the filters area and enter the criteria.

SAC%20build%20query%20for%20SAP%20S4HANA%20import


Click on Create to create the query.

SAC%20create%20query


The entries from source system are displayed. Fields like Company Code, Profit Center and Functional Area are automatically mapped to the target fields in SAC. Further mandatory mapping is required for the Dimension ID in the Dimension Mapping. Select the order number from the drop-down list and assign it to the Dimension ID and assign Internal Order description to the field Description.

SAC%20mapping


I did not have any issues and there is no further transformation required.

SAC%20finish%20mapping


Create the query by clicking on Finish Mapping.

finish%20mapping%20popup


Confirm the pop-up and finish the import.

Confirm%20the%20pop-up%20and%20finish%20the%20import


In the protocol on the right side you can see that 2 rows have been imported.



To view the mapping select the import job and click on the icon:


mapping%20summary


You can also automate this activity and schedule import jobs by clicking on the icon for schedule settings
icon%20schedule%20settings
:

schedule%20settings


Switch to the dimension view. There you can see the new imported entries in SAC:

dimension%20view


3. Plan Internal Order​


Objectives: After I have imported the internal order master data, I can start planning on the internal order.

Open the Browse -> Files in the Main Menu. Search for and open the story SAP__FI_BPL_IM_INTERNAL_ORDER

story%20SAP__FI_BPL_IM_INTERNAL_ORDER


Tip: You can also add the story to your favorites by clicking on the star and it will also be available under recent stories in your home screen for faster access next time.

Click on the story SAP__FI_BPL_IM_INTERNAL_ORDER_PLANNING.

Click%20on%20the%20story%20SAP__FI_BPL_IM_INTERNAL_ORDER_PLANNING


In this story you can create plan data on an internal order based on cost elements for a year (and periods). Existing plan data are displayed for internal order IO442 in my example. Add the new imported internal orders by clicking Add member. You can also search and select the internal orders.

Add%20the%20new%20imported%20internal%20orders


Select the G/L-accounts you want to plan and enter the amounts for the year 2021:

Select%20the%20G/L-accounts%20you%20want%20to%20plan%20and%20enter%20the%20amounts%20for%20the%20year%202021%3A


The yearly amount is automatically distributed to the periods:

yearly%20amount%20is%20automatically%20distributed%20to%20the%20periods


You can adjust the values for some periods:

You%20can%20adjust%20the%20values%20for%20some%20periods


Changes are highlighted in yellow.

You can adapt the display as you like: e.g. change the hierarchy view for the accounts by right clicking on GL account and change it to flat presentation.

change%20the%20hierarchy%20view


If you want to display the G/L account number, right clicking on G/L account and change Display Options.

change%20Display%20Options


At the end you can save and publish your plan data (click on Publish Data) or leave the story without publishing data and keep plan data private only (click OK).

save%20and%20publish


If you do not publish your changes, they will be saved as private version and only be visible for you.

publish%20data


4. Derive Profit Center from Internal Order​


Objective: In this step, after I have completed the planning, I can derive the profit center from the internal order master data (that has been imported into SAC before) and enrich plan data with this profit center.

This step is optional and only necessary if you require the profit center information in SAC. The profit center will also be derived when you export data in SAP S/4HANA (see next step 5).

Open the Browse -> Files in the Main Menu. Search for and open the story SAP__FI_BPL_IM_INTERNAL_ORDER_PLAN_ADMIN.

open%20the%20story%20SAP__FI_BPL_IM_INTERNAL_ORDER_PLAN_ADMIN


The Story SAP__FI_BPL_IM_INTERNAL_ORDER_PLAN_ADMIN is displayed. There is no profit center assigned to the planned internal orders:

Story%20SAP__FI_BPL_IM_INTERNAL_ORDER_PLAN_ADMIN%20is%20displayed


To derive a profit center from the imported master data click on the planning function Profit Center Derive:

derive%20a%20profit%20center


The data action is executed, and profit centers are derived. Again, at the end you can save and publish your plan data (click on Publish Data) or leave the story without publishing data and keep plan data private only (click OK).

publish%20pc%20derivation


5. Export Plan data from SAC to S/4HANA​


Objectives: In this step I export plan data from the SAC model into table ACDOCP in SAP S/4HANA
SAP Help: How to export data to SAP S/4HANA: Exporting Data to SAP S/4HANA

Open the model SAP__FI_BPL_IM_INTERNAL_ORDER and go to data management:

Open%20the%20model%20SAP__FI_BPL_IM_INTERNAL_ORDER


Click on export data->Export Data to SAP S/4HANA:

Export%20Data%20to%20SAP%20S/4HANA


Select your connection for your SAP S/4HANA system and enter your credentials (if not maintained in the connection).

credentials%20for%20export


Select S/4HANA Application “Planning – ACDOCP” and the following fields:

Company code, Fiscal Year Period, G/L Account, Order ID, Plan Category, Amount in Global Currency and Global Currency

target%20data%20selection


Click next and maintain the mapping:

Target DimensionSource Dimension
Company CodeSAP_ALL_COMPANY_CODE (Member ID)
FiscalYearPeriodDate
G/L AccountSAP_FI_BPL_GLACCOUNT (Member ID)
Order IDSAP_FI_BPL_INTERNAL_ORDER (Member ID)
Plan CategoryVersion: map Version Plan to Target Category PLN
Global CurrencyValue is derived from model currency
Model Default Currency: USD
Target Measures
AmountInGlobalCurrencySignedData

mapping%20-%20export%20to%20SAP%20S4HANA


Add filters by clicking add filter. I will select internal order as filter criteria for the data selection:

add%20filters


For the demo I only select two orders:

select%20internal%20order%20filter


Click OK.

mapping%20export


Click next and you can select the scope. Data will be cleaned based on the selected criterias before the export. I select company code, fiscal year period, order ID and planning category to overwrite only plan data within this scope.

export%20method


When you click Finish, the data exports will start.

message%20model%20is%20being%20exported


I have successfully exported 24 line items for 2 orders and 12 periods each.

message%2024%20lines%20exported


You can see the latest run of the export job and of course you can also schedule an export job and do not have to run it manually.

see%20export%20jobs


6. Show plan data in ACDOCP​


Objectives: After the export to SAP S/4HANA I want to do a quick check of the results.

You can check the results in planning table ACDOCP (data browser transaction SE16N):

table%20ACDOCP


Additional characteristics like functional area and segment are automatically derived from order master data in SAP S/4HANA.

The SAC model only contains plan data in default currency (USD in the sample) which are transferred into the global currency field in S/4HANA (see also SAP Help Exporting Data to SAP S/4HANA).

model%20currency


7. Report Order Plan/Actual​


Objectives: At the end I can do reporting for internal orders with the new Analytical Apps in SAP S/4HANA.

After export to SAP S/4HANA, plan data are available for reporting in SAP S/4HANA, e.g. Fiori App Order Plan/Actual (App ID F2886):

icon%20app%20F2886


I select my internal orders and planned time frame:



The app shows plan data from ACDOCP:

app%20internal%20order%20plan%20actual


app%20internal%20order%20plan%20actual%20II


As an alternative you could also use SAP Analytics Cloud for reporting and create your own story there.

Further information and documentation​




SAP S/4HANA​

SAP S/4HANA Cloud​

SAP Analytics Cloud​




Conclusion​


In this blog post I have shown how you can plan internal order in SAP S/4HANA with SAP Analytics Cloud. Internal order planning is only one scenario that is delivered within the business content Integrated Financial Planning for SAP S/4HANA in SAP Analytics Cloud. Similar content is available for project and cost center planning and other Financial Planning areas (Product Cost Planning, Sales and Profitability Planning, Financial Statement Planning,…) . Please check the documentation and roadmap for the current and future scope. I hope it was helpful for you and you gained some insights into Financial Planning in SAP S/4HANA with SAP Analytics Cloud with this simple example.



Brought to you by the S/4HANA RIG

Christian Rainer
Product Expert
SAP S/4HANA Regional Implementation Group

SAP%20S/4HANA%20RIG


Okumaya devam et...
 
Üst