Run time error

[Former Member]

Hi,

I wrote the program and it is syntactically correct. But when I am executing iam getting runtime error. Anyone can plz check and tell me why it is getting and where i did the mistake.

REPORT ZFS_TAB1 LINE-SIZE 180

LINE-COUNT 26(2)

NO STANDARD PAGE HEADING.

TYPES:

BEGIN OF TY_LFB1,

MINDK TYPE LFB1-MINDK,

END OF TY_LFB1,

BEGIN OF TY_EKKO,

EKGRP TYPE EKKO-EKGRP,

AEDAT TYPE EKKO-AEDAT,

EBELN TYPE EKKO-EBELN,

SUBMI TYPE EKKO-SUBMI,

BSART TYPE EKKO-BSART,

KTWRT TYPE EKKO-KTWRT,

LIFNR TYPE EKKO-LIFNR,

END OF TY_EKKO,

BEGIN OF TY_LFA1,

KTOKK TYPE LFA1-KTOKK,

NAME1 TYPE LFA1-NAME1,

ORT01 TYPE LFA1-ORT01,

REGIO TYPE LFA1-REGIO,

PSTLZ TYPE LFA1-PSTLZ,

TELF1 TYPE LFA1-TELF1,

TELFX TYPE LFA1-TELFX,

END OF TY_LFA1,

BEGIN OF TY_ADRC,

HOUSE_NUM1 TYPE ADRC-HOUSE_NUM1,

STREET TYPE ADRC-STREET,

PO_BOX TYPE ADRC-PO_BOX,

END OF TY_ADRC,

BEGIN OF TY_ADR6,

SMTP_ADDR TYPE ADR6-SMTP_ADDR,

END OF TY_ADR6,

BEGIN OF TY_WYT3,

LIFN2 TYPE WYT3-LIFN2,

END OF TY_WYT3.

TYPES:

BEGIN OF TY_OUTPUT,

MINDK TYPE LFB1-MINDK,

EKGRP TYPE EKKO-EKGRP,

AEDAT TYPE EKKO-AEDAT,

EBELN TYPE EKKO-EBELN,

SUBMI TYPE EKKO-SUBMI,

BSART TYPE EKKO-BSART,

KTWRT TYPE EKKO-KTWRT,

LIFNR TYPE EKKO-LIFNR,

KTOKK TYPE LFA1-KTOKK,

NAME1 TYPE LFA1-NAME1,

ORT01 TYPE LFA1-ORT01,

REGIO TYPE LFA1-REGIO,

PSTLZ TYPE LFA1-PSTLZ,

TELF1 TYPE LFA1-TELF1,

TELFX TYPE LFA1-TELFX,

HOUSE_NUM1 TYPE ADRC-HOUSE_NUM1,

STREET TYPE ADRC-STREET,

PO_BOX TYPE ADRC-PO_BOX,

SMTP_ADDR TYPE ADR6-SMTP_ADDR,

LIFN2 TYPE WYT3-LIFN2,

END OF TY_OUTPUT.

• D A T A

DATA:

ST_LFB1 TYPE TY_LFB1,

IT_LFB1 TYPE TABLE OF TY_LFB1,

ST_EKKO TYPE TY_EKKO,

IT_EKKO TYPE TABLE OF TY_EKKO,

ST_LFA1 TYPE TY_LFA1,

IT_LFA1 TYPE TABLE OF TY_LFA1,

ST_ADRC TYPE TY_ADRC,

IT_ADRC TYPE TABLE OF TY_ADRC,

ST_ADR6 TYPE TY_ADR6,

IT_ADR6 TYPE TABLE OF TY_ADR6,

ST_WYT3 TYPE TY_WYT3,

IT_WYT3 TYPE TABLE OF TY_WYT3,

ST_OUTPUT TYPE TY_OUTPUT,

IT_OUTPUT TYPE TABLE OF TY_OUTPUT.

• S E L E C T I O N S C R E E N

SELECT-OPTIONS:

SMINDK FOR ST_LFB1-MINDK,

SAEDAT FOR ST_EKKO-AEDAT,

SEKGRP FOR ST_EKKO-EKGRP,

SLIFNR FOR ST_EKKO-LIFNR.

