I_UtilitiesSalesContractItem

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_UtilitiesSalesContractItem.
-- 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_UtilitiesSalesContractItem AS
SELECT
  objtype_h AS UtilsSalesContractObjectType,
  object_id AS UtilitiesSalesContract,
  number_int AS UtilitiesSalesContractItem,
  header_guid AS UtilitiesSalesContractUUID,
  item_guid AS UtilitiesSalesContractItemUUID,
  item_guid_char AS UtilsSlsContrItemCharacterUUID,
  objtype_i AS UtilsSlsContractItemObjectType,
  description_i AS UtilsSlsContrItemDescription,
  logical_contract_item AS UtilsSalesContrLogicalItem,
  product AS ProductUUID,
  product_id AS Product,
  ordered_prod AS OriginallyRequestedProduct,
  order_date AS UtilsSlsContrItmPostgDateTime,
  contstart AS UtilsSlsContrItemStartDateTime,
  contend AS UtilsSlsContrItemEndDateTime,
  itm_type AS UtilsSalesContractItemCategory,
  itm_language AS Language,
  pod_int_ui AS UtilsInternalPointOfDelivery,
  contract_account AS ContractAccount,
  premise AS UtilitiesPremise,
  isu_contract AS UtilitiesContract,
  previous_item AS UtilsSlsContrItemPreviousItem,
  pf_process AS UtilitiesSalesContractProcess,
  ui_process AS UtilsSlsContrUIProcess,
  stat_error AS UtilsSalesContractItemHasError,
  stat_open AS UtilsSalesContractItemIsOpen,
  stat_released AS UtilsSlsContrItemIsReleased,
  stat_cancelled AS UtilsSlsContrItemIsRejected,
  stat_archived AS UtilsSlsContractItemIsArchived,
  changed_at_i AS ChangedDateTime,
  created_by_i AS CreatedByUser,
  changed_by_i AS LastChangedByUser
FROM crms4d_iuci_i
LEFT OUTER JOIN I_CustMgmtBusObjType AS _UtilsSalesContractObjectType ON _UtilsSalesContractObjectType.BusinessObjectType = UtilsSalesContractObjectType  -- association [1..1]
LEFT OUTER JOIN I_CustMgmtItmBusObjType AS _UtilsSlsContrItemObjectType ON _UtilsSlsContrItemObjectType.BusinessObjectType = UtilsSlsContractItemObjectType  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocItemCategory AS _UtilsSlsContractItemCategory ON _UtilsSlsContractItemCategory.ServiceDocItemCategory = UtilsSalesContractItemCategory  -- association [1..1]
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _UtilsSlsContrItemObjectStatus ON _UtilsSlsContrItemObjectStatus.SrvcMgmtObjectUUID = UtilitiesSalesContractItemUUID  -- association [0..*]
LEFT OUTER JOIN I_SrvcDocLifecycleStatus AS _UtilsSalesContractItemStatus ON UtilsSlsContrItmLfcycStatus = _UtilsSalesContractItemStatus.ServiceDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_UtilitiesSalesContract AS _UtilitiesSalesContract ON _UtilitiesSalesContract.UtilsSalesContractObjectType = UtilsSalesContractObjectType AND _UtilitiesSalesContract.UtilitiesSalesContract = UtilitiesSalesContract  -- association [1..1]
LEFT OUTER JOIN I_UtilitiesSalesContractItem AS _UtilsSlsContrItemPreviousItem ON _UtilsSlsContrItemPreviousItem.UtilsSalesContractObjectType = UtilsSalesContractObjectType AND _UtilsSlsContrItemPreviousItem.UtilitiesSalesContract = UtilitiesSalesContract AND _UtilsSlsContrItemPreviousItem.UtilitiesSalesContractItem = UtilsSlsContrItemPreviousItem  -- association [0..1]
LEFT OUTER JOIN I_UtilsSalesContractPeriod AS _UtilsSalesContractPeriod ON _UtilsSalesContractPeriod.UtilsSalesContractObjectType = UtilsSalesContractObjectType AND _UtilsSalesContractPeriod.UtilitiesSalesContract = UtilitiesSalesContract AND _UtilsSalesContractPeriod.UtilitiesSalesContractItem = UtilitiesSalesContractItem  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON product = _Product.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_UtilsAllocOfExtToIntPoD AS _UtilsAllocOfExtToIntPoD ON _UtilsAllocOfExtToIntPoD.UtilsInternalPointOfDelivery = UtilsInternalPointOfDelivery  -- association [0..*]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON _ContractAccount.ContractAccount = ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN E_UtilitiesSalesContractItem AS _Extension ON _Extension.UtilsSalesContractObjectType = UtilsSalesContractObjectType AND _Extension.UtilitiesSalesContract = UtilitiesSalesContract AND _Extension.UtilitiesSalesContractItem = UtilitiesSalesContractItem  -- association [1..1]
;