Access required fields from another datasource

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[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