Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Issue with Maintenence View generated using SE54

shishupalreddy
Active Contributor

‎2008 Mar 12 12:48 AM

0 Likes
525

Hello all,

We generated a view V_T16FC with the tables T16FC

T16FD

T16FG

when we try to see the data in the view , it is saying no data in the view , though the data is ther in all the three tables .

I checked foreign key relations they are fine .

can any please provide what could be the problem .

Helpful answers will be rewarded.

Urgent !!!!

Hello all,

We generated a view V_T16FC with the tables T16FC

T16FD

T16FG

when we try to see the data in the view , it is saying no data in the view , though the data is ther in all the three tables .

I checked foreign key relations they are fine .

can any please provide what could be the problem .

Helpful answers will be rewarded.

Urgent !!!!

Reply
2 REPLIES 2
Read only

Former Member

‎2008 Mar 12 6:32 AM

0 Likes
496

even if data is there in 3 tables, matching data might be not there.

if you check the join conditions clearly field FRGGR is checked against 3 table where as field FRGCO is checked against table T16FD and T16FC.

try to write a simple join query against these 3 tables as per the join conditions in the view "V_T16FC", still it does the same thing.

Read only

Former Member

‎2008 Mar 12 6:34 AM

0 Likes
496

Check the below link.

[http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecec446011d189700000e8322d00/content.htm|http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecec446011d189700000e8322d00/content.htm]

Hope it helps.

Thanks,

Balaji