A_UtilitiesSalesContractItem

DDL: A_UTILITIESSALESCONTRACTITEM Type: view_entity CONSUMPTION
36 Fields 1 Data Sources 1 Associations 1 OData Services

Utilities Sales Contract Item

A_UtilitiesSalesContractItem is a Consumption CDS View that provides data about "Utilities Sales Contract Item" in SAP S/4HANA. It reads from 1 data source (R_UtilitiesSalesContractItemTP) and exposes 36 fields with key fields UtilsSalesContractObjectType, UtilitiesSalesContract, UtilitiesSalesContractItem. It has 1 association to related views. It is exposed through 1 OData service (API_UTILITIESSALESCONTRACT).

Data Sources (1)

SourceAliasJoin Type
R_UtilitiesSalesContractItemTP R_UtilitiesSalesContractItemTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_UtilitiesSalesContractPeriod _UtilsSalesContractPeriod $projection.UtilsSalesContractObjectType = _UtilsSalesContractPeriod.UtilsSalesContractObjectType and $projection.UtilitiesSalesContract = _UtilsSalesContractPeriod.UtilitiesSalesContract and $projection.UtilitiesSalesContractItem = _UtilsSalesContractPeriod.UtilitiesSalesContractItem

Annotations (10)

NameValueLevelField
EndUserText.label Utilities Sales Contract Item view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name UtilitiesSalesContractItem view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
OData.entityType.name UtilitiesSalesContractItem_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_UTILITIESSALESCONTRACT API_UTILITIESSALESCONTRACT V4 C2 NOT_RELEASED

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY UtilsSalesContractObjectType UtilsSalesContractObjectType
KEY UtilitiesSalesContract UtilitiesSalesContract
KEY UtilitiesSalesContractItem UtilitiesSalesContractItem
UtilitiesSalesContractUUID UtilitiesSalesContractUUID
UtilitiesSalesContractItemUUID UtilitiesSalesContractItemUUID
UtilsSlsContrItemCharacterUUID UtilsSlsContrItemCharacterUUID
UtilsSlsContractItemObjectType UtilsSlsContractItemObjectType
UtilsSlsContrItemDescription UtilsSlsContrItemDescription
UtilsSalesContrLogicalItem UtilsSalesContrLogicalItem
ProductUUID ProductUUID UUID
Product Product Product Sold
OriginallyRequestedProduct OriginallyRequestedProduct
UtilsSlsContrItmPostgDateTime UtilsSlsContrItmPostgDateTime
UtilsSlsContrItemStartDateTime UtilsSlsContrItemStartDateTime
UtilsSlsContrItemEndDateTime UtilsSlsContrItemEndDateTime
UtilsSalesContractItemCategory UtilsSalesContractItemCategory
Language Language Report Text Language
UtilitiesInstallation UtilitiesInstallation
UtilsInternalPointOfDelivery UtilsInternalPointOfDelivery
ContractAccount ContractAccount Contract Acct
UtilitiesPremise UtilitiesPremise Premise
UtilitiesContract UtilitiesContract
UtilsSlsContrItemPreviousItem UtilsSlsContrItemPreviousItem
UtilitiesSalesContractProcess UtilitiesSalesContractProcess
UtilsSlsContrUIProcess UtilsSlsContrUIProcess
UtilsSlsContrItmLfcycStatus UtilsSlsContrItmLfcycStatus
UtilsSalesContractItemHasError UtilsSalesContractItemHasError
UtilsSalesContractItemIsOpen UtilsSalesContractItemIsOpen
UtilsSlsContrItemIsReleased UtilsSlsContrItemIsReleased
UtilsSlsContrItemIsRejected UtilsSlsContrItemIsRejected
UtilsSlsContractItemIsArchived UtilsSlsContractItemIsArchived
CreationDateTime CreationDateTime Timestamp
ChangedDateTime ChangedDateTime Time Stamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
_UtilsSalesContractPeriod _UtilsSalesContractPeriod

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 A_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 A_UtilitiesSalesContractItem AS
SELECT
  UtilsSalesContractObjectType,
  UtilitiesSalesContract,
  UtilitiesSalesContractItem,
  UtilitiesSalesContractUUID,
  UtilitiesSalesContractItemUUID,
  UtilsSlsContrItemCharacterUUID,
  UtilsSlsContractItemObjectType,
  UtilsSlsContrItemDescription,
  UtilsSalesContrLogicalItem,
  ProductUUID,
  Product,
  OriginallyRequestedProduct,
  UtilsSlsContrItmPostgDateTime,
  UtilsSlsContrItemStartDateTime,
  UtilsSlsContrItemEndDateTime,
  UtilsSalesContractItemCategory,
  Language,
  UtilitiesInstallation,
  UtilsInternalPointOfDelivery,
  ContractAccount,
  UtilitiesPremise,
  UtilitiesContract,
  UtilsSlsContrItemPreviousItem,
  UtilitiesSalesContractProcess,
  UtilsSlsContrUIProcess,
  UtilsSlsContrItmLfcycStatus,
  UtilsSalesContractItemHasError,
  UtilsSalesContractItemIsOpen,
  UtilsSlsContrItemIsReleased,
  UtilsSlsContrItemIsRejected,
  UtilsSlsContractItemIsArchived,
  CreationDateTime,
  ChangedDateTime,
  CreatedByUser,
  LastChangedByUser
FROM R_UtilitiesSalesContractItemTP
LEFT OUTER JOIN A_UtilitiesSalesContractPeriod AS _UtilsSalesContractPeriod ON UtilsSalesContractObjectType = _UtilsSalesContractPeriod.UtilsSalesContractObjectType AND UtilitiesSalesContract = _UtilsSalesContractPeriod.UtilitiesSalesContract AND UtilitiesSalesContractItem = _UtilsSalesContractPeriod.UtilitiesSalesContractItem  -- association [0..*]
;

Learn More