User Defined Values - Current Formtype

[#1]

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

[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