C_InhRepairItemPrecheckObjPg

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_InhRepairItemPrecheckObjPg.
-- 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_InhRepairItemPrecheckObjPg AS
SELECT
  InHouseRepair,
  InHouseRepairItem,
  InHouseRepairItemUUID,
  LastChangeDateTime,
  _InHouseRepairTP.CreationDateTime AS CreationDateTime,
  InHouseRepairUUID,
  InhRepairType,
  PostingDate,
  InhRepairItemCategory,
  InhRepairItemStatus,
  InhRepairItemSuplmntyStatus,
  Product,
  _Product._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  InhRepairReferenceEquipment,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObject,
  SerialNumber,
  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,
  DistributionChannel,
  Division,
  SalesOrganization,
  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,
  InhRepairItemAvailyStatus,
  InhRepairItemIsNew,
  InhRepairItemIsInProcess,
  InhRepairItemIsCompleted,
  _CustomerReturnsItemReference.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  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_InhReprItmPrChkExectblActn AS _InhRepairItemExectblAction ON InHouseRepair = _InhRepairItemExectblAction.InHouseRepair AND InHouseRepairItem = _InhRepairItemExectblAction.InHouseRepairItem  -- association [0..*]
LEFT OUTER JOIN C_InhRepairItemContract AS _InhouseRepairContract ON InHouseRepair = _InhouseRepairContract.InHouseRepair AND InHouseRepairItem = _InhouseRepairContract.InHouseRepairItem AND SoldToParty = _InhouseRepairContract.SoldToParty AND InhRepairReferenceEquipment = _InhouseRepairContract.InhRepairReferenceEquipment AND DistributionChannel = _InhouseRepairContract.DistributionChannel AND Division = _InhouseRepairContract.Division AND SalesOrganization = _InhouseRepairContract.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPrChkSrvcQtanLink AS _ServiceQuotation ON InHouseRepairItemUUID = _ServiceQuotation.InHouseRepairItemUUID  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPrChkSrvcOrdLink AS _ServiceOrder ON InHouseRepairItemUUID = _ServiceOrder.InHouseRepairItemUUID  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPrChkSrvcQtanLink AS _OpenServiceQuotation ON InHouseRepairItemUUID = _OpenServiceQuotation.InHouseRepairItemUUID AND _OpenServiceQuotation.ServiceQuotationIsOpen = 'X'  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPrChkSrvcQtanLink AS _CompletedServiceQuotation ON InHouseRepairItemUUID = _CompletedServiceQuotation.InHouseRepairItemUUID AND _CompletedServiceQuotation.ServiceQuotationIsOpen = ''  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPrChkSrvcOrdLink AS _OpenServiceOrder ON InHouseRepairItemUUID = _OpenServiceOrder.InHouseRepairItemUUID AND _OpenServiceOrder.ServiceOrderIsOpen = 'X'  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmPrChkSrvcOrdLink AS _CompletedServiceOrder ON InHouseRepairItemUUID = _CompletedServiceOrder.InHouseRepairItemUUID AND _CompletedServiceOrder.ServiceOrderIsOpen = ''  -- association [0..*]
;