I_SalesOfficeOrgUnitIDVH

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SalesOfficeOrgUnitIDVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_SalesOfficeOrgUnitIDVH AS
SELECT
  SlsOffcOrgUnitSlsOffcAssgmt.SalesOffice AS SalesOffice,
  cast(_crmd_orgman_temp.sales_office as crmt_sales_office_lbl preserving type ) AS SalesOfficeOrgUnitID,
  cast(_SalesOrganizationUnitText.OrganizationalUnitName as crmt_sales_office_name_lbl preserving type ) AS SalesOfficeOrgUnitName,
  cast(_crmd_orgman_temp.sales_org as crmt_sales_org preserving type ) AS SalesOrganizationOrgUnitID,
  _crmd_orgman_temp.dis_channel AS DistributionChannel,
  _crmd_orgman_temp.division AS OrganizationDivision,
  SlsOffcOrgUnitSlsOffcAssgmt.OrganizationalUnit AS OrganizationalUnit
FROM I_SlsOffcOrgUnitSlsOffcAssgmt AS SlsOffcOrgUnitSlsOffcAssgmt
INNER JOIN crmd_orgman_temp AS _crmd_orgman_temp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrganizationUnitText AS _SalesOrganizationUnitText ON SlsOffcOrgUnitSlsOffcAssgmt.OrganizationalUnit = _SalesOrganizationUnitText.OrganizationalUnit AND _SalesOrganizationUnitText.StartDate <= $session.system_date AND _SalesOrganizationUnitText.EndDate >= $session.system_date AND _SalesOrganizationUnitText.Language = $session.system_language  -- association [0..1]
;