sap business objects supply chain performance management
TRANSCRIPT
Extractor Mapping Guide
SAP Business ObjectsSupply Chain PerformanceManagement
Release 1.0
Document Version 1.00 – November, 2009
2
© Copyright 2009 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any formor for any purpose without the express permission of SAP AG. Theinformation contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors containproprietary software components of other software vendors.
Microsoft, Windows, Excel, Outlook, and PowerPoint are registeredtrademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p,System p5, System x, System z, System z10, System z9, z10, z9, iSeries,pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390,OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, PowerArchitecture, POWER6+, POWER6, POWER5+, POWER5, POWER,OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS,HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, ParallelSysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity,Tivoli and Informix are trademarks or registered trademarks of IBMCorporation.
Linux is the registered trademark of Linus Torvalds in the U.S. and othercountries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are eithertrademarks or registered trademarks of Adobe Systems Incorporated inthe United States and/or other countries.
Oracle is a registered trademark of Oracle Corporation.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the OpenGroup.Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame,VideoFrame, and MultiWin are trademarks or registered trademarks ofCitrix Systems, Inc.
HTML, XML, XHTML and W3C are trademarks or registeredtrademarks of W3C®, World Wide Web Consortium, MassachusettsInstitute of Technology.
Java is a registered trademark of SunMicrosystems, Inc
JavaScript is a registered trademark of Sun Microsystems, Inc., usedunder license for technology invented and implemented by Netscape.
SAP, R/3, xApps, xApp, SAP NetWeaver, Duet,PartnerEdge, ByDesign, SAP Business ByDesign, andother SAP products and services mentioned herein as wellas their respective logos are trademarks or registeredtrademarks of SAP AG in Germany and in several othercountries all over the world. All other product and servicenames mentioned are the trademarks of their respectivecompanies. Data contained in this document servesinformational purposes only. National productspecifications may vary.
These materials are subject to change without notice. Thesematerials are provided by SAP AG and its affiliatedcompanies ("SAP Group") for informational purposes only,without representation or warranty of any kind, and SAPGroup shall not be liable for errors or omissions withrespect to the materials. The only warranties for SAPGroup products and services are those that are set forth inthe express warranty statements accompanying suchproducts and services, if any. Nothing herein should beconstrued as constituting an additional warranty.
DisclaimerSome components of this product are based on Java™. Anycode change in these components may cause unpredictableand severe malfunctions and is therefore expressivelyprohibited, as is any decompilation of these components.
Any Java™ Source Code delivered with this product isonly to be used by SAP’s Support Services and may not bemodified or altered in any way.
Documentation in the SAP Service MarketplaceYou can find this documentation at the following Internetaddress:service.sap.com/instguidesscpm
3
Typographic ConventionsType Style Represents
Example Text Words or characters thatappear on the screen. Theseinclude field names, screentitles, pushbuttons as well asmenu names, paths andoptions.Cross-references to otherdocumentation
Example text Emphasized words or phrasesin body text, titles of graphicsand tables
EXAMPLE TEXT Names of elements in thesystem. These include reportnames, program names,transaction codes, tablenames, and individual keywords of a programminglanguage, when surrounded bybody text, for example,SELECT and INCLUDE.
Example text Screen output. This includesfile and directory names andtheir paths, messages, namesof variables and parameters,source code as well as namesof installation, upgrade anddatabase tools.
Example text Exact user entry. These arewords or characters that youenter in the system exactly asthey appear in thedocumentation.
<Example text> Variable user entry. Pointedbrackets indicate that youreplace these words andcharacters with appropriateentries.
EXAMPLE TEXT Keys on the keyboard, forexample, function keys (suchas F2) or the ENTER key.
Icons
Icon Meaning
Caution
Example
Note
Recommendation
Syntax
4
ContentsIntroduction ................................................................................................................................6Guidelines on this Document ......................................................................................................71. POF Data Extraction ........................................................................................................8
1.1 Extraction for Document Accuracy...............................................................................81.2 Extraction for Warranty, Return, Damage-free and Defect-free Installation ..................91.3 Extraction for Sales Order Detail - Item level ...............................................................91.4 Extraction for Sales Schedule Line Overview with Delivery ....................................... 101.5 R/3 Details for Perfect Order Fulfillment .................................................................... 11
2. COGS Data Extraction ................................................................................................... 122.1 Extraction for Cost of Goods Sold .............................................................................. 132.2 R/3 Details for Cost of Goods Sold ............................................................................. 132.3 Extraction for RSCFA SD Expenses ........................................................................... 14
3. SCMC Data Extraction .................................................................................................. 153.1 Extraction for Supply Chain Management Cost .......................................................... 153.2 Extraction for SCMC-Transportation .......................................................................... 183.3 R/3 Details for Supply Chain Management Cost ......................................................... 37
4. C2C Payables (Vendor).............................................................................................. 384.1 Extraction for Vendor Invoice Data ............................................................................ 384.2 R/3 Details for Vendor Invoice Data ........................................................................... 404.3 Extraction for Vendor Payment Data .......................................................................... 404.4 R/3 Details for Vendor Payment Data ......................................................................... 41
5. C2C Receivables (Customer) .................................................................................... 425.1 Extraction for Customer Invoice Data ......................................................................... 425.2 R/3 Details for Customer Invoice Data ....................................................................... 435.3 Extraction for Customer Receipt Data ........................................................................ 445.4 R/3 Details for Customer Receipt Data ....................................................................... 455.5 Extraction for Customer Adjustments and Bad debts Data. ......................................... 455.6 R/3 Details of Customer Adjustments and Bad debts Data. ......................................... 47
6. C2C Inventory.............................................................................................................. 476.1 Extraction for Inventory Data ..................................................................................... 486.2 Extraction Inventory Write-off Data ........................................................................... 496.3 Extraction for Inventory Forecast Data ....................................................................... 506.4 R/3 details for C2C Inventory data ............................................................................. 51
7. POFD Data Extraction ................................................................................................ 527.1 Extraction for Sales Return and Forecast .................................................................... 527.1.1 Extraction for Sales Return ..................................................................................... 527.1.2 R/3 Details for Sales Return .................................................................................... 547.1.3 Extraction for Forecast ............................................................................................ 547.2 Extraction for Purchase Return, Goods Receipt and ASN ........................................... 557.2.1 Extraction for Purchase Return ............................................................................... 557.2.2 Extraction for Goods Receipt .................................................................................. 577.2.3 Extraction for ASN ................................................................................................. 607.2.4 R/3 Details for Purchase Return/Goods Receipt/ASN ............................................. 637.3 Extraction for Production and Distribution ................................................................. 647.3.1 Extraction for Distribution ...................................................................................... 647.3.2 R/3 Details for Delivery Item Data .......................................................................... 667.3.3 Extraction for Production ........................................................................................ 67
5
7.3.4 SAP - R/3 Module: Production Planning (PP) ......................................................... 707.4 Extraction for Resource .............................................................................................. 717.4.1 Extraction of Work Center View Data..................................................................... 717.4.2 Extraction of Work Center Capacity Data ............................................................... 72
8. ODM Data Extraction .................................................................................................. 738.1 Extraction for Statistical Information .......................................................................... 738.1.1 Target: DSO = 0SPM_DS71 (Other Diagnostic - Statistical Information - Master).. 738.1.2 Target: DSO = 0SPM_DS71 (Other Diagnostic - Statistical Information - Master).. 748.1.3 R/3 Details for Customer Master Data..................................................................... 758.1.4 Target: DSO = 0SPM_DS71 (Other Diagnostic - Statistical Information - Master).. 758.1.5 Target: DSO = 0SPM_DS71 (Other Diagnostic - Statistical Information - Master).. 768.1.6 R/3 Details for Material Master Data ...................................................................... 768.1.7 Target: DSO = 0SPM_DS71 (Other Diagnostic - Statistical Information - Master).. 778.1.8 R/3 Details for Vendor Master Data ........................................................................ 778.1.9 Target: DSO = 0SPM_DS24 (Other Diagnostic - Statistical Information) ............... 788.1.10 R/3 Details for Sales Document Item Data .............................................................. 798.1.11 Target: DSO = 0SPM_DS24 (Other Diagnostic - Statistical Information) ............... 798.1.12 R/3 Details for Purchasing Data .............................................................................. 818.1.13 Target: DSO = 0SPM_DS24 (Other Diagnostic - Statistical Information) ............... 818.1.14 R/3 Details for Delivery Item Data .......................................................................... 828.1.15 Target DSO = 0SPM_DS24 (Other Diagnostic - Statistical Information)................. 828.1.16 R/3 Details for Billing Document Item Data ........................................................... 84
9. OFCT Data Extraction ................................................................................................ 859.1 Target DSO = 0SPM_DS33 ........................................................................................ 859.2 Target DSO = 0SPM_DS72 ........................................................................................ 869.3 Target DSO = 0SPM_DS33 ........................................................................................ 879.4 Target DSO = 0SPM_DS73 ........................................................................................ 889.5 Target DSO = 0SPM_DS73 ........................................................................................ 88
10. Global Section ............................................................................................................... 8910.1 Reporting Currency................................................................................................. 8910.2 Reporting Unit ........................................................................................................ 8910.3 Currency Conversion .............................................................................................. 9010.4 Unit Conversion ...................................................................................................... 90
6
IntroductionThis document presents details on the various extractors that are used in SAP BusinessObjectsSupply Chain Performance Management scenarios. This document provides a starting point forthe SAP system extractors that are used to feed the data, scenario by scenario. The tables inthis document describe how the data flows from these extractors to the fields in the DataStoreobjects (DSO). In certain cases, the data is loaded directly from a flat file instead of from anextractor. These cases are also explained in the document, providing information on the kind ofdata that has to be loaded from the flat file.
You need a basic understanding of the DSO structure to which data is loaded from theextractors before reading this document.
7
Guidelines on this DocumentIn this document, fields are marked with one star (*), two stars (**) or three stars (***) to meanthe following:
Symbol Description* Fields that are part of the primary key of a DSO** Refer to Reporting Unit conversion/Reporting Currency conversion section for
details*** Refer to Unit conversion/Currency conversion section for details
8
1. POF Data Extraction
The sections 1.1, 1.2, 1.3 and 1.4 provide the mapping details required to upload the data tothe Perfect Order Fulfillment (POF) staging layer.
1.1 Extraction for Document Accuracy
Document accuracy information is not available in the SAP ERP system; so that data fordocument accuracy has to be loaded using a flat file. This mechanism is provided by SAPBusinessObjects Supply Chain Performance Management. For an order and the correspondingcompany code, load ‘1’ if the Document Accuracy (Shipping Documentation Accuracy, PaymentDocumentation Accuracy, Other Documentation Accuracy and Compliance Documentation) isincorrect, otherwise load ‘0’. In case the data is not uploaded, by default, the value for all thesedocumentation accuracy is ’0’.
9
1.2 Extraction for Warranty, Return, Damage-free and Defect-freeInstallation
Warranty, return, damage-free and defect-free installation information is not available in theSAP system. For this reason, the data for this information needs to be loaded using flat files.This mechanism is provided by SAP BusinessObjects Supply Chain PerformanceManagement. For an order, its item, and the corresponding company code, load ‘1’ if warrantyreturn, damage-free and defect-free installation are incorrect, otherwise load ‘0’. In case thedata is not uploaded, by default, the value for all these above mentioned key figures is taken as’0’.
1.3 Extraction for Sales Order Detail - Item level
Target DSO = 0SPM_DS61 (Sales Overview - Item)Source Data Source = 2LIS_11_VAITM
Note: For the table below, the aggregation type for the key figure upload is overwrite.
TARGET FIELD SOURCE FIELD UPDATE TYPE
0DOC_NUMBER*(Sales document)
VBELN(Sales document) Direct Assignment
0S_ORD_ITEM*Sales document item
POSNR(Sales document item) Direct Assignment
0SPM_COMP*(Company Code)
BUKRS(Company code) Direct Assignment
0SPM_CUST(Customer)
KUNNR(Sold-to party) Direct Assignment
0SPM_SHIPTO(Ship-To Party)
PKUNWE(Ship-To Party) Direct Assignment
0SPM_PLANT(Plant)
WERKS(Plant) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material) Direct Assignment
0DOC_DATE(Document Date)
ERDAT(Date on Which Record WasCreated) Direct Assignment
0SPM_TUNIT(Transaction UOM)
VRKME(Sales unit) Direct Assignment
0FISCVARNT(Fiscal year variant)
PERIV(Fiscal Year Variant) Direct Assignment
0SPM_DC(Distribution Channel)
VTWEG(Distr. Channel) Direct Assignment
0SPM_DIV(Division)
SPART(Division) Direct Assignment
0SPM_SALORG(Sales Organization)
VKORG(Sales Organization) Direct Assignment
10
0SPM_SALGRP(Sales Group)
VKGRP(Sales Group) Direct Assignment
0SPM_SALOFF(Sales office)
VKBUR(Sales Office) Direct Assignment
0SPM_SALEMP(Sales Representative)
PVRTNR(Sales employee) Direct Assignment
0UPPR_BND(Tolerance Limit for Over Deliveryin %)
UEBTO(Overdeliv. Tol) Direct Assignment
0LOWR_BND(Tolerance Limit for Under Deliveryin %)
UNTTO(Unlimited tol.) Direct Assignment
0SPM_KF_TQY(Quantity Ordered - TransactionUnit)
KWMENG(Order quantity),VRKME(Sales unit) Direct Assignment
0SPM_KF_ODQ(Ordered Quantity - Sales Unit)
KWMENG(Order quantity),VRKME(Sales unit) ROUTINE (unit conversion**)
0SALES_UNIT(Sales Unit)
VRKME(Sales unit) ROUTINE(reporting unit**)
1.4 Extraction for Sales Schedule Line Overview with Delivery
Target: DSO = 0SPM_DS60 (Sales schedule Line Overview with Delivery)Source: Data Source = 2LIS_11_V_SSL
Note: For the table below, the aggregation type for the key figure upload is overwrite.
TARGET FIELD SOURCE FIELD UPDATE TYPE IMPACTED KPIs
0DOC_NUMBER*(Sales document)
VBELN(Sales document) Direct Assignment
0S_ORD_ITEM*(Sales document item)
POSNR(Sales document item) Direct Assignment
0SCHED_LINE*(Schedule line number)
ETENR(Schedule Line) Direct Assignment
0DELIV_NUMB*(Delivery)
VBELN_VL(Delivery) Direct Assignment
0DELIV_ITEM*(Delivery Item)
POSNR_VL(Item) Direct Assignment
0SPM_CH_PGI(Planned Goods Issue Date)
MCEX_B_WADAT(PG Issue Date) Direct Assignment
0SPM_TUNIT(Transaction UOM)
VRKME(Sales unit) Direct Assignment
0ACT_GI_DTE(Actual goods issue date)
MCEX_I_WADAT(Actual Goods MovementDate of Delivery) Direct Assignment
11
0SPM_KF_DLT(Actual quantity delivered -Transactional Unit)
VSMNG(Delivered Quantity inSales Unit of Sales OrderSched. Lines) Direct Assignment
0DLV_QTY(Actual Quantity Delivered –inSales Unit)
VSMNG (DeliveredQuantity in Sales Unit ofSales Order Sched.Lines), VRKME(Salesunit)
Update Type: ROUTINE (unitconversion**)
0SPM_KF_TCQ(Conf Quantity - TransactionUnit)
BMENG(Confirmed Qty in SalesUnit of Sales OrderSched. Lines) Direct Assignment
0SPM_KF_CNF(Confirmed Quantity - in SalesUnit)
BMENG (Confirmed Qtyin Sales Unit of SalesOrder Sched. Lines);VRKME(Sales unit)
Update Type: ROUTINE (unitconversion**)
0SALES_UNIT(Sales Unit)
VRKME(Sales unit)
Update Type: ROUTINE(reporting unit**)
0SPM_CH_DCL(Actual Delivery Location) Not available
KPI ‘Delivery Location Accuracy’will be 100% for all the schedule
lines.
0SPM_CH_CRL(Customer RequestedLocation) Not available
0SPM_KF_CQC(Confirmed Cases) Not available
1. Case Fill Rate cannot becomputed.
0SPM_KF_ADC(Actual Cases Delivered) Not available
1.5 R/3 Details for Perfect Order FulfillmentSAP-R3 Module: Sales & Distribution (SD)
Transactions:VA01/VA02/VA03 To create/edit/display a sales orderVL01N/VL02N/VL03N To create/edit/display an outbound delivery
Tables:
Scenario : SalesTable Table DescriptionVBAK Sales Order HeaderVBAP Sales Order ItemVBEP Sales Order Schedule LineScenario : DistributionTable Table DescriptionLIKP Delivery HeaderLIPS Delivery Item
12
2. COGS Data Extraction
The sections 2.1 and 2.2 provide the mapping details required to upload the data to the Cost ofGoods Sold (CoGS) staging layer.
13
2.1 Extraction for Cost of Goods Sold
Target DSO = 0SPM_DS10 (COGS inbound)Source Data Source = 0CO_OM_CCA_9
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD Update Type
0CALDAY(Calendar day)
BUDAT(Posting date) Direct Assignment
0FISCVARNT(Fiscal year variant)
PERIV(Fiscal year variant) Direct Assignment
0SPM_COMP(Company code)
BUKRS(Company code) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material number) Direct Assignment
0SPM_PLANT(Plant)
WERKS(Plant) Direct Assignment
0SPM_BUSAR(Business area)
GSBER(Business area) Direct Assignment
0SPM_CH_ITY(Vendor invoice type)
KSTAR(Cost element) Direct Assignment
0CO_AREA(Controlling area)
KOKRS(Controlling area) Direct Assignment
0SPM_KF_IVR(Invoice/inventory value –Transaction Currency)
SWG(Amount) Direct Assignment
0SPM_TCURR(Transaction currency)
WAERS(Currency key) Direct Assignment
0SPM_KF_IVL(Invoice Value – ReportingCurrency)
SWG(Amount), WAERS(Currencykey) Routine(currency conversion**)
0CURRENCY(Currency Key)
WAERS(Currency key) Routine(currency conversion**)
2.2 R/3 Details for Cost of Goods Sold
SAP R/3 Module: Controlling (CO)
Tables:COEP Controlling document line item table
COBK Controlling document header table
14
2.3 Extraction for RSCFA SD ExpensesThe term sales and distribution expense (SD expense) refers to the sales and distribution expenses. It isused mainly in the computation of total returns on the supply chain fixed assets. This detail is notcaptured in the source system, but can be provided by the flat file. The flat file upload mechanism isprovided by SAP Business Objects Supply Chain Performance Management. The sales and distributionexpense is captured for a particular document date, company code, profit center and business area. Ifthe SD expense is not captured, it does not affect COGS analysis. The only KPI affected will be theReturn on Supply Chain Fixed Assets in the RSCFA scenario.
Scenario Dependency:1. C2C Customer Invoice: COGS as a percentage of total supply chain revenue can be
calculated only if the “total supply chain revenue” (sum of all customer invoices, that is,0SPM_KF_IVR) information comes from a C2C Customer invoice (0SPM_DS46).
2. POFD Forecast: All unit-based KPIs, such as, “Direct labor cost per unit”, “Direct materialcost per unit” and “Production overhead cost per unit” needs the “Total number of units sold”information. The required information comes from POFD Forecast (0SPM_DS22). As the POFDForecast information is not available in the scenario, the data containing this information canbe loaded using flat files. This mechanism is provided by SAP Business Objects SupplyChain Performance Management. Gross Sales/Purchase Value, Discount, Allowancesfor Sales Defects, Forecasted Sales, Demand Unfulfilled Quantity, and Gross Salesshould be present in the flat file to calculate the COGS value.
Unavailable Dimensions: Dimension-based analysis for COGS and related KPIs is not availablefor the following dimensions. Although these dimensions are available in the BI data model, there is nocorresponding field in the data source, so they are not available for analysis once the extractors areused.
0SPM_PCTR (Profit center)
15
3. SCMC Data Extraction
Sections 3.1 and 3.2 and 3.3 provide the mapping details required to upload the data into theSCMC staging layer. The section marked in red is new mapping and is not available in SCPM1.0 system.
3.1 Extraction for Supply Chain Management Cost
Target: DSO = 0SPM_DS30 (SCMC - DSO)Source: Data Source = 0CO_OM_CCA_9
16
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE Routine Logic
0REFER_DOC*(Document number of thereference document
BELNR(Document Number) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material Number) Direct Assignment
0SPM_COMP*(Company Code)
BUKRS(Company Code) Direct Assignment
0SPM_BUSAR(Business Area)
GSBER(Business Area) Direct Assignment
0SPM_PLANT(Plant)
WERKS(Plant) Direct Assignment
0SPM_KF_CS(Customer Service Cost)
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Customer Service CostElement
0SPM_KF_FGW(Finished Goods WarehouseCost)
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Finished GoodsWarehouse Cost
0SPM_KF_CPM( Contract & ProgramManagement Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Contract & ProgramManagement.
0SPM_KF_IPE( Installation Planning &Execution Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Installation Planning &Execution Cost
0SPM_KF_ARP( Accounts ReceivableProcessing Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Accounts ReceivableProcessing Cost’
0SPM_KF_PUR( Purchasing Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Purchasing Cost
0SPM_KF_RMW( RM Warehouse Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to RM Warehouse Cost’
0SPM_KF_SQ( Supplier Quality Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Supplier Quality Cost
0SPM_KF_DC( Demand Planning Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Demand Planning Cost’
0SPM_KF_SP( Supply Planning Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Supply Planning Cost’
0SPM_KF_SCF( Supply Chain FinanceControl Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Supply Chain FinanceControl Cost’
0SPM_KF_OPP( Opportunity Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Opportunity Cost
0SPM_KF_OBS( Obsolescence Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Obsolescence Cost
0SPM_KF_SHR( Shrinkage Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Shrinkage Cost
17
0SPM_KF_TI( Taxes & Insurance Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Taxes & InsuranceCost’
0SPM_KF_SCA( Supply Chain ApplicationCost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Supply ChainApplication Cost’
0SPM_KF_IOC( IT operational Cost forSupply Chain )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to IT operational Cost forSupply Chain
0SPM_KF_RAP( Return AuthorizationProcessing Cost (Delivery) )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Return AuthorizationProcessing Cost (Delivery)
0SPM_KF_RPW( Return ProductWarehousing Cost (Delivery))
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Return ProductWarehousing Cost (Delivery)
0SPM_KF_WAR( Warranty Cost )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Warranty Cost
0SPM_KF_SRA( Return AuthorizationProcessing Cost (Sourcing) )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Return AuthorizationProcessing Cost (Sourcing)
0SPM_KF_SRP( Return ProductWarehousing Cost(Sourcing) )
KSTAR, SWG(Cost Element ,Amount) Routine
Update with Amount if the documentis related to Return ProductWarehousing Cost (Sourcing)
0DOC_DATE( Document Date ) BLDAT ( Document Date) Direct Assignment
0CO_AREA(Controlling area ) KOKRS (Controlling Area) Direct Assignment
0SPM_TCURR(Transaction Currency )
WAERS(Currency key) Direct Assignment
0FISCVARNT(Fiscal year variant ) FISCVAR Direct Assignment
0CURRENCY( Currency Key ) WAERS (Currency Key)
Routine(currencyconversion***)
0SPM_KF_RC1( Resource Cost - CustomerService )
KSTAR, SWG (CostElement ,Amount), WAERS(Currency key)
Routine(currencyconversion**)
Update with Amount if the documentis related to Customer Service Cost
Unavailable Dimensions: Dimension-based analysis for SCMC and related KPIs is not availablefor the dimensions listed below. Although these dimensions are available in the BW data model, they arenot available for analysis once the extractors are used, since there is no corresponding field in the datasource.
0SPM_CH_FMD (From locations) 0SPM_CH_TMD (To locations) 0SPM_SALORG (Sales organization) 0SPM_DIVISION (Division) 0SPM_PCTR (Profit center) 0SPM_CH_TMO (Transportation mode) 0SPM_VENDOR (Vendor) 0SPM_SHIPTO (Ship-to party) 0SPM_CUST (Customer) 0SPM_SUPPLY (Goods supplier) 0SPM_CARIER (Carrier) 0SPM_PURORG (Purchasing Organization)
18
3.2 Extraction for SCMC-Transportation
3.2.1
Target: DSO = 0SPM_DS52 (SCMC-Transportation Intermediate DSO)
Source: Data Source = 2LIS_08TRTK
Note: For the table below, the aggregation type for the key figure upload is summation.
0REFER_DOC *( Document number
of the referencedocument )
TKNUM(ShipmentNumber)
Direct AssignmentIncluded from
communication structure
0SPM_SUPPLY(Goods Supplier)
WERKA(Plant departure)
Direct Assignment
0SPM_CUST(Customer)
KUNNZ(Customer
Destination Point)Direct Assignment
0SPM_FR_LOC(From Location
Indicator)
KNOTA(Departure Point)
LIFNA(Vendor
Departure Point)LSTEL
(Departure loadPoint)VSTEL
(Shipping PointDeparture)
WERKA(Plant departure)
Routine
IF KNOTA NOT INITIALTHEN 0SPM_FR_LOC =
KNOTAELSE IF LIFNA NOT INITIAL
THEN 0SPM_FR_LOC =LIFNA
ELSE IF LSTEL NOT INITIALTHEN 0SPM_FR_LOC =
LSTELELSE IF VSTEL NOT
INITIAL THEN0SPM_FR_LOC = VSTEL
ELSE IF WERKA NOTINITIAL THEN
0SPM_FR_LOC = WERKA
0SPM_TO_LOC(To Location
Indicator)
KNOTZ(Destination
Point)LSTEZ
(Destination loadPoint)VESTZ
Routine
IF KNOTZ NOT INITIALTHEN 0SPM_TO_LOC =
KNOTZELSE IF LSTEZ NOT INITIAL
THEN 0SPM_TO_LOC =LSTEZ
ELSE IF VSTEZ NOT
19
(Shipping PointDestination)
KUNNZ(Customer
Destination Point)WERKZ(Plant
Destination)
INITIAL THEN0SPM_TO_LOC = VSTEZ
ELSE IF KUNNZ NOTINITIAL THEN
0SPM_TO_LOC = KUNNZELSE IF WERKZ NOT
INITIAL THEN0SPM_TO_LOC = WERKZ
0SPM_CH_FLI(From Location
Indicator Indicator)
KNOTA(Departure Point)
LIFNA(Vendor
Departure Point)LSTEL
(Departure loadPoint)VSTEL
(Shipping PointDeparture)
WERKA(Plant departure)
Routine
IF KNOTA NOT INITIALTHEN 0SPM_CH_FLI = ‘K’
ELSE IF LIFNA NOT INITIALTHEN 0SPM_CH_FLI = ‘S’
ELSE IF LSTEL NOT INITIALTHEN 0SPM_CH_FLI = ‘L’
ELSE IF VSTEL NOTINITIAL THEN
0SPM_CH_FLI = ‘V’ELSE IF WERKA NOT
INITIAL THEN0SPM_CH_FLI = ‘P’
0SPM_CH_TLI(To Location
Indicator Indicator)
KNOTZ(Destination
Point)LSTEZ
(Destination loadPoint)VESTZ
(Shipping PointDestination)
KUNNZ(Customer
Destination Point)WERKZ(Plant
Destination)
Routine
IF KNOTZ NOT INITIALTHEN 0SPM_CH_TLI = ‘K’
ELSE IF LSTEZ NOT INITIALTHEN 0SPM_CH_TLI = ‘L’
ELSE IF VSTEZ NOTINITIAL THEN
0SPM_CH_TLI = ‘V’ELSE IF KUNNZ NOT
INITIAL THEN0SPM_CH_TLI = ‘C’ELSE IF WERKZ NOT
INITIAL THEN0SPM_CH_TLI = ‘P’
0SPM_KF_KPW(Allowed Total
Weight ForShipment)
KAPAGEW(Capacity Weight)
Direct Assignment
0SPM_KF_KPV(Allowed Total
Volume ForShipment)
KAPAVOL(CapacityVolume)
Direct Assignment
0SPM_KF_NTW(Total Net Weight)
MAX_NTGEW(Maximum Net
Weight)Direct Assignment
0SPM_KF_NTV(Total Net Volume)
MAX_VOLUM(Maximum
Volume)Direct Assignment
20
0SPM_TVUNIT(Transaction Volume
Unit)
VOLEH(Volume Unit)
Direct Assignment
0SPM_TWUNIT(Transaction Weight
Unit)
GEWEI(Unit of Weight)
Direct Assignment
0SPM_TVUNIT(Transaction Volume
Unit)
DTMEV(Volume Unit for
shipmentcapacity)
Direct Assignment
0SPM_TWUNIT(Transaction Weight
Unit)
DTMEG (Weight Unit for
shipmentcapacity)
Direct Assignment
3.2.2
Target: DSO = 0SPM_DS52 (SCMC-Transportation Intermediate DSO)
Source: Data Source = 2LIS_08TRFKZ
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC /IMPLICATIONS IMPACTED KPIs
0REFER_DOC *( Document number
of the referencedocument )
TKNUM(ShipmentNumber)
Direct AssignmentIncluded from
communicationstructure
0SPM_COMP(Company code)
BUKRS(Company code) Direct Assignment
0DOC_DATE(Document Date)
ERDAT (Date onWhich RecordWas Created )
Direct Assignment
0SPM_MTRL( Material )
MATNR( MaterialNumber )
Direct Assignment
0SPM_MTART(Material Type)
MTART(Material Type)
Direct Assignment
0SPM_SHTYP(Shipment Type)
SHTYP(Shipment Type)
Direct Assignment
0SPM_PLANT( Plant )
WERKS( Plant )
Direct Assignment
0SPM_BUSAR( Business area )
GSBER( Business Area )
Direct AssignmentIncluded from
communicationstructure
0SPM_PCTR( Profit centre )
PRCTR( Profit Center )
Direct AssignmentIncluded from
communicationstructure
21
0CO_AREA(Controlling area)
KOKRS(Controlling area)
Direct AssignmentIncluded from
communicationstructure
0SPM_CARIER(Carrier)
TDLNR(Number of
forwarding agent)Direct Assignment
0SPM_CH_TMO(Transportation
Mode)
TRMTYP(Means ofTransport)
Direct AssignmentIncluded from
communicationstructure
0SPM_SHIPTO(Ship-To Party)
LIFNZVendor numberof destination
point
Direct Assignment
0SPM_PURORG(Purchasing
Organization)
EKORGPurchasing
OrganizationDirect Assignment
0SPM_VENDOR(Vendor)
LIFNRVendor Account
NumberDirect Assignment
0SPM_KF_IDE(Detention Cost for
Raw Material)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net ValueFreight),
Routine
Material Type = ROWShipment Type (SHTYP =
Inbound),Shipment Cost ItemCategory (FKPTY =Detention Cost),
Net Value Freight(NETWR=)
0SPM_KF_IDC(Demurrage Cost for
Raw Material)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net ValueFreight),
Routine
Material Type = ROWShipment Type (SHTYP =
Inbound),Shipment Cost ItemCategory (FKPTY =Demurrage Cost),Net Value Freight
(NETWR=)
0SPM_KF_DTC(Detention Cost for
Finished Goods)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net Value
Freight)
Routine
Material Type = FERTShipment Type (SHTYP =
Outbound)Shipment Cost ItemCategory (FKPTY=Detention Cost),
Net Value Freight(NETWR=)
0SPM_KF_ODE(Demurrage Cost for
Finished Goods)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net Value
Routine
Material Type = FERTShipment Type (SHTYP =
Outbound)Shipment Cost ItemCategory (FKPTY=Demurrage Cost),Net Value Freight
(NETWR=)
22
Freight)
0SPM_TCURR(Transaction
Currency)
WAERS(Currency)
Direct Assignment
0CURRENCYCurrency Key)
WAERS(Currency)
Routine (reportingcurrency***)
0SPM_KF_R25(Resource Cost – RawMaterial Detention)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net ValueFreight),WAERS(Freight
DocumentCurrency)
ERDAT (Date onWhich RecordWas Created )
Routine (currencyconversion**)
Material Type = ROWShipment Type (SHTYP =
Inbound),Shipment Cost ItemCategory (FKPTY =Detention Cost),
Net Value Freight(NETWR=),
Freight DocumentCurrency (WAERS=)
0SPM_KF_R26(Resource Cost – RawMaterial Demurrage
Cost)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net ValueFreight),WAERS(Freight
DocumentCurrency)
ERDAT (Date onWhich RecordWas Created )
Routine (currencyconversion**)
Material Type = ROWShipment Type (SHTYP =
Inbound),Shipment Cost ItemCategory (FKPTY =Demurrage Cost),Net Value Freight
(NETWR=),Freight Document
Currency (WAERS=)
0SPM_KF_RDC(Resource Cost –Finished Goods
Detention)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net ValueFreight),WAERS(Freight
DocumentCurrency)
ERDAT (Date onWhich RecordWas Created )
Routine (currencyconversion**)
Material Type = FERTShipment Type (SHTYP =
Outbound)Shipment Cost ItemCategory (FKPTY=Detention Cost),
Net Value Freight(NETWR=),
Freight DocumentCurrency (WAERS=)
23
0SPM_KF_R26(Resource Cost –Finished Goods
Demurrage Cost)
MTARTSHTYP
(Shipment type),FKPTY
(Shipment CostItem Category),
NETWR(Net ValueFreight),WAERS(Freight
DocumentCurrency)
ERDAT (Date onWhich RecordWas Created )
Routine (currencyconversion**)
Material Type = FERTShipment Type (SHTYP =
Outbound)Shipment Cost ItemCategory (FKPTY=Demurrage Cost),Net Value Freight
(NETWR=),Freight Document
Currency (WAERS=)
3.2.3
Target: DSO = 0SPM_DS35 (SCMC-Transportation DSO)
Source: Data Source = 0SPM_DS52 (SCMC-Transportation Intermediate DSO)
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC /IMPLICATIONS IMPACTED KPIs
0REFER_DOC *( Document number
of the referencedocument )
0REFER_DOC *( Document number
of the referencedocument )
DirectAssignment
0SPM_COMP(Company code)
0SPM_COMP(Company code)
DirectAssignment
0DOC_DATE(Document Date)
0DOC_DATE(Document Date)
DirectAssignment
0SPM_MTRL( Material )
0SPM_MTRL( Material )
DirectAssignment
0SPM_PLANT( Plant )
0SPM_PLANT( Plant )
DirectAssignment
0SPM_FRLOC(From
Plant/LocationIndicator)
0SPM_FRLOC(From Plant/Location
Indicator)
DirectAssignment
0SPM_TOLOC (To Plant/Location
Indicator)
0SPM_TOLOC (To Plant/Location
Indicator)
DirectAssignment
0SPM_BUSAR( Business area )
0SPM_BUSAR( Business area )
DirectAssignment
24
0SPM_PCTR( Profit centre )
0SPM_PCTR( Profit centre )
DirectAssignment
0CO_AREA(Controlling area)
0CO_AREA(Controlling area)
DirectAssignment
0SPM_CARIER(Carrier)
0SPM_CARIER(Carrier)
DirectAssignment
0SPM_CH_TMO(Transportation
Mode)
0SPM_CH_TMO(Transportation
Mode)
DirectAssignment
0SPM_CUST(Customer)
0SPM_CUST(Customer)
DirectAssignment
0SPM_SHIPTO(Ship-To Party)
0SPM_SHIPTO(Ship-To Party)
DirectAssignment
0SPM_PURORG(Purchasing
Organization)
0SPM_PURORG(Purchasing
Organization)
DirectAssignment
0SPM_VENDOR(Vendor)
0SPM_VENDOR(Vendor)
DirectAssignment
0SPM_SUPPLY(Goods Supplier)
0SPM_SUPPLY(Goods Supplier)
DirectAssignment
0SPM_TVUNIT(TransactionVolume Unit)
0SPM_TVUNIT(Transaction Volume
Unit)
DirectAssignment
0SPM_TWUNIT(Transaction Weight
Unit)
0SPM_TWUNIT(Transaction Weight
Unit)
DirectAssignment
0SPM_CVUNIT(Transaction
Capacity VolumeUnit)
0SPM_CVUNIT(Transaction Capacity
Volume Unit)
DirectAssignment
0SPM_CWUNIT(Transaction
Capacity WeightUnit)
0SPM_CWUNIT(Transaction Capacity
Weight Unit)
DirectAssignment
0SPM_KF_CCU(Finished GoodsCarrier Capacity
Load - Primary - TR)
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator = dc
Maximum Net Weight
25
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)0SPM_KF_NTV
(Maximum Volume)0SPM_TWUNIT(Weight Unit)0SPM_TVUNIT(Volume Unit)
Maximum VolumeWeight UnitVolume Unit
0SPM_KF_SCU(Finished GoodsCarrier Capacity
Load - Secondary –TR)
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)0SPM_KF_NTV
(Maximum Volume)0SPM_TWUNIT(Weight Unit)0SPM_TVUNIT(Volume Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerMaximum Net Weight
Maximum VolumeWeight UnitVolume Unit
0SPM_KF_TCC(Finished Goods
Total CarrierCapacity Load - TR)
0SPM_KF_CCU0SPM_KF_SCU Routine
0SPM_KF_CCU (FinishedGoods Carrier Capacity
Load - Primary – TR )+
0SPM_KF_SCU(Finished Goods Carrier
Capacity Load -Secondary – TR)
SPM_KF_VCCFinished GoodsCarrier CapacityLoad - Primary -
Volume - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTV
(Maximum Volume)0SPM_TVUNIT(Volume Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
PlantTo Location Indicator =
DCMaximum Volume
Volume Unit
26
0SPM_KF_VSCFinished GoodsCarrier CapacityLoad -Secondary
Volume - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTV
(Maximum Volume)0SPM_TVUNIT(Volume Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerMaximum Volume
Volume Unit
0SPM_KF_WCCFinished Good
Carrier CapacityLoad - Primary -
Weight - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)0SPM_TWUNIT(Weight Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
PlantTo Location Indicator =
DCMaximum Net Weight
Weight Unit
0SPM_KF_WSCFinished GoodsCarrier Capacity
Load - SecondaryWeight -TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)0SPM_TWUNIT(Weight Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerMaximum Net Weight
Weight Unit
0SPM_KF_PCCFinished Goods
Carrier Capacity -Primary - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator = dc
Capacity WeightCapacity Volume
Weight Unit for shipmentcapacity
27
0SPM_KF_KPW(Allowed Total Weight
for Shipment)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CWUNIT
(Transaction CapacityWeight Unit)
0SPM_CVUNIT(Transaction Capacity
Volume Unit)
Volume Unit for shipmentcapacity
0SPM_KF_SOCFinished Goods
Carrier Capacity -Secondary - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CWUNIT
(Transaction CapacityWeight Unit)
0SPM_CVUNIT(Transaction Capacity
Volume Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerCapacity WeightCapacity Volume
Weight Unit for shipmentcapacity
Volume Unit for shipmentcapacity
0SPM_KF_PSCFinished Goods
Total CarrierCapacity - TR
0SPM_KF_PCC0SPM_KF_SOC Routine
0SPM_KF_PCC (FinishedGoods Carrier Capacity -
Primary – TR )+
0SPM_KF_SOC(Finished Goods CarrierCapacity - Secondary –
TR)
0SPM_KF_VPCFinished Goods
Carrier Capacity -Primary - Volume -
TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CVUNIT
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator = dc
Capacity VolumeVolume Unit for shipment
capacity
28
(Transaction CapacityVolume Unit)
0SPM_KF_VCSFinished Goods
Carrier Capacity -Secondary Volume -
TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CVUNIT
(Transaction CapacityVolume Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerCapacity Volume
Volume Unit for shipmentcapacity
0SPM_KF_VPSTotal FinishedGoods Carrier
Capacity - Volume -TR
0SPM_KF_VCC0SPM_KF_VSC Routine
0SPM_KF_VSCFinished Goods Carrier
Capacity Load -SecondaryVolume - TR
+0SPM_KF_VPS
Total Finished GoodsCarrier Capacity - Volume
- TR
0SPM_KF_WPCFinished Goods
Carrier Capacity -Primary - Weight -
TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)
0SPM_CWUNIT(Transaction Capacity
Weight Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator =Dc
Capacity WeightWeight Unit for shipment
capacity
29
0SPM_KF_WPSFinished Goods
Carrier Capacity -Secondary - Weight
- TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)
0SPM_CWUNIT(Transaction Capacity
Weight Unit)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerCapacity Weight
Weight Unit for shipmentcapacity
0SPM_KF_WCTTotal FinishedGoods Carrier
Capacity - Weight -TR
0SPM_KF_WPC0SPM_KF_WPS Routine
0SPM_KF_WPCFinished Goods Carrier
Capacity - Primary -Weight - TR
+0SPM_KF_WPS
Finished Goods CarrierCapacity - Secondary -
Weight - TR
0SPM_KF_ICURaw Material -
Carrier CapacityLoad - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_NTW(Maximum Net
Weight)0SPM_KF_NTV
(Maximum Volume)0SPM_TWUNIT(Weight Unit)0SPM_TVUNIT(Volume Unit)
Routine
Material type = ROWShipment Type = inbound
Maximum Net WeightMaximum Volume
Weight UnitVolume Unit
0SPM_KF_VRCRaw Material -
Carrier CapacityLoad - Volume - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_NTV
(Maximum Volume)0SPM_TVUNIT(Volume Unit)
Routine
Material type = ROWShipment Type = inbound
Maximum VolumeVolume Unit
0SPM_KF_WR1Raw Material -
Carrier CapacityLoad - Weight - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_NTW(Maximum Net
Weight)
Routine
Material type = ROWShipment Type = inbound
Maximum Net WeightWeight Unit
30
0SPM_TWUNIT(Weight Unit)
0SPM_KF_INCRaw Material -
Carrier Capacity - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CWUNIT
(Transaction CapacityWeight Unit)
0SPM_CVUNIT(Transaction Capacity
Volume Unit)
Routine
Material type = ROWShipment Type = inbound
Capacity WeightCapacity Volume
Weight Unit for shipmentcapacity
Volume Unit for shipmentcapacity
0SPM_KF_WR2Raw Material -
Carrier Capacity -Weight - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)
0SPM_CWUNIT(Transaction Capacity
Weight Unit)
Routine
Material type = ROWShipment Type = inbound
Capacity WeightWeight Unit for shipment
capacity
0SPM_KF_VR1Raw Material -
Carrier Capacity -Volume - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CVUNIT
(Transaction CapacityVolume Unit)
Routine
Material type = ROWShipment Type = inbound
Capacity VolumeVolume Unit for shipment
capacity
0SPM_KF_R32(Finished GoodsCarrier CapacityLoad - Primary)
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator = dc
Maximum Net WeightMaximum Volume
Weight UnitVolume Unit
31
0SPM_KF_NTV(Maximum Volume)
0SPM_TWUNIT(Weight Unit)0SPM_TVUNIT(Volume Unit)0SPM_MATNR
( Material )
0SPM_KF_R33(Finished GoodsCarrier Capacity
Load - Secondary)
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)0SPM_KF_NTV
(Maximum Volume)0SPM_TWUNIT(Weight Unit)0SPM_TVUNIT(Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerMaximum Net Weight
Maximum VolumeWeight UnitVolume Unit
0SPM_KF_TCC(Finished Goods
Total CarrierCapacity Load - TR)
0SPM_KF_CCU0SPM_KF_SCU Routine
0SPM_KF_CCU (FinishedGoods Carrier Capacity
Load - Primary – TR )+
0SPM_KF_SCU(Finished Goods Carrier
Capacity Load -Secondary – TR)
SPM_KF_VCCFinished GoodsCarrier CapacityLoad - Primary -
Volume - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTV
(Maximum Volume)0SPM_TVUNIT(Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
PlantTo Location Indicator =
DCMaximum Volume
Volume Unit
32
0SPM_KF_VSCFinished GoodsCarrier CapacityLoad -Secondary
Volume - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTV
(Maximum Volume)0SPM_TVUNIT(Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerMaximum Volume
Volume Unit
0SPM_KF_WCCFinished Good
Carrier CapacityLoad - Primary -
Weight - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)0SPM_TWUNIT(Weight Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
PlantTo Location Indicator =
DCMaximum Net Weight
Weight Unit
0SPM_KF_WSCFinished GoodsCarrier Capacity
Load - SecondaryWeight -TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_NTW(Maximum Net
Weight)0SPM_TWUNIT(Weight Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerMaximum Net Weight
Weight Unit
33
0SPM_KF_R35Finished Goods
Carrier Capacity -Primary - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CWUNIT
(Transaction CapacityWeight Unit)
0SPM_CVUNIT(Transaction Capacity
Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator = dcAllowed Total Volume for
ShipmentAllowed Total Weight for
ShipmentTransaction Capacity
Weight UnitTransaction Capacity
Volume Unit
0SPM_KF_R36Finished Goods
Carrier Capacity -Secondary - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CWUNIT
(Transaction CapacityWeight Unit)
0SPM_CVUNIT(Transaction Capacity
Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerAllowed Total Volume for
ShipmentAllowed Total Weight for
ShipmentTransaction Capacity
Weight UnitTransaction Capacity
Volume Unit
0SPM_KF_PSCFinished Goods
Total CarrierCapacity - TR
0SPM_KF_PCC0SPM_KF_SOC Routine
0SPM_KF_PCC (FinishedGoods Carrier Capacity -
Primary – TR )+
0SPM_KF_SOC(Finished Goods CarrierCapacity - Secondary –
TR)
34
0SPM_KF_RFCFinished Goods
Carrier Capacity -Primary - Volume -
TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CVUNIT
(Transaction CapacityVolume Unit)
0SPM_MATNR( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator = dcAllowed Total Volume for
ShipmentTransaction Capacity
Volume Unit
0SPM_KF_RFVFinished Goods
Carrier Capacity -Secondary Volume -
TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CVUNIT
(Transaction CapacityVolume Unit)
0SPM_MATNR( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerAllowed Total Volume for
ShipmentTransaction Capacity
Volume Unit
0SPM_KF_VPSTotal FinishedGoods Carrier
Capacity - Volume -TR
0SPM_KF_VCC0SPM_KF_VSC Routine
0SPM_KF_VSCFinished Goods Carrier
Capacity Load -SecondaryVolume - TR
+0SPM_KF_VPS
Total Finished GoodsCarrier Capacity - Volume
- TR
0SPM_KF_RWPFinished Goods
Carrier Capacity -Primary - Weight -
TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
plantTo Location Indicator = dcAllowed Total Weight for
ShipmentTransaction Capacity
Weight Unit
35
0SPM_KF_KPW(Allowed Total Weight
for Shipment)0SPM_CWUNIT
(Transaction CapacityWeight Unit)
0SPM_MATNR( Material )
0SPM_KF_R1SFinished Goods
Carrier Capacity -Secondary - Weight
- TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_CH_FLI
(From LocationIndicator)
0SPM_CH_TLI(From Location
Indicator)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)
0SPM_CWUNIT(Transaction Capacity
Weight Unit)0SPM_MATNR
( Material )
Routine
Material type = FERTShipment type =
OutboundFrom Location Indicator =
dcTo Location Indicator =
customerAllowed Total Weight for
ShipmentTransaction Capacity
Weight Unit
0SPM_KF_WCTTotal FinishedGoods Carrier
Capacity - Weight -TR
0SPM_KF_WPC0SPM_KF_WPS Routine
0SPM_KF_WPCFinished Goods Carrier
Capacity - Primary -Weight - TR
+0SPM_KF_WPS
Finished Goods CarrierCapacity - Secondary -
Weight - TR
0SPM_KF_R38Raw Material -
Carrier CapacityLoad - TR
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_NTW(Maximum Net
Weight)0SPM_KF_NTV
(Maximum Volume)0SPM_TWUNIT(Weight Unit)0SPM_TVUNIT(Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = ROWShipment Type = inbound
Maximum Net WeightMaximum Volume
Weight UnitVolume Unit
36
0SPM_KF_VC1Raw Material -
Carrier CapacityLoad - Volume
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_NTV
(Maximum Volume)0SPM_TVUNIT(Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = ROWShipment Type = inbound
Maximum VolumeVolume Unit
0SPM_KF_WC1Raw Material -
Carrier CapacityLoad - Weight
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_NTW(Maximum Net
Weight)0SPM_TWUNIT(Weight Unit)0SPM_MATNR
( Material )
Routine
Material type = ROWShipment Type = inbound
Maximum Net WeightWeight Unit
0SPM_KF_R39Raw Material -
Carrier Capacity
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CWUNIT
(Transaction CapacityWeight Unit)
0SPM_CVUNIT(Transaction Capacity
Volume Unit)0SPM_MATNR
( Material )
Routine
Material type = ROWShipment Type = inboundAllowed Total Volume for
ShipmentAllowed Total Weight for
ShipmentTransaction Capacity
Weight UnitTransaction Capacity
Volume Unit
0SPM_KF_WC2Raw Material -
Carrier Capacity -Weight
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_KPW
(Allowed Total Weightfor Shipment)
0SPM_CWUNIT(Transaction Capacity
Weight Unit)0SPM_MATNR
( Material )
Routine
Material type = ROWShipment Type = inboundAllowed Total Weight for
ShipmentTransaction Capacity
Weight Unit
37
0SPM_KF_VC2Raw Material -
Carrier Capacity -Volume
0SPM_MTART(Material type)0SPM_SHTYP
(Shipment Type)0SPM_KF_KPV(Allowed Total
Volume for Shipment)0SPM_CVUNIT
(Transaction CapacityVolume Unit)
0SPM_MATNR( Material )
Routine
Material type = ROWShipment Type = inboundAllowed Total Volume for
ShipmentTransaction Capacity
Volume Unit
3.3 R/3 Details for Supply Chain Management Cost
SAP R/3 Module: Controlling (CO)
Tables:COEP Controlling document line item tableCOBK Controlling document header table
SAP R/3 Module: Sales and Distribution (SD)
Transactions:
VT01N Create ShipmentVT02N Change ShipmentVT03N Display Shipment
Tables:VTTK Shipment HeaderVTTP Shipment ItemVTTS Stage of Shipment
38
4. C2C Payables (Vendor)
C2C DiagnosticsVendor Invoice0SPM_DS45
Cash To Cash Cycle Time - Payables
BW
Sta
ging
Laye
rIn
boun
d La
yer
BW Data Source SCPMInbound DSO
Flat File (.csv format)R/3 Data Source
R/3
Dat
a So
urce
Laye
r
0FI_AP_4
C2C DiagnosticsVendor Payment
0SPM_DS29
4.1 4.3Filter Invoices in DTP Filter Payments in DTP
Sections 4.1 and 4.3 provide the mapping details required to upload the data into the C2CPayables (Vendor)staging layer.
4.1 Extraction for Vendor Invoice Data
Target: DSO = 0SPM_DS45 (C2CD Vendor Invoice)Source: Data Source = 0FI_AP_4
Note: For the table below, the aggregation type for the key figure upload is overwrite.
While taking the data in this DSO filter is done on the Document Type KR (Vendor invoice).
TARGET FIELD SOURCE FIELD Update Type IMPACTED KPIs
0INV_DOC_NO*(Invoice Number)
BELNR(Accounting DocumentNumber) Direct Assignment
39
0SPM_COMP *(Company Code)
BUKRS(Company Code) Direct Assignment
0SPM_CH_IDT(Invoice Date)
BUDAT(Posting Date in theDocument) Direct Assignment
0SPM_CH_DUE(Due Date)
NETDT(Due Date for Net Payment) Direct Assignment
0SPM_VENDOR(Vendor)
LIFNR(Account Number of Vendor orCreditor) Direct Assignment
0SPM_TCURR(Transaction Currency)
WAERS(Currency Key) Direct Assignment
0SPM_KF_DVT(Discount Transaction Value)
WSKTO(Cash discount amount indocument currency) Direct Assignment
0SPM_KF_IVR(Transaction Inventory Value)
WRBTR(Amount in documentcurrency), Direct Assignment
0FISCVARNT(Fiscal year variant)
FISCVAR(Fiscal year variant) Direct Assignment
0CURRENCY(Currency Key)
WAERS(Currency Key)
ROUTINE(reportingcurrency***)
0SPM_KF_IVL(Invoice Value)
WRBTR (Amount in documentcurrency), WAERS(CurrencyKey)BUDAT(Posting Date)
ROUTINE(reportingcurrency***)
0SPM_KF_DVL(Discount)
WSKTO(Cash discountamount in document currency),WAERS(Currency Key)BUDAT(Posting Date )
ROUTINE(reportingcurrency***)
0CLR_DOC_NO(Clearing Document) AUGBL(Clearing Document) Direct Assignment
0CLEAR_DATE(Clearing Date) AUGDT(Clearing Date) Direct Assignment
0SPM_CH_ITY (Vendor inventorytype)
1. Payables value (direct materials)
2. Days Payables(direct materialsbased on AnnualPurchase)
3. Days Payables(direct materialsbased on YTDPurchase)
4. Payables value (indirect materials)
5. Days payables(Indirect Materialsbased on AnnualPurchase)
6. Days payables(Indirect Materialsbased on YTDPurchase)
7. Payables value(other materials)
8. Days Payables (othermaterials based onAnnual Purchase)
9. Days Payables (othermaterials based onYTD Purchase)
40
Unavailable Dimensions: Dimension-based analysis for C2C and related KPIs are not availablefor the dimensions listed below, since although these dimensions are available in the BI data model,there is no corresponding data source field in the extractor, and therefore they are not available foranalysis once the extractors are used.
0SPM_CH_ITY (Vendor inventory type) 0SPM_PURGRP (Purchasing group) 0SPM_PURORG (Purchasing organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center) 0CO_AREA (Controlling area)
4.2 R/3 Details for Vendor Invoice Data
SAP R/3 Module: Finance (FI)
Transactions:
FB01 Creation of any type of FI document based on type and posting key.FB60 Vendor Invoice
Tables:
BSEG FI documents line item tableBSAK Cleared Vendor related FI documentsBSIK Open Vendor related FI documents
4.3 Extraction for Vendor Payment Data
Target DSO = 0SPM_DS29 (C2C Diagnostic Vendor Payment)Source Data Source = 0FI_AP_4
Note: For the table below, the aggregation type for the key figure upload is overwrite.
While taking the data in this DSO filter is done on the Document Type KZ (Vendor payment).
TARGET FIELD SOURCE FIELD Update Type IMPACTED KPIs
0SPM_COMP*(Company Code)
BUKRS(Company Code) Direct Assignment
0SPM_CH_RPN*(Receipt/Payment No.)
BELNR(Accounting Document Number) Direct Assignment
0INV_DOC_NO*(Invoice Number)
1. Average Days to Pay2. Average Days to Pay
within or on due datepayments
3. Average Days to Payoverdue Payments
0SPM_CH_IDT(Invoice Date)
41
0SPM_CH_DUE(Due Date)
4. Average PaymentOverdue Period
5. Payables Average pastdue
0SPM_CH_CDT(Collection/Payment Date) BUDAT(Posting Date) Direct Assignment
0SPM_VENDOR(Vendor)
LIFNR(Account Number of Vendor orCreditor) Direct Assignment
0SPM_TCURR(Transaction Currency)
WAERS(Currency Key) Direct Assignment
0SPM_KF_CAT(Collection/Payment TransactionAmount)
WRBTR(Amount in documentcurrency) Direct Assignment
0CURRENCY(Currency Key)
WAERS(Currency Key)
ROUTINE(reportingcurrency***)
0SPM_KF_CAM(Collection/Payment amount)
WRBTR(Amount in documentcurrency), WAERS(Currency Key),BLDAT(Posting Date)
ROUTINE(reportingcurrency***)
0CLR_DOC_NO(Clearing Document) AUGBL(Clearing Document) Direct Assignment
0CLEAR_DATE(Clearing Date) AUGDT(Clearing Date) Direct Assignment
Unavailable Dimensions: Dimension-based analysis for C2C and related KPIs is not available forthe dimensions listed below, since although these dimensions are available in the BI data model, there isno corresponding data source field in the extractor, and so they are not available for analysis once theextractors are used.
0SPM_PURGRP (Purchasing Group) 0SPM_PURORG (Purchasing Organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit centre) 0CO_AREA (Controlling area)
4.4 R/3 Details for Vendor Payment Data
SAP R/3 Module: Finance (FI)
Transactions:
FB01 Creation of any type of FI document based on type and posting key.
FB60 Vendor InvoiceF-31 Outgoing Payments
Tables:
BSEG FI documents line item table BSAK Cleared Vendor related FI documents BSIK Open Vendor related FI documents
42
5. C2C Receivables (Customer)
Cash To Cash Cycle Time - Receivables
BW
Sta
ging
Laye
rIn
boun
d La
yer
BW Data Source SCPMInbound DSO
Flat File (.csv format)R/3 Data Source
R/3
Dat
a So
urce
Laye
r
C2C DiagnosticsCustomer Invoice
0SPM_DS46
C2C DiagnosticsCustomer Receipt
0SPM_DS28
0FI_AR_4
5.15.3 5.5
C2C Diagnostics CustomerBad debts and Adjustments
0SPM_DS49
Filter Bad debts andAdjustments in DTP
Filter Invoicesin DTP
Filter ReceiptsDTP
Sections 5.1, 5.3 and 5.6 provide the mapping details required to upload the data into theC2C Receivables (Customer) staging layer.
5.1 Extraction for Customer Invoice Data
Target DSO = 0SPM_DS46 (C2CD Customer Invoice)Source Data Source = 0FI_AR_4
Note: For the table below, the aggregation type for the key figure upload is overwrite..
While taking the data in this DSO filter is done on the Document Type KR (Vendor invoice).
TARGET FIELD SOURCE FIELD Update Type
0INV_DOC_NO*(Invoice Number)
BELNR(Accounting Document Number) Direct Assignment
0SPM_COMP*(Company codec)
BUKRS(Company Code) Direct Assignment
43
0SPM_CH_DUE(Due Date)
NETDT(Due Date for Net Payment) Direct Assignment
0SPM_CH_IDT(Invoice Date)
BUDAT(Posting Date in the Document) Direct Assignment
0FISCVARNT(Fiscal year variant)
FISCVAR(Fiscal year variant) Direct Assignment
0SPM_CUST(Customer)
KUNNR(Customer Number 1) Direct Assignment
0SPM_TCURR(Transaction Currency)
WAERS(Currency Key) Direct Assignment
0SPM_KF_IVR(Transaction Inventory Value)
WRBTR(Amount) Direct Assignment
0SPM_KF_DVT(Discount Transaction Value)
WSKTO(Cash discount amount indocument currency) Direct Assignment
0CURRENCY(Currency Key)
WAERS(Currency Key) ROUTINE(reporting currency***)
0SPM_KF_IVL(Invoice Value)
WRBTR(Amount), WAERS(Currency Key),BUDAT(Posting Date) ROUTINE(reporting currency***)
0SPM_KF_DVL(Discount)
WSKTO(Cash discount amount indocument currency), WAERS(Currency Key),BUDAT(Posting Date) ROUTINE(reporting currency***)
0CLR_DOC_NO(Clearing Document) AUGBL(Clearing Document) Direct Assignment
0CLEAR_DATE(Clearing Date) AUGDT(Clearing Date) Direct Assignment
Unavailable Dimensions: Dimension-based analysis for C2C and related KPIs is not available forthe dimensions listed below, since although these dimensions are available in the BI data model, butthere is no corresponding data source field in the extractor, and for this reason they are not available foranalysis once the extractors are used.
0CO_AREA (Controlling area) 0SPM_DC (Distribution channel) 0SPM_DIV (Division) 0SPM_SALEMP (Sales representative) 0SPM_SALGRP (Sales group) 0SPM_SALOFF (Sales office) 0SPM_SALORG (Sales organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center)
5.2 R/3 Details for Customer Invoice Data
SAP R/3 Module: Finance (FI) Transactions:
FB01 Creation of any type of FI document based on type and posting key.
FB70 Customer Invoice
44
F-28 Incoming Payments
Tables:
BSEG FI documents line item tableBSAD Cleared Customer related FI documentsBSID Open Customer related FI documents
5.3 Extraction for Customer Receipt Data
Target DSO = 0SPM_DS28 (C2C Diagnostic Customer Receipt)Source Data Source = 0FI_AR_4
Note: For the table below, the aggregation type for the key figure upload is overwrite.
While taking the data in this DSO filter is done on the Document Type DZ (Customer payment)
TARGET FIELD SOURCE FIELD Update Type IMPACTED KPIs
0SPM_CH_RPN*(Receipt/Payment No)
BELNR(Accounting DocumentNumber) Direct Assignment
0SPM_COMP*(Company Code)
BUKRS(Company Code) Direct Assignment
0INV_DOC_NO*(Invoice Number)
1. Collection Period2. Collection Period Within
Due date payments3. Collection Period
overdue Payments4. Collection Overdue
Period5. Receivables Average
Days past Due
0SPM_CH_DUE(Due Date)
0SPM_CH_IDT(Invoice Date)
0SPM_CH_CDT(Collection/Payment Date)
BUDAT(Posting Date in theDocument) Direct Assignment
0FISCVARNT(Fiscal year variant)
FISCVAR(Fiscal year variant) Direct Assignment
0SPM_CUST(Customer)
KUNNR(Customer Number 1) Direct Assignment
0SPM_TCURR(Transaction Currency)
WAERS(Currency Key) Direct Assignment
0SPM_KF_CAT(Collection/Payment TransactionAmount)
WRBTR(Amount in documentcurrency), Direct Assignment
0CURRENCY(Currency Key)
WAERS(Currency Key)
ROUTINE(reportingcurrency***)
0SPM_KF_CAM(Collection/Payment amount)
WRBTR(Amount in documentcurrency), WAERS(Currency Key),BUDAT(Posting Date)
ROUTINE (currencyconversion**)
0CLR_DOC_NO(Clearing Document) AUGBL(Clearing Document) Direct Assignment
0CLEAR_DATE(Clearing Date) AUGDT(Clearing Date) Direct Assignment
45
Unavailable Dimensions: Dimension-based analysis for C2C and related KPIs will not be availablefor the dimensions listed below, since although these dimensions are available in the BI data model,there is no corresponding data source field in the extractor, and so they are not available for analysisonce the extractors are used.
0CO_AREA (Controlling area) 0SPM_DC (Distribution channel) 0SPM_DIV (Division) 0SPM_SALEMP (Sales representative) 0SPM_SALGRP (Sales group) 0SPM_SALOFF (Sales office) 0SPM_SALORG (Sales organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center)
5.4 R/3 Details for Customer Receipt Data
SAP R/3 Module: Finance (FI)
Transactions:
FB01 Creation of any type of FI document based on type and posting key
FB70 Customer InvoiceF-28 Incoming Payments
Tables:
BSEG FI documents line item table BSAD Cleared Customer related FI documents BSID Open Customer related FI documents
5.5 Extraction for Customer Adjustments and Bad debts Data.
Note: For the table below, the aggregation type for the key figure upload is overwrite.
While taking the data in this DSO filter is done on the Document Types DG, DA and Posting Keys11,16,06 (Customer adjustment and payments)
TARGET FIELD SOURCE FIELD Update Type Routine Logic IMPACTED KPIs0REFER_DOC(Document Numberfor referencedocument)
BELNR(AccountingDocumentNumber) Direct Assignment
0SPM_COMP*(Company Code)
BUKRS(Company Code) Direct Assignment
0DOC_DATE(Document Date)
BUDAT(Posting Date inthe Document) Direct Assignment
46
0FISCVARNT(Fiscal year variant)
FISCVAR(Fiscal yearvariant) Direct Assignment
0SPM_CUST(Customer)
KUNNR(CustomerNumber 1) Direct Assignment
0SPM_TCURR(TransactionCurrency)
WAERS(Currency Key) Direct Assignment
0SPM_KF_AVT(Adjustment - TR)
BLART(DocumentType),BSCHL(PostingKey),WAERS(Currency Key),WRBTR(Amountin documentcurrency), Routine
Update with DocumentAmount if thedocument isadjustment
0SPM_KF_BVT(Bad debt – TR)
BLART(DocumentType),BSCHL(PostingKey),WAERS(Currency Key),WRBTR(Amountin documentcurrency), Routine
Update with DocumentAmount if thedocument is bad debt
0CURRENCY(Currency Key)
WAERS(Currency Key)
ROUTINE(reportingcurrency***)
0SPM_KF_AVL(Adjustment)
BLART(DocumentType),BSCHL(PostingKey),WAERS(Currency Key),WRBTR(Amountin documentcurrency),BUDAT(PostingDate)
ROUTINE (currencyconversion**)
Update with Currencyconverted DocumentAmount if thedocument isadjustment
0SPM_KF_BDV(Bad debt)
BLART(DocumentType),BSCHL(PostingKey),WAERS(Currency Key),WRBTR(Amountin documentcurrency),BUDAT(PostingDate)
ROUTINE (currencyconversion**)
Update with CurrencyConverted DocumentAmount if thedocument is Bad debt
0CLR_DOC_NO(ClearingDocument)
AUGBL(ClearingDocument) Direct Assignment
0CLEAR_DATE(Clearing Date)
AUGDT(ClearingDate) Direct Assignment
Unavailable Dimensions: Dimension-based analysis for C2C and related KPIs will not be availablefor the dimensions listed below, since although these dimensions are available in the BI data model,there is no corresponding data source field in the extractor, and so they are not available for analysisonce the extractors are used.
0CO_AREA (Controlling area) 0SPM_DC (Distribution channel) 0SPM_DIV (Division) 0SPM_SALEMP (Sales representative) 0SPM_SALGRP (Sales group) 0SPM_SALOFF (Sales office)
47
0SPM_SALORG (Sales organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center)
5.6 R/3 Details of Customer Adjustments and Bad debts Data.
SAP R/3 Module: Finance (FI)
Transactions:
FB01 Creation of any type of FI document based on type and posting key
FB70 Customer InvoiceF-28 Incoming Payments
Tables:
BSEG FI documents line item table BSAD Cleared Customer related FI documents BSID Open Customer related FI documents
6. C2C Inventory
Cash To Cash Cycle Time - Inventory
BW
Sta
ging
Laye
rIn
boun
d La
yer
BW Data Source SCPMInbound DSO
Flat File (.csv format)R/3 Data Source
R/3
Dat
a So
urce
Laye
r
C2C Diagnostic InventoryWriteoffs
0SPM_DS34
C2C DiagnosticInventory
0SPM_DS17
Inventory Writeoff
C2C DiagnosisInventory Forecast
0SPM_DS43
Inventory Forecast
6.1.26.1.3
2LIS_03_BX 2LIS_03_BF 2LIS_03_UM
2LIS_04_P_MATNR
0IC_C03
0PP_C02
SAP deliveredStandard Cube
SAP deliveredStandard DSO
0CO_OM_OPA_6 2LIS_04_P_COMP 2LIS_04_P_ARBPL
0PP_DS030PP_O01
6.2 6.3Analysis Process6.1.1
48
Sections 6.1, 6.2 and 6.3 provide the mapping details required to upload the data into theC2C Inventory staging layer.
6.1 Extraction for Inventory Data
The data for C2C inventory-related fields is taken from SAP delivered business contentCubes 0IC_C03 and 0PP_C02. A C2C inventory needs information such as the quantityand value of raw materials, purchased finished goods, finished goods, finished goods inplant, finished goods outside plant, WIP inventory, and return goods. These values shouldbe captured along with the units or currencies they refer to respectively.
C2C Inventory values should be captured corresponding to the company code(0SPM_COMP)*, plant (0SPM_PLANT)*, inventory category (0SPM_CH_INC)*, material(0SPM_MTRL)*, calendar day (0CALDAY)*.
Further analyses can be carried out for the ABC item category (0SPM_CH_ITC), theinventory age bucket (0SPM_CH_AGE), fiscal year variant (0FISCVARNT), business area(0SPM_BUSAR), profit center (0SPM_PCTR), and controlling area (0CO_AREA), providedthese details are captured from the flat file.
6.1.1 Analysis Process
This is used to extract the As on date inventory balance from the Cube 0IC_C03 wrtRaw material, finished goods and returned goods to the Direct Update DSO0SPM_ST03 as we cannot have a direct transformation from Non-Cumulative cube0IC_C03.
6.1.2 Segregation of inventory balances into Raw material, finished goods etc.
This step segregates inventory balances captured in 0SPM_ST03 into Raw material,Finished Goods, Purchased Finished goods, Finished Goods in Plant, FinishedGoods outside plant and Returned Goods Inventories and quantities and theircurrency/unit conversion into Reporting currency/unit.
6.1.3 Capture Work In Progress
This step extracts Work in Progress inventory and quantity from 0PP_C02 cube andconverts them into their reporting currency/unit to update into SCPM inbound layer.
Scenario Dependency:
1. Cost Of Goods Sold C2C Inventory takes data from the annualized COGSvalue from the cost of goods sold scenario. If this is not captured, the inventory KPIswill be 0 with respect to COGS. Below is the list of KPIs which are not computed.
Inventory Days of Supply Based on Annual COGS Raw Material Inventory Days Based on Annual COGS WIP Inventory Days Based on Annual COGS Finished Goods Inventory Days Based on Annual COGS Finished Goods Inventory Days Plant Based on Annual COGS Finished Goods Inventory outside plant Days Plant Based on Annual COGS
49
Purchased Finished Goods Inventory Days Based on Annual COGS Returned Goods Inventory Days Based on Annual COGS
6.2 Extraction Inventory Write-off Data
The data for C2C Inventory write-off related fields is not available in the SAP ERPsystem, so the data can be loaded using a flat file. This mechanism is provided by SAPBusiness Objects Supply Chain Performance Management. Inventory write–off data isused in the calculation of C2C Inventory write-off KPI and the flat file contains thevalue for the same inventory write-offs – TR (0SPM_KF_IWT), or transaction currency(0SPM_TCURR), for example.
Inventory write-off detail captured in a flat file have to be captured using the correctcompany code (0SPM_COMP)* and reference document (0REFER_DOC)*.
Further analysis on the business area (0SPM_BUSAR), profit center (0SPM_PCTR),material (0SPM_MTRL) and plant (0SPM_PLANT) is also possible, provided thesedetails are captured from the flat file.
50
6.3 Extraction for Inventory Forecast Data
The data for C2C Inventory forecast related fields are not available in the SAP ERPsystem; so the data can be loaded using a flat file. This mechanism is provided bySAP Business Objects Supply Chain Performance Management.Inventory forecast data is used in the calculation of C2C inventory forecast demand /day.
The flat file contains values for forecast demand / day (transaction currency).This value should be captured using the corresponding company code(0SPM_COMP)*, plant (0SPM_PLANT)*, material (0SPM_MTRL)*, calendar day(0CALDAY)*. The Unit (0SPM_TUNIT) in which the forecast demand is measuredshould also be mentioned.
51
6.4 R/3 details for C2C Inventory data
Transactions:
ME21N/ME22N/ME23N To create/edit/display a Purchase OrderMIGO To create a Material Document (Goods
Receipt)
Tables:
MSEG Table that stores Material Document LineItems
MBEW Valuated Stocks
52
7. POFD Data Extraction
7.1 Extraction for Sales Return and Forecast
7.1.1 Extraction for Sales Return
Target: DSO = 0SPM_DS06 (Other Diagnostic-Sales Returns)Source: Data Source = 2LIS_11_VAITM
Note: For the table below, the aggregation type for the key figure upload is summation.
Process the Sales returns by determining through Sales document type (AUART) = RE.
TARGET FIELD SOURCE FIELD UPDATE TYPE
0REFER_DOC(Document number of the reference document ) *
VBELN (Sales document )
Direct Assignment
53
0REFER_ITM(Item number of the reference item ) *
POSNR(Sales document item )
Direct Assignment
0SPM_COMP(Company Code ) *
BUKRS (Company code )
Direct Assignment
0SPM_CUST(Customer )
KUNNR(Sold-to party )
Direct Assignment
0SPM_PLANT(Plant )
WERKS (Plant )
Direct Assignment
0SPM_SALGRP(Sales Group )
VKGRP (Sales Group )
Direct Assignment
0SPM_SALOFF(Sales office )
VKBUR(Sales Office )
Direct Assignment
0SPM_SALORG(Sales Organization )
VKORG (Sales Organization )
Direct Assignment
0SPM_DIV(Division )
SPART (Division )
Direct Assignment
0SPM_DC(Distribution Channel )
VTWEG (Distr. Channel )
Direct Assignment
0FISCVARNT(Fiscal year variant )
PERIV (Fiscal Year Variant )
Direct Assignment
0SPM_TUNIT(Transaction UOM )
VRKME (Sales unit )
Direct Assignment
0SPM_SALEMP(Sales Representative )
PVRTNR(Sales employee )
Direct Assignment
0SPM_KF_SVU(Sales Return Value (Transaction Unit) )
NETWR (Net value of the order item in document
currency ) , AUART (Sales DocumentType)
Routine
0SPM_KF_SRU(Sales Return -Quantity (Transaction Unit) )
KWMENG (Order quantity ), AUART (Sales
Document Type
Routine
0SPM_MTRL(Material )
MATNR(Material )
Direct Assignment
0CALDAY(Calendar Day )
ERDAT(Date on Which Record Was Created )
Direct Assignment
0SPM_TCURR (Transaction Currency ) WAERK
(Doc. Currency)Direct Assignment
0CURRENCY (Currency Key )
WAERK(Doc. Currency)
Routine(Reporting Currency***)
0UNIT (Unit of Measure )
VRKME (Sales unit )
Routine(reporting unit***)
0SPM_KF_SRQ(Sales Return Quantity )
KWMENG (Order quantity )
AUART (Sales Document Type) ,VRKME
(Sales unit )
Routine(unit conversion**)
0SPM_KF_SRV (Sales Return Value )
NETWR (Net value of the order item in document
currency), AUART (Sales DocumentType) , WAERS (Currency key)
Routine(Currency conversion**)
54
Unavailable Dimensions: Dimension-based analysis for POFD Sales Return and related KPIs isnot available for the dimensions listed below. Although these dimensions are available in the BI datamodel, there is no corresponding data source field in the extractor, so they are not available for analysisonce the extractors are used.
0SPM_BUSAR (Business area) 0SPM_PCTR (Profit centre) 0CO_AREA (Controlling area)
7.1.2 R/3 Details for Sales Return
SAP-R3 Module: Sales and Distribution (SD)
Transactions:
VA01/VA02/VA03 To create/edit/display a sales order
Tables:
VBAK Sales Order HeaderVBAP Sales Order Item
7.1.3 Extraction for Forecast
Forecast information is not available in the SAP ERP system; so that forecast data can be loaded using aflat file. The flat file upload mechanism is provided by SAP BusinessObjects Supply Chain PerformanceManagement. This file feeds the forecast information that is used in the forecast scenario. Theinformation provided through this flat file affects COGS data, as this information is used in COGS relatedKPI calculation.
Note: If the forecast data is not available, KPIs such as "forecast accuracy daily bucket", "forecastaccuracy weekly bucket", "forecast accuracy monthly bucket", "forecast bias %", "gross sales unit","gross sales revenue", "net sales unit", "net sales revenue", "planned demand fulfillment rate %", and"sales returns value as a % of gross sales revenue" cannot be calculated.
55
7.2 Extraction for Purchase Return, Goods Receipt and ASN
Sections 7.2.1, 7.2.1, 7.2.3 and 7.2.4 provide the mapping details required to upload the datainto the Purchase Return, Goods Receipt and ASN staging layer. The section marked in red isnew mapping and is not available in SCPM 1.0 system.
7.2.1 Extraction for Purchase Return
Target: DSO = 0SPM_DS07 (Other Diagnostic-Purchase Return)Source: Data Source = 2LIS_03_BF
Note: For the table below, the aggregation type for the key figure upload is summation.
56
TARGET FIELD SOURCE FIELD UPDATE TYPE
0REFER_DOC(Document number of the reference document )
MBLNR (Material Doc.) Direct Assignment
0CALDAY(Calendar Day )
BUDAT(Posting Date )
Direct Assignment
0FISCVARNT(Fiscal year variant )
PERIV(Fiscal Year Variant )
Direct Assignment
0SPM_PLANT(Plant )
WERKS(Plant )
Direct Assignment
0SPM_MTRL(Material )
MATNR(Material )
Direct Assignment
0SPM_COMP(Company Code )
BUKRS(Company Code )
Direct Assignment
0SPM_TUNIT(Transaction UOM )
MEINS(Base Unit )
Direct Assignment
0SPM_BUSAR(Business area )
GSBER(Business Area )
Direct Assignment
0SPM_PCTR(Profit centre )
PRCTR(Profit Center )
Direct Assignment
0SPM_VENDOR(Vendor )
LIFNR(Vendor )
Direct Assignment
0SPM_TCURR(Transaction Currency )
WAERS(Local Currency )
Direct Assignment
0SPM_KF_PRT(Purchase Return Quantity (Transaction Unit) )
BWMNG(BW: Quantity in Base Unit of Measure ),
BWART (Movement type),Routine
0SPM_KF_PRU(Purchase Return Value (Transaction Unit) )
BWGEO(BW: Cost Value in Local Currency ),
BWART (Movement type),Routine
0CURRENCY(Currency Key )
WAERS(Local Currency ) Routine(reporting Currency***)
0UNIT(Unit of Measure )
MEINS(Base Unit )
Routine (reporting unit***)
0CO_AREA(Controlling area )
KOKRSCO Area Direct Assignment
0SPM_KF_PRQ(Purchase Return Quantity )
BWMNG(BW: Quantity in Base Unit of Measure ),
BWART (Movement type), MEINS(Base Unit )
Routine (unit conversion**)
0SPM_KF_PRV(Purchase Return Value )
BWGEO(BW: Cost Value in Local Currency ),BWART (Movement type), WAERS
(Local Currency )
Routine (Currency conversion**)
Unavailable Dimensions: Dimension-based analysis for POFD Purchase Return and related KPIsis not available for the dimensions listed below, since although these dimensions are available in the BIdata model, there is no corresponding data source field in the extractor, so they are not available foranalysis once the extractors are used.
0SPM_PURORG (Purchasing Organization)
57
0SPM_PURGRP (Purchasing Group)
7.2.2 Extraction for Goods Receipt
7.2.2.1 Target: DSO = 0SPM_DS20 (Other Diagnostic-Goods Receipt)Source: Data Source = 2LIS_03_BFDelta Process = ABR1
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC /IMPLICATIONS IMPACTED KPIs
0REFER_DOC *( Document number
of the referencedocument )
EBELN(Purchasing
Document Number)Direct Assignment
0SPM_COMP*( Company Code )
BUKRS( Company Code ) Direct Assignment
0CALDAY( Calendar Day )
BUDAT( Posting Date ) Direct Assignment
0FISCVARNT( Fiscal year variant
)
PERIV( Fiscal Year Variant
)Direct Assignment
0SPM_PLANT( Plant )
WERKS( Plant ) Direct Assignment
0SPM_VENDOR( Vendor )
LIFNR( Account Number ofVendor or Creditor )
Direct Assignment
0SPM_MTRL( Material )
MATNR( Material Number ) Direct Assignment
0SPM_TCURR( Transaction
Currency )
WAERS( Currency Key ) Direct Assignment
0SPM_BUSAR( Business area )
GSBER( Business Area ) Direct Assignment
0SPM_PCTR( Profit centre )
PRCTR( Profit Center ) Direct Assignment
0SPM_STRLOC(Storage Location)
LGORT(Storage Location) Direct Assignment
0SPM_KF_GRT( Good Receipt
Value (TransactionUnit) )
BWGEO( BW: Cost Value inLocal Currency ),
BWART (Movementtype)
RoutineIf BWRAT = ‘101’ then0SPM_KF_GRV = BWGEO
0SPM_KF_AGT( Actual Good
Receipt Quantity(Transaction Unit) )
BWMNG( BW: Quantity in
Base Unit ofMeasure ), BWART
(Movement type)
Routine If BWRAT = ‘101’ then0SPM_KF_AGT = BWMNG
58
0SPM_KF_RVU( Rejected Quantity -Vendor (Transaction
Unit) )
BWMNG( BW: Quantity in
Base Unit ofMeasure ), BWART(Movement type),
Routine If BWRAT = ‘122’ then0SPM_KF_RVU = BWMNG
0SPM_KF_TDU( Transit Damage
Quantity(Transaction Unit) )
BWMNG( BW: Quantity in
Base Unit ofMeasure ), BWART
(Movement type)
Routine If BWRAT = ‘343’ then0SPM_KF_TDU = BWMNG
0CURRENCY( Currency Key )
WAERS( Currency Key )
Routine (reportingcurrency***)
0UNIT( Unit of Measure )
MEINS( Base Unit )
Routine (reportingunit***)
0SPM_TUNIT( Transaction UOM )
MEINS( Base Unit ) Direct Assignment
0CO_AREA( Controlling area )
KOKRS(Controlling Area ) Direct Assignment
0SPM_KF_GQT( Actual Good
Receipt Quantity )
BWMNG( BW: Quantity in
Base Unit ofMeasure ), BWART(Movement type),
MEINS(Base Unit )
MATNR( Material Number )
Routine (unitconversion**)
If BWRAT = ‘101’ then0SPM_KF_GQT = BWMNG
0SPM_KF_VRQ( Rejected Quantity )
BWMNG( BW: Quantity in
Base Unit ofMeasure ), BWART(Movement type),
MEINS(Base Unit )
MATNR( Material Number )
Routine (unitconversion**)
If BWRAT = ‘122’ then0SPM_KF_VRQ = BWMNG
0SPM_KF_TDQ( Transit Damage
Quantity )
BWMNG( BW: Quantity in
Base Unit ofMeasure ), BWART(Movement type),
MEINS(Base Unit )
MATNR( Material Number )
Routine (unitconversion**)
If BWRAT = ‘343’ then0SPM_KF_TDQ = BWMNG
0SPM_KF_GRV( Good Receipt
Value )
BWGEO( BW: Cost Value in
Local Currency )BWART (Movement
type), WAERS (Currency Key )
BUDAT(Posting Date)
Routine (currencyconversion**)
If BWRAT = ‘101’ then0SPM_KF_GRV = BWGEO
7.2.2.2 Target: DSO = 0SPM_DS20 (Other Diagnostic-Goods Receipt)Source: Data Source = 2LIS_02_ITMDelta Process = ABR
Note: For the table below, the aggregation type for the key figure upload is summation.
59
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC /IMPLICATIONS IMPACTED KPIs
0REFER_DOC *( Document number
of the referencedocument )
EBELN(Purchasing Document
Number)Direct Assignment
0SPM_PURORG(Purchasing
Organization)
EKORG(Purchasing
Organization)Direct Assignment
0SPM_PURGRP(Purchasing Group)
EKGRP(Purchasing Group) Direct Assignment
0SPM_SUPPLY(Goods Supplier) PWLIF
(Goods supplier) Direct Assignment
0SPM_CARIER(Carrier)
PLIEF(Vendor to whom partner
roles have beenassigned)
Direct Assignment
0SPM_KF_SGT( Scheduled GoodReceipt Quantity
(Transaction Unit) )
KTMNG(Target Quantity) Direct Assignment
0SPM_KF_SGQ( Scheduled GoodReceipt Quantity )
KTMNG(Target Quantity)
MEINS(Base Unit )
MATNR( Material Number )
Routine (unitconversion**)
0SPM_KF_GST( Gross PurchaseValue Transaction
Unit )
NETWR(Net order value in order
currency)Direct Assignment
0SPM_KF_GSP( Gross Purchase
Value )
NETWR(Net order value in order
currency)WAERS ( Currency Key )
BUDAT(Posting Date)
Routine (currencyconversion**)
0SPM_KF_ASU( ASN Schedule
DispatchQuantity(Transaction
Unit) )
CNFQTY(Confirmed Quantity) Direct Assignment
0SPM_KF_SQT( ASN Schedule
Dispatch Quantity )
CNFQTY(Confirmed Quantity)
MEINS(Base Unit )
MATNR( Material Number )
Routine (unitconversion**)
0CURRENCY( Currency Key )
WAERS( Currency Key )
Routine (reportingcurrency***)
0SPM_TCURR( TransactionCurrency )
WAERS( Currency Key ) Direct Assignment
0UNIT( Unit of Measure )
MEINS( Base Unit )
Routine (reportingunit***)
0SPM_TUNIT( Transaction UOM )
MEINS( Base Unit ) Direct Assignment
60
7.2.3 Extraction for ASN
7.2.3.1 Target: DSO = 0SPM_DS47 (Other Diagnostic-ASN) Source: Data Source = 2LIS_02_ITM
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC /IMPLICATIONS IMPACTED KPIs
0REFER_DOC *( Document number
of the referencedocument )
EBELN(Purchasing Document
Number)Direct Assignment
0SPM_COMP*( Company Code )
BUKRS( Company Code ) Direct Assignment
0FISCVARNT( Fiscal year variant )
PERIV( Fiscal Year Variant ) Direct Assignment
0SPM_PURORG(Purchasing
Organization)
EKORG(Purchasing
Organization)Direct Assignment
0SPM_PURGRP(Purchasing Group)
EKGRP(Purchasing Group) Direct Assignment
0SPM_SUPPLY(Goods Supplier) PWLIF
(Goods supplier) Direct Assignment
0SPM_MTRL( Material )
MATNR( Material Number ) Direct Assignment
0SPM_CH_GDT( GR Date )
BUDAT( Posting Date ) Direct Assignment
0SPM_VENDOR( Vendor )
LIFNR( Account Number ofVendor or Creditor )
Direct Assignment
0SPM_CARIER(Carrier)
PLIEF(Vendor to whom partner
roles have beenassigned)
Direct Assignment
0SPM_PLANT( Plant )
WERKS( Plant ) Direct Assignment
61
7.2.3.2 Target: DSO = 0SPM_DS47 (Other Diagnostic-ASN)Source: Data Source = 2LIS_02_CGR
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC /IMPLICATIONS IMPACTED KPIs
0REFER_DOC *( Document number
of the referencedocument )
EBELN(Purchasing Document
Number)Direct Assignment
0SPM_CH_ADT(Advance Shipment
Notice Date)
CNFDT(Delivery Date of Vendor
Confirmation)Direct Assignment
0SPM_KF_ANU(ASN DispatchQuantity – TR)
TTLQTY(Assigned Quantity) Direct Assignment
0SPM_KF_ASU(ASN Schedule
Dispatch Quantity –TR)
CNFQTY(Confirmed Quantity) Direct Assignment
0SPM_TUNIT( Transaction UOM )
MEINS( Base Unit ) Direct Assignment
7.2.3.3 Target: DSO = 0SPM_DS21 (Other Diagnostic - Advance Shipment Notice) Source: DSO = 0SPM_DS47 (Other Diagnostic – ASN)
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC /IMPLICATIONS IMPACTED KPIs
0REFER_DOC *( Document number
of the referencedocument )
0REFER_DOC *( Document number of
the reference document )Direct Assignment
0SPM_COMP*( Company Code )
0SPM_COMP*( Company Code ) Direct Assignment
0FISCVARNT( Fiscal year variant )
0FISCVARNT( Fiscal year variant ) Direct Assignment
0SPM_PURORG(Purchasing
Organization)
0SPM_PURORG(Purchasing
Organization)Direct Assignment
0SPM_PURGRP(Purchasing Group)
0SPM_PURGRP(Purchasing Group) Direct Assignment
0SPM_SUPPLY(Goods Supplier)
0SPM_SUPPLY (GoodsSupplier) Direct Assignment
62
0SPM_MTRL( Material )
0SPM_MTRL( Material ) Direct Assignment
0SPM_CH_GDT( GR Date )
0SPM_CH_GDT( GR Date ) Direct Assignment
0SPM_VENDOR( Vendor )
0SPM_VENDOR( Vendor ) Direct Assignment
0SPM_CARIER(Carrier)
0SPM_CARIER(Carrier) Direct Assignment
0SPM_PLANT( Plant )
0SPM_PLANT( Plant ) Direct Assignment
0SPM_CH_ADT(Advance Shipment
Notice Date)
0SPM_CH_ADT(Advance Shipment
Notice Date)Direct Assignment
0SPM_KF_ANU(ASN DispatchQuantity – TR)
0SPM_KF_ANU(ASN Dispatch Quantity
– TR)Direct Assignment
0SPM_KF_AQT(Actual ShipmentNotice Dispatch
Quantity)
0SPM_KF_ANU(ASN Dispatch Quantity
– TR)
0SPM_MTRL( Material )
0UNIT( Unit of Measure )
Routine (unitconversion**)
0SPM_KF_ASU(ASN Schedule
Dispatch Quantity –TR)
0SPM_KF_ASU(ASN Schedule Dispatch
Quantity – TR)Direct Assignment
0SPM_KF_SQT(ASN Schedule
Dispatch Quantity –TR)
0SPM_KF_ASU(ASN Schedule Dispatch
Quantity – TR)
0SPM_MTRL( Material )
0UNIT( Unit of Measure )
Routine (unitconversion**)
0SPM_KF_CTR(Counter for No. of
Records)
0REFER_DOC *( Document number of
the reference document )Routine COUNT (0REFER_DOC )
0SPM_KF_SPC(Source (Transfer)
Product Cycle Time)
0SPM_CH_ADT(Advance Shipment
Notice Date)
0SPM_CH_GDT( GR Date )
0SPM_KF_CTR(Counter for No. of
Records)
Routine
(0SPM_CH_GDT -0SPM_CH_ADT
) / 0SPM_KF_CTR
63
0UNIT( Unit of Measure )
0UNIT( Unit of Measure )
Routine (reportingunit***)
0SPM_TUNIT( Transaction UOM )
0SPM_TUNIT( Transaction UOM ) Direct Assignment
7.2.4 R/3 Details for Purchase Return/Goods Receipt/ASNSAP-R3 Module: Material Management (MM)
Transactions:
ME21N/ME22N/ME23N Create/Change/Display Purchase OrderMIGO Goods Receipt Purchase OrderMIRO Invoice against Goods Receipt
Tables:
MSEG Document Segment: MaterialMKPF Header: Material Document
64
7.3 Extraction for Production and Distribution
Sections 7.3.1, 7.3.1, 7.3.3 and 7.3.4 provide the mapping details required to upload the datainto the Production and Distribution staging layer. The section marked in red is new mappingand is not available in SCPM 1.0 system.
7.3.1 Extraction for Distribution
Target DSO = 0SPM_DS18 (Other diagnostic – distribution)Source Data Source = 2LIS_12_VCITM
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs
0REFER_DOC(Document number of
the referencedocument)
VBELN(Delivery document)
Direct Assignment
65
0FISCVARNT(Fiscal year variant)
PERIV(Fiscal Year Variant)
BUKRS(Company Code)
Direct Assignment
0SPM_COMP(Company Code)
BUKRS(Company code) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material)
Direct Assignment
0SPM_PCTR(Profit center)
PRCTR(Profit Centre) Direct Assignment
0CO_AREA(Controlling area)
KOKRS(CO Area) Direct Assignment
Included fromcommunication
structure
0SPM_TUNIT(Transaction UOM)
VRKME(Sales unit) Direct Assignment
0SPM_FRLOC(From Locations)
LSTEL(Loading Point) Direct Assignment
0SPM_TOLOC(To Locations)
ABLAD(Unloading Point) Direct Assignment
0SPM_CH_TMO(Transportation mode)
TRMTYP (Means Transp.) Direct Assignment
Included fromcommunication
structure
0CALDAY(Calendar Day)
ERDAT(Created on ) Direct Assignment
0UNIT(Unit of Measure)
VRKME(Sales unit) (Routine (reporting
unit***)
0SPM_BUSAR(Business area)
GSBER(Business Area) Direct Assignment
0SPM_CARIER(Carrier)
PSPDNR(Fwd Agent) Direct Assignment
0SPM_KF_ADU(Actual QuantityDelivered - TR)
LFIMG(Actual quantity
delivered (insales units))
VRKME(Sales Unit)
Direct Assignment
0SPM_KF_AQD(Plant FG Dispatches
Units)
LFIMG(Actual quantity
delivered (insales units))
VRKME(Sales Unit)
MATNR
Routine (unitconversion**)
66
(Material)
0SPM_KF_AQU(Actual Quantity
Delivered inValue - TR)
NETWR(Net Value)
WAERK(Currency
Included fromcommunication
structure
Direct Assignment
0SPM_KF_AQV(Plant FG Dispatches
Value)
NETWR(Net Value)
WAERK(CurrencyERDAT(Date) Routine (unit
conversion**)
0SPM_KF_DSQ(Distribution Schedule
Quantity)Not Available
0SPM_KF_DSU(Distribution Schedule
QuantityUnconstrained)
Not Available
Analysis for DistributionSchedule achievement
(Daily,Weekly and monthly)
Bucket isnot possible
0SPM_KF_DQT(Distribution Schedule
(Quantity) - TR)Not Available
0SPM_KF_DUT(Distribution Schedule
(Quantity)Unconstrained)
Not Available
Analysis for DistributionSchedule achievement
(Daily,Weekly and monthly)
Bucket isnot possible
0SPM_TCURR(Transaction
Currency)WAERK
(Doc. Currency)
Included fromcommunication
structure
Routine (reportingCurrency**)
Included fromcommunication
structure
Routine (reportingCurrency**)
0CURRENCY(Currency Key)
WAERK(Doc. Currency) Routine (reporting
Currency**)Routine (reporting
Currency**)
7.3.2 R/3 Details for Delivery Item Data
SAP R/3 Module:
Sales & Distribution (SD)
Transactions:
VT01N Create Delivery DocumentVT02N Change Delivery DocumentVT03N Display Delivery Document
67
Tables:
LIKP Delivery: Header DataLIPS Delivery: Item DataVBUK Sales Document: Header Status and Administrative DataVBUP Sales Document: Item Status
7.3.3 Extraction for Production
7.3.3.1 Target: DSO = 0SPM_DS70 (Other Diagnostic – Production - Intermediate)Source: Data Source = 2LIS_04_P_MATNR
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINELOGIC
IMPACTEDKPIs
0REFER_DOC(Document number of thereferencedocument)
AUFNR(Order Number) Direct Assignment
0SPM_COMP(Company Code)
BUKRS(Company code) Direct Assignment
0SPM_PLANT(Plant)
WERKS(Plant) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material Number) Direct Assignment
0SPM_TUNIT(Transaction UOM)
MEINS(Base Unit ofMeasure)
Direct Assignment
0SPM_KF_MTU(Manufacture Defects Quantity(Transaction Unit))
PAMNG(Scrap quantity ) Direct Assignment
0SPM_KF_SPT(Scheduled Production Quantity
(Transaction Unit))
PGMNG(Total planned order
quantity)Direct Assignment
0SPM_KF_ATU(Actual Production Quantity(Transaction Unit))
WEMNG(Quantity of goods
received)Direct Assignment
0CALDAY(Calendar Day)
BUDAT(Posting date) Direct Assignment
0FISCVARNT(Fiscal year variant) FISCVARNT Direct Assignment
0SPM_KF_MDQ(ManufacturingDefects (Quantity))
PAMNG(Scrap quantity )
Routine (unitconversion**)
0SPM_KF_SPQ(ScheduledProduction (Quantity))
PGMNG(Total planned order
quantity)
Routine (unitconversion**)
0SPM_KF_APQ(Actual Production(Quantity))
WEMNG(Quantity of goods
received)
Routine (unitconversion**)
0UNIT(Unit of Measure)MEINS
(Base Unit ofMeasure)
Routine (reporting unit***)
68
7.3.3.2 Target DSO = 0SPM_DS70 (Other Diagnostic – Production - Intermediate)Source Data Source = 0CO_PC_01
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTEDKPIs
0SPM_KF_ATV(Actual Production Value(TransactionUnit))
SWKFR(AMOUNTFX)
SMEFR( QUANTINFX )
CURRENCY(RSCURRENCY)
Routine
SWKFR(AMOUNTFX)
*SMEFR
( QUANTINFX )
0FISCVARNT(Fiscal year variant) FISCVARNT Direct Assignment
0CURRENCY(CurrencyKey) RSCURRENCY Routine (reporting
currency**)
0SPM_TCURR(TransactionCurrency) RSCURRENCY Direct Assignment
0SPM_COMP WERKS(Plant) Read Master Data
0SPM_VERSION VERSION(Version) Direct Assignment
0CO_AREA CO_AREA(CO Area) Direct Assignment
7.3.3.3 Target DSO = 0SPM_DS19 (Other Diagnostic – Production)Source DSO = 0SPM_DS70 (Other Diagnostic – Production - Intermediate)
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs0SPM_COMP
(Company Code)0SPM_COMP
(Company Code) Direct Assignment
0SPM_CH_PDN(Production Document
Number)
0SPM_CH_PDN(Production
Document Number)0FISCVARNT
(Fiscal year variant)0FISCVARNT
(Fiscal year variant) Routine*
0SPM_CH_C1(SCPM Custom Dimension 1)
0SPM_CH_C1(SCPM CustomDimension 1)
Direct Assignment
0SPM_CH_C2(SCPM Custom Dimension 2)
0SPM_CH_C2(SCPM CustomDimension 2)
Direct Assignment
0SPM_CH_C3(SCPM Custom Dimension 3)
0SPM_CH_C3(SCPM CustomDimension 3)
Direct Assignment
0SPM_CH_C4(SCPM Custom Dimension 4)
0SPM_CH_C4(SCPM CustomDimension 4)
Direct Assignment
0SPM_CH_C5(SCPM Custom Dimension 5)
0SPM_CH_C5(SCPM CustomDimension 5)
Direct Assignment
0SPM_CH_C6(SCPM Custom Dimension 6)
0SPM_CH_C6(SCPM CustomDimension 6)
Direct Assignment
0SPM_CH_C7(SCPM Custom Dimension 7)
0SPM_CH_C7(SCPM CustomDimension 7)
Direct Assignment
0SPM_CH_C8(SCPM Custom Dimension 8)
0SPM_CH_C8(SCPM Custom Direct Assignment
69
Dimension 8)0CALDAY
(Calendar Day)0CALDAY
(Calendar Day) Direct Assignment
0CURRENCY(Currency Key)
0CURRENCY(Currency Key) Direct Assignment
0SPM_TCURR(Transaction Currency)
0SPM_TCURR(Transaction
Currency)Direct Assignment
0SPM_KF_ATV(Actual Production Value –
TR)
0SPM_KF_ATV(Actual Production
Value – TR)Direct Assignment
0SPM_KF_APV(Production Value)
0CALDAY(Calendar Day)
0CURRENCY(Currency Key)
0SPM_KF_ATV(Actual Production
Value)0SPM_TCURR
(TransactionCurrency)
Routine (currencyconversion**)
0SPM_KF_MTU(Manufacture Defects Quantity
– TR)
0SPM_KF_MTU(Manufacture
Defects Quantity –TR)
Direct Assignment
0SPM_KF_MDQ(Manufacturing Defects
(Quantity))
0SPM_KF_MDQ(Manufacturing
Defects (Quantity))Direct Assignment
0SPM_KF_SPQ(Scheduled Production
(Quantity))
0SPM_KF_SPQ(ScheduledProduction(Quantity))
Direct Assignment
0SPM_KF_SPT(Scheduled Production
Quantity – TR)
0SPM_KF_SPT(Scheduled
Production Quantity– TR)
Direct Assignment
0SPM_KF_APQ(Production (Units))
0SPM_KF_APQ(Production (Units)) Direct Assignment
0SPM_KF_ATU(Actual Production (QTY) –
TR)
0SPM_KF_ATU(Actual Production
(QTY) – TR)Direct Assignment
0SPM_TUNIT(Transaction UOM)
0SPM_TUNIT(Transaction UOM) Direct Assignment
0UNIT(Unit of Measure)
0UNIT(Unit of Measure) Direct Assignment
0SPM_VERSON(Version)
0SPM_VERSON(Version) Direct Assignment
0SPM_BUSAR(Business area)
0SPM_BUSAR(Business area) Direct Assignment
0SPM_PCTR(Profit centre)
0SPM_PCTR(Profit centre) Direct Assignment
0CO_AREA(Controlling area)
0CO_AREA(Controlling area) Direct Assignment
70
7.3.4 SAP - R/3 Module: Production Planning (PP)Transactions:
CO01 Create Production OrderCO02 Change Production OrderCO03 Display Production Order
Tables:
AFKO Order Header data PP ordersAFPO Order Item
71
7.4 Extraction for Resource
7.4.1 Extraction of Work Center View Data
Target: DSO = 0SPM_DS23 (Other Diagnostic – Resource)Data Source = 2LIS_04_P_ARBPL
Note: For the table below, the aggregation type for the key figure upload is summation.
TARGET FIELD SOURCE FIELD UPDATE TYPE
72
0SPM_WRKCTR( Work Center/Resource )
ARBPL( Work center ) Direct Assignment
0CALDAY(Calendar Day)
BUDAT(Posting date) Direct Assignment
0SPM_COMP( Company Code )
BUKRS( Company Code ) Direct Assignment
0SPM_PLANT( Plant )
WERKS( Plant ) Direct Assignment
0SPM_KF_RET( Resource Downtime ) ANGEB ( Available capacity ),
I_DFZ (Actual execution time ) Routine
0SPM_KF_ARC( Actual Resource Consumption Time ) I_DFZ
( Actual execution time ) Direct Assignment
7.4.2 Extraction of Work Center Capacity Data
Target: DSO = 0SPM_DS23 (Other Diagnostic – Resource)Data Source = 0PP_WCCP
TARGET FIELD SOURCE FIELD
0SPM_WRKCTR( Work Center/Resource )
ARBPL( Work center ) Direct Assignment
0CALDAY(Calendar Day)
DATUB(Valid-to date) Direct Assignment
0SPM_COMP( Company Code )
WERKS( Plant )
Read master data from attribute of0PLANT
0SPM_PLANT( Plant )
WERKS( Plant ) Direct Assignment
0SPM_KF_TAT( Total Resource Available Time ) ANGEB ( Available capacity ) Direct Assignment
73
8. ODM Data Extraction
8.1 Extraction for Statistical Information
Sections from 8.1.1 to 8.1.16 provide the mapping details required to upload the data into theStatistical Information staging layer. This is a new mapping and is not available in SCPM 1.0system.
8.1.1 Target: DSO = 0SPM_DS71 (Other Diagnostic - StatisticalInformation - Master)
Source: Data Source = 0CUSTOMER_ATTR
Note: For the table below, the aggregation type for the key figure upload is overwrite.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs
0SPM_CUST(Customer)
KUNNR(Customer Number
1) Direct Assignment
74
0SPM_COMP(Company Code)
WERKS(Plant)
Read Master Data(0PLANT)
0SPM_PLANT(Plant)
(WERKS)Plant
Direct Assignment
0CALDAY(Calendar Day)
ERDAT(Posting Date)
Direct Assignment
0SPM_KF_ACU(No. of ActiveCustomers)
KUNNR(Customers)
AUFSD(Order Block)
CASSD(Sales Block)
FAKSD(Billing Block)
LIFSD(Delivery Block)
Routine
check KUNNR whereAUFSD - Order Block,CASSD - Sales Block,FAKSD - Billing Block,LIFSD - Delivery Block
are not NULL)Result = 1 else
Result = 0
8.1.2 Target: DSO = 0SPM_DS71 (Other Diagnostic - StatisticalInformation - Master)
Source: Data Source = 0CUST_SALES_ATTR
Note: For the table below, the analysis dimensions added for the key figure.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs
0SPM_CUST(Customer)
KUNNR(Customer Number
1)Direct Assignment
0SPM_DIV(Division)
SPART(Division)
Direct Assignment
0SPM_SALGRP(Sales Group)
VKGRP(Sales Group)
Direct Assignment
0SPM_SALOFF(Sales Office)
VKBUR(Sales Office)
Direct Assignment
0SPM_DC(Distribution Channel)
VTWEG(Distribution
Channel)Direct Assignment
0SPM_SALORG(Sales Organization)
VKORG(Sales Organization)
Direct Assignment
Unavailable Dimensions: Dimension-based analysis for the KPIs, No. Of Active Customersare not available for the dimensions listed below, since although these dimensions are availablein the BI data model, there is no corresponding data source field in the extractor, and thereforethey are not available for analysis once the extractors are used.
0SPM_PURGRP (Purchasing group) 0SPM_PURORG (Purchasing organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center) 0CO_AREA (Controlling area) 0SPM_SALEMP (Sales Representative) 0SPM_MTRL (Material) 0SPM_WRKCTR (Work Center/Resource) 0SPM_VENDOR (Vendor)
75
8.1.3 R/3 Details for Customer Master Data
SAP R/3 Module:
Logistics Master Data (LO-IO)
Transactions:
VD01 Create CustomerVD02 Change CustomerVD03 Display Customer
Tables:
KNA1 General Data in Customer MasterKNVV Customer Master Sales Data
8.1.4 Target: DSO = 0SPM_DS71 (Other Diagnostic - StatisticalInformation - Master)
Source: Data Source = 0MATERIAL_ATTR
Note: For the table below, the aggregation type for the key figure upload is overwrite.
TARGET FIELD SOURCE FIELD UPDATE TYPEROUTINE LOGIC IMPACTED
KPIs
0SPM_MTRL(Material)
MATNR(Material Number) Direct Assignment
0CALDAY(Calendar Day)
ERSDA(Posting Date) Direct Assignment
0SPM_VENDOR(Vendor)
MATNR(Material Number)
Read Master Data(0MATERIAL)
0SPM_KF_FGS(No. of FinishedGoods SKUs)
MATNR(Material Number)
MTART(Material Type)
Routine
(Check of entries in MATNRwhere MTART = FERT) Result =
1 else Result = 0
0SPM_KF_FGA(No. of Finished
Goods SKUs Active)
MATNR(Material Number)
MTART(Material Type)
Routine(Check of entries in MATNR
where MTART = FERTand LVORM <> 'X') Result = 1
else Result = 0
0SPM_KF_RMS(No. of RM SKUs)
MATNR(Material Number)
MTART(Material Type)
Routine
(Check of entries in MATNRwhere MTART = ROH) Result =
1 else Result = 0
0SPM_KF_RMA(No. of RM SKUs
Active)
MATNR(Material Number)
MTART(Material Type)
Routine
(Check of entries in MATNRwhere MTART = ROH and
LVORM <> 'X') Result = 1 elseResult = 0
(Number ofSupply Sources
per Item)
0SPM_KF_SFS(No. of Semi-finished
SKUs)
MATNR(Material Number)
MTART(Material Type)
Routine
(Check of entries in MATNRwhere MTART = HALB) Result =
1 else Result = 0
0SPM_KF_SFA(No. of Semi-finished
SKUs Active)
MATNR(Material Number)
MTART(Material Type)
Routine
(Check of entries in MATNRwhere MTART = HALB and
LVORM <> 'X') Result = 1 elseResult = 0
76
8.1.5 Target: DSO = 0SPM_DS71 (Other Diagnostic - StatisticalInformation - Master)
Source: Data Source = 0MAT_PLANT_ATTR
Note: For the table below, the analysis dimensions added for the key figure.
TARGET FIELD SOURCE FIELD UPDATE TYPEROUTINE LOGIC IMPACTED
KPIs
0SPM_MTRL(Material)
MATNR(Material Number) Direct Assignment
0SPM_COMP(Company Code)
WERKS(Plant)
Read Master Data(0PLANT)
0SPM_PLANT(Plant)
(WERKS)Plant
Direct Assignment
Unavailable Dimensions: Dimension-based analysis for the Material Master data relatedKPIs, are not available for the dimensions listed below, since although these dimensions areavailable in the BI data model, there is no corresponding data source field in the extractor, andtherefore they are not available for analysis once the extractors are used.
0SPM_CUST (Customer) 0SPM_DC (Distribution Channel) 0SPM_SALORG (Sales Organization) 0SPM_DIV (Division) 0SPM_PURGRP (Purchasing group) 0SPM_PURORG (Purchasing organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center) 0CO_AREA (Controlling area) 0SPM_SALGRP (Sales Group) 0SPM_SALOFF (Sales Office ) 0SPM_WRKCTR (Work Center/Resource) 0SPM_VENDOR (Vendor)
8.1.6 R/3 Details for Material Master Data
SAP R/3 Module:
Logistics Master Data (LO-IO)
Transactions:
MM01 Create MaterialMM02 Change MaterialMM03 Display Material
Tables:
77
MARA General Data in Material MasterMARC Plant Data for Material
8.1.7 Target: DSO = 0SPM_DS71 (Other Diagnostic - StatisticalInformation - Master)
Source: Data Source = 0VENDOR_ATTR
Note: For the table below, the analysis dimensions added for the key figure.
TARGET FIELD SOURCE FIELD UPDATE TYPEROUTINE LOGIC IMPACTED
KPIs
0SPM_VENDOR(Vendor)
LIFNR(Account Number Ofvendor or Creditor) Direct Assignment
0SPM_COMP(Company Code)
WERKS(Plant)
Read Master Data(0PLANT)
0SPM_PLANT(Plant)
(WERKS)Plant Direct Assignment
0SPM_KF_SSA(No. of Supply
Sources Active)
LIFNR(Account Number Ofvendor or Creditor)
SPERR(Posting Block)
SPERM(Purchasing Block)
SPERQ(Function Block)
Routine
(check LIFNR where SPERR -Posting Block, SPERM -
Purchasing Blockand SPERQ - Function Block arenot NULL) Result = 1 else Result
= 0
(Number ofSupply Sources
per Item)
Unavailable Dimensions: Dimension-based analysis for the Vendor Master data relatedKPIs, are not available for the dimensions listed below, since although these dimensions areavailable in the BI data model, there is no corresponding data source field in the extractor, andtherefore they are not available for analysis once the extractors are used.
0SPM_CUST (Customer) 0SPM_DC (Distribution Channel) 0SPM_SALORG (Sales Organization) 0SPM_DIV (Division) 0SPM_PURGRP (Purchasing group) 0SPM_PURORG (Purchasing organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center) 0CO_AREA (Controlling area) 0SPM_SALGRP (Sales Group) 0SPM_SALOFF (Sales Office ) 0SPM_WRKCTR (Work Center/Resource) 0SPM_MTRL (Material)
8.1.8 R/3 Details for Vendor Master Data
78
SAP R/3 Module:
Material Master Data (MM-IO)
Transactions:
XK01 Create VendorXK02 Change VendorXK03 Display Vendor
Tables:
LFA1 General Data in Vendor Master
8.1.9 Target: DSO = 0SPM_DS24 (Other Diagnostic - StatisticalInformation)
Source: Data Source = 2LIS_11_VAITM
Note:
For the table below, the aggregation type for the key figure upload is overwrite.
Field GSBER (Business Area) has been added from its communication structure.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs0REFER_DOC *
(Document number ofthe referencedocument)
VBELN(Document Number) Direct Assignment
0SPM_CUST(Customer)
KUNNR(Customer Number
1) Direct Assignment
0SPM_DIV(Division)
SPART(Division) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material Number) Direct Assignment
0SPM_PLANT(Plant)
(WERKS)Plant Direct Assignment
0CALDAY(Calendar Day)
ERDAT(Created On) Direct Assignment
0FISCVARNT(Fiscal year Variant)
(PERIV)Fiscal Year Variant
BUKRS(Company Code)
Direct Assignment
0SPM_SALGRP(Sales Group)
VKGRP(Sales Group) Direct Assignment
0SPM_SALOFF(Sales Office)
VKBUR(Sales Office) Direct Assignment
0SPM_SALEMP(Sales
Representative)PVRTNR
(Sales Employee) Direct Assignment
0SPM_DC(Distribution Channel)
VTWEG(Distribution
Channel) Direct Assignment
79
0SPM_SALORG(Sales Organization)
VKORG(Sales Organization) Direct Assignment
0SPM_COMP(Company Code)
BUKRS(Company Code) Direct Assignment
0SPM_BUSAR(Business Area)
GSBER(Business Area) Direct Assignment
0SPM_KF_COR(No. of Customer
Order) - Constant Value = 1 for each Salesdocument
Unavailable Dimensions: Dimension-based analysis for the KPIs, No. Of Customers Ordersare not available for the dimensions listed below, since although these dimensions are availablein the BI data model, there is no corresponding data source field in the extractor, and thereforethey are not available for analysis once the extractors are used.
0SPM_PURGRP (Purchasing group) 0SPM_PURORG (Purchasing organization) 0SPM_PCTR (Profit center) 0CO_AREA (Controlling area) 0SPM_WRKCTR (Work Center/Resource) 0SPM_VENDOR (Vendor)
8.1.10 R/3 Details for Sales Document Item Data
SAP R/3 Module:
Sales & Distribution (SD)
Transactions:
VA01 Create Sales OrderVA02 Change Sales OrderVA03 Display Sales Order
Tables:
VBAK Sales Document Header DataVBAP Sales Document Item DataVBKD Sales Document: Business DataVBUK Sales Document: Header Status and Administrative DataVBUP Sales Document: Item Status
8.1.11 Target: DSO = 0SPM_DS24 (Other Diagnostic - StatisticalInformation)
Source: Data Source = 2LIS_02_HDR
80
Note:
For the table below, the aggregation type for the key figure upload is overwrite.
Fields BUKRS (Business Area) and KUNNR (Customer) has been added fromits communication structure.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs0REFER_DOC *
(Document number ofthe referencedocument)
EBELN(Document Number) Direct Assignment
0CALDAY(Calendar Day)
BUDAT(Posting date) Direct Assignment
0SPM_PURGRP(Purchasing Group
EKGRP(Purchasing Group) Direct Assignment
0SPM_VENDOR(Vendor)
LIFNR(Account Number Ofvendor or Creditor) Direct Assignment
0SPM_CUST(Customer)
KUNNR(Customer Number 1) Direct Assignment
0FISCVARNT(Fiscal year Variant)
PERIV(Fiscal Year Variant)
BUKRS(Company Code)
Direct Assignment
0SPM_PLANT(Plant)
LIFNR(Vendor)
Read Master Data Read Master Data from0VENDOR
0SPM_COMP(Company Code)
BUKRS(Company Code) Direct Assignment
0SPM_PURGRP(Purchasing Group
EKGRP(Purchasing Group) Direct Assignment
0SPM_KF_PINNo. of Purchase
Invoices
ARECH(No. of invoices for
Vendors) Direct Assignment
Unavailable Dimensions: Dimension-based analysis for the KPIs, No. of Purchase Invoices,are not available for the dimensions listed below, since although these dimensions are availablein the BI data model, there is no corresponding data source field in the extractor, and thereforethey are not available for analysis once the extractors are used.
0SPM_DC (Distribution Channel) 0SPM_SALORG (Sales Organization) 0SPM_DIV (Division) 0SPM_PURORG (Purchasing organization) 0SPM_BUSAR (Business area) 0SPM_PCTR (Profit center) 0CO_AREA (Controlling area) 0SPM_SALGRP (Sales Group) 0SPM_SALOFF (Sales Office ) 0SPM_WRKCTR (Work Center/Resource)
81
8.1.12 R/3 Details for Purchasing Data
SAP R/3 Module:
Material Management (MM)
Transactions:
ME21 Create Purchase OrderME22 Change Purchase OrderME23 Display Purchase Order
Tables:
EKKO Purchasing Document HeaderEKPA Partner Roles in Purchasing
8.1.13 Target: DSO = 0SPM_DS24 (Other Diagnostic - StatisticalInformation)
Source: Data Source = 2LIS_12_VCITM
Note: For the table below, the aggregation type for the key figure upload is overwrite.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs0REFER_DOC *
(Document number ofthe referencedocument)
VBELN(Document Number) Direct Assignment
0SPM_SALORG(Sales Organization)
VKORG(Sales Organization) Direct Assignment
0SPM_COMP(Company Code)
BUKRS(Company Code) Direct Assignment
0CALDAY(Calendar Day)
ERDAT(Posting date) Direct Assignment
0FISCVARNT(Fiscal year Variant)
PERIV(Fiscal Year Variant)
BUKRS(Company Code) Direct Assignment
0SPM_PLANT(Plant)
(WERKS)Plant Direct Assignment
0SPM_VENDOR(Vendor)
LIFNR(Account Number Ofvendor or Creditor) Direct Assignment
0SPM_SALGRP(Sales Group)
VKGRP(Sales Group) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material Number) Direct Assignment
0SPM_CUST(Customer)
KUNNR(Customer Number 1) Direct Assignment
0SPM_SALOFF(Sales Office)
VKBUR(Sales Office) Direct Assignment
82
0SPM_SALEMP(Sales
Representative)PVRTNR
(Sales Employee) Direct Assignment
0SPM_DC(Distribution Channel)
VTWEG(Distribution Channel) Direct Assignment
0SPM_DIV(Division)
SPART(Division) Direct Assignment
0SPM_BUSAR(Business Area)
GSBER(Business Area) Direct Assignment
0CO_AREA(Controlling Area)
KOKRS(Controlling Area) Direct Assignment
0SPM_KF_SDE(No. of SalesDeliveries)
-Constant Value = 1 for each
document
Unavailable Dimensions: Dimension-based analysis for the KPI, No. Of Sales Deliveriesare not available for the dimensions listed below, since although these dimensions are availablein the BI data model, there is no corresponding data source field in the extractor, and thereforethey are not available for analysis once the extractors are used.
0SPM_PURGRP (Purchasing group) 0SPM_PURORG (Purchasing organization) 0SPM_PCTR (Profit center) 0SPM_WRKCTR (Work Center/Resource)
8.1.14 R/3 Details for Delivery Item Data
SAP R/3 Module:
Sales & Distribution (SD)
Transactions:
VT01N Create Delivery DocumentVT02N Change Delivery DocumentVT03N Display Delivery Document
Tables:
LIKP Delivery: Header DataLIPS Delivery: Item DataVBUK Sales Document: Header Status and Administrative DataVBUP Sales Document: Item Status
8.1.15 Target DSO = 0SPM_DS24 (Other Diagnostic - StatisticalInformation)
Source Data Source = 2LIS_13_VDITM
83
Note:
For the table below, the aggregation type for the key figure upload is overwrite.
Field GSBER (Business Area) has been added from its communication structure.
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs0REFER_DOC *
(Document number ofthe referencedocument)
VBELN(Document Number) Direct Assignment
0SPM_SALORG(Sales Organization)
VKORG(Sales Organization) Direct Assignment
0SPM_COMP(Company Code)
BUKRS(Company Code) Direct Assignment
0CALDAY(Calendar Day)
ERDAT(Posting date) Direct Assignment
0FISCVARNT(Fiscal year Variant)
PERIV(Fiscal Year Variant)
BUKRS(Company Code) Direct Assignment
0SPM_CUST(Customer)
KUNAG(Customer No.) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material Number) Direct Assignment
0SPM_PLANT(Plant)
(WERKS)Plant Direct Assignment
0SPM_DIV(Division)
SPART(Division) Direct Assignment
0SPM_BUSAR(Business Area)
GSBER(Business Area) Direct Assignment
0SPM_SALEMP(Sales
Representative)PVRTNR
(Sales Employee) Direct Assignment
0SPM_SALGRP(Sales Group)
VKGRP(Sales Group) Direct Assignment
0SPM_SALOFF(Sales Office)
VKBUR(Sales Office) Direct Assignment
0SPM_DC(Distribution Channel)
VTWEG(Distribution Channel) Direct Assignment
0SPM_KF_SIN(No. of Sales Invoices)
- ConstantValue = 1 for each
document
0SPM_KF_POW(No. of Units of Power
consumption) Not Available0SPM_KF_SSA( No. of SupplySources Active)
Not available
(Number of SupplySources per Item)
Cannot be computed
Unavailable Dimensions: Dimension-based analysis for the KPI, No. Of Sales Invoices arenot available for the dimensions listed below, since although these dimensions are available inthe BI data model, there is no corresponding data source field in the extractor, and thereforethey are not available for analysis once the extractors are used.
84
0SPM_PURGRP (Purchasing group) 0SPM_PURORG (Purchasing organization) 0SPM_PCTR (Profit center) 0SPM_WRKCTR (Work Center/Resource) 0SPM_VENDOR (Vendor)
8.1.16 R/3 Details for Billing Document Item Data
SAP R/3 Module:
Sales & Distribution (SD)
Transactions:
VF01 Create Billing DocumentVF02 Change Billing DocumentVF03 Display Billing Document
Tables:
VBRK Billing Document: Header DataVBRP Billing Document: Item DataVBUK Sales Document: Header Status and Administrative DataVBUP Sales Document: Item Status
85
9. OFCT Data Extraction
Sections from 9.1 to 9.5 provide the mapping details required to upload the data into the OFCTstaging layer. This is a new mapping and is not available in SCPM 1.0 system.
9.1 Target DSO = 0SPM_DS33 Source Data Source = 2LIS_11_VAITM
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs
86
0SPM_COMP*(Company Code)
BUKRS(Company Code) Direct Assignment
0DOC_NUMBER*(Sales document)
VBELN(Sales Document) Direct Assignment
0S_ORD_ITEM*(Sales documentitem)
POSNR(Item) Direct Assignment
0FISCVARNT(Fiscal year variant)
BUKRS(Company Code)
PERIV(Fi.Year Variant)
Routine
0SPM_SALEMP(SalesRepresentative)
PVRTNR(Sales employee) Direct Assignment
0SPM_CH_COR(Customer OrderReceive Date)
ERDAT (Created on) Direct Assignment
0SPM_CH_COT(Customer OrderReceive Time)
ERZET(Time) Direct Assignment
9.2 Target DSO = 0SPM_DS72 Source Data Source = 2LIS_04_P_MATNR
0SPM_COMP*(Company Code)
BUKRS(Company Code) Direct Assignment
0DOC_NUMBER*(Sales document)
KDAUF(Sales Order) Direct Assignment
0S_ORD_ITEM*(Sales document item)
KDPOS(Sales ord. item) Direct Assignment
0CALDAY(Calendar Day)
BUDAT(Posting date) Direct Assignment
0SPM_MTRL(Material)
MATNR(Material) Direct Assignment
0SPM_PLANT(Plant)
WERKS(Plant) Direct Assignment
0SPM_MTART(Material type)
MATNR(Material)
Read Master Data ofMaterial
0SPM_CH_MSD(Manufacturing StartDate (Earliest StartDate))
GSTRI(Actual start) Direct Assignment
0SPM_CH_RFP(Release Date ofFinished Product toStorage Location)
BUDAT(Posting date) Direct Assignment
0SPM_CH_SPS(Schedule ProductionActivities Start Date)
GSTRS(Sched. start) Direct Assignment
87
0SPM_CH_SPE(Schedule ProductionActivities End Date)
GLTRS(Sched. finish) Direct Assignment
0SPM_CH_PS(Production StartDate)
GSTRI(Actual start) Direct Assignment
0SPM_CH_PE(Production End Date(Production OrderConfirmation Date))
GETRI(Actual Finish) Direct Assignment
0SPM_CH_SFS(Stage FinishedProduct Start Date)
GSTRI(Actual start) Direct Assignment
0SPM_CH_SFE(Stage FinishedProduct End Date)
BUDAT(Posting date) Direct Assignment
0SPM_CH_RT(Release Time ofFinished Product toStorage Location)
GEUZI(Actual finish) Direct Assignment
Included fromcommunication
structure
0SPM_CH_SPT(Schedule ProductionActivities Start Time)
GSUZS(SchedStartTime) Direct Assignment
Included fromcommunication
structure
0SPM_CH_SET(Schedule ProductionActivities End Time)
GLUZS(Finish time) Direct Assignment
Included fromcommunication
structure
0SPM_CH_PRT(Production StartTime)
GSUZI(ActualStart) Direct Assignment
Included fromcommunication
structure0SPM_CH_PRE(Production End Time(Production OrderConfirmation Time))
GEUZI(Actual finish) Direct Assignment
Included fromcommunication
structure
0SPM_CH_SFT(Stage FinishedProduct Start Time)
GSUZI(ActualStart) Direct Assignment
Included fromcommunication
structure
0SPM_CH_SED(Stage FinishedProduct End Time)
GEUZI(Actual finish) Direct Assignment
Included fromcommunication
structure
9.3 Target DSO = 0SPM_DS33 Source DSO = 0SPM_DS72
TARGET FIELD SOURCE FIELD UPDATE TYPE ROUTINE LOGIC IMPACTED KPIs
0SPM_CH_SFE(Stage Finished Product
End Date)
0SPM_CH_SFE
0SPM_MTART (MaterialType)
Routine
Copy0SPM_CH_SFE
where Material type(0SPM_MTART) =
FERT
0SPM_CH_RFP (ReleaseDate of Finished Productto Storage Location)
0SPM_CH_RFP
0SPM_MTART (MaterialType) Routine
Copy0SPM_CH_RFPwhere Material type(0SPM_MTART) =FERT
88
9.4 Target DSO = 0SPM_DS73 Source Data Source = 2LIS_08TRTLP
0SPM_COMP*(Company Code)
BUKRS(Company Code)
Direct Assignment
Included fromcommunicationstructure
0REFER_ITM*(Item number of thereference item)
POSNR(Item) Direct Assignment
0REFER_DOC*(Document number ofthe referencedocument)
VBELN(Delivery) Direct Assignment
0SPM_DIV(Division)
SPART(Division) Direct Assignment
0SPM_DC(Distribution Channel)
VTWEG(Distr. Channel) Direct Assignment
0SPM_SALOFF(Sales Office)
VKBUR(Sales Office) Direct Assignment
0SPM_CH_ODC(Order Delivered atCustomer Place Date)
DATEN(Act.ShipmentEnd) Direct Assignment
0SPM_CH_MST(Manufacturing ShipDate of STO)
DATBG(CurrShipmtStart) Direct Assignment
0SPM_CH_COW(Customer OrderReceive Date atWarehouse)
DATEN(Act.ShipmentEnd)
SHTYP(Shipment type) Routine
0SPM_CH_COS(Customer OrderShipment Date atWarehouse)
DATBG(CurrShipmtStart) Direct Assignment
0SPM_CH_ODT(Order Delivered atCustomer Place Time)
UATEN(ActShipmtEndTim) Direct Assignment
Included fromcommunicationstructure
0SPM_CH_CST(Customer OrderShipment Time atWarehouse)
UATBG(ActTranspStrtTm) Direct Assignment
Included fromcommunicationstructure
9.5 Target DSO = 0SPM_DS73 Source Data Source = 2LIS_13_VDITM
0SPM_COMP*(Company Code)
BUKRS(Company Code)
Direct Assignment0REFER_ITM*(Item number of thereference item)
POSNR(Item) Direct Assignment
0REFER_DOC*(Document number ofthe referencedocument)
VBELN(Sales Document) Direct Assignment
89
0S_ORD_ITEM(Sales document item)
AUPOS(Item) Direct Assignment
0DOC_NUMBER(Sales document)
AUBEL(Sales Document) Direct Assignment
0SPM_CH_INT(Invoice Date)
ERDAT(Created on) Direct Assignment
0SPM_CH_ITT(Invoice Time)
ERZET(Time) Direct Assignment
10. Global Section
10.1 Reporting CurrencyThe reporting currency of an organization is the currency in which an organizationcarries out all its business. The need for maintaining a reporting currency arisesfrom the fact that all the business of an organization needs to be carried out using acommon currency, irrespective of the various transaction values uploaded fromdifferent sources. Similarly, any amount field in the SAP BusinessObjects SupplyChain Performance Management application has two values associated with it, thatis, the transaction currency value and the reporting currency value.
The transaction currency value is the amount that is entered by the enduser, along with a currency, which is the transaction currency.
The reporting currency value is the amount value in terms of the reportingcurrency maintained by the organization.
The transaction currency is uploaded into the data model for conversion along withthe transaction value. As a prerequisite to the conversion of values from onecurrency to another, the currency itself has to be converted from transaction toreporting. This is what is done in the reporting currency conversion.
As an example, a multinational corporation functioning worldwide can have theamount fields maintained in many currencies, all over the world, such as the Euro,INR, USD. However, the reporting currency of the organization must be maintainedin one common currency, for example, the Euro.
10.2 Reporting UnitThe reporting unit of an organization is the unit in which an organization carries outall its business. The need for maintaining a reporting unit arises from the fact that allthe business done by an organization needs to be in carried out using one commonunit, irrespective of the various transaction values uploaded from different sources.Any quantity field in the SAP Business Objects Supply Chain PerformanceManagement application has two values associated with it, the transaction unit valueand the reporting unit value.
The transaction unit value is the quantity entered by the end user, along witha unit, which is the transaction unit.
The reporting unit value is the quantity value in terms of the reporting unitmaintained by the organization.
The transaction unit is uploaded into the data model for conversion along with thetransaction quantity. As a prerequisite to the conversion of quantity from one unit to
90
another, the unit itself has to be converted from transaction to reporting. This iswhat is done in the reporting unit conversion.
10.3 Currency ConversionAs mentioned above, all the transaction amount values entered into the systemneed to be maintained in one common currency, the reporting currency. This isachieved by performing the currency conversion of that transaction value into thereporting currency value. A conversion factor from the transaction currency to thereporting currency is maintained in the table TCURR, the exchange rate table. Thisconversion factor is then used to accomplish the currency conversion.
10.4 Unit ConversionAs mentioned above, all the transaction quantity values that are entered into thesystem need to be maintained in one common unit, the reporting unit. This isachieved by performing the unit conversion of that transaction quantity into thereporting quantity value. The conversion factor from the transaction unit to thereporting unit is maintained in a DSO, the reporting unit DSO. This conversion factoris then used to accomplish the unit conversion.