C_ProductPlantTextInfo

DDL: C_PRODUCTPLANTTEXTINFO SQL: CPRODPLNTTXTIF Type: view CONSUMPTION
5 Fields 1 Data Sources

Material Notes in DDMRP

C_ProductPlantTextInfo is a Consumption CDS View that provides data about "Material Notes in DDMRP" in SAP S/4HANA. It reads from 1 data source (I_Productplanttext) and exposes 5 fields with key fields Product, Plant, Language.

Data Sources (1)

SourceAliasJoin Type
I_Productplanttext _text from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CPRODPLNTTXTIF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Material Notes in DDMRP view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY Language
LongTextID LongTextID Text ID
LongText LongText Text 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 C_ProductPlantTextInfo.
-- 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: CPRODPLNTTXTIF

CREATE VIEW C_ProductPlantTextInfo AS
SELECT
  Product,
  Plant,
  upper(Language) AS Language,
  LongTextID,
  LongText
FROM I_Productplanttext AS _text
;

Learn More