R_SupProtRstrcdProdSimlnDetTP

DDL: R_SUPPROTRSTRCDPRODSIMLNDETTP Type: view_entity TRANSACTIONAL
52 Fields 1 Data Sources 4 Associations

SUP Restricted Product Smltn Dets - TP

R_SupProtRstrcdProdSimlnDetTP is a Transactional CDS View that provides data about "SUP Restricted Product Smltn Dets - TP" in SAP S/4HANA. It reads from 1 data source (I_SupProtRstrcdProdSimlnDet) and exposes 52 fields with key fields SupProtRstrcdProdUUID, SupplyProtectionUUID, SupplyProtectionGroupUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SupProtRstrcdProdSimlnDet I_SupProtRstrcdProdSimlnDet from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SupplyProtection _SupplyProtection $projection.SupplyProtectionUUID = _SupplyProtection.SupplyProtectionUUID
[0..1] I_SupplyProtectionGroup _SupplyProtectionGroup $projection.SupplyProtectionGroupUUID = _SupplyProtectionGroup.SupplyProtectionGroupUUID
[0..*] I_SupProtSelfRestrictionTypeT _SupProtSelfRestrictionTypeT $projection.supprotselfrestrictiontype = _SupProtSelfRestrictionTypeT.SupProtSelfRestrictionType
[0..*] I_SupProtPlanningPeriodTypeT _SupProtPlanningPeriodTypeT $projection.supprotplanningperiodtype = _SupProtPlanningPeriodTypeT.SupProtPlanningPeriodType

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label SUP Restricted Product Smltn Dets - TP view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY SupProtRstrcdProdUUID SupProtRstrcdProdUUID
KEY SupplyProtectionUUID SupplyProtectionUUID UUID
KEY SupplyProtectionGroupUUID SupplyProtectionGroupUUID CVC UUID
SupProtProtectedQuantity SupProtProtectedQuantity Protected Quantity
SupProtConsumedQuantity SupProtConsumedQuantity Consumed Quantity
SupProtRemainingProtectedQty SupProtRemainingProtectedQty Remaining Protection
SupProtRestrictedQuantity SupProtRestrictedQuantity Restricted Quantity
AvailableQuantityInBaseUnit AvailableQuantityInBaseUnit Confirmed Qty
UnitOfMeasure UnitOfMeasure Unit Protected Qty
Plant Plant Valuation Area
SupProtRstrcdProdReducnPct SupProtRstrcdProdReducnPct
SupProtSmltdProtectedQty SupProtSmltdProtectedQty
SupProtSmltdRmngProtectedQty SupProtSmltdRmngProtectedQty
SupProtSmltdAvailableQty SupProtSmltdAvailableQty
SupProtSmltdRestrictedQty SupProtSmltdRestrictedQty
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
SupProtSelfRestrictionType _SupplyProtection SupProtSelfRestrictionType
SupProtPlanningPeriodType _SupplyProtection SupProtPlanningPeriodType
SupProtPlanningPeriodStartDate _SupplyProtection SupProtPlanningPeriodStartDate
SupProtPlanningPeriodEndDate _SupplyProtection SupProtPlanningPeriodEndDate
SupProtPlanningPeriodTimeZone _SupplyProtection SupProtPlanningPeriodTimeZone
SupProtIsPlanningContextSlsOrd _SupplyProtection SupProtIsPlanningContextSlsOrd
SupProtIsPlanningContextSTO _SupplyProtection SupProtIsPlanningContextSTO
SupProtGroupPriorityValue _SupplyProtectionGroup SupProtGroupPriorityValue
SupProtCharc01CtlgPathUUID _SupplyProtectionGroup SupProtCharc01CtlgPathUUID
SupProtCharc01ValueID _SupplyProtectionGroup SupProtCharc01ValueID
SupProtCharc02CtlgPathUUID _SupplyProtectionGroup SupProtCharc02CtlgPathUUID
SupProtCharc02ValueID _SupplyProtectionGroup SupProtCharc02ValueID
SupProtCharc03CtlgPathUUID _SupplyProtectionGroup SupProtCharc03CtlgPathUUID
SupProtCharc03ValueID _SupplyProtectionGroup SupProtCharc03ValueID
SupProtCharc04CtlgPathUUID _SupplyProtectionGroup SupProtCharc04CtlgPathUUID
SupProtCharc04ValueID _SupplyProtectionGroup SupProtCharc04ValueID
SupProtCharc05CtlgPathUUID _SupplyProtectionGroup SupProtCharc05CtlgPathUUID
SupProtCharc05ValueID _SupplyProtectionGroup SupProtCharc05ValueID
SupProtCharc06CtlgPathUUID _SupplyProtectionGroup SupProtCharc06CtlgPathUUID
SupProtCharc06ValueID _SupplyProtectionGroup SupProtCharc06ValueID
SupProtCharc07CtlgPathUUID _SupplyProtectionGroup SupProtCharc07CtlgPathUUID
SupProtCharc07ValueID _SupplyProtectionGroup SupProtCharc07ValueID
SupProtCharc08CtlgPathUUID _SupplyProtectionGroup SupProtCharc08CtlgPathUUID
SupProtCharc08ValueID _SupplyProtectionGroup SupProtCharc08ValueID
SupProtCharc09CtlgPathUUID _SupplyProtectionGroup SupProtCharc09CtlgPathUUID
SupProtCharc09ValueID _SupplyProtectionGroup SupProtCharc09ValueID
SupProtCharc10CtlgPathUUID _SupplyProtectionGroup SupProtCharc10CtlgPathUUID
SupProtCharc10ValueID _SupplyProtectionGroup SupProtCharc10ValueID
_SupProtRstrcdProdTP _SupProtRstrcdProdTP
_SupplyProtection _SupplyProtection
_SupplyProtectionGroup _SupplyProtectionGroup
_SupProtSelfRestrictionTypeT _SupProtSelfRestrictionTypeT
_SupProtPlanningPeriodTypeT _SupProtPlanningPeriodTypeT

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 R_SupProtRstrcdProdSimlnDetTP.
-- 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 R_SupProtRstrcdProdSimlnDetTP AS
SELECT
  SupProtRstrcdProdUUID,
  SupplyProtectionUUID,
  SupplyProtectionGroupUUID,
  SupProtProtectedQuantity,
  SupProtConsumedQuantity,
  SupProtRemainingProtectedQty,
  SupProtRestrictedQuantity,
  AvailableQuantityInBaseUnit,
  UnitOfMeasure,
  Plant,
  SupProtRstrcdProdReducnPct,
  SupProtSmltdProtectedQty,
  SupProtSmltdRmngProtectedQty,
  SupProtSmltdAvailableQty,
  SupProtSmltdRestrictedQty,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  _SupplyProtection.SupProtSelfRestrictionType AS SupProtSelfRestrictionType,
  _SupplyProtection.SupProtPlanningPeriodType AS SupProtPlanningPeriodType,
  _SupplyProtection.SupProtPlanningPeriodStartDate AS SupProtPlanningPeriodStartDate,
  _SupplyProtection.SupProtPlanningPeriodEndDate AS SupProtPlanningPeriodEndDate,
  _SupplyProtection.SupProtPlanningPeriodTimeZone AS SupProtPlanningPeriodTimeZone,
  _SupplyProtection.SupProtIsPlanningContextSlsOrd AS SupProtIsPlanningContextSlsOrd,
  _SupplyProtection.SupProtIsPlanningContextSTO AS SupProtIsPlanningContextSTO,
  _SupplyProtectionGroup.SupProtGroupPriorityValue AS SupProtGroupPriorityValue,
  _SupplyProtectionGroup.SupProtCharc01CtlgPathUUID AS SupProtCharc01CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc01ValueID AS SupProtCharc01ValueID,
  _SupplyProtectionGroup.SupProtCharc02CtlgPathUUID AS SupProtCharc02CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc02ValueID AS SupProtCharc02ValueID,
  _SupplyProtectionGroup.SupProtCharc03CtlgPathUUID AS SupProtCharc03CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc03ValueID AS SupProtCharc03ValueID,
  _SupplyProtectionGroup.SupProtCharc04CtlgPathUUID AS SupProtCharc04CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc04ValueID AS SupProtCharc04ValueID,
  _SupplyProtectionGroup.SupProtCharc05CtlgPathUUID AS SupProtCharc05CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc05ValueID AS SupProtCharc05ValueID,
  _SupplyProtectionGroup.SupProtCharc06CtlgPathUUID AS SupProtCharc06CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc06ValueID AS SupProtCharc06ValueID,
  _SupplyProtectionGroup.SupProtCharc07CtlgPathUUID AS SupProtCharc07CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc07ValueID AS SupProtCharc07ValueID,
  _SupplyProtectionGroup.SupProtCharc08CtlgPathUUID AS SupProtCharc08CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc08ValueID AS SupProtCharc08ValueID,
  _SupplyProtectionGroup.SupProtCharc09CtlgPathUUID AS SupProtCharc09CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc09ValueID AS SupProtCharc09ValueID,
  _SupplyProtectionGroup.SupProtCharc10CtlgPathUUID AS SupProtCharc10CtlgPathUUID,
  _SupplyProtectionGroup.SupProtCharc10ValueID AS SupProtCharc10ValueID
FROM I_SupProtRstrcdProdSimlnDet
LEFT OUTER JOIN I_SupplyProtection AS _SupplyProtection ON SupplyProtectionUUID = _SupplyProtection.SupplyProtectionUUID  -- association [0..1]
LEFT OUTER JOIN I_SupplyProtectionGroup AS _SupplyProtectionGroup ON SupplyProtectionGroupUUID = _SupplyProtectionGroup.SupplyProtectionGroupUUID  -- association [0..1]
LEFT OUTER JOIN I_SupProtSelfRestrictionTypeT AS _SupProtSelfRestrictionTypeT ON supprotselfrestrictiontype = _SupProtSelfRestrictionTypeT.SupProtSelfRestrictionType  -- association [0..*]
LEFT OUTER JOIN I_SupProtPlanningPeriodTypeT AS _SupProtPlanningPeriodTypeT ON supprotplanningperiodtype = _SupProtPlanningPeriodTypeT.SupProtPlanningPeriodType  -- association [0..*]
;

Learn More