topic Re: INDX table in Application Development and Automation Discussions

INDX table

Former Member — Fri, 02 May 2008 11:28:21 GMT

HI all,

I have to know in INDX table there is a field CLUSTR and CLUSTD. Pls tell me that from where these fields are updating.

pls help me in this regard asap.

points will be rewarded.

regards

ravi shankar reddy s

Re: INDX table

Former Member — Fri, 02 May 2008 11:34:40 GMT

hope you this to update the INDX table

EXPORT A FROM B TO DATABASE indx(sq) ID lv_srtfd.

in this CLUSTR is length of A CLUSTD is field type of A ,

Mark if useful,

Badari

Re: INDX table

Former Member — Fri, 02 May 2008 11:36:26 GMT

CLUSTR type INT2 with length 2. This contains the length of the data in the following field CLUSTD. The field is filled automatically by the system when you save a data cluster.

CLUSTD type VARC. You can define it with any length. It is usually around 1000 bytes long. This is the field in which the system saves the actual data in the data cluster. The data is saved in compressed form. If CLUSTD is not long enough to accommodate a data cluster, it is split across two or more lines.

Below link may help you.

[INDX-Type Databases|http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3c05358411d1829f0000e829fbfe/frameset.htm]

I hope it helps.

Best Regards,

Vibha

Please mark all the helpful answers

Re: INDX table

Former Member — Fri, 02 May 2008 11:39:40 GMT

hi badrinarayan,

in one of the program they are using the code like this

CASE which.

WHEN 'ABB'. ASSIGN ix_id TO <ix_id>.

WHEN 'CSC'. ASSIGN ix_id2 TO <ix_id>.

WHEN OTHERS.

EXIT.

ENDCASE.

*<< 02/04 CSC

SELECT mandt FROM ('T000') INTO TABLE tclnt

WHERE mandt <> sy-mandt

ORDER BY mandt.

INSERT sy-mandt INTO tclnt INDEX 1.

LOOP AT tclnt.

auf unserem "eigenen" Cluster nachsehen

IMPORT picture_data TO pictab

picture_size TO picsize

picture_type TO pictype

FROM DATABASE zntg_indx(pi)

CLIENT tclnt ID <ix_id>.

IF sy-subrc <> 0 OR pictab[] IS INITIAL.

da wurde das Logo per Transport reingebracht

IMPORT picture_data TO pictab

picture_size TO picsize

picture_type TO pictype

FROM DATABASE indx(zn)

CLIENT tclnt ID <ix_id>.

IF sy-subrc = 0 AND NOT pictab[] IS INITIAL.

dann auf "unser" Cluster hauen

EXPORT picture_data FROM pictab

picture_size FROM picsize

picture_type FROM pictype

TO DATABASE zntg_indx(pi)

ID <ix_id>.

COMMIT WORK.

ENDIF.

IF NOT pictab[] IS INITIAL.

EXIT.

ENDIF.

ENDLOOP.

URL geben lassen

IF NOT pictab[] IS INITIAL.

CALL FUNCTION 'DP_CREATE_URL'

EXPORTING

type = 'image'

subtype = pictype

size = picsize

lifetime = cndp_lifetime_transaction "%46%

TABLES

data = pictab[]

CHANGING

url = url

EXCEPTIONS

OTHERS = 99.

IF sy-subrc <> 0.

CLEAR url.

ENDIF.

this is the code they used to get a logo from the table indx/zntg_indx.

pls tell me how they upload that logo in that indx table.

thans in advance

Re: INDX table

Former Member — Fri, 02 May 2008 11:41:10 GMT

hi vibha,

in one of the program they are using the code like this

CASE which.

WHEN 'ABB'. ASSIGN ix_id TO <ix_id>.

WHEN 'CSC'. ASSIGN ix_id2 TO <ix_id>.

WHEN OTHERS.

EXIT.

ENDCASE.

*<< 02/04 CSC

SELECT mandt FROM ('T000') INTO TABLE tclnt

WHERE mandt <> sy-mandt

ORDER BY mandt.

INSERT sy-mandt INTO tclnt INDEX 1.

LOOP AT tclnt.

auf unserem "eigenen" Cluster nachsehen

IMPORT picture_data TO pictab

picture_size TO picsize

picture_type TO pictype

FROM DATABASE zntg_indx(pi)

CLIENT tclnt ID <ix_id>.

IF sy-subrc <> 0 OR pictab[] IS INITIAL.

da wurde das Logo per Transport reingebracht

IMPORT picture_data TO pictab

picture_size TO picsize

picture_type TO pictype

FROM DATABASE indx(zn)

CLIENT tclnt ID <ix_id>.

IF sy-subrc = 0 AND NOT pictab[] IS INITIAL.

dann auf "unser" Cluster hauen

EXPORT picture_data FROM pictab

picture_size FROM picsize

picture_type FROM pictype

TO DATABASE zntg_indx(pi)

ID <ix_id>.

COMMIT WORK.

ENDIF.

IF NOT pictab[] IS INITIAL.

EXIT.

ENDIF.

ENDLOOP.

URL geben lassen

IF NOT pictab[] IS INITIAL.

CALL FUNCTION 'DP_CREATE_URL'

EXPORTING

type = 'image'

subtype = pictype

size = picsize

lifetime = cndp_lifetime_transaction "%46%

TABLES

data = pictab[]

CHANGING

url = url

EXCEPTIONS

OTHERS = 99.

IF sy-subrc <> 0.

CLEAR url.

ENDIF.

this is the code they used to get a logo from the table indx/zntg_indx.

pls tell me how they upload that logo in that indx table.

thans in advance

Re: INDX table

Former Member — Fri, 02 May 2008 12:11:35 GMT

HI all,

i want to know how this INDX table is uploading.

thanks in advance.