Integrated Analytics Of Sap Crm Sales And Erp Sd-Books Pdf

Integrated Analytics of SAP CRM Sales and ERP SD
14 Dec 2019 | 46 views | 0 downloads | 5 Pages | 433.27 KB

Share Pdf : Integrated Analytics Of Sap Crm Sales And Erp Sd

Download and Preview : Integrated Analytics Of Sap Crm Sales And Erp Sd


Report CopyRight/DMCA Form For : Integrated Analytics Of Sap Crm Sales And Erp Sd



Transcription

Qord the total number of ERP sales orders that converted from ERP quotations. As a solution following are the two options presented below to implement the BW integration of the. CRM and SD content to get all the dashboards working. Option 1 In the query layer we can create a multi provider with the CRM and SD InfoP 5 Followed. by creating a new query with all the necessary fields and form a new dashboard component linked with all. the new queries, Option 2 In the data load we mapped the SD data directly into the CRM InfoP as part of the data load. In comparison a set of dashboards have been created and we don t need to create a new query and a new. dashboard component in BW Here we choose option 2 and by using the existing queries and dashboards. components the reports in CRM Sales scenario will show quotations and orders related information to the. decision makers, 1 1 Possible Solutions to Data Load Process. There are three different options of loading data in SAP BW The data sources delivered as part of. Business Content which is based on the old data flow technology 7 0 Datasource To allow for an easy. migration path SAP has provided a technique to use the 3 x Datasource at the start of a new extraction. transfer and load process The purpose for this is to design and build a new data flow without migrating to. 3 x Datasource immediately The recommendation if possible is to avoid using this technique 3 x. Datasource emulation in productive mode as it meant as design time feature allowing for easy migration of. data flows to the new technology 6 7, 1 2 Option 1 New Data Flow from SD Datasource DS to CRM content. The best solution is to create new transformations from the DS to the CRM InfoCubes InfoC here we. don t need to load data to SD InfoC but we need the DSs which are delivered as a part of Business Content. based on the new data flow technology Option 1 is shown in Fig 1. 1 3 Option 2 Old Data Flow, Another solution is to create the data flow based on the old technology transfer rules infosources and. update rules but this data flow will only be valid till the DS migration Option 2 is shown in Fig 2. 1 4 Option 3 New Data Flow from SD InfoP to CRM content. This solution is to load the data from the SD InfoP to the CRM InfoP Using this data flow we can use a. standard transformation and it will be independent of the DS migration Option 3 is shown in Fig 3. The use of transformations simplifies the maintenance of rules for cleaning and consolidating data. Instead of two rules transfer rules and update rules as in the past only the transformation rules are still in. need The transformation rule can be edited on an interactive GUI Transformations also provide additional. functionalities such as quantity conversion and the option to create an end routine or expert routine As a. comparison the option 3 is selected as a solution to integrate CRM sales opportunity and ERP QSO. Fig 1 Option 1 Fig 2 Option 2, Fig 3 Option 3 Fig 4 Data flow from ERP SD to CRM Content.
2 New Data Flow from ERP SD to CRM Content, The Fig 4 displays the data flow from SD used in order to populate the CRM cubes for SO 0CSAL C03. and Quotations from SO 0CSAL C05 0CSAL C03 is an InfoC which delivers information related to SO. It provides data on the quantities and values of SO in total as well as individual items It enables decision. makers to see status details such as open delivered billed or delayed and thus provides information for. pipeline figures as well as incoming and open orders 0CSAL C05 InfoC delivers data related to quotations. Decision makers can use this data for analyzing what happens to quotations in the sales organization or for. certain customers As well as providing general data such as quotation validity periods quantity and value. of quotation items it also enables decision makers to monitor the progress of quotations by delivering data. on quotation statuses, SD InfoSource InfoS 2LIS 11 VAITM needs to be activated in SAP BW In SAP BW data flow a. custom Data Store Object DSO is created DSO is another primary physical database storage object besides. InfoC DSO is designed to store every detailed transaction level records Most of the time summarized and. aggregated data provided by DSO are needed while InfoC are the primary objects used to support BW. queries for long periods In Table 1 fields of the custom DSO are listed. Table 1 Files of Customer DSO, Description Info objects. Key Fields Sales document 0DOC NUMBER, Sales document item 0S ORD ITEM. Description Info objects, Data fields, Bill to party 0BILLTOPRTY.
Billing block in SD document 0BILL BLOCK, Company code 0COMP CODE. By using updated rules the custom DSO is mapped to InfoS 2LIS 11 VAITM The key step of. integrating ERP SD QSO to CRM sales is the mapping of custom DSO to DSO 0CRM SALO and. 0CRM QUTO through transformations Table 2 3 8 In BW these two DSOs through data transfer. process the integrated data are stored at CRM InfoC 0CSAL C03 and 0CSAL C05 A set of pre defined. dashboards will show sales cycle with ERP QSO based on two InfoC. Table 2 Mapping table for transformation between custom DSO to 0CRM QUTO. Target fields Description Rules Type Source Fields Comments. 0BP CONTPER Contact Persons Routine 0REFER DOC Rule 1. 0BP EMPLO Responsible Employee Routine 0SALESEMPLY Rule 2. Table 3 Mapping table for transformation between custom DSO to 0CRM SALO. Target fields Description Rules Type Source Fields Comments. 0CRM SOLDTO Sold To Party Routine 0SOLD TO Rule 1, 0CRM SHIPTO Goods Recipient Routine 0SHIP TO Rule 2. Below we lists some segments of a transformation which contains three parts data declaration select. statement and rules, Data declaration Select statement. TYPES BEGIN OF ty orgunit SELECT orgunit crmsalorgx salorg salesorg. orgunit TYPE bi0 oiorgunit FROM bi0 qorgunit, crmsalorgx TYPE bi0 oicrmsalorgx INTO CORRESPONDING FIELDS OF T. crmsalgrpx TYPE bi0 oicrmsalgrpx ABLE gt orgunit, crmsaloffx TYPE bi0 oicrmsaloffx FOR ALL ENTRIES IN SOURCE PACKAGE.
crm salorg TYPE bi0 oicrm salorg WHERE salesorg SOURCE PACKAGE salesorg. crm salgrp TYPE bi0 oicrm salgrp AND objvers A, crm saloff TYPE bi0 oicrm saloff AND dateto SOURCE PACKAGE createdon. salesorg TYPE bi0 oisalesorg AND datefrom SOURCE PACKAGE createdo. END OF ty orgunit, Rule 1 Rule 2, READ TABLE gt crm opph READ TABLE gt employee INTO gs employee. INTO gs crm opph WITH KEY WITH KEY person SOURCE FIELDS salesemply. crm obj id SOURCE FIELDS IF sy subrc 0, RFER DOC wa person gs employee employee. SELECT SINGLE bpartner FROM bi0 p, BINARY SEARCH, bpartner INTO wa bpartner. IF sy subrc 0, WHERE customer wa person, RESULT gs crm opph.
AND objvers A, bp contper ENDIF, Fig 5 The sales cycle report with quotation rate. To test our proposed solutions in SAP CRM WebClient UI we have created numbers of opportunities. with business partner and estimated closing dates for the sales cycle After an opportunity is created we need. to maintain the opportunity with data collected during identify an opportunity Then we create numbers of. ERP quotations in which some of the ERP quotations are transferred into ERP SO We can view the CRM. opportunity report from CRM WebClient UI and ERP QSOs report from ERP WebClient UI The following. action can test whether our solution has taken effect or not In BW we first activate the DS. 2LIS 11 VAITM and then load the created data from ERP into BW according to the proposed solution. mapping to ERP SD module data to CRM sales application data Later the related queries and dashboards in. SAP BW are activated Then from CRM WebClient UI we can view the Rc of ERP quotations from sales. orders shown in Fig 5 The newly created InfoP with transformation realizes proper integration of ERP SD. transaction data SO with CRM sales application data opportunity in BW. 4 References, 1 G C Williams Implementing SAP ERP Sales Distribution McGraw Hill Osborne Media Vol 1 March 21. 2 K Sharma A Mutsaddi in Configure SAP ERP Sales and Distribution Wiley Publishing Inc Apr 12 2010. 3 A Macdonald D Beavis in Seize the Moment Supply Chain Integration Journal of Manufacturing Engineer. Vol 80 2002 pp 175 178, 4 Y Shanlin L Hongyan in On the Integration of ERP and CRM Based on Collaborative E business Journal of. Hefei University of Technology Vol 27 e d I 2004 pp 1 4. 5 G Oberniedermaier T Sell Jander Sales and Distribution with SAP Making SAP SD Work for Your Business. GWV Vieweg e d 1 December 2 2003, 6 T Zurek in SAP Business Information Warehouse from data warehousing to an e business platform. Proceedings of 17th International Conference on Data Engineering 2001 pp 1 3. 7 Information on http help sap com, 8 Mutsaddi Ashutosh Configuring SAP ERP Sales and Distribution SYBEX INC 2010.
Integrated Analytics of SAP CRM Sales and ERP SD Ru Ma1 a Distribution SD module provides the functionalities of Quotation and Sales Order QSO management in the sales phase which fulfills the business process followed by CRM LO management In the recent SAP CRM7 0 release the integration of ERP QSO is available and can be created through CRM User Interface UI but the analytics of

