Skip to Content
author's profile photo Former Member
Former Member

I don't get the Select behaviour :

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 vbapnetwr vbapwaerk vbelv posnv vbak~erdat

INTO TABLE tt_orders_out

FROM vbap

INNER JOIN vbak

ON vbakvbeln = vbapvbeln

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 12:49 PM

    I changed the position of kerdat and it worked.

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2008 at 12:51 PM

    try to select from a db-View like VIVEDA

    (or find snother in se11-view-find)

    A.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 12:51 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 12:52 PM

    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 ...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 01:01 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.