Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

9 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 12:13 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 11:22 AM

    Hi!

    You will fid it in

    Table - ADOC and Field - Instance

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 11:23 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 11:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 11:27 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 12:01 PM

    When i enter this query into the generator it errors?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 12:06 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 12:13 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 13, 2009 at 12:16 PM

    Thanks that has solved my problem.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.