I_CmmdtyPrcgFmlaAssyFldMapping

DDL: I_CMMDTYPRCGFMLAASSYFLDMAPPING Type: view_entity BASIC Package: LOG_CMM_PRC_CUSTOMIZING_VDM
4 Fields 1 Data Sources

Formula Assembly Field Mapping

I_CmmdtyPrcgFmlaAssyFldMapping is a Basic CDS View that provides data about "Formula Assembly Field Mapping" in SAP S/4HANA. It reads from 1 data source (cpec_fa_fldmap) and exposes 4 fields with key fields CmmdtyPrcgFmlaAssyApplication, FmlaAssyMappingStructureName, FmlaAssyMappingComponentName, FmlaAssemblyMappingFieldName. Part of development package LOG_CMM_PRC_CUSTOMIZING_VDM.

Data Sources (1)

SourceAliasJoin Type
cpec_fa_fldmap cpec_fa_fldmap from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Formula Assembly Field Mapping view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyPrcgFmlaAssyApplication kappl Application
KEY FmlaAssyMappingStructureName structure Structure ID
KEY FmlaAssyMappingComponentName fieldname UI Group FieldName
KEY FmlaAssemblyMappingFieldName fa_fieldname Field Name

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_CmmdtyPrcgFmlaAssyFldMapping.
-- 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_CmmdtyPrcgFmlaAssyFldMapping AS
SELECT
  kappl AS CmmdtyPrcgFmlaAssyApplication,
  structure AS FmlaAssyMappingStructureName,
  fieldname AS FmlaAssyMappingComponentName,
  fa_fieldname AS FmlaAssemblyMappingFieldName
FROM cpec_fa_fldmap
;

Learn More