Please let me know ..how to create custom table as ..

[Former Member]

Dear Freinds,

I have four fields in my custom table....first field is key field and second one is non key (text descritpion of first field) , third fields is key field and fourth is again

as text field non key..

Field Data element

MANDT MANDT

ZZFAART FACHR (primary key)

FRTXT ZZFRTXT (char50)

ZZORGCODE ZZORGCODE (char10)

ZZORGTXT ZORGTXT (char60)

now when we are enteing from SM30 ... my requirement as per functional is

i have to make zzfaart field as primary key......... i have made it since that is first field.

now he wants zzorgcode as also primary key......... as per the table condtion i cannot

give zzorgcode as primary key as all the key fields should be in order..........but the functional say he wants in third place only............he saying we can see so many place in confiugration's in spro....where

when we enter first field the second field (text ) will be automatically populated.......

(this point iam able to do....) and the third field will be primary key...

however iam not able to do is to make the zzorgcode as primary key ............as he wants that tobe grated out as well once we enter the value and he wants it to make primary key so that no duplicates can be entered.

Please let me know how to do this point....

Regards

Syamala

[Former Member · Accepted solution]

Dear Syamala,

Options:

1. Make first three fields as key field along with MANDT. i.e. key :MANDT, ZZFAART FRTXT, ZZORGCODE.

2. Make two tables. One with : MANDT, ZZFAART, FRTXT. The second with: MANDT, ZZFAART, ZZORGCODE, ZZORGTXT. (For example material description is stored in seperate table.)

3. Change the order of the fields: MANDT, ZZFAART, ZZORGCODE, FACHR, ZZORGTXT.

Let me know if you need further clarification.

Regards,

Naveen.

[Former Member · Accepted solution]

Dear Naveen,

thanks for replying i dint clarity of your points

1. Make first three fields as key field along with MANDT. i.e. key :MANDT, ZZFAART FRTXT, ZZORGCODE. ---<b> how can i make ZFRTXT ...is a text field of 40 field</b>

2. Make two tables. One with : MANDT, ZZFAART, FRTXT. The second with: MANDT, ZZFAART, ZZORGCODE, ZZORGTXT. (For example material description is stored in seperate table.) --- this is ok

3. Change the order of the fields: MANDT, ZZFAART, ZZORGCODE, FACHR, ZZORGTXT. -

---

where i have to do all this

please let me know clearly iam still in office..............please help me.

regards

syamla

[Former Member · Accepted solution]

Dear Freind,

Please explain little bit more ...........as this has to be done urgently......

can you explain me in step wise.........

thanks in advance.

regards

syamala

[Former Member · Accepted solution]

Dear Syamala,

It you are sure that the text field would never change, you can use it as part of the primary key. There is no hard and fast rule that text field should not be part of the primary key.

You would design the primary key as per your requirement. However, if the description of ZZFAART may change later use other options that I have specified.

Regards,

Naveen.

[Former Member · Accepted solution]

Dear Naveen,

your solution was very very help ful for me........can you please give your id

i have one more problem ........where i can send you the screen shot...........

please hope you dont mind giving me your id to my id.Iam giivng full points to you

regards

saymala

ravi_kiran10@yahoo.com

[Former Member]

Condition Table:

&#61550; Condition records are always created using a specific key.

&#61550; Use tables for help in defining the structure of condition record keys.

&#61550; The most important fields used in pricing at header and item level are available in the standard system.

&#61550; <b>The key fields of a condition table must appear at the start of the table, in other words, non-key fields must not appear between any two key fields.</b>&#61550; Condition table: The definition of the key of the condition record.

regards,

Rajesh Banka

Reward suitable points.

[Former Member]

Dear Rajesh & Naveen

thank you for answering

but i have my structure as below :

Field Data element

MANDT MANDT

ZZFAART FACHR (primary key)

FRTXT ZZFRTXT (char50)

ZZORGCODE ZZORGCODE (char10)

ZZORGTXT ZORGTXT (char60)

how can i design so that i can given ZZORGCODE as primary key

please give me reply................. It is urgent please.

or please give me to my personnel id (ravi_kiran10@yahoo.com)

regards

Syamala