Related Books

Technologie und Managementorientierte

Technologie und Managementorientierte

Technologie und Managementorientierte Betriebswirtschaftslehre Master in Management amp Technology Track 1 TUM School of Management Technische Universit t M nchen Content Master sprogram with specialization in Technology and in Management at the TUM School of Management Combination of Master sprograms M Sc TUM BWL and WITEC Innovative design Block structure consisting of

6 vector Igus

6 vector Igus

ist mit Preisen von bis zu 5 000 Euro dotiert Innovative e chains made of plastic are a heart of mechanical engineering and auto mation and are used in around 40 industries They are the solution how to guide energy data and media safely at the arm of an industrial robot They are responsible that STS cranes in a container

CONSTRUCTION INNOVATION ET NOUVELLES TECHNOLOGIES

CONSTRUCTION INNOVATION ET NOUVELLES TECHNOLOGIES

processus contr l production en s rie de pi ces uniques contr l e virtuellement machine vapeur nergie de masse lectricit ordinateur contr le des technologies informatiques commande num rique internet capteurs syst mes en ligne syst mes cyber physiques NUM RISATION DE LA CONSTRUCTION THE DIGITAL TURN IN ARCHITECTURE 1992 2012 sous la direction de Mario CARPO AD

LL Automatique pour les syst mes FluidFluid Power Power

