I_InHouseRepairItemTP

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_InHouseRepairItemTP.
-- 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 I_InHouseRepairItemTP AS
SELECT
  ihritem.InHouseRepair AS InHouseRepair,
  ihritem.InHouseRepairItem AS InHouseRepairItem,
  ihritem.InHouseRepairItemUUID AS InHouseRepairItemUUID,
  ihritem.InHouseRepairItemCharUUID AS InHouseRepairItemCharUUID,
  ihritem.CreationDateTime AS CreationDateTime,
  ihritem.CreatedByUser AS CreatedByUser,
  ihritem.LastChangeDateTime AS LastChangeDateTime,
  ihritem.LastChangedByUser AS LastChangedByUser,
  ihritem.InhRepairItemObjectType AS InhRepairItemObjectType,
  ihritem.InHouseRepairUUID AS InHouseRepairUUID,
  ihritem.InhRepairItemCategory AS InhRepairItemCategory,
  ihritem.InhRepairItemStatus AS InhRepairItemStatus,
  ihritem.InhRepairItemSuplmntyStatus AS InhRepairItemSuplmntyStatus,
  ihritem.InhRepairItemAvailyStatus AS InhRepairItemAvailyStatus,
  ihritem.InhRepairItemDeliveryStatus AS InhRepairItemDeliveryStatus,
  ihritem.InhRepairItemHasError AS InhRepairItemHasError,
  ihritem.InhRepairItemIsOpen AS InhRepairItemIsOpen,
  ihritem.ProductUUID AS ProductUUID,
  ihritem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
  ihritem.Product AS Product,
  ihritem.InhRepairReferenceEquipment AS InhRepairReferenceEquipment,
  ihritem.SerialNumber AS SerialNumber,
  _InHouseRepairTP.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _InHouseRepairTP.SoldToParty AS SoldToParty,
  _InHouseRepairTP.ContactPerson AS ContactPerson,
  case when ihritem.ShipToParty is initial then _InHouseRepairTP.ShipToParty else ihritem.ShipToParty end as ShipToParty AS ShipToPartyendasShipToParty,
  _InHouseRepairTP.DistributionChannel AS DistributionChannel,
  _InHouseRepairTP.Division AS Division,
  _InHouseRepairTP.SalesOrganization AS SalesOrganization,
  _InHouseRepair.SalesOffice AS SalesOffice,
  _InHouseRepair.SalesGroup AS SalesGroup,
  _InHouseRepair.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _InHouseRepair.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _InHouseRepair.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ihritem.ReferenceCustomerReturnItem AS ReferenceCustomerReturnItem,
  ihritem.RefRetsMgmtProcessItem AS RefRetsMgmtProcessItem,
  ihritem.RefRetsMgmtProcItmQtySplit AS RefRetsMgmtProcItmQtySplit,
  ihritem.InhRepairType AS InhRepairType,
  ihritem.PostingDate AS PostingDate,
  ihritem.Quantity AS Quantity,
  ihritem.QuantityUnit AS QuantityUnit,
  cast( ihritem._ParentInHouseRepairItem.InHouseRepairItem as crms4_repa_high_lvl_item_lbl preserving type ) AS ParentInHouseRepairItem,
  IncotermsPart1,
  IncotermsPart2,
  ShippingCondition,
  DeliveryPriority,
  ihritem._InhRepairItemCategory AS _InhRepairItemCategory,
  ihritem._InhRepairItemStatus AS _InhRepairItemStatus,
  ihritem._InhRepairItemSuplmntyStatus AS _InhRepairItemSuplmntyStatus,
  ihritem._InhRepairItemHasError AS _InhRepairItemHasError,
  ihritem._InhRepairItemIsOpen AS _InhRepairItemIsOpen,
  ihritem._InhRepairReferenceEquipment AS _InhRepairReferenceEquipment,
  ihritem._Product AS _Product,
  ihritem._QuantityUnitOfMeasure AS _QuantityUnitOfMeasure,
  ihritem._ServiceOrder AS _ServiceOrder,
  ihritem._ServiceQuotation AS _ServiceQuotation,
  ihritem._SrvcMgmtObjectStatus AS _SrvcMgmtObjectStatus,
  ihritem._InhRepairItemAvailyStatus AS _InhRepairItemAvailyStatus,
  ihritem._ProductText AS _ProductText,
  ihritem._InhRepairReferenceEquipText AS _InhRepairReferenceEquipText,
  ihritem._OutboundDelivery AS _OutboundDelivery
FROM I_InHouseRepairItem AS ihritem
LEFT OUTER JOIN I_InHouseRepair AS _InHouseRepair ON _InHouseRepair.CustMgmtObjectType = 'BUS2000256' AND InHouseRepair = _InHouseRepair.InHouseRepair  -- association [1..1]
LEFT OUTER JOIN I_SitnInstceIndicator AS _SitnInstceIndicator ON _SitnInstceIndicator.SitnInstceAnchorObjectKey = InHouseRepairItemCharUUID AND _SitnInstceIndicator.SitnDefAnchorObject = 'InHouseRepairItemUUID'  -- association [0..1]
LEFT OUTER JOIN E_InHouseRepairItem AS _Extension ON _Extension.CustMgmtObjectType = 'BUS2000256' AND InHouseRepair = _Extension.InHouseRepair AND InHouseRepairItem = _Extension.InHouseRepairItem  -- association [1..1]
LEFT OUTER JOIN I_InhRepairItmCustRetRelation AS _CustomerReturnsItemReference ON ( InHouseRepairItemCharUUID = _CustomerReturnsItemReference.ServiceDocumentItemPredecessor AND _CustomerReturnsItemReference.ServiceDocItmSuccssrBusObjType = 'VBAP' ) OR ( InHouseRepairItemCharUUID = _CustomerReturnsItemReference.ServiceDocumentItemSuccessor AND _CustomerReturnsItemReference.ServiceDocItmPrdcssrBusObjType = 'VBAP' )  -- association [0..1]
LEFT OUTER JOIN R_InhReprItmWithSglReltdOrd AS _InhReprItmWithSglReltdOrd ON InHouseRepairItemUUID = _InhReprItmWithSglReltdOrd.InHouseRepairItemUUID AND InHouseRepair = _InhReprItmWithSglReltdOrd.InHouseRepair AND InHouseRepairItem = _InhReprItmWithSglReltdOrd.InHouseRepairItem  -- association [0..1]
LEFT OUTER JOIN R_InhReprItmWithSglReltdQtan AS _InhReprItmWithSglReltdQtan ON InHouseRepairItemUUID = _InhReprItmWithSglReltdQtan.InHouseRepairItemUUID AND InHouseRepair = _InhReprItmWithSglReltdQtan.InHouseRepair AND InHouseRepairItem = _InhReprItmWithSglReltdQtan.InHouseRepairItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN R_InhRepairItemNoteTP AS _InhRepairItemNoteTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InhRepairItmFUPCustReturnTP AS _InhRepairItmFUPCustReturnTP ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_InhRepairItmSrvcQtanTP AS _InhRepairItmSrvcQtanTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InhRepairItmSrvcOrdTP AS _InhRepairItmSrvcOrdTP ON /* condition not available in parsed metadata */  -- association [0..*]
;