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, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.




Install SAP Free


SAP Output Types and Output Message Names or Text


ABAP programmers developing outputs for SAP sales documents or billing documents already know ouotput types are customized by SAP NACE transaction. If it is required to read text for SAP output message type programmatically in ABAP, developers can query SAP table T685B and T685T.

In SAP, output management is customized using SAP NACE transaction.
Here is a screenshot for Billing Output Types.

SAP Output message type customization in NACE transaction

As seen in screenshot, the output type and name for the output message type is displayed together.
Output types are stored in database table T685B table (Condition Types: Additional Data for Sending Output)

All output messages or outputs created for SAP documents are stored in NAST database table.
In NAST table there is only KSCHL field which is the output message type code without its description or text.

NAST and T685B SAP tables can be joined using KAPPL and KSCHL fields. OBJKY field in NAST table is the document number that the output is created for.

If as an ABAP programmer you are creating a report that will display SAP output message type (output type) with its description, following SAP table T685Tcan be used.
T685T table is for "Conditions: Types: Texts"

SAP output message type names

Following OpenSQL Select statement can be used to read output messages, their types and description.
Please note that I did not read any field from t685b table, but you should exclude this JOIN if you will not use it to read any data from t685b table.

SELECT
 nast~objky,
 t685t~kappl,
 t685t~kschl,
 t685t~vtext
INTO TABLE @DATA(lt_output_messages)
FROM nast
INNER JOIN t685b
 ON nast~kappl = t685b~kappl AND
  nast~kschl = t685b~kschl
INNER JOIN t685t
 ON nast~kappl = t685t~kappl AND
  nast~kschl = t685t~kschl AND
  t685t~spras = @sy-langu.





SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table


Meetup Sunumu 1 meetup






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