C_MDG_1909 SAP – Master Data Governance Interview Questions

The SAP Certified Application Associate – Master Data Governance exam, C_MDG_1909, is designed to verify that you have the fundamental and core knowledge required for the application consultant role. The SAP C_MDG_1909 exam verifies that you have a broad grasp and in-depth technical abilities necessary to serve as a mentor on a project team.

1.) What is SAP MDG and how does it work?

SAP Master Data Governance (MDG) is a cutting-edge master data management technology strategy that enables out-of-the-box master data management to centralize master data production, revision, and distribution or to integrate master data through the corporate infrastructure.

2.) What is ERP and how does it work?

ERP stands for Enterprise Resource Planning Software, which is a computer system that allows businesses to manage their resources more efficiently. It manages workflows and allows information to be shared between various entities within an organization or enterprise.

3.) What SAP products are available?

SAP R/3 is the successor to SAP R/2 and is the industry leader in enterprise resource planning. The Presentation, Logic, and Data tiers are referred to as R/3 in a three-tier architecture. SD, FI, and HR are just a few of the modules that cover practically every corporate department.

mySAP – It is a collection of SAP products that includes SAP R/3, SRM, PLM, CRM, and SCM in addition to SAP R/3.

4.) What is NetWeaver, exactly?

• Netweaver is a sophisticated infrastructure platform that allows all mySAP suite items to run on a single Netweaver instance, known as SAP Web Application Server (SAP WEBAs).
• Netweaver has the advantage of allowing you to access SAP data through the network (HTTP protocol) or even on a mobile device.
• You can save money by using the SAP Client-side GUI to teach users.

5.) When it comes to metadata, master data, and transaction data, what’s the difference?

Meta data refers to information about other data. It contains information as well as MetaObjects.

Customer information, personnel information, and material information are all examples of master data. This data resembles reference data more closely. If a customer buys ten units of your product, for example, instead of asking for the customer’s shipping address ten times, the same information can be acquired from the Customer Master Data.

Transaction data refers to the specifics of everyday transactions.

6.) Is it possible to run a company warehouse without SAP R/3?

Yes, a corporate warehouse can be run without R/3 by simply moving structures from enterprise data warehouse sources (ODS table, Infocube) into incoming data files or utilising third-party tools to integrate flat files and other data resources.

7.) What is the definition of a variable?

The variables are query parameters defined in the parameter’s query description, which is empty before inserting queries into the workbooks.

8.) Define the many kinds of variables.

• Default type/user entry
• Path of Replacement
• Types of Processing
• Formulas
• Text
•  Hierarchies
•  Characteristics variable
•  Hierarchy nodes

9.) Describe a handful of SAP’s flaws.

• It is pricey.
• It necessitates the use of highly qualified staff.
• It necessitates a lengthy deployment period.
• The user interfaces are quite complicated.
• It doesn’t say where the master data is stored.

10.) What is the difference between data mining and online analytical processing (OLAP)?

OLAP: This is a database monitoring platform that understands the schema, measurements, and composition facts.

Data mining:  is a technique for examining data in order to find persistent correlations and systematic links between variables.

11.) What are the three stages of data mining?

• Deployment
• Initial Exploration 
• Model building

12.) What are the R/3 system’s many layers?

• Database
• Application
• Presentation 

13.) How do you go about creating a table in the data dictionary?

• Domain registration 
• Table creation 
• Create data elements 

14.) What does AWB stand for?

All data staging and processing procedures are controlled and maintained by the Administrator Workbench in the business information warehousing system.

15.) What exactly is Bex?

Business Explorer is referred to as Bex. It allows users to locate reports, review data, access reports, and conduct queries. In addition, the Bex browser allows workbook queries to save their specific responsibilities. It is made up of the Bex Map, the Bex Analyzer, and the Bex Web.

16.) What part in BIW does ODS play?

An ODS object is used to contain debugged and consolidated transaction records at the document level. A dataset that has been combined from one or more data sources is referred to as a composite dataset. A Bex or an Infoset query can be used to analyze this data collection. Within the same device or across systems, a delta update can update the data in an ODS object into InfoCubes or other ODS objects. ODS objects store data in transparent, flat database tables, as opposed to InfoCubes’ multi-dimensional data storage.

