SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Install SAP Free

Invoice Output fail because of missing Billing Type text in TVFKT table

In SAP system, although we could successfuly display output file for a specific invoice, we could not display the same output file when we logon to SAP system in Russian (RU) language. The error we get when we try to display output is pointing that either billing type is not defined in customizing or no text exists in TVFKT table where billing type translations is stored for logon Russian language.

Вид фактуры Z3F2 не предусмотрен
№ сообщения VF312
The specified billing type Z3F2 is not permitted.
The following causes are possible:
The billing type is not defined in Customizing
No entry exists in text table TVFKT for the billing type in the logon language
System Response
The system does not allow further processing of the document.
Create billing types, carry out changes as well as display existing table entries by using Customizing. Inform your system administrator.
If the billing type already exists in the logon language, maintain the missing text in Customizing.

output error due missing text translation in SAP TVFKT table
Error due to missing billing type text in TVFKT table

Then using SAP transaction code SE11 (Data Browser), I browsed ABAP table TVFKT table for billing type Z3F2 and output language of the invoice (from NAST table, I see the SPRAS language field value is RU-Russian). Just as pointed as a result of the above SAP output error message, there was no entry existing in TVFKT SAP table for billing type and language type.

browse SAP table TVFKT using SE11 transaction
TVFKT table with no entry for billing type and logon language because of missing translation text in SAP Customizing

So I decided that the error is because of missing text in Customizing of related billing type. The following steps are for providing the missing translation text of sales invoice billing type in customizing using SPRO transaction code.

First execute SPRO transaction for starting Customization

SAP Customization SPRO transaction
Start SAP SPRO transaction

Follow the path: Sales and Distribution > Billing > Billing Documents > Define Billing Types

Define Billing Types for SAP Billing Documents
Use Define Billing Types customization screen for providing missing text translation

Choose Define Billing Types

Define Billing Types for SD documents
Perform Define Billing Types activity

When the Billing Document Types list is displayed it is editable so you can make customization changes on billing document types. If you only want to see details and do not want to make any changes, then change into read only display mode immediately. This will prevent an accidental update on billing document types and also will not lock screen for other users who want to change billing document type details.

Choose the related billing document type and press view details icon on top menu

change Billing Document Types using SAP Customization screen
Change View "Billing: Document Types"

For my case I chose Z3F2 billing type from list and displayed details for this document billing type.

On the detail screen using top SAP menues, follow Goto > Translation in order to see if translation for language Russian is missing or not. If billing type text translation is missing, SAP customizers can also provide the translation text using same screen.

SAP translation menu for Billing Document Type text
Billing Document Type Translation menu option

A long list of available languages will be displayed as seen in below SAP screenshot. Mark your target language or SAP languages to check for missing text translation.

SAP translation languages
Available SAP languages for translation of billing type

When I chosed and displayed Russian for translation of Z3F2 billing type, I see that the translation text is empty. So I provided the same text as in English for the Russian language as seen below.

SAP translation of billing type text for missing languages
Translate billing type text for translation missing languages

After this simple customization step, I saved changes and created a new SAP customization request for distributing this change to other SAP systems using transport system. And after the changes are transported to SAP test system, the SAP Smartform invoice output is successfuly displayed on VF03 output preview screen. So entering text translation to text table TVFKT for the billing type in the logon language through SPRO customization tcode solved the first problem.

SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table

Meetup Sunumu 1 meetup

Related Articles and Tutorials(http://www.kodyaz.com/sap-abap/missing-billing-type-text-in-tvfkt-sap-table.aspx)
Complete List of SAP Modules
SAP Invoice Output ZZZZ is not Defined
Sales Tables among ABAP Tables (SAP Sales and Distribution SD Tables)
SAP Invoice Output Determination Analysis for Not Created Output Message
SAP Payment Terms Table and ZTERM Texts Table for ABAP Developers
SAP Smartforms Table for Sales Order and Invoice Outputs
Assign SAP Item Category to Sales Document Type using SPRO
Convert the table using the Database Utility (SE14)
Create Sales Order, Delivery and Billing Document in SAP
How to Find Output Determination Procedure for a Billing Document
Invoice Split due to Manual Invoice Maintenance Check on Sales Order
Invoice Output fail because of missing Billing Type text in TVFKT table
Primary key change not permitted for value table
Get Proforma Invoice from Commercial Invoice in ABAP
SAP VKM3 to Release Sales Order from Credit Block
Get SAP Document Flow using SD_DOCUMENT_FLOW_GET ABAP Function Module
SAP Purchase Order Tables, Transaction Codes and Output
Trigger Output Re-Determination for Billing Documents
TVAP Item Category and SAP Table TVAPT for Text Translations
Update Database Table Data using ABAP SE16N_INTERFACE
VF31 SAP Transaction to Reprocess Billing Output Messages
How to Find User Exits for Billing using SPRO

Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems