I_MKT_CouponCodeUsageWithOffer

DDL: I_MKT_COUPONCODEUSAGEWITHOFFER SQL: IMKTCPNCDUSEWOFR Type: view COMPOSITE Package: CUAN_CDS_COUPON
29 Fields 1 Data Sources 2 Associations

Marketing: Coupon Code Usage with Offer

I_MKT_CouponCodeUsageWithOffer is a Composite CDS View that provides data about "Marketing: Coupon Code Usage with Offer" in SAP S/4HANA. It reads from 1 data source (I_MKT_CouponCode) and exposes 29 fields with key fields CouponCodeUsageUUID, CouponCodeUUID. It has 2 associations to related views. Part of development package CUAN_CDS_COUPON.

Data Sources (1)

SourceAliasJoin Type
I_MKT_CouponCode CouponCode from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_MKT_CouponCodeUsage _CouponCodeUsage $projection.CouponCodeUUID = _CouponCodeUsage.CouponCodeUUID
[1..1] E_MKT_CouponCode _Extension $projection.CouponCodeUUID = _Extension.CouponCodeUUID

Annotations (8)

NameValueLevelField
EndUserText.label Marketing: Coupon Code Usage with Offer view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMKTCPNCDUSEWOFR view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #COMPOSITE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CouponCodeUsageUUID _CouponCodeUsage CouponCodeUsageUUID
KEY CouponCodeUUID I_MKT_CouponCode CouponCodeUUID
CouponUUID I_MKT_CouponCode CouponUUID
CouponCodeUsageType _CouponCodeUsage CouponCodeUsageType
InteractionContactUUID _CouponCodeUsage InteractionContactUUID NodeID
NumberOfRedemptionPerContact _CouponCodeUsage NumberOfRedemptionPerContact
ValidityStartDateTime _CouponCodeUsage ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime _CouponCodeUsage ValidityEndDateTime Valid To Timestamp
CouponCode I_MKT_CouponCode CouponCode
CouponCodeSerialNumber I_MKT_CouponCode CouponCodeSerialNumber
EANCodeImageURL I_MKT_CouponCode EANCodeImageURL
QRCodeImageURL I_MKT_CouponCode QRCodeImageURL
Coupon
CouponCanExceedOfferPeriod
CouponCodeValidityDuration
CouponCodeValidityDurationUnit
CpnCodeValidityStartDelay
CpnCodeValidityStartDelayUnit
CouponType
CouponContactRelationshipType
TotalNumberOfRedemption
TotalNumberOfRdmptnPerContact
MarketingOffer
MarketingOfferUUID
OfferStartDateTime
OfferEndDateTime
OfferStatus
_OfferStatus
_CouponCodeUsage _CouponCodeUsage

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_CouponCodeUsageWithOffer.
-- 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: IMKTCPNCDUSEWOFR

CREATE VIEW I_MKT_CouponCodeUsageWithOffer AS
SELECT
  _CouponCodeUsage.CouponCodeUsageUUID AS CouponCodeUsageUUID,
  CouponCode.CouponCodeUUID AS CouponCodeUUID,
  CouponCode.CouponUUID AS CouponUUID,
  _CouponCodeUsage.CouponCodeUsageType AS CouponCodeUsageType,
  _CouponCodeUsage.InteractionContactUUID AS InteractionContactUUID,
  _CouponCodeUsage.NumberOfRedemptionPerContact AS NumberOfRedemptionPerContact,
  _CouponCodeUsage.ValidityStartDateTime AS ValidityStartDateTime,
  _CouponCodeUsage.ValidityEndDateTime AS ValidityEndDateTime,
  CouponCode.CouponCode AS CouponCode,
  CouponCode.CouponCodeSerialNumber AS CouponCodeSerialNumber,
  CouponCode.EANCodeImageURL AS EANCodeImageURL,
  CouponCode.QRCodeImageURL AS QRCodeImageURL,
  CouponCode._Coupon.Coupon AS Coupon,
  CouponCode._Coupon.CouponCanExceedOfferPeriod AS CouponCanExceedOfferPeriod,
  CouponCode._Coupon.CouponCodeValidityDuration AS CouponCodeValidityDuration,
  CouponCode._Coupon.CouponCodeValidityDurationUnit AS CouponCodeValidityDurationUnit,
  CouponCode._Coupon.CpnCodeValidityStartDelay AS CpnCodeValidityStartDelay,
  CouponCode._Coupon.CpnCodeValidityStartDelayUnit AS CpnCodeValidityStartDelayUnit,
  CouponCode._Coupon.CouponType AS CouponType,
  CouponCode._Coupon.CouponContactRelationshipType AS CouponContactRelationshipType,
  CouponCode._Coupon.TotalNumberOfRedemption AS TotalNumberOfRedemption,
  CouponCode._Coupon.TotalNumberOfRdmptnPerContact AS TotalNumberOfRdmptnPerContact,
  CouponCode._Coupon._Offer.MarketingOffer AS MarketingOffer,
  CouponCode._Coupon._Offer.MarketingOfferUUID AS MarketingOfferUUID,
  CouponCode._Coupon._Offer.OfferStartDateTime AS OfferStartDateTime,
  CouponCode._Coupon._Offer.OfferEndDateTime AS OfferEndDateTime,
  CouponCode._Coupon._Offer.OfferStatus AS OfferStatus,
  CouponCode._Coupon._Offer._OfferStatus AS _OfferStatus
FROM I_MKT_CouponCode AS CouponCode
LEFT OUTER JOIN I_MKT_CouponCodeUsage AS _CouponCodeUsage ON CouponCodeUUID = _CouponCodeUsage.CouponCodeUUID  -- association [1..*]
LEFT OUTER JOIN E_MKT_CouponCode AS _Extension ON CouponCodeUUID = _Extension.CouponCodeUUID  -- association [1..1]
;

Learn More