topic Re: Duplicate(double) values in Database view in Application Development and Automation Discussions

Duplicate(double) values in Database view

former_member194739 — Sat, 10 May 2014 15:14:55 GMT

Dear Experts,

I have created Database view with two tables like MARA and MAKT. Key field-MATNR. Based on MATNR i collected MARA and MAKTX values. I got double(one duplicate) values in this view. How to approach single values.

I attached screen shots. Kindly give me suggestions for removing duplicate value.

Regards,

Abbas.

Re: Duplicate(double) values in Database view

rosenberg_eitan — Sat, 10 May 2014 15:50:03 GMT

Hi,

MAKT have extra key for language

Actually I am quite sure that there is such a view already.

Use "where use" on MAKT.

Use the "selection" compare sy-langu

Regards.

Re: Duplicate(double) values in Database view

former_member194739 — Sat, 10 May 2014 16:38:29 GMT

Dear Eitan,

I am added above query in selection conditions tab, error display:

'Join for field MAKT-SPRAS uses an SY field'

Added screenshot.

Regards,

Abbas.

Re: Duplicate(double) values in Database view

Former Member — Sat, 10 May 2014 17:38:37 GMT

Hi Syed,

Can you give comparison value equal to 'E' inplace of SY-LANGU and recheck it?

Regards,

Sudeesh Soni

Re: Duplicate(double) values in Database view

Former Member — Sat, 10 May 2014 17:47:32 GMT

Hi Abbas,

You cannot Use System field in Database View .

But if you try same in Maintenance View it will work.SO try creating MAINTENANCE VIEW.

or else assign this system field value to a variable before the condition and use that variable in the condition.

Hope it will resolve your queries.

Regards,

Kannan.

Re: Duplicate(double) values in Database view

former_member194739 — Sat, 10 May 2014 18:49:03 GMT

Dear Sudeesh,

If i replace 'E' in place of SY-LANGU, activated but values are getting duplicate. If 'EN' no values(0).

Regards,

Abbas.

Re: Duplicate(double) values in Database view

rosenberg_eitan — Sun, 11 May 2014 04:53:05 GMT

Hi,

What is the purpose of this view ?

If it is a for search help please look at Elementary srch hlp MAT0M

We can see that SPRAS is suplied as parameter:

Regards.

Re: Duplicate(double) values in Database view

Former Member — Sun, 11 May 2014 06:20:15 GMT

Hi Syed,

Can you add MANDT(Client) as well in Table join condition on 1st row and then MATNR(2nd row) and recheck it?

Regards,

Sudeesh Soni

Re: Duplicate(double) values in Database view

Former Member — Sun, 11 May 2014 07:32:20 GMT

Salam Aleem,

use this bapi it will resolve your problem you need the material description.

PARAMETERS:MATERIAL LIKE BAPIMATDET-MATERIAL.

DATA: MATERIAL_GENERAL_DATA LIKE BAPIMATDOA,

RETURN LIKE BAPIRETURN .

CALL FUNCTION 'BAPI_MATERIAL_GET_DETAIL'

EXPORTING

MATERIAL = MATERIAL

* PLANT =

* VALUATIONAREA =

* VALUATIONTYPE =

* MATERIAL_EVG =

IMPORTING

MATERIAL_GENERAL_DATA = MATERIAL_GENERAL_DATA

RETURN = RETURN

* MATERIALPLANTDATA =

* MATERIALVALUATIONDATA =

IF RETURN-TYPE NE 'E' OR RETURN-TYPE NE 'A'.

WRITE: MATERIAL_GENERAL_DATA-MATL_DESC.

ENDIF.

Re: Duplicate(double) values in Database view

Former Member — Sun, 11 May 2014 07:38:22 GMT

I thing the duplication is due to the language.

You probably have the same text in both languages.

Try adding field spras to the view...

Re: Duplicate(double) values in Database view

rosenberg_eitan — Sun, 11 May 2014 07:45:15 GMT

Hi,

I have the feeling that you are right...

Regards.

Re: Duplicate(double) values in Database view

former_member194739 — Sun, 11 May 2014 10:28:12 GMT

Der Sudeesh.

Thank you very much. I added MANDT field in both join condition and view fields. Now values are no duplicates.

Thanks,

Abbas.

Re: Duplicate(double) values in Database view

former_member194739 — Sun, 11 May 2014 10:51:51 GMT

w/salam,

I have not required BAPI. Thanks your assistance.

Regards,

Abbas.

Re: Duplicate(double) values in Database view

Former Member — Sun, 11 May 2014 12:08:23 GMT

Great Abbas.

Cheers