topic Re: Transparent tables in Application Development and Automation Discussions

Transparent tables

Former Member — Thu, 21 Feb 2008 10:05:57 GMT

Hello All,

I am trying to create a database view in se11 using the follwing:

RFPSD

BSEG

RFPOSXEXT

When attempting to activate the view I get the following error:

VIEW ZAGEDEBT was not activated

View allows read-only access only

'Display using Data Browser only'

The view ignores client-dependenc

Key field BSEG-BUKRS missing

Key field BSEG-BUZEI missing

Key field BSEG-GJAHR missing

Key field BSEG-MANDT missing

All fields are evaluated as key fields

Table BSEG is not transparent

Is it possible to create a view based on the table bseg even though it is not transparent?

Is there another table I can use which contains the same data as the tables I stated above?

Thanks,

Nick.

Re: Transparent tables

former_member404244 — Thu, 21 Feb 2008 10:24:37 GMT

Hi,

cehck teh table BKPF for ur requirement.

Regards,

nagaraj

Re: Transparent tables

Former Member — Thu, 21 Feb 2008 11:56:29 GMT

Hi,

You cannot create view for specified table as BSEG is cluster table. You can use table BKPF for your specific requirment.

<REMOVED BY MODERATOR>

Sachin

Edited by: Alvaro Tejada Galindo on Feb 21, 2008 9:14 AM

Re: Transparent tables

ThomasZloch — Thu, 21 Feb 2008 12:05:33 GMT

well, BSEG is a cluster table, and the other two aren't even tables, but structures. No data to be viewed here.

The whole thing does not make sense to me, so I cannot recommend a different approach.

Greetings

Thomas

P.S. using BKPF instead of BSEG does not make sense either, very different data inside...

Re: Transparent tables

Former Member — Thu, 21 Feb 2008 14:09:34 GMT

Thanks for the replies all.

How can I identify what is a cluster table, table, structure by viewing them in SE11?

I ended up creating a view from BSIS and BSID which I was then able to create my dataSource for BI.

Cheers,

Nick.

Re: Transparent tables

ThomasZloch — Thu, 21 Feb 2008 15:45:02 GMT

hi Nick,

good workaround. keep in mind though that you are only selecting open items via BSIS and BSID, if you want cleared items, you need to look at BSAS and BSAD as well.

In SE11, at the very top left of the screen, you will see e.g. "Cluster table" (or "Structure" etc.) and then the table name. That's how you can tell.

Cheers

Thomas

Re: Transparent tables

Former Member — Fri, 22 Feb 2008 09:46:40 GMT

Cheers Thomas.

One last thing that you may be able to help be with.

My report requires two other fields:

KONTO (account number)

KTEXT (Account short text)

I have been trying to find the source of these fields and it points to BSEG and RFPSD which I am unable to use.

I have searched for data elements in SE11, and it finds variuous tables that use both KONTO and KTEXT, but none of them have the data I require.

Any ideas how I can track these two fileds down?

Any help would be much appeciated.

Manay thanks,

Nick.

Re: Transparent tables

ThomasZloch — Fri, 22 Feb 2008 11:42:35 GMT

for G/L accounts, you can find this information in table SKAT:

SAKNR = account number

TXT20 = short account text

TXT50 = long account text

You also need language SPRAS and chart of accounts KTOPL for access. KTOPL can be derived from BUKRS via table T001.

For customers, it is table KNA1:

KUNNR = account number

NAME1 = account text

Hope this helps

Thomas

Re: Transparent tables

Former Member — Fri, 22 Feb 2008 14:27:49 GMT

Nice one Thomas. Your help is much appreciated.