on 07-04-2015 6:38 AM
Hi experts,
I need to add tax code description in AR invoice Item row, i have searched in Form setting but its not available, how to create and how to link, Please do needful.
Thanks
Vigneshwaran
HI Vigneshwaran,
Please add Row level UDF in Marketing documents with name of Tax description
Save below query and use this for formatted search.
This will work for both Item and service documents of sales and purchase module
------------
If $[$3.0.0] = 'I'
Select A.Name from OSTC A where A.Code = $[$38.160.0]
else
Select A.Name from OSTC A where A.Code = $[$39.95.0]
------------
Thanks
Unnikrishnan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vigneshwaran,
Those texts are "Variables" to pick data directly from current / active screen.
For Ex:
Click on View > System information.
Then move your curser in Item/ Service Type field. Then you can see "I [Form =139 Item 3 Pane 1-4 variable 1 Table Name, Field Name] in message area [Down- Left side part of the SAP screen)
If you move your curser on Tax code field of (Item type Document), then you can see "I [Form =139 Item 38 Pane 1 Column 160 Row 1 variable 11 Table Name, Field Name]"
So for picking data directly from Screen we can use this code
$[$Item No.Column No.Field Type]
Field Type means Number for numeric, 0 for Alphanumeric value etc
For the first Case
$[$3.0.0]
For second case
$[$38.160.0]
Hope you understand and got answer for your question
Thanks
Unnikrishnan
Hi Vignesh
You need to make a row level UDF and then u need to define a FMS based on row level tax code used in marketing document.
But can u tell us why u need description
Regards,
Bhushan Verma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.