topic Re: Debit billings--select statement in Application Development and Automation Discussions

Debit billings--select statement

Former Member — Sun, 10 Dec 2006 08:29:05 GMT

Hi,

I am preparing one alv report related to FI module.There is one colomn called Debit billings.

The explanation given for that colomn

" Document types RV and DR which debit accounts 110000 , 110500 , 110900 and credit accounts 400000 to 401000 .

Can any one tell me how to write the select statement for this colomn.

From where i have to fetch the data.

thanks

ansari

Re: Debit billings--select statement

Former Member — Sun, 10 Dec 2006 18:00:52 GMT

It will be pretty difficult to write a single select for this. You want two matching records from BSIS or BSAS (so long as these are GL accounts).

Rob

Re: Debit billings--select statement

Former Member — Mon, 11 Dec 2006 04:20:28 GMT

Since in my report i want to get the amounts associated with the customers i think i should be using the BSID table.But the problem for me is there have given the account numbers hard coded.So i am in a doubt weather i should go to BSEG table also.

Re: Debit billings--select statement

Former Member — Mon, 11 Dec 2006 04:34:05 GMT

yeah , u have to get the records from BSEG only.But not directly.

first get the Debit entries of Custokers from BSiD+BSAD , get the accouting documents

2.by using these documents goto BSEG.Bcos BSEG is a Huge table , u may face performace Issues.

Regards

Prabhu

Re: Debit billings--select statement

Former Member — Mon, 11 Dec 2006 04:40:41 GMT

Since i am dealing with only open customers in my report i think i should only use BSID.

And after geting the doc nos from BSID i am comin to BSEG.But as you told it is giving me peroformace issues.So i think i should use BSIS instead of BSEG which may help me in the case of performance

Thanks

Ansari

Re: Debit billings--select statement

Former Member — Mon, 11 Dec 2006 05:09:50 GMT

No , U are going on Basis of G/L accounts ,So what u get in BSID is only based on the Customer items only.

entry like this 

40 customer 100/-
50 g/l           100/-

<b>in BSIS u will get only 40-100/- only , u wont get 50-100/- , so u have to goto BSEG to get g/l 50-100</b>.

regards

Prabhu

Re: Debit billings--select statement

Former Member — Mon, 11 Dec 2006 05:16:52 GMT

Hi ,

I did not understand your answer completely. I am dealing with accoutns receivable.So i was thinking i will be coming from BISD which deals with open customers.

Can you please explain to me this

<b>entry like this

40 customer 100/-

50 g/l 100/-

in BSIS u will get only 40-100/- only , u wont get 50-100/- , so u have to goto BSEG to get g/l 50-100.

</b>

Thanks

Ansari