6 Answers
-
Best Answer
Former MemberPosted on Oct 17, 2006 at 09:14 AMHello,
Do like this.
Select * from ekko into table IT_EKKO where EBELN IN S_EBELN.
If not IT_EKKO[] is initial.
SELECT * from EKPO into table IT_EKPO for all entries in IT_EKKO where EBELN = IT_EKKO-EBELN.
endif.
Loop at IT_EKKO.
READ atble it_ekpo with key EBELN = IT_EKKO-EBELN.
if sy-subrc NE 0.
Error Meesage.
endif.
ENDLOOP
If useful reward.
Vasanth
Add a comment
-
Former MemberPosted on Oct 17, 2006 at 09:30 AM
SELECT ebeln
ebelp
FROM ekpo
INTO TABLE t_ekpo
FOR ALL ENTRIES IN t_ekko
WHERE ebeln EQ t_ekko-ebeln
AND loekz EQ ' '.
loop at t_ekko.
read table t_ekpo with key ebeln = t_ekko-eblen.
if sy-subrc =0 .
item exists
else.
item not exists.
endif.
-Anu.
Add a comment
-
Former MemberPosted on Oct 17, 2006 at 09:35 AM
U can directly check the table EKPO for the purchase order and item data. Because, item cannot exists without header data. Unless you want to read EKKO for some other data or in different section of the code.
SELECT SINGLE EBELN POSNR into lbelnr lposnr
FROM EKPO
WHERE ebeln = <yourdata> and
posnr = <youritem>.
If sy-subrc = 0.
it exists
else.
does not exist.
endif.
U can do the same for EKKO for po header data.
Add a comment
-
Posted on Oct 17, 2006 at 09:14 AM
hi,
check table ekko for PO and ekpo for items
A.
Add a comment
-
Former MemberPosted on Oct 17, 2006 at 09:18 AM
Hi ,
u mean to say the po is existing fine and now the items under that po is existing or not ???
am i missing something here or
are u looking for the items which are deleted under that po number in ekko ..
if so in ekpo(item level) u have po with items
check the field loekz --Deletion indicator in purchasing document
or in the entries put loekz = x ,
this will fetch u the items deleted under that po ..
hope this helps ,
regards,
VIjay
Add a comment
Add a comment