I_ConversionFunctionAssignment

DDL: I_CONVERSIONFUNCTIONASSIGNMENT Type: view_entity BASIC

Conversion Function Assignment

I_ConversionFunctionAssignment is a Basic CDS View that provides data about "Conversion Function Assignment" in SAP S/4HANA. It reads from 1 data source (cnvdmcfac) and exposes 13 fields with key field CnvrsnFunctionAssignmentID.

Data Sources (1)

SourceAliasJoin Type
cnvdmcfac cnvdmcfac from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Conversion Function Assignment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CnvrsnFunctionAssignmentID convasguid Assignment ID
CnvrsnFunctionAssignmentType convasstyp Assignment Type
CnvrsnAssgmtEnhancementSpot enhspotname Enh. Spot
CnvrsnAssgmtBusinessAddInName badidef BAdI Definition
ConversionAssignmentClassName badiifname BAdI Interface
ConversionAssignmentMethodName methodname Interface Comp.
ConversionTableSourceName srcname Source Name
ConversionObjectDataSource source ViolationSource
ConversionAssignmentStatus Status of the assignment
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_ConversionFunctionAssignment.
-- 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_ConversionFunctionAssignment AS
SELECT
  convasguid AS CnvrsnFunctionAssignmentID,
  convasstyp AS CnvrsnFunctionAssignmentType,
  enhspotname AS CnvrsnAssgmtEnhancementSpot,
  badidef AS CnvrsnAssgmtBusinessAddInName,
  badiifname AS ConversionAssignmentClassName,
  methodname AS ConversionAssignmentMethodName,
  srcname AS ConversionTableSourceName,
  source AS ConversionObjectDataSource,
  cast(dmrel as boole_d preserving type ) AS ConversionAssignmentStatus,
  createdby AS ConversionObjectCreatedBy,
  createdon AS CnvrsnObjectCreatedOnDateTime,
  changedby AS ConversionObjectChangedBy,
  changedon AS CnvrsnObjLoclLastChgdOnDteTme
FROM cnvdmcfac
;