The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.



Description

Ex : BW - Working Capital for GBU (Core Workbook)

Technical NameEx : BW_QRY_MPR_FC001_0022

Application

Ex : FIWC - Working Capital

Info-provider

Ex : MPR_WC02

Usage type

Direct execution in Analyzer / Broadcast / Qlikview Source / ...

Expected users

Ex: GBU zone and WW controllers


Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

TabScreenshotComment
DisplayInsert screenshot  
Rows/ColumnsInsert screenshot  
Value DisplayInsert screenshot  
PlanningInsert screenshot  
ExtendedInsert screenshot  

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

Ex : Calendar Day

0CALDAY

Single/Multiple/SelectOption/SAPexit/ClientExit

Yes/No

Explanation for the use of this variable

Variable Sequence

Add screenshot

Filters

ObjectFilter ValueExplanation
Ex : Status of the trading partner Ex : <> 1 Ex : Exclude intercompanies

Add screenshot if relevant

Key figures

Key Figure 1

Description

Text/name of the variable and explanation

Calculation rule detail

Quantity x Price

Text Replacement Variable

If relevant, add the text replacement rule used for the key figure

Currency Conversion

Exchange Rate Type : Ex ZRH0

Currency : Variable, or fixed currency used

Time Reference : Current date / Based on infoobject X / Variable

Unit Conversion

Unit : Variable or fixed unit

Characteristics


Info-object NameInfo-object TextExplanation (if needed)

Demand

Review

Budget

Review

Forecast

Accuracy

Segmentation

QV

DR

QV

FA

0CALMONTHCalendar Year/MonthTextColumnRowColumnFreeFreeColumn
0LOGSYSSource SystemNo display to avoid the display of the prefix for compound characteristics.RowRowRowRowRowFree
C_MATNR2Material

Key + Text

RowRowRowRowRowFree
C_SHIPTIDSAP Ship-to

Key + Text

Previously, the Ship-to was C_SHIPTO, but description were not daily loaded.

Previous 30/10/2017, the description was 'Ship-to'

02.2019 Added in Segmentation

RowRowRowFreeRowRow
0DISTR_CHANDistribution Channel

Key + Text

Available for RCS only. For SOLVAY it corresponds to the 2 first characters of the BU.

Also available for Logility flow, coming from Exclusion table since 01.2018

RowRowRowRow
Free
C_DYN_024DYN Ship-to (incl.Prosp)

Available for DynaSys since 30/10/2017

02.2019 Added on FA

FreeFreeFreeFreeFree
CPFCTR1_2BFC Global Business Unit

Key + Text

From DSO DBDYN02 to get the BU (C_DYN_010), then MasterData C_DYN_010 to get the GBU

FreeFreeFreeFreeFreeFree
C_MATNR2__0PROD_HIERProd. HierarchyKey + TextFreeFreeFreeFreeFreeFree
C_MATNR2__C_PRODCommercial Product / Material Group

Key + Text

Commercial Product for RCS WP1.

Example 90001465 / RHODOLINE® 581B


Material Group for SOLVAY PF1.

Example Z10-11695 / SD TGT<0,15


Exception rule : for material RCS dupplicated on Solvay PF1, having Basic Material filled with Commercial Product, value is stored in C_PROD axis instead of Material Group


02.2019 Added on Segmentation

Free

Row

FreeFreeFreeFree
C_SHTCTRYShip-to Country

Text

02.2019 Added on Segmentation

FreeRowFreeFreeFreeFree
C_SOLDIDSold-to

Key + Text

Previously, the Sold-to was C_SOLDTO, but description were not daily loaded.

FreeFreeFreeFreeFreeFree
C_SOLDID__C_GRCUSTIndustrial Group

Text

V1 = C_CUSTOMR__C_GRCUST

