Data products
Data products in Cortex Framework represent the curated, logical packaging of data assets engineered to solve specific business problems. They serve as the ultimate business-facing layer, directly powering business intelligence (BI) dashboards, reporting tools, machine learning models, and autonomous agents.
Dataform pipelines function as the execution engine for these data products. They run ELT (Extract, Load, Transform) processes that aggregate, join, and shape data from the standardized data foundation layer—and, where applicable, other upstream data products—into these final, consumer-ready structures.
Key concepts
Data asset - A pointer to a physical data resource, such as a BigQuery dataset, table, or view. A data product contains one or more assets.
Data product - A curated, logical grouping of data assets, formally packaged to be discoverable, trusted, and accessible for solving specific business problems. Cortex Framework delivers two types of data products:
Source-aligned data products: A collection of tables in an analytical data model (for example, Sales Orders or Customers). These products feed from the data foundation layer, serve as foundational entities, and can be used to feed more complex use-case-specific models.
Consumption data products: Specialized analytical models engineered for particular business scenarios, delivering complex KPI logic and high-fidelity metrics (for example, Sales Performance Insights). Consumption data products typically consume and aggregate upstream data foundation modules, as well as source-aligned data products, to drive immediate decision-making.
Data products for SAP ERP
The following table outlines the catalog of data products available for SAP ERP (ECC and S/4HANA) within Cortex Framework, detailing their functional descriptions, source tables, and supported source systems.
| Data product | Data asset | Description | Source tables | Source systems | |
|---|---|---|---|---|---|
| SAP ECC | SAP S/4HANA | ||||
| Accounting Documents | Accounting Documents Header | Accounting document headers at the granularity of Client(System), Company Code, Accounting Document Number, and Fiscal Year. | bkpf, tcurx |
✅ | ✅ |
| Accounting Documents Item | Accounting document items at the granularity of Client(System), Company Code, Accounting Document Number, Fiscal Year, and Line Item Number. | bkpf, bseg, t005, tcurx |
✅ | ✅ | |
| Accounts Payable | Accounts Payable | Accounts payable journal entries at the granularity of Client(System), Ledger, Company Code, Fiscal Year, Document Number, and Line Item. | acdoca, bkpf, bseg |
✅ | |
| Vendor Cleared Items | Vendor cleared items at the granularity of Client(System), Company Code, Vendor, Special G/L Transaction Type, Special G/L Indicator, Clearing Date, Clearing Document, Assignment, Fiscal Year, Document Number, and Line Item. | bkpf, bsak |
✅ | ||
| Vendor Open Items | Vendor open items at the granularity of Client(System), Company Code, Vendor, Special G/L Transaction Type, Special G/L Indicator, Clearing Date, Clearing Document, Assignment, Fiscal Year, Document Number, and Line Item. | bkpf, bsik |
✅ | ||
| Accounts Receivable | Accounts Receivable | Accounts receivable journal entries at the granularity of Client(System), Ledger, Company Code, Fiscal Year, Document Number, and Line Item. | acdoca, bkpf, bseg |
✅ | |
| Customer Cleared Items | Customer cleared items at the granularity of Client(System), Company Code, Customer, Special G/L Transaction Type, Special G/L Indicator, Clearing Date, Clearing Document, Assignment, Fiscal Year, Document Number, and Line Item. | bkpf, bsad |
✅ | ||
| Customer Open Items | Customer open items at the granularity of Client(System), Company Code, Customer, Special G/L Transaction Type, Special G/L Indicator, Clearing Date, Clearing Document, Assignment, Fiscal Year, Document Number, and Line Item. | bkpf, bsid |
✅ | ||
| Addresses | Addresses | Addresses at the granularity of Client(System), Address Number, Valid From Date, Version ID for International Addresses, Person Number, and Sequence Number. | adrc, adr6, adrct |
✅ | ✅ |
| Agency Business Settlement Documents | Agency Settlement Document Headers | Agency settlement document headers at the granularity of Client(System) and Settlement Document Number. | wbrk |
✅ | ✅ |
| Agency Settlement Document Items | Agency settlement document items at the granularity of Client(System), Settlement Document Number, and Document Item Number. | wbrk, wbrp |
✅ | ✅ | |
| Billing Documents | Billing Document Headers | Billing document header details at the granularity of Client(System) and Billing Document. | vbrk |
✅ | ✅ |
| Billing Document Items | Billing document item details at the granularity of Client(System), Billing Document, and Item Number. | vbrk, vbrp |
✅ | ✅ | |
| Billing Blocking Reasons | Billing blocking reasons at the granularity of Client(System), Language Key, and Billing Block. | tvfst |
✅ | ✅ | |
| Business Partners | Business Partners | Business partners at the granularity of Client(System) and Business Partner. | but000 |
✅ | ✅ |
| Business Partner Addresses | Business partner addresses at the granularity of Client(System), Business Partner, Address Number, and Valid From. | adrc, adr6, adrct, but020 |
✅ | ✅ | |
| Business Partner Bank Details | Business partner bank details at the granularity of Client(System), Business Partner, Bank Details ID, and Valid From. | but0bk |
✅ | ✅ | |
| Condition Contracts | Condition Contracts Header | Condition contracts header details at the granularity of Client(System) and Condition Contract Number. | wcocoh |
✅ | ✅ |
| Condition Contracts Item | Condition contracts item details at the granularity of Client(System), Condition Contract Number, and Item GUID. | wcocoi |
✅ | ✅ | |
| Rebates Settlement Calendar | Rebates settlement calendar at the granularity of Client(System), Condition Contract Number, Settlement Date, and Settlement Date Sequential ID. | wb2_d_settl_cal |
✅ | ✅ | |
| Condition Contract Settlement Detailed Statement | Condition contract settlement detailed statements at the granularity of Client(System), Condition Contract Number, Document Number, Document Item, and Business Volume Document keys. | wb2_d_bvdetail |
✅ | ✅ | |
| Controlling Areas and Cost Elements | Controlling Area Assignment | Controlling area assignments at the granularity of Client(System), Company Code, and Business Area. | tka02 |
✅ | ✅ |
| Controlling Areas | Controlling areas at the granularity of Client(System) and Controlling Area. | tka01 |
✅ | ✅ | |
| Cost Elements | Cost elements at the granularity of Client(System), Controlling Area, Cost Element, Valid To Date, and Language Key. | cskb, csku, tka01 |
✅ | ✅ | |
| Cost and Profit Centers | Cost Centers | Cost centers at the granularity of Client(System), Controlling Area, Cost Center, Valid To Date, and Language Key. | csks, cskt |
✅ | ✅ |
| Profit Centers | Profit centers at the granularity of Client(System), Profit Center, Valid To Date, Controlling Area, and Language Key. | cepc, cepct |
✅ | ✅ | |
| Currency Conversion | Currency Codes | Currency codes at the granularity of Client(System), Currency Code, and Language Key. | tcurc, tcurt, tcurx |
✅ | ✅ |
| Exchange Rates | Exchange rates at the granularity of Client(System), Exchange Rate Type, From Currency, To Currency, and Conversion Date. | tcurf, tcurr |
✅ | ✅ | |
| Customers | Customers | Customer master data, customer number, name of customer, location, address, and similar information at the granularity of Client(System) and Customer number, Version ID for International Addresses and Valid from date. | kna1, adrc |
✅ | ✅ |
| Delivery Documents | Delivery Document Headers | Delivery documents at the header level at the granularity of Client(System) and Delivery document number. | tcurx, likp |
✅ | ✅ |
| Delivery Document Items | Delivery document items at the granularity of Client(System), Delivery document number and Item number of delivery document. | tcurx, likp, lips |
✅ | ✅ | |
| Delivery Blocking Reasons | Delivery blocking reasons at the granularity of Client(System) and Language Key. | tvlst |
✅ | ✅ | |
| Financial Statement Structure & Versions | Financial Statement Structure Items | Financial statement structure items at the granularity of Client(System), Financial Statement Version, and Node ID. | fagl_011pc |
✅ | ✅ |
| Financial Statement Structure Text | Financial statement structure texts at the granularity of Client(System), Financial Statement Version, Language Key, Financial Statement Item, Text Type, and Line Number. | fagl_011qt |
✅ | ✅ | |
| Financial Statement Structure Version Assignments | Financial statement structure version assignments at the granularity of Client(System), Financial Statement Version, Financial Statement Item, Chart of Accounts, and G/L Account From. | fagl_011zc |
✅ | ✅ | |
| Fiscal Year Variants | Fiscal Year Variants | Fiscal year variant configurations at the granularity of Client(System) and Fiscal Year Variant. | t009 |
✅ | ✅ |
| Fiscal Year Variant Periods | Fiscal year variant periods at the granularity of Client(System), Fiscal Year Variant, Year, Calendar Month, and Calendar Day. | t009b |
✅ | ✅ | |
| Fixed Assets | Fixed Assets Master | Fixed assets master details at the granularity of Client(System), Company Code, Asset Number, Asset Subnumber, and Language Key. | anla, anlh, ankt, t095t, t098t |
✅ | ✅ |
| Depreciation Terms | Depreciation terms at the granularity of Client(System), Company Code, Asset Number, Asset Subnumber, Depreciation Area, Valid To Date, and Language Key. | anlb, t090nat, t093b, t093c, t093t |
✅ | ✅ | |
| Time Dependent Asset Allocations | Time-dependent asset allocations at the granularity of Client(System), Company Code, Asset Number, Asset Subnumber, and Valid To Date. | anlz |
✅ | ✅ | |
| General Ledger Accounts | General Ledger Accounts | General ledger accounts at the granularity of Client(System), Chart of Accounts, G/L Account Number, and Language Key. | ska1, skat |
✅ | ✅ |
| Global Settings | Company Codes | Company codes at the granularity of Client(System) and Company Code. | t001 |
✅ | ✅ |
| Languages | Languages at the granularity of Language Key and Description Language. | t002, t002t |
✅ | ✅ | |
| Countries | Countries at the granularity of Country Key and Language Key. | t005, t005t |
✅ | ✅ | |
| Country Dialing Codes | Country dialing codes at the granularity of Client(System) and Country Key. | t005k |
✅ | ✅ | |
| Country Tax Regions | Country tax regions at the granularity of Client(System), Country Key, Region, and Language Key. | t005s, t005u |
✅ | ✅ | |
| System Status Texts | System status texts at the granularity of System Status Key and Language Key. | tj02t |
✅ | ✅ | |
| Material Batches | Material Cross Plant Batches | Material cross-plant batches at the granularity of Client(System), Material Number, Batch Number, and Language Key. | makt, mch1 |
✅ | ✅ |
| Material Plant Batches | Material plant batches at the granularity of Client(System), Material Number, Plant, Batch Number, and Language Key. | makt, mcha, t001w |
✅ | ✅ | |
| Material Batch Stocks | Material batch stocks at the granularity of Client(System), Material Number, Plant, Storage Location, Batch Number, and Language Key. | makt, mchb, t001w |
✅ | ✅ | |
| Materials Movements | Material Documents | Material documents at the granularity of Client(System), Document Number, Document Year and Document Item. | ECC: tcurx, msegS/4H: tcurx, matdoc |
✅ | ✅ |
| Material Movement Types | Material movement types at the granularity of Client(System), Language Key, Movement Type, Special Stock Indicator, Movement Indicator, Receipt Indicator and Consumption Related Movement Type. | t156, t156t |
✅ | ✅ | |
| Materials | Materials | Materials at the granularity of Client(System) and Material Number. | mara, makt |
✅ | ✅ |
| Material Types | Material types at the granularity of Client(System), Material Type and Language Key. | t134, t134t |
✅ | ✅ | |
| Material Groups | Material groups at the granularity of Client(System), Material Group, and Language Key. | t023, t023t |
✅ | ✅ | |
| Material Plants | Material plants at the granularity of Client(System), Material Number and Plant. | marc |
✅ | ✅ | |
| Materials by Storage Location | Exposes material inventory levels, multilingual material descriptions, plant names, and storage location names at the storage location level | mard, makt, t001w, and t001l |
✅ | ✅ | |
| Plants and Storage | Plants | Plants at the granularity of Client(System) and Plant. | t001w |
✅ | ✅ |
| Storage Locations | Storage locations at the granularity of Client(System), Plant, and Storage Location. | t001l |
✅ | ✅ | |
| Project Structure | Project Structure | Project structure at the granularity of Client(System), Project Internal ID, and WBS Element Internal ID. | proj, prhi, prps, prte |
✅ | ✅ |
| Project Info Database | Project info database records at the granularity of Client(System), Object Number, Ledger, Value Type, Object Indicator, Fiscal Year, Value Category, Budget Type, Version, Category, Fund, Transaction Currency, and Period Block. | rpsco |
✅ | ✅ | |
| Purchasing Documents | Purchasing Document Headers | Provides details about purchase orders at the header level. This view is at the granularity of Client(System) and Purchasing document number. | ekko |
✅ | ✅ |
| Purchasing Document Items | Details about purchase order items. This view is at the granularity of Client(System), Purchasing document number and Item number of purchasing document. | tcurx, ekpo, ekko |
✅ | ✅ | |
| Purchasing Document Schedule Lines | Details about purchase documents at schedule line level, including KPIs such as Open Quantity.. The granularity of this view is Client(System), Purchasing Document Number, Item Number of Purchasing Document and Delivery Schedule Line Counter. | tcurx, ekpo, ekko, eket |
✅ | ✅ | |
| Purchasing Organisational Structure | Purchasing Groups | Purchasing groups at the granularity of Client(System) and Purchasing Group. | t024 |
✅ | ✅ |
| Purchasing Organizations | Purchasing organization master data at the granularity of Client(System) and purchasing organization. | t024e |
✅ | ✅ | |
| Sales Documents | Sales Document Headers | Sales documents at the header level, at the granularity of Client(System), and Sales document number. | tcurx, vbak |
✅ | ✅ |
| Sales Document Items | Sales document items, at the granularity of Client(System), Sales document number and Item number of sales document. | tcurx, vbap |
✅ | ✅ | |
| Sales Document Partners | Sales document partner details at the granularity of Client(System), Sales Document, Sales Document Item, and Partner Function. | vbpa |
✅ | ✅ | |
| Sales Document Schedule Lines | Sales documents at schedule line level, including KPIs such as Open Quantity and In-Transit Quantity. The granularity of this view is Client(System), Sales Document Number, Item Number of Sales Document and Delivery Schedule Line Counter. | tcurx, vbep |
✅ | ✅ | |
| Sales Document Header Statuses | Sales document header statuses at the granularity of Client(System) and Sales Document. | vbak, vbuk |
✅ | ✅ | |
| Sales Document Item Statuses | Sales document item statuses at the granularity of Client(System), Sales Document, and Sales Document Item. | lips, vbap, vbup |
✅ | ✅ | |
| Sales Document Flow | Sales document flows at the granularity of Client(System), Preceding Document, Preceding Item, Subsequent Document, and Subsequent Item. | vbfa |
✅ | ✅ | |
| Sales Organizational Structure | Sales Organizations | Sales organizations at the granularity of Client(System), Sales Organization and Language Key. | tvko, tvkot |
✅ | ✅ |
| Distribution Channel | Distribution channels at the granularity of Client(System), Distribution Channel and Language Key. | tvtw, tvtwt |
✅ | ✅ | |
| Divisions | Divisions at the granularity of Client(System), Division and Language Key. | tspa, tspat |
✅ | ✅ | |
| Units of Measurement | Units of Measurement | Units of measurement at the granularity of Client(System), Unit of Measurement, and Language Key. | t006, t006a, t006t |
✅ | ✅ |
| Universal Journal | Universal Journal Entry Line Items | Universal journal entry line items at the granularity of Client, Ledger, Company Code, Fiscal Year, Accounting Document Number, and Line Item. | acdoca, tcurx |
✅ | |
| Universal Journal Entry Ledgers | Universal journal entry ledgers at the granularity of Client, Ledger, and Language. | finsc_ledger, finsc_ledger_t |
✅ | ||
| Group Journal Entries | Group journal entries at the granularity of Client, Ledger, Dimension, Fiscal Year, Document Number, Line Item, and Language Key. | acdocu, fincs_ref_vers_r, tcurx, tf200, tf201 |
✅ | ||
| Vendor Invoices | Vendor Invoice Headers | Vendor invoice headers at the granularity of Client(System), Invoice Document Number, and Fiscal Year. | rbkp |
✅ | ✅ |
| Vendor Invoice Items | Vendor invoice items at the granularity of Client(System), Invoice Document Number, Fiscal Year, and Invoice Item Number. | rbkp, rseg |
✅ | ✅ | |
| Vendor Invoice Account Assignments | Vendor invoice account assignments at the granularity of Client(System), Invoice Document Number, Fiscal Year, Invoice Item Number, Sequential Number of Account Assignment, and Sequential Number for Coding Block. | rbco, rbkp |
✅ | ✅ | |
| Vendors | Vendors | Vendor master data, vendor number, name of vendor, location, address, and similar at the granularity of Client(System) and Vendor number, Version ID for International Addresses and Valid from date. | lfa1, adrc |
✅ | ✅ |
Consumption data product samples for SAP
The following consumption data product samples are available for SAP (SAP ERP and SAP BDC).
- Sales Performance Insights
- Supplier Spend Analysis
For further details and specifics, see the
Consumption data product samples documentation.