You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »


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


Technical Name

Application


Info-provider


Usage type


Expected users


Workbook/Query General Description

General parameters

Global properties

TabScreenshotComment
Display 
Rows/Columns 
Value Display 
Planning 
Extended 

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

Variable Sequence

Filters

ObjectFilter ValueExplanation

Key figures

Key Figure 1

Description

Calculation rule detail

Text Replacement Variable

Currency Conversion

Exchange Rate Type : 

Currency : 

Time Reference : 

Unit Conversion

Unit : 

Characteristics


Info-object NameInfo-object TextExplanation (if needed)

Demand

Review

Budget

Review

Forecast

Accuracy

Segmentation

QV

DR

QV

FA

0CALMONTHCalendar Year/MonthTextColumnRowColumnFree

0LOGSYSSource SystemNo display to avoid the display of the prefix for compound characteristics.RowRowRowRow

C_MATNR2Material

Key + Text

RowRowRowRow

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'

RowRowRow


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

C_DYN_024DYN Ship-to (incl.Prosp)

Available for DynaSys since 30/10/2017

02.2019 Added on FA

FreeFreeFreeFree

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

FreeFreeFreeFree

C_MATNR2__0PROD_HIERProd. HierarchyKey + TextFreeFreeFreeFree

C_MATNR2__C_PRODCommercial Product / Material Group

Key + Text

Commercial Product for RCS WP1.

Material Group for SOLVAY PF1.

FreeRowFree


C_SHTCTRYShip-to CountryTextFreeRowFree


C_SOLDIDSold-to

Key + Text

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

FreeFreeFreeFree

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.

FreeFreeFreeFree

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
FreeFreeFreeRow

C_SHTCTRY__C_GZONEGeo ZoneNo description availableFreeFreeFreeFree

C_DYN_005__C_TACTIC2Tactical MaterialDescription are available since 08/12/2016FreeFreeFreeFree

C_DYN_017__C_ZIPARTCSO

Customer Service Officer (CSO)

Only filled for RCS

FreeFreeFreeFree

C_CUSTOMR__0REGIONShip-to Region FreeFreeFreeFree

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

FreeFreeFreeFree

C_DYN_018__C_MPPLANTMain Shipping Plant FreeFreeFreeFree

C_MATNR2__C_MAT_GRPMaterial Group FreeFreeFreeFree

C_MATNR2__C_MATGR2Packaging Type

Previous name : Material Group 2 (Release March 2017)

For Solvay PF1 only

FreeFreeFreeFree

C_MATNR2__C_DIVISNDivision FreeFreeFreeFree

C_DYN_010BU FreeFreeFreeFree

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)

FreeFreeFreeFree

C_MATNR2__C_MAGRVPackaging Materials

Only for RCS

Available since 14/03/2017

FreeFreeFreeFree

C_DYN_018__C_VEPARTAccount Manager

PF1 notion

Release April 2017

FreeFreeFreeFree

C_DYN_018__C_VWPARTCCS Rep

PF1 notion

Release April 2017

FreeFreeFreeFree

C_DYN_019__C_DYN_020

C_DYN_021__C_DYN_020

Planning Zone

DYN Only

Changed to C_DYN_021 27/11/2018

FreeFreeFreeFree

C_GBR14__C_GBR1GBR End-Use (Application)

Previous to 30/10/2017, field was C_GBR5__C_GBR1

FreeFreeFreeFree

C_GBR14__C_GBR2GBR End-Use (Market)
Previous to 30/10/2017, field was C_GBR5__C_GBR2FreeFreeFreeFree

C_GBR14__C_GBR3GBR End-Use (Segment)
Previous to 30/10/2017, field was C_GBR5__C_GBR3FreeFreeFreeFree

C_GBR14__C_GBR4GBR Corporate End-Use
Previous to 30/10/2017, field was C_GBR5__C_GBR4FreeFreeFreeFree

C_DYN_021__C_DYN_022ABC Class (auto)DYN OnlyFreeFreeFreeFree

C_DYN_021__C_DYN_023ABC Class (manual)DYN OnlyFreeFreeFreeFree