• A T S E L E C T I O N S C R E E N

AT SELECTION-SCREEN.

PERFORM VALIDATE_MINDK.

PERFORM VALIDATE_EKGRP.

PERFORM VALIDATE_LIFNR.

• S T A R T O F S E L E C T I O N.

START-OF-SELECTION.

PERFORM GETDATA_EKKO.

PERFORM GETMIND_LFB1.

PERFORM GET_VENDORMASTERDATA.

PERFORM GET_VENDORADDRESS.

PERFORM GET_VENDOREMAIL.

PERFORM GET_INVOICEPARTY.

SELECT EKKO_{EKGRP EKKO}AEDAT EKKO_{EBELN EKKO}SUBMI EKKO_{BSART EKKO}KTWRT EKKO~LIFNR

LFA1_{KTOKK LFA1}NAME1 LFA1_{ORT01 LFA1}REGIO LFA1_{PSTLZ LFA1}TELF1 LFA1_{TELFX LFB1}MINDK ADRC_{HOUSE_NUM1 ADRC}STREET ADRC_{PO_BOX ADR6}SMTP_ADDR WYT3~LIFN2 INTO TABLE IT_OUTPUT

FROM EKKO INNER JOIN LFA1 ON EKKO_{LIFNR EQ LFA1}LIFNR

JOIN LFB1 ON LFA1_{LIFNR EQ LFB1}LIFNR

JOIN WYT3 ON LFA1_{LIFNR EQ WYT3}LIFNR

JOIN ADRC ON LFA1_{ADRNR EQ ADRC}ADDRNUMBER

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK AND

EKKO~AEDAT IN SAEDAT AND

EKKO~EKGRP IN SEKGRP AND

EKKO~LIFNR IN SLIFNR.

IF SY-SUBRC EQ 0.

LOOP AT IT_OUTPUT INTO ST_OUTPUT.

WRITE:/ ST_OUTPUT-EKGRP,ST_OUTPUT-AEDAT,ST_OUTPUT-EBELN,ST_OUTPUT-SUBMI,ST_OUTPUT-BSART,ST_OUTPUT-KTWRT,ST_OUTPUT-LIFNR,ST_OUTPUT-KTOKK,

ST_OUTPUT-NAME1,ST_OUTPUT-ORT01,ST_OUTPUT-REGIO,ST_OUTPUT-PSTLZ,ST_OUTPUT-TELF1,ST_OUTPUT-TELFX,ST_OUTPUT-MINDK,ST_OUTPUT-HOUSE_NUM1,ST_OUTPUT-STREET,ST_OUTPUT-PO_BOX,ST_OUTPUT-SMTP_ADDR,ST_OUTPUT-LIFN2.

ENDLOOP.

ELSE.

WRITE:/ 'NO RECORDS FOUND'.

ENDIF.

&----

---

*& Form GETDATA_EKKO

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GETDATA_EKKO .

SELECT EKGRP "PURCHASING GROUP

AEDAT "DATE ON WHICH RECORD WAS CREATED

EBELN "PURCHASING DOCUMENT NUMBER

SUBMI "COLLECTIVE NUMBER

BSART "PURCHASE DOCUMENT TYPE

KTWRT "CUMULATIVE PLANNED VALUE

LIFNR "VENDOR ACCOUNT NUMBER

FROM EKKO INTO TABLE IT_EKKO

WHERE EKGRP IN SEKGRP AND LIFNR IN SLIFNR AND AEDAT IN SAEDAT AND BSTYP = 'A'.

IF SY-SUBRC EQ 0.

LOOP AT IT_EKKO INTO ST_EKKO.

WRITE:/ ST_EKKO-EKGRP,ST_EKKO-AEDAT,ST_EKKO-EBELN,ST_EKKO-SUBMI,ST_EKKO-BSART,ST_EKKO-KTWRT,ST_EKKO-KTWRT,ST_EKKO-LIFNR.

ENDLOOP.

ENDIF.

ENDFORM. " GETDATA_EKKO

&----

---

*& Form GETMIND_LFB1

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GETMIND_LFB1 .

SELECT MINDK "MINORIY INDICATORS

FROM LFB1 INTO TABLE IT_LFB1 WHERE MINDK IN SMINDK.

