query on select stmt

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[JanStallkamp]

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