I_MKT_COUPONCODEUSAGE

CDS View

Marketing: Coupon Code Usage

I_MKT_COUPONCODEUSAGE is a CDS View in S/4HANA. Marketing: Coupon Code Usage. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MKT_CouponCodeUsageTP view from TRANSACTIONAL Marketing: Coupon Code Usage TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY CouponCodeUsageUUID CouponCodeUsageUUID 1
CouponCodeUsageType CouponCodeUsageType 1
CouponCodeUUID CouponCodeUUID 1
CouponUUID CouponUUID 1
InteractionContactUUID InteractionContactUUID 1
NumberOfRedemptionPerContact NumberOfRedemptionPerContact 1
ValidityEndDateTime ValidityEndDateTime 1
ValidityStartDateTime ValidityStartDateTime 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Marketing: Coupon Code Usage
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MKT_COUPONCODEUSAGE (
    COUPONCODEUSAGEUUID,
    COUPONCODEUSAGETYPE,
    COUPONCODEUUID,
    COUPONUUID,
    INTERACTIONCONTACTUUID,
    NUMBEROFREDEMPTIONPERCONTACT,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (COUPONCODEUSAGEUUID)
);