I_MKT_OfferContentWithoutURL

DDL: I_MKT_OFFERCONTENTWITHOUTURL SQL: IMKTOFFRCNTNTWO Type: view BASIC Package: CUAN_CDS_OFFER
19 Fields 1 Data Sources

Marketing: Offer Content Without URL Fields

I_MKT_OfferContentWithoutURL is a Basic CDS View (Dimension) that provides data about "Marketing: Offer Content Without URL Fields" in SAP S/4HANA. It reads from 1 data source (I_MKT_OfferContent) and exposes 19 fields with key field MarketingOfferContentUUID. Part of development package CUAN_CDS_OFFER.

Data Sources (1)

SourceAliasJoin Type
I_MKT_OfferContent OfferContent from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMKTOFFRCNTNTWO view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Marketing: Offer Content Without URL Fields view
ObjectModel.representativeKey MarketingOfferContentUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
Metadata.allowExtensions true view
VDM.viewType #BASIC view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MarketingOfferContentUUID MarketingOfferContentUUID UUID
MarketingOfferUUID MarketingOfferUUID UUID
OfferContentSourceURLDesc OfferContentSourceURLDesc
OfferContentTargetURLDesc OfferContentTargetURLDesc
LanguageISOCode LanguageISOCode Language ISO Code
CommunicationMedium CommunicationMedium
OfferContentType OfferContentType
OfferContentPosition OfferContentPosition
MarketingOfferContent MarketingOfferContent
MarketingArea MarketingArea
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_Language _Language
_CommunicationMedium _CommunicationMedium
_OfferContentType _OfferContentType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_OfferContentWithoutURL.
-- 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: IMKTOFFRCNTNTWO

CREATE VIEW I_MKT_OfferContentWithoutURL AS
SELECT
  MarketingOfferContentUUID,
  MarketingOfferUUID,
  OfferContentSourceURLDesc,
  OfferContentTargetURLDesc,
  LanguageISOCode,
  CommunicationMedium,
  OfferContentType,
  OfferContentPosition,
  MarketingOfferContent,
  MarketingArea,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_MKT_OfferContent AS OfferContent
;

Learn More