Need tax code description

[Former Member]

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

[former_member212181 · Accepted solution]

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

[Former Member · Accepted solution]

Hi unnikrishnan

I am having a dought why we giving this If $[$3.0.0] = 'I $[$38.160.0] $[$39.95.0] what these metion can you please explain. It will helpful for me

Regards,

Vigneshwaran

[former_member212181 · Accepted solution]

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

[Former Member · Accepted solution]

Hi unnikrishnan,

I clearly understand, Thank you so much, For all modules like Business partner, Inventory, SO,PO etc, Will have $[$Item No.Column No.Field Type].

[former_member212181 · Accepted solution]

yes, same format.

If your query is only for a particular screen you can use $[Tablename.FieldName] also.

Thanks

Unnikrishnan

[Former Member · Accepted solution]

K thanks sir.

[Former Member]

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

[Former Member]

Hi verma,

In client place they asking Tax descrption need to appear near tax code in AR invoice because tax codes are only 8 characters, most users dont know which tax code in ar invoice, so that need the description.

Regards,

Vigneshwaran

[Former Member]

Hi Vignesh

Try by the below query:

SELECT DISTINCT T3.Name

FROM OSTA T0  INNER JOIN RDR4 T1 ON T0.[Code] = T1.[StaCode]

inner join ORDR T2 ON T1.DocEntry=T2.DocEntry

INNER JOIN OSTC T3 ON T3.Code=T1.StcCode

where  T0.[Code] = T1.[StaCode]

group by T3.Name

Regards,

Bhushan Verma