For V2 it has been changed for C_CUSTID. The field KONZS is taken from PRS Customer. PRS seems not contains all customers (only payer?). If Customer Group (C_GRCUST) are missing, the masterdata will have to be upgraded to get missing ones.

FreeFreeFreeFreeFreeFree
C_DYN_017__C_SAL_GRPSales Group

Sales Group = Sales Rep for RCS WP1 Only

Source :

  • M3 order for Solvay PF1
  • Masterdata Ship-to/Sold-to Sales view if Sales Order
  • DynaSys table EXP_SHIPTO_DC_SR_MANUAL
FreeFreeFreeRowFreeFree
C_SHTCTRY__C_GZONEGeo ZoneNo description availableFreeFreeFreeFreeFreeFree
C_DYN_005__C_TACTIC2Tactical MaterialDescription are available since 08/12/2016FreeFreeFreeFreeFreeFree
C_DYN_017__C_ZIPARTCSO

Customer Service Officer (CSO)

or CSR Contact

Only filled for RCS

FreeFreeFreeFreeFreeFree
C_CUSTOMR__0REGIONShip-to Region FreeFreeFreeFreeFreeFree
C_CUSTOMR__0CITYShip-to City

Since 30/10/2017, for DynaSys info it comes from C_DYN_024 to get city for both SAP Ship-to and Sales Force Prospects

FreeFreeFreeFreeFreeFree
C_DYN_018__C_MPPLANTMain Shipping Plant FreeFreeFreeFreeFreeFree
C_MATNR2__C_MAT_GRPMaterial Group FreeFreeFreeFreeFreeFree
C_MATNR2__C_MATGR2Packaging Type

Previous name : Material Group 2 (Release March 2017)

For Solvay PF1 only

FreeFreeFreeFreeFreeFree
C_MATNR2__C_DIVISNDivision FreeFreeFreeFreeFreeFree
C_DYN_010BU FreeFreeFreeFreeFreeFree
C_DYN_018__C_MSHCONDMain Shipping Cond.

Available since 07/02/2017

Shipping Condition of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)

FreeFreeFreeFreeFreeFree
C_MATNR2__C_MAGRVPackaging Materials

Only for RCS

Available since 14/03/2017

FreeFreeFreeFreeFreeFree
C_DYN_018__C_VEPARTAccount Manager

PF1 notion

Release April 2017

FreeFreeFreeFreeFreeFree
C_DYN_018__C_VWPARTCCS Rep

PF1 notion

Release April 2017

FreeFreeFreeFreeFreeFree

C_DYN_019__C_DYN_020

C_DYN_021__C_DYN_020

Planning Zone

DYN Only

Changed to C_DYN_021 27/11/2018

FreeFreeFreeFreeFree
C_GBR14__C_GBR1GBR End-Use (Application)

Previous to 30/10/2017, field was C_GBR5__C_GBR1

FreeFreeFreeFreeFreeFree
C_GBR14__C_GBR2GBR End-Use (Market)
Previous to 30/10/2017, field was C_GBR5__C_GBR2FreeFreeFreeFreeFreeFree
C_GBR14__C_GBR3GBR End-Use (Segment)
Previous to 30/10/2017, field was C_GBR5__C_GBR3FreeFreeFreeFreeFreeFree
C_GBR14__C_GBR4GBR Corporate End-Use
Previous to 30/10/2017, field was C_GBR5__C_GBR4FreeFreeFreeFreeFreeFree
C_DYN_021__C_DYN_022ABC Class (auto)DYN OnlyFreeFreeFreeFreeFreeFree
C_DYN_021__C_DYN_023ABC Class (manual)DYN OnlyFreeFreeFreeFreeFreeFree
C_GBUZONE__C_ZONEH1GBU Zone (hier. 1)

Key and Text => Dyn Only

02.2019 Added on Segmentation

FreeRowFreeFreeFreeFree
C_GBUZONE__C_ZONEH2GBU zone (hier. 2)

Key and Text =>Dyn Only

