Start and end dates for condition records

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Benny]

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

[Benny]

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

Regards,

Benny