I don't get the Select behaviour :

[Former Member]

This select does not bring me anything in the vbak -erdat field and i don't get why...

TYPES : BEGIN OF ts_orders_out,

• vbak

vkorg TYPE vkorg,

vtweg TYPE vtweg,

vdatu TYPE edatu_vbak,

vbeln TYPE vbeln,

auart TYPE auart,

knumv TYPE knumv,

• vbap

werks TYPE werks,

matnr TYPE matnr,

erdat TYPE erdat,

abgru TYPE abgru,

posnr TYPE posnr,

kwmeng TYPE kwmeng,

vrkme TYPE vrkme,

netwr TYPE netwr,

waerk TYPE waerk,

vbelv TYPE vbelv,

posnv TYPE posnv,

• vbep

edatu TYPE edatu,

wadat TYPE wadat,

• vbpa

account TYPE kunnr,

billtoparty TYPE kunnr,

shiptoparty TYPE kunnr,

soldtoparty TYPE kunnr,

• mara

mtart TYPE mtart,

• makt

maktx TYPE maktx,

ersda TYPE ersda,

• likp

wadat_ist TYPE wadat_ist,

• konv

kbetr TYPE kbetr,

• mvke

lfmng TYPE minlf,

status(9) TYPE c,

• VBAK erdat

kerdat type erdat,

END OF ts_orders_out.

FIELD-SYMBOLS :

<ls_orders_out> TYPE ts_orders_out.

DATA : tt_orders_out TYPE TABLE OF ts_orders_out.

SELECT vkorg vtweg vdatu vbak~vbeln auart knumv

werks matnr vbap~erdat abgru posnr

kwmeng vrkme vbap_{netwr vbap}waerk vbelv posnv vbak~erdat

INTO TABLE tt_orders_out

FROM vbap

INNER JOIN vbak

ON vbak_{vbeln = vbap}vbeln

WHERE vkorg IN s_vkorg

AND vdatu IN s_vdatu

AND vbak~vbeln IN s_vbeln

AND vbak~auart IN s_auart

AND vbak~vtweg IN s_vtweg

AND vbap~werks IN s_werks

AND vbap~posnr IN s_posnr

AND vbap~matnr IN s_matnr

AND vbap~abgru IN s_abgru

AND vbap~waerk IN s_waerk

AND vbap~vrkme IN s_vrkme

AND vbak~erdat IN s_erdat.

kerdat field is empty but i there is something in vbak.

Thanks

[Former Member]

I changed the position of kerdat and it worked.

Still don't get why it wasn't....

[andreas_mann3]

try to select from a db-View like VIVEDA

(or find snother in se11-view-find)

A.

[Former Member]

Hi Alan,

In your select query you did not select the field kerdat. And you also did not select some more fields which you have mentioned in the structure ts_orders_out. Just check it out. Try to put those fields also in your select query

Regards,

Swapna.

[Former Member]

the fields which U declared in the internal table do not match ..

with your select statement ...

The field which UR looking for vbak-erdat is stored in

edatu from vbep ...

[Former Member]

Hi Alan,

I think fetching data in different table and then moving them in one will be a better idea .Secondly it will be easier to debugg where the datas are missing.

Try your luck

Binod