17.) What is the difference between the terms “domain” and “data element”?

A Data Element is a link between the domain types and the table types.

The length, form, and permissible value range Q19 of the attributes are defined by the domain.

18.) What is the difference between the parameters SET and GET?

You must first set parameter ID values in the global memory area before retrieving them from the memory ID area. For example, in the case of an online program, you must “Set” values from screen fields before “getting” them.

19.) What exactly are ALE, IDOC, EDI, and RFC?

• ALE is used to enable Application Linking.
• RFC is a protocol that is used to call a remote function.
• Electronic data interchange is referred to as EDI.
• Intermediary documents are used in IDOC format.

20.) What exactly does BDC stand for? What is the total number of BDC methods?

Batch Data Communication is abbreviated as BDC. The BDC techniques are

• Call Transaction 
•  Direct Input
• Batch Input Session

21.) When you say “one-time vendors,” what exactly do you mean?

In some businesses, it is impossible to create new master records for vendors and trading partners. The use of a fictitious vendor code on invoice input is possible with a one-time vendor. The data that would normally be kept in the vendor master is directly entered on the invoice.

22.) What are the steps in the SAP Payment Run?

The following are SAP’s standard steps for executing the SAP Payment Run:

• Parameter entry: This includes, among other things, business codes, vendor accounts, and payment systems.
• Proposal scheduling: the system generates a collection of invoices to be paid.
• Individual payments are placed into the ledger during payment booking.
• Printing of payment forms: Printing of payment forms.
• How do the’residual payment’ and ‘partial payment’ techniques of cash allocation in a receivable account differ?
• Partially paid invoice: Assume invoice A456 is submitted for $100 and the customer pays $70. It subtracts the half bill from the invoice, leaving a $30 balance.
• Residual payment: During the residual payment, Invoice A456 will be cleared for $100, and a new invoice line item will be created for the balance of $30.

23.) What are internal tables, tables, tables with values, and translucent tables?ent tables are all terms used to describe different types of tables.

• It’s a typical data form object that only exists during the execution of the application.
• The table would perform a field-level check.
• At the domain stage, the value table will be checked.
• Transparent tables will have the identical form in the dictionary as well as the database, with the same precise details and fields.
• In SAP R/3, specify the presentation application and database servers.
• The application layer of the R/3 system is made up of the application server and the message server. The application programmes in an R/3 system run on application servers. The presentation elements, the database, and each other are all connected to the application servers via the message server.

24.) In SAP, explain what a company is.

In SAP, a company is the highest corporate body with which the organization’s financial outcomes, such as profit and loss statements and balance sheets, can be produced. One or more company codes can make up a single firm. All enterprise codes must have the same COA (chart of accounts) and fiscal year, according to SAP.

25.) What’s the difference between SAP BASIS and SAP ABAP?

The programming language SAP ABAP is used for SAP customization, type development, and reporting. The administration module, albeit SAP BASIS is the foundation, is used to manage code changes, upgrades, database management, and network configuration, among other things.

26.) What does it mean to have a “expanded star schema”?

The fact and dimensions tables make up the star schema. In addition, master data tables are maintained in a separate table containing references to the dimensional tables’ attributes. At the same time, the Extended Star Schema makes reference to these many master data tables.

27.) What is the best way to write a BDC programme?

The following is the solution to writing BDC software:

• Convert legacy system data to a “Conversion” flat table file.
• To transfer the flat file to the SAP System, use “SAP Data Transfer.”
• Depending on the BDC type, call transactions or create sessions.

28.) Mention the main benefits of BW reporting over R/3 reporting.

The Business Warehouse collects and stores data using a database and OLAP ideas, whereas the R/3 is set up for transaction processing. The same analysis may be done in R/3, but it is much easier with a BW.

29.) Make a distinction between the two sorts of communication services.

You should utilize two sorts of communication services to manage communication:

Message Delivery Service: This service is used by app servers to send and receive short internal messages.

Gateway Services: This service facilitates connectivity between R/3 and external applications using the CPI-C protocol.

30.) Mention the cause codes for account receivables in SAP Master Data Governance.

Reason codes are labels that can be applied to incoming consumer payments to describe underpayments or overpayments. They are incompatible with the “void reason codes” that are used to create outbound checks.