DataArea
frameworkShared across companiesThe kernel table that lists every company (legal entity data area) in the environment — the source of every dataareaid value used to partition application tables
Kernel (system) table, so it is absent from the CDM application schema; field list verified against the F&O system-tables reference. Kernel fields use lowercase names (id, name, isVirtual).
What the badges mean
- main
- Table group: how F&O categorizes the table's role — main entity, group/header, transaction, worksheet header, worksheet line, reference, parameter, or framework.
- Shared across companies
- The table carries no
DataAreaId— rows aren’t partitioned per company, so a query never needs (and can’t use) a company filter here (see the quirks guide). - Date-effective
- The table carries a
ValidFrom/ValidToeffectivity window — a join without a date filter multiplies every key by its history (see the quirks guide).
Fields
3 fields · 1 key
3 fields.
| Key | Field | EDT | Description | Type | Length | Flags |
|---|---|---|---|---|---|---|
| Key | id | DataAreaId | The company code — the value application tables carry in dataareaid | string | ||
| name | Company name as registered when the data area was created | string | ||||
| isVirtual | Whether this is a virtual company (shared-data container) rather than a real operating company — exclude virtual rows when listing legal entities | enum |
Field provenance: hand-curated.
Boilerplate SQL
Starting point for reading DataArea on Databricks — enums are decoded, 1900-01-01 dates are wrapped to NULL, and the DataAreaId anchor is in place. Set your Unity Catalog location, company, and filter values below; they’re substituted into the SQL and the copy button.
2 parameters not filled: <catalog>, <schema>
-- ============================================================
-- Table : DataArea The kernel table that lists every company (legal entity data area) in the environment — the source of every dataareaid value used to partition application tables
-- Purpose: Column-selected read of DataArea — auto-generated from field metadata
-- Grain : One row per id
-- Notes : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
d.id AS "The company code — the value application tables carry in dataareaid",
d.name AS "Company name as registered when the data area was created",
d.isvirtual AS "Whether this is a virtual company (shared-data container) rather than a real operating company — exclude virtual rows when listing legal entities" -- enum: decode d.isvirtual via GlobalOptionsetMetadata join — see quirks guide #enums
FROM <catalog>.<schema>.dataarea d
ORDER BY d.id;Verified September 2026
Relationships
Diagram of 1-hop neighbors — join details below. RecId and InventDim edges are highlighted; they’re the joins newcomers most often get wrong.
Join details
ON companyinfo.dataarea = dataarea.id