IF SY-SUBRC EQ 0.

LOOP AT IT_LFB1 INTO ST_LFB1.

WRITE:/ ST_LFB1-MINDK.

ENDLOOP.

ENDIF.

ENDFORM. " GETMIND_LFB1

&----

---

*& Form GET_VENDORMASTERDATA

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_VENDORMASTERDATA .

SELECT KTOKK "VENDOR ACCOUNT NUMBER

NAME1 "NAME1

ORT01 "CITY

REGIO "REGION

PSTLZ "POSTAL CODE

TELF1 "FIRST TELEPHONE NUMBER

TELFX "FAX NUMBER

FROM LFA1 INTO TABLE IT_LFA1.

IF SY-SUBRC EQ 0.

LOOP AT IT_LFA1 INTO ST_LFA1.

WRITE:/ ST_LFA1-KTOKK,ST_LFA1-NAME1,ST_LFA1-ORT01,ST_LFA1-REGIO,ST_LFA1-PSTLZ,ST_LFA1-TELF1,ST_LFA1-TELFX.

ENDLOOP.

ENDIF.

ENDFORM. " GET_VENDORMASTERDATA

&----

---

*& Form GET_VENDORADDRESS

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_VENDORADDRESS .

SELECT HOUSE_NUM1 "HOUSE NUMBER1

STREET "STREET

PO_BOX "PO BOX

FROM ADRC INTO TABLE IT_ADRC.

IF SY-SUBRC EQ 0.

LOOP AT IT_ADRC INTO ST_ADRC.

WRITE:/ ST_ADRC-HOUSE_NUM1,ST_ADRC-STREET,ST_ADRC-PO_BOX.

ENDLOOP.

ENDIF.

ENDFORM. " GET_VENDORADDRESS

&----

---

*& Form GET_VENDOREMAIL

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_VENDOREMAIL .

SELECT SMTP_ADDR "VENDOR EMAIL ADDRESS

FROM ADR6 INTO TABLE IT_ADR6.

IF SY-SUBRC EQ 0.

LOOP AT IT_ADR6 INTO ST_ADR6.

WRITE:/ ST_ADR6-SMTP_ADDR.

ENDLOOP.

ENDIF.

ENDFORM. " GET_VENDOREMAIL

&----

---

*& Form GET_INVOICEPARTY

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM GET_INVOICEPARTY .

SELECT LIFN2

FROM WYT3 INTO TABLE IT_WYT3.

IF SY-SUBRC EQ 0.

LOOP AT IT_WYT3 INTO ST_WYT3.

WRITE:/ ST_WYT3-LIFN2.

ENDLOOP.

ENDIF.

ENDFORM. " GET_INVOICEPARTY

&----

---

*& Form VALIDATE_MINDK

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM VALIDATE_MINDK .

DATA:

LW_MINDK TYPE T059M-MINDK,

W_INPUT TYPE C.

IF SMINDK NE 'EX'.

SELECT MINDK FROM T059M INTO LW_MINDK

WHERE MINDK IN SMINDK.

ENDSELECT.

ENDIF.

IF SY-SUBRC NE 0.

MESSAGE E000(0) WITH 'NO MINORITY INDICATOR FOR THIS CUSTOMER'.

ELSE.

W_INPUT = 'X'.

ENDIF.

ENDFORM. " VALIDATE_MINDK

&----

---

*& Form VALIDATE_EKGRP

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM VALIDATE_EKGRP .

DATA:

LW_EKGRP TYPE T024-EKGRP,

W_INPUT TYPE C.

IF SAEDAT IS NOT INITIAL.

SELECT EKGRP FROM T024 INTO LW_EKGRP

WHERE EKGRP IN SEKGRP.

ENDSELECT.

ENDIF.

IF SY-SUBRC NE 0.

MESSAGE E000(0) WITH 'INVALID PURCHASE GROUP RANGE'.

ELSE.

W_INPUT = 'X'.

ENDIF.

ENDFORM. " VALIDATE_EKGRP

&----

---

*& Form VALIDATE_LIFNR

&----

---

• text

----

---

• --> p1 text

• <-- p2 text

----

---

FORM VALIDATE_LIFNR .

