topic Re: bseg table in Application Development and Automation Discussions

bseg table

Former Member — Wed, 23 Apr 2008 10:58:40 GMT

hi,

i am using BSEG table for displaying the cost of material whether it is paid or not?

plzz guide me whether it is correct table or not?

Re: bseg table

Former Member — Wed, 23 Apr 2008 11:13:12 GMT

Hi Ricky Singh,

you need to check whether the Item is Opened or Cleared i.e. Paid or not in FBL1N Transaction.

Check BSAK table for Vendor Clear Items.

Regards,

Sunil

Re: bseg table

Former Member — Wed, 23 Apr 2008 11:14:40 GMT

Go through the following links

http://www.auditware.co.uk/news/usergroups/idea_sap_ug_1/auditprog_procurement

FI tables

http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF

Re: bseg table

Former Member — Wed, 23 Apr 2008 11:19:21 GMT

check the BSID table if the entry is there then the customer has to pay the amount,this table is called Customer Open Items.

Else Check BSAD table if the entry is there then the customer has paid the amount, this table is called

Customer Closed Items.

In htese two tables there is key field called BELNR,GJAHR.

Reward if helpful.

Thank You

Re: bseg table

Former Member — Wed, 23 Apr 2008 11:52:37 GMT

hi,

actually i am looking for the vendors from whom we have the material and i want to check whether it is paid or not?

Currently i used BSEG table and when i make link with others table CHVW then data is not coming properly.now i am trying to use other tables.

so guide me more about that how do i link CHVW with BSEG as i am taking matnr as common fields but when i debug it it does not show the materials.

It is really urgent to me.

Edited by: ric .s on Apr 24, 2008 6:42 AM

Re: bseg table

Former Member — Thu, 24 Apr 2008 04:52:14 GMT

Hi Ricky Singh,

u link the tables BSEG and CHVW not only with MATNR but also with

CHVW

MJAHR......Number of Material Document

MJAHR.....Material Document Year

AUFNR......Order Number

VBELN......Billing Document

and BSEG

BELNR.........Accounting Document Number

GJAHR............Fiscal Year

AUFNR......Order Number

VBELN......Billing Document

reward if helpful

raam

Re: bseg table

Former Member — Thu, 24 Apr 2008 05:01:49 GMT

Hi Raam,

ok i am trying to do it but when i check for MBLNR field in BSEG table

dere is no such field and as per to my knowledge dere is a field called

BELNR field in BSEG,and Mjahr is d 1 which have the date of present day and GJAHR is d 1 which have the financial year.

so is it possibel to have link beteween dem?

Moreover ,BSEG IS A Cluster table on which no inner join can work and for dat purpose i am using for all enteries...

plzzz guide and if find useful definately rewarded.

Edited by: ric .s on Apr 24, 2008 7:02 AM

Re: bseg table

Former Member — Thu, 24 Apr 2008 05:08:23 GMT

Hi,

check this MBLNR is in CHVW

CHVW

WERKS......Plant

MBLNR......Number of Material Document

MJAHR.....Material Document Year

AUFNR......Order Number

VBELN......Billing Document

EBELP........Item Number of Purchasing Document

and BSEG

WERKS......Plant

BELNR.........Accounting Document Number

GJAHR............Fiscal Year

AUFNR......Order Number

VBELN......Billing Document

EBELP........Item Number of Purchasing Document

Use all the above fields in where condition in FOR ALL ENTRIES statement.

use FOR ALL ENTRIES only, it is better than INNER JOIN

raam