Data Type QUAN

[Former Member]

Hi Dear Expert,

I do not know too much about this data type. I have a requirement to extract data from two custom tables records to one alv table. So there are some different columns and some commom columns. Here there are two different fields that need to be shown using a shared alv table field. These two different field are: QUAN, 15 chars and decimal 3 without 'sing' flaged;    QUAN, 13 chars and decimal 3 with 'sing' flaged

So how do I set the filed type in the alv table???  Hope anyone could give me some hints. Thank you so much,

BR

Jay

[custodio_deoliveira]

Hi Jay,

You may declare your field for the ALV as QUAN 15 char WITH sign, then you can have results from both fields.

Regards,

Custodio

[Former Member]

Hi Custodio,

Sorry to disturb you.  I do not konw the command to definition a field as quan with sign in report instead of DDIC. I did not find any grammar in ABAPDOCU or ABAPHELP. Could you please show me the command

BR

Jay

[former_member186494]

Hi Jay, Just define the variable use data element or table-field as type.

Such as:

Data l_menge type ekpo-menge.

[SwadhinGhatuary]

Hi ,

Simply add a field in ALV with QUAN 15 with 3 decimal and sign. SO that no data loss.

And once check data in both table

[Former Member]

Hi Ghatuary,

Are you mean: data: lv_kwmeng(15) type p decimals 3? But I did not find where to put 'sign' statement.

BR

Jay

[madhu_vadlamani]

Hi Yang,

Please check in field catalog.

Madhu.

[Former Member]

Hi fan,

You can try the follow code,and it's possable to give minus sign directly.

DATA: lv_kwmeng(15) TYPE p DECIMALS 3 VALUE '-99.333'.

[Former Member]

Hi Yang,

Try to create a Data Element with a Domain in SE11.

In domain,give the following details:

For e.g. , if the data element is ZDEC_SIGN then in your Report use following:

data: lv_kwmeng type ZDEC_SIGN.

Regards,

Neha