PO number on Billing data

[Former Member]

Hi Team,

I'm trying to pull in billing invoices history, and the client has PO number on the billing invoices.

1) Is there a way to club these two data? the billing data is going into 0sd_c03 cube and Po data is going into 0pur_c01 I think?

2)Is cost WAVWR on the billing item the revenue?

if the client is counting the revenue same as billed invoices? shld the revenue be mapped to COST.?

thanks for your time

andy

[Former Member · Accepted solution]

PO number come on 2LIS_13_VDITM field BSTNK_VF. You can map to 0PO_NUMBER.

WAVWR cost not revenue. This maps to 0COST

Revenue comes through on Subtotal 1 to 6 from pricing procedure for condition. Map to 0SUBTOTAL_1 to 0SUBTOTAL_6. Also NETVAL INV to 0NETVAL_INV and GROSS VAL to 0GROSS_VAL

pls assign points to say thanks.

[Former Member · Accepted solution]

Thanks Dave on the PO tip.

I should say I did not understand the mapping of subtotal1 thru 6 part..

What is it that they shld be mapped to.

since there is only one revenue on the Billing item data...

shld I just map it to subtotal1 and leave the rest of them blank?

Thanks again for your time

Andy

[Former Member · Accepted solution]

When you use the billing extraction process 2LIS_13_VDITM all the subtotal fileds will be there and each should be used. I would make sure each one is in the cube and map each. NETWR would be the 1 line net total. BRTWR is the 1 line gross total. Subtotals are at a condition level and would allow varying the totals. NETWR and BRTWR can include amounts that are not revenue related ie accruals.