LL Automatique pour les syst mes FluidFluid Power Power

processus Modulateur de puissance Cha ne d action Syst me de r gulation de pression 0 R servoir G n ration Pompe Xavier Brun 19 10 11 JNRR 8 me dition La Rochelle Pluridisciplinarit Automatique Informatique Electronique Syst me Syst me de Commande Electrique Magn tique Non lin arit Ph nom nologique Electronique Electrique Magn tique M d F comp Sous

Master Robotics and Autonomous Systems 2019

Master Robotics and Autonomous Systems 2019

Advanced Control and Estimation RO4500 KP08 ACE 33 Medizinische Robotik RO5100 KP08 MedRob08 35 Bio inspired Robotics RO5200 KP08 BRS 36 Autonomous Vehicles RO5500 KP08 AV 37 Advanced Topics in Robotics RO5800 KP04 RO5801 KP04 ATiR 39 Advanced Topics in Robotics RO5800 KP08 ATR 40 Pflicht Lehrmodule Studierendentagung PS5000 KP06 PS5000 ST 42 Autonomous Systems RO4000

Chancen durch die virtuelle Inbetriebnahme mit Robotik im

Chancen durch die virtuelle Inbetriebnahme mit Robotik im

Chancen durch die virtuelle Inbetriebnahme mit Robotik im Sondermaschinen und Anlagenbau S Ragavan Guido Damm Unrestricted Siemens AG 2018 Page 2 Siemens PLM Software Ihre Referenten im Webinar Guido Damm Pre Sales Siemens PLM Software Hannover Fokus Produktionsplanung und Absicherung 20 Jahre PLM Erfahrung Sarvananthan Ragavan Portfolio Development Siemens PLM Software K ln Fokus

7 Autres cultures Ontario

7 Autres cultures Ontario

une culture sensible au gel et g n ralement sem e plus tard que les autres grandes cultures Le sarrasin est cultiv pour l alimentation humaine entre dans la composition de nourriture pour le b tail et sert la fabrication du miel de sarrasin C est aussi une culture couvre sol couramment utilis e pour lutter contre les mauvaises herbes et comme engrais vert voir ce sujet le

Labellisation des 20 premiers Territoires French Impact

Labellisation des 20 premiers Territoires French Impact

diffuser une culture de la coop ration Promouvoir la mesure et l valuation de l impact Inspirer les politiques publiques Engagement du projet pr sidentiel Le French Impact a t lanc en 2018 par le Haut Commissaire l Economie Sociale et Solidaire et l Innovation Sociale au Minist re de la Transition cologique et solidaire Il s est organis en association

AP French Language and Culture 2019 Free Response Questions

AP French Language and Culture 2019 Free Response Questions

FRENCH LANGUAGE AND CULTURE FREE RESPONSE QUESTIONS 222222222222222 Task 2 Persuasive Essay You have 1 minute to read the directions for this task Vous aurez 1 minute pour lire les instructions de cette t che You will write a persuasive essay to submit to a French writing contest The essay topic is based on

Thoughts for Food I French Cuisine and French Culture

Thoughts for Food I French Cuisine and French Culture

A glory of French culture this cuisine is however relatively recent in origin Though based on an important tradition that dates from the Renaissance what is now labelled gastronomy the myth of French cuisine its particular social context were essentially products of the nineteenth century For a select few the gastronomical revolution was not the least momentous of the revolutions that

FRENCH CULTURE FRENCH CINEMA in French

FRENCH CULTURE FRENCH CINEMA in French

French Culture French Cinema in French Course Description Le ous se donnea pou o jetif d inteoge la notion de ultue fan aise ta e s le pisme du in ma En tudiant la production cin matographique fran aise des origines nos jours travers le corpus des films propos s les tudiants auront un aper u des cin astes majeurs et des courants esth tiques au sein des uels ils