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

Creating a view in SAP (MM/SD modules)

Former Member

‎2004 Dec 03 4:22 PM

0 Likes
1,203

Hello, all!

I'm creating a database view in SAP based on VBFA, SER01, OBJK tables. After i had specified the fields, I decided to check if everything is correct. SAP gave me several error messages. For example, please add MANDT fields of the tables and other key fields. Ok, I added them but then SAP told me that I have too many MANDT fields in the view, delete them. And now it's like in a loop! Whatever I do, it either tells me: please add MANDT for those tables or please remove MANDT.

What am i doing wrong?

I want to have this view to speed up my RFC which returns material number (MATNR), serial number (SERNR), equipment description (EQKTX) and sales order (VBELV) from VBFA.

Hello, all!

I'm creating a database view in SAP based on VBFA, SER01, OBJK tables. After i had specified the fields, I decided to check if everything is correct. SAP gave me several error messages. For example, please add MANDT fields of the tables and other key fields. Ok, I added them but then SAP told me that I have too many MANDT fields in the view, delete them. And now it's like in a loop! Whatever I do, it either tells me: please add MANDT for those tables or please remove MANDT.

What am i doing wrong?

I want to have this view to speed up my RFC which returns material number (MATNR), serial number (SERNR), equipment description (EQKTX) and sales order (VBELV) from VBFA.

Reply
5 REPLIES 5
Read only

Former Member

‎2004 Dec 03 4:32 PM

0 Likes
1,135

Hello,

You only need to add the MANDAT field once in your view. This should resolve this issue. Cheers!

Bill

Read only

Former Member
In response to Former Member

‎2004 Dec 03 4:34 PM

0 Likes
1,135

Bill, if i add once, it tells me: can u please add MANDT for other tables...So what i did is that i added MANDT but i changed their names, so now it doesnt give me this message,,,but i have another one: "The view ignores client-dependency of the base tables"

Read only

Former Member

‎2004 Dec 03 4:32 PM

0 Likes
1,135

Ok, now i changed MANDT names to MANDT1 to MANDTn. It is ok but i get a message "The view ignores client-dependency of the base tables"

Read only

Former Member

‎2004 Dec 03 4:47 PM

0 Likes
1,135

I would appreciate any explanation on how to create views in SAP. I'm quite a newbee to SAP. What i know is that it allows only inner joins between tables (no outer joins). Other than that, i don't recall other requirements.

BTW, i want to emphasize that im creating a database view , not a maintenance or a projection one.

Read only

Former Member

‎2004 Dec 03 7:29 PM

0 Likes
1,135

Ciao,

add some information to your message.

1. Join condition used

2. Key fields

3. other tables involved in your view

4. mainly the document flow. What's your starting document? Sales order? Delivery? Sernr and MATNR are in the equipment master table EQUI and in the VBAP table(sales order item).

5. why did you choose VBFA as the main table?