topic Re: Problem with join / explicit field declaration does not work in Application Development and Automation Discussions

Problem with join / explicit field declaration does not work

Former Member — Fri, 21 Jan 2011 10:56:14 GMT

Hello together,

there is something I do not understand about the join. I have a join over two tables (see below). The field AENAM exists in both tables but I want to have it coming from ZDPP_VERBRAUCEFF.

BUT the system gives me the values from MARA although I define the source ZDPP_VERBRAUCEFF.

SELECT zdpp_verbrauceff~mandt

zdpp_verbrauceff~matnr

zdpp_verbrauceff~zzmdv01

zdpp_verbrauceff~begda

zdpp_verbrauceff~endda

zdpp_verbrauceff~vmeng

zdpp_verbrauceff~vmeng_m

zdpp_verbrauceff~aenam "Problem

zdpp_verbrauceff~aedat

zdpp_verbrauceff~aezet

zdpp_verbrauceff~prfdt

zdpp_verbrauceff~prfzt

FROM zdpp_verbrauceff

INNER JOIN mara

ON zdpp_verbrauceff_{matnr = mara}matnr

INTO TABLE lt_ver_db

WHERE zdpp_verbrauceff~zzmdv01 IN s_mdv01

AND zdpp_verbrauceff~begda <= s_datum-high

AND zdpp_verbrauceff~endda >= s_datum-low

AND mara~mtart IN s_mtart

AND mara~matnr IN s_matnr.

Can anybody tell me what I doing wrong?

Thanks in advance,

Sebastian

Re: Problem with join / explicit field declaration does not work

Former Member — Fri, 21 Jan 2011 11:05:17 GMT

hi,

Please check the link.

[http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec77446011d189700000e8322d00/content.htm]

Re: Problem with join / explicit field declaration does not work

Former Member — Fri, 21 Jan 2011 11:06:55 GMT

Hi,

Add this below in where condition.

SELECT zdpp_verbrauceff~mandt

ON zdpp_verbrauceff_{matnr = mara}matnr

INTO TABLE lt_ver_db

WHERE zdpp_verbrauceff~matnr IN s_matnr

AND zdpp_verbrauceff~zzmdv01 IN s_mdv01

AND zdpp_verbrauceff~begda <= s_datum-high

AND zdpp_verbrauceff~endda >= s_datum-low

AND mara~matnr IN s_matnr

AND mara~mtart IN s_mtart.

Regards,

Srini.

Re: Problem with join / explicit field declaration does not work

former_member201275 — Fri, 21 Jan 2011 11:32:02 GMT

Can you try change the statment sequence as I have below and see if this works i.e:

SELECT zdpp_verbrauceff~mandt

zdpp_verbrauceff~matnr

zdpp_verbrauceff~zzmdv01

zdpp_verbrauceff~begda

zdpp_verbrauceff~endda

zdpp_verbrauceff~vmeng

zdpp_verbrauceff~vmeng_m

zdpp_verbrauceff~aenam "Problem

zdpp_verbrauceff~aedat

zdpp_verbrauceff~aezet

zdpp_verbrauceff~prfdt

zdpp_verbrauceff~prfzt

FROM zdpp_verbrauceff

INTO TABLE lt_ver_db "LINE MOVED to here

INNER JOIN mara

ON zdpp_verbrauceff_{matnr = mara}matnr

WHERE zdpp_verbrauceff~zzmdv01 IN s_mdv01

AND zdpp_verbrauceff~begda <= s_datum-high

AND zdpp_verbrauceff~endda >= s_datum-low

AND mara~mtart IN s_mtart

AND mara~matnr IN s_matnr.

Regards,

Warren.