sd Billing Document (FI Postings)

[Former Member]

Hi Guys,

I am looking at a billing document in VF03. When i checked the related accounting documents, i have a list of Accounting, PA, controlling, profit center and special ledger documents.

The number of these documents differ for different billing document numbers. How do we know how many of PA, Accoutning, Controlling etc. documents are generated for a particular billing document.

This is about SD-FI integration.

Regards

[Former Member]

Normally you will get 1 FI, 1 PCA, 1 CO and many PA. The PA depends on the level set up in PA. If it is at the material level then you'll get a PA posting for each material in your document. PA posts based on value fields and characteristics so it depends on your set up.

please assign points if helpful as a way to say thanks.

[Former Member]

Hi Dave,

Thanks a lot. I think its set up by material in our config. But i noticed that, for the same material with different posting dates the number of PA documents increase and an additional FI, PCA, FI-SL and CO documents are added.

I have another question. For a particular Billing Document, I see that the R/3 entries reconcile with BW for COPA and Rebates records in our config. But, the Billing Conditions are not reconciling properly. For example, few of these billing documents have 2 posting dates (10/05/2005) and (01/14/2006). Only the records with posting date of 10/2005 are coming into BW. The 01/2006 billing conditions are not getting posted into BW. Is there any field in the document or R/3 table that tells us if the document for the period of 01/2006 is cleared or some indicator which lets us know the exact status of the document.

George

Message was edited by: George Smith

[Former Member]

It sounds like your extractor is not set up correctly to pull the delta for condition records. There is a new delta in PI2004 that may work out better. I set mine up based on the billing document delta.

[Former Member]

Hi Dave,

Thanks for the answer. I forgot mentioning that we have some billing conditions records in BW for 01/14/2006.

I would like to mention here that, some of our Billing documents in R/3 have separate PA documents for 'Revenue' and 'Rebates' while for others, both Revenue and Rebate amounts are included in the same PA.

For example, one of our Billing Doc has separate PAs for Revenue and Rebates. The PA doc. with revenue has a posting date of 10/20/2005 (1000$) and PA for rebates has a posting date of 01/14/2006 (100$). Now of this

100$ rebates, the rebates record in BW and COPA record in BW has 2 entries (14$ rebate and 86$ rebate). In Conditions, i have only one entry (14$ rebate) with a posting date of 10/20/2005 (This seemed a bit odd since the Rebates PA in R/3 had a posting date of 01/14/2006). The other conditions entry in BW for 86$ rebate is missing.

Can you give an idea of whether its a configuration problem, if not any other place to check for in R/3 or BW?

PS: We are using 2LIS_13_VDKON extractor for Billing Conditions are on R/34.7 with a patch level of 24.

Regards

Message was edited by: George Smith

[Former Member]

The condition records in R3 are in table KONV. But the connection is the condition record to the billing doc. You can use logical data base VFV through a query to see the full flow including the billing document. So run a report in R3 for your billing document using the logical data base VFV query. Compare that to what's in BW. You'll need the ODS or cube where it is at. Compare them to see if they match. BW is probably extracting incorrect but you won't know until you check the line item level.

[Former Member]

Hi Dave,

How to access the logical database VFV in the R/3 system?

Regards

[Former Member]

You have to build a query or abap report. Try the tables directly. VBRK is the billing header and vbrp is the billing detail. The condition links to VBRK and then you can get the detail. Now you can compare the conditions detail to the billing detail.

You want to eventually compare the BW ODS or cube to the condition detail. Be careful since pricing can be statistical as well.

It may be related to the transfer or update rules in BW.

You need to establish at the item level the correct amounts in R3 then trace how they are being created in your BW system.

Message was edited by: Dave Scarpino

[Former Member]

How do you make the SD billing document and FI Invoice the same?