Z tables

[Former Member]

Hi Guys,

needs some clarification, one very strange thing happening not sure, when we create any customized table in sap, all fields are created as NOT NULL in oracle even though they are not deifned at NOT NULL in ABAP dictionary(initial value field not checked)

confusion ???

Bye

Lakhbir

[Former Member]

Hi Lakhbir,

All the fields of all tables defined in SAP data dictionary are created as NOT NULL fields. That is the reason why you should not try to get to the underlying database bypassing the SAP application layer. By design SAP data dictionary is supposed to be independent of underlying database. May be, in order acheive that kind of protability, all table fields are defined as NOT NULL in the underlying database. Here is a snippet from SAP documentation on ABAP dictionary and under "initial values" section.

<i>When a table is created, all the fields of the table are defined as NOT NULL and filled with the default value. The same is true when the table is converted. The fields are only created as NOT NULL if new fields are added or inserted. An exception is key fields, as the Initial flag is automatically set here.</i>

Hope this helps,

Srinivas

[Former Member]

hi Srinivas,

I could not find the said documentation in ABAP dictionary in R/3 Library

Lakhbir

[Former Member]

Here is the link to ABAP dictionary.

http://help.sap.com/saphelp_46c/helpdata/en/4f/991f82446d11d189700000e8322d00/frameset.htm

The information about "Initial Values" can be found following the path

"Tables>Making Changes to Tables>Inserting New Fields-->Initial Values".

Regards,

Srinivas