I_ConversionTableForeignKey

DDL: I_CONVERSIONTABLEFOREIGNKEY Type: view_entity BASIC
18 Fields 1 Data Sources

Conversion Table Foreign Key

I_ConversionTableForeignKey is a Basic CDS View that provides data about "Conversion Table Foreign Key" in SAP S/4HANA. It reads from 1 data source (cnvdmtablefkyc) and exposes 18 fields with key fields ConversionPackage, ConversionObject, ConversionTableAlias, ConversionFieldName.

Data Sources (1)

SourceAliasJoin Type
cnvdmtablefkyc cnvdmtablefkyc from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Conversion Table Foreign Key view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ConversionPackage packid Package
KEY ConversionObject cnvobj Conversion Object
KEY ConversionTableAlias tabalias Table Alias
KEY ConversionFieldName fieldname UI Group FieldName
ConversionParentTableAlias parent_tabalias Parent Tabel Alias
ConversionParentFieldName parent_fieldname Field Name
CnvrsnForeignKeyRelationType fkytype FK Type
ConversionChildFieldOffset chdfld_offset offset
ConversionChildFieldUsedLength chdfld_length Length
ConversionParentFieldOffset prtfld_offset offset
CnvrsnParentFieldUsedLength prtfld_length Length
ConversionFieldLinkingOperator link_operator Linking Operator
ConversionFieldLogicalOperator logical_operator Logical operator
ConversionObjectDataSource source ViolationSource
ConversionObjectCreatedBy createdby User Name
CnvrsnObjectCreatedOnDateTime createdon Time Stamp
ConversionObjectChangedBy changedby User Name
CnvrsnObjLoclLastChgdOnDteTme changedon Time Stamp

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_ConversionTableForeignKey.
-- 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_ConversionTableForeignKey AS
SELECT
  packid AS ConversionPackage,
  cnvobj AS ConversionObject,
  tabalias AS ConversionTableAlias,
  fieldname AS ConversionFieldName,
  parent_tabalias AS ConversionParentTableAlias,
  parent_fieldname AS ConversionParentFieldName,
  fkytype AS CnvrsnForeignKeyRelationType,
  chdfld_offset AS ConversionChildFieldOffset,
  chdfld_length AS ConversionChildFieldUsedLength,
  prtfld_offset AS ConversionParentFieldOffset,
  prtfld_length AS CnvrsnParentFieldUsedLength,
  link_operator AS ConversionFieldLinkingOperator,
  logical_operator AS ConversionFieldLogicalOperator,
  source AS ConversionObjectDataSource,
  createdby AS ConversionObjectCreatedBy,
  createdon AS CnvrsnObjectCreatedOnDateTime,
  changedby AS ConversionObjectChangedBy,
  changedon AS CnvrsnObjLoclLastChgdOnDteTme
FROM cnvdmtablefkyc
;

Learn More