Buffering for database view

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi Ramesh,

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

Thanks,

Khanh

[ThomasZloch]

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

[Former Member]

Hi Thomas,

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

Thanks,

Khanh