Billing header and billing item data

[Former Member]

Hi All

I am having billing header DSO with billing number , billing type , billing date and pos recpit number but no key figures . and billing item DSO with billing number , billing type , billing date and key figures .

My question is now i want to combine the billing header with billing item . so that i can show as below .

billing number , billing type , billing date , pos recpit number and key figures .

but the problem is header doesnt have any key figures . when i combine both these DSO' s . i am not getting the sales in one line .

it is giving one line as billing number , billing type , billing date , pos recpit number & all keyfigures as Zeros .

and second line billing number , billing type , billing date , pos recpit number (as zero) & all keyfigures values .

SO my question is how can get the billing information including pos recepit in one line .

Apperciate all your answers . and rewarded . this is quite urjent .

Thanks alot in advance .

[Former Member · Accepted solution]

Tania:

I think you have a couple of options here.

1. When you load the Billing Item DSO, do a look up into the Header DSO and fetch the header level data (which i believe the field you are looking for is pos receipt numbe and populate it in your line item DSO.

Or

2. create a InfoSet join between your header DSO and item DSO based on Billing document number. This will give you the header information at line item level.

OR

3. Enhance the Billing Item extractor to get the header field from the billing header table in R3 VBRK.

Hope one of these options will work for you.

Good Luck.

MP.

[Former Member]

ideally billing item dso will have bill no and item as part of key and this is resulting in multiple rows. when you combine with header.

in your case it seems you don't have any billing item no in item level dso . is that the case??

if yes then data is at same granularity in your header and item level dso (in your case).

make the key portion same and you will have one record in target DSO.

else lookup on header is the option available