cancel
Showing results for 
Search instead for 
Did you mean: 

Display the Rowlevel value in a Title UDF

Former Member
0 Kudos

Hi,

When i'm trying to display the row level price value of a Sales Order in a created Title UDF using FMS,

i'm getting the following error...

" Internal error (3006) occurred  [Message 131-183] "

My query is: " SELECT $[$38.14.Number]"

Accepted Solutions (0)

Answers (3)

Answers (3)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this:

SELECT $[$-38.14.Number]


Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi,

Please close this duplicated threads.

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordan,

Thanks for suggestion.

Thanks,

md.zak

former_member192773
Active Participant
0 Kudos

Hello MD,

You must also add a linenum to your query else your logic is not complete because one document could have more lines.

SELECT $[$38.14.Number] WHERE $[$38.LineNum.NUMBER] = 0


Note: change LineNum for the columnNumber

Regards Teun

Former Member
0 Kudos

Hi Aben,

Thaks for your reply.But,by using of your given query i'm getting error like.....

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '$38.LineNum.NUMBER'. 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement 'Blanket Agreement' (OOAT) (s) could not be prepared.

Thanks,

md.zak

Former Member
0 Kudos

Hi Zak,

Except if SAP as changed the internal of SBO, since always, it's not possible to query values in document's header from document's lines.

Others will confirm...

Regards,

Eric

former_member192773
Active Participant
0 Kudos

Hello md.zak,

My mistake, the salesorder must be already added to the database. Then it's possible to query the lines.

Is the salesorder already add to the database?

Regards Teun

Former Member
0 Kudos

Hi Aben,

No,before add  the sales order only i would like to display in UDF and then add that document.

Thanks,

zak

former_member192773
Active Participant
0 Kudos

Hello,

I think to achieve this, you must add some custom businesslogic with the SAP DI-API or use/buy a standard products like B1up or coresuite.

Regards Teun