C_MatlDocOvwGenericProd

DDL: C_MATLDOCOVWGENERICPROD SQL: CCPLTCONFMATVH Type: view CONSUMPTION

Help-View Cross Plant Config. Product

C_MatlDocOvwGenericProd is a Consumption CDS View that provides data about "Help-View Cross Plant Config. Product" in SAP S/4HANA. It reads from 1 data source (F_Mmim_Findmatdoch) and exposes 2 fields.

Data Sources (1)

SourceAliasJoin Type
F_Mmim_Findmatdoch F_Mmim_Findmatdoch from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CCPLTCONFMATVH view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Help-View Cross Plant Config. Product view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (2)

KeyFieldSource TableSource FieldDescription
CrossPlantConfigurableProduct _CrossPlantConfigurableProduct Material Vehicle Model
MaterialName

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 C_MatlDocOvwGenericProd.
-- 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: CCPLTCONFMATVH

CREATE VIEW C_MatlDocOvwGenericProd AS
SELECT
  _CrossPlantConfigurableProduct.Material AS CrossPlantConfigurableProduct,
  _CrossPlantConfigurableProduct._Text[1: Language=$session.system_language].MaterialName AS MaterialName
FROM F_Mmim_Findmatdoch
;