segunda-feira, 9 de março de 2020

Verify General Journal Entries – Configuration Steps in S/4HANA 1909

Introduction

With S/4HANA 1709, the “Verify General Journal Entries” Apps were introduced. There are three apps, as follows:
  1. App ID F2547: Verify General Journal Entries – For Requester
  2. App ID F2728 :Verify General Journal Entries – For Processor (Inbox)
  3. App ID F2729: Verify General Journal Entries – For Processor (Outbox)
The process is driven by Standard Workflow Scenario WS02800046, where, the first step is for a ‘Requester’ to submit a document for review (Journal created as Parked) and the next step is for the Processor / Reviewer to approve or reject the document (approved journals get converted from Parked to Posted).
However, with S/4HANA 1909, the process of identifying ‘Processor’ or ‘Reviewer’ of the Journal changes. In S/4HANA 1709 and 1809 releases, the Processor was identified based on Rule 02800011 (FDC_GLJE_VER) maintained using Fiori App “Define Responsibilities” or with SAP Transaction Code FDC_ACC_VER_RESP. In S/4HANA 1909, the concepts of “Responsibility Management” using Functions, Function Profiles and Teams are introduced and the ‘Processor’ or ‘Reviewer’ is maintained using the “Manage Team and Responsibilities” App.
  • Workflow Process: From Requester to Processor


This is the first blog in what should later shape up into a series. This first blog provides details of various configuration points and steps to enable the standard “Verify General Journal Entries” process in S/4HANA 1909. The next blogs in this series would explore possibilities of enhancing and extending the standard workflow to meet Business needs.



Configuration Details


Here are the steps to follow to set up the ‘standard’ process for SAP delivered ‘one-step’ approval workflow for verifying G/L Journal Entries. While the SAP Help Document for S/4HANA 1909 is pretty detailed, here we share some additional information about system set up, which we came across while implementing it in our S/4HANA 1909 environment.

  • Apps Required: The following apps need to be activated

Please activate the following apps, i.e.:
  • Activate the SICF Path
  • Activate the OData Services
  • Manage Business Catalog and Business Groups
  • Assign Fiori App Target Mapping (Semantics) where applicable
These details can be found in the Fiori App Library Links, in the section ‘Implementation Information :- Configuration
App IDApp NameFiori Apps Library URL
F2720Manage Workflows for General Journal Entry Verificationhttps://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F2720’)/S16OP
F2547Verify General Journal Entries – For Requesterhttps://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F2547’)/S16OP
F2728Verify General Journal Entries – For Processor (Inbox)https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F2728’)/S16OP
F2729Verify General Journal Entries – For Processor (Outbox)https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F2729’)/S16OP
F3932Manage Teams and Responsibilities for General Journal Entry Verificationhttps://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F3932’)/S16OP
F2288Maintain Employeeshttps://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F2288’)/S16OP
F0718Post General Journal Entrieshttps://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps(‘F0718’)/S16OP


  • Steps to set up the Workflow



Step 1. Configurations (SPRO) in the Front End Fiori Server

A. Set up Scenario Definition in the Front-end Server
  • Navigate to SPRO Path: SAP NetWeaver > Gateway Service Enablement > Content > Task Gateway > Task Gateway Service > Scenario Definition.

  • Click New Entries and provide the following values:
Scenario Identifier: FI_GLJE_VER
Scenario Display Name: Verify General Journal Entry
Service: /IWPGW/TASKPROCESSING
Version: 2
EntitySet External Name: Task
Property External Name: TaskDefinitionID
Default Sort by Property: CreatedOn
MassAction: True (X)

  • Select the row of the newly added scenario and double-click Assign Consumer Type to Scenario in the left pane. Click New Entries and provide the following values:
DESKTOP
MOBILE
TABLET

  • Select the row of the newly added scenario and double-click Task Definition for Scenario in the left pane.
    Provide the following values in two lines:
– SAP System Alias: [The system alias to the back-end system with software version /IWPGW/BWF]
– Task Type: TS02800035 and TS78500071
  • Save the changes.
