Customer > Customer Service - Activity

General Description
This page displays the number of order and order lines created per month and split by type: Standard, Free, Samples, Return order lines. KPI: Number of Orders Number of Order lines Average number of Order Lines per Order

Target Users

Supply Chain Managers
Supply Chain Operational
Supply Chain Excellence
Logistics
Customer Service
Account Managers

Authorization & Rights

All the accesses must be validated by:

Supply Chain Excellence

Click here for the Access form to get access to the Global Supply Chain Dashboard.

Calculation:


KPI Name	Calculation
#Order Lines
#Orders
Average # of lines by orders
Standard Order Lines
Free Order Lines	BI4: Total Billing w/o taxes = 0 or empty Order document type = FG/ZAGR (#Samples Order Lines Excluded). BW: Item Category = 'ZKMS','ZR4N','ZTAS' (#Samples Order Lines Excluded).
Samples Order Lines	BI4: Order type = TA PO type <> DFUE/WEBS and SMART samples + Order type KL/ZKL BW: Item Category = 'KLN','KNN','ZSAM'
Return Order Lines

Technical Documentation

Source:

BW OBAS- QV_BW_QRY_MVSDSO45_SD0005

BI4:

NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001

NB SBS Monthly Dashboard CS Return orders CSWWPPS R001

Update:

Daily

Query filters applied:

Source Information:

Filters

BI4 Query (WP1 Data):

NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001

LEGAL COMPANIES <>ZFR9/7378

DISTRIBUTION CHANNEL <> 8I

SHIP TO KA <> GRCL200022/9999999999/GRCL000098

ORDER FLOW CODE = R

DOC TYPE = FG/KB/KBB/KE/KEB/LP/ORB/RCM/TA/TAM/ZAGR/VEF/VEFR/ZEXP/ZOR/ZKEB/ZKBB/ZORB/LZM/RCS/ZKL/KL

ORDER REJETION:
CODE = 98 OR
EMPTY OR
ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)

BW Query (PF1 Data):

QV_BW_QRY_MVSDSO45_SD0005

[0SOLD_TO__0CUST_CLASS] CUSTOMER CLASSIFIC <> [G] GROUP COMPANY

Doc Type:
KBN, KEN, KLN, KNN, TAS, TDN, TDXR, Z104, Z105, Z107, Z108, Z109, Z1E3, Z1IR, Z1IX, Z1Q5, Z1Q6, Z1QP, Z1RD, ZDMN, ZDMS, ZDON, ZEXP, ZIND, ZIRS, ZITI, ZKLE, ZKMN, ZKMS, ZKNE, ZORB, ZOUT, ZR4N, ZRAG, ZRCM, ZRCS, ZRDC, ZRGI, ZRIN, ZRP1, ZRP2, ZRP3, ZRPE, ZRVO, ZSAM, ZT1E, ZT1N, ZTAS, ZTDE, ZTDL, ZTDM, ZTDN, ZTDR, ZTES, ZVEX, ZVEY, ZVF1, ZVXI.

Dimensions:

Global Overview of Dimensions

			BW	BI4
Global Filters	Period	Month Year	Order Line Creation Month	Order document date YYYY/MM
	Organization	GBU	[0G_CWWE01__CPFCTR1_2] GBU	Sector zone name
		Group of Activity	[0G_CWWE01__CPFCTR2_2] Group of Activities	FC BU Name
		Sub-Activity	N/A	BFC Market
		Company	[C_COMPCDE] Company	Legal Company
	Plant	Zone	[C_GZONE] Geographie/Zone	Plant geographical zone
		Country	[0COUNTRY] Country key	Plant country
		Plant	[0PLANT] Plant	Plant name
	Ship Destination	Zone	[C_GZONE] Geographie/Zone	Ship to geo Zone name
		Country	[C_SHIPTID__0COUNTRY] Ship-to country	Ship to country name
		Corporate Group	[C_CORPGR] CRM Customer Corp. Group (PRS)	Ship to group name
		Ship Destination	[C_SHIPTID] Ship-to	Ship to name
	Product	Product Hierarchy	[C_PRODHIE] Product Hierarchy	N/A
		Product	[C_MATNR2] Material\Attributes\[C_PROD] Commercial Product / Material Group	Product Name
		Bulk/Packed	[C_MATNR2] Material\Attributes\[C_BULKPAC] Transportation Group	Mapping based on: Material Packaging Group Name Bulk = Packed in Bulk else = Packed
		Packaging Type	[C_MATNR2] Material\Attributes\[C_PACKAG] Packaging type	Material Packaging Group Name
