C_SupProtRstrcdProdSimlnDetTP

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_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 C_SupProtRstrcdProdSimlnDetTP AS
SELECT
  SupProtRstrcdProdUUID,
  SupplyProtectionUUID,
  SupplyProtectionGroupUUID,
  SupProtProtectedQuantity,
  SupProtConsumedQuantity,
  SupProtRemainingProtectedQty,
  SupProtRestrictedQuantity,
  AvailableQuantityInBaseUnit,
  UnitOfMeasure,
  Criticality,
  Plant,
  SupProtRstrcdProdReducnPct,
  SupProtSmltdProtectedQty,
  SupProtSmltdRmngProtectedQty,
  SupProtSmltdAvailableQty,
  SupProtSmltdRestrictedQty,
  SupProtSmltdPrtctdQtyCritlty,
  SupProtSmltdRmngProtQtyCritlty,
  SupProtSmltdRstrcdQtyCritlty,
  SupProtSmltdAvailQtyCritlty,
  LastChangeDateTime,
  _SupplyProtection.SupplyProtectionName AS SupplyProtectionName,
  _SupplyProtection.SupProtPlanningPeriodType AS SupProtPlanningPeriodType,
  _SupProtPlanningPeriodTypeT.SupProtPlanningPeriodTypeText : localized AS SupProtPlanningPeriodTypeTextlocalized,
  _SupplyProtection.SupProtPlanningPeriodStartDate AS SupProtPlanningPeriodStartDate,
  _SupplyProtection.SupProtPlanningPeriodEndDate AS SupProtPlanningPeriodEndDate,
  _SupplyProtection.SupProtPlanningPeriodTimeZone AS SupProtPlanningPeriodTimeZone,
  _SupplyProtection.SupProtIsPlanningContextSlsOrd AS SupProtIsPlanningContextSlsOrd,
  _SupplyProtection.SupProtIsPlanningContextSTO AS SupProtIsPlanningContextSTO,
  _SupplyProtection.SupProtSelfRestrictionType AS SupProtSelfRestrictionType,
  _SupProtSelfRestrictionTypeT.SupProtSelfRestrictionTypeText : localized AS SupProtSelfRestrictionTypeTextlocalized,
  _SupplyProtectionGroup.SupProtGroupPriorityValue AS SupProtGroupPriorityValue,
  _SupplyProtectionGroup.SupProtCharc01CtlgPathUUID AS SupProtCharc01CtlgPathUUID,
  cast(SupProtCharc01ValueID as sup_rop_charc_value_01 preserving type) AS SupProtCharc01ValueID,
  _SupplyProtectionGroup.SupProtCharc02CtlgPathUUID AS SupProtCharc02CtlgPathUUID,
  cast(SupProtCharc02ValueID as sup_rop_charc_value_02 preserving type) AS SupProtCharc02ValueID,
  _SupplyProtectionGroup.SupProtCharc03CtlgPathUUID AS SupProtCharc03CtlgPathUUID,
  cast(SupProtCharc03ValueID as sup_rop_charc_value_03 preserving type) AS SupProtCharc03ValueID,
  _SupplyProtectionGroup.SupProtCharc04CtlgPathUUID AS SupProtCharc04CtlgPathUUID,
  cast(SupProtCharc04ValueID as sup_rop_charc_value_04 preserving type) AS SupProtCharc04ValueID,
  _SupplyProtectionGroup.SupProtCharc05CtlgPathUUID AS SupProtCharc05CtlgPathUUID,
  cast(SupProtCharc05ValueID as sup_rop_charc_value_05 preserving type) AS SupProtCharc05ValueID,
  _SupplyProtectionGroup.SupProtCharc06CtlgPathUUID AS SupProtCharc06CtlgPathUUID,
  cast(SupProtCharc06ValueID as sup_rop_charc_value_06 preserving type) AS SupProtCharc06ValueID,
  _SupplyProtectionGroup.SupProtCharc07CtlgPathUUID AS SupProtCharc07CtlgPathUUID,
  cast(SupProtCharc07ValueID as sup_rop_charc_value_07 preserving type) AS SupProtCharc07ValueID,
  _SupplyProtectionGroup.SupProtCharc08CtlgPathUUID AS SupProtCharc08CtlgPathUUID,
  cast(SupProtCharc08ValueID as sup_rop_charc_value_08 preserving type) AS SupProtCharc08ValueID,
  _SupplyProtectionGroup.SupProtCharc09CtlgPathUUID AS SupProtCharc09CtlgPathUUID,
  cast(SupProtCharc09ValueID as sup_rop_charc_value_09 preserving type) AS SupProtCharc09ValueID,
  _SupplyProtectionGroup.SupProtCharc10CtlgPathUUID AS SupProtCharc10CtlgPathUUID,
  cast(SupProtCharc10ValueID as sup_rop_charc_value_10 preserving type) AS SupProtCharc10ValueID
FROM R_SupProtRstrcdProdSimlnDetTP
;