Skip to Content
author's profile photo Former Member
Former Member

Difference of extractors

Dear all! Please explain or give reference to documents for standard SD extractors:

2LIS_12_VCITM

2LIS_11_VAITM

2LIS_13_VDITM

Also is there any link to FI invoice in 2LIS_13_VDITM ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 11:17 AM

    2LIS_11_VAITM --> All the Sales related data will be available

    2LIS_12_VCITM --> Once a sale order is delivered, the details concerned to delivery will be available in this DS

    2LIS_13_VDITM --> After a Sale order is Invoiced, you will get all the invoiced details relating to that sale order.

    Also is there any link to FI invoice in 2LIS_13_VDITM ?

    Ans : No. You can get that from 0EC_PCA_3 (GLPCA). The reference document in the 0EC_PCA_3 and the Invoice Numner in 2LIS_13_VDITM are the reference fields.

    Regards,

    Balaji V

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 11:11 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 11:28 AM

    Thank you for answers!

    So as I understood there are no standard LO extractors that

    combine in themselves data from SD, invoices and payments ?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Nope.. You have to do that in BW side.

      Get the data from the 3 datasource separately into 3 individual ODS.

      Have a consolidation ODS and combine the data to display the Open, Delivered or Invoiced records based on some Flag.

      Whenver a record comes from Sales ODS, update the Flag as "S", if it is from Delivery update it as "D" and if it is from Invoice update it as "I".

      So based on the flag you can get the corresponding records in yr report.

      Regards,

      Balaji V

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 02:11 PM

    The problem is that in all of that extractors there is no link to FI document from which we can take information about payment etc.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.