R_VarConfignCharacteristicTP

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_VarConfignCharacteristicTP.
-- 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_VarConfignCharacteristicTP 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 atfor) AS CharcDataType,
  cast('' as atsch) AS CharcTemplate,
  cast('' as waers_curc) AS Currency,
  cast('' as msehi) AS CharcValueUnit,
  cast(' ' as isocd_unit) AS VarCnfCharcISOUnit,
  cast('' as vcr_is_read_only) AS IsReadOnly,
  cast('' as entryisrequired) AS EntryIsRequired,
  cast('' as charcishidden) AS CharcIsHidden,
  cast('' as additionalvalueisallowed) AS AdditionalValueIsAllowed,
  cast('' as multiplevaluesareallowed) AS MultipleValuesAreAllowed,
  cast('' as vch_hl_ext_confign_status) AS VarConfignStatus,
  cast('' as vchclf_cstic_id) AS CharcInternalID,
  cast('' as atbez) AS CharcDescription,
  cast(0 as int4) AS CharcNumberOfMasterDataValues,
  cast('' as vchclf_formatted_value_range) AS CharcFormattedValueRangeText,
  cast('' as boole_d) AS CharcIsIntervalValueAllowed,
  cast(0 as timestampl) AS CharcLastChangedDateTime,
  cast('' as boole_d) AS CharcMDDomainHasIntervalValues
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]
LEFT OUTER JOIN R_VarConfignAssignedValueTP AS _AssignedValue ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_VarConfignPossibleValueTP AS _PossibleValue ON /* condition not available in parsed metadata */  -- association [0..*]
;