topic Re: Transparent table query in Application Development and Automation Discussions

Transparent table query

Former Member — Fri, 30 Jan 2009 17:38:08 GMT

Hey Folks

I created a transaparent table.

and just have one field in it currently.

Questions:

1) Every transaprent table needs a primary key? IF yes then is it becos of same concept as Databased? We can join tables using this key?

2) I created only one entry right now in table and used MANDT as the field : Clicked Key: Clicked initial value :Data element : Z_MAND :

But when I go to utililites and create a table entry : I see it asks for field name : character

Although I guess it should ask for MANDT as I created field name as MANDT.

Can someone help me in these 2 questions.

Thank You

Re: Transparent table query

Former Member — Fri, 30 Jan 2009 17:47:20 GMT

1) Every transaprent table needs a primary key? IF yes then is it becos of same concept as Databased? We can join tables using this key?

Answer yes, to both of your questions. You can create a database view by joining two table, so also you can join them in a select query.

2) I created only one entry right now in table and used MANDT as the field : 

Clicked Key: Clicked initial value :Data element : Z_MAND :


But when I go to utililites and create a table entry : I see it asks for field name : character

Although I guess it should ask for MANDT as I created field name as MANDT.

It is compulsory to have MANDT as a key field, if you want to make your table records client dependent - all client dependent tables will have MANDT as their first key. The data element for MANDT should be MANDT only. You typically add keys other than MANDT, which define the structure of your table.

Re: Transparent table query

Former Member — Fri, 30 Jan 2009 17:50:14 GMT

Hello Friend,

Welcome to the SAP World...........

MANDT is the client field that is requried in every table.

Without writing this field we cann't insert the record or use the table.

Just write the field name MANDT and data element name ZMANDT it will automatically take the field type and size.click check box for primary key.........

now create any field that you want in your table with primary key and try your logic..........

Hope it will help you to understand the concept of MANDT field...........

Thanks

-Arun Kayal

Edited by: Arun Kayal on Jan 30, 2009 6:52 PM

Re: Transparent table query

Former Member — Fri, 30 Jan 2009 19:58:35 GMT

Hey folks

So MANDT is mandatory field in every table.

Besides MANDT we need to delcare another field which will be the primary key too.

Secondly I had asked another question about when I am inserting value in a table ,the field name should come as MANDT ,instead Field name comes as : character.

Thank You

Re: Transparent table query

Former Member — Fri, 30 Jan 2009 20:08:12 GMT

Hi,

You have given the Z_MAND as the data element for the field MANDTin the database table. Check the field label given in the dataelement Z_MAND it should be Character change the field label.

Re: Transparent table query

Former Member — Fri, 30 Jan 2009 20:13:48 GMT

Hey

I changed the field label form character to tree. saved it and activated it ,still it says character when i create entry.?

Secondly what is domain ?

And in field label : thee is short ,medium ,long : what lengths are these?

Thank You

Re: Transparent table query

Former Member — Fri, 30 Jan 2009 20:24:23 GMT

Hi,

The length of the short ,medium ,long is 10 ,20 & 40.

[Data element |http://help.sap.com/saphelp_47x200/helpdata/en/90/8d72feb1af11d194f600a0c929b3c3/frameset.htm]..

[Domain|http://help.sap.com/saphelp_47x200/helpdata/en/cf/21ede5446011d189700000e8322d00/frameset.htm]