How to get Table-Name by FormType

Konstantin

Hello everybody,

I have a rule that works for all Sales- and Purchase Documents where I execute some SQL for the particular table (e.g. OINV or INV1 for the AR Invoice).

I wondered if there is some functionality to get the table-name by the FormType.

As you all know the designer can replace things like "O@@RDR" with the exact table-name when the SQL is executed through LD.QueryData().

Is there something like this for the customizer?

Greez and Thanks!

ChristianB

Hi,

the Table for the Head-Table is the first SystemDatasource of Documents. So you can "Loop" thru the SystemDatasources, get your TableName in the very first Datasource and Exit the Loop

Best Regards

Christian

Fiona Shao

Hello Konstantin

So far we don't have this function in customize, but this is a really nice idea. we will think about this in our next roadmap. and meanwhile, you could write a global function to check active form type and return the table name in the extended code.

best regards

fiona 

Konstantin

Thanks.

A global function is fine so far. Some built-in functionality would be nice.