Can Primary Key values be empty?

[Former Member]

Hi,

We have some custom tables created in ECC 6.

One of the tables contains the below fields.

<i><b>MANDT

PERIOD

KOSTL

LSTAR

AUFNR

<u>SOURCE</u></b></i>

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, <u><i><b>SOURCE</b></i></u> 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

[Former Member]

Hi,

We have some custom tables created in ECC 6.

One of the tables contains the below fields.

<i><b>MANDT

PERIOD

KOSTL

LSTAR

AUFNR

<u>SOURCE</u></b></i>

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, <u><i><b>SOURCE</b></i></u> 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]

Sure it can.

Regards,

Rich Heilman

[RichHeilman]

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]

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

Rob

[Former Member]

Thanks Rob.

I gave you points.

[Former Member]

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

Rob

[Former Member]

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

Thanks Rich for your quick reply.