CUAND_CPN_USAGE

Transparent Table Application Table
9 Fields 3 CDS Views

Coupon Code Usages

CUAND_CPN_USAGE is an SAP database table in S/4HANA. Coupon Code Usages. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
CUAN_OFFER_GET_CODES view left_outer Read all coupon codes for offers
I_MKT_CouponCodeUsage view from BASIC Marketing: Coupon Code Usage
P_MKT_Coupon view left_outer BASIC Marketing: Private Coupon Calculations

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient mandt Client
KEY couponcodeusageuuid cuan_cpn_code_usage_uuid
couponcodeuuid cuan_cpn_code_uuid
couponuuid cuan_cpn_coupon_uuid
interactioncontactuuid /bobf/conf_key NodeID
couponcodeusagetype cuan_cpn_code_usage_id
validitystartdatetime cuan_cpn_code_validty_start
validityenddatetime cuan_cpn_code_validty_end
numberofredemptionpercontact cuan_cpn_redem_contact

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.

-- Coupon Code Usages
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAND_CPN_USAGE (
    SAPCLIENT,                     -- Client [mandt]
    COUPONCODEUSAGEUUID,           -- cuan_cpn_code_usage_uuid
    COUPONCODEUUID,                -- cuan_cpn_code_uuid
    COUPONUUID,                    -- cuan_cpn_coupon_uuid
    INTERACTIONCONTACTUUID,        -- NodeID [/bobf/conf_key]
    COUPONCODEUSAGETYPE,           -- cuan_cpn_code_usage_id
    VALIDITYSTARTDATETIME,         -- cuan_cpn_code_validty_start
    VALIDITYENDDATETIME,           -- cuan_cpn_code_validty_end
    NUMBEROFREDEMPTIONPERCONTACT,  -- cuan_cpn_redem_contact
    PRIMARY KEY (SAPCLIENT, COUPONCODEUSAGEUUID)
);

Learn More