I_MKT_CustomDimension09Text

DDL: I_MKT_CUSTOMDIMENSION09TEXT SQL: IMKT_CSTMDIMN09T Type: view BASIC Package: CUAN_CDS_MRM

Marketing: Custom Dimension 09 - Text

I_MKT_CustomDimension09Text is a Basic CDS View that provides data about "Marketing: Custom Dimension 09 - Text" in SAP S/4HANA. It reads from 2 data sources (cuand_cdim_09dsc, cuand_cdim_09rt) and exposes 3 fields with key fields Language, MarketingCustomDimension09. Part of development package CUAN_CDS_MRM.

Data Sources (2)

SourceAliasJoin Type
cuand_cdim_09dsc cuand_cdim_09dsc from
cuand_cdim_09rt cuand_cdim_09rt inner

Annotations (13)

NameValueLevelField
EndUserText.label Marketing: Custom Dimension 09 - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey MarketingCustomDimension09 view
AbapCatalog.sqlViewName IMKT_CSTMDIMN09T view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
Metadata.ignorePropagatedAnnotations true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language cuand_cdim_09dsc language Report Text Language
KEY MarketingCustomDimension09
MarketingCustomDimension09Name

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_MKT_CustomDimension09Text.
-- 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: IMKT_CSTMDIMN09T

CREATE VIEW I_MKT_CustomDimension09Text AS
SELECT
  cuand_cdim_09dsc.language AS Language,
  cast(cuand_cdim_09rt.id as cuan_customdimension09 preserving type) AS MarketingCustomDimension09,
  cast(cuand_cdim_09dsc.description as cuan_customdimension09name preserving type) AS MarketingCustomDimension09Name
FROM cuand_cdim_09dsc
INNER JOIN cuand_cdim_09rt ON /* join condition not captured in parsed metadata */
;