topic query ex in Application Development and Automation Discussions

query ex

Former Member — Fri, 17 Nov 2006 07:37:57 GMT

Hi experts,

Please see the following statements ,with that i need select query,Please help me on this.

Q1: Here the payment due date needs to be calculated.

*Take VBRK-FKDAT and VBRK-ZTERM.

*For the payment term found,look up V_T052_ZTERM,and check the number of days V_T052_ZTAG1.

*Add V_T052_ZTERM to VBRK-FKDAT ,Display DDMMYY.

Thanks & Regards

Former Member — Fri, 17 Nov 2006 09:06:33 GMT

<b>HI

Select single FKDAT ZTERM from vbrk into corresponding fields of <itabname> where<condition>

if sy-subrc = o.

select V_T052_ZTERM V_T052_ZTAG1 from <tabname> where V_T052_ZTERM = <itab-ZTERM> into corresponding fields of <itab2>.

if sy-subrc = 0.

ADD V_T052_ZTERM TO <itab-FKDAT>.

endif.

Then for display Use EDIT MAsk.

Mark points if helpful.

Regs

Manas Ranjan Panda</b>