CRMS4_IU_I_S_CTI_L

DDL: CRMS4_IU_I_S_CTI_L Type: view

Utilities Sales Contract Item Latest

CRMS4_IU_I_S_CTI_L is a CDS View that provides data about "Utilities Sales Contract Item Latest" in SAP S/4HANA. It reads from 2 data sources (CRMS4_IU_P_S_CTI_L, crms4d_iuci_i) and exposes 5 fields with key fields UtilitiesSalesContract, UtilsSalesContrItemStartDteTme.

Data Sources (2)

SourceAliasJoin Type
CRMS4_IU_P_S_CTI_L CRMS4_IU_P_S_CTI_L from
crms4d_iuci_i crms4d_iuci_i inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4IUSICTIL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utilities Sales Contract Item Latest view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesSalesContract CRMS4_IU_P_S_CTI_L UtilitiesSalesContract Transaction ID
KEY UtilsSalesContrItemStartDteTme CRMS4_IU_P_S_CTI_L UtilsSalesContrItemStartDteTme
UtilsSalesContrItemEndDteTme CRMS4_IU_P_S_CTI_L UtilsSalesContrItemEndDteTme
UtilsSalesContrLogicalItem CRMS4_IU_P_S_CTI_L UtilsSalesContrLogicalItem Logical Item Ident
UtilitiesSalesContractItem crms4d_iuci_i number_int Item Number in Doc.

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_L.
-- 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_L AS
SELECT
  CRMS4_IU_P_S_CTI_L.UtilitiesSalesContract AS UtilitiesSalesContract,
  CRMS4_IU_P_S_CTI_L.UtilsSalesContrItemStartDteTme AS UtilsSalesContrItemStartDteTme,
  CRMS4_IU_P_S_CTI_L.UtilsSalesContrItemEndDteTme AS UtilsSalesContrItemEndDteTme,
  CRMS4_IU_P_S_CTI_L.UtilsSalesContrLogicalItem AS UtilsSalesContrLogicalItem,
  crms4d_iuci_i.number_int AS UtilitiesSalesContractItem
FROM CRMS4_IU_P_S_CTI_L
INNER JOIN crms4d_iuci_i ON /* join condition not captured in parsed metadata */
;