topic Re: Buffering for database view in Application Development and Automation Discussions

Buffering for database view

Former Member — Tue, 02 Jun 2009 04:28:46 GMT

Hi experts,

I want to create a database view for these 3 tables: Vbak, Vbap and Vbpa.

I try to set up buffering on (Goto --> Technical Settings) for this view but it said that my view cannot be buffered.

I found that field PARVW in Vbpa is a key field and it is not in join condition. May be this is the reason why my view can not be buffered. Below is my join condition:

VBAP-MANDT = VBAK-MANDT
VBAP-MANDT = VBPA-MANDT
VBAP-VBELN = VBAK-VBELN
VBAP-VBELN = VBPA-VBELN
VBAP-POSNR = VBPA-POSNR

Please help.

Re: Buffering for database view

Former Member — Tue, 02 Jun 2009 04:41:30 GMT

Hi Khanh,

Chk these links

http://help.sap.com/saphelp_40b/helpdata/en/cf/21ecab446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_40b/helpdata/en/cf/21eadf446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_40b/helpdata/en/cf/21eaec446011d189700000e8322d00/content.htm

Thanks and regards

Srikanth.P

Re: Buffering for database view

Former Member — Tue, 02 Jun 2009 06:20:54 GMT

Hi,

I have tried with ur join condition...i am able to create buffering...

please check ur end or delete and create newly.

Regards,

Ramesh.

Re: Buffering for database view

Former Member — Tue, 02 Jun 2009 06:59:13 GMT

Hi Ramesh,

I'm creating in ECC6 and can not turn buffer on.

Thanks,

Khanh

Re: Buffering for database view

ThomasZloch — Tue, 02 Jun 2009 07:27:42 GMT

Different question, why do want to switch on buffering for sales documents at all? Buffering is recommended for tables where the number of rows is rather small and where the contents rarely change, and sales documents are normally just the opposite.

Thomas

Re: Buffering for database view

Former Member — Tue, 02 Jun 2009 07:46:55 GMT

Hi Thomas,

You are right. I should not create a view which enable buffering like that.

Thanks,

Khanh