Please help

[Former Member]

I have a situation where I need to be able to track the following information.

I am trying to implement 2LIS_11_V_SSL extractor

I need to be able to send BW,

Sales order/item - Billing Doc

- Accounting doc

- Material Document

- shipping doc number

I know they are 1:M but still I need to know how I can link the above information acurately with the SAP tables

Infact user prefers to see only the last document for all types.

Forgot to add one more think delivery doc/item

I found the following:

Table VBRP has billing doc item, delv doc, item

MSEG has material doc

I am wondering is it going to be same for the schedule lines too ? i.e, for order/item/scl combination can I use table VBRP and MSEG ?

I could not find what table I can use for account doc ? BSEG ? searching that based on order item take hrs.

Any intelligent way to collect these ? I do not want to use VBFA table.

Thanks again

KS

[Former Member · Accepted solution]

what is your schema? where do you plan to start? do you want to start with the invoice and flow back to the order and delivery and flow ahead to get the accounting doc?

if so, VBRP will give you the order & delivery details. BSEG contains the invoice number (BSEG-VBELN) as well as order, item and schedule line.

ashutosh

[Former Member · Accepted solution]

I want to start with order item and link all the related documents.

I have the delivery and billing

problem is with Material Document, Accounting Document and Shipping document (table OIGS oil)

To read bseg it takes forever since it is not the primary key

Thanks,

KS