Please Note: ‘IWF_PGW’ in the example above was defined in SPRO path: SAP NetWeaver > SAP Gateway > OData Channel > Configuration > Connection Settings > SAP Gateway to SAP System > Manage SAP System Aliases
Please Note: In the example above, Task TS02800035 is for ‘Verify General Journal Entry’ in Workflow Scenario WS02800046 Step 10 and Task TS78500071 is for ‘Verify Intercompany General Journal Entry’  in Workflow Scenario WS02800046 Step 50.


Step 2. Configurations (SPRO) in the Back End S/4HANA 1909 Server

A. Steps of Maintaining Task Names and Decision Options
  • Navigate to SPRO Path: SAP NetWeaver > Gateway Service Enablement > Content > Workflow Settings > Maintain Task Names and Decision Options.

  • Maintain Task Names and Decision Options. Click New Entries and provide the following values:
New Entry 1:
Workflow ID: WS02800046
Step ID: 000010
Step Description: Verify G/L Journal Entry
New Entry 2:
Workflow ID: WS02800046
Step ID: 000050
Step Description: Verify Intercompany General Journal Entry
Save the changes.

  • Select the newly created entries, and double-click Decision Keys. Repeat for both new entries, i.e., for WF Step 10 and 50.Create two keys with the values as follows:
    KeyIcon MIME Repository PathDecision textCommentNature
    1(Empty)Approve(Empty)Positive
    2(Empty)Reject(Select Checkbox)Negative

B. Steps for Adding Visualization Parameters
  • Navigate to SPRO Path: SAP NetWeaver > Application Server > Business Management > SAP Business Workflow > Visualization of SAP Business Workflow Metadata > Client-Dependent Configuration .
