How to find out SD billing doc # using accounting doc number ?

[Former Member]

Hi Experts,

Using accounting doc tables such as BKPF , BSEG and BSID , I need to find out respective SD billing doc no when I have accounting doc number.

The issue is I cannot use either 'reference number' or assignment number' because the same numbers are not flowing to accounting doc from SD ( enabled by a enhacement ).

Regards

Mahesh.

[Former Member]

Hi,

In BKPF : AWKEY / XBLNR with these fields we can identify the SD billing document number.

In BSEG table VBELN field is Billing document number

Or

Goto T.Code FB03 enter the accounting document number,company code and fiscal year and press enter.

select the line and choose details, choose addtional data tab, here we can see the billing document number.

Regards,

Chandrasekhar.S

[Former Member]

Hi,

In Table BKPF there is a field: AWKEY (which stores the billing doc no.)

BKPF-AWKEY --> VBRK-VBELN.

U can probably make use of this link.Hope this works.

Reward points accordingly.

Cheerzz..

Subbzz.