topic Re: changing domain in table vbap in Application Development and Automation Discussions

changing domain in table vbap

santosh_kumar94 — Wed, 11 Dec 2013 15:19:07 GMT

Dear all,

I have one requirement to change the domain of standard table.

suppose , we have one standard domain with values:

data type - DEC.

No. Characters 5

Decimal Places 0

Output Length 6

but, as per my requirement i want to make it.

data type - DEC.

No. Characters 7

Decimal Places 2

Output Length 9.

how to do that ?

Re: changing domain in table vbap

Former Member — Wed, 11 Dec 2013 15:42:12 GMT

I can give you 61 pages of reasons that yo don't want to do that. Doing a where used on VBAP I get 61 pages of objects returned! Each and every one of these would potentially have to be changed as well.

The smarter route is to add a additional field that gets filled in at the same time as the original one.

But perhaps we are jumping the gun. Why don't you tell us more about the real problem that you are trying to solve. Perhaps we can propose some alternatives.

Neal

Re: changing domain in table vbap

Former Member — Wed, 11 Dec 2013 15:46:37 GMT

Santosh,

It is not advisable to change the domain in a standard table. VBAP is a table used in many programs/objects.

If you change the domain, it will affect all these programs/objects.

A lot of them might give a dump as well which will impact business.

Regards,

Guru.

Re: changing domain in table vbap

Former Member — Wed, 11 Dec 2013 15:47:24 GMT

Hi santhosh,

Check the below threads, give me the table name and field.

find the restrictions below.

Changing the length of a key field in a table | SCN

http://scn.sap.com/message/3821763#3821763

Re: changing domain in table vbap

atul_mohanty — Wed, 11 Dec 2013 15:55:00 GMT

Do not change the domain of standard table.

Re: changing domain in table vbap

Former Member — Wed, 11 Dec 2013 17:28:00 GMT

Hi,

Please share the complete requirement with the scenario this will help us to solve the problem in some or other way.... Discussing technically you won't give result always.

Regards,
Rajesh Sadula.

Re: changing domain in table vbap

suhassonawane — Wed, 11 Dec 2013 18:17:45 GMT

Hi,

It’s not advisable to change the standard domain as SAP uses standard domain in lot many tables and finally get referred into the programs.

Changing domain directly can cause short dump in programs.

So if you have a requirement in your custom report or z table then creates a new one and uses the same.

Regards,

Suhas

Re: changing domain in table vbap

santosh_kumar94 — Thu, 12 Dec 2013 05:09:27 GMT

thanks all for reply,

but as per the requirement. in vbap-UMVKN. this field has

data type - dec.

no of character - 5

decimal places - 0

output length - 6

for example - as per the user requirement. in one of the screen i/p for conversion here , he wants to enter 1290.80 kg = 900 birds.

since, the field vbap-UMVKN will not allowing the value '1290.80' to be entered here.

so, as per the requirement user want to make it.

data type - dec

no of character - 7

decimal places -2

output length - 9

is there any solution to do this ?

Re: changing domain in table vbap

Former Member — Thu, 12 Dec 2013 05:45:00 GMT

Hi Santosh,

Please find the below screen shot, it is not advisable to change this field.

124 tables and 1406 structures.

option: create the customized field with append structure in VBAP. Add the screen field in sales transaction. finally educate the users to usage of the new field.

This is the simplest way!

Thanks,

Kiran

Re: changing domain in table vbap

RaymondGiuseppi — Thu, 12 Dec 2013 11:14:39 GMT

Don't execute the Where-used on VBAP but first on data element, and then on every structure, table, internal table, etc. which use the data-element you want to change, and good luck for the implicit and explicit move-corresponding statements...

Re: changing domain in table vbap

Former Member — Thu, 12 Dec 2013 14:53:22 GMT

Hi,

As everyone said, you better create a custom tab with z field and do whatever you want.

It is not at all advisable to change the standard domain, because it is being used in many table.

Regards,

Rajesh Sadula.

Re: changing domain in table vbap

santosh_kumar94 — Sat, 14 Dec 2013 07:33:31 GMT

hi all,

whatever you all are saying i agree. we can't change the standard domain.

but, as per the requirement what is the solution for this.

please explain in brief . what should i do for this requirement ?

Re: changing domain in table vbap

manish_mohan3 — Thu, 07 May 2015 15:50:32 GMT

Hi,

I understand the concern around changing the domain of a standard field in VBAP.

But what if I want to change the increase the length of a custom field in VBAP say from DEC 9, 5 to DEC 14, 9.

I tried this on a custom table in DEV and as expected the data is not lost and the existing values are converted to DEC 14, 9

In PROD, we have millions of records. Does anyone have experience moving such a change to PROD or comment on this approach.

Thank you,

Manish

Re: changing domain in table vbap

Former Member — Thu, 07 May 2015 16:23:09 GMT

If you increase the length of the field, the data may be kept, but have you thought about all the reports (including standard SAP reports) that expect a data element of a certain length?

Rob

Re: changing domain in table vbap

manish_mohan3 — Thu, 07 May 2015 16:36:17 GMT

Yes Rob, I have already looked at the dependencies. My concern was around time for the conversion as we have a lot of data in VBAP ( ~ 200 M ).

Any idea how long it would take?

Also, you mentioned, "The data may be kept".. That's little scary.. Any reason you think this wouldn't work as expected in PRODUCTION. Please advise.

Thank you,

Manish

Re: changing domain in table vbap

Former Member — Thu, 07 May 2015 16:42:50 GMT

I didn't mean that the data may or may not be kept; I just meant that there are other considerations besides keeping the data.

The time for the conversion is not something that can be answered here; it depends on your system and it's configuration. Besides, it's a Basis issue, not ABAP.

Rob

Re: changing domain in table vbap

manish_mohan3 — Thu, 07 May 2015 17:41:01 GMT

Awesome... Thank you, Rob.. This was helpful.

Thank you,

Manish