Get MR's Billing & Invoicing details programmatically

[ricky_shaw]

Hi Experts,

I need to find out in a programmatical way if an Installation has MR uploaded, Billed & invoiced.

I know we can see this in ES32 under various tabs

I am writing a program to see if a particular installation (without devices) has MR's updated. How do i get this? i don't see any field for Installation in EABL table.

After this, how can i check: if the installation is billed and subsequently how to check if its invoiced or not.?

[srinivasankh · Accepted solution]

Hi Ricky,

To achieve the following, please use the below logic:

• Use table EABLG to check if there are any MR documents
• So, you use ANLAGE in EABLG and then join MR doc-EABL to check whether MR document is active or not
• Then to check whether its billed or not use the mr docs in EABL-ADAT = ERCH-END of bill period
• To check if the bill doc is invoiced or not, use ERCH-BELNR = ERCHC-BELNR then ERCHC-OPBEL = ERDK-OPBEL.

Do consider reversal indicators, simulation indicators, outsort status where applicable.

Hope this helps.

Thanks,

Srini

[ricky_shaw · Accepted solution]

Hi, Can you suggest if its enough to query V_EABL instead of joining EABL + EABLG?

[srinivasankh · Accepted solution]

Hi Ricky,

Yes, if you have that View which has the join on MRDoc-EABLG-EABL then you can use that.

Thanks,

Srini

[ricky_shaw]

Hi Srini,

In your response above You said "Then to check whether its billed or not use the mr docs in EABL-ADAT = ERCH-END of bill period"..

I am not getting the specific billing docs.

Can you suggest more filtering criteria here as I see same ADAT in EABL for many MR docs?

Should i compare EABL-ADAT with ABRDATS or it should be between BEGABRPE & ENDABRPE??

Thanks

Ricky