What is MT101 file format and it’s application in SAP

MT101 message is a request to transfer fund from payer’s account to receiver’s. To make the transactions like this, MT101 message format is used to do the communication.

Below is the sample MT101 file format:

MT101

Why and where MT101 message type is used?

Well it can be understood if you look at the body of MT101 format. The body of SWIFT MT101 Message contains header, sender/ordering party details and customer/receiving party details. It means there will be blocks of each transaction in MT101 file and each transaction block will contain sender and receiver details.

Now let’s look at the other file formats, which body contains header, transaction details and footer. So these formats are specifically for sending payment from one bank to other receiver’s banks. But MT101 file is made for paying through multiple banks to many banks.

In easy words as mentioned above each transaction will have one sending bank and one receiving bank in MT101 format. So in single file there might be multiple sending banks and multiple receiving banks.

Hopefully now we understand use of MT101 message but now question arises is how a company/organization use this and how it can be helpful than other file formats?

To understand the answer of this question, We would like give you a scenario. Imagine a multinational company based in USA, who is spread across America having hundreds of company code and thousand bank accounts.

Now when in SAP you do the payment run from each bank account there should be a payment file configured for each bank. Imagine the efforts of having this much DME structures and payment files. It’s a huge activity of maintaining these file formats and matching the all requirements. This is where MT101 helps. With this you can use MT101 format for every bank. All the payment files from all banks will be created in MT101 format.And we know the structure of MT101 (header, sender details, receiver details). Now the trick here is, we don’t send MT101 directly to bank unlike in other file formats. Because we don’t know whether bank will understand MT101 or not.

So we send all the files to a middle man i.e. SWIFT which act as a middle-ware here and then SWIFT reads the MT101 and take call to which bank this file should go for payment. This is the reason in each transaction MT101 haves details of sending bank/company. This process is helpful to the organisations who use IHC (in house cash management). Who have worked on the IHC might be easily relate to this or find how useful is this.

Thanks for reading, if you want to learn more about bank payment files and DME in SAP then you can checkout this eBook.

Read More
SAP College August 24, 2021 0 Comments

What is SAP Co-Pilot?

Imagine you are sitting on your couch, scrolling through Instagram, it’s 21:00 o’clock, you are done with dinner and planning to go to bed… almost all of the items in your to do list is checked…

And suddenly you realize that you forgot to punch a Purchase order against the purchase requisition raised by IT department. The requirement is for procurement of headsets and it is urgent, the PO should have punched today itself. So you decide to create purchase order…

Now imagine the pain of getting up and reaching to your home office desk/laptop, logging in, connecting through all of VPN and then follow all of the necessary steps to create purchase order without getting distracted by the emails or the messages you may have received.

Now, instead of doing all of this, what if someone do it for you. Like you ask google assistance/Siri/Alexa to set an alarm for you, like you ask them to call xyz person. What if you get a similar bot and you ask that bot to ‘show me all of the purchase requisition created for headset requirement’ and the bot replies you with the appropriate requisition number and a soft copy of that requisition on your smartphone. You check the details of the requisition and then you ask bot to create a purchase order for this xyz requisition… and within few seconds the bot replies you with the created purchase order and soft copy of it….

Wouldn’t it be amazing? If you think it is, then it’s here the bot name is SAP Co-pilot and it can do many more things than what we imagined in above example. Explore more about co-pilot in below video..

Read More
SAP College June 11, 2021 0 Comments

What is Rise with SAP?

Basically it’s an offer, SAP has launched after pandemic. SAP has offered a package of components along with S4HANA.

Rise with SAP is a movement where SAP wants to help customers to move on to the latest technologies with the most efficient and faster way. SAP has divided customers into three categories:

  1. ECC customers
  2. S4HANA customers
  3. New customers

Now there are just so many things out there for new customers as well as ECC customers to choose from and also there are S4HANA customers but all are on different level, some have opted in 2015 some have in 2018 and all of the customers are wondering what should be the next step… this is where Rise with SAP comes into the picture

SAP wants to build an Intelligent enterprise to run and streamline complex innovative scenarios. To help businesses streamline their processes differently with the help of Intelligent suite (i.e. S4HANA) and Industry cloud. It helps businesses to not only became profitable but to be sustainable in long run.

Below slide provides an idea about how SAP will help implementing the Intelligent enterprise:

  1. Help businesses to Redesign business process
  2. Provide necessary Tools & services for smooth migration
  3. Provide Infrastructure, Platforms, Required Application and Network

What SAP is offering in Rise with SAP offer:

Packages included in this offer and how customers can buy this:

S4HANA private cloud edition:

for more information about Rise with SAP watch this webinar.

If you have any suggestions or questions do let us know in the comment section or you can also write us directly. 

Sign up with us to get an update of a new blog post.

Till then you can have look at our ebooks.

Read More
SAP College February 9, 2021 0 Comments

GST India – E-Invoicing

1.     Introduction

GST E-invoice is introduced to reduce the evasion of GST. It is an electronic invoice generated by supplier on the government portal. It is mandatory to issue e-invoice for Business to Business (B2B) transactions provided that the supplier has crossed the threshold limit of 500 crore turnover in previous financial year.

E-invoice solution provided by SAP:

For more details refer OSS – 2884058 – SAP solution for eInvoice/IRN India

SAP has provided two solutions for eInvoicing

  • Automated Solution

This is a solution developed by SAP which will provide direct integration between the SAP and the eInvoicing (IRN) via certifiedGSPs using the SAP Cloud Integration Platform. 

GSP:  GST Suvidha Provider (GSP) is considered as an enabler or authorised intermediary for businesses to access GST portal services.