Specific Filters		Sales Office	Qv Mapping based on Sales Office	QV Mapping based on Sales Office
		Sales Office Country	QV Mapping based on Sales Office	QV Mapping based on Sales Office
		Sales Office	[C_SAL_OFF] Sales Office	Sales office name
		CSR	[C_CUSTSAL__C_ZIPART] CSR (Sold-to)	Order partner ZI actualized name

Dashboard

BW & BI4 Key Figures

SAP

CSR (Customer Service Representative)

- the person in responsible to create and manage the Sales Order

BI4 (WP1):
ZI Partner

BW (PF1)
[_CUSTSAL__C_ZIPART]
ZI Partner sold to

Customer masterdata (Sales area data)

WP1: Partner functions → ZI
PF1: Partner functions → VW

Page tree

Customer > Customer Service - Activity

Marie-Ange Carrier

Miriam Luttrin

KPI:

Supply Chain Managers

Supply Chain Operational

Supply Chain Excellence

Logistics

Customer Service

Account Managers

All the accesses must be validated by:

Calculation:

KPI Name

Calculation

#Order Lines

#Orders

Average # of lines by orders

Standard Order Lines

Free Order Lines

BI4:Total Billing w/o taxes = 0 or emptyOrder document type = FG/ZAGR (#Samples Order Lines Excluded).

BW:Item Category = 'ZKMS','ZR4N','ZTAS' (#Samples Order Lines Excluded).

Samples Order Lines

BI4:Order type = TAPO type <> DFUE/WEBS and SMART samples + Order type KL/ZKL

BW:Item Category = 'KLN','KNN','ZSAM'

Return Order Lines

Source:

Update:

Query filters applied:

Source Information:

Filters

BI4 Query (WP1 Data):

NB SBS Monthly Dashboard CS Indicators Direct and Cancel orders CSWWPPS R001

LEGAL COMPANIES <>ZFR9/7378

DISTRIBUTION CHANNEL <> 8I

SHIP TO KA <> GRCL200022/9999999999/GRCL000098

ORDER FLOW CODE = R

DOC TYPE = FG/KB/KBB/KE/KEB/LP/ORB/RCM/TA/TAM/ZAGR/VEF/VEFR/ZEXP/ZOR/ZKEB/ZKBB/ZORB/LZM/RCS/ZKL/KL

ORDER REJETION: CODE = 98 OR EMPTY OR ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)

BW Query (PF1 Data):

QV_BW_QRY_MVSDSO45_SD0005

[0SOLD_TO__0CUST_CLASS] CUSTOMER CLASSIFIC <> [G] GROUP COMPANY

Dimensions:

BI4 (WP1):ZI Partner

BW (PF1)[_CUSTSAL__C_ZIPART]ZI Partner sold to

Customer masterdata (Sales area data)

WP1: Partner functions → ZI

PF1: Partner functions → VW

BI4:
Total Billing w/o taxes = 0 or empty
Order document type = FG/ZAGR (#Samples Order Lines Excluded).

BW:
Item Category = 'ZKMS','ZR4N','ZTAS' (#Samples Order Lines Excluded).

BI4:
Order type = TA
PO type <> DFUE/WEBS and SMART samples + Order type KL/ZKL

BW:
Item Category = 'KLN','KNN','ZSAM'

ORDER REJETION:
CODE = 98 OR
EMPTY OR
ORDER LINE CANCELLED IN SAP NOT CONSIDERED (ORDER LINE ITEM CATEGORY CODE = ZZZZ)

BI4 (WP1):
ZI Partner

BW (PF1)
[_CUSTSAL__C_ZIPART]
ZI Partner sold to