02.2019 Added on Segmentation

FreeRowFreeFreeFreeFree
0G_CWWE01IECRAAPO + DYN WP1FreeFreeFreeFreeFreeFree
C_GBR18__C_GBR19GBR GBU Mat Group

Key and Text



The notion of GBU material group exists only for WP1.
Available since since 30/10/2017

02.2019 Added on Segmentation

FreeRowFreeFreeFreeFree
C_GBR13__C_GBR9GBR: Customer Sub Group

Key and Text

Available since since 30/10/2017

02.2019 Added on Segmentation

FreeRowFreeFree
Free
C_GBR13__C_GBR6GBR GBU group (Ship-to)

Key + Text

Available since since 30/10/2017, for Dyn/Log , it replaces 'Enterprise Customer Group'

02.2019 Added on Segmentation

FreeRowFreeFreeFreeFree
C_GBR15__C_SHIPKAGBR Ship-to KA

Key and Text

Available since since 30/10/2017

FreeFreeFreeFreeFreeFree
C_SHTCTRY__C_ZONEShip-to BFC Geographie/Zone

Key and Text

Available since since 30/10/2017

FreeFreeFreeFreeFreeFree
C_DYN_024__C_PROSPFlag Prospect

Key and Text

Available since since 30/10/2017

 

'X' Prospect

 

' ' Ship-to

02.2019 Added on FA

FreeFreeFreeFreeFree
0INFOPROVInfoProvider

Key and Text

Available since 30/10/2017

FreeFreeFreeFree

C_GBR18__C_GBR20GBU Material Sub-grp

Key and Text

Available since 28/11/2017

02.2019 Added on Segmentation

FreeRowFreeFreeFree
C_DYN_018__PRDFACT

Main Prod Plant

Available since 31/05/2018

Attribut maintained only in DynaSys for RCS Material/Shipto

02.2019 Added on Segmentation

06.2019 => description change to "Main Production Plant" (Ex : Default Factory Plant)

FreeFreeFreeFreeFree
C_MATNR2__C_LPRODProduct Line 00
FreeFreeFreeFreeFree
C_MATNR2__C_LIP04Product Line 04
FreeFreeFreeFreeFree
C_MATNR2__C_LIP05Product Line 05

Key and Text

Available since 28/11/2017

02.2019 Added on Segmentation

FreeRowFreeFree

C_MATNR2__C_FMPRDProduct Family Code

FreeFreeFreeFreeFree
C_SOTCTRYSold-to Country
FreeFreeFreeFreeFree
C_SOTCTRY__C_ZONESold-to BFC Geographie/Zone
FreeFreeFreeFreeFree
C_DYN_005__C_GRPPGMIProduct Group (PGMI)

Available only for TS (filter on PGMI IC*)

FreeFreeFreeFreeFreeFree
C_DYN_018__C_INCOTRMIncoterms (Solvay)

Key
Available since 18/10/2018

FreeFreeFreeFreeFreeFree
C_DYN_018__C_INCOTM2Incoterms 2 (Solvay)

Key 
Available since 18/10/2018

FreeFreeFreeFreeFree
C_DYN_017__C_INCOTRMIncoterms (RCS)Key 
Available since 18/10/2018		FreeFreeFreeFreeFree
C_DYN_017__C_INCOTM2Incoterms 2 (RCS)Key 
Available since 18/10/2018		FreeFreeFreeFreeFree
 C_GBR23__SGINFO4 GBR Segment Info 4

Available 13/12/2018

RCS only (depending on IECRA)

02.2019 Added on FA/Segmentation

FreeFreeFreeFree

 C_GBR23__SGINFO5 GBR Segment Info 5 Available 13/12/2018

RCS only (depending on IECRA)

02.2019 Added on FA/Segmentation

FreeFreeFreeFree

C_DYN_017__C_SALEMPSales Employee

Key + Texts

02.2019 Added on DR/FA/Segmentation

