CRMS4_IU_I_S_CTI

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_IU_I_S_CTI.
-- 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 CRMS4_IU_I_S_CTI AS
SELECT
  crms4d_iuci_i.objtype_h AS BusinessObjectType,
  crms4d_iuci_i.object_id AS UtilitiesSalesContract,
  crms4d_iuci_i.number_int AS UtilitiesSalesContractItem,
  crms4d_iuci_i.header_guid AS UtilitiesSalesContractUUID,
  crms4d_iuci_i.item_guid AS UtilsSalesContrItemUUID,
  crms4d_iuci_i.item_guid_char AS UtilsSalesContrItemCharUUID,
  crms4d_iuci_i.objtype_i AS UtilsSalesContrItemObjectType,
  crms4d_iuci_i.parent AS ParentUtilsSalesContrItemUUID,
  crms4d_iuci_i.description_i AS UtilsSalesContrItemDescription,
  crms4d_iuci_i.logical_contract_item AS UtilsSalesContrLogicalItem,
  crms4d_iuci_i.order_date AS ItemPostingDateTime,
  _UtilitiesSalesContract.UtilsSalesContrDescription AS UtilsSalesContrDescription,
  _UtilitiesSalesContract.PostingDate AS PostingDate,
  _UtilitiesSalesContract.SoldToPartyCountry AS SoldToPartyCountry,
  _UtilitiesSalesContract.SoldToPartyRegion AS SoldToPartyRegion,
  _UtilitiesSalesContract.SoldToParty AS SoldToParty,
  _UtilitiesSalesContract.ServiceTeam AS ServiceTeam,
  _UtilitiesSalesContract.ResponsibleEmployee AS ResponsibleEmployee,
  _UtilitiesSalesContract.ServiceEmployee AS ServiceEmployee,
  _UtilitiesSalesContract.ContactPerson AS ContactPerson,
  _UtilitiesSalesContract.PayerParty AS PayerParty,
  _UtilitiesSalesContract.BillToParty AS BillToParty,
  crms4d_iuci_i.stat_lifecycle AS UtilsSalesContrItemLifeCycle,
  crms4d_iuci_i.stat_error AS UtilsSalesContrItemHasError,
  crms4d_iuci_i.stat_open AS UtilsSalesContrItemIsOpen,
  crms4d_iuci_i.stat_released AS UtilsSalesContrItemIsReleased,
  crms4d_iuci_i.stat_cancelled AS UtilsSalesContrItemIsRejected,
  crms4d_iuci_i.stat_quotation AS UtilsSalesContrItemIsQuotation,
  _UtilitiesSalesContract.UtilsSalesContrIsArchivabl AS UtilsSalesContrItemIsArchivabl,
  _UtilitiesSalesContract.UtilsSalesContrIsArchived AS UtilsSalesContrItemIsArchived,
  crms4d_iuci_i.created_at_i AS UtilsSalesContrItemCrtedDteTme,
  crms4d_iuci_i.changed_at_i AS UtilsSalesContrItemChgdDteTme,
  crms4d_iuci_i.created_by_i AS UtilsSalesContrItemCrtedByUser,
  crms4d_iuci_i.changed_by_i AS UtilsSalesContrItemChgdByUser,
  crms4d_iuci_i.ordered_prod AS OriginallyRequestedProduct,
  crms4d_iuci_i.contstart AS UtilsSalesContrItemStartDteTme,
  crms4d_iuci_i.contend AS UtilsSalesContrItemEndDteTme,
  _LogicalDates.UtilsSalesContrLogStartDteTme AS UtilsSalesContrLogStartDteTme,
  _LogicalDates.UtilsSalesContrLogEndDteTme AS UtilsSalesContrLogEndDteTme,
  _LogicalDates.FirstItemPostingDateTime AS FirstItemPostingDateTime,
  _LatestItem.UtilitiesSalesContractItem AS LatestItem,
  _LatestItem.UtilsSalesContrItemEndDteTme AS LatestEndDateTime,
  _LatestItem.UtilsSalesContrItemStartDteTme AS LatestStartDateTime,
  crms4d_iuci_i.product_id AS Product,
  _ProductText[1: Language = $session.system_language].ProductName AS ProductName,
  crms4d_iuci_i.installation AS UtilitiesInstallation,
  crms4d_iuci_i.pod_int_ui AS UtilsInternalPointOfDelivery,
  crms4d_iuci_i.contract_account AS UtilitiesContractAccount,
  crms4d_iuci_i.premise AS UtilitiesPremise,
  crms4d_iuci_i.isu_contract AS UtilitiesContract,
  _UtilitiesInstallation.Division AS Division,
  _UtilitiesInstallation._Division._Text[1: Language = $session.system_language].DivisionName AS DivisionName,
  crms4d_iuci_i.itm_language AS Language,
  crms4d_iuci_i.salesdocument AS SalesDocument,
  crms4d_iuci_i.salesdocumentitem AS SalesDocumentItem,
  _UtilitiesSalesContract._SoldToParty AS _SoldToParty,
  _UtilitiesSalesContract._RespEmployee AS _RespEmployee,
  _UtilitiesSalesContract._ServiceTeam AS _ServiceTeam,
  _UtilitiesSalesContract._ServiceEmployee AS _ServiceEmployee,
  _UtilitiesSalesContract._ContactPerson AS _ContactPerson,
  _UtilitiesSalesContract._PayerParty AS _PayerParty,
  _UtilitiesSalesContract._BillToParty AS _BillToParty,
  _UtilitiesSalesContract._SoldToPartyRegion AS _SoldToPartyRegion,
  _UtilitiesSalesContract._SoldToPartyCountry AS _SoldToPartyCountry
