sy-dbcnt

[Former Member]

what is sy-dbcnt

[Former Member]

Hi

Database Count. It will count number of records in a database table.

Regards

Haritha.

[Former Member]

Hi

Database Count. It will count number of records in a database table.

Regards

Haritha.

[Former Member]

SY-DBCNT gives the number of records in database table

After an open SQL statement, the system field sy-dbcnt contains the number of database lines processed.

REPORT ychatest.

DATA : v_matnr LIKE mara-matnr.

SELECT matnr FROM mara INTO v_matnr UP TO 1 ROWS.

ENDSELECT.

WRITE : sy-dbcnt.

Message was edited by:

Chandrasekhar Jagarlamudi

[Former Member]

it will return the number of records processed in the database.

[Former Member]

hi,

Welcome to SDN

SY-DBCNT:: no. of records processed in database table after a query.

SY-DBCNT

SQL statements set the content of SY-DBCNT to the number of database lines processed. With SELECT loops in Open SQL, SY-DBCNT is set after the ENDSELECT statement. In Native SQL, SY-DBCNT is set after the ENDEXEC statement.

DELETE sets SY-DBCNT to the number of lines deleted.

FETCH sets SY-DBCNT to the number of lines already read by the current cursor.

INSERT sets SY-DBCNT to the number of lines inserted.

MODIFY sets SY-DBCNT to the number of lines processed.

UPDATE sets SY-DBCNT to the number of lines changed.

Return Value

~~Guduri

[Santosh_Kezkhepatmelathil]

it is a System Field which gives you the Number of Records In database table

regards,

santosh.

[Former Member]

Hi,

Number of elements in edited dataset with DB operations

WRITE: /12 'Number of selected records:', SY-DBCNT CENTERED.

Regards,

Bhaskar

[Former Member]

when a selct query was executed it will have how many records fetched from database

[Former Member]

nmhnh

[Former Member]

no of records read (rows processed) in database.

[bharat_rathod2]

Dear,

this thread is marked as answered s no need to give answer

[Former Member]

ohh...okk...new here so didn't noticed that.