topic Primary key from .include structure? in Application Development and Automation Discussions

Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 10:06:04 GMT

Hi All,

can i assign primary key field to database table from included structure ?

Re: Primary key from .include structure?

vinodkumar_thangavel — Thu, 12 Mar 2015 11:11:56 GMT

Hi Abdulkadir,

I hope it is not possible to assign the field of include structure as Primary key field.

Regards,

Vinodkumar.

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 11:23:49 GMT

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 13:59:55 GMT

YES.

Rob

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 14:14:38 GMT

Hello Abdulkadir

I think this is not possible. You can select the included structure as primary key, but then all fields of that structure are marked as primary keys

Maybe create a seperate structure to include just with the field you want as primary key?

Hope this helps.

Kind regards

Thomas

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 14:17:37 GMT

Hello Thomas,

Yes your advice is my best alternative solution.

Thanks.

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 14:18:24 GMT

How?

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 14:20:38 GMT

Exactly what I meant - it is possible.

Rob

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 15:08:25 GMT

I am new at SAP systems therefore i want to consult to experts. I 'll develope an application (Db + Web Service). I wanted to design my dictionary objects in best and short style, generate all objects from structure (all objects= Db Tables, web services inputs/outputs, codebehind declarations ...). But Db Primary key attribute block it.

Which way is better?

Then, there is no benefit to declare structure if I can't assign primary key field to table from included structure.

i 'll create table without create/.include structure and use type of the table at codebehind declarations, web service inputs/outputs. (please look at followings images)

I mean;

> ztUser(Table) > Data: gv_user type ztUser.

and there is no requirement create table from structure .

> zsUser(Structure) > ztUser(Table .included zsUser) > Data: xx type ztUser

, , Former Member

Re: Primary key from .include structure?

Former Member — Thu, 12 Mar 2015 15:19:45 GMT

The benefit of include structures is there re-usability. Your ZDEN_SDATASTATUS is a good example. SAP creates structures for key fields, inserts them at the beginning of tables and sets the structure as the key field. They can then add more keys in subsequent fields.

Generally, we don't use structures for keys, but use them for non-key fields in multiple tables.

Rob