E_MKT_LOCATION

DDL: E_MKT_LOCATION SQL: EMKT_LOCATION Type: view EXTENSION Package: CUAN_CDS_LOC

Marketing Location

E_MKT_LOCATION is a Extension CDS View that provides data about "Marketing Location" in SAP S/4HANA. It reads from 1 data source (cuand_loc_root) and exposes 1 field with key field MarketingLocation. Part of development package CUAN_CDS_LOC.

Data Sources (1)

SourceAliasJoin Type
cuand_loc_root Persistence from

Annotations (7)

NameValueLevelField
VDM.viewType #EXTENSION view
AbapCatalog.sqlViewName EMKT_LOCATION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY MarketingLocation cuand_loc_root db_key UUID

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 E_MKT_LOCATION.
-- 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: EMKT_LOCATION

CREATE VIEW E_MKT_LOCATION AS
SELECT
  Persistence.db_key AS MarketingLocation
FROM cuand_loc_root AS Persistence
;