creating a structure, but data element not active

[Former Member]

Hi,

In SE11, i am creating a structure based on table vbrk. in that i include the field "mwsbk" but sap says that it is not active . what shall i do ? i need that field in my structure.

instead of that, then i tried including mwsbp, but then getting an error message saying "specify reference table and ref field".

thks

[Sm1tje]

you have to look for the data element which is assigned to MWSBK. My guess is that this is a field in a table/structure somewhere. But when you want to use 'this' you will need to search for the data element of field MWSBK and use that.

[Former Member]

Thanks Micky. Actually i inserted this field thru the input help only. I selected the search button, chose search data elements option and then typed MWSBK. This is a field in VBRK table.

I am facing similar issues in other tables, like in VBRP, for field AUBEL. When I try to include this field in my structure I get the same error " AUBEL is not active" in status bar.

thks

[Former Member]

OK, one thing i noticed is that aubel field follows field type VBELN_VA and which has domain vbeln. so can i just include a field in my structure of type vbeln and name it as aubel ? will this help ?

thks

[Sm1tje]

well, when I use the search help and enter the name MWSBK, it's not giving me anything, only the DATA ELEMENT MWSBP (which is assigned to VBRK-MWSBK) I can find. So, clearly, you will have to use the DATA ELEMENT and NOT the name of the field in table VBRK.

Same will be the case for VBRP-AUBEL, for that you need to use DATA ELEMENT VBELN_VA.

You can name the field of your structure anyway you want, but the data element must be active and thus available in DD!!

[Former Member]

thanks Micky. Did you try to perform a "check" on the structure after including the field VBRK-MWSBK ? When I did that I got the error "specify reference table and reference field". Are you not getting that error ?

[Former Member]

I am sorry, what i meant was the data element MWSBP. try including that and perform a check.

[Former Member]

OK, I am getting this message "specify reference table and reference field" basically for all currency and quantity fields. Any pointers on how to resolve this issue ?

thks

[Sm1tje]

This is due to the fact that you are using a currency field. In SE11, where yo are creating your structure, there is a tab currency/quantity fields tab. You will have to enter a table and field in there which 'points' to the currency key. So in your structure, you should also include a field with currency key as a reference, or just use VBRK as table and WAERK as field for reference.

[Former Member]

Thanks Micky, that did work ! Can you also please give me the reference table and field to be used for QUAN type ?

[Sm1tje]

Works exactly the same as for currency field. So check table VBRP and field FKIMG. This field has reference VBRP-VRKME. So also create this reference field in your structure, or refer to VBRP-VRKME. Normally, you would have to define the reference fields in the structure as well (proper design), since a quantity (currency) makes no sense without a unit (currency key).

One is merely a number, but ONE EURO tells you a 'BIT' more, now doesn't it.

Same for 1000 and 1000 Kilograms.

[Former Member]

Understood Micky. Thanks a lot for your help. tc

[HELLA_Marwen]

I think your are using the field name, not the data element name( like werks and werks_d)
please check.

Br,
Marwen