problem in picking up the data

[Former Member]

hi,

I have a requirement of picking up the data from mvke and a005 table.

In an internal Table select all records from MVKE where Sales Org/Dist Channel/Material Number = Selection Screen parameters u2013 Exclude the Following Values of Core assortment Code: Q/N/X/I

2. If Material Selection is Blank on selection screen Join tables MVKE and A005 where Sales Org and Dist Channel = Selection Parameters and Core Assortment code is Q or N and A005-KSCHL = ZCSP and A005-KUNNR = Selection screen u2013 Select all Materials and add them to the internal table.

here a005 is cluster table.

Example if the following Materials existed in Sales org 2103

Material (MATNR) CAC

MAT_1 C

MAT_2 C

MAT_3 C

MAT_4 B

MAT_5 B

MAT_6 Q

MAT_7 Q

MAT_8 N

MAT_9 X

MAT_10 I

MAT_11 C

MAT_12 C

MAT_13 C

MAT_14 C

Step 1 would pick

MAT_1

MAT_2

MAT_3

MAT_4

MAT_5

MAT_11

MAT_12

MAT_13

MAT_14

If the following ZCSP Records were in Place (Table A005)

ZCSP

KUNNR MATNR

106367 MAT_6

106367 MAT_8

113047 MAT_4

113047 MAT_8

And when the prog. is rin for a cust.

MAT_6 and MAT_8 would also be included in the Output.

how to do this i'm just confused

[Former Member]

read about how to do a subquery in SE30. Or do a simple loop on internal table created from A005 and delete those rows from the first table (if not being executed for a customer). Not difficult at all.... just write the code and then if you can't figure out why it doesn't work, post a specific question....

What you've done here is call "spec dumping"... the forum isn't a do-my-work-for-me source, but participants do offer help to specific coding errors or problems..