Restrict Type from Joining on query

[Former Member]

I have created ArchivalOrder extending OrderModel.

I have inserted Recorder In archivalOrderModel.

When I query I m quering on Ordermodel I getting result of ArchivalOrderModel.

Is there Any way I can Restrict by Data modeling or any other sollution exist

[StefanKruk]

You can add an exclamation mark to your from statement to search without subtypes.

Like described here: https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/b3c53d29850c47faa977f0cda707...

SELECT * FROM {Product}  // Will search for all Products and Variants
SELECT * FROM {Product!} // Will only search for Products without subtypes
SELECT * FROM {VariantProduct*} // Search for VariantProducts and its Parent Types (Product)