Consumption bill quantity

[Former Member]

Hi All,

While making the Consumption report, i didn't enable to figure out the table or logic to get the Consumpion/Demand billed quantity  in the report for respective invoice on periodic basis.

I have already check the table EABL,DBERCHZ1,

Kindly suggest.

Thanks
Anurag Bajpai

[Former Member · Accepted solution]

Hi Anurag,

Get the bill document number for the corresponding invoice from table DBERDLB and then fetch all consumption/demand line items from table DBERCHZ1 by passing bill document number.

Hope its useful.

Regards,

Rajesh

[Former Member]

Hi Rajesh,

Thanks for your response,i already check that table since there are 52 line item and i am getting billing quantity in multiple line item,so i couldn't came to conclusion that what logic ( ex:-variant/line item) should be used to fetch the billing quantity to finalize the report.

Thanks

Anurag Bajpai

[Former Member]

Hi Anurag,

I think its easy to get consumption line items based on Line item.

Regards,

Rajesh