topic Re: Modifying an append structure in Application Development and Automation Discussions

Modifying an append structure

javier_rodruez — Mon, 04 Jun 2012 13:40:11 GMT

Hi experts,

I have recently add an extra field "C" to the append structure of the database table MARA. It has 3 extra fields: A, B and C. The, I adjust the table MARA using transaction SE14.

Parameter "C" has a domain XFELD (Yes/No), so when I was testing the correct adjustment of the indexes, I noticed that if I made a query with this field it also takes into consideration the registers created after the modification. I would expected to return all the registers that have field C in blanks.

SELECT * FROM mara WHERE c = ' '.

Is that correct or I am forgetting to execute any other adjust?

Lots of thanks,

Javier

Re: Modifying an append structure

Former Member — Mon, 04 Jun 2012 13:47:06 GMT

Registers?

If you are talking of selecting data from MARA where C = space, then the query is correct.

Can you explain ?

Thanks,

Shambu

Re: Modifying an append structure

ThomasZloch — Mon, 04 Jun 2012 13:49:11 GMT

I'm confused by your formulation, normally the unexpected effect is that entries created before the adjustment are not found by a query like the one you listed.

In that case the reason usually is that flag "initial values" has not been set in SE11 for the new columns, so all existing entries have a NULL (hex 00) value, as opposed to initial value (space, hex 20, for character fields).

In any case you can try to set this flag for "C", adjust the entries again, and see if this changes anything.

Thomas

P.S. I hope "C" is just a placeholder for the actual name

Re: Modifying an append structure

venkateswaran_k — Mon, 04 Jun 2012 13:51:02 GMT

Hi Javier,

I think since you used XFELD as data type,

If you want to select all records with C = 'No'...

Write like as follows

SELECT * FROM mara WHERE c NE 'X'.

Regards,

Venkat

Re: Modifying an append structure

javier_rodruez — Mon, 04 Jun 2012 14:06:10 GMT

You are right, Thomas.

Inside the append structure, it is not possible to set the column "Initial values".

So, which solution are you suggesting? Maybe combine in the WHERE condition the expression with "NOT NULL" for the old records and another with " = ' ' for the new ones?

Lots of thanks for your help!!!

P.S. Exactly, "C" is just a placeholder to simplify the explanation here in the forum

Re: Modifying an append structure

ThomasZloch — Mon, 04 Jun 2012 14:40:23 GMT

Good point, when you are maintaining your append fields, the check box is not available, when you are back in the main (standard) table, the check box is there, but you cannot change it without an access key (which we don't want). What are we missing?

I think changing code to cater for this is not a good approach. Did you try the option "Extras -> Force Conversion" in SE14 for MARA already? Speak to your system administrator first.

Thomas

Re: Modifying an append structure

RaymondGiuseppi — Mon, 04 Jun 2012 14:50:40 GMT

You should activate the flag "initial value"at included structure level as this is not possible at subfield level.

Call SE11 on the table, navigate to append structure, there in the menu navigate to : Extras, DB Attributes, Initialization Flag On/Off. Activate again append structure and table, and then adjust database if required.

Regards,

Raymond

Re: Modifying an append structure

javier_rodruez — Mon, 04 Jun 2012 14:56:40 GMT

Exactly, Raymond. Problem solved!!!

Thanks to all of you for your help.