P_Cfd_Custom_Field_Versions

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 P_Cfd_Custom_Field_Versions.
-- 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.
-- SQL view name: P_CFD_FIELD_VERS

CREATE VIEW P_Cfd_Custom_Field_Versions AS
SELECT
  Field.external_name AS ExternalName,
  businessContext.business_context AS BusinessContext,
  Field.name AS Name,
  Field.version AS Version,
  businessContext.deviating_field_name AS DeviatingFieldName,
  case when businessContext.deviating_field_name = '' then concat(concat(Field.external_name, '_'), businessContext.persistence_context_suffix) else businessContext.deviating_field_name end as TechnicalName AS deviating_field_nameendasTechnicalName,
  coalesce ( _UiTextsInOriginalLanguage.FieldLabel, _DataElementTextFallback.LongLabel ) as FieldLabel AS LongLabelasFieldLabel,
  Field.type AS InternalType,
  case when Field.type = #CFD_FIELD_TYPE.ASC_TO_STD then 'ASC_TO_CBO' else Field.type end as Type AS typeendasType,
  case when Field.data_element_name = '' then Field.length else _DataElement.leng end as Length AS lengendasLength,
  case when Field.data_element_name = '' then Field.scale else _DataElement.decimals end as Scale AS decimalsendasScale,
  case when Field.data_element_name = '' then '' else _DataElement.datatype end as DataType AS datatypeendasDataType,
  Field.origin AS Origin,
  tadir.masterlang AS MasterLanguage,
  Field.aggregation AS Aggregation,
  Field.data_element_name AS DataElementName,
  Field.value_help_kind AS ValueHelpKind,
  Field.value_help_view_name AS ValueHelpViewName,
  Field.leading_dimension_view_name AS LeadingDimensionViewName,
  Field.display_option AS DisplayOption,
  Field.code_list_uppercase_only AS CodeListUppercaseOnly,
  concat(Field.created_on, Field.created_at) AS CreatedAt,
  Field.created_by AS CreatedBy,
  concat(Field.last_changed_on, Field.last_changed_at) AS LastChangedAt,
  Field.last_changed_by AS LastChangedBy,
  dats_tims_to_tstmp(Field.last_changed_on, Field.last_changed_at, 'UTC', $session.client, 'NULL') AS LastChangedAtTimestamp,
  Field.associated_business_object AS AssociatedBusinessObject,
  characteristic.characteristic_name AS CharacteristicName,
  characteristic.class_type AS ClassType,
  characteristic.object_type AS ClassificationObjectType,
  Field.data_subject_id_type AS DataSubjectIdType,
  Field.badi_impl_for_data_subject AS BadiImplForDataSubject,
  _AssociatedBO.BusinessObjectName AS AssociatedBODescription,
  Field.semantic_action_name AS SemanticActionName,
  Field.semantic_object_name AS SemanticObjectName,
  Field.enhancement_prefix AS EnhancementPrefix,
  Field.name_prefix AS NamePrefix,
  Field.short_enhancement_prefix AS ShortEnhancementPrefix
FROM cfd_w_rep AS Field
INNER JOIN cfd_w_rep_bus AS businessContext ON /* join condition not captured in parsed metadata */
INNER JOIN tadir ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cfd_w_rep_ch_ref AS characteristic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Cfd_User_Name AS _CreateUser ON _CreateUser.name = Field.created_by  -- association [1]
LEFT OUTER JOIN P_Cfd_User_Name AS _ChangeUser ON _ChangeUser.name = Field.last_changed_by  -- association [1]
LEFT OUTER JOIN P_Cfd_Business_Context AS _BusinessContext ON BusinessContext = _BusinessContext.BusinessContext  -- association [1]
LEFT OUTER JOIN P_Cfd_Field_Type AS _Type ON type = _Type.Code  -- association [1]
LEFT OUTER JOIN p_cfd_ui_text AS _UiTexts ON _UiTexts.ExternalName = ExternalName AND _UiTexts.BusinessContext = BusinessContext  -- association [*]
LEFT OUTER JOIN p_cfd_ui_text AS _UiTextsInOriginalLanguage ON _UiTextsInOriginalLanguage.ExternalName = ExternalName AND _UiTextsInOriginalLanguage.BusinessContext = BusinessContext AND _UiTextsInOriginalLanguage.Language = MasterLanguage AND _UiTextsInOriginalLanguage.ComponentIdentifier = '' AND _UiTextsInOriginalLanguage.EnhancementObjectType = 'DATAELEM'  -- association [1]
LEFT OUTER JOIN P_Cfd_Data_Element_Text AS _DataElementTextFallback ON DataElementName = _DataElementTextFallback.DataElement AND _DataElementTextFallback.MasterLanguage = _DataElementTextFallback.Language  -- association [1]
LEFT OUTER JOIN I_LanguageText AS _MasterLanguageText ON MasterLanguage = _MasterLanguageText.LanguageCode  -- association [*]
LEFT OUTER JOIN P_Cfd_Field_Origin AS _Origin ON Origin = _Origin.Code  -- association [1]
LEFT OUTER JOIN dd04l AS _DataElement ON DataElementName = _DataElement.rollname AND _DataElement.as4local = 'A' AND _DataElement.as4vers = '0000'  -- association [1]
LEFT OUTER JOIN P_CFD_ASSOCIABLE_BO AS _AssociatedBO ON AssociatedBusinessObject = _AssociatedBO.BusinessObjectID  -- association [1]
LEFT OUTER JOIN P_Cfd_Associable_Cds_View AS _AssociatedValueHelp ON ValueHelpViewName = _AssociatedValueHelp.ViewName  -- association [0..1]
LEFT OUTER JOIN P_Cfd_Associable_Cds_View AS _AssociatedLeadingDimension ON LeadingDimensionViewName = _AssociatedLeadingDimension.ViewName  -- association [0..1]
LEFT OUTER JOIN P_CFD_VH_COMPONENT_NAME AS _CdsViewComponentIdentifiers ON ExternalName = _CdsViewComponentIdentifiers.FieldExternalName  -- association [0..*]
LEFT OUTER JOIN P_Cfd_Value_Help_Bindings AS _ValueHelpBindings ON ExternalName = _ValueHelpBindings.ExternalName  -- association [0..*]
;