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, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




Install SAP Free


SAP Tables TVPRT - Commission Group Texts Table for ABAP


SAP table TVRPT named "Commission Group Texts" is used for storing SAP sales table of commission group texts.
On SAP Invoice screens which you can display using VF01, VF02 or VF03, if you double click on Sales Order Item we can display commission group data.
On the Item Detail tab, in Price Data section there is the Commission group list.

tvprt-commission-group-texts-sap-table





Recently, on a SAP Smartforms output document for SAP Sales Order Invoice, I had to display the Commission Group data on the Smartform.
So I had to fetch commission group code data VBRP-PROVG and then get the commission group text from SAP table TVPRT - Commission Group Texts.
You can find the commission group code in SAP VBRP table Billing Document: Item Data table for the related billing document and billing item.
Here is the ABAP code I used for commission group text where the PROVG is known.

CLEAR GV_VATCODE_DESC.

SELECT SINGLE VTEXT INTO GV_VATCODE_DESC
  FROM TVPRT
  WHERE SPRAS = 'IT' AND PROVG = GS_WEEE_KONV-PROVG.

CONDENSE GV_VATCODE_DESC.






SAP Resources

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








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