Sap Sale Module: RE:[sap-log-sd] Abap code for condition z001 and table 901

Posted by Peter M
on May 10 at 7:39 AM

Hi,

Many thanks.
I put code:
SELECT SINGLE matnr FROM KOTG001
WHERE KSCHL EQ 'ZINC'
AND kunnr EQ komkg-kunnr
AND matnr EQ kompg-matnr.
IF sy-subrc EQ 0.
kompg-matnr = space.
ENDIF.

but error for first line appears:
Field list without INTO clause is not allowed. . allowed. allowed.

---------------Original Message---------------
From: Peter M
Sent: Monday, May 09, 2011 9:03 AM
Subject: Abap code for condition z001 and table 901

Hi All,

I'm on project where is lack of ABAP programers.
I'm not ABAP programer (just SD consultant) and I need to make some small abap code but I have a trouble with it :(

It is about Listing/Exclusion functionality.

I need to deactivate condition Z002 (it is Exclusion) where system find in condition Z001 (Inclusion) proper combination of customer and material (I made my own table 901 for this Z001 inclusion condition)
The idea is:
in exclusion Z002 I exclude one particular material for all customer
in inclusion Z001 table 901 I set listing where I assigned one customer to one material
and I want to put in MV45AFZA code which "tell" the system "If you find in Z001 condition, table 901 combination of customer and material - "turn off" exclusion for it"

I know that for such tables like MARA or KNMT this code looks like:

SELECT SINGLE * FROM MARA (KNMT etc)
but how to write it for such things like condition Z001 and table 901.

I really hope that you understand me :)

__.____._