Select My Inbox for the Worklist Client field –
Create an entry with the following values:
Task: TS02800035
Visualization Type: INBOX_GEN
Click Parameters icon in this newly created line and provide the following values and Save your changes.
Parameter NameVisualization Parameter Value…
SCHEMEsapui5
APPLICATION_PATH(Empty)
COMPONENT_NAMEcross.fnd.fiori.inbox.annotationBasedTaskUI
QUERY_PARAM00data=/sap/opu/odata/SAP/FAC_GL_JOURNALENTRY_VER_SRV;x=sid({SYSTEM}.{CLIENT})/C_GLJrnlEntryToBeVerified(CompanyCode='{&FI_GLJEVER.AUSBK&}’,AccountingDocument='{&FI_GLJEVER.BELNR&}’,FiscalYear='{&FI_GLJEVER.GJAHR&}’)
QUERY_PARAM01annotations=/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Annotations(TechnicalName=’FAC_GL_JOURNALENTRY_VER_ANNO_MDL’,Version=’0001′)/$value
Save your changes.
Repeat step 1 and step 2, and then create an entry with the following values:
Task: TS78500071
Visualization Type: INBOX_GEN
Click Parameters icon in this newly created line and provide the following values Save your changes.
Parameter NameVisualization Parameter Value…
SCHEMEsapui5
APPLICATION_PATH(Empty)
COMPONENT_NAMEcross.fnd.fiori.inbox.annotationBasedTaskUI
QUERY_PARAM00data=/sap/opu/odata/SAP/FAC_GL_JOURNALENTRY_VER_SRV;x=sid({SYSTEM}.{CLIENT})/C_GLJrnlEntryToBeVerified(CompanyCode='{&AUSBK&}’,AccountingDocument='{&BELNR&}’,FiscalYear='{&GJAHR&}’)
QUERY_PARAM01annotations=/sap/opu/odata/IWFND/CATALOGSERVICE;v=2/Annotations(TechnicalName=’FAC_GL_JOURNALENTRY_VER_ANNO_MDL’,Version=’0001′)/$value

C. Steps of Customizing Teams and Responsibilities
  • Define Functions
  • Navigate to SPRO Path: Cross-Application Components  > Application Server  > General Application Functions >  Responsibility Management > Functions > Define Functions.
    Create three entries with the following values and save changes
Function         Function Description
FGJEV_L1     General Journal Entry Verification Level 1
FGJEV_L2     General Journal Entry Verification Level 2
FGJEV_L3     General Journal Entry Verification Level 3

  • Define Function Profiles
  • Navigate to SPRO Path: Cross-Application Components  > Application Server  > General Application Functions >  Responsibility Management > Functions > Define Function Profiles.
    Create one entry with the following values and save changes
Profile: FGJEV
Function Profile Description: FI General Journal Entry Verification
  • Select the newly created entry and double-click Function Profile to Function Mapping.
    Create three entries with the following values and save changes:
Function         Function Description
FGJEV_L1     General Journal Entry Verification Level 1
FGJEV_L2     General Journal Entry Verification Level 2
FGJEV_L3     General Journal Entry Verification Level 3


  • Map Function Profiles to Standard Team Category 
  • Navigate to SPRO Path: Cross-Application Components  > Application Server  > General Application Functions >  Responsibility Management > Teams and Responsibilities > SAP Delivered Team Categories >  Map Function Profiles to Standard Team Category.
    Create one entry with the following values and save changes
Category: FGJEV
Profile: FGJEV
Function Profile Description: FI General Journal Entry Verification

  • Define Team Types
  • Navigate to SPRO Path: Cross-Application Components  > Application Server  > General Application Functions >  Responsibility Management > Teams and Responsibilities > SAP Delivered Team Categories >  Define Team Types.
    Create one entry with the following values and save changes
Team Type: FGLVG
Category: FGJEV
Team Type Description: FI G/L Ver. Team in General
Note: The entry created is the default team that is assigned to verify journal entries.
In the section below where the “Manage Teams and Responsibilities” App has been described, the relationships between Function Profile, Functions, team Category and Type have been illustrated.

D. Steps of Customizing Notification
  • Navigate to SPRO Path: SAP NetWeaver > Notification Channel > Notification Channel Provider Enablement > Administration  > Notification Provider Settings > Manage Notification Providers .
Create an entry with the following values and save changes.
Notification Provider ID: JE_VER_NOTIF_PROV
Is Active?: Yes



Step 3. Maintain Employees
As mentioned in the sections above, in S/4HANA 1909, the Workflow recipient is determined by the concept of Teams and Functions managed via the App “Manage Teams and Responsibilities”. Once a Team is created (see Step 4 below for further details), Business Partners can be assigned to the team. However, only those Business Partners can be assigned that have one of the following three roles:
  • BUP003 (Employee)
  • BBP005 (Service Performer)
  • BBP010 (Freelancer)
In S/4HANA, Business Partners cannot be created anymore for these roles above using the App “Manage Business Partner Master Data” or Transaction BP. Please refer to OSS Note 2770132 to read more.
However, the solution is suggested in OSS Note 2570961. This Note provides details of how Business Partners can be created in S/4HANA system with Employee Roles, with or without HR Integration. In this example, we would follow the instructions provided for scenario ‘HR Integration is Inactive’.
  • Launch the “Maintain Employees” App – Click on the button called ‘New’ at the bottom
  • Enter the Employee ID, click on the ‘Assign Users’ button. Select from an existing SAP User that needs to be linked with this new Employee. Two more buttons will appear. Select the ‘Copy User Data to Employee Data’ button.
  • Click on the ‘Save’ button at the bottom of the screen. If saved successfully, a message will appear at the bottom of the screen. Go back to the main list of Employees.
  • The New Employee now appears in the list.
  • On the “Manage Business Partner Master Data” App, a new Business Partner can be seen created with Role BUP003 (Employee) attached to it.


Step 4. Manage Teams and Responsibilities

Once the Employees are created in the system and linked to SAP User IDs, the Teams can be set up where the workflows would land for review and approval. This can be managed by the App “Manage Teams and Responsibilities – General Journal Entries Verification”
  • Launch the “Manage Teams and Responsibilities – General Journal Entries Verification” App – Click on the button called ‘Create’ at the right hand side of the screen.
  • Create a New Team. Assign a ‘Name’ of your choice, add a ‘Description’, change the ‘Status’ to ‘Ready to Use’, select the value ‘FGLVG’ from the dropdown field ‘Type’. The Team Type FGLVG was configured in Step 2.C above and assigned to Team Category FGJEV. In ‘Responsibility Definition’ add a Company Code, Cost Centre or GL Account Group to restrict the Workflow Team. Then assign a Business Partner as Team Owner and one or more Business Partners as Team Members. Once done, click on ‘Save’ button at the bottom.
  • If you click on the ‘Create’ Button for adding Team Owners or Members, the list of Business Partner that is displayed only looks for Roles BUP003 (Employee); BBP005 (Service Performer) or BBP010 (Freelancer). The data is retrieved from the Backend S/4HANA system using CDS View I_RESPYMGMTTEAMMEMBER (SQL View ITEAMMEMBER) for Team Members. Various other CDS Views with prefix ‘I_RESPYMGMTTEAM*’ are relevant to this app.
  • Each Team Member is assigned a function. In this example, all three Business Partners were assigned the Function FGJEV_L1 (General Journal Entry Verification Level 1). In Step 2.C above, this Function was assigned to Profile FGJEV, which in turn, was assigned to Team Category FGJEV.
  • The following figure provides an overview of the relationship between Team Type, Team Category, Function Profile and Functions defined in Step 2.C above and used by the “Manage Teams and Responsibility” App.



Step 5. Manage Workflow

After setting up the Employees and the Team, ensure the Workflow for Workflow Scenario WS02800046 is active in the system.
  • Launch the “Manage Workflows for General Journal Entries Verification” App. The workflow called ‘General Journal Entry Verification’ should already exist with status ‘Active’. If not, click on the button called ‘Add’ at the top right hand side of the screen and proceed as follows.
  • Add a new Workflow with name “General Journal Entry Verification” and add two steps, namely, 1.Verify and 2.Post.
  • Configure the two steps as per the screenshots below. Once done, click on Apply and ensure the Workflow created is in status Active.
  • Configuring the steps above any differently, would lead to different results.

Step 6. Verify General Journal Entries – For Requester

The set up is complete and we are now ready to create a journal for verification.

  • Launch the “Verify General Journal Entries – For Requester” App. Click on the ‘+’ sign to create a new Journal. In this example, we would only explain the process of creation of an individual journal using the ‘+’ button. Mass creation of Journals is possible by using the ‘Upload’ button.
  • Enter values in the mandatory fields and expand each line item to add further item level details. Additional items can also be added here. When data is populated, either the ‘Simulate’ button can be used to check for errors, or the ‘Submit’ button can be used to Park the document for verification.
  • Errors, if any, will be reported in a popup box.
  • Resolve errors and Submit Document to generate a new Journal.
  • Click on Display to check the Journal. The status ‘Submitted’ on the right top indicates the Workflow has triggered and is awaiting approval. Status ‘Error;’ would mean the Workflow is in error, whereas status ‘Posted’ would mean the document has been posted without the need of a workflow.
  • Navigate back to the Verify General Journal Entries App to find the new journal and the Processors selected for approval. The two processors selected are two of the three assigned to team ‘GJE REVIEWERS’ in step 4 above. The third member of that team initiated this workflow and the workflow excludes the initiator from processor list, i.e., one cannot create a journal for verification and verify himself / herself.
  • The workflow log can be seen in the backend using Transaction SWIA or SWI1 – Workflow Task WS02800046.
  • The journal, in this example, can be seen in Parked status.

Step 7. Verify General Journal Entries – For Processor (Inbox)

This is the final section of this blog that shows how a journal can be reviewed and approved.

  • Launch the “Verify General Journal Entries – For Processor (Inbox)” App. This opens up the ‘My Inbox’ app. Look for the journal which was just added. Click on the Journal Number to check further details. Else choose from one of the buttons at the bottom right corner of the screen.
  • Approve: Document gets posted
  • Reject: Can be returned to the initiator with comments for changes
  • Claim: When multiple reviewers exist, claiming the workflow removes it from the other reviewers’ list. Once claimed, a new button appears called ‘Release’. That button makes the workflow available to all reviewers again.
  • Forward: The workflow is forwarded to another user for review.
  • Suspend: A date can be selected and the review can be suspended till then.
  • When the journal is Approved, a popup box appears to record Decision Notes. When the reviewer clicks on Submit, the Journal is posted. with the message ‘Task Successfully Completed’.
  • The Journal now appears with status ‘Posted’ and can be seen in the ‘Manage Journal Entries’ App.
  • The backend workflow (Transaction SWIA) moves to status ‘Completed’ at this stage

Please Note:
  • Workflow User SAP_WFRT is used to trigger the notifications. Please check and ensure the user is set up properly with correct authorisations.
  • If the code block has any custom field, they have to be introduced into the ‘Post General Journal Entries’ app using the ‘Custom Field and Logic’ app.
  • Further technical settings are required in the system to connect front-end Fiori and back-end S/4HANA server if two separate servers are used.
  • Please ensure the relevant Fiori Business Catalogs are assigned to appropriate users.


Conclusion

For years the ‘Park and Post’ process has been used in SAP to implement segregation of duty and using the Four eyes principle. Usually, that required significant custom workflow development work. The Verification of Journal Entries process provides a more standard way of reviewing a parked document before posting.


Reference:

Special Thanks:
Rishab Bucha for guidance and support. You are pretty amazing.

System Details:
Front-End Fiori Server
Back-End S/4HANA Server

Documentary batches and its integration to SAP EWM

Conceptualization:

Documentary batches have been in SAP arena for long time, however the usage and adaptability  has been quite limited by customers because of less available content and its full interoperability has not been explored in length.
This blog is written to understand why there is need of Documentary batches in logistics realms and how it could be a game changer for logistics and warehousing.

Definition:

Documentary batches are virtual batches, not real one. A documentary batch is a batch that is not inventory-managed. It means it will never appear in your stock, however, they are generated during certain business operations like during Goods receipt, during picking, return to vendor and etc.
So, the required product is not flagged as batch managed in Material master.

Using documentary batches, the traceability of a product is enhanced  without managing the stock of the product in batches. It means we dont need to activate the Material as batch managed, no need to do any  Batch Management settings. Only settings are required at Documentary batch level in OCHA for the required material types. If material type becomes more generic for customer, sap has given Badi to use for specific products.

Example: Requirement is to trace a product which is sent to Customer with documentary batches. No real batches exits in Stock.

Below are the processes where documentary batches can be incorporated. SAP has recently extended the usage of documentary batches in Order and network. Also during Vendor return process, documentary batches can be incorporated.
ERP settings:

EWM settings:
In EWM, we just need to activate the required Item type.

For Outbound Process:
When you create an outbound delivery with or without reference to a sales order, the outbound delivery is replicated to SAP EWM. Documentary batches are generated during confirming Picking WT and once GI is posted, documentary batches are batches are updated in SAP S4H LE delivery.
Once a delivery is created, a documentary batch tab is appeared. This field is grey out, so documentary batches would be generated during WT creation.

In SAP EWM, /SCWM/PRDO, documentary batches shares the same field with real batches. You dont find any separate field for documentary batches in EWM.You can can give any batch number as per your need. If you need customer specific batch numbering, there are badi to use that for auto number for documentary batches.

On confirming WT and posting GI from EWM, documentary batch is updated in ERP. As a thumb rule, documentary batches are only updated once there is Goods movement.


You can print lebel of batch during shipping to customer and documentary batches can be recorded in RFUI as well.
Note:If you work with RFID or TRM functions, or call IDocs/BAPIs, you can only book in documentary batches by calling up the RFC-capable function module VBDBDM_DATA_MAINTAIN_RFC beforehand or incorporating it into the process.

Documenatry batches in recent years have seen more enhancements and it cab be used in below process as well
  1. Creating a return delivery to vendor, Vendor return process
  2. In network and in service orders.
References:

Do share your feedback to make it more productive.

Best regards
Shailesh Mishra

Yorkshire Water uses SAP Fiori Elements to build Fiori apps quickly

At Yorkshire Water we have been using SAP Fiori Elements for the past 18 months as part of our S/4 HANA implementation. In this blog, I’ll talk about what we did and why, how it improved our business agility, and what the Yorkshire Water people think about their new apps.
Our SAP Fiori Elements project
Project goals
In our old ECC System we made extensive use of the classic HR transactions (PA20, PA30, etc.).  Whilst these are ok for experienced users, they aren’t user friendly for occasional users, so we wanted something that ‘just worked’. To address this, especially for new employees entering the workforce, we wanted to build nice-looking and intuitive Fiori analytical apps that ran with minimal clicks, allowing end-users to get the information they needed quickly.  The apps would help HR professionals and line managers to act by exception rather than needing to trawl through long lists in Excel.
The process
We started working with SAP Fiori Elements in March 2018 as part of our preparations for migrating to SAP S/4HANA. Our SAP S/4HANA go-live was planned for July 2019, so we spent around 3-4 months investigating and learning Fiori Elements along with other required technologies such as CDS (core data services) and OData (open standard for querying databases).  We had one developer focusing on gaining knowledge of SAP Fiori Elements, with another focusing on CDS and OData. Much of our learning was by trial and error. More on that later.
Ultimately, we ended up building around 45 apps. These run from a set of 60 OData services, which include both basic and composite views that filter or aggregate information.
Screenshot with sample data showing the People Manager Analytics Dashboard delivered using the Overview Page template in SAP Fiori Elements
Business results
Once we figured out how to build SAP Fiori apps using SAP Fiori Elements, we showed some samples to our end-users and the overwhelming response was that they were really impressed with the speed, capability and end-user experience. We ended up building all our end-user HR analytics from our SAP S/4HANA system using SAP Fiori Elements.  We built:
  • Overview pages with cards for specific HR information for people managers and HR business partners
  • Dashboards for specific HR topics such as compensation, workforce distribution, and diversity
  • Business intelligence for gender pay gap (which we report to the government) and ethnicity pay gap (which we track internally to enforce equity in this area – planned to go live soon)
These pages give key metrics through simple and intuitive screens. They save lots of time over manually clicking through the classic transaction to search for information or preparing, distributing and reading Excel sheets.  As we are running on SAP S/4HANA the reporting is all done in real time – no waiting for process chains to load overnight in to SAP BW. These new apps significantly reduce the workload of our dedicated HR Management Information team who used to compile this information in Excel. They can now spend more time on analysis and action, rather than just moving data around.
SAP Fiori Elements allows us to provide a consistent flow that people can follow through all our HR apps. Cards on Overview Pages allow our users to drill down from a high-level summary to the relevant list report or analytical list page. We make heavy use of both visual filter bars and traditional filters so people can find what they need with a minimum of clicks.
Screenshot with sample data showing workforce attrition rates delivered using the Analytical List Page template in SAP Fiori Elements
Challenges
My biggest gripe about developing apps with SAP Fiori Elements was the documentation. The main documentation that defined what the user experience should look like was very well-defined. However, it was not clear how to achieve this look with SAP Fiori Elements – the technical documentation was very much a ‘work in progress’. This resulted in us trying many approaches to see what worked – with lots of failure and frustration. Eventually, we reached our goal, but the process was more painful than it needed to be. I learned at SAP TechEd that SAP are working on improving this and we have noticed improvements over the last few months.
Final thoughts about SAP Fiori Elements
SAP Fiori Elements is simple for us to use to rapidly develop analytical visualisations. We can build the apps we need quickly, and we don’t need a massive team of developers to achieve this.  SAP Fiori Elements means all our apps look consistent and the underlying power of SAP S/4HANA makes most screens instantaneous. We are also able to deploy our apps rapidly to our users through the Fiori Launchpad.
Most important, the feedback from our end users is extremely positive. They save lots of time every day. They can just click on the SAP Fiori launchpad and immediately launch the new HR apps and have access to the information they need to do their jobs.  We are now seeing other areas of the business asking how they can harness SAP Fiori Elements to visualise information they want to get out to end-users.
About Yorkshire Water
Yorkshire Water provides water and waste water services to the 5.4 million people who live and work in the Yorkshire region of the UK. We have around 3,500 employees, many of who are mobile, driving around to ensure we provide the reliable service that people expect, and maintaining our pipes to detect, repair, and prevent leaks. We have several hundred people managers, who are the primary users of the HR apps we have built using SAP Fiori Elements.
Learn more
Recording of the SAP Fiori Elements session I attended at TechEd Barcelona: https://events.sap.com/teched/en/session/51557
More on Yorkshire Water: https://www.yorkshirewater.com/

Analysis of tax codes master data

Hello SAPers!
If you check the topics of my blog posts, you will notice my obvious interest in topics around automatic payment program and bank statement. However, being SAP FI consultant who works extensively with Ukrainian localization, my main specialization is VAT accounting.
I’ve been responsible for implementation of VAT localization for Ukraine, Russia, Kazakhstan as well as Belarus and Georgia. Although these are different countries, there is one common denominator – complex legal landscape and a lot of special reporting requirements. Considering that VAT reporting in SAP is heavily based on tax codes, implementation of VAT processes usually implies creation of many tax codes. For instance, concept of tax codes for Ukraine on one of my recent projects involved 75 tax codes.
On one hand, that doesn’t sound overtly complicated. On the other hand, consider typical tasks of consultant during project life cycle:
  • Design concept of tax codes for a country;
  • Devise a tool to create these tax codes en masse, usually LSMW;
  • Check the settings of tax codes in the system.
While first two tasks are easy and might be considered as one-time activities, analysis of tax codes settings is more complicated. You might check all tax codes’ requisites / account determination in FTXP, but it will be very time consuming.
You might also use standard SAP report RF_STEUERINFO (accessible via t-code S_ALR_87012365). It contains all necessary details in one place – but it doesn’t support export to Excel and essentially, you’ll have to check each tax code separately. Example of a standard report can be found below:
Now consider, that you’ll have to analyze tax codes settings in each system i.e. development, quality and production. Your project landscape might involve even more systems e.g. sandbox, additional systems for trial loads, pre-prod system, training environments etc. As a result, you will spend a lot of time on analysis, which can be significantly reduced.
Lately, I had a bit of free time and decided to improve my ABAP-skills. As a result, I’ve developed small report on tax codes master data. This report has two modes – i.e. translations mode and settings.
In translations mode, you can review tax code names in all languages:
Settings mode allows you to review all tax codes’ requisites along with GL accounts. Report will list all condition types maintained for a tax code and all GL accounts.
Both reports are ALV-based and can be easily saved into Excel and compared with target values.
The project is open-sourced. You can find a link to a GitHub repository here and install it via abapGit. Let me know how it works and raise issues if something is wrong.

Regards,
Bohdan Petrushchak

quinta-feira, 27 de fevereiro de 2020

New videos showcasing SAP Fiori 3 for SAP S/4HANA

If you’re looking for examples of how SAP Fiori actually helps users get their work done more easily: we have created a series of two minute videos with some concrete examples, including for the first time some examples showing the Situations approach for surfacing machine intelligence, and an example showing the seamless integration of SAP S/4HANA Cloud and SAP Analytics Cloud.
The SAP Fiori 3 target design aims to enhance SAP Fiori to support consistencyintelligence and integration. Many SAP products now already provide first steps towards consistency by supporting the SAP Fiori 3 theme “Quartz Light” and the shell header bar; below you can see first examples for intelligence and integration.
The series starts with two introductory videos, which some of you may have already seen:
The subsequent three videos each give an example of how a user can quickly and easily perform a given task using SAP S/4HANA with SAP Fiori, and are updated versions of the three videos I published a year ago, with additional content:
Two of the next three videos show how the Situations approach introduced by SAP Fiori helps SAP S/4HANA users deal with important but not-so-common business situations, and one shows the seamless integration between SAP S/4HANA Cloud and SAP Analytics Cloud:
If you are not familiar with the Situations approach, let me summarize it briefly: it is a powerful approach for helping users deal with not-so frequent but important business situations. The system
  • recognizes when a business situation occurs;
  • notifies the responsible user;
  • provides the user with an explanation of the situation, and
  • provides guidance and recommendations on how to deal with it.
Identifying a business situation and determining appropriate recommended actions can be done using machine learning or rule-based. The power of the approach comes from the way it helps users: the notification means they are informed in a timely manner, and the explanation and recommended actions mean that users can save a lot of time by having all the relevant information presented to them in one place, rather than having to search for it themselves throughout the system.
The Situations approach is under continuous further development, and is one of the key elements of the SAP Fiori 3 target design, so stay tuned to learn about further improvements going forward.
For more insights into the currently supported design concepts behind the situations approach, have a look at the Situation Handling section in the SAP Fiori design guidelines.