Add fields to an existing database view.

[Former Member]

Hi All,

My requirement is to add the VKORG and VTWEG fields from the MVKE table to an existing view with MARA, MARC and MAKT tables. My problem is when I add the two fields to the existing DB view , only the material in the MVKE are being pulled. How can I get the all the material (including material that does not have a sales org and distribution channel) ? This view will be used by an extractor. Any information will be helpful. Thanks in advance.

Raj

[ThomasZloch]

Not possible, I'm afraid, since you require a left outer join, but DDIC database views only implement inner joins. Any chance you can code the extraction logic as an open SQL statement?

Thomas

[Former Member]

Thanks for your reply Thomas. I kind of figured out that using views will not fullfill my requirement.

I have to go with open SQL. Can SQ01 be used to create this query ? I have no experince with SQ01 . Please let me know.

Thanks

Raj

[edgar_nagasaki]

Raj,

I wouldn't recommend you to use SQ01 once it has (or could have) serious concerns about performance and system degradation (and actually some companies simply deny the use of it). Therefore I would suggest you to create a simple report for this purpose (or maybe an ALV, always an elegant solution ). But if it's okay to use queries in your organization/system, follows the link to an useful document I found (from other contributor here in SCN):

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10eab7af-0e54-2c10-28a5-87b47adbe...

Regards,

Edgar