Hello,
Can I declare an option field as a primary key in a table?? If so then can I modify this field by using RENAME() function??
Thank You,
Hi,
Look for Table 36 Sales Header or any of the document header table.
Can you rename a Sales Document?
Yes, you can use an option as the primary key, either alone or in combination. And you can use RENAME to change it.
The reason you cannot rename a sales document is not because of functionality, but because it for sales orders, not only changes the key value, but the whole meaning of the record. So via code, it has been disabled in table 36.
Hey Rajat,
Always have a look on some standard tables whenever you stuck on some questions like this. You might have seen Sales Header and Purchase Header Tables. There you would have seen Document Type as a part of Primary key and which is a Option type field, so here you have the answer of your first question. For your second question please have a look on this, you will understand. 