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

Access required fields from another datasource

Hi,

I need to have contract information for Sales Orders (i.e. doc_type / doc_categ / doc_categr / refe_doc) in Billing Document ODS (source - 2lis_13_vditm).

This data exists in my Sales Order Item ODS (source - 2lis_11_vaitm). What is the most efficient way of getting this data?

I am considering doing a lookup in the update rules of the Billing Document ODS from the Sales Order Item ODS. Will this do the trick?

Thanks,

Milind

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2008 at 07:15 PM

    Hi,

    I think this all fields are already present in the billing extractor.

    doc_type / doc_categ / doc_categr / refe_doc...this all attributes of sales are defenatley in the billing extractor just type to explore it...I am not sure what is reference doc...but rest three are there..and are commonly used from this data source....just try it out.

    There is something called as SD document category,Sales document type etc. present in the 2LIS_13_VDITM which contains the values for sales doc only.check for the fields like PVTYP,AUTYP etc.I dont remember it exactly the field name but its there and I have used it from 2LIS_13_VDITM...no need to look into sales extractor for this.

    also doing a look up like this will create a huge performace issues as for every billing doc loaded you will have to scan the whole sales item DSO again and again.will not advice to do that.

    Thanks

    Ajeet

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I cant find the objects you mentioned. Also dont think SD document category,Sales document type etc. will solve this issue.

      The and game is to be able to create a report which show how much has been sold and how much is outstanding as per contract. For example:

      Contract ID | Sales Order | Qty Sold | Qty Outstanding

      Thanks,

      Milind

  • author's profile photo Former Member
    Former Member
    Posted on Dec 31, 2008 at 07:21 PM

    Hi,

    You've got multiple options to choose from. multiprovider which'll join the data from each ODS object and will give you an union.

    You can also go in for an infoset which'll give you intersection of data based on if you do an inner join or go in for an outer join.

    The other option you've got is to create a generic datasource based on the view combining the tables you want at the R3 side and then pull the data only to one ODS.

    Again you also have the option of looking up the data from the various ODS but that'll be a hit on performance.

    Also for using the above approaches, you need to consider your requirements, data volumes and granularity.

    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.