topic Re: Create Custom View with A004 in Application Development and Automation Discussions

Create Custom View with A004

Former Member — Thu, 22 Mar 2012 19:14:28 GMT

Hello,

I am trying to create a custom database view (SE11) with the following tables: A004 & KONP. It appears that A004 for some reason is not a valid table in a view because I receive the error: Type of table A004 is not allowed for view, Message No. E2307.

1) Is there a way I can use A004 in a view?

2) If not is there a different table in SAP that contains the same data as A004 that I can use?

3) If not is there a way I can create a consolidated view of A004 & KONP in a different way OTHER than a ABAP program.

Thanks!

Re: Create Custom View with A004

Former Member — Thu, 22 Mar 2012 19:30:08 GMT

Hi,

does the table A304 meet your needs?
It has the same key not sure if the data is there though.

Cheers
Adi

Re: Create Custom View with A004

TuncayKaraca — Thu, 22 Mar 2012 20:23:38 GMT

@Kent Maxwell

A004 is a Pooled Table that cannot be used in views. "Keep in mind that you can only include transparent tables in a database view."

Creating a Database View

Re: Create Custom View with A004

Former Member — Thu, 22 Mar 2012 20:50:48 GMT

Ok. I am not surprised. Rarely is anything elementary or straight forward with SAP.

So I can't do it because it's a POOLED Table. Is there way that I can approach this with different tables and get close to the same result?

Re: Create Custom View with A004

TuncayKaraca — Thu, 22 Mar 2012 20:59:12 GMT

A004 is a standard Condition Table for pricing. If the data, you need, stay in A004, you need to use this table. There won't be alternative. All A*** tables for pricing conditions. Each A*** table holds pricing information for pricing procedures for different key fields. You can check with SD Functional Analyst.