First-hand knowledge.
Reading Sample This sample chapter provides an introduction to the SAP MDG data modeling concepts, including entities, attributes, hierarchies, and the relationships between entities. It also describes the standard data models: material master, financial, and business partner.
“Data Modeling” Contents Index The Authors
Homiar Kalwachwala, Sandeep Chahal, Santhosh Cheekoti, Antony Isacc, Rajani Khambhampati, and David Quirk
SAP Master Data Governance: The Comprehensive Guide to SAP MDG 627 Pages, 2017, $79.95 ISBN 978-1-4932-1433-4
www.sap-press.com/4192
Contents Preface .....................................................................................................................................................
1
1.1 1.2
1.3
1.4
19
Introduction to Enterprise Information Management
25
Stages of Enterprise Information Management Engagement ........................
26
Organizational Drivers for Enterprise Information Management ................
28
1.2.1 1.2.2
Enterprise Information Management Benefits and Drivers .................. Building the Business Case ................................................................................
28 30
Enterprise Information Management Capabilities ..............................................
31
1.3.1 1.3.2 1.3.3 1.3.4 1.3.5 1.3.6
32 33 33 33 34 34
Architecture and Metadata Management ................................................... Data Integration ................................................................................................... Data Quality ........................................................................................................... Master Data Management ................................................................................ Content Management ........................................................................................ Information Lifecycle Management ...............................................................
Key SAP Solutions for Enterprise Information Management ..........................
34
1.4.1 1.4.2 1.4.3
35 36
SAP Data Services ................................................................................................. SAP Information Steward .................................................................................. SAP HANA Smart Data Integration and SAP HANA Smart Data Quality ...................................................................................................................... SAP Agile Data Preparation ............................................................................... SAP Information Lifecycle Management ...................................................... SAP Content Management Solutions by OpenText ..................................
37 38 39 41
1.5
SAP Master Data Governance ........................................................................................
42
1.6
Summary .................................................................................................................................
45
1.4.4 1.4.5 1.4.6
7
Contents
2
Contents
Deploying SAP MDG
47
2.1
Overview ................................................................................................................................
48
2.2
Architecture ...........................................................................................................................
50
2.2.1 2.2.2
Overview ................................................................................................................. Available User Interfaces ..................................................................................
50 54
Available Deployment Options ...................................................................................
57
2.3.1 2.3.2 2.3.3 2.3.4
Hub versus Co-Deployment ............................................................................. Limitations and Restrictions ............................................................................ Initial Build ............................................................................................................. Customizing Synchronization ..........................................................................
58 60 61 63
2.3.5
Reference Master Data Synchronization .....................................................
75
Overview of Data Domains ............................................................................................
76
2.4.1 2.4.2 2.4.3 2.4.4 2.4.5
Material Master .................................................................................................... Business Partner, Supplier, and Customer .................................................. Customer Vendor Integration .......................................................................... Financials ................................................................................................................ Custom Domains .................................................................................................
76 79 84 93 96
SAP S/4HANA ........................................................................................................................
96
2.5.1 2.5.2
Architecture and Deployment Options ........................................................ Master Data Domains ........................................................................................
97 97
Summary .................................................................................................................................
98
2.3
2.4
2.5
2.6
3 3.1
Data Modeling Introduction to Data Modeling in SAP MDG ........................................................... 3.1.1 3.1.2 3.1.3 3.1.4 3.1.5 3.1.6 3.1.7
8
Master Data Create/Change Process ............................................................ Entity Types ............................................................................................................ Attributes ................................................................................................................ Relationships ......................................................................................................... Hierarchies ............................................................................................................. Entity Relationship Model Diagram .............................................................. Data Model-Related Configurations .............................................................
3.2
3.2.1 3.2.2 3.2.3
Material Master Data Model ............................................................................ Supplier, Customer, and Business Partner Data Models ......................... Financial Data Model ..........................................................................................
125 129 135
3.3
Summary ................................................................................................................................. 138
4
User Interface Modeling
4.1
Floorplan Manager .............................................................................................................. 140
4.2
139
User Interface Framework ............................................................................................... 144 4.2.1 4.2.2 4.2.3 4.2.4 4.2.5
Overview .................................................................................................................. Configuration ......................................................................................................... Material Master .................................................................................................... Business Partner, Customer, and Supplier ................................................... Financial Domains ................................................................................................
144 153 158 160 163
4.3
Summary ................................................................................................................................. 166
5
Process Modeling
5.1
Governance Scope ............................................................................................................... 168
5.2
Change Requests .................................................................................................................. 170
99 99 100 102 108 110 111 113 114
Standard Data Models ....................................................................................................... 125
5.3
167
5.2.1 5.2.2 5.2.3 5.2.4 5.2.5
Overview .................................................................................................................. Logical Action ......................................................................................................... Business Activity ................................................................................................... Change Request Type .......................................................................................... Change Request Steps ........................................................................................
171 176 176 178 181
5.2.6 5.2.7 5.2.8
Change Requests Actions and Step Types .................................................... User Interface Determination .......................................................................... Editions ....................................................................................................................
187 189 190
Single-Record Processing ................................................................................................. 193 5.3.1 5.3.2 5.3.3
Central Master Data Scenarios ........................................................................ Processing Customer on a Client System ..................................................... Business Context Viewer Side Panels ............................................................
193 203 204
9
Contents
5.4
5.5
5.6
6 6.1
6.2
6.3
6.4
Multiple Object Processing .............................................................................................
205
5.4.1 5.4.2 5.4.3 5.4.4 5.4.5
Mass Change ......................................................................................................... File Upload/Download ....................................................................................... Data Import Process ............................................................................................ Hierarchy Processing ........................................................................................... Multiple-Record Processing ..............................................................................
206 207 209 210 218
Workflow Process Modeling ..........................................................................................
219
5.5.1 5.5.2 5.5.3
Standard Workflow Templates ....................................................................... Rule-Based Workflows ....................................................................................... Available Business Add-Ins ...............................................................................
222 229 240
Summary .................................................................................................................................
241
Data Quality and Search
243
Search Functionality ..........................................................................................................
244
6.1.1 6.1.2 6.1.3 6.1.4 6.1.5
Overview ................................................................................................................. Search Help ............................................................................................................ Match Profiles ....................................................................................................... SAP HANA Search Setup ................................................................................... SAP HANA Search Extensibility .......................................................................
244 246 249 251 256
Duplicate Check ...................................................................................................................
258
6.2.1 6.2.2
Search and Duplicate Check ............................................................................. Data Quality Remediation ................................................................................
259 263
Business Rules ......................................................................................................................
263
6.3.1 6.3.2 6.3.3 6.3.4 6.3.5
Code Lists ................................................................................................................ Simple Checks in SAP Master Data Governance ........................................ Data Modeling-Based Checks .......................................................................... Business Rules Framework Plus-Based Checks and Validations .......... Business Add-In-Based Validations ...............................................................
264 264 265 266 275
Data Enrichment ..................................................................................................................
278
6.4.1
10
Contents
Integration with SAP Data Quality Management for Address Standardization ....................................................................................................
279
6.4.2 6.4.3
Integration with Third-Party Data Enrichment Tools .............................. Business Partner Screening in SAP Fraud Management .........................
283 285
6.5
Summary ................................................................................................................................ 287
7
Data Replication Framework
7.1
Building Blocks and Configuration Objects ............................................................. 291 7.1.1 7.1.2 7.1.3
Building Blocks ...................................................................................................... Configuration Objects ......................................................................................... Enhance Default Settings for Outbound Implementations ...................
289
291 307 314
7.2
Material Master Replication ........................................................................................... 325
7.3
Customer, Supplier, and Business Partner Replication ...................................... 328 7.3.1 7.3.2
7.4
7.7
Account Replication ............................................................................................. Company Replication .......................................................................................... Cost Element Replication ................................................................................... Profit Center and Profit Center Hierarchy Replication ............................. Cost Center and Cost Center Hierarchy Replication .................................
330 331 332 332 333
Replication Options for Non-SAP Systems ............................................................... 334 7.5.1 7.5.2 7.5.3
7.6
328 329
Financial Master Data Replication ............................................................................... 330 7.4.1 7.4.2 7.4.3 7.4.4 7.4.5
7.5
SOA-Based Replication ....................................................................................... ALE-Based Replication .........................................................................................
Web Services .......................................................................................................... Intermediate Documents ................................................................................. File Protocol ............................................................................................................
334 334 334
Operations .............................................................................................................................. 335 7.6.1 7.6.2
Logging, Tracing, and Monitoring Tools ....................................................... Change Pointers ....................................................................................................
335 337
7.6.3 7.6.4 7.6.5 7.6.6
Check Data Replication Framework Customizing ..................................... Delete Replication Log ........................................................................................ Display Object Replication Status ................................................................... Delete Replication Status ..................................................................................
338 338 340 341
Summary ................................................................................................................................. 341
11
Contents
Contents
8
Analytics
343
8.1
Embedded Business Intelligence Content ................................................................
344
8.2
SAP HANA-Based Analytics ............................................................................................
349
8.2.1 8.2.2 8.2.3 8.2.4
Architecture ........................................................................................................... Object-Based Change Request Analytics ..................................................... Change Document-Based Change Request Analytics ............................. Workflow-Based Change Request Analytics ...............................................
349 353 353 353
Summary .................................................................................................................................
354
8.3
10.2.4 10.2.5 10.2.6 10.2.7
SAP Ariba ................................................................................................................. SAP Customer Relationship Management ................................................... SAP S/4HANA Finance ......................................................................................... SAP Information Steward ..................................................................................
395 397 397 398
10.3 Integration with Third-Party Solutions ..................................................................... 399 10.4 Summary ................................................................................................................................. 400
11 SAP Fiori Applications for SAP MDG
401
11.1 Introduction to SAP Fiori .................................................................................................. 401
9
Data Migration
355
9.1
Overview .................................................................................................................................
355
9.1.1 9.1.2
Technology Options ........................................................................................... General Recommendations for Initial Data Load ......................................
357 365
Data Migration Strategies ...............................................................................................
369
9.2.1 9.2.2 9.2.3
Data Import/Export Framework ..................................................................... Key Mapping and Value Mapping .................................................................. SAP MDG File Upload/Download ...................................................................
369 373 377
11.4 Summary ................................................................................................................................. 421
Summary ................................................................................................................................
388
12 SAP MDG Extensibility
11.2 SAP Fiori Applications for SAP MDG ............................................................................ 403 11.3 Extensibility Options .......................................................................................................... 409
9.2
9.3
11.3.1 11.3.2 11.3.3 11.3.4
Extension of the Data Model (SAP MDG Layer) ......................................... Extension of the User Interface layer ............................................................ Launchpad Extension ......................................................................................... SAP Theme Designer ...........................................................................................
410 412 418 420
423
12.1 Extending Standard Data Models ................................................................................ 424
10 Integration Scenarios
389
10.1 SAP MDG Application Programming Interfaces ....................................................
389
10.1.1 10.1.2
Governance API ..................................................................................................... Convenience API ...................................................................................................
390 391
10.1.3
Application Context API .....................................................................................
391
10.2 Integration with SAP Solutions ....................................................................................
392
10.2.1 10.2.2 10.2.3
12
SAP Product Lifecycle Management .............................................................. SAP Supplier Lifecycle Management ............................................................. SAP Hybris ...............................................................................................................
392 393 395
12.1.1 12.1.2
Adding Attributes to Standard Data Models .............................................. Adding New Entities to the Data Model .......................................................
425 426
12.2 Enhancing SAP-Delivered User Interfaces ................................................................ 427 12.2.1 12.2.2 12.2.3 12.2.4 12.2.5 12.2.6
Customizing ........................................................................................................... Personalizing .......................................................................................................... Enhancement ......................................................................................................... Context-Based Adaptations .............................................................................. Copy Application Configuration (Deep-Copy) ............................................ Modification ...........................................................................................................
427 428 429 430 430 431
13
Contents
Contents
12.3 Using the SAP MDG Business Add-In .......................................................................... 12.3.1 12.3.2 12.3.3 12.3.4 12.3.5
Rule Service BAdIs ................................................................................................ Various Replication BAdIs ................................................................................. Change Request User Interface Building Block Enhancement BAdIs ............................................................................................ Workflow BAdIs .................................................................................................... Other Domain-Specific BAdIs ...........................................................................
12.4 Enhancing Master Data Domains with Search Capabilities ............................. 12.4.1 12.4.2 12.4.3 12.4.4
433 433 434 435 436 438
441 441 442 443
12.5 Summary .................................................................................................................................
445
13 Building Custom Applications: Data Modeling and User Interface Modeling
447
13.1 Custom Data Models .........................................................................................................
448 448 450
13.2 Create a Custom Data Model .........................................................................................
454
Concepts and Prerequisites .............................................................................. Creating Entities ................................................................................................... Adding Attributes to Entities ........................................................................... Representing the Work Breakdown Structure Hierarchically ............... Generic Interaction Layer Data Model ..........................................................
454 458 471 472 476
13.3 Create a Custom User Interface ....................................................................................
478
13.3.1 13.3.2 13.3.3
14.1.1 14.1.2 14.1.3 14.1.4 14.1.5 14.1.6
Create a New Business Object ......................................................................... Create a New Business Activity ....................................................................... Assign Business Activities and Logical Actions to Business Objects ..................................................................................................................... Maintain Settings for Business Activity Determination .......................... Create Change Request Type ............................................................................ Workflow Settings ...............................................................................................
498 499 500 501 502 505
14.2 Security and Roles ............................................................................................................... 506 14.2.1 14.2.2 14.2.3
Authorization Objects ......................................................................................... Roles .......................................................................................................................... Home Page .............................................................................................................
506 509 513
14.3 Translation .............................................................................................................................. 516
SAP ERP Project System ...................................................................................... Data Modeling Tools ...........................................................................................
13.2.1 13.2.2 13.2.3 13.2.4 13.2.5
497
14.1 Process Modeling ................................................................................................................. 497
440
Database Search ................................................................................................... SAP Enterprise Search ......................................................................................... SAP HANA Search ................................................................................................. BAdI Enhancements for the Search Functionality ....................................
13.1.1 13.1.2
14 Building Custom Applications: Process Modeling and Data Replication
User Interface Framework ................................................................................ Design and Develop the User Interface ........................................................ Develop a Single Object Maintenance User Interface ............................
479 480 487
13.4 Summary .................................................................................................................................
496
14.3.1 14.3.2 14.3.3 14.3.4 14.3.5
Overview .................................................................................................................. Floorplan Manager Text Tool ........................................................................... Translating Data Element Texts and Floorplan Manager Texts ........... Translating Text Elements in the Feeder Class ........................................... Translating Texts in the PFCG Role .................................................................
517 520 521 523 524
14.4 Data Replication ................................................................................................................... 525 14.4.1 14.4.2
Customizing Settings for Data Replication ................................................. Data Replication Framework Runtime Settings for Project Definition ................................................................................................................
526 531
14.5 Enabling Key Mapping ...................................................................................................... 536 14.6 Enabling Value Mapping .................................................................................................. 538 14.7 Summary ................................................................................................................................. 540
15 Operational Strategies
541
15.1 Edition Strategy .................................................................................................................... 541 15.1.1
14
Create New Editions ............................................................................................
543
15
Contents
15.1.2 15.1.3
Contents
Releasing Editions ................................................................................................ Monitoring Editions ............................................................................................
15.2 Ongoing Data Loads ........................................................................................................... 15.2.1 15.2.2 15.2.3 15.2.4
544 546
Appendices
548
A
SAP MDG Solution Extensions by Utopia ................................................................. 605
B
The Authors ............................................................................................................................ 613
Creating Mass Change Requests for Mass Loads ...................................... Scheduling File Uploads in the Background ................................................ Operating with the Data Import/Export Framework .............................. Mass Processing in SAP MDG ...........................................................................
548 550 550 552
15.3 Performance Optimization .............................................................................................
554
15.4 Troubleshooting ..................................................................................................................
556
15.5 Summary .................................................................................................................................
558
16 Consolidation
559
16.1 Overviews and Use Cases ................................................................................................
560
16.2 Process Flow ..........................................................................................................................
563
16.2.1 16.2.2 16.2.3 16.2.4 16.2.5 16.2.6 16.2.7
Prerequisites and Preparations ....................................................................... Creating a Consolidation Process with SAP Fiori ....................................... Standardization ................................................................................................... Matching ................................................................................................................. Best Record Calculation ..................................................................................... Validation ............................................................................................................... Activation ...............................................................................................................
564 578 580 585 590 593 595
16.3 Initial Data Load ..................................................................................................................
599
16.3.1 16.3.2 16.3.3 16.3.4
Source Tables ......................................................................................................... SAP Landscape Transformation Replication Server .................................. SAP HANA Studio ................................................................................................. CSV Files ..................................................................................................................
600 601 603 603
16.4 Summary ................................................................................................................................
603
16
Index ........................................................................................................................................................
605
615
17
Chapter 3 Data Modeling
3
This chapter provides a view into the SAP MDG data modeling concepts, including different storage areas and storage types, as well as insights into delivered data models. We’ll also discuss entities, attributes, and the relationships between entities.
In the previous two chapters, we introduced the concept of master data management and SAP’s master data management product—SAP MDG—and how it fits into the overall portfolio of enterprise information management (EIM) products. This chapter introduces the concept of data modeling in SAP MDG and provides an overview of SAP-delivered data models. The following data models are delivered by SAP as part of SAP MDG: 쐍 Material master 쐍 Business partner, customer, and supplier 쐍 Financials
Let’s begin by exploring the data modeling process in SAP MDG.
3.1 Introduction to Data Modeling in SAP MDG A key aspect of governing master data is the ability for all roles involved in the endto-end governance process to manipulate data collaboratively in a staging environment. Hence, a separation is required between data that are currently being used or ready to be used in transactions and data that are involved in a governance process. There are two storage areas in the context of SAP MDG as follows: 쐍 Staging area
Contains data currently in a governance process and has an associated change request.
99
3
Data Modeling
3.1
쐍 Active area
Contains data ready to be consumed by other applications or ready to be distributed to other systems. In the following sections, we begin with the steps to create or change master data to understand the concept of change requests and staging data versus active data. In the sections that follow, we’ll discuss the various elements of data modeling and by going through the related configuration steps.
3.1.1 Master Data Create/Change Process Figure 3.1 illustrates a simple master data create/change process.
Requester
Master Data Experts
Master Data Steward
Introduction to Data Modeling in SAP MDG
Master data experts further maintain, enrich, and validate the record to ensure that the master data record submitted by the requester follows data quality rules. During this process, data are read from the staging area and saved back into the staging area if any changes to data were made. The master data steward processes the change request and does the final approval. In this process, the master data record is read from the staging area and is updated into the active area after the final approval step. This process is also known as activation. At this point, the master data record is ready to be consumed by any other applications if SAP MDG is installed in a co-deployment scenario. If SAP MDG is installed as a hub, once activated, data are ready for replication to other SAP or non-SAP systems. The active areas in SAP MDG can be in either the flex mode or the reuse active area, as described here: 쐍 Flex mode
Request
Data is copied from active area in case of change scenario
Maintain, Enrich, & Validate
Approve
Replicate
Staging Area
Active Area
SAP and non-SAP systems
Figure 3.1 Staging and Active Area Concept for Master Data Create Scenario
First, the requester initiates a change request for creating or changing a master data record. (We’ll discuss the concept of change request in detail in the next chapter.) There are two main scenarios that we’ll explore, as follows: 쐍 Create scenario
In a create scenario, request details along with data entered by the requester are stored in the staging area after the requester submits the change request. 쐍 Change scenario
In a change scenario, the master data record is copied from the active area into the staging area, and changes made by the requester, along with change request details, are stored in the staging area.
100
In this mode, a new set of database tables are generated when the data model is defined. This mode is used when there are no corresponding SAP ERP tables or when the activated data in SAP MDG are intended to be isolated from SAP ERP tables. If required, data can be replicated to SAP ERP master data tables. An example of such a scenario is standard SAP MDG, Financials objects. All SAP MDG, Financials objects are delivered in flex mode to isolate them from SAP ERP Financials (SAP ERP FI) tables and only replicate when needed to SAP ERP master data tables or to transactional SAP ERP systems if SAP MDG is deployed as a hub. 쐍 Reuse active area
In this mode, existing SAP ERP tables are used. As an example, for a material master, these are reuse active area tables MARA, MARC, MARD, and so on. Figure 3.2 shows the difference between the flex and reuse modes of a data model. Data models for material masters and business partners are delivered in the reuse active area mode, which means that after a change request is activated, the corresponding SAP ERP master data tables are updated. Data modeling in SAP MDG involves various elements such as entity types, attributes, and relationships. Every master data object that needs to be governed using SAP MDG requires a data model and user interface (UI) built on top of it. Every data model in SAP MDG has several generated database tables that store data during the governance process.
101
3
3
Data Modeling
3.1
Change Request Process (New/Changes to data)
MDG Application Foundation
MDG Application Foundation
Change Request Process (New/Changes to data)
Staging Area
Activation
Active Area
Introduction to Data Modeling in SAP MDG
automatically generates all necessary database tables, including check tables, text tables, and additional tables needed to store attachments and sets, for example. Key fields of this storage/usage type include the entity type itself, edition (if relevant), and other entity types linked to this entity type via relationships. The MATERIAL entity in the material master data model is an example of a type 1 entity, as shown in Figure 3.3.
Staging Area
Activation
Master Data
Flex Mode
SAP ERP
SAP ERP
Replication (if needed) Master Data (Active Area)
Re-use Mode
Figure 3.2 Flex and Reuse Modes
3.1.2 Entity Types Different types of master data in a data model are represented by different entity types. SAP MDG automatically generates required database tables needed for master data processing. Every data model has at least one entity type. An important property of an entity type is Storage/Usage Type, which determines whether entities belonging to an entity type are changeable via a change request or via entities belonging to other entity types, the type of information stored, and whether database tables are generated or reused from the active area. The following four storage or usage types are available: 쐍 Type 1: Changeable via Change Request; Generated Database Tables
This storage and usage type is used for main entities in the data model that are under governance. These entities are linked to change request types (Chapter 5 describes change request types in detail), and data stored in these can be changed via change requests. These entities have persistence, and SAP MDG
102
Figure 3.3 An Example of Type 1 Entity Type 쐍 Type 2: Changeable w/o Change Request; Generated Check/Text Tables
This storage and usage type is used for check tables that have persistence in SAP MDG. Data stored in this storage or usage type can be changed without a change request. SAP MDG generates only the check tables and text tables with the entity type, as well as with the entity types assigned to the entity type, through leading relationships as fixed key fields. 쐍 Type 3: Not Changeable via MDG; No Generated Tables
This storage and usage type is used for check tables that have no persistence in SAP MDG. Data stored in this storage or usage type can’t be changed in SAP MDG.
103
3
3
Data Modeling
3.1
쐍 Type 4: Changeable via Other Entity Type; Generated Database Tables
This storage and usage type is used for maintaining dependent data (e.g., plant data for material master and company code, sales data for customer master) and can only be maintained together with an entity of type 1. This entity type needs to be in a relationship with the relationship type leading and assigned as the To-entity type to an entity type with storage and usage type 1. The system generates the check table as described for storage and usage type 1 but also generates the entity types that are assigned through qualifying relationships as key fields. The MARCBASIC entity in the material master data model is an example of a type 4 entity type. An entity type can have the properties listed in Table 3.1. Property
Represents the name of entity type.
Description
Language-dependent description of the entity type.
SU Type
Decides the generation of database tables for storage of master data. Determines properties such as Data Type and Length for the entity type to which it’s assigned. Data types are restricted to CHAR, NUMC, or CUKY, and length is restricted to 45 characters. Data elements can’t be assigned to entity types of storage/usage type 4. Storage/usage types also decide how to represent values if a value table or domain fixed values exist.
Validity of Entity Type
Determines whether or not the entity type is edition dependent.
Deletion
Determines whether or not deletion is allowed for the entities of this entity type via the change request process.
Attachments
Explanation
Sets
When selected, sets can be stored to entities of this entity type, and the system automatically provides a data store for this purpose.
Search Help
When a search help is assigned to a field, the input help executes the search help instead of reading the data in the check table or the fixed values of the domain of the data element. You should only use search helps as an exception.
Generated
Specifies whether entity types were generated or manually created, and those entity types that are generated can’t be changed or deleted via the Edit Data Model Customizing activity.
Hierarchies
Entity Type
Data Element
Property
Explanation
General Data
Introduction to Data Modeling in SAP MDG
When selected, attachments can be stored to entities of this entity type, and the system automatically provides a data store for storing these attachments. This can only be selected for entities with storage/usage type 1.
Is Hierarchy Type?
Determines whether an entity type defines a hierarchy. This setting also determines whether hierarchies have versions and are synchronized.
Validity of Hierarchy
If the Is Hierarchy Type? option is set to have a version, then this property determines the validity of the hierarchy.
Reuse Active Area
When a reuse active area is specified, the system stores active data solely in this reuse active area. The reuse active area can be assigned either at the data model level or at the entity type. When defined at the data model level, all entity types defined in that data model inherit the reuse active area. However, if a separate reuse active area for an entity type is specified at the entity type level, then it overrides the setting inherited from the data model.
Structure/Table
Used to establish the link between an entity type, attribute, or relationship, and a structure or database table defined in the ABAP Dictionary.
Field
Used to establish the link between an attribute or relationship and a field defined in the ABAP Dictionary that is part of a structure or a database table.
Table 3.1 Properties of an Entity Type Table 3.1 Properties of an Entity Type (Cont.)
104
105
3
3
Data Modeling
3.1
Introduction to Data Modeling in SAP MDG
Property
Explanation
Property
Explanation
Struct. for X-Fields
Used to establish the link between an entity type and an associated structure defined in the ABAP Dictionary that contains a checkbox with type CHAR and Length 1, with values space and X for each resolved attribute.
Long Text: Length
Determines visible length of long text in the UI for this entity type.
Key Assignment Type of Key Assignment
Following options are available and determine how the key of the entity will be entered during the change request process: 쐍 Key Cannot Be Changed; No Internal Key Assignment: In this case, there is no internal key generation possible, and the user needs to maintain the key manually. After it’s maintained, the key can’t be changed. 쐍 Internal Key Assignment Only: SAP MDG automatically assigns an internal number upon activation of the change request. During the change request process, SAP MDG assigns a temporary key. 쐍 Key Can Be Changed; No Internal Key Assignment: The key of the entity needs to be explicitly defined. However, it can be changed as long as the change request isn’t activated. 쐍 Key Can Be Changed; Internal Key Assignment Possible: In this option, either the system can automatically generate a number during the change request activation or the user can define his or her own key.
Number Range Object for Temporary Keys
Number range object for specifying temporary keys. For example, the MDG_BS_MAT number range object is specified for the MATERIAL entity type.
Medium Text: Length
Determines visible length of medium text in UI for this entity type.
Short Text: Length
Determines visible length of short text in UI for this entity type.
3
Source Fields for Texts Source Field Long Text
Applicable to storage/usage type 3 entity types. Determines the check table field that contains long text.
Source Field Medium Text
Applicable to storage/usage type 3 entity types. Determines the check table field that contains medium text.
Source Field Short Text
Applicable to storage/usage type 3 entity types. Determines the check table field that contains short text.
Table 3.1 Properties of an Entity Type (Cont.)
The following is a summary of all storage/usage types: 쐍 Storage type 1:
– This storage type is used for entity types that are maintained in SAP MDG. – Maintenance is performed via change requests, and these entity types act as entry points for change requests. – Data storage is generated. – Additional data modeling is possible and can have attributes and references. – Data elements such as data type, length, field label, and so on can be assigned.
Entity Texts Language-Dependent Texts
Indicates whether the entity type can have languagedependent texts. Based on this selection, the system automatically includes Language as a key field when the database tables are generated for this entity type.
Table 3.1 Properties of an Entity Type (Cont.)
– Check that table and domain fixed values associated with the data element are ignored. – (F4) is determined based on entries in generated check tables. 쐍 Storage type 2:
– This storage type is used for entity types that shouldn’t be maintained in SAP MDG and aren’t available in the system. – Data storage is generated.
106
107
3
Data Modeling
– Additional data modeling isn’t possible; associated check and text tables are generated. – No maintenance occurs via change requests. – Mandatory data element assignment occurs for data type, length, field label, and so on. – Check that tables and domain fixed values associated with the data elements are ignored. – (F4) is determined based on entries in the generated check tables.
3.1
and linked to the entity type via a relationship (see the next section for details on relationships). An attribute can be defined only for storage/usage type 1 or 4 entity types. Every attribute can have the properties listed in Table 3.2.
3 Property
Explanation
Attribute
Name of attribute.
Key Field
Indicator to identify attribute as a key field.
Data Element
Determines properties such as data type, length, and field label displayed on the UI and field help for input fields for the attribute to which it’s assigned. The domain assigned to the data element determines the allowed values for the value help and the validation of values, either from the domain fixed values or from the assigned check table or text table. If there is no check table or fixed values assigned to the domain, then no input help is available, and no validation is carried out.
Required Entry
Indicator to identify whether the attribute is required for data entry.
Currency/UoM
Currency or unit of measure field if the attribute requires a currency or unit of measure.
Search Help
When a search help is assigned to a field, the input help executes the search help instead of reading the data in the check table or the fixed values of the domain of the data element. Search helps should only be used as an exception.
No Existence Check
Used for deactivating the existence check for attribute values. However, existence checks can’t be suppressed for values that are derived from domain fixed values.
Description
Description of attribute.
Structure/Table
Used to establish the link between an entity type, attribute, or relationship, and a structure or database table defined in the ABAP Dictionary.
Field
Used to establish the link between an attribute or relationship and a field defined in the ABAP Dictionary that is part of a structure or a database table.
쐍 Storage type 3:
– This storage type is used for entity types that should not be maintained in SAP MDG and that are available in the system. – No data storage is generated. – Additional data modeling isn’t possible. – No maintenance occurs in SAP MDG. – Mandatory data element assignment occurs for data type, length, field label, and so on. – Check that the table and domain fixed values associated with the data element are used. – (F4) is determined based on entries in associated check/text tables and/or domain fixed values associated with the data element. Nonkey fields in check tables are ignored. 쐍 Storage type 4:
– This storage type is used for entity types that are maintained in SAP MDG in the context of another entity type. – Maintenance is performed via change requests, but these entity types can’t act as entry points for the change request. Maintenance is possible via owning the storage type 1 entity type. – Data storage is generated. – Additional data modeling is possible and can have attributes and references.
3.1.3 Attributes An attribute defines a property of an entity type, and an attribute is defined for each property. Alternatively, an attribute can be defined as a storage/usage type 3 entity
108
Introduction to Data Modeling in SAP MDG
Table 3.2 Properties of an Attribute
109
3
Data Modeling
3.1
Property
Explanation
Generated
Specifies whether the attribute was generated or manually created, and those attributes that are generated can’t be changed or deleted via the Edit Data Model Customizing activity.
Table 3.2 Properties of an Attribute (Cont.)
3.1.4 Relationships
Introduction to Data Modeling in SAP MDG
Qualifying
Leading • “From-Entity type” (E1) is at a higher level than “To-Entity type” (E2) • E1 is part of key of E2 • Value of E1 is mandatory to maintain E2 • Relationship name is not relevant • Usage of Data Element is not allowed • Self relationships are not possible
If more than one entity type is defined in a data model, a relationship between entity types can be established. A relationship represents a link between entity types. Every relationship has a relationship type and cardinality. Relationship types determine
Entity Type (E1) “from-entity type”
Relationship
Entity Type (E2) “to-entity type”
Referencing • “From-Entity type” (E1) is a resolved attribute of “ToEntity type” (E2) • Relationship name defines name of resolved attribute • Usage of Data Element is allowed • Self relationships are possible • E2 must be of Storage/Use type 1 or 4 • Cardinality (0:N or 1:N) decides whether resolved attribute is mandatory or optional
• “From-Entity type” (E1) is at a higher level than “To-Entity type” (E2) • E1 is part of key of E2 • Value of E1 is mandatory to maintain E2 • Relationship name is not relevant • Usage of Data Element is not allowed • Self relationships are not possible • E2 must be of Storage/Use type 4
whether one entity type (from-entity type) is at a higher level than another entity type (to-entity type) or whether it is to be copied as an attribute of the other entity
Figure 3.4 Summary of Relationship Types
type in the check table. The following relationship types are available: 쐍 Referencing
This relationship type is used to specify from-entity type as an attribute of the toentity type. 쐍 Leading
If this relationship type is used, then the from-entity type is on a higher level than the to-entity type.
3.1.5 Hierarchies SAP MDG offers modeling hierarchies based on configurations of the entity types. The definition of hierarchies includes setting the hierarchies as edition dependent and synchronous. If a hierarchy is set up for an entity type, the system automatically generates database tables for storing hierarchies. Refer to the hierarchy-related properties explained in Table 3.1. The following sections explain each of these hierarchyrelated properties in detail.
쐍 Qualifying
This relationship type is similar to the leading relationship type with the excep-
Is Hierarchy Type?
tion that the qualifying relationship is possible when the to-entity type is of stor-
The Is Hierarchy Type? property of an entity type determines whether the entity type defines a hierarchy. If used, it also determines whether the property is version dependent or synchronized:
age/usage type 4. 쐍 Foreign key relationship
This relationship type is used if certain attributes or key fields of the to-entity type use the from-entity type as a foreign key. Figure 3.4 provides a summary of leading, qualifying, and referencing relationship types.
쐍 Version dependent
Version dependency enables a hierarchy to have multiple versions. Hierarchy versions can be defined under Customizing by following the IMG path, MDGIMG 폷 Process Modeling 폷 Hierarchies 폷 Create Hierarchy Versions. 쐍 Synchronized
In a synchronized hierarchy, the substructure defined will remain the same throughout. A different structure can’t be defined within the same hierarchy or in a different hierarchy for the same entity.
110
111
3
3
Data Modeling
This property Is Hierarchy Type? allows for a combination of version dependent and synchronous. Following are the available options:
3.1
Introduction to Data Modeling in SAP MDG
Hierarchy Attribute and Hierarchy Attribute from Reference
쐍 No (hierarchy can’t be set up for the entity type)
Hierarchy attributes can be defined for each relationship between nodes in a hierarchy. These hierarchy attributes are available during hierarchy processing:
쐍 Yes – Version-Dependent/Synchronized
쐍 Hierarchy Attribute
쐍 Yes – Not Version-Dependent/Synchronized 쐍 Yes – Not Version-Dependent/Not Synchronized 쐍 Yes – Version-Dependent/Not Synchronized
Validity of Hierarchies This property is applicable in scenarios where the Is Hierarchy Type? property is set to have version-dependent hierarchies. Using the property, an entity type can be set to have Edition or No Edition, and the system uses the edition to delimit the validity of the hierarchy. In such scenarios, an edition needs to be assigned to the hierarchy defining entity type during hierarchy processing.
3
Hierarchy attribute for a relationship between nodes is set using data elements. 쐍 Hierarchy Attribute from Reference
Hierarchy attribute for a relationship between nodes is set using a reference to an entity type. Figure 3.5 shows an example of hierarchy attributes defined for entity type consolidation group with an entity type of node consolidation unit from data model 0G.
Apart from the preceding two properties available at the entity type level, there are additional configurations that complete the entire hierarchy setup.
Entity Types for Hierarchies Using this configuration, you can model the role of additional entity types that are part of a hierarchy setup for a selected entity type. This configuration can be maintained using the IMG path, MDGIMG 폷 General Settings 폷 Data Modeling 폷 Edit Data Model, and then selecting the Entity Types for Hierarchies view under Entity Types. The following options are available for each entity type in the hierarchy setup: 쐍 Hierarchy Name
If this usage is selected for an entity type, then such entities act as root nodes for a hierarchy and hence define the hierarchy name. For any entity type, to complete a hierarchy setup, an additional entity type needs to be defined with this usage. Such an entity type can’t be used as a to-entity type in a leading relationship. 쐍 No Special Use
If entity types are defined with this usage, then they can be used as actual nodes and as lower-level hierarchy nodes in a hierarchy. 쐍 Ranges Permitted on End Nodes
An entity type that is used as a lower node in a hierarchy can have a range of values.
Figure 3.5 Example: Hierarchy Attribute
See Section 3.2.2 to understand how the business partner hierarchy is set up in business partner data model. Chapter 5, Section 5.4.4, provides details on how to create a hierachy using an example.
3.1.6 Entity Relationship Model Diagram As basic data model building blocks were explained in previous sections, this section explains how each of the building blocks come together to form a data model. This is
112
113
3
Data Modeling
3.1
explained using an entity relationship model (ERM) diagram, as shown in Figure 3.6. The following are some important aspects of a data model and its associated building blocks:
Introduction to Data Modeling in SAP MDG
Figure 3.7 shows business object type codes.
3
쐍 A data model can have more than one entity type. 쐍 A data model can have many relationships defined. 쐍 An entity type can have one or more attributes. 쐍 Many attributes can have the same data element. 쐍 An entity type can occur in multiple hierarchies. 쐍 Two entity types can have many relationships.
* Data Model
1
*
Entity Types 2
1
1 1 1..* Attributes
* *
Relations
Hierarchy
Now let’s move on to define the entity type to be used by the business object type.
* 1 Data Elements
Figure 3.6 ERM Diagram of a Data Model
3.1.7 Data Model-Related Configurations SAP MDG offers all data modeling-related Customizing activities grouped under Transaction MDGIMG. In this section, we’ll review all available Customizing nodes under the Data Modeling section of Transaction MDGIMG.
Define Business Type Object Codes In this Customizing activity, new business object type codes can be added for custom data models. For all standard data models, there is no need to add any new business type object codes because SAP has already delivered these. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Define Business Object Type Codes.
114
Figure 3.7 Business Object Type Codes
Define Entity Type to Be Used by Business Object Type If two or more entity types are assigned to the same business object type code, this Customizing activity is used to specify which entity types should be used. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Define Entity Type to Be Used by Business Object Type.
Define Prefixes for Internal Key Assignment In a data model, when an entity type with internal number assignment is used, a temporary key number range assignment is required (refer to the “Key Assignment” in Table 3.1). For example, the MATERIAL entity in the material master data model uses the MDG_BS_MAT number range object for temporary keys. Similarly, the BP_HEADER entity type in the business partner data model uses the MDG_BP number range object. Using this Customizing activity, a prefix can be assigned to the temporary number generated for internal number assignment scenarios to indicate that the generated number is a temporary number (as shown in Figure 3.8). SAP MDG has $ as the default Prefix, which can be changed if needed. The menu path for accessing this is MDGIMG 폷 Data Modeling 폷 Define Prefixes for Internal Key Assignment.
115
3
Data Modeling
3.1
Introduction to Data Modeling in SAP MDG
3
Figure 3.8 Prefix for Temporary Keys
Edit Data Model This Customizing activity provides an entry point for the entire list of data models available in the system and also the list of entities, attributes, and relationships. Various views available in this Customizing activity enable you to extend or create new data models and activate them. The system uses the data model to generate database tables. This activity can be accessed using two different IMG paths, and each path offers a different way to define or edit data models. Both options provide a way to access the list of assigned active areas and associated access classes at the data model level. The two options are as follows:
Figure 3.9 Business Partner Data Model: Edit Data Model
쐍 Edit data model functionality using SAP GUI
Figure 3.9 shows the business partner data model as an example using this IMG path. This Customizing activity also provides additional functionalities such as Visualize Data Model and Adjust Staging Area of Linked Change Requests. See the list of reports provided later in this section for additional details. The menu path for accessing this is MDGIMG 폷 Data Modeling 폷 Edit Data Model. 쐍 Configuration Workbench
The Configuration Workbench is a Web Dynpro application that acts as an alternative to the Edit Data Model Customizing activity. The Configuration Workbench includes all the functions that the Edit Data Model Customizing activity provides, presents data model details in a tabular format per entity type, and distinguishes relationship information into outgoing and incoming relationships for each entity. Figure 3.10 shows the business partner data model using the Configuration Workbench. Figure 3.10 Business Partner Data Model: Configuration Workbench
116
117
3
Data Modeling
SAP MDG offers several reports related to data models; the most commonly used are as follows: 쐍 Visualize Data Model (report USMD_DISPLAY_DATAMODEL)
This report offers a hierarchical view of entity types and attributes in a data model. This report also offers overview, detail view, and graphical display modes as well. Figure 3.11 shows the output of this report for the business partner data model as an example.
3.1
Introduction to Data Modeling in SAP MDG
쐍 Data Model Generated Tables (report USMD_DATA_MODEL)
This report displays data model entity types and generated database tables. It’s also possible to display counts of active and inactive records for each of these tables. 쐍 Compare Data Model (report USMD_COMPARE_DATA_MODEL)
This report compares active and inactive versions of a data model and provides a list of comparison results. 쐍 Delete Data Model (report USMD_DELETE_DATA_MODEL)
This report can be used to delete a data model. This functionality can also be triggered from the Edit Data Model IMG node or the Configuration Workbench. However, you should exercise caution because this report deletes the entire data model. 쐍 Adjust Staging Area of Linked Change Requests (report USMD_ADJUST_STAGING)
For the selected data model, this report verifies whether there were any changes made to the data model, and, if yes, it adjusts the change requests that are in process per the changes made in the data model. This report needs to be run in all relevant clients and target systems after data model changes.
Define Authorization Relevance per Entity Type This Customizing activity (as shown in Figure 3.12) is used to determine whether the system uses predefined authorizations from the reuse active area or SAP MDGspecific authorizations using authorization object USMD_MDAT. By default, the system always uses predefined authorizations from the reuse active area. If the option to select SAP MDG-specific attributes is chosen, then configurations for entity type level authorizations and authorization-relevant attributes need to be set up. Note the following: 쐍 If the reuse active area is used, then settings made under Authorization for Entity
Types and Authorization-Relevant Attributes views will be ignored. 쐍 For data models business partner and material master, standard SAP ERP authori-
zation checks are always performed, and any additional settings performed under this Customizing activity aren’t supported.
Figure 3.11 Output of Report USMD_DISPLAY_DATA_MODEL for the Business Partner Data Model
118
The menu path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Define Authorization Relevance per Entity Type.
119
3
3
Data Modeling
3.1
Introduction to Data Modeling in SAP MDG
generation of data model-specific structures explained in the previous section. In this Customizing activity, a package can be assigned for the customizing includes used during data model enhancements. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Assign Package for Customizing Include.
3
This Customizing activity has views for structures as well as mapping for each data model. Figure 3.13 shows the material master data model structures as an example.
Figure 3.12 Define Authorizations per Entity Type and Attributes
Generate Data Model-Specific Structures Each data model and entity type can have the following structures in the Data Dictionary: 쐍 PDF-based forms 쐍 Service Mapping Tool (SMT) with structures used for the configuration of enter-
prise services 쐍 Mapping between staging area and reuse active area 쐍 Data replication framework 쐍 SAP Enterprise Search 쐍 Field control of attributes 쐍 Field properties of attributes and key fields 쐍 Key fields
This Customizing activity is used to generate the preceding data model-specific structures. These structures need to be regenerated whenever a data model is changed. For all standard data models, these structures are delivered as well. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Generate Data ModelSpecific Structures. Figure 3.13 Data Model Structures for the Material Master Data Model
Assign Package for Customizing Include When an entity type delivered by SAP is enhanced to include additional attributes, the system automatically writes these attributes to Customizing includes during the
120
Figure 3.14 shows SMT Mapping from Active Area and SMT Mapping to Active Area for the material master data model as an example.
121
3
Data Modeling
3.1
Introduction to Data Modeling in SAP MDG
3
Figure 3.15 An Example of Package Assignment to Package Group
Service Mapping Tool You need to understand a bit more about SMT before moving on to the following sections. SMT is a program that enables you to fill target structures using sets of source structures. SMT supports simple and complex mappings, mappings with field transformations, and field checks. The main uses of SMT are to transform SAP internal format to enterprise services format and vice versa. Figure 3.16 shows an example of mapping for the MDG_BS_MAT_MAP_2STA structure and associated mapping steps. Refer to the earlier “Generate Data Model-Specific Structures” section for details on data model-specific structures and “Define Package Groups” section for details on package groups.
Figure 3.14 Data Model Mappings for the Material Master Data Model
Define Package Groups Using this Customizing activity, you can define package groups that consist of one or more packages. A package group can be assigned to a mapping (see the next section). The (F4) help of the transformation tool displays only classes that are contained in one of the specified packages. Figure 3.15 shows an example of a package assignment to a material master package group MDG_BS_MM. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Create and Edit Mappings 폷 Define Package Groups.
Figure 3.16 SMT Mapping Example
122
123
3
Data Modeling
Figure 3.17 shows mapping step MDG_BS_MAT_MARA as an example along with transformations and field mappings.
3.2
Standard Data Models
entire mapping Customizing. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Create and Edit Mappings 폷 Check Customizing. Now, let’s explore the standard data models provided by SAP.
3
3.2 Standard Data Models In this section, we’ll go through standard data models (material master; supplier, customer, and business partner; and financial) delivered by SAP at a high level and understand how entities are structured in each data model. This section also covers the scope of each data model.
3.2.1 Material Master Data Model With the generally available SAP MDG 9.0 release, the material master data model in SAP MDG covers most of the material master attributes that are commonly used across industries. Figure 3.18 shows an overview of the material master data model. Figure 3.17 Mapping Step Example Valuation Data
Sales Data
Following are the configurations available for either create and edit mappings or extend mappings: 쐍 Create and Edit Mappings
This Customizing activity is used for creating new mappings and mapping steps, and creating or editing transformations and field checks. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Create and Edit Mappings 폷 Create and Edit Mappings. 쐍 Extend Mappings
This Customizing activity is used for extending existing and delivered mappings, but it can’t be used to create new mappings or mapping steps. The IMG path for accessing this activity is MDGIMG 폷 Data Modeling 폷 Extend Mappings 폷 Extend Mappings.
Basic Data • • • • • • • • • •
General Data Descriptions Units of Measure EAN/UPC Internal Comment Basic/Quality/ Purchasing Text Material Sales Material Quality Material Purchasing Tax Classification for Purchasing
• • • •
Sales Text Sales Data Sales Grouping Tax Classification for Sales • Plant Data Sales • Plant Data Foreign Trade
• • • •
Valuation Data Costing Data Plant Data Costing Valuation Data with Material Ledger
Classification • Class Assignment • Characteristic Valuation
Warehouse Data
Plant Data
MM Data Model
Production Version DMS Link
Check Customizing
124
• Storage Location General Data • Storage Location MRP Data
• WM Data • Storage Type Data
• Document Link Text
This Customizing activity triggers the execution of report RSMT_CHECK, which can be executed for a specific mapping or for the entire configuration and checks the
Storage Location Data
• MRP Text • Plant Data MRP • Plant Data Production Planning • Plant Data Work Scheduling • Plant Data Quality Management • Plant Data Purchasing • Plant Data Stock Planning • Quality Inspection Setup • MRP Areas • …
Figure 3.18 Material Master Data Model
125
3
Data Modeling
3.2
The following are some of the highlights of the material master data model:
Standard Data Models
Entity Type
SU Type
Description
MARCMRPFC
4
Plant Data MRP Forecast (View Planning)
MARCMRPLS
4
Plant Data MRP Lot Size (View Lot Size)
and warehouse data
MARCMRPMI
4
Plant Data MRP Misc. (View Manufacturing)
쐍 No defined hierarchies
MARCMRPPP
4
Plant Data MRP Production Planning (View Material)
Table 3.3 lists SU type 1 and 4 entity types of the material master data model.
MARCMRPSP
4
Plant Data MRP Stock Planning (View Procurement)
쐍 Four storage/usage type 1 entity types 쐍 Several type 2 and type 3 entity types acting as check tables 쐍 Several type 4 entity types representing plant data, storage location, valuation,
Entity Type
SU Type
Description
MARCPURCH
4
Plant Data Purchasing
MATERIAL
1
Basic Data
MARCQTMNG
4
Plant Data Quality Management
DRADBASIC
1
Basic Data for Document Link
MARCSALES
4
Plant Data Sales
MATCHGMNG
1
Material Change Management
MARCSTORE
4
Plant Data Storage
MKALBASIC
1
Production Version
MARCWRKSD
4
Plant Data Work Scheduling
BSCDATTXT
4
Basic Data Text
MARDMRP
4
Storage Location MRP Data for Material
CLASSASGN
4
Class Assignment (Classification)
MARDSTOR
4
Storage Location General Data for Material
DRADTXT
4
Document Link Text
MBEWACTNG
4
Material Accounting Data
INTCMNT
4
Internal Comment
MBEWCSTNG
4
Material Costing Data
MARAPURCH
4
Material Purchasing Data
MBEWMLAC
4
Material Ledger: Prices
MARAQTMNG
4
Material Quality Data
MBEWMLVAL
4
Material Ledger: Period Totals Records Values
MARASALES
4
Material Sales Data
MBEWVALUA
4
Material Valuation Data
MARCATP
4
Plant Data ATP
MDMABASIC
4
MRP Area Basic Data
MARCBASIC
4
Plant Data Basic Data
MEAN_GTIN
4
International Article Numbers (EANs) for Material
MARCCSTNG
4
Plant Data Costing
MLANPURCH
4
Tax Classification for Purchasing
MARCFRCST
4
Plant Data Forecasting
MLANSALES
4
Tax Classification for Sales
MARCFRGTR
4
Plant Data Foreign Trade
MLGNSTOR
4
Material Warehouse Management Data
MARCFRPAR
4
Plant Data Forecast Parameters
MLGTSTOR
4
Material Storage Type Data
Table 3.3 Material Master Data Model SU Type 1 and 4 Entity Types
126
3
Table 3.3 Material Master Data Model SU Type 1 and 4 Entity Types (Cont.)
127
3
Data Modeling
3.2
Standard Data Models
relationships are modeled. Figure 3.19 shows the MARCBASIC entity type and its associated relationships as an example. Some of the highlights of this example are as follows:
Entity Type
SU Type
Description
MPGDPRODG
4
Material Data for Product Group
MRPTXT
4
Material MRP Text
MVKEGRPNG
4
Sales Grouping
MVKESALES
4
Sales Data
PURCHTXT
4
Material Purchasing Text
QINSPTXT
4
Material Quality Inspection Text
QMATBASIC
4
Parameters for Inspection Type
SALESTXT
4
Material Sales Text
UNITOFMSR
4
Units of Measure for Material
VALUATION
4
Characteristic Valuation (Classification)
쐍 The MATERIAL entity has a leading relationship of cardinality 1:N to entity type MARCBASIC. 쐍 The PRCTR entity type has a referencing relationship of cardinality 0:N to entity
type MARCBASIC. 쐍 The WERKS entity type has a qualifying relationship of cardinality 1:N to entity type MARCBASIC.
MARCBASIC (SU Type 4)
MATERIAL (SU Type 1)
PRCTR (SU Type 2)
Relationships Leading (1:N)
From Entity Type
Relationship
Description
MATERIAL
MATMARCBA
Leading Material for Plant Data Basic Data
Leading
1:N
PRCTR
PRCMARCBA
Referencing Profit Center for Plant Data Basic Data
Referencing
0:N
WERKS
WRKMARCBA
Qualifying Plant for Plant Data Basic Data
Qualifying
1:N
Table 3.3 Material Master Data Model SU Type 1 and 4 Entity Types (Cont.)
Relationship Type
Cardinality
Qualifying (1:N)
Attributes
Table 3.4 lists the reuse active areas and associated access classes assigned to the material master data model. Active Area
Description
Access Class
DRAD
Document-object link
CL_MDG_BS_MAT_DRAD_ACCESS
DRATYP2CHK
Type 2 entities (attributes) for document-object link (DRAD)
CL_MDG_BS_MAT_DRAD_TYP2CHK_ACC
MATERIAL
Material master (MM01 – MM03 in active area)
CL_MDG_BS_MAT_ACCESS
Type 2 entities (attributes) for material master
CL_MDG_BS_MAT_TYP2CHK_ACCESS
MM_TYP2CHK
Table 3.4 Material Master Data Model: Reuse Active Areas
Now that you understand all the data model building blocks from Section 3.1, we can focus on the material master data model and understand how some of the entities and
128
Referencing (0:N)
Attribute
Data Element
Description
FPRFM
FPRFM
Distribution profile of material in plant
LOGGR
LOGGR
Logistics handling group for workload calculation
MARCLVORM
LVOWK
Flag Material for Deletion at Plant Level
…
…
…
WERKS (SU Type 3)
Figure 3.19 Material Master Data Model Example
3.2.2 Supplier, Customer, and Business Partner Data Models The business partner data model caters to business partner, customer master, and supplier domains in SAP MDG. This helps in having all common attributes in the appropriate business partner-related entity types. As discussed in Section 2.4.3 in Chapter 2, customer vendor integration (CVI) plays an important role in creating business partner and associated customer/vendor records. Business partner relationships are used for creating customer and supplier contacts in SAP MDG. Figure 3.20 shows an overview of the business partner data model and how business partner data and corresponding SAP ERP customer and SAP ERP vendor data are linked.
129
3
3
Data Modeling
3.2
Standard Data Models
SU Type
Description
ADDRNO
1
Address Number
BP_HEADER
1
Business Partner
BP_HRCHY
1
Hierarchy
BP_REL
1
Relationships
BP_SUBHRY
1
Lower-Level Hierarchy
ADDRESS
4
Address
AD_EMAIL
4
Email Address
AD_FAX
4
Fax Number
AD_NAME_O
4
Names of Organizations
AD_NAME_P
4
Names of Persons
AD_POSTAL
4
Physical Address
AD_TEL
4
Telephone Number
AD_URL
4
Internet Address
BP_ADDR
4
Addresses
BP_ADDUSG
4
Address Usage
BP_BKDTL
4
Bank Details
Some of the highlights of the business partner data model are as follows:
BP_CENTRL
4
Central Data
쐍 Multiple storage/usage type 1 entity types are available.
BP_COMPNY
4
Company Code
BP_CPGEN
4
BP Relationship Contact Person General Data
BP_CUSDUN
4
Dunning Data (Customer)
BP_CUSFCN
4
Customer: Partner Function
BP_CUSGEN
4
General Data (Customer)
Business Partner
Central Data
• Organization • Person • Group
Address • • • •
Phone Fax Email URL
Roles
Sales Area Data
Tax Numbers
• Address Usages • Address Versions Relationships
• Dunning Areas • Withholding Tax Types
Bank Details
Identification Numbers
Address Details
Company Code Data
• Partner Functions
Tax Indicators
Industry Sectors General Data SAP ERP Customers Company Code Data SAP ERP Vendors
• Contact Persons
Business Partner Data
• Dunning Areas • Withholding Tax Types Purchasing Org Data • Purchasing Org Data 2 • Partner Functions
SAP ERP Vendor Master-specific Data
General Data
SAP ERP Customer Master-specific Data
Entity Type
Figure 3.20 Business Partner Data Model
쐍 Multiple type 4 entity types are available. 쐍 Business partner hierarchy is possible. 쐍 Business partner and corresponding SAP ERP customer/SAP ERP vendor are linked
via the multiple assignments entity type. Table 3.5 lists SU type 1 and 4 entity types of the business partner data model.
3
Table 3.5 Business Partner Data Model SU Type 1 and 4 Entity Types
130
131
3
Data Modeling
3.2
Standard Data Models
Entity Type
SU Type
Description
Entity Type
SU Type
Description
BP_CUSTAX
4
Tax Classification for Customer
VENCCTXT
4
Texts (Supplier Company Code Data)
BP_CUSWHT
4
Customer: Extended Withholding Tax
VENGENTXT
4
Texts (Supplier General Data)
BP_CUS_CC
4
Customer Company Code Data
VENPOTXT
4
Texts (Supplier Purchasing Organization)
BP_DUNN
4
Dunning Data
WP_EMAIL
4
Workplace Address: Email Address
BP_IDNUM
4
Identification Numbers
WP_FAX
4
Workplace Address: Fax Number
BP_INDSTR
4
Industry
WP_POSTAL
4
Workplace Address: International Versions
BP_MLT_AS
4
Multiple Assignment of Customer/Supplier
WP_TEL
4
Workplace Address: Telephone Number
BP_PORG
4
Purchasing Organization
WP_URL
4
Workplace Address: Internet Address
BP_PORG2
4
Purchasing Data
BP_ROLE
4
Role
BP_SALES
4
Sales Data (Customer)
ness partner data model. Note that the entity types BP_HRCHY and BP_SUBHRY are
BP_TAXGRP
4
Tax Groupings (Suppliers)
assigned with SAP MDG as active area, which implies that these entity types aren’t
BP_TAXNUM
4
Tax Numbers
the business partner data model level.
BP_VENFCN
4
Supplier: Partner Functions
BP_VENGEN
4
General Data (Supplier)
BP_VENSUB
4
Supplier Subrange
BP_WHTAX
4
BP_WPAD
3
Table 3.5 Business Partner Data Model SU Type 1 and 4 Entity Types (Cont.)
Table 3.6 lists the reuse active areas and associated access classes assigned to the busi-
defined as reuse entity types and don’t use the PARTNER reuse active area defined at
Active Area
Description
Access Class
CUS_TYP2CH
Type 2 entities (e.g., tax classification) for customer master
CL_MDG_BS_CUST_TYP2CHK_ACCESS
Extended Withholding Tax
PARTNER
N/A
CL_MDG_BS_BP_ACCESS_MASTER
4
BP Contact Person Workplace Address
SUP_TYP2CH
Type 2 entities (e.g., plant) for vendor master
CL_MDG_BS_SUPPL_TYP2CHK_ACCESS
CUSCCTXT
4
Texts (Customer Company Code Data)
CUSGENTXT
4
Texts (Customer General Data)
CUSSALTXT
4
Texts (Customer Sales Data)
Table 3.6 Business Partner Data Model: Reuse Active Areas
Next let’s focus on the business partner data model and understand how some of the entities and relationships are modeled. Figure 3.21 shows how some of the important
Table 3.5 Business Partner Data Model SU Type 1 and 4 Entity Types (Cont.)
132
entity types are related to each other in the business partner data model.
133
3
Data Modeling
3.2
Standard Data Models
쐍 For BP_HEADER, the Entity Types for Hierarchies customization is maintained as the BP_HRCHY
BP_CUSDUN
BP_CUSGEN
BP_SUBHRY
CUSCCTXT BP_CUS_CC
BP_HEADER
following: – BP_HRCHY is defined as Hierarchy Name.
3
– BP_SUBHRY is defined as No Special Use. BP_CUSWHT
CUSGENTXT
– BP_HEADER is defined as No Special Use.
BP_MLT_AS BP_CUSTAX
BP_CUSFCN
Not modeled as hierarchy
BP_ADDR CUSSALTXT BP_CENTRL BP_VENGEN BP_ROLE
BP_TAXNUM
BP_HRCHY
BP_SALES
BP_DUNN BP_COMPNY
BP_WHTAX
BP_INDSTR
BP_VENSUB
BP_BKDTL
BP_TAXGRP
BP_REL
BP_PORG
VENCCTXT
BP_PORG2 BP_VENFCN
VENPOTXT
Figure 3.21 Business Partner Data Model: Entity Types
Modeled as hierarchy BP_HEADER
VENGENTXT
BP_SUBHRY
Not modeled as hierarchy BP_IDNUM
The business partner data model also can model hierarchies for business partners. From the persistence perspective, entity types BP_HRCHY and BP_SUBHRY are modeled to be flex entity types (the active area is defined as “MDG” at the entity type level). It is important to note that business partner hierarchy is not related to the SAP ERP customer or vendor hierarchies. Figure 3.22 shows how entity types BP_HRCHY, BP_SUBHRY, and BP_HEADER are modeled to facilitate hierarchy creation for business partner records. The following are some important aspects of modeling these three entity types:
Figure 3.22 Business Partner Data Model: Hierarchy
쐍 Entity types BP_HRCHY and BP_SUBHRY aren’t modeled as hierarchies; Is Hierarchy
3.2.3 Financial Data Model
Type? is set to No (as shown Figure 3.22). 쐍 Entity type BP_HEADER is modeled as a hierarchy; Is Hierarchy Type? is set to Yes –
Not Version-Dependent/Not Synchronized.
134
Entity Types for Hierarchies
Now, let’s move on to discuss the final data model delivered by SAP.
The SAP standard financial (0G) data model caters to the data governance of various SAP ERP FI objects such as cost center, profit center, cost element, G/L account, and so on. Refer to the previous chapter for a complete list of SAP ERP FI objects.
135
3
Data Modeling
3.2
Table 3.7 shows a list of all SU type 1 and 4 entity types of the financial (0G) data model Entity Type
SU Type
Description
ACCCCDET
1
G/L account (company code)
ACCOUNT
1
G/L account (chart of accounts)
BDC
1
Breakdown category
BDCSET
1
Breakdown category set
CCTR
1
Cost center
CCTRG
1
Cost center group
CCTRH
1
Cost center group hierarchy
CELEM
1
Cost element
CELEMG
1
Cost element group
CELEMH
1
Cost element group hierarchy
COMPANY
1
Company
CONSCHAR
1
Consolidation characteristic
CONSGRP
1
Consolidation group
CONSGRPH
1
Consolidation group hierarchy
CONSUNIT
1
Consolidation unit
FRS
1
Financial reporting structure
FRSI
1
Financial reporting structure item
FSI
1
Item
FSIH
1
Item hierarchy
Standard Data Models
Entity Type
SU Type
Description
FSIT
1
Text item
PCTR
1
Profit center
PCTRG
1
Profit center group
PCTRH
1
Profit center group hierarchy
SUBMPACK
1
Cause for submission
TRANSTYPE
1
Transaction type
ACCCCAUDT
4
SAP ERP audit information for G/L account (company code)
ACCNTAUDT
4
SAP ERP audit information for G/L account (chart of accounts)
BDCSUBSEL
4
Assignments of subassignments
CCTRAUDIT
4
SAP ERP audit information for cost center
CELEMAUDT
4
SAP ERP audit information for cost element
CGGCURR
4
Entity for currency assignment
CUVERS
4
Entity related to consolidation unit entity
FRSITXT
4
Financial report texts
FSIAUDIT
4
SAP ERP audit information for item
FSIVERS
4
Entity related to item entity
PCCCASS
4
Assignments of profit centers
PCTRAUDIT
4
SAP ERP audit information for profit center
3
Table 3.7 SU Type 1 and 4 Entity Types of the Financial Data Model (Cont.)
Table 3.7 SU Type 1 and 4 Entity Types of the Financial Data Model
136
Figure 3.23 shows type 1 entity types of the financial data model grouped under three main areas. Note that the financial area also uses profit center, profit center group, and profit center hierarchy.
137
3
Data Modeling
Financial
Consolidation GL Account (Company Code)
Chart of Account
Financial Reporting Structure
Company
Controlling
Consolidation Reporting Structure
Breakdown Category Set
Consolidation Chart of Account
Breakdown Category
Cause for Submission
Transaction Type
Consolidation Unit
Profit Center Group Hierarchy
Profit Center Group
Profit Center
Consolidation Group
Cost Center Group Hierarchy
Cost Center Group
Cost Center
Consolidation Group Hierarchy
Cost Element Group Hierarchy
Cost Element Group
Cost Element Hierarchy
Referencing
Consolidation Characteristic
Leading
Figure 3.23 Financial Data Model: Type 1 Entity Types
3.3 Summary This chapter covered the building blocks of SAP MDG data modeling, including entity types, attributes, and relationships. After introducing the building blocks of data modeling, this chapter covered the customization aspects of data modeling. We covered the standard data models for material master, business partner, and financials, as well as how standard data models are modeled.
138
Index A
B
ABAP Dictionary ................................................... 105 ABAP object-oriented programming (OO) ... 283 ABAP repository .................................................... 418 ABAP Workbench ........................................ 513, 523 Account replication ............................................. 330 SOA messages .................................................... 331 Activation ...................................................... 101, 595 configuration ..................................................... 596 Active area ..................................................... 100, 451 checks .................................................................... 452 Ad hoc replication ................................................ 305 Adapters ................................................................... 571 business partners ............................................. 572 material objects ................................................ 574 Address standardization .................................... 279 leveraging SAP DQM ...................................... 280 Agent determination logic ................................ 437 ALE-based replication ......................................... 329 Analytics ................................................................... 343 Analyze log tool ..................................................... 336 Application building block ID (ABBID) ......... 158 Application context API ..................................... 391 Application framework ...................................... 277 Application Link Enabling (ALE) .... 60, 357, 435 Application log ............................................. 150, 335 Application parameters ..................................... 484 Application programming interfaces (APIs) .................................................. 389, 454, 526 Approve Master Data/Extended app ............ 408 Architecture and metadata management ..... 32 Attributes .............................................. 108, 466, 470 adding to entities ............................................. 471 dependencies ..................................................... 456 properties ............................................................ 109 Audit trails ............................................................... 598 Authorization objects ...................... 506–507, 511 fields ...................................................................... 507
Background RFC (bgRFC) .......................... 582, 589 Best record calculation ....................................... 590 properties ............................................................ 591 rules ....................................................................... 591 Bill of materials (BOM) ....................................... 392 BOL and GenIL layer integration .................... 161 BRFplus ............ 188, 226, 240, 266, 433, 573, 593 data objects ........................................................ 274 navigation .......................................................... 267 rule engine .......................................................... 266 rule-based workflows ..................................... 230 rules .................................................... 270, 576, 596 Business activities ................................................ 176 create new ........................................................... 499 determination ................................................... 501 linked .................................................................... 180 UI applications ................................................. 177 Business Add-Ins (BAdIs) ................ 154, 157, 433 data quality and search ................................ 275 workflows ............................................................ 240 Business Address Services (BAS) .................... 572 fuzzy search ....................................................... 246 Business application programming interfaces (BAPIs) .................................................................. 399 Business case ............................................................. 30 Business Configure Sets (BC Sets) ..... 61–62, 64, 144, 409, 582, 588 Customizing synchronization ....................... 72 Business Context Viewer (BCV) ... 144, 193, 345 side panels .......................................................... 204 Business intelligence .......................................... 344 client ..................................................................... 344 embedded content ........................................... 344 finance reports .................................................. 348 SAPMDG deployment ....................................... 59 Business Object Layer (BOL) .......... 151, 454, 480 Business object type codes ............................................................ 114, 454 entity type ........................................................... 115
615
Index
Business objects ........................ 291, 451, 461, 533 code ....................................................................... 457 consolidation .................................................... 568 create new .......................................................... 498 criteria .................................................................. 453 define/assign ..................................................... 320 entity types ......................................................... 292 filter objects ....................................................... 293 Business partner ............................................ 79, 568 category .................................................................. 79 change request types ...................................... 195 group ....................................................................... 79 group hierarchy ................................................... 79 hierarchy ............................................................. 134 relationship ........................................................... 79 role ............................................................................ 79 role category .................................................. 89, 91 workflow template .......................................... 222 Business partner data model ........ 129–130, 133 entity types ......................................................... 134 governace scope ............................................... 169 hierarchies .......................................................... 135 Business partner governance .......................... 194 UIs .......................................................................... 160 Business partner screening .............................. 285 SAP Fraud Management ............................... 286 Business partner type group .................................................................... 195 organization ...................................................... 195 person ................................................................... 195 Business requirements ...................................... 578 Business rules ............................................... 263, 554 Business systems configuration .................................................... 308 data replication framework ........................ 298
C Calculation views .................................................. 350 Central Finance ..................................................... 397 Central governance ......................................... 48, 51 use case ................................................................... 43 Central master data scenarios ......................... 193 Centralized master data system ..................... 289 Change application .............................................. 147 Change pointers .................................................... 337
616
Index
Change request ...................................................... 149 Change request actions ............................ 187–188 Change request analytics ................................... 349 Change request header ....................................... 173 Change request number ....................................... 54 Change request process ............................ 171, 185 setup ...................................................................... 189 UI determination .............................................. 189 Change request step types ................................ 188 Change request steps ........................................... 181 checks .................................................................... 184 configuration ........................................... 181–182 options .................................................................. 184 properties ................................................... 183, 185 Change request types ... 178, 182, 206, 498, 504 create ..................................................................... 502 duplicate checks ................................................ 282 financial controlling ....................................... 199 financial governance ...................................... 201 properties ............................................................. 178 SLAs ........................................................................ 180 Change request UIBB (CRUIBB) ... 145, 435, 488 Change requests ........................ 54, 100, 170–171, 344, 390–391, 497, 545, 548 change document-based ............................... 353 failed ...................................................................... 556 notes ...................................................................... 175 object-based ....................................................... 353 statuses ................................................................. 173 tables ..................................................................... 352 workflow-based ................................................. 353 Change scenario .................................................... 100 Changes highlighting ........................................................ 555 reschedule ............................................................ 542 Check customizing ............................................... 124 Check table ............................................................... 469 Chip ............................................................................. 514 Class Builder ............................................................ 523 Cleansing case ........................................................ 150 Client copy ............................................................... 300 Code lists ................................................................... 264 Co-deployment .................................. 57–58, 61–62 initial build ............................................................ 62 restrictions ............................................................ 59 Communication channels ................................. 296
Company code ....................................................... 467 Company replication .......................................... 331 Compare data model ........................................... 119 Component.js ......................................................... 413 Computing Center Management System (CCMS) ........................................................ 335, 556 Conceptual data model ...................................... 454 Configuration Workbench ................................ 116 Connectors .............................................................. 441 Consistency check ................................................ 588 Consolidation .................................................. 51, 559 analytics ................................................................. 48 initial load .............................................................. 48 mergers or acquisitions .................................... 49 Contact person activation ............................................................... 86 assignment .................................................... 87–88 Content management ........................................... 34 Content management portfolio ........................ 41 key solutions ......................................................... 41 Context parameters ............................................. 437 Context-based adaptations (CBAs) ...... 430, 432 Control file ............................................................... 603 Controlling area .................................................... 464 Convenience APIs ....................................... 391, 558 Core Data Services (CDS) views ....................... 350 Cost center .................................................................. 93 Cost center replication ....................................... 333 Cost element .............................................................. 93 Cost element replication ................................... 332 Create application ................................................ 147 Create scenario ...................................................... 100 Create, read, update, delete (CRUD) operations .............................. 167, 171, 390, 411 Cross-application navigation ........................... 502 CSV Files ................................................................... 603 Custom applications ................................. 447, 497 security and roles ............................................. 506 Custom data models ........................................... 347 create .................................................................... 454 Custom domains ...................................................... 96 Custom object framework ...................... 447, 495 Custom objects ............................................... 45, 506 Custom rules .......................................................... 264 Custom solution ...................................................... 65
Custom theme ....................................................... 420 Customer master ........................................... 80, 205 change request types ...................................... 196 client maintenance ......................................... 397 Customer master data ........................................... 28 Customer master governance ......................... 196 Customer vendor integration (CVI) ................ 84, 129, 425 business partner .................................................. 85 vendor integration ............................................. 91 Customer workflow templates ....................... 225 agent determination ...................................... 226 design ................................................................... 226 Customer, supplier, and business partner replication .......................................................... 328 IDoc messages ................................................... 329 Customizing configurations ............................... 61 Customizing data ............................................. 63, 65 Customizing Distribution ............................. 61, 65 creating ................................................................... 71 monitoring ............................................................ 72 RFCs .......................................................................... 68 Customizing includes ......................................... 121 Customizing layer ................................................ 427 Customizing Scout .................................... 61, 65, 74 RFCs .......................................................................... 68 Customizing synchronization ........................... 63 ALE-based ............................................................... 65 SAP Solution Manager-based ........................ 65
D Data archiving ........................................................... 39 Data consistency ................................................... 563 Data consolidation .................................................. 43 Data conversion .................................................... 363 BAdIs ..................................................................... 363 Data Dictionary .................................. 120, 248, 322 Data domains ............................................................ 76 Data enhancement .............................................. 438 Data enrichment .......................................... 183, 278 Data enrichment integration options ......... 278 SAP Data Quality Management ................ 279 third party tools ............................................... 283 Data enrichment process .................................. 171 Data export framework ...................................... 358
617
Index
Data extraction from SAP ERP ..................................................... 357 Transaction MDMGX-based ........................ 359 Data import ............................................................ 551 Data import framework ............................ 364, 369 Data import process ............................................ 209 change request types ...................................... 210 main tasks .......................................................... 370 Data import/export framework ........... 550–551 Data integration ....................................................... 33 Data load ......................................................... 548, 599 active area .......................................................... 364 non-SAP system ................................................ 602 staging area ....................................................... 365 Data migration ...................................................... 355 considerations .................................................. 368 governance ......................................................... 367 hub vs. co-deployed ........................................ 365 implementation approach ........................... 367 recommendations ........................................... 365 strategies ............................................................. 369 use cases .............................................................. 355 Data modeling ....................................... 99, 101, 447 checks ................................................................... 265 introduction .......................................................... 99 tools ...................................................................... 450 Data model-related configurations .............. 114 Data models ......................... 99, 101, 389, 441, 493 add new entities ............................................... 426 adding attributes ............................................. 425 adding custom fields ...................................... 424 adding existing fields ..................................... 424 attributes ............................................................ 472 create new .......................................................... 457 custom ................................................................. 448 extension ............................................................. 410 extensions ........................................................... 424 filtering ...................................................... 433–434 generated tables ............................................... 119 reports .................................................................. 118 structures ............................................................ 120 Data monitoring ............................................ 27, 398 Data privacy regulations ...................................... 40 Data profiling ............................................................ 26 Data provider class (DPC) .................................. 411 Data quality ..................................................... 33, 578
618
Index
Data quality and search ...................................... 243 Data quality checks .............................................. 593 Data quality connector ....................................... 263 Data quality remediation ......................... 263, 399 Data quality rules .................................................. 171 Data quality scorecards ...................................... 398 Data quality solution integrations ................... 54 Data quality tool .................................................... 263 Data replication .......................... 54, 497, 525, 556 BAdIs ...................................................................... 434 non-SAP systems ............................................... 334 settings ................................................................. 526 target system ..................................................... 532 Data replication framework ................... 289, 335, 434, 498 building blocks .................................................. 291 components ........................................................ 290 configuration objects ............................ 291, 307 custom settings ................................................. 307 customizing check ............................................ 338 operations ........................................................... 335 replication modes ............................................ 304 settings ................................................................. 531 Data replication trigger ...................................... 555 Data transfer directories .................................... 369 Data virus scan ....................................................... 555 Database search ..................................................... 441 Deep-copy ................................................................ 430 Define filter criteria .............................................. 149 Delete data model ................................................. 119 Delete replication log .......................................... 338 Delete replication status .................................... 341 Direct/automatic replication ........................... 304 Display change documents ............................... 149 Display change requests ..................................... 149 Display object replication status .................... 340 Distribution monitor ................................ 150, 546 Distribution types ................................................... 71 Domain-specific UI applications ........... 145, 151 DPC source ............................................................... 412 Duplicate check ............................................ 258, 281 best practices ..................................................... 259 configurations ................................................... 261 hybrid approach ............................................... 259 process modeling configuration ................ 262 search and duplicate check .......................... 259
Duplicate records .................................................. 258 reasons ................................................................. 258 Dynamic GenIL objects ...................................... 151
E Edit data model ...................................................... 116 Edition comparison ............................................. 150 Edition management .......................................... 458 Edition type ............................................................. 191 Edition-based process ......................................... 191 Editions ........................................................... 190, 541 analysis ................................................................ 547 comparing .......................................................... 547 create new ........................................................... 543 defining ................................................................ 191 guidelines ............................................................ 543 monitoring ......................................................... 546 releasing .............................................................. 544 Engineering change record (ECR) ................... 392 Enrichment adapters .......................... 54, 284, 400 Enrichment feeder ............................................... 283 Enrichment framework ...................................... 400 Enrichment process ............................................. 580 Enrichment spots ....................................... 285, 400 Enrichment UI ........................................................ 283 Enterprise asset management ............................ 44 Enterprise Information Management (EIM) ......................................................................... 25 benefits and drivers ............................. 28, 30–31 capabilities ............................................................ 31 cost savings ........................................................... 28 decision making .................................................. 29 operational efficiency ....................................... 28 portfolio .................................................................. 35 program .................................................................. 26 regulatory compliance ..................................... 29 solutions ................................................................. 34 stages ................................................................ 26, 28 strategy ................................................................... 41 Entities ................................................... 458, 475, 493 Entity data model (EDM) ................................... 411 Entity Relationship Model (ERM) diagram ...................................................... 114, 475 Entity type .................................. 102, 120, 133, 475 authorization relevance ................................ 119 filtering ................................................................. 433
Entity type (Cont.) generation .......................................................... 105 keys ........................................................................ 106 properties ............................................................ 104 type 1 ..................................................................... 103 type 2 .................................................................... 103 type 3 ..................................................................... 103 type 4 .................................................................... 104 Entity type properties ......................................... 186 Error message ........................................................ 466 Exact search ............................................................ 246 Existence check ............................................ 109, 466 Explicit filters ......................................................... 294 complex filters .................................................. 295 simple explicit filters ...................................... 295 Extensibility ........................................................... 423 Extension logic ...................................................... 416 Extension point ..................................................... 416 Extension project ................................................. 414 Extract, transform, and load (ETL) ... 35, 355, 599
F Feeder class ................................. 140, 153, 491, 518 File download ......................................................... 385 entity types ......................................................... 385 execute ................................................................. 386 file structure ....................................................... 386 selection ............................................................... 386 settings ................................................................. 386 File export ................................................................ 551 File export framework ........................................ 373 File protocol ............................................................ 334 File repository server (FRS) extraction ........ 358 File upload ...................................................... 378, 550 entity type ........................................................... 379 execute ................................................................. 384 file structure ....................................................... 380 performance issues ......................................... 554 prerequisites ...................................................... 378 upload settings ................................................. 380 Filter objects ........................................................... 292 assign .................................................................... 528 business objects ................................................ 321 define .................................................................... 527 defining ................................................................ 317 entity types ......................................................... 319
619
Index
Filters ................................................................ 293, 536 Finance master data object UIs ....................... 163 Financial accounting governance .................... 94, 164, 197 change request types ...................................... 197 Financial consolidation governance .............. 95, 164, 201 change request types ...................................... 201 Financial controlling governance .................... 95, 164, 198 change request types ...................................... 199 Financial domains ................................................ 163 Financial master data ......................................... 197 elements ................................................................. 93 objects .................................................................. 190 replication .......................................................... 330 Financials workflow templates ....................... 227 Flex entities ............................................................ 425 Flex mode ....................................................... 101, 452 Flexible user interface designer (FLUID) ........................... 140, 142, 428, 489, 520 Floorplan applications ....................................... 144 Floorplan Manager ...................... 50, 55, 140, 151, 479, 488, 517, 555 event ..................................................................... 493 predefined layouts .......................................... 141 translation .......................................................... 522 UIs .......................................................................... 427 wiring ................................................................... 488 Floorplan Manager text tool ............................ 520 Floorplan Manager Workbench ...................... 429 Floorplan Manager–SPI integration (FSI) .... 158 Foreign key relationship .......................... 110, 461 Form UIBB ............................................................... 490 Freestyle UIBBs ...................................................... 140 FTP .............................................................................. 359 Fuzzy matching ..................................................... 586 parallelization ................................................... 587 Fuzzy search .................................................. 246, 575
G G/L account data ...................................................... 93 General Data Protection Regulation ................ 40 Generic Interaction Layer (GenIL) ....... 151, 427, 454, 480 data models ....................................................... 152 model .................................................................... 494
620
Index
Generic Interaction Layer (GenIL) (Cont.) models ................................................................... 476 objects ......................................................... 160, 163 Generic UIBBs (GUIBBs) .................. 140, 489, 520 Governance API ........................................... 390, 557 functions .............................................................. 390 Governance scope ................................................. 168 change impact ................................................... 168 Greenfield implementation ................................ 61 Guided activities floorplan (GAF) ......... 142, 145
H Hadoop ........................................................................ 33 Handler classes ....................................................... 426 Harmonization settings ..................................... 533 Hierarchies ............................................................... 111 attributes ............................................................. 113 entity types ......................................................... 112 validity .................................................................. 112 Hierarchy leading entity .................................... 474 Hierarchy maintenance ..................................... 507 Hierarchy nodes .................................................... 348 Hierarchy processing ....................... 149, 205, 210 business partner IDs ........................................ 214 change request types ...................................... 216 interlocking ......................................................... 216 nodes ..................................................................... 213 UI links .................................................................. 211 Hub deployment ..................................................... 63 initial build ............................................................ 61 Hub versus co-deployment ................................ 58
I IDocs ............................................................................. 54 message type ...................................................... 528 Implicit filters/checks ......................................... 296 Improvement programs ...................................... 27 Indexing .................................................................... 444 InfoObjects .............................................................. 348 InfoProviders .......................................................... 344 Information lifecycle management ................ 34 Inherited rules ........................................................ 264 Initial build ................................................................ 61 Initial synchronization ......................................... 64
In-place navigation .............................................. Interlocking concept ........................................... Intermediate Documents (IDocs) ................... Internet Communication Framework (ICF) services ................................................................. Is Hierarchy Type? ................................................
502 217 334 404 111
K Key assignment ..................................................... 106 prefixes ................................................................. 115 Key fields .................................................................. 465 Key mapping .......... 147, 299, 348, 400, 536, 573 initial loads ......................................................... 374 maintenance ...................................................... 301 search .................................................................... 302 tools ....................................................................... 300 Key performance indicators (KPIs) ..... 149, 344, 402, 559 Key structures ........................................................ 529
L Language-dependent texts ..................... 435, 491 Launchpad designer ............................................ 419 Lazy loading ............................................................ 142 Leading relationship ............................................ 466 Legacy codes ........................................................... 376 Legacy system decommissioning ..................... 40 Level .............................................................................. 58 List UIBB ......................................................... 491, 493 Locations .................................................................. 469 Logical actions ............................................. 176, 500 UI applications .................................................. 177 Logical data model ............................................... 455
M Manual replication ............................................... 305 Mappings ................................................................. 123 configuration ..................................................... 124 Mass change ............................................................ 147 Mass change process ........................................... 206 Mass change request ................................. 207, 548 steps ....................................................................... 548 types ...................................................................... 208
Mass loads ............................................................... 548 Mass processing .................................................... 552 steps ...................................................................... 553 Master data .......................... 47, 289, 355, 497, 584 create/change process ................................... 100 domains ............................................................... 440 import ................................................................... 148 maintenance ...................................................... 507 objects ........................................................... 76, 544 record .................................................................... 283 stewardship tools ................................................ 50 type ........................................................................ 366 valid on date ...................................................... 542 validity date ....................................................... 544 volume ................................................................. 366 Master data governance best practices ..................................................... 244 scenario ............................................................... 168 Master Data Governance Consolidation app ......................................................................... 408 Master Data Governance Mass Processing app ......................................................................... 408 Master data management ............................. 33, 42 solution ................................................................... 48 Master data steward ............................................ 101 Match profiles ........................................................ 249 parameters ......................................................... 249 Matching .................................................................. 585 Material master .................. 76, 193, 204, 568, 598 data model ...................................... 121, 125, 128 governance UIs ................................................. 158 processes ................................................................ 78 simplifications ..................................................... 97 views ........................................................................ 76 workflow template .......................................... 222 Material master replication .............................. 325 outbound implementations ........................ 325 segment filters .................................................. 327 Material matching ................................................ 589 Material objects adaptors .............................................................. 574 Message log ............................................................. 351 Metadata provider class ..................................... 159 Model provider class (MPC) .............................. 411 Monitoring replication tool ............................. 335 web UI fields ....................................................... 336
621
Index
Multiple object processing ............................... Multiple-record processing .............................. change request types ...................................... Multirecord processing ......................................
Index
205 218 219 147
N Networks .................................................................. 448 Nodes ......................................................................... 212 Non-Customizing data synchronization .................................................. 76 Nonharmonized master data .......................... 376 Nonuser agent decision table ................. 232, 234 Normalization ....................................................... 581 Number assignment business partner to customer ........................ 91 business partner to vendor ............................. 92
O Object ID types ...................................................... 324 Object identifier .......................................... 528–529 Object identifier type code ...................... 530, 537 Object identifiers ........................................ 322–323 key structures .................................................... 323 Object instance floorplan (OIF) ....................... 143 Object nodes .................................................. 324, 537 Object type code ................................................... 435 Ongoing synchronization .................................... 64 Open Data Protocol (OData) Services ... 350, 402 extension use cases ......................................... 410 redefinition steps ............................................. 411 Operational Data Provisioning (ODP) .......... 445 Operational efficiency ........................................... 28 Outbound controller .................................. 304, 335 Outbound implementations ........ 296, 533–534 class ....................................................................... 526 configurations .................................................. 315 create .................................................................... 530 enhance default settings .............................. 314 functions ............................................................. 297 outbound parameters .................................... 297 parameters ............................................... 315–316 Overview page floorplan (OVP) ... 142, 145, 520
622
P Package groups ...................................................... 122 Page Builder ............................................................. 513 Parallel processing ................................................ 554 Parallel workflow paths ...................................... 436 Physical data model ............................................. 456 Plants ......................................................................... 468 Point of impact ........................................................ 25 Poor master data quality .................................... 243 challenges ............................................................ 243 Postprocessing Office ............................................ 85 Print forms ............................................................... 156 Process control ....................................................... 391 Process matching .................................................. 591 Process model configuration ..................................................... 568 table view ............................................................. 569 Process modeling ........................................ 167, 497 Process patterns .................................................... 234 Processing time ........................................... 149, 345 Profit center ..................................................... 93, 465 Profit center replication ..................................... 332 Project definition .................... 449, 455, 458, 468, 490, 504, 533 ID ............................................................................. 463 Purchasing ................................................................. 76
Q Quick activities floorplan (QAF) ...................... 144
R Recurring loads ...................................................... 552 Referencing relationship ................................... 465 Regulatory compliance ......................................... 29 Relationships .......................................................... 110 Remote client key search ................................... 246 Remote function call (RFC) ................................ 445 Remote function call (RFC) connection ....... 345 Replicate by object selection ............................ 148 Replicate by replication model ........................ 148 Replication models ........................... 298, 308, 533 activation ............................................................ 535 defining ................................................................ 309
Replication models (Cont.) outbound implementations ........................ 311 outbound parameters .................................... 313 target systems ................................................... 312 Replication modes ................................................ 304 Replication timing ............................................... 542 Request Business Partner app ......................... 404 Request Customer app ....................................... 406 Request Customer Change app ....................... 406 Request New Cost Center app .......................... 404 Request New Material app ................................ 407 Request Profit Center app ................................. 407 Request Supplier app .......................................... 408 Requester roles ...................................................... 164 RESTful APIs ............................................................ 396 Retail and fashion management ....................... 45 Retention management ........................................ 40 Reuse active area ...................... 101, 451, 461, 508 Reuse class ............................................................... 452 Reuse entities ......................................................... 425 Reuse mode ............................................................. 451 Reuse UIBBs (RUIBBs) .......................................... 140 RFC destination ..................................................... 589 Roles ........................................................................... 509 authorization .................................................... 511 custom .................................................................. 509 customer/FI customer ................................ 79, 89 translation .......................................................... 524 vendor/FI vendor ......................................... 79, 91 Root object ............................................................... 477 Root-cause analysis .............................................. 556 Rule-based workflows ............................... 229, 436 change request process .................................. 238 designing ................................................... 236–237 process patterns ............................................... 234 Rules ........................................................................... 270 Rules/data validation ............................................. 54
S SAP Agile Data Preparation ......................... 37–38 key features ........................................................... 39 SAP Ariba .................................................................. 395 SAP Business Client .................... 56, 144, 509, 518 SAP Business Suite ............................ 158, 450, 544 SAP Business Warehouse (SAP BW) ............... 345 SAP Business Workflow ...................................... 498
SAP content management solutions ............... 41 SAP Credit Management ................................... 398 SAP CRM ................................................................... 397 SAP Data Dictionary ............................................ 265 SAP Data Quality Management (DQM) ....... 246, 279 SAP Data Services .......................................... 35, 367 capabilities ............................................................ 35 SAP Enterprise Architecture Explorer ............. 97 SAP Enterprise Asset Management (SAP EAM) .............................................................. 45 SAP Enterprise Portal ............................................. 55 SAP Enterprise Search ...................... 246, 426, 441 SAP ERP Financials (FI) ....................................... 398 objects .................................................................. 135 SAP ERP master data tables .............................. 101 SAP ERP Plant Maintenance ................................ 45 SAP ERP Project System ..................................... 448 SAP ERP tables ........................................................ 424 SAP Extended Enterprise Content Management (SAP Extended ECM) by OpenText .............. 41 SAP Fiori architecture ........................................................ 402 components ....................................................... 410 consolidation .................................................... 578 extensibility ....................................................... 409 overview .............................................................. 401 SAP MDG apps .................................................. 403 SAP Fiori apps ......................... 53, 55–56, 139, 401 enhancements ................................................... 412 extension steps ................................................. 414 SAP Fiori launchpad ..................................... 56, 402 design catalog ................................................... 419 extension ............................................................. 418 SAP Fraud Management .................................... 285 SAP Gateway ........................................................... 402 SAP Gateway server ............................................. 414 SAP Gateway Service Builder ........................... 411 SAP General Ledger (G/L) .................... 44, 47, 164 SAP Global Trade Services (GTS) ........................ 98 SAP HANA ................................................................... 38 SAP HANA artifacts .............................................. 484 SAP HANA fuzzy search ..................................... 586 SAP HANA search .............................. 247–248, 442 extensibility ....................................................... 256 flex entities ......................................................... 258
623
Index
SAP HANA search (Cont.) generating .......................................................... 251 setup ..................................................................... 251 view ....................................................................... 483 Web Dynpro application ............................... 251 SAP HANA smart data integration ................... 37 SAP HANA smart data quality ......... 37, 572, 588 SAP HANA Studio ..................... 352, 443, 601, 603 SAP HANA views .......................................... 350, 354 SAP HANA-based analytics ............................... 349 SAP Hybris Product Content Management 395 SAP Information Lifecycle Management (SAP ILM) ................................................................ 39 SAP Information Steward .......................... 36, 398 capabilities ............................................................ 36 SAP Landscape Transformation Replication Server (SLT) ...................................... 350, 358, 601 SAP MDG ........................................... 42, 47, 139, 289 8.0 .......................................................................... 390 analytics .............................................................. 343 APIs ........................................................................ 153 architecture ........................................................... 50 BAdIs ..................................................................... 433 business functions .............................................. 51 change pointers ................................................ 435 consolidation vs central governance ......... 43 data conversion option ................................. 363 data enrichment framework ....................... 283 deployment ........................................................... 47 deployment options .......................................... 57 editions ................................................................ 541 EIM ............................................................................ 26 enterprise content .............................................. 44 enterprise master data ..................................... 42 extensibility ....................................................... 423 file upload/download .................................... 377 finance UI applications ................................. 163 foundation framework .................................. 451 governance scope ............................................ 168 hierarchy ............................................................. 472 integration scenarios ..................................... 389 integration with SAP solutions .................. 392 languages ........................................................... 517 operational strategies ................................... 541 performance optimization .......................... 554 replication-related BAdIs .............................. 439
624
Index
SAP MDG (Cont.) SAP HANA database .......................................... 62 SAP PLM integration ....................................... 393 simple checks ..................................................... 264 solution components ........................................ 52 third-party integration .................................. 399 troubleshooting ................................................ 556 UI navigation ..................................................... 502 UIs ............................................................................. 54 use cases ................................................................. 48 workflow BAdIs ................................................. 436 SAP MDG communicator ...... 391, 484–485, 488 SAP MDG hub .................................................. 57, 203 data migration .................................................. 368 data replication ................................................ 292 number range settings ..................................... 59 SAP MDG UI ............................................................. 139 central governance ............................................ 53 consolidation ....................................................... 53 framework ........................................................... 144 SAP MDG, central governance ..... 244, 423, 553 address standardization ................................ 279 analytics ............................................................... 345 data migration .................................................. 355 duplicates ............................................................ 259 integrations ........................................................ 283 SAP MDG, consolidation adaptors ........................................... 571, 585, 595 overview ............................................................... 560 prerequisites ....................................................... 564 process flow ........................................................ 563 process models .................................................. 569 scope ...................................................................... 577 security roles ...................................................... 564 services ................................................................. 565 transactions ........................................................ 564 use cases ............................................................... 561 SAP MDG, Financials ..................................... 94, 330 object extraction .............................................. 358 objects ................................................................... 101 SAP MDG, mass processing ............................... 578 SAP MDG, Product ...................................... 393, 395 SAP MDG, Supplier ..................................... 394–395 SAP NetWeaver MDM extractor ...................... 358 SAP Notes for SAP MDG ........................................ 60 SAP Process Integration (SAP PI) ..................... 396
SAP Product Lifecycle Management (SAP PLM) ............................................................ 392 SAP S/4HANA ............................... 96, 204, 394, 450 architecture and deployment options ........ 97 master data domains ........................................ 97 SAP S/4HANA Finance ........................................ 397 SAP Screen Personas ............................................ 432 SAP Smart Business apps ................................... 402 SAP Smart Business Cockpits ........................... 350 SAP Smart Business content ............................ 344 SAP Solution Extensions ...................................... 41 SAP Solution Manager-based synchronization .......................................... 65–66 setup ......................................................................... 67 SAP Supplier Lifecycle Management ............ 393 SAP Supplier Relationship Management (SAP SRM) ............................................................ 392 SAP Supply Chain Management (SAP SCM) ............................................................ 392 SAP Theme Designer ........................................... 420 SAP Transport Management System (TMS) ........................................................................ 64 SAP Web IDE .................................................. 413, 416 SAPUI5 ....................................................................... 413 Scope governance entity level .......................................................... 179 Search applications ........................... 146, 246, 484 Search configuration ........................................... 146 Search control ........................................................ 485 Search functionality ............................................ 244 BAdIs ..................................................................... 443 business activities ............................................ 244 Search helps ...................... 105, 109, 246, 429, 483 Search object connector ..................................... 277 Search template ..................................................... 485 Segment filters ....................................................... 292 Semi-automatic synchronization ..................... 64 Service level agreements (SLAs) ..... 27, 149, 344 Service Mapping Tool (SMT) .......... 123, 425, 526 Service Provider Infrastructure (SPI) ............ 158 framework .......................................................... 484 Service-oriented architecture (SOA) ... 358, 395 Single Object Maintenance (SOM) UI ............................................ 390, 486, 501 configuration ..................................................... 487 Single-record processing ................................... 193
Single-value decision table ............................... 230 SMT mapping ......................................................... 426 SOA-based replication ........................................ 328 Software component installation ..................... 51 Source tables .......................................................... 600 SPI Metadata Browser ......................................... 158 Staging area ............................................... 54, 99, 451 Staging/active areas ............................................ 364 Staging-active concept ....................................... 244 Standard data models ................................ 125, 400 Standard financial (0G) data model .............. 135 Standard UI configurations .............................. 155 Standardization ..................................................... 580 parallelization ................................................... 582 Status logs ............................................................... 554 Status report ........................................................... 346 Storage type ................................................... 102, 107 Strategic benefits ..................................................... 31 SU type ...................................................................... 476 Subnodes ................................................................. 212 Supplier client maintenance ............................ 394 Supplier master ..................................................... 205 change request types ...................................... 197 governance ......................................................... 196 Supplier workflow templates .......................... 222 agent determination ...................................... 224 design ................................................................... 222 Synchronization groups ....................................... 69 Synchronization objects ................................ 68, 85 Synchronized hierarchy .................................... 111 System calls ............................................................ 437 System Landscape Directory (SLD) ................ 531 business systems .............................................. 298
T Tactical benefits ....................................................... 31 Tansaction handler class ................................... 491 Target tables ........................................................... 332 Technical UIBB ....................................................... 488 Text data processing .............................................. 35 Track My Requests app ....................................... 408 Transaction /IWFND/MAINT_SERVICE ............................ 412 /UI2/FLP ...................................................... 409, 420 /UI2/NWBC_CFG_CUST ................................. 420
625
Index
Transaction (Cont.) /UI2/NWBC_CFG_SAP ................................... 420 /UI2/SEMOBJ ..................................................... 420 /UI2/SEMOBJ_SAP ........................................... 420 /UI5/THEME_DESIGNER ............................... 420 BRF+ ...................................................................... 576 BSANLY_BI_ACTIVATION ............................. 344 CG3Z ...................................................................... 370 CJ20N .................................................................... 499 CREATE_MASS_ID_MAP ............................... 375 DRFCC ................................................................... 338 DRFF ...................... 296, 305, 309, 318–319, 536 DRFIMG ............................................................... 534 DRFLOG ............................................................... 336 DRFLOGDEL .................................... 338–339, 554 DRFOUT ......................... 305–306, 336, 554–555 DRFRSD ................................................................ 340 DRFRSDEL .................................................. 341, 554 DTEXPORT ................................................. 148, 358 DTIMPORT ................................................. 148, 209 FILE ..................................................... 308, 369, 375 FPM_WB .............................................................. 429 GENIL_BOL_BROWSER. ................................. 151 GENIL_MODEL_BROWSER .................. 151, 161 LPD_CUST ............................... 145, 419, 432, 516 LTR ......................................................................... 601 MDB ...................................................................... 158 MDCIMG ................................................................. 63 MDG_ADJUST_IDM ........................................ 300 MDG_ANALYSE_IDM ............................ 302, 374 MDG_BS_BP_CR_BCSET4 ............................. 195 MDG_BS_MAT_CR_BCST06 ........................ 193 MDG_BS_SUP_CR_BCSET7 .......................... 197 MDG_BS_VL_CR_BCSET4 ............................. 197 MDG_FIN_BCSET_CR_06 ............................. 203 MDG_GEN_HBA_CR ....................................... 350 MDG_GEN_HBA_CR_EXT ............................ 350 MDG_HDB_GEN_UI ....................................... 443 MDG_KM_MAINTAIN ................................... 301 MDGCPDEL ......................................................... 555 MDGIMG .................................. 63, 114, 139, 363, 399, 426, 431, 451 MDMGX .................................. 357, 359–360, 362 MGIMG ................................................................ 153 NWBC .................................................... 55, 245, 370 PFCG ...................................................................... 420 RSA5 ...................................................................... 344
626
Index
Transaction (Cont.) RSOR ...................................................................... 344 SCDT_FETCH ........................................................ 73 SCDT_GROUPS ............................................. 68–69 SCDT_LOG ............................................................. 72 SCDT_MAPPING .................................................. 68 SCDT_SETUP .................................................. 68, 71 SCOUT ..................................................................... 74 SCPR20 .................................................................... 62 SE10 ........................................................................ 253 SE11 ......................................................................... 264 SE16N ..................................................................... 600 SE24 ........................................................................ 523 SE63 .............................................................. 522, 525 SE80 .......................................... 155, 254, 513, 522 SEGW ..................................................................... 411 SFP .......................................................................... 156 SFW5 .................................................................. 51, 62 SICF .................................................................. 62, 565 SLG1 .................................................... 310, 335, 378 SM34 ...................................................................... 427 SM59 .................................. 67, 280–281, 286, 308 SOLAR_PROJECT_ADMIN ........................ 67–68 SPERS_MAINT .................................................... 432 STC01 ..................................................................... 404 SWE2 ...................................................................... 566 SWU3 ....................................................................... 62 USMD_RULE ....................................................... 267 Transaction control .............................................. 391 Transactional data .................................................. 66 Translation ............................................................... 516 Translation Editor ....................................... 523–524 Transports .................................................................. 61 TREX ................................................................. 345, 440 Troubleshooting .................................................... 558 Type 1 entity ....................................... 458, 461, 498 Type 3 entity ........................................................... 465
User interfaces (UI) ................................. 36, 54, 139 CBAs ....................................................................... 430 configurations ................................................... 484 copy application configuration ................. 430 custom creation ................................................ 478 custom object .................................................... 481 customizing ........................................................ 427 design .................................................................... 481 develop ................................................................. 482 edit page .............................................................. 482 enhancement ..................................................... 429 extension ............................................................. 412 framework .......................................................... 479 main page ........................................................... 482 modeling ................................................... 139, 447 modeling metadata ........................................ 451 modification ...................................................... 431 personalizing ..................................................... 428 search screen ...................................................... 481 Utopia ........................................................................... 45
V Validations .................................................... 574, 593 BAdI-based .......................................................... 275 Validity dates .......................................................... 366 Validity UIBBs ........................................................ 145 Valid-to date ........................................................... 191 Value drivers .............................................................. 31 Value lists ................................................................. 539 Value mapping .......................... 303, 400, 538, 573 initial loads ......................................................... 376 Vendor account groups ......................................... 92 Vendor integration ................................................. 91 Vendor lifecycle ..................................................... 298 Vendor master .......................................................... 82 Vendor master data ............................................. 222
Vendors .................................................................... 298 Version dependent hierarchy ......................... 111 VIP indicator .............................................................. 89 Virtual data models (VDMs) ............................. 350
W WBS elements ............................ 449, 455, 461, 504 attributes ............................................................ 495 create and change ........................................... 493 Web Dynpro ............... 54, 283, 432, 444, 480, 513 components ....................................................... 142 UIBBs ..................................................................... 141 Web Dynpro applications ................................. 345 business partner governance ...................... 162 finance object-related governance ........... 164 master data processing ................................. 145 material master governance ....................... 160 Web services ........................................................... 334 Where-used list ...................................................... 150 Work breakdown structure (WBS) ................. 447 business activities ............................................ 500 conceptual data model ................................. 455 hierarchy ............................................................. 472 project definition ............................................. 449 Workflow agents ................................................... 436 Workflow Builder .................................................. 188 Workflow decision tables .................................. 436 Workflow log .......................................................... 150 Workflow process modeling ............................ 219 Workflow templates ..................................... 53, 219 standard .............................................................. 222 Workflows ................................................................ 438 assign processors ............................................. 505 settings ................................................................. 505 Worklist .................................................................... 145
U Ungoverned fields ................................................ 168 Universal unique ID (UUID) .............................. 374 User agent decision table ................................... 231 User experience ..................................................... 139 User interface building blocks (UIBBs) ........................... 140, 428, 482, 520, 555
627
First-hand knowledge.
Homiar Kalwachwala is a senior consulting manager at SAP. He is the head of the Global Cloud Integration & Middleware services practice community at SAP.
Sandeep Singh Chahal is a principal business processes consultant working for SAP‘s Data Technology & Services team since 2015.
Santhosh Kumar Cheekoti is a principal consultant at SAP America. He has more than 11 years of experience in SAP consulting.
Antony John Isacc is a principal architect for SAP America with a consulting focus in enterprise information management solutions.
Rajani Khambhampati joined SAP in 2007 and is a principal architect with the DBS team at SAP America.
Homiar Kalwachwala, Sandeep Chahal, Santhosh Cheekoti, Antony Isacc, Rajani Khambhampati, and David Quirk
David Quirk is a senior director in the SAP EIM solution management team.
SAP Master Data Governance: The Comprehensive Guide to SAP MDG 627 Pages, 2017, $79.95 ISBN 978-1-4932-1433-4
www.sap-press.com/4192
We hope you have enjoyed this reading sample. You may recommend or pass it on to others, but only in its entirety, including all pages. This reading sample and all its parts are protected by copyright law. All usage and exploitation rights are reserved by the author and the publisher.
