_COUPONCODEUSAGE

_COUPONCODEUSAGE is an SAP database table in S/4HANA. It contains 6 fields.

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CouponCodeUsageUUID CouponCodeUsageUUID 1
CouponCodeUsageType CouponCodeUsageType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _COUPONCODEUSAGE (
    COUPONCODEUSAGEUUID,
    COUPONCODEUSAGETYPE,
    INTERACTIONCONTACTUUID,
    NUMBEROFREDEMPTIONPERCONTACT,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATETIME,
    PRIMARY KEY (COUPONCODEUSAGEUUID)
);