topic Can Primary Key values be empty? in Application Development and Automation Discussions

Can Primary Key values be empty?

Former Member — Wed, 11 Jul 2007 17:55:56 GMT

Hi,

We have some custom tables created in ECC 6.

One of the tables contains the below fields.

MANDT

PERIOD

KOSTL

LSTAR

AUFNR

SOURCE

POOL

PRODUCT

...

....

.... etc.

Key/Initial Values check boxes are selected for fields in bold/italic above.(I mean primary key).

But when I check the table contents, SOURCE column contains empty values(nothing) for some records. Is that correct?

I think Primary key fields should contain some value in a record.

Please advise.

Thanks in advance.

Han

RichHeilman — Wed, 11 Jul 2007 18:02:58 GMT

Sure it can.

Regards,

Rich Heilman

RichHeilman — Wed, 11 Jul 2007 18:05:20 GMT

Have a look at table S001. Hopefully there is data for this table in your system. The first couple fields have initial values in my system.

Regards,

Rich Heilman

Former Member — Wed, 11 Jul 2007 18:06:27 GMT

Look at the values for AUGDT and AUGBL in table BSIS. They're key fields but always empty.

Rob

Former Member — Wed, 11 Jul 2007 18:12:38 GMT

Thanks Rob.

I gave you points.

Former Member — Wed, 11 Jul 2007 18:17:04 GMT

Glad to help, but isn't Rich deserving as well?

Rob

Former Member — Wed, 11 Jul 2007 18:23:24 GMT

That was also solved my problem. I gave him as well now.

Thanks Rich for your quick reply.