I_SupProtRstrcdProdSimlnDet

DDL: I_SUPPROTRSTRCDPRODSIMLNDET Type: view_entity BASIC
20 Fields 1 Data Sources

SUP Restricted Product Smltn Details

I_SupProtRstrcdProdSimlnDet is a Basic CDS View that provides data about "SUP Restricted Product Smltn Details" in SAP S/4HANA. It reads from 1 data source (sup_rop_sim_dtls) and exposes 20 fields with key fields SupProtRstrcdProdUUID, SupplyProtectionUUID, SupplyProtectionGroupUUID.

Data Sources (1)

SourceAliasJoin Type
sup_rop_sim_dtls sup_rop_sim_dtls from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SUP Restricted Product Smltn Details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SupProtRstrcdProdUUID checkresultuuid
KEY SupplyProtectionUUID supplyprotectionuuid UUID
KEY SupplyProtectionGroupUUID supplyprotectiongroupuuid CVC UUID
SupProtProtectedQuantity supprotprotectedquantity Protected Quantity
SupProtConsumedQuantity supprotconsumedquantity Consumed Quantity
SupProtRemainingProtectedQty supprotremainingprotectedqty Remaining Protection
AvailableQuantityInBaseUnit supprotavailablequantity
SupProtRestrictedQuantity supprotrestrictedquantity Restricted Quantity
UnitOfMeasure unitofmeasure Unit Protected Qty
SupProtRstrcdProdReducnPct reductionpercentage
SupProtSmltdProtectedQty supprotsmltdprotectedqty
SupProtSmltdRmngProtectedQty supprotsmltdrmngprotectedqty
SupProtSmltdAvailableQty supprotsmltdavailableqty
SupProtSmltdRestrictedQty supprotsmltdrestrictedqty
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
Plant _SupProtRstrcdProdDet Plant Valuation Area
_SupProtRstrcdProdDet _SupProtRstrcdProdDet

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_SupProtRstrcdProdSimlnDet.
-- 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_SupProtRstrcdProdSimlnDet AS
SELECT
  checkresultuuid AS SupProtRstrcdProdUUID,
  SupplyProtectionUUID,
  SupplyProtectionGroupUUID,
  SupProtProtectedQuantity,
  SupProtConsumedQuantity,
  SupProtRemainingProtectedQty,
  supprotavailablequantity AS AvailableQuantityInBaseUnit,
  SupProtRestrictedQuantity,
  UnitOfMeasure,
  reductionpercentage AS SupProtRstrcdProdReducnPct,
  SupProtSmltdProtectedQty,
  SupProtSmltdRmngProtectedQty,
  SupProtSmltdAvailableQty,
  SupProtSmltdRestrictedQty,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  _SupProtRstrcdProdDet.Plant AS Plant
FROM sup_rop_sim_dtls
;

Learn More