When inserting an entry into a database table with an INSERT statement, assigning a value to a description field (CHAR) without specifying any value is similar to manually assigning a value to the field

Ls-description = space, do the two cases have the same effect when inserted into the database?

Figure out what the hook in SE11 is for?

If the table structure appends a new structure, then the corresponding field of the append will be NULL. There is a reply on the link below. The first part of the statement makes sense, but the is null is valid only in the WHERE statement. If the data is already selected and placed in the internal table, then all the values are initial. Outside the chain picture archiving failure (img – e14KI5kJ – 1563802589007) (user-images.githubusercontent.com/5669954/327…)”

For NULL and INITIAL, we did an experiment:

  1. Create a new database table: [outside chain picture archiving failure (img – V4r9ftA0-1563802589008) (user-images.githubusercontent.com/5669954/327…)”
  2. Insert two pieces of data:

Outside the chain picture archiving failure (img – pHrG2dkZ – 1563802589008) (user-images.githubusercontent.com/5669954/327…)”

  1. Insert include structure initial value

Outside the chain picture archiving failure (img – zNwgxUhc – 1563802589009) (user-images.githubusercontent.com/5669954/327…)”

  1. Testing:

Outside the chain picture archiving failure (img – zdUUZm66-1563802589009) (user-images.githubusercontent.com/5669954/327…)”

Execution Result:

Outside the chain picture archiving failure (img – rKP2l2rV – 1563802589010) (user-images.githubusercontent.com/5669954/327…)”

Outside the chain picture archiving failure (img – fpCotxAj – 1563802589010) (user-images.githubusercontent.com/5669954/327…)”

Note:

  1. The above test was done on QI2/506 (MaxDB). If I switch to HANA DB, all IS NOT NULL will return true even if I do NOT check initial value. I am NOT sure why HANA DB IS designed this way.Copy the code
  2. "I just asked XXX, and she said that there is a situation, which I saw when I did HANA Preview, that is, if we use left out JOIN, there is no corresponding data in the right table, then the corresponding field will be NULL." -- According to ABAP help, Only outer join will have the situation you mentionedCopy the code
  3. "Initial if the data is already selected and placed in the internal table... - According to ABAP help and my tests on QI2, it is true that NULL fetching the internal table automatically becomes initial.Copy the code

I guess “observing preview results in HANA Studio” and “retrieving data from internal Table using open SQL in ABAP” are not the same thing?

Written in ABAP code to take data to the database server through the database interface:help.sap.com/saphelp_nw0…