Code for Count value--Bit urgent

[Former Member]

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......

[Former Member]

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.

[Former Member]

Please update