FreeRowFreeFree

C_DYN_017__C_FLGDISTDistributor Flag

Texts

02.2019 Added on DR/BR/FA/Segmentation

but empty (flow will be implemented later)

FreeFreeFreeFree

C_MATNR2__C_LIP02Product Line 02

Texts

02.2019 Added on DR/BR/FA/Segmentation

FreeFreeFreeFreeFree
C_GBR15_C_SHIPK2GBR Ship-to KA Adjusted      

Key

02.2019 Added on DR/BR/FA/Segmentation

For Novecare. If Commercial Product = "GRCL000098", Ship-to is taken

FreeFreeFreeFree

0CALQUARTERCal. Year/Quarter

Key

02.2019 Added on DR/FA

FreeFreeFreeFree

0CALMONTH2Calendar Month

Key

02.2019 Added on DR/FA

FreeFreeFreeFree

0CALYEARCalendar Year

Key

02.2019 Added on DR/FA

FreeFreeFreeFree

0CALQUART1Quarter

Key

02.2019 Added on DR/FA

FreeFreeFreeFree

0LOC_CURRCYLocal Currency

Key

02.2019 Added on DR

FreeFreen/aFreeFree
0CURRENCYCurrency

Key

02.2019 Added on DR

FreeFreen/aFreeRow
0UNITUnit of Measure

Key

02.2019 Added on DR/FA

FreeFreeFreeFree

C_PRODPLAManufacturing PlantAvailable since 15/02/2018 for FA

Free


C_SAL_OFFSales OfficeAvailable since 15/05/2018 for FA

Free


C_SHIPTOCustomer number



Row

C_MATNR2__C_AMTS001Reason for material production



Row

C_MATNR2__C_MSTAVX-DChain status



Row

C_GBUZONEGBU zone



Free

C_PLANTPlant



Free

C_CUSTOMR__0COUNTRYCust: Country




Free
C_DYN_018__C_COMPCDECompany code




FreeFree
C_DOCTYP2Order document type

DYN for Source DynaSys

APO for Source APO





Free
C_MATNR2__C_LIP03Product line 03




Free
C_DYN_018__C_DYN_016

Key Account

(Ship-to KA) (APO)

RCS notion

Text in MD C_GRCUST

Available since 14/03/2017

Since 30/10/2017, For DynaSys/Logility, use Ship-to KA (GBR) (C_GBR15__C_SHIPKA)

=> to be removed quickly in last QV query (QV is not using it anymore)






Free
C_TGBRC2__C_ENTSEG3GBR Enterprise SegmentAvailable since 25/06/2019FreeFreeFreeFree

CPFCTR2_2BFC Group of activities

BFC BU

Available since xx/07/2019

From IECRA for WP1; from Material Plant for PF1 (C_DYN_018)

Technical object is C_DYN_018__CPFCTR2_2 but taken form CPFCTR2_2 stored in cube

FreeFreeFreeFree

C_MAGNITUBFC Activity 1

Available since xx/07/2019

From IECRA for WP1; from Material Plant for PF1 (C_DYN_018)

Technical object is 0G_CWWE01__C_MAGNITU but taken form C_MAGNITU stored in cube

FreeFreeFreeFreeFreeFree










Old axis

C_CUSTGP2Enterprise Customer Group (APO)

Key + Text

Since 30/11/2017, only for APO (new axis for Dyn). Old description 'Enterprise Customer Group'


C_DYN_018__C_INCOTRMIncoterms

Available since 07/02/2017

Incoterms of the last M3 sales order not rejected

(No reason for Rejection , Item Category M3N, most recent change on date)


C_MATNR2__C_LPRODLIP00Since Solstice
C_MATNR2__C_LIP04LIP04Since Solstice
C_MATNR2__C_FMPRDProduct Group (family)Since Solstice
C_PGMI__C_GRPPGMIItem ClassSince Solstice