topic Re: query on select stmt in Application Development and Automation Discussions

query on select stmt

Former Member — Tue, 24 Jun 2008 08:13:15 GMT

hi,

below is the extraction logic

1. Select all invoice documents from Table VBRK where Sales Organization VBRK-VKORG, Distribution Channel VBRK- VTWEG and Division VBRK-SPART matches to Sales Organization, Distribution Channel and Division specified in the selection parameters and SD Document Catergory VBRK- VBTYP <> N u2013 Invoice Cancellation type S1 and S2.

2. Select all invoice documents from the above where all Sold-to party/Ship-to party customers VBRK-KUNAG and payer customers VBRK-KUNRG matches to Sold-to party/Ship-to party and payer specified in the selection parameters

how to write the select stmts for the abluve logic??.

thank you in advance.

Re: query on select stmt

Former Member — Tue, 24 Jun 2008 08:15:42 GMT

Why ask others to write your code. How will you learn. Try it yourself then if you have problems then ask.

Re: query on select stmt

Former Member — Tue, 24 Jun 2008 08:18:07 GMT

select *

from vbrk

into table i_vbr

where vkorg in s_vkorg

and vtweg in s_vtweg

and sprat in s_sprat

and kunag in s_kunag

and kunrg in s_kunrg.

Re: query on select stmt

Former Member — Tue, 24 Jun 2008 08:18:09 GMT

Hello,

The specification is so clear, and if you are not able to build a SQL query out of the info U've.. you need training! Get trained 1st, learn and work.. or at least give it a try..

Rgds,

Raghu.

Re: query on select stmt

Former Member — Tue, 24 Jun 2008 08:19:49 GMT

Usha Devi,

Why do you feel the need to respond to this in a way to only receive points.

Oh and by the why, that SQL you have provided.......

Re: query on select stmt

Former Member — Tue, 24 Jun 2008 08:20:39 GMT

Martin has a point..I agree to him..

Re: query on select stmt

JanStallkamp — Tue, 24 Jun 2008 08:32:16 GMT

Hi.

I will lock this thread. This is not a question that should be discussed in this forum. Your specification is so close to real code that even without any ABAP knowledge a look into some demo programs and the online help for 'SELECT' will solve it.

As Martin said: If you tried it and have any particular problems then we can discuss them here.

Best regards,

Jan Stallkamp