CRMS4_IU_P_S_CTI_L

DDL: CRMS4_IU_P_S_CTI_L SQL: CRMS4IUSPCTIL Type: view
4 Fields 1 Data Sources

Utilities Sales Contract Item Latest

CRMS4_IU_P_S_CTI_L is a CDS View that provides data about "Utilities Sales Contract Item Latest" in SAP S/4HANA. It reads from 1 data source (crms4d_iuci_i) and exposes 4 fields.

Data Sources (1)

SourceAliasJoin Type
crms4d_iuci_i crms4d_iuci_i from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CRMS4IUSPCTIL 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 (4)

KeyFieldSource TableSource FieldDescription
UtilitiesSalesContract object_id Transaction ID
UtilsSalesContrLogicalItem logical_contract_item Logical Item Ident
UtilsSalesContrItemStartDteTme
UtilsSalesContrItemEndDteTme

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_P_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.
-- SQL view name: CRMS4IUSPCTIL

CREATE VIEW CRMS4_IU_P_S_CTI_L AS
SELECT
  object_id AS UtilitiesSalesContract,
  logical_contract_item AS UtilsSalesContrLogicalItem,
  max(contstart) AS UtilsSalesContrItemStartDteTme,
  max(contend) AS UtilsSalesContrItemEndDteTme
FROM crms4d_iuci_i
;

Learn More