topic Re: reading table clusters ex CDCLS in Application Development and Automation Discussions

reading table clusters ex CDCLS

Former Member — Mon, 26 Feb 2007 07:32:40 GMT

Hi Experts,

When trying to load table from table cluster CDCLS into an internal table the field VARDATA has the data 0001000100014344504F5320202020200290008300010131050000121F9D0267ACFA8CAC7A0C4CCE2E01FEC10A2010626064AC800F189A608A9108BC5D233105E1

this data appears to be in hex format can this be decoded into BIN format.

Thanks and Regards,

Shravan.

Re: reading table clusters ex CDCLS

Former Member — Mon, 26 Feb 2007 08:01:40 GMT

Hi shravan,

***************************************************

1. EG Table MONI field Clustd , contains RAW DATA

SO THE FIRST THING IS TO KNOW WHICH KIND OF DATA

IE. FIELDS, INTERNAL TABLE ETC.

IT CONTAINS.

***************************************************

This can be known via IMPORT Command.

Sample Program is:

DATA : CDIR LIKE TABLE OF CDIR WITH HEADER LINE.

*----

IMPORT META DATA

IMPORT DIRECTORY INTO CDIR FROM DATABASE MONI(DB)

ID 'SYSEVENT20041008074601'.

BREAK-POINT.

just look into internal table CDIR, it contains 3 fields.

1 SY-DATUM -- FIELD

2. SY-UZEIT --- FIELD

3. V_SYSTEM_EVENT_TAB -- TABLE

2. NOW TO GET DATA U CAN AGAIN USE IMPORT COMMAND

DATA : MYDATE TYPE SY-DATUM.

IMPORT SY-DATUM TO MYDATE FROM DATABASE MONI(DB)

ID 'SYSEVENT20041008074601'.

BREAK-POINT.

3. JUST TAKE CARE OF

A: DB

B: SYSEVENT20041008074601

A and B should be in your moni table.

4. for the 3rd field, V_SYSTEM_EVENT_TAB

I don't know what is the related structure.

(im still searching for it)

otherwise we can import it in the same way,

by declaring an internal table of the related

structure.

HOPE THIS HELPS.

Regards,

Amit Mittal.

Re: reading table clusters ex CDCLS

Former Member — Mon, 26 Feb 2007 08:21:03 GMT

Hi Amit,

Thanks for your reply.In my case I cant use the statements IMPORT as the

cluster tables withing CDCLS ex CDPOS doesnt have the fields RELID and CLUSTR.

Regards,

Shravan Kumar.

Re: reading table clusters ex CDCLS

Former Member — Mon, 26 Feb 2007 09:01:22 GMT

Hi again,

1. For CDCLS the respective table are

CDPOS Change document items

PCDPOS Change document items

2. Hence, we don't directly read the table CDCLS.

3. Instead we use

select * from CDPOS

into internaltable

(the internal table should be of type CDPOS).

4. It will auotmaitcally read the data from the actual database table CDCLS,

and provide the data in well structured format of CDPOS.

regards,

amit m.