I_InHouseRepairItem

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_InHouseRepairItem.
-- 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_InHouseRepairItem AS
SELECT
  objtype_h AS CustMgmtObjectType,
  cast(object_id as crms4_repa_inhouse_repair_lbl preserving type) AS InHouseRepair,
  cast(number_int as crms4_repa_item_lbl preserving type) AS InHouseRepairItem,
  item_guid AS InHouseRepairItemUUID,
  cast(item_guid_char as crms4_repa_object_guid32 preserving type) AS InHouseRepairItemCharUUID,
  created_at_i AS CreationDateTime,
  created_by_i AS CreatedByUser,
  changed_at_i AS LastChangeDateTime,
  changed_by_i AS LastChangedByUser,
  objtype_i AS InhRepairItemObjectType,
  header_guid AS InHouseRepairUUID,
  product AS ProductUUID,
  ordered_prod AS OriginallyRequestedProduct,
  ship_to_party AS ShipToParty,
  product_id AS Product,
  itm_type AS InhRepairItemCategory,
  cast(stat_lifecycle as crms4_repa_item_status_lbl preserving type ) AS InhRepairItemStatus,
  stat_suppl AS InhRepairItemSuplmntyStatus,
  stat_delivery AS InhRepairItemDeliveryStatus,
  stat_repair_availability AS InhRepairItemAvailyStatus,
  stat_error AS InhRepairItemHasError,
  stat_open AS InhRepairItemIsOpen,
  equipment_id AS InhRepairReferenceEquipment,
  _InHouseRepair.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _InHouseRepair.SalesOrganization AS SalesOrganization,
  _InHouseRepair.DistributionChannel AS DistributionChannel,
  _InHouseRepair.Division AS Division,
  _InHouseRepair.SalesOffice AS SalesOffice,
  _InHouseRepair.SalesGroup AS SalesGroup,
  _InHouseRepair.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _InHouseRepair.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _InHouseRepair.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  cast(serial_number as crms4_repa_equip_serialnumber preserving type) AS SerialNumber,
  process_type AS InhRepairType,
  posting_date AS PostingDate,
  ref_return_order_item AS ReferenceCustomerReturnItem,
  ref_msr_item AS RefRetsMgmtProcessItem,
  ref_msr_split_id AS RefRetsMgmtProcItmQtySplit,
  parent AS ParentInHouseRepairItemUUID,
  cast( order_qty as crms4_repa_item_qty_lbl preserving type ) AS Quantity,
  base_qty_unit AS QuantityUnit,
  incoterms1 AS IncotermsPart1,
  incoterms2 AS IncotermsPart2,
  ship_cond AS ShippingCondition,
  dlv_prio AS DeliveryPriority
FROM crms4d_repa_i
LEFT OUTER JOIN I_BusinessObjType AS _CustMgmtObjectType ON CustMgmtObjectType = _CustMgmtObjectType.BusinessObjectType  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocItemCategory AS _InhRepairItemCategory ON InhRepairItemCategory = _InhRepairItemCategory.ServiceDocItemCategory  -- association [0..1]
LEFT OUTER JOIN I_InhRepairItemStatus AS _InhRepairItemStatus ON InhRepairItemCategory = _InhRepairItemStatus.InhRepairItemCategory AND InhRepairItemStatus = _InhRepairItemStatus.InhRepairItemStatus  -- association [0..1]
LEFT OUTER JOIN I_InhRepairItemStatus AS _InhRepairItemSuplmntyStatus ON InhRepairItemCategory = _InhRepairItemSuplmntyStatus.InhRepairItemCategory AND InhRepairItemSuplmntyStatus = _InhRepairItemSuplmntyStatus.InhRepairItemStatus  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocErrorStatus AS _InhRepairItemHasError ON InhRepairItemHasError = _InhRepairItemHasError.ServiceDocumentHasError  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocOpenStatus AS _InhRepairItemIsOpen ON InhRepairItemIsOpen = _InhRepairItemIsOpen.ServiceDocumentIsOpen  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _InhRepairReferenceEquipment ON InhRepairReferenceEquipment = _InhRepairReferenceEquipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_InHouseRepair AS _InHouseRepair ON CustMgmtObjectType = _InHouseRepair.CustMgmtObjectType AND InHouseRepair = _InHouseRepair.InHouseRepair  -- association [1..1]
LEFT OUTER JOIN I_EquipmentText AS _InhRepairReferenceEquipText ON InhRepairReferenceEquipment = _InhRepairReferenceEquipText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnitOfMeasure ON QuantityUnit = _QuantityUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_InhRepairTransactionRelation AS _ServiceOrder ON InHouseRepairItemUUID = _ServiceOrder.CustMgmtPrdcssrTransactionUUID AND _ServiceOrder.CustMgmtTransacRelationType = 'IHR1' AND _ServiceOrder.CustMgmtPrdcssrTransacObjType = 'BUS2000257'  -- association [0..*]
LEFT OUTER JOIN I_InhRepairTransactionRelation AS _ServiceQuotation ON InHouseRepairItemUUID = _ServiceQuotation.CustMgmtPrdcssrTransactionUUID AND _ServiceQuotation.CustMgmtTransacRelationType = 'IHR2' AND _ServiceQuotation.CustMgmtPrdcssrTransacObjType = 'BUS2000257'  -- association [0..*]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcMgmtObjectStatus ON InHouseRepairItemUUID = _SrvcMgmtObjectStatus.SrvcMgmtObjectUUID AND _SrvcMgmtObjectStatus.SrvcMgmtObjectStatusIsInactive = '' AND ( _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1002' OR _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1003' OR _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1005' )  -- association [0..1]
LEFT OUTER JOIN I_InhRepairTransactionRelation AS _OutboundDelivery ON InHouseRepairItemUUID = _OutboundDelivery.CustMgmtPrdcssrTransactionUUID AND _OutboundDelivery.CustMgmtTransacRelationType = 'VONA' AND _OutboundDelivery.CustMgmtSuccssrTransacObjType = 'LIKP'  -- association [0..1]
LEFT OUTER JOIN I_InhRepairItemAvailyStatus AS _InhRepairItemAvailyStatus ON InhRepairItemAvailyStatus = _InhRepairItemAvailyStatus.InhRepairItemAvailyStatus  -- association [0..1]
LEFT OUTER JOIN I_InHouseRepairItem AS _ParentInHouseRepairItem ON InHouseRepair = _ParentInHouseRepairItem.InHouseRepair AND ParentInHouseRepairItemUUID = _ParentInHouseRepairItem.InHouseRepairItemUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
;