I_RepairObjectSituation

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_RepairObjectSituation.
-- 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.
-- SQL view name: IREPOBJSIT

CREATE VIEW I_RepairObjectSituation AS
SELECT
  InhRepItem.CustMgmtObjectType AS CustMgmtObjectType,
  InhRepItem.InHouseRepair AS InHouseRepair,
  InhRepItem.InHouseRepairItem AS RepairObject,
  InhRepItem.InHouseRepairItemUUID AS InHouseRepairItemUUID,
  cast(InHRepair.InhRepairStatus as crms4_inhrepair_status) AS InhRepairStatus,
  cast(InhRepItem.InhRepairItemStatus as crms4_repair_obj_status) AS RepairObjectStatus,
  RespEmployeeUser.UserID AS ResponsibleEmployeeUserID,
  InHRepair.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  InhRepItem.InHouseRepairUUID AS InHouseRepairUUID,
  InhRepItem.CreatedByUser AS CreatedByUser,
  InhRepItem.InhRepairItemCategory AS InhRepairItemCategory,
  cast(division( tstmp_seconds_between(InhRepItem.CreationDateTime,tstmp_current_utctimestamp(),'NULL'), 86400, 0 ) as crms4_creation_date_duration) AS NrOfDaysAftReprObjCreationDate,
  cast(division( tstmp_seconds_between(StatusChangedDateTime, tstmp_current_utctimestamp(),'NULL'), 86400, 0 ) as crms4_days_in_current_status) AS NrOfDaysInCurrentStatus,
  InHRepair.SalesOrganization AS SalesOrganization,
  InHRepair.DistributionChannel AS DistributionChannel,
  InHRepair.Division AS Division,
  InHRepair.SalesOffice AS SalesOffice,
  InHRepair.SalesGroup AS SalesGroup,
  InHRepair.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  InHRepair.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  InHRepair.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  InhRepItem.InhRepairType AS InhRepairType,
  InhRepItem._InHouseRepair AS _InHouseRepair,
  InHRepair._SalesOrganization AS _SalesOrganization,
  InHRepair._DistributionChannel AS _DistributionChannel,
  InHRepair._Division AS _Division,
  InHRepair._SalesOffice AS _SalesOffice,
  InHRepair._SalesGroup AS _SalesGroup,
  InhRepItem._CustMgmtObjectType AS _CustMgmtObjectType,
  InhRepItem._InhRepairItemCategory AS _InhRepairItemCategory
FROM I_InHouseRepairItem AS InhRepItem
INNER JOIN I_InHouseRepair AS InHRepair ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InHouseRepairItem AS _RepairObjectExtension ON CustMgmtObjectType = _RepairObjectExtension.CustMgmtObjectType AND InHouseRepair = _RepairObjectExtension.InHouseRepair AND RepairObject = _RepairObjectExtension.InHouseRepairItem  -- association [0..1]
;