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 Sales Organization VKORG Text Description for Different Languages in TVKOT Table


If you are developing ABAP applications in SAP, you may require to know which SAP table keeps Sales Organization VKORG text and descriptions for ABAP developers.
While coding in ABAP recently, I required to display VKORG Sales Organization descriptions, so I need to find the SAP table where Sales Organization VKORG texts are stored.

Sales Organization VKORG text information can be found in TVKOT, Organizational Unit: Sales Organizations: Texts table in field VTEXT.

Here is a small part of a larger ABAP program where I read the text of VKORG - sales organization for the login language from TVKOT SAP table.
VTEXT field has the translated text and description for the related Sales Organization VKORG in TVKOT SAP table.

SELECT SINGLE VTEXT FROM TVKOT
INTO gv_VTXTK
WHERE spras = sy-langu
AND vkorg = gs_knvv-vkorg.
Code




If you open the ABAP Dictionary screen using SE11 SAP transaction code, you can find the structure of the TVKOT Sales Organizations Texts table as seen in the below screenshot.

sap-table-tvkot-sales-organization-texts



SAP HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


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