topic Re: Extra fields in Table in Application Development and Automation Discussions

Extra fields in Table

ricky_shaw — Wed, 29 Jun 2011 15:45:01 GMT

Hi Gurus,

Some tables hold few fields as part of their strcuture definition.

But when we try to see the entries(se11) of the table few more extra fields are seen.

Ex: In TJ02 table we can see only 3 fields as per defenition but when we see the contents, we can TXT04 & TXT30 also which is not seen in definition.

How is that possible ? Are these fields Extra fields defined in a buffer or memory area..etc?

thanks

Re: Extra fields in Table

Former Member — Wed, 29 Jun 2011 15:50:01 GMT

Hi Ricky.

When you display the fields for a table (i.e. transaction SE11 or SE12), you see exactly the fields for that table.

But, if you jump to the contents of that table, or if you display the contents via transaction SE16, SAP automatically joins this first table to the text table (in this case, TJ02T). That's why you see 2 extra text fields.

This happens in may other cases: for example T003 (text table T003T), CSKA (text table CSKU), etc.

I hope it helps. Kind regards,

Alvaro

Edited by: Alvaro Vidal-Abarca on Jun 29, 2011 5:55 PM --Added more examples

Re: Extra fields in Table

ricky_shaw — Wed, 29 Jun 2011 16:42:34 GMT

Thanks Alvaro,

Thats fine. Where is this join happening with the text table?

Is there a way where we can see this?

Re: Extra fields in Table

Former Member — Wed, 29 Jun 2011 16:53:54 GMT

Hello Ricky Sh ,

The reason for those additional fields is in the SE11 is by defalut after you go inside the SE11 and enter the table name and go inside by pressing "F7" . There if you see the menu Go-> Text table there the link is assigned internally. That is the reason you are able to see the texts in the SE11 result screen.

To create a tabel with text table field shown up you need to create a table as mentioned below:-

Procedure

To use the functions offered by a text table, create a table(ZCustom Text Table) in the ABAP Dictionary with the same key as table <ZCustom Table> and an extra field with type SPRAS. Define the text fields as non-key fields in this table. Then define a text foreign key from this text table to table <ZCustom Table>.

Hope this answers your questions.

Thanks,

Greetson.