Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Query in Database Table!!!!

Go to solution
Former Member

‎2008 Sep 27 1:27 PM

0 Kudos
92

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

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎2008 Sep 29 5:40 AM

0 Kudos
60

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

1 REPLY 1

Go to solution
Former Member

‎2008 Sep 29 5:40 AM

0 Kudos
61

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