DATA:

LW_LIFNR TYPE EKKO-LIFNR,

W_INPUT TYPE C.

IF SLIFNR IS NOT INITIAL.

SELECT LIFNR FROM EKKO INTO LW_LIFNR

WHERE LIFNR IN SLIFNR.

ENDSELECT.

ENDIF.

IF SY-SUBRC NE 0.

MESSAGE E000(0) WITH 'INVALID VENDOR GROUP RANGE'.

ELSE.

W_INPUT = 'X'.

ENDIF.

ENDFORM. " VALIDATE_LIFNR

[Former Member]

Hi Ram,

At what line the error is coming. Just look at dump and it will give you details.

Regards,

Atish

[Former Member]

Can you please tell the error discription.

Regards

Azad.

[Former Member]

Hi

Remove the code related to the PERFORM statements

PERFORM GETDATA_EKKO.

PERFORM GETMIND_LFB1.

PERFORM GET_VENDORMASTERDATA.

PERFORM GET_VENDORADDRESS.

PERFORM GET_VENDOREMAIL.

PERFORM GET_INVOICEPARTY.

and delete the code of these FORM..ENDFORMs..

since you are getting all the data with a single JOIN

remove this and run

and write the what error you are getting actually..

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

without posting the error and the line where it occured, we wont be able to help you.

[Former Member]

try this it will work

SELECT EKKO_{EKGRP EKKO}AEDAT EKKO_{EBELN EKKO}SUBMI EKKO_{BSART EKKO}KTWRT EKKO~LIFNR

LFA1_{KTOKK LFA1}NAME1 LFA1_{ORT01 LFA1}REGIO LFA1_{PSTLZ LFA1}TELF1 LFA1_{TELFX LFB1}MINDK

ADRC_{HOUSE_NUM1 ADRC}STREET ADRC_{PO_BOX ADR6}SMTP_ADDR WYT3~LIFN2 INTO <b>corresponding fields of</b> TABLE IT_OUTPUT

FROM EKKO INNER JOIN LFA1 ON EKKO_{LIFNR EQ LFA1}LIFNR

JOIN LFB1 ON LFA1_{LIFNR EQ LFB1}LIFNR

JOIN WYT3 ON LFA1_{LIFNR EQ WYT3}LIFNR

JOIN ADRC ON LFA1_{ADRNR EQ ADRC}ADDRNUMBER

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK AND

EKKO~AEDAT IN SAEDAT AND

EKKO~EKGRP IN SEKGRP AND

EKKO~LIFNR IN SLIFNR.

regards

shiba dutta

[former_member189059]

copy paste the entire error code and the line at which it occurs

[Former Member]

hI,

Run time error is SNAP_NO_NEW_ENTRY.

User and Transaction

Client.............. " "

User................ " "

Language key........ " "

Transaction......... " "

Program............. " "

Screen.............. " "

Screen line......... " "

Information About Termination Point in XSLT Prog.

Termination occurred in the XSLT program " ".

The call took place using CALL TRANSFORMATION fro

program specified below.

In the source code, the termination point is in l

of the (Include) program " ".

Information About Termination Point in ABAP Prog.

Internal notes

The termination was triggered in function " "

of the SAP kernel, in line " " of the module " ".

The internal operation just processed is " ".

Internal mode was started at " ".

Where i can see in which line the error is.

[Former Member]

hi,

go to source code option to see the line numner. and put the error analysis here.

so that we can help u out.

Regards

Azad.

[Former Member]

Click the long text button in top and see the line..

or else copy paste the whole Error message

Rams One more thing is u have sused select statement.

In tht u have MINDK Field in middle..

Make the select statement like this...

SELECT LFB1_{MINDK EKKO}EKGRP EKKO_{AEDAT EKKO}EBELN EKKO_{SUBMI EKKO}BSART EKKO~KTWRT

EKKO~LIFNR

LFA1_{KTOKK LFA1}NAME1 LFA1_{ORT01 LFA1}REGIO LFA1_{PSTLZ LFA1}TELF1

LFA1_{TELFX ADRC}HOUSE_NUM1 ADRC_{STREET ADRC}PO_BOX

ADR6_{SMTP_ADDR WYT3}LIFN2 INTO TABLE IT_OUTPUT

