I_FlxMtPlObjVarDescription

DDL: I_FLXMTPLOBJVARDESCRIPTION SQL: IFMPOVARD Type: view BASIC

Description of Variants

I_FlxMtPlObjVarDescription (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

FlexibleMaterialPlngObjVarDesc · Cross Applications

I_FlxMtPlObjVarDescription is a Basic CDS View (Dimension) that provides data about "Description of Variants" in SAP S/4HANA. It reads from 1 data source (dfs_fmpo_varnt_t) and exposes 5 fields with key field FlxMtPlObjVariantDescUUID.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-DFS-OF-FMP
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction, Association Target for Defining CDS Entities, Data Source for Search
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
dfs_fmpo_varnt_t dfs_fmpo_varnt_t from

Annotations (18)

NameValueLevelField
ObjectModel.sapObjectNodeType.name FlexibleMaterialPlngObjVarDesc view
AbapCatalog.sqlViewName IFMPOVARD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Description of Variants view
VDM.viewType #BASIC view
ObjectModel.representativeKey FlxMtPlObjVariantDescUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY FlxMtPlObjVariantDescUUID flxmtplobjvariantdescuuid UUID for the Variant Description
FlxblMatlPlngObjVariantUUID flxblmatlplngobjvariantuuid Variant UUID
Language language Report Text Language
FlxblMatlPlngObjVariantDesc flxblmatlplngobjvariantdesc Flexible Material Planning Object: Variant Description
FlxblMatlPlngObjectUUID flxblmatlplngobjectuuid Flexible Material Planning Object UUID

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_FlxMtPlObjVarDescription.
-- 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: IFMPOVARD

CREATE VIEW I_FlxMtPlObjVarDescription AS
SELECT
  FlxMtPlObjVariantDescUUID,
  FlxblMatlPlngObjVariantUUID,
  Language,
  FlxblMatlPlngObjVariantDesc,
  FlxblMatlPlngObjectUUID
FROM dfs_fmpo_varnt_t
;