I_TDAFieldMappingContainer

DDL: I_TDAFIELDMAPPINGCONTAINER Type: view_entity COMPOSITE Package: FRM_S4C_TDC

Field mapping for repository

I_TDAFieldMappingContainer is a Composite CDS View that provides data about "Field mapping for repository" in SAP S/4HANA. It reads from 4 data sources (I_TDAContainerField, I_TDACustomField, I_TDAContainerField, I_TDACustomField) and exposes 45 fields with key field TDATemplateMappingUUID. It is exposed through 2 OData services (ASQL_F1709, ASQL_F5404). Part of development package FRM_S4C_TDC.

Data Sources (4)

SourceAliasJoin Type
I_TDAContainerField _TdcField inner
I_TDACustomField _TdcField inner
I_TDAContainerField _TdcField inner
I_TDACustomField _TdcField inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Field mapping for repository view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F1709 ASQL_F1709 C2 NOT_RELEASED
ASQL_F5404 ASQL_F5404 C2 NOT_RELEASED

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY TDATemplateMappingUUID TContRepo tdc_mapid TDC Mapping GUID
TDACreateUUID TContRepo tdc_id TDC container GUID
TDAFieldUUID TContRepo field_id Field name
TDAContainerFieldAliasName TContRepo alias_name Short Description
TDAContainerFieldFlagValue TContRepo field_rename_flag field rename flag
TDAContainerFieldOriginalName TContRepo original_name Short Description
TDAFieldDDICName I_TDACustomField TDAFieldDDICName Field name
TDAFieldLabelText I_TDACustomField TDAFieldLabelText Short Description
TDAFieldCategory I_TDACustomField TDAFieldCategory Field category
TDAFieldDataType I_TDACustomField TDAFieldDataType Fields data type
TDAFieldLengthValue I_TDACustomField TDAFieldLengthValue Text Length
tdc_mapidasTDATemplateMappingUUID
TDACreateUUID CcontRepo tdc_id TDC container GUID
TDAFieldUUID CcontRepo field_id Field name
TDAContainerFieldAliasName CcontRepo alias_name Short Description
TDAContainerFieldFlagValue CcontRepo field_rename_flag field rename flag
TDAContainerFieldOriginalName CcontRepo original_name Short Description
TDAFieldDDICName I_TDACustomField TDAFieldDDICName Field name
TDAFieldLabelText I_TDACustomField TDAFieldLabelText Short Description
TDAFieldCategory I_TDACustomField TDAFieldCategory Field category
TDAFieldDataType I_TDACustomField TDAFieldDataType Fields data type
TDAFieldLengthValue I_TDACustomField TDAFieldLengthValue Text Length
tdc_mapidasTDATemplateMappingUUID
TDACreateUUID ScontRepo tdc_id TDC container GUID
TDAFieldUUID ScontRepo field_id Field name
TDAContainerFieldAliasName ScontRepo alias_name Short Description
TDAContainerFieldFlagValue ScontRepo field_rename_flag field rename flag
TDAContainerFieldOriginalName ScontRepo original_name Short Description
TDAFieldDDICName I_TDACustomField TDAFieldDDICName Field name
TDAFieldLabelText I_TDACustomField TDAFieldLabelText Short Description
TDAFieldCategory I_TDACustomField TDAFieldCategory Field category
TDAFieldDataType I_TDACustomField TDAFieldDataType Fields data type
TDAFieldLengthValue I_TDACustomField TDAFieldLengthValue Text Length
tdc_mapidasTDATemplateMappingUUID
TDACreateUUID ScontRepo tdc_id TDC container GUID
TDAFieldUUID ScontRepo field_id Field name
TDAContainerFieldAliasName ScontRepo alias_name Short Description
TDAContainerFieldFlagValue ScontRepo field_rename_flag field rename flag
TDAContainerFieldOriginalName ScontRepo original_name Short Description
TDAFieldDDICName I_TDACustomField TDAFieldDDICName Field name
TDAFieldLabelText I_TDACustomField TDAFieldLabelText Short Description
TDAFieldCategory I_TDACustomField TDAFieldCategory Field category
TDAFieldDataType I_TDACustomField TDAFieldDataType Fields data type
TDAFieldLengthValue I_TDACustomField TDAFieldLengthValue Text Length
TDAFieldDecimalPlaceValue I_TDACustomField TDAFieldDecimalPlaceValue decimal place

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_TDAFieldMappingContainer.
-- 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_TDAFieldMappingContainer AS
SELECT
  TContRepo.tdc_mapid AS TDATemplateMappingUUID,
  TContRepo.tdc_id AS TDACreateUUID,
  TContRepo.field_id AS TDAFieldUUID,
  TContRepo.alias_name AS TDAContainerFieldAliasName,
  TContRepo.field_rename_flag AS TDAContainerFieldFlagValue,
  TContRepo.original_name AS TDAContainerFieldOriginalName,
  _TdcField.TDAFieldDDICName AS TDAFieldDDICName,
  _TdcField.TDAFieldLabelText AS TDAFieldLabelText,
  _TdcField.TDAFieldCategory AS TDAFieldCategory,
  _TdcField.TDAFieldDataType AS TDAFieldDataType,
  _TdcField.TDAFieldLengthValue AS TDAFieldLengthValue,
  _TdcField.TDAFieldDecimalPlaceValue AS tdc_mapidasTDATemplateMappingUUID,
  _TdcField.TDAFieldDecimalPlaceValue AS TDAFieldDecimalPlaceValue
INNER JOIN I_TDAContainerField AS _TdcField ON /* join condition not captured in parsed metadata */
INNER JOIN I_TDACustomField AS _TdcField ON /* join condition not captured in parsed metadata */
;