I_InHouseRepair

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_InHouseRepair.
-- 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_InHouseRepair AS
SELECT
  objtype_h AS CustMgmtObjectType,
  cast(object_id as crms4_repa_inhouse_repair_lbl preserving type ) AS InHouseRepair,
  header_guid AS InHouseRepairUUID,
  cast(header_guid_char as crms4_repa_object_guid32 preserving type) AS InHouseRepairCharUUID,
  process_type AS InhRepairType,
  cast(posting_date as crms4_repa_created_on_lbl preserving type ) AS PostingDate,
  created_at_h AS CreationDateTime,
  created_by_h AS CreatedByUser,
  changed_at_h AS LastChangeDateTime,
  changed_by_h AS LastChangedByUser,
  cast(stat_lifecycle as crms4_repa_status_lbl preserving type ) AS InhRepairStatus,
  stat_error AS InhRepairHasError,
  stat_open AS InhRepairIsOpen,
  sold_to_party AS SoldToParty,
  cast(contact_person as crms4_repa_contact_lbl preserving type ) AS ContactPerson,
  ship_to_party AS ShipToParty,
  cast( person_resp as crms4_repa_resp_employee_lbl preserving type ) AS ResponsibleEmployee,
  end_customer AS InHouseRepairEndCustomer,
  sales_org_sd AS SalesOrganization,
  sales_office_sd AS SalesOffice,
  sales_group_sd AS SalesGroup,
  cast( sales_org as crms4_repa_sales_org_naid_lbl2 preserving type ) AS SalesOrganizationOrgUnitID,
  sales_office AS SalesOfficeOrgUnitID,
  sales_group AS SalesGroupOrgUnitID,
  cast( sales_org_resp as crms4_repa_sales_org_un_id_lbl preserving type ) AS ResponsibleSalesOrganization,
  dis_channel AS DistributionChannel,
  Division,
  ref_return_order AS ReferenceCustomerReturn,
  ref_msr_id AS RefRetsMgmtProcess,
  incoterms1 AS IncotermsPart1,
  incoterms2 AS IncotermsPart2,
  ship_cond AS ShippingCondition,
  dlv_prio AS DeliveryPriority,
  stat_repa_ico AS InHouseRepairIsIntercompany
FROM crms4d_repa_h
LEFT OUTER JOIN I_BusinessObjType AS _CustMgmtObjectType ON CustMgmtObjectType = _CustMgmtObjectType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _InhRepairType ON InhRepairType = _InhRepairType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_InhRepairStatus AS _InhRepairStatus ON InhRepairStatus = _InhRepairStatus.InhRepairStatus  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocErrorStatus AS _InhRepairHasError ON InhRepairHasError = _InhRepairHasError.ServiceDocumentHasError  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocOpenStatus AS _InhRepairIsOpen ON InhRepairIsOpen = _InhRepairIsOpen.ServiceDocumentIsOpen  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _SoldToParty ON SoldToParty = _SoldToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ContactPerson ON ContactPerson = _ContactPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ResponsibleEmployee ON ResponsibleEmployee = _ResponsibleEmployee.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _EndCustomer ON InHouseRepairEndCustomer = _EndCustomer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _SalesOrganizationOrgUnit ON SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit.OrgUnitTypeIDConcatenated AND _SalesOrganizationOrgUnit.StartDate <= $session.system_date AND _SalesOrganizationOrgUnit.EndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _SalesOfficeOrgUnit ON SalesOfficeOrgUnitID = _SalesOfficeOrgUnit.OrgUnitTypeIDConcatenated AND _SalesOfficeOrgUnit.StartDate <= $session.system_date AND _SalesOfficeOrgUnit.EndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _SalesGroupOrgUnit ON SalesGroupOrgUnitID = _SalesGroupOrgUnit.OrgUnitTypeIDConcatenated AND _SalesGroupOrgUnit.StartDate <= $session.system_date AND _SalesGroupOrgUnit.EndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationUnit AS _ResponsibleSalesOrg ON ResponsibleSalesOrganization = _ResponsibleSalesOrg.OrgUnitTypeIDConcatenated AND _ResponsibleSalesOrg.StartDate <= $session.system_date AND _ResponsibleSalesOrg.EndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOrganizationOrgUnit_2 ON SalesOrganizationOrgUnitID = _SalesOrganizationOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesOfficeOrgUnit_2 ON SalesOfficeOrgUnitID = _SalesOfficeOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _SalesGroupOrgUnit_2 ON SalesGroupOrgUnitID = _SalesGroupOrgUnit_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_SrvcMgmtOrganizationUnit AS _ResponsibleSalesOrg_2 ON ResponsibleSalesOrganization = _ResponsibleSalesOrg_2.OrgUnitTypeIDConcatenated  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_InHouseRepairItem AS _InHouseRepairItem ON CustMgmtObjectType = _InHouseRepairItem.CustMgmtObjectType AND InHouseRepair = _InHouseRepairItem.InHouseRepair  -- association [0..*]
LEFT OUTER JOIN I_InhRepairTransactionRelation AS _RepairOrders ON InHouseRepairUUID = _RepairOrders.CustMgmtPrdcssrTransactionUUID AND _RepairOrders.CustMgmtTransacRelationType = 'IHR1' AND _RepairOrders.CustMgmtPrdcssrTransacObjType = 'BUS2000256'  -- association [0..*]
LEFT OUTER JOIN I_InhRepairTransactionRelation AS _RepairQuotation ON InHouseRepairUUID = _RepairQuotation.CustMgmtPrdcssrTransactionUUID AND _RepairQuotation.CustMgmtTransacRelationType = 'IHR2' AND _RepairQuotation.CustMgmtPrdcssrTransacObjType = 'BUS2000256'  -- association [0..*]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcMgmtObjectStatus ON InHouseRepairUUID = _SrvcMgmtObjectStatus.SrvcMgmtObjectUUID AND _SrvcMgmtObjectStatus.SrvcMgmtObjectStatusIsInactive = '' AND ( _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1002' OR _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1003' OR _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1005' )  -- association [0..1]
LEFT OUTER JOIN I_InhRepairStatusText AS _InhRepairStatusText ON InhRepairStatus = _InhRepairStatusText.InhRepairStatus  -- association [0..*]
LEFT OUTER JOIN I_InhRepairTransactionRelation AS _PredecessorCustomerReturn ON InHouseRepairUUID = _PredecessorCustomerReturn.CustMgmtSuccssrTransactionUUID AND _PredecessorCustomerReturn.CustMgmtTransacRelationType = 'VONA' AND _PredecessorCustomerReturn.CustMgmtPrdcssrTransacObjType = 'BUS2102'  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocHeaderLongText AS _SrvcDocHeaderLongText ON _SrvcDocHeaderLongText.ServiceObjectType = CustMgmtObjectType AND _SrvcDocHeaderLongText.ServiceDocument = InHouseRepair AND _SrvcDocHeaderLongText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN E_InHouseRepair AS _Extension ON CustMgmtObjectType = _Extension.CustMgmtObjectType AND InHouseRepair = _Extension.InHouseRepair  -- association [1..1]
;