Create Custom View with A004

[former_member405802]

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!

[former_member209685]

Hi,

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

Cheers
   Adi

[TuncayKaraca]

@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

[former_member405802]

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?

[TuncayKaraca]

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.