recursive query?

[Pat Hartman]

I don't think that I can help you. English appears to be your native language but you haven't understood anything I've said. We have a total communications gap. It may be that you are so out of your depth that you need to hire someone to do this job for you.

Try rereading everything I have written. You never answered any of my questions. I still don't know what identifies a "set". Good luck.

 

[WayneRyan]

Shivalee,

OK, I'll take one more shot at it.

You appear to be trying to treat your Excel spreadsheet like a database.
From the Example that you have posted, this would translate to Access
something like this:

A table to hold information about your SOD's

tblSOD
======
SodID - AutoNumber
SodType - Text
SodTitle - Text

Sample Data:

1  CFTM (Create payment proposal & execute payment run)
2  CFTM (Create vendor financial data & post vendor invoice in FI)
3  CFTM (Create vendor financial data & post vendor invoice in FI)
4  CFTM (Change vendor financial data & post vendor invoice in FI)
5  CFTM (Change vendor financial data & post vendor invoice in FI)
6  CFTM (Create vendor centrally & post vendor invoice in FI)
7  CFTM (Create vendor centrally & post vendor invoice in FI)
8  CFTM (Change vendor centrally & post vendor invoice in FI)
9  CFTM (Change vendor centrally & post vendor invoice in FI)
10 COTC (Create customer financial data & create sales order)


A table to hold your "XK01", "FD01" things, lets call them departments.

tblDepartments
==============
DepartmentID - AutoNumber
DepartmentName - Text

Sample Data:

1 F110
2 FK01
3 FK02
4 XK01
5 XK02

A table to hold your TCDs

tblTCD
======
TcdID - AutoNumber
TcdName - Text
OtherStuff - Whatever else you need to describe TCDs

Sample Data:

1 F110
2 F-43
3 FB60
4 VA01

A table to hold the "charges" to SODs

tblSODCharge
=========
ChargeID - AutoNumber
SodPointer - FK to SOD
TcdPointer - FK to TCD
ChargeEntity - Text
ChargeType - Text
ChargeValue - Number

Sample Data:

ID  SOD  TID  Ent.   Type   Value
==  ===  ===  =====  =====  =====
 1   1    1   *      TCD    F110
 2   1    1   BUKRS  FBTCH  02
 3   1    1   KOAR   FBTCH  02
 4   1    1   BUKRS  FBTCH  03
 5   1    1   KOAR   FBTCH  04
 6   1    1   BUKRS  FBTCH  11
 7   1    1   KOAR   FBTCH  11
 8   1    1   BUKRS  FBTCH  21
 9   1    1   KOAR   FBTCH  21
10   1    1   BUKRS  FBTCH  25
11   1    1   KOAR   FBTCH  25
.
.
.
81   10   1   *      TCD    FD01
82   10   1   BUKRS  TCD    VA01
83   10   1   KOAR   FBTCH  02
84   10   1   BUKRS  FBTCH  03
85   10   1   KOAR   FBTCH  04
86   10   1   BUKRS  FBTCH  11

I give up!

1) Your spreadsheet has too much overlapping information!
2) I have no idea what your application does!

I just know that if your organized your data in a database format,
as opposed to a spreadsheet, you could easily extract information
by SODs, TCDs, or whatever.

While I'm at it, Pat was right (as was my earlier post). You may
want to retrieve "rows" (1,3,4) from your data, BUT your SELECT
statement (the Where clause) will have

Where CriteriaForRow1 OR
      CriteriaForRow3 OR
      CriteriaForRow4

Then, when it runs, you will retrieve your desired rows. If you change
the ORs to ANDs, you'll get no data (we've seen that).

But with that approach you might as well leave it in Excel.

Hope that helps a little,
Wayne

 

[shivalee]

I have re-qritten my query as sodid as criteria:
SELECT sod.OBJCT, sod.FIELD1, sod.VALUE1, sod.FIELD2, sod.VALUE2
FROM sod
WHERE sodid=1;
And now my requirement is fulfilled.
Thanks both of you.
shivalee