topic Re: Code for Count value....Bit urgent. in Application Development and Automation Discussions

Code for Count value....Bit urgent.

Former Member — Tue, 18 Dec 2007 09:49:41 GMT

Hi all,

My Requirement is like this.

1) with the shipment document number in field VFKP-REBEL (reference object in the shipment cost document header) access to VTTS (Shipment’s Stages) table with the corresponding VTTS-TKNUM

2)Count the records number corresponding to the same related Shipment Number (TKNUM)

3)Condition base value (KONV-KWART) = counted value - 1.

Can any one please povide me code for this.

Thanks in Advance......

Re: Code for Count value....Bit urgent.

Former Member — Wed, 19 Dec 2007 15:57:16 GMT

select TKNUM

FROM VFKP AS A INNER JOIN VTTS AS B

ON A_{REBEL = B}TKNUM.

INTO IT_VFKP_VTTS

WHERE """IF ANY CONDITIONS ARE THERE..

SORT IT_VFKP_VTTS BY TKNUM.

LOOP AT IT_VFKP_VTTS.

CNT = CNT + 1.

AT END OF TKNUM.

FLAG = 'X'.

ENDAT.

IF FLAG = 'X'.

MOVE IT_VFKP_VTTS-TKNUM TO WA_COUNT-TKNUM.

MOVE CNT TO WA_COUNT-CNT.

APPEND WA_COUNT TO IT_COUNT(WHICH holds data of tknum and its count.)

clear: wa_count, cnt.

ENDIF.

ENDLOOP.

............

......tknum = ....

KONV-KWART) = wa_count-cnt-1.

these for tknum field value wise.