I_MKT_CustomDimension08Text

DDL: I_MKT_CUSTOMDIMENSION08TEXT SQL: IMKT_CSTMDIMN08T Type: view BASIC Package: CUAN_CDS_MRM

Marketing: Custom Dimension 08 - Text

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

Data Sources (2)

SourceAliasJoin Type
cuand_cdim_08dsc cuand_cdim_08dsc from
cuand_cdim_08rt cuand_cdim_08rt inner

Annotations (13)

NameValueLevelField
EndUserText.label Marketing: Custom Dimension 08 - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey MarketingCustomDimension08 view
AbapCatalog.sqlViewName IMKT_CSTMDIMN08T 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_08dsc language Report Text Language
KEY MarketingCustomDimension08
MarketingCustomDimension08Name

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_CustomDimension08Text.
-- 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_CSTMDIMN08T

CREATE VIEW I_MKT_CustomDimension08Text AS
SELECT
  cuand_cdim_08dsc.language AS Language,
  cast(cuand_cdim_08rt.id as cuan_customdimension08 preserving type) AS MarketingCustomDimension08,
  cast(cuand_cdim_08dsc.description as cuan_customdimension08name preserving type) AS MarketingCustomDimension08Name
FROM cuand_cdim_08dsc
INNER JOIN cuand_cdim_08rt ON /* join condition not captured in parsed metadata */
;