C_InhReprItmMngReprObjectObjPg

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_InhReprItmMngReprObjectObjPg.
-- 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_InhReprItmMngReprObjectObjPg AS
SELECT
  InHouseRepair,
  InHouseRepairItem,
  InHouseRepairItemUUID,
  LastChangeDateTime,
  CreationDateTime,
  InHouseRepairUUID,
  InhRepairType,
  InhRepairItemCategory,
  InhRepairItemStatus,
  Product,
  _ProductText.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 AS ContactPersonBusinessPartnerId,
  cast(_InHouseRepairTP._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,
  ShipToPartyAddressID,
  DistributionChannel,
  Division,
  SalesOrganization,
  RespEmployeeBusinessPartnerId,
  cast(_InHouseRepairTP._ResponsibleEmployee.BusinessPartnerName as crms4_repa_resp_empl_name_lbl preserving type) AS ResponsibleEmployeeName,
  _InHouseRepairTP.InHouseRepairEndCustomer AS InHouseRepairEndCustomer,
  cast(_InHouseRepairTP._EndCustomer.BusinessPartnerName as crms4_repa_endcust_name_lbl preserving type) AS InHouseRepairEndCustomerName,
  InhRepairItemAvailyStatus,
  ParentInHouseRepairItem,
  Quantity,
  QuantityUnit,
  _QuantityUnitOfMeasure._Text.UnitOfMeasureName : localized AS UnitOfMeasureNamelocalized,
  _CustomerReturnsItemReference.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  IncotermsPart1,
  IncotermsPart2,
  ShippingCondition,
  DeliveryPriority,
  Plant,
  InHouseRepairItemTP._Plant.PlantName AS PlantName,
  StorageLocation,
  InHouseRepairItemTP._StorageLocation.StorageLocationName AS StorageLocationName,
  InhRepairItemSpecialStockType,
  InHouseRepairItemTP._InhReprItemSpecialStockTypeT.InhReprItmSpecialStockTypeText : localized AS InhReprItmSpecialStockTypeTextlocalized,
  InhReprItmInvtryUsabilityCode,
  InHouseRepairItemTP._InhReprItmInvtryUsblyCodeTxt.InhReprItmInvtryUsblyCodeText : localized AS InhReprItmInvtryUsblyCodeTextlocalized,
  _InHouseRepair._SalesOrganization.CompanyCode AS CompanyCode,
  InhRepairItemIsObsolete
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 ContactPersonBusinessPartnerId = _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_SrvcMgmtSoldToPartyQuickVw AS _EndCustomerQuickView ON InHouseRepairEndCustomer = _EndCustomerQuickView.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_InhReprItmReprObjExectblActn 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_InhReprItmMngReprObjQtanLink AS _ServiceQuotation ON InHouseRepairItemUUID = _ServiceQuotation.InHouseRepairItemUUID  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmMngReprObjOrdLink AS _ServiceOrder ON InHouseRepairItemUUID = _ServiceOrder.InHouseRepairItemUUID  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmMngReprObjQtanLink AS _OpenServiceQuotation ON InHouseRepairItemUUID = _OpenServiceQuotation.InHouseRepairItemUUID AND _OpenServiceQuotation.ServiceQuotationIsOpen = 'X'  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmMngReprObjQtanLink AS _CompletedServiceQuotation ON InHouseRepairItemUUID = _CompletedServiceQuotation.InHouseRepairItemUUID AND _CompletedServiceQuotation.ServiceQuotationIsOpen = ''  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmMngReprObjOrdLink AS _OpenServiceOrder ON InHouseRepairItemUUID = _OpenServiceOrder.InHouseRepairItemUUID AND _OpenServiceOrder.ServiceOrderIsOpen = 'X'  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmMngReprObjOrdLink AS _CompletedServiceOrder ON InHouseRepairItemUUID = _CompletedServiceOrder.InHouseRepairItemUUID AND _CompletedServiceOrder.ServiceOrderIsOpen = ''  -- association [0..*]
LEFT OUTER JOIN C_InhReprItmMngReprObjSrlNmbr AS _InhReprItmMngReprObjSrlNmbr ON InHouseRepair = _InhReprItmMngReprObjSrlNmbr.InHouseRepair AND InHouseRepairItem = _InhReprItmMngReprObjSrlNmbr.InHouseRepairItem  -- association [1..*]
LEFT OUTER JOIN C_InhReprItmMngReprObjHistory AS _InhReprItmMngReprObjHistory ON InHouseRepair = _InhReprItmMngReprObjHistory.InHouseRepair AND InHouseRepairItem = _InhReprItmMngReprObjHistory.InHouseRepairItem  -- association [0..*]
;