CRMS4_SERV_H_SEARCH

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 CRMS4_SERV_H_SEARCH.
-- 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.
-- SQL view name: CRMS4_SERVHSRCH

CREATE VIEW CRMS4_SERV_H_SEARCH AS
SELECT
  objtype_h AS object_type,
  object_id,
  category,
  _actc.description AS category_txt,
  priority,
  _prio.txt_long AS priority_txt,
  period_date,
  settl_from,
  settl_to,
  bill_date,
  invcr_date,
  value_date,
  sepa_on,
  mandate_id,
  kind_date_to,
  net_weight_h,
  volume_h,
  net_value_h AS NET_VALUE,
  tax_amount_h,
  freight_h,
  number_items,
  tstmp_to_dats( valid_from, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_from AS clientNULLasvalid_from,
  tstmp_to_dats( valid_to, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as valid_to AS clientNULLasvalid_to,
  quot_start,
  quot_end,
  tstmp_to_dats( quot_start, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as quot_start_date AS clientNULLasquot_start_date,
  tstmp_to_dats( quot_end, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as quot_end_date AS clientNULLasquot_end_date,
  srv_cust_beg,
  srv_cust_end,
  srq_tot_unit,
  srv_rfirst,
  srv_rready,
  srv_close,
  contstart,
  tstmp_to_dats( contstart, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as date_start AS clientNULLasdate_start,
  contend,
  tstmp_to_dats( contend, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as date_end AS clientNULLasdate_end,
  due_on,
  header_guid,
  header_guid AS GUID,
  _SituationHdr.SitnNumberOfInstances AS SIT_NUM_HDR,
  cast(_SituationTot.SitnNumberOfInstances as sit_de_inst_count) AS SIT_NUM_TOT,
  process_type,
  posting_date,
  description_h AS description,
  upper( description_h) AS DESCRIPTION_UC,
  created_at_h,
  created_at_h AS CREATED_AT,
  tstmp_to_dats( created_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CREATED_AT_DATE AS clientNULLasCREATED_AT_DATE,
  tstmp_to_dats( created_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CREATED_ON AS clientNULLasCREATED_ON,
  changed_at_h,
  changed_at_h AS CHANGED_AT,
  tstmp_to_dats( changed_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CHANGED_AT_DATE AS clientNULLasCHANGED_AT_DATE,
  tstmp_to_dats( changed_at_h, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as CHANGED_ON AS clientNULLasCHANGED_ON,
  created_by_h,
  created_by_h AS CREATED_BY,
  changed_by_h,
  changed_by_h AS changed_by,
  btx_class,
  auth_scope,
  object_id_ok,
  verify_date,
  dis_channel,
  division,
  division_ori,
  sales_org,
  sales_office,
  sales_group,
  service_org,
  sales_org_sd,
  _sold.BusinessPartnerFullName AS SOLD_TO_PARTY_LIST,
  payer,
  _payr.BusinessPartnerFullName AS payer_list,
  person_resp,
  resp_group,
  service_team,
  _inbxasgnto.BusinessPartnerFullName AS INBOX_ASSIGNED_TO_list,
  _inbxgrpasgn.BusinessPartnerFullName AS INBOX_GROUP_ASSIGNED_list,
  _inbxacct.BusinessPartnerFullName AS INBOX_ACCOUNT_list,
  _inbxcustcont.BusinessPartnerFullName AS INBOX_CONTACT_PERSON_list,
  payplan_type,
  exchg_type,
  exchg_date,
  taxjurcode,
  ref_currency,
  currency,
  price_date,
  pmnttrms,
  price_grp,
  cust_group,
  exchg_rate,
  tax_dest_cty,
  tax_dest_reg,
  vat_reg_no,
  ac_indicator,
  region,
  industry,
  cust_group1,
  cust_group2,
  cust_group3,
  cust_group4,
  cust_group5,
  po_date_sold,
  po_date_ship,
  usage_type,
  submission,
  rejection,
  probability,
  incoterms1,
  incoterms2,
  ship_cond,
  over_dlv_tol,
  dlv_prio,
  ordercombind,
  part_dlv,
  dlv_group,
  part_dlv_itm,
  rec_priority,
  urgency,
  impact,
  escalation,
  risk,
  is_updated,
  chklst_id,
  wp_fixval,
  stat_credit,
  stat_error,
  stat_billing,
  stat_open,
  inbox_status,
  stat_ico,
  _LglControlStatus.SrvcDocGTSStatusText AS stat_gts_lglControl_desc,
  asp_id_01,
  cat_id_01,
  asp_id_02,
  cat_id_02,
  rule_horizon,
  rule_date_to,
  cancproc,
  cancparty,
  canc_reason
FROM crms4d_serv_h AS _SRVH
LEFT OUTER JOIN I_BusinessPartner AS _sold ON _SRVH.sold_to_party = _sold.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ship ON _SRVH.ship_to_party = _ship.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _bill ON _SRVH.bill_to_party = _bill.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _payr ON _SRVH.payer = _payr.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _resp ON _SRVH.person_resp = _resp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _cont ON _SRVH.contact_person = _cont.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _rgrp ON _SRVH.resp_group = _rgrp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _srvt ON _SRVH.service_team = _srvt.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _semp ON _SRVH.service_employee = _semp.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _cacc ON _SRVH.contract_account = _cacc.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxasgnto ON _SRVH.inbox_assigned_to = _inbxasgnto.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxgrpasgn ON _SRVH.inbox_group_assigned = _inbxgrpasgn.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxacct ON _SRVH.inbox_account = _inbxacct.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _inbxcustcont ON _SRVH.inbox_contact_person = _inbxcustcont.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN crmc_act_cat_t AS _actc ON _SRVH.category = _actc.category AND _actc.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN scpriot AS _prio ON _SRVH.priority = _prio.priority AND _prio.langu = $session.system_language  -- association [0..1]
LEFT OUTER JOIN CRMS4_PROC_TYPE AS _proc ON _SRVH.process_type = _proc.Process_Type  -- association [0..1]
LEFT OUTER JOIN CRMS4_LFCY_STATUS AS _lfcy ON _SRVH.stat_lifecycle = _lfcy.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_CANC_STATUS AS _canc ON _SRVH.stat_cancelled = _canc.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_RELE_STATUS AS _rele ON _SRVH.stat_released = _rele.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_QUOT_STATUS AS _quot ON _SRVH.stat_quotation = _quot.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_DELI_STATUS AS _deli ON _SRVH.stat_delivery = _deli.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ERRO_STATUS AS _erro ON _SRVH.stat_error = _erro.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_GDIS_STATUS AS _gdis ON _SRVH.stat_goods_issue = _gdis.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_BILL_STATUS AS _bili ON _SRVH.stat_billing = _bili.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_FBIL_STATUS AS _fbil ON _SRVH.stat_for_billing = _fbil.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_OPEN_STATUS AS _open ON _SRVH.stat_open = _open.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ARCB_STATUS AS _arcb ON _SRVH.stat_archivable = _arcb.domvalue_l  -- association [0..1]
LEFT OUTER JOIN CRMS4_ARCD_STATUS AS _arcd ON _SRVH.stat_archived = _arcd.domvalue_l  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON _SRVH.objtype_h = _ServiceDocumentExt.ServiceCategory AND _SRVH.object_id = _ServiceDocumentExt.ServiceOrder  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefMaintenancePlan AS _RefMaintenancePlan ON _SRVH.header_guid = _RefMaintenancePlan.ServiceDocumentUUID AND _SRVH.objtype_h = _RefMaintenancePlan.ServiceObjectType  -- association [0..1]
LEFT OUTER JOIN I_SrvcOrdRefMaintenanceItem AS _RefMaintenanceItem ON _SRVH.header_guid = _RefMaintenanceItem.ServiceDocumentUUID AND _SRVH.objtype_h = _RefMaintenanceItem.ServiceObjectType  -- association [0..1]
LEFT OUTER JOIN I_SitnInstceIndicator AS _SituationHdr ON _SRVH.header_guid_char = _SituationHdr.SitnInstceAnchorObjectKey  -- association [0..1]
LEFT OUTER JOIN CRMS4_SERV_SITN_TOT_COUNT AS _SituationTot ON _SRVH.header_guid_char = _SituationTot.header_key  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgText ON _SalesOrgText.SalesOrganization = _SRVH.sales_org_sd AND _SalesOrgText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistrChannelText ON _DistrChannelText.DistributionChannel = _SRVH.dis_channel AND _DistrChannelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON _DivisionText.Division = _SRVH.division AND _DivisionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesOfficeText AS _SalesOfficeText ON _SalesOfficeText.SalesOffice = _SRVH.sales_office_sd AND _SalesOfficeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesGroupText AS _SalesGroupText ON _SalesGroupText.SalesGroup = _SRVH.sales_group_sd AND _SalesGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseServiceOrgText AS _EnterpriseServiceOrgText ON _EnterpriseServiceOrgText.EnterpriseServiceOrganization = _SRVH.enterprise_service_org AND _EnterpriseServiceOrgText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN crms4d_ext_ref AS _ExtRef ON _SRVH.objtype_h = _ExtRef.objtype_h AND _SRVH.object_id = _ExtRef.object_id  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocCreditStatusText AS _credit ON _SRVH.stat_credit = _credit.DomainValue AND _credit.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocExecutionStatusText AS _maint ON _SRVH.stat_maintenance = _maint.DomainValue AND _maint.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocBslnCostPostgStatusT AS _basln ON _SRVH.stat_bsln_cost_postg = _basln.SrvcDocBslnCostPostgStatus AND _basln.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocBslnCostPostgStatusT AS _ongoing ON _SRVH.stat_cont_cost_calc = _ongoing.SrvcDocBslnCostPostgStatus AND _ongoing.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocInterCoProcgStatusTxt AS _ico ON _SRVH.stat_ico = _ico.SrvcDocInterCoProcgStatus AND _ico.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocBizCmpltdStatusText AS _bizcmpl ON _SRVH.stat_business_completed = _bizcmpl.SrvcDocBizCompletedStatus AND _bizcmpl.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN CRMS4_REF_OBJECT AS _refobj ON _SRVH.object_id = _refobj.object_id AND _SRVH.objtype_h = _refobj.objtype_h  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocGTSStatusText AS _EmbargoStatus ON _SRVH.stat_gts_embargo = _EmbargoStatus.DomainValue AND _EmbargoStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocGTSStatusText AS _LglControlStatus ON _SRVH.stat_gts_legal_control = _LglControlStatus.DomainValue AND _LglControlStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SrvcDocGTSStatusText AS _ScreeningStatus ON _SRVH.stat_gts_screening = _ScreeningStatus.DomainValue AND _ScreeningStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_RespyMgmtTeamDescription AS _SrvTeamDesc ON _SrvTeamDesc.ObjectID = _SRVH.service_team_rm AND _SrvTeamDesc.LanguageKey = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_RespyMgmtTeamHeaderMainObj AS _SrvTeamName ON _SrvTeamName.ObjectID = _SRVH.service_team_rm AND _SrvTeamName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentPredecessor AS _PrecedingServiceOrder ON _SRVH.header_guid = _PrecedingServiceOrder.ServiceDocumentUUID AND _PrecedingServiceOrder.ServiceDocPrdcssrBusObjType = 'BUS2000116' AND _PrecedingServiceOrder.ServiceObjectType = 'BUS2000117'  -- association [0..1]
;