I_UtilsPoDAttributes

DDL: I_UTILSPODATTRIBUTES Type: view_entity BASIC

Utilities Point of Delivery Attributes

I_UtilsPoDAttributes (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

UtilsPointOfDeliveryAttributes · Utilities

I_UtilsPoDAttributes is a Basic CDS View that provides data about "Utilities Point of Delivery Attributes" in SAP S/4HANA. It reads from 1 data source (euiattr) and exposes 15 fields with key fields UtilsInternalPointOfDelivery, UtilsPoDAttributesEndDate, UtilsPoDAttributesEndTime. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-IDE
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
PackageUtilities for SAP S/4HANA

Documentation

Data Sources (1)

SourceAliasJoin Type
euiattr euiattr from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UtilsPoDHeader _UtilsPoDHeaderAggrgn $projection.UtilsIntAggrgnPointOfDelivery = _UtilsPoDHeaderAggrgn.UtilsInternalPointOfDelivery
[1..1] I_UtilsPoDHeader _UtilsPoDHeader $projection.UtilsInternalPointOfDelivery = _UtilsPoDHeader.UtilsInternalPointOfDelivery
[0..1] I_UtilsPoDUsageContext _UtilsPoDUsageContext $projection.UtilsPoDUsageContext = _UtilsPoDUsageContext.UtilsPoDUsageContext

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Utilities Point of Delivery Attributes view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name UtilsPointOfDeliveryAttributes view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY UtilsInternalPointOfDelivery int_ui Internal key for point of delivery
KEY UtilsPoDAttributesEndDate dateto Valid-To Date
KEY UtilsPoDAttributesEndTime timeto Valid-To Time
UtilsPoDAttributesStartDate datefrom Valid From
UtilsPoDAttributesStartTime timefrom Time from
UtilsPoDUsageContext usagecontext Usage Context for Point of Delivery
UtilsPointOfDeliveryIsDormant dormant Point of Delivery Is Dormant
UtilsIntAggrgnPointOfDelivery int_ui_aggr Internal Key for Aggregation Point of Delivery
UtilsPoDAttributesCreationDate erdat Record Created On
UtilsPoDAttributesCrtdByUser ernam Name of Person Responsible for Creating the Object
UtilsPoDAttributesChangeDate aedat Last Changed On
UtilsPoDAttributesChgdByUser aenam Name of Person Who Changed Object
_UtilsPoDHeader _UtilsPoDHeader
_UtilsPoDHeaderAggrgn _UtilsPoDHeaderAggrgn
_UtilsPoDUsageContext _UtilsPoDUsageContext

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_UtilsPoDAttributes.
-- 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_UtilsPoDAttributes AS
SELECT
  int_ui AS UtilsInternalPointOfDelivery,
  dateto AS UtilsPoDAttributesEndDate,
  timeto AS UtilsPoDAttributesEndTime,
  datefrom AS UtilsPoDAttributesStartDate,
  timefrom AS UtilsPoDAttributesStartTime,
  usagecontext AS UtilsPoDUsageContext,
  dormant AS UtilsPointOfDeliveryIsDormant,
  int_ui_aggr AS UtilsIntAggrgnPointOfDelivery,
  erdat AS UtilsPoDAttributesCreationDate,
  ernam AS UtilsPoDAttributesCrtdByUser,
  aedat AS UtilsPoDAttributesChangeDate,
  aenam AS UtilsPoDAttributesChgdByUser
FROM euiattr
LEFT OUTER JOIN I_UtilsPoDHeader AS _UtilsPoDHeaderAggrgn ON UtilsIntAggrgnPointOfDelivery = _UtilsPoDHeaderAggrgn.UtilsInternalPointOfDelivery  -- association [0..1]
LEFT OUTER JOIN I_UtilsPoDHeader AS _UtilsPoDHeader ON UtilsInternalPointOfDelivery = _UtilsPoDHeader.UtilsInternalPointOfDelivery  -- association [1..1]
LEFT OUTER JOIN I_UtilsPoDUsageContext AS _UtilsPoDUsageContext ON UtilsPoDUsageContext = _UtilsPoDUsageContext.UtilsPoDUsageContext  -- association [0..1]
;