Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.






Image Removed

Info
titleSupply Chain Excellence
Roberta Navone
Info
iconfalse
titleIS Reporting Coordinator
Diogo Paiva
Info
iconfalse
titleD&PS Expert
EMEA: Emma Glasson
NAM/LAM: Karina Tsuji
APAC: Lilian Cheong
Info
iconfalse
titleAuthorization & 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

General Description

This indicator explores the e-invoicing which refers to invoices sent via email or EDI.
KPI:
% E-Invoicing
#Invoices
#E-Invoices
#Manual Invoices
Scope:
  • Exclusion of material types
    servicesa
    services and packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
  • Exclusion of SOLD entities (consolidation method = SOLD)
  • Intra GBU flag = N
  • See this link to see the full default scope of the Customer Service KPIs by Sales Doc Types: Global Sales Order Doc Types
    • Scope for eInvoicing Ratio: Sales Doc. Type Group = Standard
      Orde
      Order and, Consignment. See column "F" in file Global Sales Order Doc Types.
  • Billing type = F2/F4/T1/F2B/FAR/ZFSS
Info
iconfalse
titleTarget Users
  • Supply Chain Managers
  • Supply Chain Operational
  • Supply Chain Excellence
  • Logistics
  • Customer Service
  • Account Managers
    • Rules to consider e-invoicing in SAP: If source field Message type(KSCHL) = 'ZINV', 'ZREI','ZRDE','ZRDC'  OR Trans Medium (NACHA) = 6 , 1, 2  Then Invoicing will be flagged as 'X' and the column e-invoiced  will be filled.




Calculation:


KPI Name
Calculation
% E-Invoicing
e ---E-Invoicing Orders
---------------------------------- x100
Total Orders
#Invoices
# Billing Document Number
#E-Invoices
# Billing Document Number where e-Invoicing Flag = "X" (Email or EDI)
#Manual Invoices
# Invoices - # E-Invoices
Technical Documentation
Source:
Core: BW_QRY_MVSDSO57_0003
QV: QVBW_QRY_MVSDSO57_0003
Update:
 Daily
Query filters applied:
Filters
Image Modified Exclusion of material types: Services & Packaging (i.e. units in KWH): PF1/Z703  WP1/ZDIE WP1/ZVER WP1/ZUNB
Image Modified Exclusion of SOLD entities (consolidation method = SOLD)
Dimensions:
Global Overview of Dimensions


BW
Global Filters
Period
Month Year
Order Line Creation Month
Organization
GBU
[CPFCTR1_2] GBU
Group of Activity
[0G_CWWE01__CPFCTR2_2] Group of Activities
Sub-Activity
[0G_CWWE01__C_MAGNITU] BFC Market
Company
[C_COMPCDE] Company
Plant
Zone
[C_PLANT] Plant\Attributes\[C_GZONE] Geographie/Zone
Country
[C_PLANT] Plant\Attributes\[0COUNTRY] Country key
Plant
[CPLANT] Plant
Ship Destination
Zone
[C_SHIPTID] Ship-to\Attributes\[C_GZONE] Geographie/Zone
Country
[C_SHIPTID] Ship-to\Attributes\[0COUNTRY] Country key
Corporate Group
[C_SHIPTID] Ship-to\Attributes\[C_CORPGR] CRM Customer Corp. Group (PRS)
Ship Destination
[C_SHIPTID] Ship-to
Product
Product Hierarchy
[C_MATNR2__C_PRDHIER] Product Hier (LIP03)
Product
[C_MATNR2__C_PROD] Commercial Product / Material Group
Bulk/Packed
[C_MATNR2] Material\Attributes\[C_BULKPAC] Transportation Group
Packaging Type
[C_MATNR2] Material\Attributes\[C_PACKAG] Packaging type
Specific Filters

Sales Doc Type Group
Sales Doc Type
[C_DOCTYP2] Order document type
Sales Office
[C_SAL_OFF] Sales Office
CSR
[C_CUSTSAL__C_ZIPART] CSR (Sold-to)
DashboardBW & BI4 Key FiguresSAP
CSR (Customer Service Representative)- the person in responsible to c reate and manage the Sales Order
BW
[_CUSTSAL__C_ZIPART]
ZI Partner sold to  
Customer masterdata (Sales area data)
  •  WP1: Partner functions → ZIImage Modified
  • PF1: Partner functions → VWImage Modified