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


Read Pricing Condition Text using ABAP in SAP Sales Document Output

Recently I had to read and display SAP pricing condition text or translation on a SAP sales document output using ABAP code. Although I had the pricing condition type code KSCHL in invoice output interface IS_BIL_INVOICE IT_KOND "Billing Item: Condition Records" table, the condition type text is not provided in any part of the interface. So I had to query SAP table T685 "Conditions: Types" and T685T "Conditions: Types: Texts" table for the translated condition text.

In this ABAP tutorial, I'll share a sample ABAP code that SAP developers can use to read pricing condition text in any language.

Before starting to code in ABAP, let's check the table structure of T685T ABAP table which stores condition texts for pricing condition types as well as for other conditions used in SAP system.

SAP sales condition texts from T685T ABAP table

As seen in above table structure, the translated condition name text is stored in VTEXT field which is 20 characters long. But to successfully read the pricing condition name text we had to filter the table with correct KVEWE (usage of the condition table) field and KAPPL (application) field.

Since this ABAP tutorial demonstrates how to read item pricing conditions on an SAP invoice output, the KVEWE value will be used as 'A' and KAPPL value will be used as 'V' in the ABAP query which is executed over T685T table.

Following sample code displays on screen the pricing condition names of a billing document with given invoice number.

DATA gv_knumv TYPE knumv.
DATA gt_konv TYPE TABLE OF konv.
DATA gs_konv TYPE konv.
DATA gs_t685t TYPE t685t.
DATA gv_condition_text TYPE vtxtk.

SELECT SINGLE knumv INTO gv_knumv FROM vbrk WHERE vbeln = '1609650002'.

SELECT * FROM konv INTO TABLE gt_konv WHERE knumv = gv_knumv.

LOOP AT gt_konv INTO gs_konv.

 SELECT SINGLE * FROM t685t INTO gs_t685t
  WHERE kvewe = 'A' AND " A = Pricing
   kappl = 'V' AND " B = Sales/Distribution
   spras = 'E' AND
   kschl = gs_konv-kschl.
 IF sy-subrc = 0.
  gv_condition_text = gs_t685t-vtext.
  WRITE: gs_konv-kschl, gv_condition_text, /.
 ENDIF.

ENDLOOP.

Below the output of the above ABAP program is shown. There are two pricing conditions defined and their texts are displayed beside the condition types.

list SAP sales condition names using ABAP

Of course ABAP developers can query T685T Condition Type Texts table for other condition types too. If you filter T685T with kvewe value equal to 'B', an ABAP developer can list Output message types and their names.

Here is the values to be used as KVEWE "Usage of the condition table" field.
1 Customer Charges
2 Routes
3 Campaign Determin.
4 Reserved for ETM
A Pricing
B Output
C Accnt Determination
D Mat. Determination
E Rebate
F Index
G Listing & Exclusion
H Batch Determination
I Profile Determin.
J Grid Determ.(IS-AFS)
K Val.Add.Serv.(IS-AFS)
L SeasonDeterm(IS-AFS)
M Portfolio Determin.
N Free goods
O
P Packing Obj. Determ.
Q
R Derivation
S Statistics
T Data Collection
U APO
V EH&S
W IBU High-Tech
X Statistics Extra
Z

And for the KAPPL field values that can be used to filter and read condition type names table T685T, here is a list of some KAPPL values on a SAP system

Application:
V Sales/Distribution
V1 Sales
V2 Shipping
V3 Billing
V4 Shipping (Spec.Case)
V5 Groups
V6 Handling Units
V7 Transport






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table