FROM EKKO INNER JOIN LFA1 ON EKKO_{LIFNR EQ LFA1}LIFNR

JOIN LFB1 ON LFA1_{LIFNR EQ LFB1}LIFNR

JOIN WYT3 ON LFA1_{LIFNR EQ WYT3}LIFNR

JOIN ADRC ON LFA1_{ADRNR EQ ADRC}ADDRNUMBER

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK AND

EKKO~AEDAT IN SAEDAT AND

EKKO~EKGRP IN SEKGRP AND

EKKO~LIFNR IN SLIFNR.

[Former Member]

hI,

This is what the runtime error message is.

Runtime Errors SNAP_NO_NEW_ENTRY

Date and Time 00.00.0000 06:14:49

-

-

---

-

-

---

Short text

Laufzeitfehler, Kurzdump konnte nicht geschrieben werden.

-

-

---

-

-

---

What happened?

Leider kann auch eine genauere Analyse des Fehlers nicht durchgeführt

werden, da die Tabelle SNAP (sie nimmt die Informationen zum

Abbruchzeitpunkt auf) keinen passenden Kurzdump enthält.

-

-

---

-

-

---

Error analysis

Die ursprüngliche Fehlerursache kann leider nicht ermittelt werden,

da in Tabelle SNAP kein passender Kurzdump vorliegt.

Wahrscheinlich enthält Tabelle SNAP bereits viele Kurzdumps,

so daß sie keine weiteren mehr aufnehmen kann. Bitte untersuchen

Sie die Situation mit Hilfe des System-Log.

In der Tabelle SNAP werden jeweils alle Kurzdumps der letzten 7 Tage

abgelegt.

-

-

---

-

-

---

How to correct the error

Je nach Fehlerursache laut SystemLog.

Wahrscheinlich muß für Tabelle SNAP mit Datenbankmitteln mehr Platz

bereitgestellt werden.

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

please use the following search criteria:

" " " "

If you cannot solve the problem yourself, please send the

following documents to SAP:

1. A hard copy print describing the problem.

To obtain this, select the "Print" function on the current screen.

-

2. A suitable hardcopy prinout of the system log.

To obtain this, call the system log with Transaction SM21

and select the "Print" function to print out the relevant

part.

3. If the programs are your own programs or modified SAP programs,

supply the source code.

To do this, you can either use the "PRINT" command in the editor or

print the programs using the report RSINCL00.

4. Details regarding the conditions under which the error occurred

or which actions and input led to the error.

-

-

---

-

-

---

System environment

SAP-Release " "

Application server... " "

Network address...... " "

Operating system..... " "

Release.............. " "

Hardware type........ " "

Character length.... " " Bits

Pointer length....... " " Bits

Work process number.. " "

Shortdump setting.... " "

Database server... " "

Database type..... " "

Database name..... " "

Database user ID.. " "

Char.set.... " "

SAP kernel....... " "

created (date)... " "

create on........ " "

Database version. " "

Patch level. " "

Patch text.. " "

Database............. " "

SAP database version. " "

Operating system..... " "

Memory consumption

Roll.... " "

EM...... " "

Heap.... " "

Page.... " "

MM Used. " "

MM Free. " "

-

-

---

-

-

---

User and Transaction

Client.............. " "

User................ " "

Language key........ " "

Transaction......... " "

Program............. " "

Screen.............. " "

Screen line......... " "

-

-

---

-

-

---

Information About Termination Point in XSLT Prog.

Termination occurred in the XSLT program " ".

The call took place using CALL TRANSFORMATION from the ABAP

program specified below.

In the source code, the termination point is in line " "

of the (Include) program " ".

-

-

---

-

-

---

Information About Termination Point in ABAP Prog.

-

-

---

-

-

---

Internal notes

The termination was triggered in function " "

of the SAP kernel, in line " " of the module " ".

The internal operation just processed is " ".

Internal mode was started at " ".

-

-

---

Thanks

[Clemenss]

Hi rams,

this is what you get with a search in the forum:

Expert Forums » Database & OS Platforms » SAP on SQL Server

Thread: Error SNAP_NO_NEW_ENTRY or DBIF_RSQL_SQL_ERROR

