Skip to Content
avatar image
Former Member

Start and end dates for condition records

I am accessing a number of tables with a similar structure when getting data from condition records.

These tables are A926, A922, A304, A306, and I suspect there are other similar tables.

They all have a start and end validity date.

I get the impression that when entering data in the SAP transactions, e.g. prices, that SAP will always make sure that for the same piece of data (e.g. the price for a particular article), these date ranges can never overlap.

Is this true? can I rely on that? It will make my code much simpler if I can.

When checking for valid rows, my sql has something like

...

and datab <= today's date

and datbi >= today's date

...

Can I assume that this query will only ever return one row, or could there be more than one row with all the other data the same, which satisfies the above conditions?

Thanks

Chris

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 18, 2008 at 12:27 PM

    Now, this surely has nothing to with Java. Could you tell me which forum you wanted to use?

    Regards,

    Benny

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2008 at 12:35 PM

    The issue has arisen in a java program . . .

    I'll be happy to move it to another forum if you can tell me where it would better go?

    Thanks

    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • And what java program are we talking about?

      Maybe you can tell us what you do at all, as I don't have the slightest idea where you are (that's why I supposed your not in Java... and I'm still suspisous 😊

      Regards,

      Benny

  • avatar image
    Former Member
    Aug 21, 2008 at 12:28 PM

    I work for a company called IBS-STL, based in Carlisle, UK, and we supply Christian books, music, and other products, both to bookshops and consumers.

    We are in the process of moving from a legacy IT system to SAP.

    We have both B2C and B2B e-commerce websites (operated and maintained by a 3rd party, off site), and we have to transfer updated product data to them every night.

    This data is held on two separate databases.

    We have a java program which runs every night, determines which products have changed, pulls data from the two databases together for each product, and writes files which are then transferred to the websites for import.

    I am currently re-writing the part java program that gets data from the database that is being replaced by SAP. The other database is not being replaced by SAP, so I still have to combine data from SAP, and that other database.

    Hope that helps,

    Regards

    Chris

    Add comment
    10|10000 characters needed characters exceeded