topic Re: Create Custom Table in Application Development and Automation Discussions

Create Custom Table

Former Member — Thu, 12 Mar 2009 13:45:03 GMT

Hi,

I want to create a custom table ZVBFA which would be a copy of VBFA so it will not pull in the line item data which VBFA does. I need it to only link the header documents in my query. Is it possible to do it?

Re: Create Custom Table

vinod_vemuru2 — Thu, 12 Mar 2009 13:52:32 GMT

HI,

Two things.

1. When u create a copy of table only structure will be copied. U may have to write code to copy the data.

2. Even if u copy the initial data, how can u update ur ztable with day to day transactions???

Thanks,

Vinod.

Re: Create Custom Table

former_member156446 — Thu, 12 Mar 2009 13:53:33 GMT

you can create a database view with under lying table as VBFA and give a selection condition as your requirement

Re: Create Custom Table

Former Member — Thu, 12 Mar 2009 13:54:54 GMT

That would be a question I need to ask you.

Is it possible to update? I am not a developer but I want to know the options.

Re: Create Custom Table

Former Member — Thu, 12 Mar 2009 13:58:51 GMT

The view seems a more reasonable answer.

How do I do it. I need the steps. I am trying to create a simple query instead of a full blown report using sq01.

Is it possible.

Re: Create Custom Table

vinod_vemuru2 — Thu, 12 Mar 2009 14:03:45 GMT

Hi,

I dont think creating copy table is the feasible option here. Instead of that u can think of the option of

creation of INDEX.

In 4.6C INDEX is not possible since VBFA is cluster table.

If u r in 4.7/above u can create in INDEX since its a transparent table.

Thanks,

Vinod.

Re: Create Custom Table

Former Member — Thu, 12 Mar 2009 19:09:50 GMT

HOW do i create the index?

Re: Create Custom Table

former_member376453 — Thu, 12 Mar 2009 19:14:26 GMT

I think, for creating a query, best option will be, creating a view with the required data, and query on it. Not sure creting an index will really help you or not.

Kuntal

Re: Create Custom Table

Former Member — Thu, 12 Mar 2009 19:32:28 GMT

How do i create a view?

Re: Create Custom Table

former_member376453 — Thu, 12 Mar 2009 19:34:50 GMT

Through TRXN SE11.

Kuntal

Re: Create Custom Table

former_member156446 — Thu, 12 Mar 2009 19:37:37 GMT

[Creating a Database View|http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm]

[With screen shots>>>|http://my.safaribooksonline.com/0201703661/ch11]

Re: Create Custom Table

Former Member — Thu, 12 Mar 2009 19:42:54 GMT

But VBFA is the sales document flow table. It has neither line item nor header data.

Rob