Skip to Content
0
Former Member
May 08, 2012 at 06:51 AM

Lead Time Report - Table relationships

43 Views

Hi all,

I have the following fields to be identified in the specified table for the Lead time report in BI.

Goods Issue Time based on 'LIKP.WADAT_IST' - 'LTAK.BDATU' Actual Goods Movement Date - Creation Date of Transfer Order Goods Receipt Time based on 'LTAK.QDATU' - 'RV50A.WDAT_IST_LA'. Date of Confirmation - Actual goods receipt date for inbound deliveries Transit Time based on 'RV50A.WDAT_IST_LA' - 'LIKP.WADAT_IST' Actual goods receipt date for inbound deliveries - Actual Goods Movement Date

The above fields will be linked in BI to 2lis_02_itm Datasource.

Once I get the relationship identified, I will create a generic datasource on the above 6 fields and take it into BI.

Then I need esatblish a link between 2lis_02_itm datasoure and the created Generic datasourc; then update the infoCube on top it.

Here, I would need to idenfy table relationships for the above fields; also the key fileds able to link the 2lis_02_itm in BI.

Requesting your help & guidance.

Thanks..

regards

San