C_RevSupplyProtectionTP

DDL: C_REVSUPPLYPROTECTIONTP Type: view_entity CONSUMPTION
21 Fields 1 Data Sources

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 21 fields with key field SupProtReviewObjectUUID.

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

Fields (21)

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
PlantForEdit _SupplyProtectionTP PlantForEdit Plant ID
PoolSegment _SupplyProtectionTP PoolSegment Pool Seg.
Batch _SupplyProtectionTP Batch Lot No.
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.PlantForEdit AS PlantForEdit,
  _SupplyProtectionTP.PoolSegment AS PoolSegment,
  _SupplyProtectionTP.Batch AS Batch,
  _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
;

Learn More