I_SupProtTimeBucketTP_2

DDL: I_SUPPROTTIMEBUCKETTP_2 Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources

Supply Protection Time Bucket - TP

I_SupProtTimeBucketTP_2 is a Transactional CDS View that provides data about "Supply Protection Time Bucket - TP" in SAP S/4HANA. It reads from 1 data source (I_SupplyProtectionTimeBucketTP) and exposes 16 fields with key field SupProtTimeBucketUUID.

Data Sources (1)

SourceAliasJoin Type
I_SupplyProtectionTimeBucketTP I_SupplyProtectionTimeBucketTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Supply Protection Time Bucket - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey SupProtTimeBucketUUID view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SupProtTimeBucketUUID TimeBucket SupProtTimeBucketUUID
SupplyProtectionUUID TimeBucket SupplyProtectionUUID UUID
SupplyProtectionGroupUUID TimeBucket SupplyProtectionGroupUUID CVC UUID
SupProtPeriodStartUTCDateTime TimeBucket SupProtPeriodStartUTCDateTime
SupProtPeriodEndUTCDateTime TimeBucket SupProtPeriodEndUTCDateTime
UnitOfMeasure TimeBucket UnitOfMeasure Unit Protected Qty
UnitOfMeasureISOCode TimeBucket UnitOfMeasureISOCode
SupProtProtectedQuantity TimeBucket SupProtProtectedQuantity Protected Quantity
SupProtConsumedQuantity TimeBucket SupProtConsumedQuantity Consumed Quantity
SupProtRemainingProtectedQty TimeBucket SupProtRemainingProtectedQty Remaining Protection
CreatedByUser TimeBucket CreatedByUser User Name
CreationDateTime TimeBucket CreationDateTime Timestamp
LastChangedByUser TimeBucket LastChangedByUser User Name
LastChangeDateTime TimeBucket LastChangeDateTime Timestamp
Plant TimeBucket Plant Valuation Area
CharcValAuthznGroup TimeBucket CharcValAuthznGroup Authorization Group

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_SupProtTimeBucketTP_2.
-- 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_SupProtTimeBucketTP_2 AS
SELECT
  TimeBucket.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  TimeBucket.SupplyProtectionUUID AS SupplyProtectionUUID,
  TimeBucket.SupplyProtectionGroupUUID AS SupplyProtectionGroupUUID,
  TimeBucket.SupProtPeriodStartUTCDateTime AS SupProtPeriodStartUTCDateTime,
  TimeBucket.SupProtPeriodEndUTCDateTime AS SupProtPeriodEndUTCDateTime,
  TimeBucket.UnitOfMeasure AS UnitOfMeasure,
  TimeBucket.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  TimeBucket.SupProtProtectedQuantity AS SupProtProtectedQuantity,
  TimeBucket.SupProtConsumedQuantity AS SupProtConsumedQuantity,
  TimeBucket.SupProtRemainingProtectedQty AS SupProtRemainingProtectedQty,
  TimeBucket.CreatedByUser AS CreatedByUser,
  TimeBucket.CreationDateTime AS CreationDateTime,
  TimeBucket.LastChangedByUser AS LastChangedByUser,
  TimeBucket.LastChangeDateTime AS LastChangeDateTime,
  TimeBucket.Plant AS Plant,
  TimeBucket.CharcValAuthznGroup AS CharcValAuthznGroup
FROM I_SupplyProtectionTimeBucketTP
;

Learn More