INDX table

[ravishankar_reddy2]

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

[Former Member]

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

[ravishankar_reddy2]

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.

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.

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

[Former Member]

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

[ravishankar_reddy2]

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.

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.

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

[ravishankar_reddy2]

HI all,

i want to know how this INDX table is uploading.

thanks in advance.