topic cdpos Tabkey in Application Development and Automation Discussions

cdpos Tabkey

Former Member — Mon, 18 Feb 2008 10:29:58 GMT

Hi All,

In table CDPOS, field TABKEY is combination of some values..

Now my requirement is to get the type value from tabkey n check it with EKKO-SPRAS.

eg.

Tabkey = 060010000077200010101 E

now here i want to check Whether E = EKKO-SPRAS..

So please help me with to split.

Thanx in Advance,

Amruta.

Re: cdpos Tabkey

ThomasZloch — Mon, 18 Feb 2008 10:34:38 GMT

CDPOS-TABKEY holds a combination of field values which represent a unique key to the data record that has been changed.

If you take the value in CDPOS-TABNAME, then lookup the primary key for that table in SE11, you should be able to define a structure where you can move the contents of TABKEY and then access them by field name.

Cheers

Thomas

Re: cdpos Tabkey

Former Member — Mon, 18 Feb 2008 10:34:56 GMT

in cdpos tabkey

first 3 characters contains client

next 10 characters contains document no like sales order / po

next 6 characters contains line item no

next 4 characters contains schedule line no.

next 1 character is language key

now u need to check 22nd character for spras

check this

if u have any doubt u can ask again

rewards points if useful

Madhavi

Re: cdpos Tabkey

Former Member — Mon, 18 Feb 2008 10:35:03 GMT

Hi,

check the value of SPRAS in tabkey as follows..

use Tabkey+22(1) = EKKO-SPRAS in IF stmt.

Rewarrd points if useful

Chandra

Re: cdpos Tabkey

RaymondGiuseppi — Mon, 18 Feb 2008 10:45:20 GMT

CDPOS-TABKEY contains the primary key of the database table.

As the primary keys are at the beginning of the table, just move TABKEY to a structure with MANDT.

In fact move CDPOS-TABKEY to (CDPOS-TABNAME)

Regards