Table for billing document to IDOC cross reference

[Former Member]

Hello,

I've been tasken with writing an audit report to confirm that our EDI package (Reims) is sending all our billing IDoc's.

I need to find a SAP table that holds the billing document & IDOC or a function to retrieve this.

Any help appreciated.

[Former Member]

Hello,

I've been tasken with writing an audit report to confirm that our EDI package (Reims) is sending all our billing IDoc's.

I need to find a SAP table that holds the billing document & IDOC or a function to retrieve this.

Any help appreciated.

[christian_wohlfahrt]

Hi Simon!

Billing documents are stored in tables VBRK / VBRP (/...).

Function modules:

BAPI_BILLINGDOC_GETLIST

BAPI_BILLINGDOC_GETDETAIL

BAPI_BILLINGDOC_DISPLAY

Alternatively you can write a own (RFC-)function module, to get a starting list of all numbers (something like select VBELN from VBRK where ERDAT in s_date_range).

Regards,

Christian

[Former Member]

Christian,

I managed to find VBRK \RL etc but couldn't find a way of cross referencing from these files to the IDoc number.

I can see the IDoc number when I look at the header output through the screen but can't seem to find where that is stored.

[christian_wohlfahrt]

Hi Simon,

I'm not sure, if there is a cross-reference in the way you might expect.

You can send one billing doc multiple times, each IDOC has it's own status overview...

Do you want to have an overview like WE05? Have a look at tables starting with EDI*, e.g. EDID4 and EDIDS.

In the segments the billing doc number can be found.

Or does your check concentrates on the messages?

Regards,

Christian

[Former Member]

I think I can get this out of EDIDC --- EDIDD after some more testing.

Many thanks