Query related to ERCH table

[Former Member]

Hi all,

Can anyone tell me how to capture all the billing data subjected to in a month,irrespective of

begabrpe & endabrpe.

eg. begabrpe starts from 07 may 2006 & endabrpe 5 june 2008 or 7th july

2008 to 1st jan 2009 respectively which are billed in current month.

my main concern is to capture the previous begabrpe & endabrpe which are involved with billing

of current month consumers.

means I have to set the logic at that much level so that it can't exclude any cases which

are billed in current month ie irrespective of bagabrpe & endabrpe.

can anyone please help me out.

Thanks & Regards...

Rajeev

[Former Member]

hi

You can use the field BELEGDAT from table ERCH.

it is the Creation date of billing document.

you can choose all the billing doc created in this month and u can put the condition BELEGDAT > ENDABRPE so u will get billing doc created in the current month but whose billing period lies in the previous month.

Regards,

Sumedha.

[Former Member]

Hi,

Can you little bit explore why BELEGDET > ENDABRPE is necessary ...because cases maybe like

that for the current month billing BEGABRPE starts from the same month & ends into the next month.

in such casses BELEGDET > ENDABRPE condition will exclude the consumers falling in the above

scenario.

Thanks & Regards...

Rajeev Shrivastava

[Former Member · Accepted solution]

Hi

With the condition i meantioned u will get the billing doc created in the current month but their begin date and end date is of an earlier period.

For u to get all the billing doc created in the current month omit the condition belegdat > endarpe.

With this u will get all the billing doc created in the current month irrespective of its end date and begin date.

Regards,

Sumedha

[Former Member]

Hi,

Thanks a lot Sumedha.

I am reallly thankful for your reply.This logic will definitely help me when I will start my development

for Outbound Interface Program.

Thanks & Regards,

Rajeev

[Former Member]

Hi,

I am glad i could help

Regard,

Sumedha

Edited by: Sumedha Lele on Apr 30, 2009 3:06 PM

[Former Member]

Hi Sumedha,

If anyone can help please help me out...

I have again a query regarding the same issue.

suppose I am picking the billdocs on the basis of BELEGDAT,

now problem is related to a gap when I will proceed further to the pick Invoices for the created

billdocs....I am exploring it as by example.

assume I am picking the billdocs created on 02.05.2009,some Invoices of the

concerned billdocs are not completed right at the same time but its over as on 06.05.2009.

now when I will pick the billdocs created on 02.05.2009 these invoices will no longer

there becoz they are not ready at that time.

& when I will pick the billdocs created on

06.05.2009 then I have not available those billdocs whose invoices are completed now.

so I will miss those invoices.

so is this the right way ERCH-> DBERDLB -> ERDK ???

or I should follow ERDK -> DBERDLB .....but again there is problem of two dates

ERDAT(creation date) & AEDAT(change on date).???

or what should be right way for a Utility Company so that in a very rare & extreme

extraordinary circumstances the gap in logic will takeplace.???

NOTE - > keep it in mind that I have to schedule the program on the daily basis.

Thanks & Regards,

Rajeev

Edited by: Rajeev Shrivastava on May 4, 2009 7:40 AM

Edited by: Rajeev Shrivastava on May 5, 2009 1:48 PM

[Former Member]

HI

try using the fields NINVOICE -- > Billing document without invoicing and NBILLREL --> Not relevant to billing. ( from table erch)

These fields will help u to pick up the bill doc which are used for invoicing.

as far as the field AEDAT is concerned.. i dont know what exactly causes it to change but will find out and update u asap.

Regards,

Sumedha.

[Former Member]

Hi,

Thanks! I will the new erch logic...

and I will wait for updated reply...

Thanks & Regards,

Rajeev