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 10:12:19 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 — Tue, 18 Dec 2007 10:19:41 GMT

Hi Dinesh,

The simplest way to count the number of entries in the database table is to use the SELECT query with a count tag.

Ex:

SELECT count (*)

FROM db_table

INTO gv_count

WHERE your_conditions.

This should solve your query. If so please reward points and mark this question answered.

Regards.

Re: Code for Count value--Bit urgent

Former Member — Tue, 18 Dec 2007 10:19:51 GMT

Please update