Where does the table for an instance of a documnet lie?

[Former Member]

Hi I'm looking to write some kind of query to find the latest instance of a particular document, I cant seem to find the table the instance number lies. I know you can find it via the tools show history menu but i need to find it within a table.

Thanks

Steve

[Former Member · Accepted solution]

Thanks I have data coming through now, however the instance column is still blank, i need it to bring through the particular instant log for that doucment?

[Former Member · Accepted solution]

Hi!

Now, instance wil come

Select o1.LogInstanc,*
from ADOC O1
where
LogInstanc >1

Close the thread !

[Former Member]

Thanks that has solved my problem.

[Former Member]

It's my pleasure too.

[Former Member]

Thanks I have data coming through now, however the instance column is still blank, i need it to bring through the particular instant log for that doucment?

[Former Member]

States there is no data for this selection criteria. Am i doing someting wrong?

[Former Member]

When i enter this query into the generator it errors?

[Former Member]

what error ?

put the error message !

[Former Member]

There does not appear to be a loginstance field in the table when looked at through the query generator.

[Former Member]

I have found the table, but cant find the field 'instance', I think it should be there because have looked at the system information within SAP B1 but cant seem to find it

[Former Member]

Hi!

Where u seeing ?

Execute this and see !

Select o1.instance,*
from ADOC O1
where
o1.instance > 0

For all the listed Documents you can see change Logs !

[Former Member]

Hi!

Check this Query

Select o1.instance,*
from ADOC O1
where
LogInstanc >1

you have did tht correctly, my query only wrong. Test it now !

[Former Member]

If it's a marketing document, it's the LogInstanc field in ADOC table.

[Former Member]

Hi!

You will fid it in

Table - ADOC and Field - Instance