Welcome, Clemens Li Help

Your Control Panel Your Control Panel

Your Reward Points Your Reward Points

Your Questions Your Questions

This question is answered.

Reply to this Thread Reply to this Thread Search Forum Search Forum Watch this Thread Watch this Thread Back to Thread List Back to Thread List

Permlink Replies: 2 - Pages: 1 - Last Post: Mar 5, 2007 2:45 PM by: Eric Brunelle

Vinayak P

Posts: 175

Questions: 64

Registered: 2/6/06

Forum points: 40

Error SNAP_NO_NEW_ENTRY or DBIF_RSQL_SQL_ERROR

Posted: Mar 5, 2007 5:38 AM

Click to reply to this thread Reply E-mail this post E-mail this post

Hi,

I get Error SNAP_NO_NEW_ENTRY or DBIF_RSQL_SQL_ERROR.

Need help

Points willl be rewarded.

Thanks

Vinayak

N.P.C

Posts: 107

Questions: 3

Registered: 8/22/06

Forum points: 166

Re: Error SNAP_NO_NEW_ENTRY or DBIF_RSQL_SQL_ERROR Solved problem (10)

Posted: Mar 5, 2007 9:36 AM in response to: Vinayak P

Click to reply to this thread Reply E-mail this post E-mail this post

Hi

I would guess that your transaction log is full.

SNAP table is used to store shortdumps and this error means the table cannot be written to.

N.P.C

Eric Brunelle

Posts: 716

Questions: 1

Registered: 6/5/06

Forum points: 772

Re: Error SNAP_NO_NEW_ENTRY or DBIF_RSQL_SQL_ERROR Very helpful answer (6)

Posted: Mar 5, 2007 2:45 PM in response to: Vinayak P

Click to reply to this thread Reply E-mail this post E-mail this post

go into SM13 to see if updates are active.

check SM21 for more messages.

search SAP notes with keyword SNAP_NO_NEW_ENTRY

Pages: 1

Back to Thread List Back to Thread List

Unread New content since your last visit

Updated Updated content since your last visit

Regards,

Clemens

[Former Member]

Is it a seperate Z program or do u have any include in the program.

This program has been called from somewhere???

SNAP table is used to store shortdumps and this error means the table cannot be written to.

I think that the transaction log is full.CHECK the SNAP table

Message was edited by:

Sumi Vasu

[Nawanandana]

if u can send us to ur runtime error i think we can get som solution for that

get the runtime error in to the text file (SYSTEM>>> LIST >>> SAVE>>LOCAL FILE>>> UNCONVERTED ) u can save it as TEXT FILE then send it

regad

nawa

[Former Member]

Click the long text button in top and see the line..

or else copy paste the whole Error message

Rams One more thing is u have sused select statement.

In tht u have MINDK Field in middle..

Make the select statement like this...

SELECT <b>LFB1_{MINDK</b> EKKO}EKGRP EKKO_{AEDAT EKKO}EBELN EKKO_{SUBMI EKKO}BSART EKKO~KTWRT

EKKO~LIFNR

LFA1_{KTOKK LFA1}NAME1 LFA1_{ORT01 LFA1}REGIO LFA1_{PSTLZ LFA1}TELF1

LFA1_{TELFX ADRC}HOUSE_NUM1 ADRC_{STREET ADRC}PO_BOX

ADR6_{SMTP_ADDR WYT3}LIFN2 INTO TABLE IT_OUTPUT

FROM EKKO INNER JOIN LFA1 ON EKKO_{LIFNR EQ LFA1}LIFNR

JOIN LFB1 ON LFA1_{LIFNR EQ LFB1}LIFNR

JOIN WYT3 ON LFA1_{LIFNR EQ WYT3}LIFNR

JOIN ADRC ON LFA1_{ADRNR EQ ADRC}ADDRNUMBER

JOIN ADR6 ON ADRC_{ADDRNUMBER EQ ADR6}ADDRNUMBER

WHERE LFB1~MINDK IN SMINDK AND

EKKO~AEDAT IN SAEDAT AND

EKKO~EKGRP IN SEKGRP AND

EKKO~LIFNR IN SLIFNR.

Message was edited by:

Sumi Vasu