I_InHouseRepairSituation

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_InHouseRepairSituation.
-- 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_InHouseRepairSituation AS
SELECT
  Header.InHouseRepair AS InHouseRepair,
  Header.CustMgmtObjectType AS CustMgmtObjectType,
  Header.InHouseRepairUUID AS InHouseRepairUUID,
  Header.InhRepairType AS InhRepairType,
  Header.SalesOrganization AS SalesOrganization,
  Header.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  Header.DistributionChannel AS DistributionChannel,
  Header.Division AS Division,
  Header.SalesOffice AS SalesOffice,
  Header.SalesGroup AS SalesGroup,
  Header.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  Header.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  Header.CreatedByUser AS CreatedByUser,
  cast(Header.InhRepairStatus as crms4_inhrepair_status) AS InhRepairStatus,
  Header.ResponsibleEmployee AS ResponsibleEmployee,
  RespEmployeeUser.UserID AS ResponsibleEmployeeUserID,
  cast( division( TSTMP_SECONDS_BETWEEN(Header.CreationDateTime,tstmp_current_utctimestamp(),'NULL'), 86400, 0 ) as crms4_days_after_creation_date) AS NrOfDaysAfterCreationDate,
  Header._InhRepairType AS _InhRepairType,
  Header._SalesOrganization AS _SalesOrganization,
  Header._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  Header._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  Header._DistributionChannel AS _DistributionChannel,
  Header._Division AS _Division,
  Header._SalesOffice AS _SalesOffice,
  Header._SalesGroup AS _SalesGroup,
  Header._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  Header._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  Header._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  Header._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  Header._RepairOrders AS _RepairOrders,
  Header._ResponsibleEmployee AS _ResponsibleEmployee,
  Header._CustMgmtObjectType AS _CustMgmtObjectType
FROM I_InHouseRepair AS Header
LEFT OUTER JOIN E_InHouseRepair AS _InHouseRepairExtension ON CustMgmtObjectType = _InHouseRepairExtension.CustMgmtObjectType AND InHouseRepair = _InHouseRepairExtension.InHouseRepair  -- association [0..1]
;