Create Custom Table

[Former Member]

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?

[vinod_vemuru2]

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.

[Former Member]

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.

[Former Member]

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.

[vinod_vemuru2]

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.

[Former Member]

HOW do i create the index?

[former_member376453]

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

[Former Member]

How do i create a view?

[former_member376453]

Through TRXN SE11.

Kuntal

[former_member156446]

[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]

[former_member156446]

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

[Former Member]

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

Rob