I_MKT_MaritalText

DDL: I_MKT_MARITALTEXT SQL: IMKT_MART Type: view BASIC Package: CUAN_CDS_COMMON
3 Fields 1 Data Sources

Marketing: Marital - Text

I_MKT_MaritalText is a Basic CDS View that provides data about "Marketing: Marital - Text" in SAP S/4HANA. It reads from 1 data source (tb027t) and exposes 3 fields with key fields Language, MaritalStatus. Part of development package CUAN_CDS_COMMON.

Data Sources (1)

SourceAliasJoin Type
tb027t tb027t from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMKT_MART view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Marketing: Marital - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ObjectModel.representativeKey MaritalStatus view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language tb027t spras Off. Language
KEY MaritalStatus tb027t marst Married
MaritalStatusName tb027t bez20 Short 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 I_MKT_MaritalText.
-- 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_MART

CREATE VIEW I_MKT_MaritalText AS
SELECT
  tb027t.spras AS Language,
  tb027t.marst AS MaritalStatus,
  tb027t.bez20 AS MaritalStatusName
FROM tb027t
;

Learn More