topic Re: Data type is giving error in Application Development and Automation Discussions

Data type is giving error

Former Member — Sun, 30 Aug 2015 17:52:05 GMT

BUt Hi guys,

I am trying to create a progrem in SE38 and while assigning the data type to a column its giving me error.

My Column is Quantity which has a currency key. So in ABAP Program while declaring Data I wrote

COPASLTYQ (17) TYPE P((n+1)/2),

COPASLQTU (3) TYPE C(5),

G_QVVQ01 (17) TYPE P((n+1)/2),

G_UVVQ01 (3) TYPE C(n),

I researched and found this link on Help.SAP.Com

Data Types in the ABAP Dictionary - ABAP Programming (BC-ABA) - SAP Library

But it did not help me.

Any ideas what am I doing wrong?

Regards

Prashant

Re: Data type is giving error

paul_bakker2 — Sun, 30 Aug 2015 21:41:42 GMT

Hi,

If it has a currency key then these fields store currency amounts.

I suggest you look at some existing SAP tables that store currency amounts.

You want the DEC data type.

cheers

Paul

Re: Data type is giving error

Former Member — Mon, 31 Aug 2015 02:41:02 GMT

Thats how I have declared. See the screen shot below:-

Re: Data type is giving error

arivazhagan_sivasamy — Mon, 31 Aug 2015 02:49:51 GMT

Hi Prashant,

Declare variables like below.

COPASLTYQ TYPE MSEG-MENGE,

COPASLQTU TYPE MSEG-MEINS,

G_QVVQ01 TYPE MSEG-MENGE,

G_UVVQ01 TYPE MSEG-MEINS.

Arivazhagan S

Re: Data type is giving error

Former Member — Mon, 31 Aug 2015 03:29:42 GMT

I am doing this in BW. Still I should refer to ECC Table names?

Re: Data type is giving error

arivazhagan_sivasamy — Mon, 31 Aug 2015 04:54:04 GMT

Hi,

Declare like below.

COPASLTYQ(17) TYPE P decimals 3,

COPASLQTU(3) TYPE C,

G_QVVQ01(17) TYPE P decimals 3,

G_UVVQ01 (3) TYPE C,

Arivazhagan S

Re: Data type is giving error

former_member198834 — Mon, 31 Aug 2015 05:11:35 GMT

Dear Prashant,

Use Data Elements Directly like

COPASLQTU TYPE MEINS,

Suresh

Re: Data type is giving error

Former Member — Mon, 31 Aug 2015 05:28:55 GMT

This worked for UoM but not for Key Figures.

Re: Data type is giving error

former_member198834 — Mon, 31 Aug 2015 05:32:17 GMT

share me u r code

Re: Data type is giving error

Former Member — Mon, 31 Aug 2015 08:20:21 GMT

DATA: BEGIN OF WA1,

COMPANY(6) TYPE C,

ZSOLD_TO(25) TYPE C,

FISCPER3(3) TYPE N,

/BIC/ZSHIP_TO(25) TYPE C,

/BIC/ZMATERIAL(50) TYPE C,

*G_QVVQ01(17) TYPE did not work here ,

G_UVVQ01 TYPE MEINS,

*COPASLTYQ(17) TYPE did not work here,

Re: Data type is giving error

arivazhagan_sivasamy — Mon, 31 Aug 2015 08:53:29 GMT

DATA: BEGIN OF WA1,

COMPANY(6) TYPE C,

ZSOLD_TO(25) TYPE C,

FISCPER3(3) TYPE N,

/BIC/ZSHIP_TO(25) TYPE C,

/BIC/ZMATERIAL(50) TYPE C,

G_QVVQ01 TYPE /BI0/OIQUANITITY ,

G_UVVQ01 TYPE MEINS,

COPASLTYQ TYPE /BI0/OIQUANITITY

Declare like above.

Re: Data type is giving error

Former Member — Mon, 31 Aug 2015 08:58:09 GMT

Hi,

No need of writing n , define as below ,

Data :

COPASLTYQ(17) TYPE P decimals 3,

COPASLQTU(3) TYPE C,

G_QVVQ01(17) TYPE P decimals 3,

G_UVVQ01 (3) TYPE C.

Regards,

Salil

Re: Data type is giving error

Former Member — Mon, 31 Aug 2015 10:12:34 GMT

Now it gives me following error:-

"For type "P" , a length specification from 1 to 6 is allowed"

Though the length specified for these quantity fields is(17).

Regards

Prashant

Re: Data type is giving error

Former Member — Thu, 03 Sep 2015 12:21:17 GMT

Hi,

Maximum Length is 16 allowed.

Data :
COPASLTYQ(16) TYPE P decimals 3,
COPASLQTU(3) TYPE C,
G_QVVQ01(16) TYPE P decimals 3,
G_UVVQ01(3) TYPE C.

OR use Data Element DEC17_3

Data :

COPASLTYQ type DEC17_3,
COPASLQTU(3) TYPE C,
G_QVVQ01 type DEC17_3,
G_UVVQ01(3) TYPE C.

Regards,

Salil