12-05-2005 11:02 AM
Hi All,
i want include Post Goods issue PGI in my output list and also find the latest date
in PGI,Installation,Contract signed,Action,Acceptence
Installation date VEDA VINSDAT
Acceptance date VEDA VABNDAT
Contract signed VEDA VUNTDAT
Goods issue date LIKP - WADAT_IST
i will send the code plz send how to find latest and PGI
TABLES : VBAK,VBAP,VBEP,VEDA,LIPS,LIKP.
DATA: BEGIN OF T_VBMTV OCCURS 200,
BSTNK LIKE VBAK-BSTNK,
AUART LIKE VBAK-AUART,
KUNNR LIKE VBAK-KUNNR,
VBELN LIKE VBAK-KUNNR,
FAKSK LIKE VBAK-FAKSK,
POSNR LIKE VBAP-POSNR,
KWMENG LIKE VBAP-KWMENG,
VRKME LIKE VBAP-VRKME,
NETWR LIKE VBAP-NETWR,
WAERK LIKE VBAP-WAERK,
VASDA LIKE VEDA-VASDA,
VINSDAT LIKE VEDA-VINSDAT,
VABNDAT LIKE VEDA-VABNDAT,
VUNTDAT LIKE VEDA-VUNTDAT,
ETENR LIKE VBEP-ETENR,
EDATU LIKE VBEP-EDATU,
WADAT_IST LIKE LIKP-WADAT_IST,
LATEST_DATE TYPE D,
END OF T_VBMTV.
SELECT-OPTIONS S_VBELN FOR VBAK-VBELN.
SELECT-OPTIONS S_AUART FOR VBAK-AUART.
SELECT-OPTIONS S_KUNNR FOR VBAK-KUNNR.
SELECT-OPTIONS S_VABN FOR VEDA-VABNDAT.
SELECT VBAKBSTNK VBAKAUART VBAKKUNNR VBAKVBELN VBAK~FAKSK
VEDAVASDA VEDAVINSDAT VEDAVUNTDAT VEDAVABNDAT
VBAPPOSNR VBAPKWMENG VBAPVRKME VBAPNETWR VBAP~WAERK
VBEPETENR VBEPEDATU INTO CORRESPONDING FIELDS OF TABLE T_VBMTV
FROM ( ( ( VBAK INNER JOIN VEDA ON VEDAVBELN = VBAKVBELN )
INNER JOIN VBAP ON VBAKVBELN = VBAPVBELN )
INNER JOIN VBEP ON VBAKVBELN = VBEPVBELN
AND VBAPPOSNR = VBEPPOSNR )
WHERE VBAK~VBELN IN S_VBELN
AND VBAK~AUART IN S_AUART
AND VBAK~KUNNR IN S_KUNNR
AND VEDA~VABNDAT IN S_VABN.
PLZ REVIEW THE ABOVE CODE AND REPLY ME THE MODIFICATIONS
I WANT FIND THE LATEST DATE
HOW TO GET PGI FROM LIKP COMPARING THE ABOVE QUERY
ADVACED TAHNKS FOR UR REPLY
I LOOK FORWAR DTO UR REPLY
REGARDS
SEK
12-05-2005 11:12 AM
I think Rajasekhar
You Have Posted this question Before also...
why can't you refer the same thread...
regards
vijay
12-05-2005 1:11 PM
have a look at table VBFA - document flow. From there get subsequent deliveries for orders. Then get PGI from LIKP.
If you want the dabase do the job for latest PFI, try
select max( WADAT_IST ) from LIKP
good luck,
Clemens
12-05-2005 1:31 PM
Hi Clemens,
Thank u for ur reply
My itab t_vbmtv
in that
Action date VEDA VASDA
Installation date VEDA VINSDAT
Acceptance date VEDA VABNDAT
Contract signed VEDA VUNTDAT
Goods issue date LIKP - WADAT_IST
one more file latest_date
loop at t_vbmtv.
we are compare VEDA VASDA ,VEDA VINSDAT ,
VEDA VABNDAT , VEDA VUNTDAT
LIKP - WADAT_IST
all these fields and find out the latest date out of these 5 then move the latest date to t_vbmtv-latest_date.
how to finf the latest date out of these 5 , plz review this and reply me the logic
advanced tahnks for ur reply
i look forward to ur reply or call
Regards
Sek