Automatic field copying in SAP FI documents

Dmitry Kaglik

September 9, 2013

SAP

2 Comments

Entering the Financial document in SAP is not a difficult process, once you learn the transaction. You can do it either via the “classic” way, similar to transaction code FB01, or in a newer “Enjoy” style like transactions codes FB50, FB60 or FB70.

However, there are some routines which everyone wants to avoid: for example, copying of information between the fields.

The most obvious way to accomplish the task of field copying is to create a substitution. It will copy one field into another based on a set of prerequisites.
However, there are some SAP standard field copy rules, which you can use straight away, without any system configuration.

1. Document balance

You entered a document with multiple lines, each of them has a different Debit/Credit sign, and the last line item of the document should bring the balance to zero. Even if your document has as little as 2 line items, it is easier to “auto-balance” the document rather than type the amount manually.

The easy way to do so in SAP FI transactions is to put “*” (asterisk) into the Amount field. Press Enter, and system will automatically calculate the document balance and populate the Amount field with the necessary value. Now, you only need to Simulate or directly Save the document.

2. Document text

You typed in a long descriptive text in the document line item, as much text as 50 characters can allow. Go to the next line item, and it requires a text as well. Do you need to type that text again? No!

Put “+” (plus sign) into the Line Item text field, and the previously entered text will appear there! Remember, you can only copy a text from the previous line item, not the line item before that one.

3. Reference

You want to automatically populate the Reference field of the document. It is usually used for external references. But what if there are no external references? The most obvious case is Sales Invoice document – it is born directly in SAP, there are no external numbers.

Nevertheless, put “*” (asterisk) into the Reference field, and SAP will automatically populate Reference with a 10-digit document number. Of course, this only happens at the moment of document saving.

The most obvious way to use it are with Sales Billing documents, especially if some of your Billing Documents migrate from another system. You populate Reference with the real external number for migrated documents, and with the SAP document number for SAP-originated documents. Then, the Reference field always contains the document number which the customer sees. It can be used for cash allocation, for example. How to achieve this in SAP SD to FI integration? Talk to SAP SD consultants, or ask SAP Expert!

4. Payment document text

You want to have some user-defined text for the invoice on the remittance advice, or on any other payment-document related document that goes to your vendor.

It is easy. Start the line item text in the vendor line item of the invoice document with “*” (asterisk), and the text will come across to the SAP table REGUP, where payment-related information is stored. The field name is REGUP-SGTXT. Of course, your remittance advice or payment file should now extract the content of SGTXT field and place it on the output.

As you can see, SAP has already cared about providing some simplifications of user life. Which methods are in use in your company?

Related Posts

Top SAP Expert posts from 2021

Dmitry Kaglik

January 10, 2022

SAP

No Comment

The year 2021 is behind us. There were many articles published on SAP Expert blog that year, as well as during previous years. Let’s see what were the most read posts from 2021. Search Strings: Powerhorse of Electronic Bank Statement More Free SAP Training Do you need help with SAP Job interviews? As for the […]

Read More

Merry Christmas and Happy New Year 2022 from SAP Expert

Dmitry Kaglik

December 25, 2021

SAP

No Comment

My dear readers! It is holiday season again upon us! Another year has gone. 2021 comes to the end. The year of surprises, struggle, success and wins. Christmas is today, and New Year is just around the corner. Let’s celebrate these! Let’s make new and better plans for future year. SAP Expert had its ups […]

Read More

2 Comments

  • Andreas on February 4, 2014

    the dual use of SGTXT as a line comment field or as an external invoice number reference is not best practice.

Leave a Reply

Your email address will not be published. Required fields are marked *

Search this site

Polls

Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...

Search this site

Subscribe!

You can subscribe to our regular updates here.

Follow Us!

Polls

Will you be happy to pay for the 3rd edition of the book FREQUENTLY ASKED QUESTIONS ON SAP FINANCE?

View Results

Loading ... Loading ...
Disclaimer and privacy policy