Entities in SAP Datasphere from S4

In SAP Datasphere, entities represent real-world business objects or concepts. They are the foundation for modeling and understanding your data. Think of them as the "nouns" in your data vocabulary.

Entities are typically represented as tables with columns (attributes) that describe the characteristics of the entity.

Here are some examples of entities from SAP S/4HANA, and how they might be represented in SAP Datasphere:

1. Customer Entity:

• In S/4HANA: Customer master data is stored in tables like KNA1 (General Data), KNB1 (Company Code Data), and ADRC (Addresses).
• In Datasphere: You might create a "Customer" entity that combines relevant attributes from these tables, such as:
  • Customer ID (KUNNR)
  • Customer Name (NAME1)
  • City (ORT01)
  • Country (LAND1)
  • Customer Group (KTOKD)

2. Product Entity:

• In S/4HANA: Product data resides in tables like MARA (General Material Data), MARC (Plant Data), and MBEW (Material Valuation).
• In Datasphere: A "Product" entity could include:
  • Material Number (MATNR)
  • Material Description (MAKTX)
  • Material Type (MTART)
  • Unit of Measure (MEINS)
  • Gross Weight (BRGEW)

3. Sales Order Entity:

• In S/4HANA: Sales order information is stored across tables like VBAK (Sales Order Header), VBAP (Sales Order Item), and LIKP (Delivery Header).
• In Datasphere: You could model a "Sales Order" entity with attributes like:
  • Sales Order Number (VBELN)
  • Order Date (AUDAT)
  • Customer ID (KUNNR)
  • Material Number (MATNR)
  • Order Quantity (KWMENG)

4. Employee Entity:

• In S/4HANA: Employee data is found in tables like PA0001 (Infotype 0001 – Organizational Assignment), PA0002 (Infotype 0002 – Personal Data), and PA0006 (Infotype 0006 – Addresses).
• In Datasphere: An "Employee" entity could combine:
  • Employee ID (PERNR)
  • Employee Name (VORNA, NACHN)
  • Department (ORGTX)
  • Job Title (PLSTX)
  • Hire Date (EINDA)

Key Takeaways:

• Entities in SAP Datasphere provide a structured representation of business objects.
• They are based on tables and attributes from source systems like SAP S/4HANA.
• Datasphere allows you to combine and harmonize data from multiple sources into meaningful entities.
• These entities then become the building blocks for creating analytical models, reports, and dashboards.