F0150

-- ============================================================
-- Table  : F0150 Parent/child links between address book numbers, organized by structure type — the hierarchy behind org structures, buying groups, and rollups.
-- Purpose: Column-selected read of F0150 — auto-generated from field metadata
-- Grain  : One row per MAOSTP + MAPA8 + MAAN8
-- Notes  : Auto-generated skeleton. Julian dates (CYYDDD) are converted to DATE and implied-decimal amounts are scaled (verify decimals in F9210); padded business-unit/UDC keys are TRIMmed. Audit columns (…USER/…PID/…UPMJ) are omitted — see the quirks guide. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  f.MAOSTP AS "Structure type separating parallel hierarchies (org chart, distribution, etc.).",
  f.MAPA8 AS "Parent address book number in the relationship.",
  f.MAAN8 AS "Child address book number in the relationship.",
  f.MADSS7 AS "Display sequence controlling sibling order under a parent.",
  CASE WHEN f.MABEFD IS NULL OR f.MABEFD = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.MABEFD AS INT) DIV 1000, 1, 1), CAST(f.MABEFD AS INT) % 1000 - 1) END AS "Date the relationship becomes effective.",  -- CYYDDD Julian → DATE
  CASE WHEN f.MAEEFD IS NULL OR f.MAEEFD = 0 THEN NULL ELSE DATE_ADD(MAKE_DATE(1900 + CAST(f.MAEEFD AS INT) DIV 1000, 1, 1), CAST(f.MAEEFD AS INT) % 1000 - 1) END AS "Date the relationship expires.",  -- CYYDDD Julian → DATE
  f.MARMK AS "Free-text remark on the relationship."
FROM <catalog>.<schema_data>.f0150 f
WHERE
  f.MAAN8 = <AN8>
ORDER BY f.MAOSTP;