LEFT OUTER JOIN CRMS4_IU_I_S_CTL_DATES AS _LogicalDates ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CRMS4_IU_I_S_CTI_L AS _LatestItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustMgmtBusObjType AS _BusinessObjectType ON BusinessObjectType = _BusinessObjectType.BusinessObjectType  -- association [1..1]
LEFT OUTER JOIN CRMS4_IU_I_S_CTH AS _UtilitiesSalesContract ON BusinessObjectType = _UtilitiesSalesContract.BusinessObjectType AND UtilitiesSalesContract = _UtilitiesSalesContract.UtilitiesSalesContract  -- association [1..1]
LEFT OUTER JOIN CRMS4_IU_I_S_CTP AS _UtilitiesSalesContractPerd ON UtilitiesSalesContract = _UtilitiesSalesContractPerd.UtilitiesSalesContract AND UtilitiesSalesContractItem = _UtilitiesSalesContractPerd.UtilsSalesContrPerdItemNumber  -- association [1..*]
LEFT OUTER JOIN CRMS4_IU_I_POD AS _UtilitiesPointOfDelivery ON UtilsInternalPointOfDelivery = _UtilitiesPointOfDelivery.UtilsInternalPointOfDelivery  -- association [0..1]
LEFT OUTER JOIN CRMS4_IU_I_PRD AS _UtilitiesProduct ON _UtilitiesProduct.UtilitiesProduct = Product  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesInstallation AS _UtilitiesInstallation ON _UtilitiesInstallation.UtilitiesInstallation = UtilitiesInstallation  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesContract AS _UtilitiesContract ON _UtilitiesContract.UtilitiesContract = UtilitiesContract  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesPremise AS _UtilitiesPremise ON _UtilitiesPremise.UtilitiesPremise = UtilitiesPremise  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON _ContractAccountPartner.ContractAccount = UtilitiesContractAccount AND _ContractAccountPartner.BusinessPartner = soldtoparty  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON _SalesDocumentItem.SalesDocument = SalesDocument AND _SalesDocumentItem.SalesDocumentItem = SalesDocumentItem  -- association [0..1]
;