How to Extract Missing billing documents into BW

[chanda]

Hi,
I have few days of billing documents missing in my BW sales cube.
Data flow is : 2LIS_13_VDITM(Delta) --> ODS (3.x) --> datamart --> Cube
I thought of filling the SETUP table using - OLI9BW and use Repair full request, but OLI9BW does not take in Billing document. It takes only sales document/SalesOrg as input.
Is there a way out to pull data into BW based on the Billing documents?
Thank you ,
Chanda

[bhavinvyas]

Hi Chandra,

JFYI. in OLI9BW field is SD Document not sales document. We know sales and billing documents are different.

It has written SD Document not sales document see the snap.

As I said earlier, If you click on F1 Help of SD Document in OLI9BW it clearly says SD Document can sales, delivery or billing document for the applications for which you are filling the data. so its not surprise its the function how it behave and its correct only. Its just you understood SD document as sales document only which is wrong.

Thanks,

Bhavin

[bhavinvyas · Accepted solution]

Hi Chandra,

Here in OLI9BW, SD Document is billing docuement only. Put billing docuemtn numbers in SD Docuement field and try to fill the setup table.

Thanks,

Bhavin

[bhavinvyas · Accepted solution]

For more information, go to OLI9BW > Press F1 Help on SD Document,

it says "The number that uniquely identifies the sales, delivery, or billing document."

[chanda · Accepted solution]

Hi BhavinKumar Vyas,
You are right. I correct myself. Entering Billing documents in SD Document field works.

Thank you .

Chanda.