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
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow

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.
Code


SAP HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.