C_RevSupplyProtectionTP

DDL: C_REVSUPPLYPROTECTIONTP Type: view_entity CONSUMPTION

Review Supply Protection Object

C_RevSupplyProtectionTP is a Consumption CDS View that provides data about "Review Supply Protection Object" in SAP S/4HANA. It reads from 1 data source (R_RevSupplyProtectionTP) and exposes 19 fields with key field SupProtReviewObjectUUID. It is exposed through 1 OData service (UI_SUPPLYPROTECTION_REVIEW). It is used in 1 Fiori application: Review Availability Check Result - Supply Protection.

Data Sources (1)

SourceAliasJoin Type
R_RevSupplyProtectionTP R_RevSupplyProtectionTP projection

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Review Supply Protection Object view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SUPPLYPROTECTION_REVIEW UI_SUPPLYPROTECTION_REVIEW V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5504 Review Availability Check Result - Supply Protection Transactional, Reuse Component Review Availability Check Result - Supply Protection

Review Availability Check Result - Supply Protection

Business Role: Others

This feature enables you to display details about the impact of supply protection on the product availability check (PAC).

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SupProtReviewObjectUUID SupProtReviewObjectUUID
ATPCheckUUID ATPCheckUUID Check ID
SupProtReviewRequestUUID SupProtReviewRequestUUID
SupplyProtectionUUID SupplyProtectionUUID UUID
UnitOfMeasure UnitOfMeasure Unit Protected Qty
SupplyProtectionName _SupplyProtectionTP SupplyProtectionName
SupProtPlanningLevel _SupplyProtectionTP SupProtPlanningLevel Planning Level
SupProtPlanningLevelTextlocalized
Material _SupplyProtectionTP Material Vehicle Model
Plant _SupplyProtectionTP Plant Valuation Area
PoolSegment _SupplyProtectionTP PoolSegment Pool Seg.
SupProtCnsmpnDateTimeType _SupplyProtectionTP SupProtCnsmpnDateTimeType
SupProtCnsmpnDateTimeTypeTextlocalized
SupProtPlanningPeriodStartDate _SupplyProtectionTP SupProtPlanningPeriodStartDate
SupProtPlanningPeriodEndDate _SupplyProtectionTP SupProtPlanningPeriodEndDate
SupProtProtectedQuantity
SupProtConsumedQuantity
SupProtRestrictedQuantity SupProtRestrictedQuantity Restricted Quantity
_ATPCheckTPredirectedtoC_RACRCheckTP

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 C_RevSupplyProtectionTP.
-- 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 C_RevSupplyProtectionTP AS
SELECT
  SupProtReviewObjectUUID,
  ATPCheckUUID,
  SupProtReviewRequestUUID,
  SupplyProtectionUUID,
  UnitOfMeasure,
  _SupplyProtectionTP.SupplyProtectionName AS SupplyProtectionName,
  _SupplyProtectionTP.SupProtPlanningLevel AS SupProtPlanningLevel,
  _SupplyProtectionTP._SupProtPlanningLevelText.SupProtPlanningLevelText : localized AS SupProtPlanningLevelTextlocalized,
  _SupplyProtectionTP.Material AS Material,
  _SupplyProtectionTP.Plant AS Plant,
  _SupplyProtectionTP.PoolSegment AS PoolSegment,
  _SupplyProtectionTP.SupProtCnsmpnDateTimeType AS SupProtCnsmpnDateTimeType,
  _SupplyProtectionTP._SupProtCnsmpnDateTimeTypeT.SupProtCnsmpnDateTimeTypeText : localized AS SupProtCnsmpnDateTimeTypeTextlocalized,
  _SupplyProtectionTP.SupProtPlanningPeriodStartDate AS SupProtPlanningPeriodStartDate,
  _SupplyProtectionTP.SupProtPlanningPeriodEndDate AS SupProtPlanningPeriodEndDate,
  cast(_SupplyProtectionTP.SupProtProtectedQuantity as sup_protected_quantity preserving type) AS SupProtProtectedQuantity,
  cast(_SupplyProtectionTP.SupProtConsumedQuantity as sup_consumed_quantity preserving type) AS SupProtConsumedQuantity,
  SupProtRestrictedQuantity
FROM R_RevSupplyProtectionTP
;