User Defined Values - Current Formtype

[wrede_tobias_schwarz]

Hi everyone,

I need the current form Type for a user defined value (the query).

I know $[$4.1.0] == Itemcode and so on.

But I need eg. Formtype = 149 when the Query is run in an Quotation. The TableName OQUT would also be sufficient.

Thank you for your help

Tobias

[kothandaraman_nagarajan · Accepted solution]

Example:

$[OQUT.Cardcode]

$[QUT1.ItemCode]

[OlehFabri]

Hi Tobias,

You can retrieve the object code based on the series as follows:

SELECT "ObjectCode" FROM NNM1 WHERE "Series" = $[$88.0.0]

The rest should be a matter of technicality. Based on the Object Code you can further append either the respective database table or Form ID. Just in case, the list of Object Codes with the database tables is available e.g. here:

https://blogs.sap.com/2017/04/27/list-of-object-types/

[wrede_tobias_schwarz]

That's great - Thank you

[kothandaraman_nagarajan]

No, we can not use form ID in FMS. only column or table name can be used.

[wrede_tobias_schwarz]

Hi Nagarajan,

what would be the Syntax for the table ?

Thank you for your help.

Kind regards Tobias

[kothandaraman_nagarajan]

Hi,

Your requirement is not clear. Please explain with more details.

Regards,

Nagarajan

[wrede_tobias_schwarz]

Hi Nagarajan,

when you create an user defined search STRG SHIFT F2

U can use SAP Variables like $[$4.1.0] to access the values in the field.

My question is ... Is there Variable in the user defined search for the Form ID ?

Kind regards

Tobias

[LoHa]

Hi Tobias,

I already asked for an improvement here:

https://influence.sap.com/sap/ino/#/idea/275157

It would be nice if yo could vote for it

regards

Lothar

[wrede_tobias_schwarz]

Hi Lothar,

ist erledigt.

Gruss

Tobias

[LoHa]

Danke sehr