How to create view on bkpf and bseg?

[Former Member]

friends,

can we create views on bkpf and bseg if yes wht are the steps...please note it down n send me..regards essam (essamsaud@yahoo.co.in)

[Former Member]

Hi,

Already std views are available , which has both BKPF & BSEG table details.

check out the below views.

V_VBSEGK

V_VBSEGS

Reward Points if it is Useful.

Thanks,

Manjunath MS

[raymond_giuseppi]

You cannot, because BSEG is a cluster table from cluster RFBLG.

For this (historical) reason, SAP provides some "secondary index" on BSEG and BKPF which are useful for you :

BSAD Accounting: Secondary Index for Customers (Cleared Items)

BSAK Accounting: Secondary Index for Vendors (Cleared Items)

BSAS Accounting: Secondary Index for G/L Accounts (Cleared Items)

BSIS Accounting: Secondary Index for G/L Accounts

BSIK Accounting: Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting: Secondary Index for G/L Accounts

(Those tables are filled via move-corresponding, there were some OSS notes meaning you can append some fields to these tables)

Regards

[Former Member]

Custom Views can be created by going to T.Code SE11.

More details :

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ecab446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/66/33f52010dd11d6999300508b5d5211/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ecd2446011d189700000e8322d00/frameset.htm

Regards

[Former Member]

Hi,

Use standard views...

View name Short text

BKPF_AEDAT BW FI: BKPF Extraction Using AEDAT

BKPF_BSAD BW FI: BSAD Extraction Using CPUDT

BKPF_BSAD_AEDAT BW FI: BSAD Extraction using AEDAT

BKPF_BSAK BW FI: BSAK Extraction Using CPUDT

BKPF_BSAK_AEDAT BW FI: BSAK Extraction using AEDAT

BKPF_BSID BW FI: BSID Extraction Using CPUDT

BKPF_BSID_AEDAT BW FI: BSID Extraction using AEDAT

BKPF_BSIK BW FI: BSIK Extraction Using CPUDT

BKPF_BSIK_AEDAT BW FI: BSIK Extraction using AEDAT

CRMV_BKPF_BEBD FI Documents Relevant for Feedback to CRM

V_EWU_BKPF Update View for Parallel Processing on BKPF

V_VBSEGK

V_VBSEGS

Regards,

Omkar.