A_MKT_MaritalStatusText

DDL: A_MKT_MARITALSTATUSTEXT SQL: AMKTMARITALT Type: view BASIC Package: CUAN_CDS_COMMON
3 Fields 1 Data Sources

Marital Status Text

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

Data Sources (1)

SourceAliasJoin Type
I_MKT_MaritalText I_MKT_MaritalText from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AMKTMARITALT view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Marital Status 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
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Language Language Report Text Language
KEY MaritalStatus MaritalStatus Married
MaritalStatusName MaritalStatusName 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 A_MKT_MaritalStatusText.
-- 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: AMKTMARITALT

CREATE VIEW A_MKT_MaritalStatusText AS
SELECT
  Language,
  MaritalStatus,
  MaritalStatusName
FROM I_MKT_MaritalText
;

Learn More