Skip to Content
0
Sep 07, 2023 at 03:54 AM

How to use select query with BSID which is not transparent table but it is DDL_SQL_VIEW ?

46 Views Last edit Sep 07, 2023 at 04:03 AM 2 rev

As per the requirement I have to add due date to smartform. I understood that we can not find due date in any table and

we have to calculated at code level using function module NET_DUE_DATE_GET . I have tested the function module in SE37

and it is giving the desired results.

Now I have to inculcate this FM in driver program.

I can see that the import section of function module contains field of BSID which I have to pass.

The challenge I am facing here is BSID is created not as transparent table but as DDL SQL VIEW as shown in image because of which

SELECT query is not working. it is throwing me error message that the table is unknown as shown in image.

image.png

image.png

image.png

How can I fix this issue ?

Kindly please help me out with this issue.

Attachments

image.png (31.0 kB)
image.png (83.4 kB)
image.png (52.5 kB)
image.png (51.9 kB)