Related Articles and Tutorials(http://www.kodyaz.com/sap-abap/read-sales-document-pricing-condition-text.aspx)
Delete All Data from SAP Database Table
How to Execute SAP Program in Background Task
Export SAP Data to Fixed Length Text File
How to Debug Popup Screen in ABAP
Check Existence using ABAP SELECT
Create Business Object in SAP
How to Upload Data to SAP from Excel File using alsm_excel_to_internal_table Function Module
ABAP - Create Hierarchy Tree List using rs_tree_construct, rs_tree_list_display and snodetext
ABAP Tutorial - ABAP String Split Example Code
Upload Data from Excel File in ABAP using TEXT_CONVERT_XLS_TO_SAP
Create CL_GUI_ALV_GRID ALV Grid Column Header using ABAP Data Element
How to Create SAPScript Text using SO10 Transaction Code
ALV Grid Color - Table Row Background Color in ALV List
SAP ABAP Tutorial - ALV Grid Example with cl_gui_alv_grid and Screen Painter
SAP Smartforms - How to Call Smartform within ABAP Program
ABAP Tutorial - SAP Split and ABAP Split String Function
SAP Tutorial - Convert Spool Request to PDF File using RSTXPDFT4 ABAP Report
Set Default Single Values List for SAP Selection Screen Parameter
ABAP Debugging using Log Point and Break Point
ABAP RegEx for ABAP Regular Expression to fetch Date from String
ABAP Runtime Error ST22 Transaction using Short Dump Analysis
ABAP Shared Memory Objects Tutorial with Sample ABAP Code
ABAP Try Catch for exception is neither caught Code Inspector Error
Add Year, Month or Day to Date Variable in ABAP using RP_CALC_DATE_IN_INTERVAL
Read Address Data using FM ADDR_GET instead of Querying ADRC Table
ABAP Authority-Check Object For User Other Than Current
SAP Code Inspector for ABAP Break-Point Statement
Call Function Module using RFC Destination in ABAP
CALL_FUNCTION_NOT_FOUND ABAP Run Time Error
How to Spell Numbers using ABAP Spell_Amount Function Module
Convert the table using the Database Utility (SE14)
Convert Sales Unit into Text using Function Module in Target Language
Create SAP Dynamic Variant using Date Calculation
Create SAP Transaction to Maintain ABAP Table using SM30
Database Hint Pseudo-Comment for SAP Code Inspector
Delete Entries in NAST Table using RSCLNAST ABAP Program
Dynamic Programming using Field Symbols in ABAP Reports
Prevent DYNPRO_SEND_IN_BACKGROUND Error in Background Process
Execute ABAP Program Automatically After Transport Request Import
How to Find Internal Table Row Count in ABAP
Get Fullname of SAP user using Function Module in ABAP Program
How to Find User Exits in ABAP Codes of SAP Transaction
Read Integer and Decimals of a Numeric Value in ABAP Programming
ABAP LOOP Statement with At New and At End
Move Minus Sign from Right to Left of Negative Number in SAP Smartform
Primary key change not permitted for value table
Read Pricing Condition Text using ABAP in SAP Sales Document Output
Read Text Symbols in Specific Language using ABAP RS_TEXTPOOL_READ
Get SAP Document Flow using SD_DOCUMENT_FLOW_GET ABAP Function Module
Export Table Contents into Text File and Download File
Search and Find SAP Transaction Code using SE93 or SEARCH_SAP_MENU
SAP Code Inspector Error: Select For Cluster Table Without Order By
ABAP Select Statement using Space instead of Null or Initial
SAP Code Inspector: Select-Statement can be Transformed
ABAP Tutorial for SET and GET PARAMETER ID Command
ABAP CONVT_NO_NUMBER Error on SP01 due SP01_WARN Parameter
Code Inspector: Unsecure use of FOR ALL ENTRIES
How to find string length using STRLEN ABAP string function
ABAP Submit Report to Run Another ABAP Program within Code
Transport Variants of an ABAP Program into Workbench Request
TVAP Item Category and SAP Table TVAPT for Text Translations
Update Multiple Variables in ABAP Select Single Statement
Function module is not released for the Internet
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement
Activate Fixed Point Arithmetic Flag for Open SQL Statement


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