R_VarConfignPossibleValueTP

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_VarConfignPossibleValueTP.
-- 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_VarConfignPossibleValueTP AS
SELECT
  cast('' as ibobjkey) AS VarConfigurationBusObjectKey,
  cast('' as sbo_node_type) AS VarConfigurationBusObjectType,
  cast(0 as vch_hl_cfg_instance_id) AS VarConfignInstceInternalID,
  cast('' as atnam) AS Characteristic,
  cast('' as vdm_cbase_value_id) AS VariantConfigurationValueID,
  cast('' as atwrt) AS VarCnfCharacteristicValue,
  cast('' as atwtb) AS VarCnfCharcValueDescription,
  cast(0 as vch_hl_value_df34_min) AS VarCnfCharcFromQuantity,
  cast('' as msehi) AS VarCnfCharcFromQuantityUnit,
  cast('' as isocd_unit) AS VarCnfCharcFromQuantityISOUnit,
  cast(0 as vch_hl_value_df34_min) AS VarCnfCharcToQuantity,
  cast('' as msehi) AS VarCnfCharcToQuantityUnit,
  cast('' as isocd_unit) AS VarCnfCharcToQuantityISOUnit,
  cast(0 as vch_hl_value_df34_min) AS VarCnfCharcFromNumericValue,
  cast(0 as vch_hl_value_df34_max) AS VarCnfCharcToNumericValue,
  cast('' as auspext_date_from) AS VarCnfCharcFromDate,
  cast('' as auspext_date_to) AS VarCnfCharcToDate,
  cast('000000' as auspext_time_from) AS VarCnfCharcFromTime,
  cast('000000' as auspext_time_to) AS VarCnfCharcToTime,
  cast(0 as vch_hl_value_df34_min) AS VarCnfCharcFromAmount,
  cast(0 as vch_hl_value_df34_min) AS VarCnfCharcToAmount,
  cast('' as waers_curc) AS VarCnfCharcCurrency,
  cast('' as atcod preserving type) AS VarCnfCharcValueIntervalType,
  cast(0 as vch_hl_assignment_type) AS VarConfignValueAssignmentType,
  cast('' as boole_d preserving type) AS ValueIsMasterData,
  cast('' as boole_d) AS VarConfignValHasHighPrecision,
  cast(0 as vch_hl_cstic_sort_key) AS VarConfignSortingNumber
FROM ibin
LEFT OUTER JOIN R_VariantConfigurationTP AS _Root ON _Root.VarConfigurationBusObjectType = VarConfigurationBusObjectType AND _Root.VarConfigurationBusObjectKey = VarConfigurationBusObjectKey  -- association [1..1]
LEFT OUTER JOIN R_VariantConfigurationTP AS _VariantConfiguration ON _VariantConfiguration.VarConfigurationBusObjectType = VarConfigurationBusObjectType AND _VariantConfiguration.VarConfigurationBusObjectKey = VarConfigurationBusObjectKey  -- association [1..1]
;