Query in Database Table!!!!

[Former Member]

Hi all,

I have a requirement which requires me to get the Object Ids for all orders where Sold-To-Party Partner Number has been changed.

Any pointers on how I could fetch this data from CDPOS table?

Any pointers on how the field TABKEY is formed.

Regards,

Vijay

[Former Member]

Hi ,

I googled about TABKEY ,

Ifound some thing about that ... hope it helps ...

first 3 letters is for client ,

and after that i found different things for different sites ....

1.

BKKRS = TABKEY+3(4)

PLANT = TABKEY+21(4).

ACNUM = TABKEY+7(10)

2.

SY-MANDT = TABKEY(3).

BSTNR = TABKEY+3(8).

BUKRS = TABKEY+11(2).

EBELP = TABKEY+13(5).

3.

TABKEY(6) = POSNR.

TABKEY+3(10) = VBELN.

TABKEY+13(6) = POSNR.

TABKEY+19(4) = ITAB-ETENR.

4.

TABKEY = SY-MANDT+EKKO-EBELN