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