Relate Text Table and Value Table

[Former Member]

hi all,

How to relate Text Table and Value Table ?

I need step by step process.

Thanks in advance.

Regards

Raj

[Former Member]

Not sure about your question...But you can take this tables as example....

<b>MARA</b> --> Values Table

<b>MAKT</b> --> Text Table

Greetings,

Blag.

[Former Member]

Hi,

Text table - If you want to create TEXT table for any table then just need to create table with the key fields of the other table along with that we need to create 2 more fields - those are language field & description.

Value table - Any table can be attached as value table for the table, only thing is field relations should be there in that table.

for step by step process to create tables - check the below -

Go to SE11,

given ZTABLE name and Create.

In Delivery Maintainance Tab..

Choose Delivery class A

and Display/Maintaintance Allowed

Go to Fields tab.

Provide ur table fields with MANDT is first field for client dependent.

If there is QUAN, CURR type fields then u must provide reference to them.

Save and Activate.

Click on Technical Settings

Data Class APPLO

Size .. 0 (as per ur requirement.)

SAVE and Back.

Click on Utilities --> Table Maintainance Generator.

Authorization Group &NC&.

and provide function group for table maintainance ( u can create a function group in se37 )

click on Find Scr Number button.

select Propose Screen Number and Continue.

then Create...

Save and Back

Activate the table.

go to tcode SM30

give the table name and click on Maintain.

there u can enter values manually too.

Regards,

*DJ

Reward, if its useful