How to select rows from a table that have same value for a specific field?

[former_member795621]

Hello,

I have a DB table in which there are BUKRS, LIFNR and DMBTR fields. I want to write a select statement that will pick any 10 records but out of those records all of them should have same BUKRS value.. lets say if CC01 is being picked then all 10 records should have same CC01 bukrs. How to achieve this?

[Eduardo-CE]

Hello:

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abapwhere.htm?file=abapwhere.htm

Regards.

[Sandra_Rossi]

Same ABAP doc of "SELECT - WHERE", but with table of contents on the left and link to latest ABAP version:

https://help.sap.com/doc/abapdocu_latest_index_htm/latest/en-US/index.htm?file=abapwhere.htm

[adityaIngale]

Hi kum28,

You can use

Select * from <DB_table_name> into table @data(lt_tab) where bukrs = 'CC01' up to 10 rows. 

Check below links for more details

https://help.sap.com/doc/abapdocu_752_index_htm/7.52/en-US/abapselect.htm