I_ResponsibleSalesOrgUnitIDVH

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_ResponsibleSalesOrgUnitIDVH.
-- 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_ResponsibleSalesOrgUnitIDVH AS
SELECT
  concat_with_space(crmd_orgman_temp.otype,cast(crmd_orgman_temp.objid as abap.char(11)), 1) AS ResponsibleSalesOrganization,
  cast(crmd_orgman_temp.sales_org as crmt_sales_org preserving type ) AS SalesOrganizationOrgUnitID,
  cast(crmd_orgman_temp.sales_office as crmt_sales_office_lbl preserving type ) AS SalesOfficeOrgUnitID,
  cast(crmd_orgman_temp.sales_group as crmt_sales_group_lbl preserving type ) AS SalesGroupOrgUnitID,
  crmd_orgman_temp.dis_channel AS DistributionChannel,
  crmd_orgman_temp.division AS Division,
  crmd_orgman_temp.objid AS OrganizationalUnit,
  _hrp1000.short AS OrganizationalUnitName,
  cast(_hrp1000.stext as crmt_sales_org_unit_name_lbl preserving type ) AS ResponsibleSalesOrgName,
  _hrp1000.begda AS StartDate,
  _hrp1000.endda AS EndDate
FROM crmd_orgman_temp
INNER JOIN hrp1000 AS _hrp1000 ON /* join condition not captured in parsed metadata */
;