C_InhRepairItemPlanObjPg

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_InhRepairItemPlanObjPg.
-- 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_InhRepairItemPlanObjPg AS
SELECT
  InHouseRepair,
  InHouseRepairItem,
  InHouseRepairItemUUID,
  _InHouseRepairTP.CreationDateTime AS CreationDateTime,
  InhRepairType,
  PostingDate,
  InHouseRepairUUID,
  InhRepairItemCategory,
  InhRepairItemStatus,
  Product,
  _Product._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  InhRepairReferenceEquipment,
  SerialNumber,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObject,
  SoldToParty,
  cast( _InHouseRepairTP._SoldToParty.BusinessPartnerName as crms4_repa_soldto_pty_name_lbl preserving type ) AS SoldToPartyName,
  ContactPerson,
  cast( _InHouseRepairTP._ContactPerson.BusinessPartnerName as crms4_repa_cntct_pers_name_lbl preserving type ) AS ContactPersonName,
  ShipToParty,
  cast( _InHouseRepairTP._ShipToParty.BusinessPartnerName as crms4_repa_shipto_pty_name_lbl preserving type ) AS ShipToPartyName,
  _InHouseRepairTP.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  cast( _InHouseRepairTP._ResponsibleEmployee.BusinessPartnerName as crms4_repa_resp_empl_name_lbl preserving type ) AS ResponsibleEmployeeName,
  _InhRepairReferenceEquipment._MasterWrntyObjectAssgmt[1: WarrantyType='1' ].WarrantyEndDate AS CustomerWarrantyEndDate,
  _InhRepairReferenceEquipment._MasterWrntyObjectAssgmt[1: WarrantyType='2' ].WarrantyEndDate AS SupplierWarrantyEndDate,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  InhRepairItemIsNew,
  InhRepairItemIsInProcess,
  InhRepairItemIsCompleted,
  LastChangeDateTime,
  InhRepairItemAvailyStatus,
  _CustomerReturnsItemReference.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID
FROM I_InHouseRepairItemTP
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_InhReprItmPlanExectblActn AS _InhRepairItemExectblAction ON InHouseRepair = _InhRepairItemExectblAction.InHouseRepair AND InHouseRepairItem = _InhRepairItemExectblAction.InHouseRepairItem  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPlnSrvcQtanLink AS _ServiceQuotation ON InHouseRepairItemUUID = _ServiceQuotation.InHouseRepairItemUUID  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPlnSrvcOrdLink AS _ServiceOrder ON InHouseRepairItemUUID = _ServiceOrder.InHouseRepairItemUUID  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPlnSrvcQtanLink AS _OpenServiceQuotation ON InHouseRepairItemUUID = _OpenServiceQuotation.InHouseRepairItemUUID AND _OpenServiceQuotation.ServiceQuotationIsOpen = 'X'  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPlnSrvcQtanLink AS _CompletedServiceQuotation ON InHouseRepairItemUUID = _CompletedServiceQuotation.InHouseRepairItemUUID AND _CompletedServiceQuotation.ServiceQuotationIsOpen = ''  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPlnSrvcOrdLink AS _OpenServiceOrder ON InHouseRepairItemUUID = _OpenServiceOrder.InHouseRepairItemUUID AND _OpenServiceOrder.ServiceOrderIsOpen = 'X'  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPlnSrvcOrdLink AS _CompletedServiceOrder ON InHouseRepairItemUUID = _CompletedServiceOrder.InHouseRepairItemUUID AND _CompletedServiceOrder.ServiceOrderIsOpen = ''  -- association [0..*]
;