Data products overview

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 Cortex Framework available data products. They run extract, load, transform (ELT) 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). They 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, data products exposed by catalog modules, as well as source-aligned data products, to drive immediate decision-making.

For more information, see Available data products and Consumption data product samples documentation.

You can extend Google Cloud Cortex Framework content by utilizing the extensibility framework to either manually develop custom data products or use the agentic data product builder to seamlessly modify existing data products and create new ones from scratch.

Available data products

The following table outlines the data products available within Cortex Framework, detailing their functional descriptions, source data, and supported sources.

Type Data product Data asset Description Source data Supported sources
SAP ECC SAP S/4HANA SAP BDC
Source-aligned Any Any Any SAP BDC data product (SAP-managed or customer-managed) that is shared with the connected BigQuery Delta Share Catalog can be registered. SAP BDC data products ✅
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, 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 ✅ ✅
Asset Documents Asset Accounting Statistical Line Items Captures statistical line items for asset postings from the SAP S/4HANA FAAT_DOC_IT table, including asset number, depreciation area, transaction type, posted amounts in company code and global currencies, and document metadata, enriched with calendar date dimensions. faat_doc_it, tcurx ✅
Asset Annual Cumulative Balances Tracks cumulative asset values (APC, ordinary, special, and unplanned depreciation) along with expired useful life attributes by fiscal year and depreciation area. anlc, faat_ydda, tcurx ✅ ✅
Asset Document Headers Captures asset posting document header-level transaction metadata from SAP ANEK (such as company code, asset number, fiscal year, posting date, and entry time), enriched with calendar date dimensions to support asset transaction analysis. anek, tcurx ✅
Asset Document Line Items Captures asset posting document line item-level transaction metadata from SAP ANEP (such as depreciation area, transaction type, posted amount, ordinary depreciation, and interest), enriched with calendar date dimensions to support asset valuation and depreciation analysis. anep, tcurx ✅
Asset Documents Captures asset posting ledger transactions from the SAP S/4HANA Universal Journal (ACDOCA) joined with BKPF (such as asset number, depreciation area, transaction type, posted amounts in local and transaction currencies, and document metadata), filtered by asset account type ('A') and enriched with calendar date dimensions. bkpf, acdoca, tcurx ✅
Asset Transaction Types Details the business transaction types used in asset accounting, including capitalization flags, retirement rules, and group mappings. tabw, tabwh, tabwt ✅ ✅
Planned Depreciation and Revaluations Captures planned depreciation values and revelations from the SAP S/4HANA FAAT_PLAN_VALUES table, including asset number, depreciation area, posting period, and planned amounts in company code and global currencies. faat_plan_values, tcurx ✅
Bill of Materials Bill of Materials Headers Contains BOM header details including validity dates, base quantities, and BOM status. stko ✅ ✅
Bill of Materials Item Selections Contains BOM item selection details mapping item nodes to alternative BOMs. stas ✅ ✅
Bill of Materials Items Contains BOM item/component details, including component quantities, scrap percentages, and item categories. stpo, stko ✅ ✅
Budget Allocations Budget Balances Annual and overall budget allocations and balances per budget object. bpja, bpge, tcurx ✅ ✅
Budget Documents Budget allocation document line items representing budget postings. bpvg, tcurx ✅ ✅
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 ✅ ✅
Cash and Liquidity Management Cash Forecast Summaries Summary records of cash management and forecast data for G/L accounts from the ECC FDSB table. fdsb, t001, tcurx ✅
Liquidity Flows Granular, real-time liquidity flows from the S/4HANA One Exposure from Operations (FQM_FLOW) table. fqm_flow, tcurx ✅
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 ✅ ✅
Controlling Documents Controlling Document Headers Controlling document headers containing metadata for controlling transactions. cobk, tcurx ✅ ✅
Controlling Document Period Line Items Controlling document line items representing financial transactions across periods. coep, tcurx ✅ ✅
Controlling External Posting Cost Totals Controlling external posting cost totals at the cost center/controlling area granularity. cosp, tcurx ✅ ✅
Controlling Internal Posting Cost Totals Controlling internal posting cost totals representing internal allocation postings. coss, tcurx ✅ ✅
Controlling Commitment Line Items Controlling commitment line items representing financial commitments and encumbrances. cooi, tcurx ✅ ✅
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 Hierarchies Classic Sets Headers Headers of classic SAP Sets. setheader, setheadert, t002 ✅ ✅
Classic Sets Leaves Set leaves of classic SAP Sets. setleaf ✅ ✅
Classic Sets Nodes Set nodes and hierarchy structure of classic SAP Sets. setnode ✅ ✅
Cost Center Group Hierarchy Cost center group hierarchical structure with descriptions. ECC: setheadert
S/4H: sethanahier0101		 ✅ ✅
Cost Center Hierarchy Flattened Flattened cost center hierarchy with names and descriptions up to multi-level nodes. ECC: t002, setnode, setleaf, csks, setheader, cskt
S/4H: t002, sethanahier0101, csks, cskt		 ✅ ✅
Financial Hierarchy Directories Directory and metadata of financial hierarchies from S/4HANA HRRP tables. hrrp_directory ✅
Financial Hierarchy Nodes Financial hierarchy nodes and node descriptions from S/4HANA HRRP tables. hrrp_node, hrrp_nodet ✅
Profit Center Group Hierarchy Profit center group hierarchical structure with descriptions. ECC: setheadert
S/4H: sethanahier0106		 ✅ ✅
Profit Center Hierarchy Flattened Flattened profit center hierarchy with names and descriptions up to multi-level nodes. ECC: t002, setnode, setleaf, cepc, setheader, cepct
S/4H: t002, sethanahier0106, cepc, cepct		 ✅ ✅
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 ✅ ✅
General Ledger Items General Ledger Actual Line Items General ledger actual line items from FAGLFLEXA containing balances and transactional line item amounts. faglflexa, t001, tcurx ✅
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 ✅ ✅
Inventory and Special Stocks Sales Order Stock Material stock allocated to specific sales orders. mska, t148t ✅
Sales Order Stock with Vendor Sales order stock specifically allocated with vendor information. msfd, t148t ✅
Special Stocks from Vendor Special stock owned/consigned by vendors. mkol, t148t ✅
Special Stocks with Customer Special stock consigned or placed at customer sites. mslb, t148t ✅
Special Stocks with Vendor Vendor special stocks with descriptive indicator labels. msku, t148t ✅
Ledger Master Ledger Master Ledger master details containing ledger characteristics and language-specific descriptions. t881, t881t ✅ ✅
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 ✅ ✅
Material Ledger Material Ledger Header Contains master records (from CKMLHD) linking a material, plant, and valuation type to a unique valuation header number (kalnr). ckmlhd ✅ ✅
Material Ledger Period Totals Exposes stock quantity, value, standard price, periodic unit price, and price/exchange rate differences (from CKMLCR) per header, period, value structure type, and currency type. ckmlcr, tcurx ✅ ✅
Material Valuation Area Lists valuation area configurations (from T001K, T001W, T001), including the company code name, plant name, and indicating if Material Ledger is active. t001k, t001w, t001 ✅ ✅
Material Valuation Exposes current standard and moving average valuation details for ECC from MBEW, including rich details like planned/future prices and costing variants. mbew, tcurx ✅
Material Valuation History Exposes historical valuation details for ECC. Union of current (MBEW) and historical (MBEWH) valuation tables, limited to core valuation fields. mbew, mbewh ✅
Materials Movements Material Documents Material documents at the granularity of Client(System), Document Number, Document Year and Document Item. ECC: tcurx, mseg
S/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 ✅ ✅
Material to BOM Link Exposes link between materials and bills of materials, including plant and BOM usage from MAST. mast ✅ ✅
Object Statuses Individual Object Statuses Consolidated view of status information for various SAP objects (such as orders, projects, and WBS elements) to track historical and current statuses from JEST. jest ✅ ✅
Order Master Data Order Master Data Exposes order master data from AUFK, including order category, order type, order status, order currency, controlling area, and cost center. aufk, tcurx ✅ ✅
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 ✅ ✅
Product Hierarchies Flattened Product Hierarchies Flattened representation of the product hierarchy up to 6 levels, showing codes and descriptions for each level. t179, t179t ✅ ✅
Product Hierarchies Master data for product hierarchies, including node codes, levels, and descriptions. t179, t179t ✅ ✅
Production Orders Production Order Header Production order header details including quantities, scheduling dates, status, and plant assignments from AUFK and AFKO. aufk, afko, tcurx ✅ ✅
Production Order Item Production order line item details including material numbers, target and delivered quantities, and settlement rules from AUFK and AFPO. aufk, afpo, tcurx ✅ ✅
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 Document Account Assignments Details about purchase document account assignments, distributing values or quantities to cost centers, orders, WBS elements, or assets. This view is at the granularity of Client(System), Purchasing Document Number, Item Number of Purchasing Document, and Sequence Number of Account Assignment. tcurx, ekkn, ekko ✅ ✅
Purchasing Document Types Configurations and language-specific descriptions for purchasing document categories and types. This view is at the granularity of Client(System), Purchasing Document Category, Purchasing Document Type, and Language Key. t161, t161t ✅ ✅