What is A_MKT_MktgLocOriginData in SAP S/4HANA?

A_MKT_MktgLocOriginData is a basic CDS view in SAP S/4HANA. Marketing: Marketing Location Origin API It contains 41 fields.

Which tables does A_MKT_MktgLocOriginData read from?

A_MKT_MktgLocOriginData reads data from: I_MKT_LocationOriginData.

What VDM layer is A_MKT_MktgLocOriginData?

A_MKT_MktgLocOriginData is classified as a Basic (interface) view providing a 1:1 representation of a database table.

A_MKT_MktgLocOriginData

DDL: A_MKT_MKTGLOCORIGINDATA SQL: AMKT_MKTLOCORI Type: view BASIC Package: CUAN_ODATA_API_MKT_LOCATION

41 Fields 1 Data Sources

Marketing: Marketing Location Origin API

A_MKT_MktgLocOriginData is a Basic CDS View that provides data about "Marketing: Marketing Location Origin API" in SAP S/4HANA. It reads from 1 data source (I_MKT_LocationOriginData) and exposes 41 fields with key fields MarketingLocationExternalID, MarketingLocationOrigin. Part of development package CUAN_ODATA_API_MKT_LOCATION.

Data Sources (1)

Source	Alias	Join Type
I_MKT_LocationOriginData	LocationOriginData	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	AMKT_MKTLOCORI	view
EndUserText.label	Marketing: Marketing Location Origin API	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (41)

Key	Field	Source Table	Source Field	Description
KEY	MarketingLocationExternalID	I_MKT_LocationOriginData	MarketingLocationExternalID	Location ID
KEY	MarketingLocationOrigin	I_MKT_LocationOriginData	MarketingLocationOrigin
	MarketingLocOriginDataUUID	I_MKT_LocationOriginData	MarketingLocOriginDataUUID	UUID
	MarketingLocationUUID	I_MKT_LocationOriginData	MarketingLocationUUID
	MarketingLocationType	I_MKT_LocationOriginData	MarketingLocationType	Worklist Type
	MarketingLocationTypeName
	CompanyName	I_MKT_LocationOriginData	CompanyName	Text
	MarketingLocationName	I_MKT_LocationOriginData	MarketingLocationName	Location Name
	Country	I_MKT_LocationOriginData	Country	Venue: Ctry/Reg
	CountryName
	AddressRegion	I_MKT_LocationOriginData	AddressRegion	Region
	RegionName
	CityName	I_MKT_LocationOriginData	CityName	Name
	PostalCode	I_MKT_LocationOriginData	PostalCode	Postal Code
	AddressStreetName	I_MKT_LocationOriginData	AddressStreetName	Street
	AddressHouseNumber	I_MKT_LocationOriginData	AddressHouseNumber	House Number
	Building	I_MKT_LocationOriginData	Building	Building code
	Floor	I_MKT_LocationOriginData	Floor	Floor
	RoomNumber	I_MKT_LocationOriginData	RoomNumber	Room Number
	PhoneNumber	I_MKT_LocationOriginData	PhoneNumber	Telephone no.
	FaxNumber	I_MKT_LocationOriginData	FaxNumber	Fax Number
	EmailAddress	I_MKT_LocationOriginData	EmailAddress	E-Mail Address
	WebsiteURL	I_MKT_LocationOriginData	WebsiteURL	URI
	IsObsolete	I_MKT_LocationOriginData	IsObsolete	Deprecated
	Latitude	I_MKT_LocationOriginData	Latitude	Latitude
	Longitude	I_MKT_LocationOriginData	Longitude	Longitude
	LatitudeUnit	I_MKT_LocationOriginData	LatitudeUnit
	LongitudeUnit	I_MKT_LocationOriginData	LongitudeUnit
	CreationUTCDateTime	I_MKT_LocationOriginData	CreationUTCDateTime	Time Stamp
	CreatedByUser	I_MKT_LocationOriginData	CreatedByUser	User Name
	LastChangeUTCDateTime	I_MKT_LocationOriginData	LastChangeUTCDateTime	Time Stamp
	LastChangeByUser	I_MKT_LocationOriginData	LastChangeByUser	User Name
	MarketingArea	I_MKT_LocationOriginData	MarketingArea
	MarketingAreaName
	ValidityStartDate	I_MKT_LocationOriginData	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_MKT_LocationOriginData	ValidityEndDate	ValidTo
	SpatialReferenceSystem	I_MKT_LocationOriginData	SpatialReferenceSystem	Stability Rule DRP
	MarketingLocationImageURL	I_MKT_LocationOriginData	MarketingLocationImageURL
	MarketingLocationMallName	I_MKT_LocationOriginData	MarketingLocationMallName
	MarketingLocationOccupancyType	I_MKT_LocationOriginData	MarketingLocationOccupancyType
	_MKT_MarketingLocOriginInfo		_MKT_MarketingLocOriginInfo

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_MktgLocOriginData.
-- 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: AMKT_MKTLOCORI

