This query is created for project SPPsalesForecast which requested by Carolina Camacho serrano to extract data to Dataiku.  The developer who create script (Python) is Adrien Ruel

Description

BW Sales - OTIF - (Dataiku Forecast)

Technical Name

DI_BW_QRY_MVSDSO50_9001

DI_BW_QRY_MVSDSO44_SD0003

Application

SD - Sales and Distribution

Info-provider

MVSDSO50 and MVSDSO44

Usage type

Dataiku extraction

Expected users


Workbook/Query General Description

DI_BW_QRY_MVSDSO50_9001 is copied again from the core query BW_QRY_MVSDSO50_0001.  Some how query DI_BW_QRY_MVSDSO50_0001, which created by CGI does not work.  

DI_BW_QRY_MVSDSO50_0001 should be deleted

General parameters

Global properties

Same as cored query just adding OLE DB for OLAP flag and add  Product Line (C_MATNR2__0CRM_PROD) and the Ship-To Country (C_SHIPTID__0COUNTRY)

Variables

Definitions


Loading Script

ObjectFilter ValueExplanation

It is loaded by following Dataiku script

  • No labels