In automated solution user has to upload the invoices from SAP, then in the backend it will be send to IRP portal via GSP and generate an 64 digit IRN (Invoice reference number) along with signed QR code; returned it back to SAP and assigned to the invoice or stored in the database.

  • Manual Solution:

SAP manual process will read the response file and store the information of IRN, QR code & digital signature in the standard table and it will link the original invoice with IRN along with the current status in the table. The preparation of a standardized format (JSON request file) needs to be generated offline by the customer.

2.     EDOC_COCKPIT

In eInvoicing solution SAP has introduced the cockpit to manage the all activities related to edocument. How to use it and what we can do with the cockpit we will see in below part:

Execute transaction code EDOC_COCKPIT

Below screen will be prompted:

EDOC_COCKPIT

Default variant is executed in the background after executing the cockpit

To change the variant value click on Change button:

We can use above parameters to filter the edocument

In the cockpit there are only two status of the document on broad level

 

In process

 Completed

Once the status is completed, there will no further processing can be done on the document.

To generate an edocument and get IRN number select the document:

And click on the submit

That’s it, within couple of seconds system will reach to the IRP portal and generate an IRN number and get back to the SAP

You can notice even after generating an edocument status is still yellow (in process)

Scroll to the extreme right to see the Invoice Reference Number

The highlighted number is the 64 digit alpha numeric IRN

Cancellation of IRN

Cancellation of E-document is only possible if we are cancelling it before 24 hours and the invoice is not finalize in the SAP

Select the E-document and click on Cancel eDocument

Enter the cancellation reason code from below available options:

  • Duplicate
  • Data Entry Mistake

Click on save

And the edocument does not get cancelled, to check the error select the document and click on ‘goto’ button

Click on application log

Errors and checks

Duplicate IRN:

IRN will not be generated for invoices with identical key parameters (Eg: Supplier GSTIN, Invoice Number/ODN, Document type, Financial Period, etc.). In case there are invoices generated with identical ODN, assign a separate number range in the view EDOINEWBCONFIGV.

RCM cases:

IRN is only required for B2B RCM invoices from the supplier perspective and not from the buyer and receiver perspective as this is not a legal requirement and there is no API available for the same in Govt. portal.

Finalize:

After finalizing, no action can be performed on the e-Document. The status color will be green once finalizing the e-Document is done.

Cancellation:

According to govt, IRN cancellation can only happen within 24 hours of its generation. Any cancellation after 24hrs could not be possible on IRN, however one can manually cancel the same on the GST portal before filing the returns.

If the source document needs to be canceled in SAP post 24 hours of IRN generation:

  1. Perform the ‘Cancel eDocument’ action under ‘More’ in EDOC_COCKPIT and it should fail with the error “Error Code 2270: The allowed cancellation time limit is crossed, you cannot cancel the IRN.”
  2. Use the ‘Allow Cancellation’ action under ‘More’ in EDOC_COCKPIT to enable the cancellation of the source document. The status will be changed to ‘ALLOW_CANCEL’ to allow source document cancellation.

Note: This does not have any impact on IRP portal data and only allows to cancel source document in the SAP system. After canceling the source document, ensure to cancel the outward liability while filing GSTR1 returns.

Below customer categories requires to generate edocument.

GSTIN / UIN Status

Tax Payer TypeGSTN StatusCustomer Category
RegularActiveB2B
Tax DeductorActiveB2G
SEZ UnitActiveSEZ
SEZ DeveloperActiveSEZ
CompositionActiveB2B

This blog will be update time to time as this is new thing in India and government seems to be serious with the edocument concept looks like we will see more changes in near future.

Sign up with us to get an update of a new blog post.

Till then you can have look at our ebooks.

Read More
SAP College November 28, 2020 0 Comments

Ways to find Tables and Transaction codes in SAP

One thing is for sure that we cannot remember every table and transaction related to any or all modules, and processes. So to make there are couple of ways which we can use to find out T-codes and tables without knowing anything.

1.    From scratch

If you don’t know the tcode or table you are searching for then the transaction SE16T will be useful for you.

Here let’s say for example, you have to find out the tcodes related to the production order

Go to SE16T

SE16T

Double click on the Find Transaction – Execute Function

On the left hand side a new option will be visible at the top, which is to search transaction term.

Now in the inputable search field we will enter ‘Production Order’ and press enter

And here you go, there are 45 transactions displayed which description contains name of the searched term.

If you look at the result it is much satisfying, this SE16N can be very useful, if we remember it and used it instead of wasting time on Google to find transactions.

Same way it works for tables, in SE16N double click on the Find Tables – Execute Function

Press enter

And we have the all tables related to accounting.

2.    From fields

This is very common way of getting the name of the tables. All we have to do is to press F1 in the field of the document.

For e.g. in Accounting document we need to check in which table header data of the document is recorded.

Select document number field and press F1

Click on the technical information

In the pop up window highlighted field usually contains the name of the fields.

3.    From the structures

Now in above scenario not all the time we get the name of the tables by pressing F1 on the field, many times we only get the structure names.

So in this block we will try to figure out, how to get table names for the fields in structure

For e.g. if we similarly go into the MIGO transaction and try to search for the table for header level of the document by pressing F1 – Technical information, we will get the structure ‘GOHEAD’

Double click on the structure GOHEAD

We will get the list of fields in the structure, now suppose we want to know the field MBLNR is used in which tables à then double click on the field

SE11

Select where used button

Tick the table fields option and press enter

Below window will pop up with the list of tables which contains the material document number field

The list will be alphabetically arranged.

Okay so I hope you enjoyed reading the blog, and hope you learned something new.

Read More
SAP College November 9, 2020 1 Comment