C_GBUZONE__C_ZONEH1GBU Zone (hier. 1)

Key and Text => Dyn Only

FreeRowFree


C_GBUZONE__C_ZONEH2GBU zone (hier. 2)

Key and Text =>Dyn Only

FreeRowFree


0G_CWWE01IECRAAPO OnlyFreeFreeFreeFree

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

FreeRowFree


C_GBR13__C_GBR9GBR: Customer Sub Group

Key and Text

Available since since 30/10/2017

FreeRowFree


C_GBR13__C_GBR6GBR GBU group (Ship-to)

Key + Text

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

FreeRowFree


C_GBR15__C_SHIPKAGBR Ship-to KA

Key and Text

Available since since 30/10/2017

FreeFreeFreeFree

C_SHTCTRY__C_ZONEShip-to BFC Geographie/Zone

Key and Text

Available since since 30/10/2017

FreeFreeFreeFree

C_DYN_024__C_PROSPFlag Prospect

Key and Text

Available since since 30/10/2017

 

'X' Prospect

 

' ' Ship-to

02.2019 Added on FA

FreeFreeFreeFree

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

FreeRowFree


C_DYN_018__PRDFACTDefault Prod Factory

Available since 31/05/2018

Attribut maintained only in DynaSys for RCS Material/Shipto

FreeFreeFree


C_MATNR2__C_LPRODProduct Line 00
FreeFreeFreeFree

C_MATNR2__C_LIP04Product Line 04
FreeFreeFreeFree

C_MATNR2__C_LIP05Product Line 05

Key and Text

Available since 28/11/2017

FreeRowFree


C_MATNR2__C_FMPRDProduct Family Code

FreeFreeFreeFree

C_SOTCTRYSold-to Country
FreeFreeFreeFree

C_SOTCTRY__C_ZONESold-to BFC Geographie/Zone
FreeFreeFreeFree

C_DYN_005__C_GRPPGMIProduct Group (PGMI)

Available only for TS (filter on PGMI IC*)

FreeFreeFreeFree

C_DYN_018__C_INCOTRMIncoterms (Solvay)

Key
Available since 18/10/2018

FreeFreeFreeFree

C_DYN_018__C_INCOTM2Incoterms 2 (Solvay)

Key 
Available since 18/10/2018

FreeFreeFreeFree

C_DYN_017__C_INCOTRMIncoterms (RCS)Key 
Available since 18/10/2018		FreeFreeFreeFree

C_DYN_017__C_INCOTM2Incoterms 2 (RCS)Key 
Available since 18/10/2018		FreeFreeFreeFree

 C_GBR23__SGINFO4 GBR Segment Info 4

Available 13/12/2018

RCS only (depending on IECRA)

02.2019 Added on FA

FreeFreeFree


 C_GBR23__SGINFO5 GBR Segment Info 5 Available 13/12/2018

RCS only (depending on IECRA)

02.2019 Added on FA

FreeFreeFree


0G_CWWE01__C_MAGNITUBFC Activity 1KeyFreeFreeFreeFree

C_DYN_017__C_SALEMPSales Employee

Key + Texts

02.2019 Added on DR/FA

FreeRowFree


C_DYN_017__C_FLGDISTDistributor Flag

Texts

02.2019 Added on DR/BR/FA

but empty (flow will be implemented later)

FreeFreeFree


C_MATNR2__C_LIP02Product Line 02

Texts

02.2019 Added on DR/BR/FA

FreeFreeFree


C_GBR15_C_SHIPK2GBR Ship-to KA Adjusted      

Key

02.2019 Added on DR/BR/FA

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

FreeFreeFree


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/aFree

0CURRENCYCurrency

Key

02.2019 Added on DR

FreeFreen/aFree

0UNITUnit of Measure

Key

02.2019 Added on DR/FA

FreeFreeFreeFree

C_PRODPLAManufacturing PlantAvailable since 15/02/2018 for FA

FreeFree

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


Old axis

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)

Removed soon. Use now the GBR one


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
  • No labels