C_InhRepairObjPg

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 C_InhRepairObjPg.
-- 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 C_InhRepairObjPg AS
SELECT
  InHouseRepair,
  InHouseRepairUUID,
  InhRepairType,
  PostingDate,
  LastChangeDateTime,
  CreationDateTime,
  InhRepairStatus,
  SoldToParty,
  cast( _SoldToParty.BusinessPartnerName as crms4_repa_soldto_pty_name_lbl preserving type ) AS SoldToPartyName,
  ContactPerson,
  cast( _ContactPerson.BusinessPartnerName as crms4_repa_cntct_pers_name_lbl preserving type ) AS ContactPersonName,
  ShipToParty,
  cast( _ShipToParty.BusinessPartnerName as crms4_repa_shipto_pty_name_lbl preserving type ) AS ShipToPartyName,
  ResponsibleEmployee,
  cast( _ResponsibleEmployee.BusinessPartnerName as crms4_repa_resp_empl_name_lbl preserving type ) AS ResponsibleEmployeeName,
  SalesOrganization,
  SalesOrganizationOrgUnitID,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesOfficeOrgUnitID,
  SalesGroup,
  SalesGroupOrgUnitID,
  ResponsibleSalesOrganization,
  InhRepairExtReference,
  InhRepairIsNew,
  InhRepairIsInProcess,
  InhRepairIsCompleted,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances
FROM I_InHouseRepairTP
LEFT OUTER JOIN C_SrvcDocTypeProcStepOverview AS _SrvcDocTypeProcStepOverview ON InhRepairType = _SrvcDocTypeProcStepOverview.ServiceDocumentType  -- association [0..*]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _SoldToPartyQuickView ON SoldToParty = _SoldToPartyQuickView.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtCntctPersnQuickVw AS _ContactPersonQuickView ON ContactPerson = _ContactPersonQuickView.BusinessPartner AND SoldToParty = _ContactPersonQuickView.SoldToParty  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtSoldToPartyQuickVw AS _ShipToPartyQuickView ON ShipToParty = _ShipToPartyQuickView.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_SrvcMgmtRespEmplQuickVw AS _ResponsibleEmployeeQuickView ON ResponsibleEmployee = _ResponsibleEmployeeQuickView.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_InhRepairItemContract AS _InhouseRepairContract ON InHouseRepair = _InhouseRepairContract.InHouseRepair AND SoldToParty = _InhouseRepairContract.SoldToParty AND DistributionChannel = _InhouseRepairContract.DistributionChannel AND Division = _InhouseRepairContract.Division AND SalesOrganization = _InhouseRepairContract.SalesOrganization  -- association [0..*]
;