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

Compare with Current View Page History

« Previous Version 6 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)DR
0CALMONTHCalendar Year/MonthTextColumnRow
0LOGSYSSource SystemNo display to avoid the display of the prefix for compound characteristics.RowRow
C_MATNR2Material

Key + Text

RowRow
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'

RowRow
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

RowRow
C_DYN_024DYN Ship-to (incl.Prosp)

Available for DynaSys since 30/10/2017

FreeFree
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

FreeFree
C_MATNR2__0PROD_HIERProd. HierarchyKey + TextFreeFree
C_MATNR2__C_PRODCommercial Product / Material Group

Key + Text

Commercial Product for RCS WP1.

Material Group for SOLVAY PF1.

FreeRow
C_SHTCTRYShip-to CountryTextFreeRow
C_SOLDIDSold-to

Key + Text

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

FreeFree
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.

FreeFree
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
FreeFree
C_SHTCTRY__C_GZONEGeo ZoneNo description availableFreeFree
C_DYN_005__C_TACTIC2Tactical MaterialDescription are available since 08/12/2016FreeFree
C_DYN_017__C_ZIPARTCSO

Customer Service Officer (CSO)

Only filled for RCS

FreeFree
C_CUSTOMR__0REGIONShip-to Region FreeFree
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

FreeFree
C_DYN_018__C_MPPLANTMain Shipping Plant FreeFree
C_MATNR2__C_MAT_GRPMaterial Group FreeFree
C_MATNR2__C_MATGR2Packaging Type

Previous name : Material Group 2 (Release March 2017)

For Solvay PF1 only

FreeFree
C_MATNR2__C_DIVISNDivision FreeFree
C_DYN_010BU FreeFree
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)

FreeFree
C_MATNR2__C_MAGRVPackaging Materials

Only for RCS

Available since 14/03/2017

FreeFree
C_DYN_018__C_VEPARTAccount Manager

PF1 notion

Release April 2017

FreeFree
C_DYN_018__C_VWPARTCCS Rep

PF1 notion

Release April 2017

FreeFree

C_DYN_019__C_DYN_020

C_DYN_021__C_DYN_020

Planning Zone

DYN Only

Changed to C_DYN_021 27/11/2018

FreeFree
C_GBR14__C_GBR1GBR End-Use (Application)

Previous to 30/10/2017, field was C_GBR5__C_GBR1

FreeFree
C_GBR14__C_GBR2GBR End-Use (Market)
Previous to 30/10/2017, field was C_GBR5__C_GBR2FreeFree
C_GBR14__C_GBR3GBR End-Use (Segment)
Previous to 30/10/2017, field was C_GBR5__C_GBR3FreeFree
C_GBR14__C_GBR4GBR Corporate End-Use
Previous to 30/10/2017, field was C_GBR5__C_GBR4FreeFree
C_DYN_021__C_DYN_022ABC Class (auto)DYN OnlyFreeFree
C_DYN_021__C_DYN_023ABC Class (manual)DYN OnlyFreeFree
C_GBUZONE__C_ZONEH1GBU Zone (hier. 1)

Key and Text => Dyn Only

FreeRow
C_GBUZONE__C_ZONEH2GBU zone (hier. 2)

Key and Text =>Dyn Only

FreeRow
0G_CWWE01IECRAAPO OnlyFreeFree
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

FreeRow
C_GBR13__C_GBR9GBR: Customer Sub Group

Key and Text

Available since since 30/10/2017

FreeRow
C_GBR13__C_GBR6GBR GBU group (Ship-to)

Key + Text

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

FreeRow
C_GBR15__C_SHIPKAGBR Ship-to KA

Key and Text

Available since since 30/10/2017

FreeFree
C_SHTCTRY__C_ZONEShip-to BFC Geographie/Zone

Key and Text

Available since since 30/10/2017

FreeFree
C_DYN_024__C_PROSPFlag Prospect

Key and Text

Available since since 30/10/2017

 

'X' Prospect

 

' ' Ship-to

FreeFree
0INFOPROVInfoProvider

Key and Text

Available since 30/10/2017

FreeFree
C_GBR18__C_GBR20GBU Material Sub-grp

Key and Text

Available since 28/11/2017

FreeRow
C_DYN_018__PRDFACTDefault Prod Factory

Available since 31/05/2018

Attribut maintained only in DynaSys for RCS Material/Shipto

FreeFree
C_MATNR2__C_LPRODProduct Line 00
FreeFree
C_MATNR2__C_LIP04Product Line 04
FreeFree
C_MATNR2__C_LIP05Product Line 05

Key and Text

Available since 28/11/2017

FreeRow
C_MATNR2__C_FMPRDProduct Family Code

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

Available only for TS (filter on PGMI IC*)

FreeFree
C_DYN_018__C_INCOTRMIncoterms (Solvay)

Key
Available since 18/10/2018

FreeFree
C_DYN_018__C_INCOTM2Incoterms 2 (Solvay)

Key 
Available since 18/10/2018

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

Available 13/12/2018

RCS only (depending on IECRA)

FreeFree
 C_GBR23__SGINFO5 GBR Segment Info 5 Available 13/12/2018

RCS only (depending on IECRA)

FreeFree
0G_CWWE01__C_MAGNITUBFC Activity 1KeyFreeFree
C_DYN_017__C_SALEMPSales Employeewill be added soonFreeRow
C_DYN_017__C_FLGDISTDistributor flag (Yes/No)will be added soon but empty (flow will be implemented later)Free
C_MATNR2__C_LIP02Product Line 02will be added soonFree
C_GBR15_C_SHIPK2GBR Ship-to KA adjusted      

will be added soon

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

Free
0CALQUARTERCal. Year/Quarter

Free
0CALMONTH20CALMONTH2Calendar month

Free
0CALYEARCalendar Year

Free
0CALQUART1Quarter

Free
0LOC_CURRCYLocal currency

Free
0CURRENCYCurrency

Free
0UNITUnit of measure

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