on 08-18-2008 11:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Now, this surely has nothing to with Java. Could you tell me which forum you wanted to use?
Regards,
Benny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
11 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.