CREATE VIEW A_MKT_MktgLocOriginData AS
SELECT
  LocationOriginData.MarketingLocationExternalID AS MarketingLocationExternalID,
  LocationOriginData.MarketingLocationOrigin AS MarketingLocationOrigin,
  LocationOriginData.MarketingLocOriginDataUUID AS MarketingLocOriginDataUUID,
  LocationOriginData.MarketingLocationUUID AS MarketingLocationUUID,
  LocationOriginData.MarketingLocationType AS MarketingLocationType,
  LocationOriginData._MKT_LocationType._Text[1:Language=$session.system_language].MarketingLocationTypeName AS MarketingLocationTypeName,
  LocationOriginData.CompanyName AS CompanyName,
  LocationOriginData.MarketingLocationName AS MarketingLocationName,
  LocationOriginData.Country AS Country,
  LocationOriginData._MKT_Country._Text[1:Language=$session.system_language].CountryName AS CountryName,
  LocationOriginData.AddressRegion AS AddressRegion,
  LocationOriginData._MKT_Region._RegionText[1:Language=$session.system_language].RegionName AS RegionName,
  LocationOriginData.CityName AS CityName,
  LocationOriginData.PostalCode AS PostalCode,
  LocationOriginData.AddressStreetName AS AddressStreetName,
  LocationOriginData.AddressHouseNumber AS AddressHouseNumber,
  LocationOriginData.Building AS Building,
  LocationOriginData.Floor AS Floor,
  LocationOriginData.RoomNumber AS RoomNumber,
  LocationOriginData.PhoneNumber AS PhoneNumber,
  LocationOriginData.FaxNumber AS FaxNumber,
  LocationOriginData.EmailAddress AS EmailAddress,
  LocationOriginData.WebsiteURL AS WebsiteURL,
  LocationOriginData.IsObsolete AS IsObsolete,
  LocationOriginData.Latitude AS Latitude,
  LocationOriginData.Longitude AS Longitude,
  LocationOriginData.LatitudeUnit AS LatitudeUnit,
  LocationOriginData.LongitudeUnit AS LongitudeUnit,
  LocationOriginData.CreationUTCDateTime AS CreationUTCDateTime,
  LocationOriginData.CreatedByUser AS CreatedByUser,
  LocationOriginData.LastChangeUTCDateTime AS LastChangeUTCDateTime,
  LocationOriginData.LastChangeByUser AS LastChangeByUser,
  LocationOriginData.MarketingArea AS MarketingArea,
  LocationOriginData._MKT_MarketingArea._Text[1: Language=$session.system_language].MarketingAreaName AS MarketingAreaName,
  LocationOriginData.ValidityStartDate AS ValidityStartDate,
  LocationOriginData.ValidityEndDate AS ValidityEndDate,
  LocationOriginData.SpatialReferenceSystem AS SpatialReferenceSystem,
  LocationOriginData.MarketingLocationImageURL AS MarketingLocationImageURL,
  LocationOriginData.MarketingLocationMallName AS MarketingLocationMallName,
  LocationOriginData.MarketingLocationOccupancyType AS MarketingLocationOccupancyType
FROM I_MKT_LocationOriginData AS LocationOriginData
;

Depth:

A_MKT_MktgLocOriginData view

I_MKT_LocationOriginData view