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 Sales Division SPART Text Description for Different Languages in TSPAT Table


During ABAP development in SAP recently, I required to display Sales Division information SPART text and SPART description in the sy-langu language translation.
Division SPART text information is in TSPAT, Organizational Unit: Sales Divisions: Texts table in field VTEXT.

Here is an example small ABAP code part of a larger ABAP program where I read the text of SPART - sales division for the login language sy-langu from TSPAT SAP table.
VTEXT field of the TSPAT table contains translated texts and descriptions for the required Sales Division SPART in TSPAT SAP table.

SELECT SINGLE VTEXT FROM TSPAT
INTO gv_SPART_VTXTK
WHERE spras = sy-langu
AND spart = gs_knvv-spart.




When the ABAP Dictionary screen is displayed using the SAP transaction code SE11, the following table structure of the TSPAT Sales Divisions Texts table will be seen as seen in below screenshot.

sap-tspat-table-for-organizational-unit-sales-divisions-texts







SAP Resources

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








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