Display Row Level Data in Title UDF

[Former Member]

Hi,

The requirement is in SAP 8.8 PL 15. I have created an UDF in Marketing Documents - Title and would like to display the Location Code from the Rows (1st row) in that UDF using FMS.

I have a query that is: select $[$38.2000002049.1]

But it gives the error: Internal Error (3006) occurred. [Message 131-183]

This query worked in SAP 2005B PL 27. Can any one please help?

Regards

Sudatt

[Former Member · Accepted solution]

select $ [ $ 38.1.Number]

[Former Member · Accepted solution]

Hi Sarkar R,

I am sorry but this option is also tried and does not work. Wonder where and what the catch is.

Regards

Sudatt

[Former Member]

Hi

Try: select $[$38.2000002049.0\]

Thanks,

Gordon

[Former Member]

Hi Gordon,

I tried this too, but still the error. I am so sure it used to work in earlier version that I may have to believe that 8.8 probably has this restriction. Or may be I am committing a very silly mistake somewhere.

Regards

Sudatt

[Former Member]

Hi sudatta mohanty,

You can try this : $[$38.U_AAAA.number]

U_AAAA is UDF

regards,

H2

[Former Member]

Hi H2,

I am retrieving data from an SAP field, so this query would probably not work. But you gave me an idea to create a UDF in row level, replicate the Location data in Row Level UDF and try to display that in Title Level UDF. I am sorry I failed.

Regards

Sudatt

[Former Member]

Hi Sudatt........

Don't feel. You can do it by using SDK.

FMS is standard but if anything not possible by standard then it can be done by SDK customization which includes coding.......

Regards,

Rahul

[Former Member]

Hi Rahul,

Thanks for the booster. It has been delivered to the client we are working for, using SDK (it was a very small piece of code). But since I have already done this in earlier versions, I have not stopped doing R&D over this till the time I am sure that either 8.8 is not capable of pulling this off or I am doing something silly.

Thank you and all the guys who have and are still replying back to this query. I appreciate all the help.

Regards

Sudatt

[Former Member]

That is the spirit man.......

Keep on going......

If you done then i suggest you to please close the thread.......

Regards,

Rahul

[Former Member]

Dear Sudatta,

Few things wanted to know...Please correct me if I am wrong

1. You have created one UDF for marketing document Title level.

2. In Row level You Do not have any UDF carrying the Location code. (Or there is an UDF at row level for Loaction code)

Your Location Code is alphanumeric or Text (Location Name) or Number only?

What kind of UDF (Type of UDF) you have created at title level?

Regards,

Sarkar R

[Former Member]

Hi,

1. Alphanumeric UDF created in Title Level for Marketing Documents.

2. The Location column provided by SAP in 8.8 is to be used and the value fetched from the first row and displayed in the above UDF.

Regards

Sudatt

[Former Member]

Hi both the codes to fetch the line item's data -

select $[$38.1.0]

or

select $[$38.1.1]

will work in any built-in fields on header part alike, but not in in any UDF.

If needed you can fetch any header level built-in fields value to the UDF by the following type code -

SELECT $[ORDR.CardName]

For your info - a few changes are there in 8.8 on this context.

[Former Member]

Hi.......

Row level value does not come to headers level field. This is the limitation.....

Regards,

Rahul

[Former Member]

Hi Rahul,

I have done this and am sure that we can retrieve the first row data to any Title UDF in 2005B PL 27 and 2007B PL12 and the query was

select $[$38.1.0]

. It selected the Item Code and displayed it in the Title UDF.

Is this a limitation in 8.8 and onwards?

Regards

Sudatt

Edited by: sudatta mohanty on Jan 24, 2011 1:30 PM

[Former Member]

The query is not right for first row......

You should write it as

select $[$38.1.1]

for first row......

Regards,

Rahul

[Former Member]

Hi,

Yeah, I tried both the options (just to be sure it does not work) and both the options are not working. Though the query given by you works in 2005B PL 27 and 2007B PL 12.

Any more suggestions?

Regards

Sudatt

[Former Member]

Dear Sudha,

select $[$38.1.Number]

Regards,

Sarkar R

[Former Member]

Hi Sudatt.....

No more suggestions. Its final........

Regards,

Rahul