Skip to Content
avatar image
Former Member

How to find new entries and updates in table BSIS

Dear ALL,

I am trying to find out how many new documents being created in table BSIS and if any modified in previous day everyday. Can you help ; how can I find that. I tried CDHDR and CDPOS; there is no entry for BSIS there. Can anyone help urgently

Regards

Rekha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 20, 2017 at 01:17 AM

    Hi Rekha,

    Go to SE16 and give duration in selection criteria it will list out all document numbers created in specific time.

    OR you can pull this data from database by invoking from to in select command.

    Ex: select BELNR from <schema>.BSIS where BUDAT between <startdate/time> and <enddate/time>;

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2017 at 06:25 PM

    Dear Harish,

    I am seeing this BUDAT for future as well. Can you help me with the logic how data flows between these tables BSIS, BSID, BSIK

    Regards

    Rekha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2017 at 06:39 PM

    Hi Rekha,

    Take a look at below link, it has some details and FI team member can give you more details on flow.

    https://archive.sap.com/discussions/thread/1612991

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded