ItemNo

[Former Member]

Hi all,

Where can I find the Item number of the filed "ObjCode" in the sales documents.

Thank's

Liat

[vasileiosfasolis · Accepted solution]

Hi Liat

do you mean objtype?

if yes you can try

select objtype from oinv

[Former Member · Accepted solution]

Yes, Thank you

[Former Member · Accepted solution]

I need the Filed Item number not his value

[Former Member · Accepted solution]

Hi

What do you mean by Field Item number ??

Regards

[Former Member · Accepted solution]

Hi,

I want to bring into the query the value from the active window (formatted serch).

exemple: SELECT $[$33.0] for the filed Balance due in sales doc or SELECT $[$4.0] for the filed Card code in sales doc.

So I neet the item Number for the filed ObjType.

Do you know the table where the item codes for the fileds are saved in?

Thank you

Liat

[Former Member · Accepted solution]

Hi Liat,

Those Item# are form specific number. Only if the fields exposed to UI, you can found the item#. I don't think ObjType field is included in the form.You can find BaseType or TargetType though.

Thanks,

Gordon

[Former Member · Accepted solution]

Ok, Thank you

Do you know if there is a function for that.

Like if I want to bring the user I use the function $[USER]

Thank's, Liat

[Former Member · Accepted solution]

The global variables such as $[user\] are too few. You may only find a couple of them. Since the document level fields are hidden to us if they are not displayed, it would be too hard to find even if they exist.

[Former Member · Accepted solution]

OK, Thank's