What is A_UtilitiesSalesContractPeriod in SAP S/4HANA?

A_UtilitiesSalesContractPeriod is a consumption CDS view in SAP S/4HANA. Utilities Sales Contract Period It contains 31 fields.

Which tables does A_UtilitiesSalesContractPeriod read from?

A_UtilitiesSalesContractPeriod reads data from: R_UtilsSalesContractPeriodTP.

What VDM layer is A_UtilitiesSalesContractPeriod?

A_UtilitiesSalesContractPeriod is classified as a Consumption view optimized for specific business scenarios and reporting.

A_UtilitiesSalesContractPeriod

DDL: A_UTILITIESSALESCONTRACTPERIOD Type: view_entity CONSUMPTION

31 Fields 1 Data Sources 1 Associations

Utilities Sales Contract Period

A_UtilitiesSalesContractPeriod is a Consumption CDS View that provides data about "Utilities Sales Contract Period" in SAP S/4HANA. It reads from 1 data source (R_UtilsSalesContractPeriodTP) and exposes 31 fields with key fields UtilsSalesContractObjectType, UtilitiesSalesContract, UtilitiesSalesContractPeriod. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
R_UtilsSalesContractPeriodTP	R_UtilsSalesContractPeriodTP	projection

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	A_UtilsSlsContrPerdConfignVal	_ConfigurationValue	`$projection.UtilsSalesContractObjectType = _ConfigurationValue.UtilsSalesContractObjectType and $projection.UtilitiesSalesContract = _ConfigurationValue.UtilitiesSalesContract and $projection.UtilitiesSalesContractPeriod = _ConfigurationValue.UtilitiesSalesContractPeriod`

Annotations (10)

Name	Value	Level
EndUserText.label	Utilities Sales Contract Period	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.sapObjectNodeType.name	UtilitiesSalesContractPeriod	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	UtilitiesSalesContractPeriod_Type	view

Fields (31)

Key	Field	Source Field	Description
KEY	UtilsSalesContractObjectType	UtilsSalesContractObjectType
KEY	UtilitiesSalesContract	UtilitiesSalesContract
KEY	UtilitiesSalesContractPeriod	UtilitiesSalesContractPeriod
	UtilitiesSalesContractUUID	UtilitiesSalesContractUUID
	UtilsSalesContractPeriodUUID	UtilsSalesContractPeriodUUID
	UtilsSlsContrPerdCharacterUUID	UtilsSlsContrPerdCharacterUUID
	UtilsSlsContrPeriodObjectType	UtilsSlsContrPeriodObjectType
	UtilsSlsContrPeriodDescription	UtilsSlsContrPeriodDescription
	UtilsSlsContrPerdPostgDateTime	UtilsSlsContrPerdPostgDateTime
	ProductUUID	ProductUUID	UUID
	Product	Product	Product Sold
	OriginallyRequestedProduct	OriginallyRequestedProduct
	ConfigurationNumber	ConfigurationNumber	Int. object no.
	UtilsSlsContrPerdStartDateTime	UtilsSlsContrPerdStartDateTime
	UtilsSlsContrPerdEndDateTime	UtilsSlsContrPerdEndDateTime
	UtilsSlsContractPeriodCategory	UtilsSlsContractPeriodCategory
	Language	Language	Report Text Language
	UtilitiesSalesContractProcess	UtilitiesSalesContractProcess
	UtilsSlsContrUIProcess	UtilsSlsContrUIProcess
	UtilitiesSalesContractItem	UtilitiesSalesContractItem
	UtilsSalesContractPeriodStatus	UtilsSalesContractPeriodStatus
	UtilsSlsContractPeriodHasError	UtilsSlsContractPeriodHasError
	UtilsSalesContractPeriodIsOpen	UtilsSalesContractPeriodIsOpen
	UtilsSlsContrPeriodIsReleased	UtilsSlsContrPeriodIsReleased
	UtilsSlsContrPeriodIsRejected	UtilsSlsContrPeriodIsRejected
	UtilsSlsContrPeriodIsArchived	UtilsSlsContrPeriodIsArchived
	CreationDateTime	CreationDateTime	Timestamp
	ChangedDateTime	ChangedDateTime	Time Stamp
	CreatedByUser	CreatedByUser	User Name
	LastChangedByUser	LastChangedByUser	User Name
	_ConfigurationValue	_ConfigurationValue

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_UtilitiesSalesContractPeriod.
-- 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_UtilitiesSalesContractPeriod AS
SELECT
  UtilsSalesContractObjectType,
  UtilitiesSalesContract,
  UtilitiesSalesContractPeriod,
  UtilitiesSalesContractUUID,
  UtilsSalesContractPeriodUUID,
  UtilsSlsContrPerdCharacterUUID,
  UtilsSlsContrPeriodObjectType,
  UtilsSlsContrPeriodDescription,
  UtilsSlsContrPerdPostgDateTime,
  ProductUUID,
  Product,
  OriginallyRequestedProduct,
  ConfigurationNumber,
  UtilsSlsContrPerdStartDateTime,
  UtilsSlsContrPerdEndDateTime,
  UtilsSlsContractPeriodCategory,
  Language,
  UtilitiesSalesContractProcess,
  UtilsSlsContrUIProcess,
  UtilitiesSalesContractItem,
  UtilsSalesContractPeriodStatus,
  UtilsSlsContractPeriodHasError,
  UtilsSalesContractPeriodIsOpen,
  UtilsSlsContrPeriodIsReleased,
  UtilsSlsContrPeriodIsRejected,
  UtilsSlsContrPeriodIsArchived,
  CreationDateTime,
  ChangedDateTime,
  CreatedByUser,
  LastChangedByUser
FROM R_UtilsSalesContractPeriodTP
LEFT OUTER JOIN A_UtilsSlsContrPerdConfignVal AS _ConfigurationValue ON UtilsSalesContractObjectType = _ConfigurationValue.UtilsSalesContractObjectType AND UtilitiesSalesContract = _ConfigurationValue.UtilitiesSalesContract AND UtilitiesSalesContractPeriod = _ConfigurationValue.UtilitiesSalesContractPeriod  -- association [0..*]
;

Depth:

A_UtilitiesSalesContractPeriod view_entity

R_UtilsSalesContractPeriodTP view_entity