Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Plz Help its Urgent

Former Member
0 Kudos

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

3 REPLIES 3

former_member188685
Active Contributor
0 Kudos

I think Rajasekhar

You Have Posted this question Before also...

why can't you refer the same thread...

regards

vijay

Clemenss
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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