CUAND_CPN_CODE

Transparent Table Application Table
7 Fields 4 CDS Views

Coupon Codes

CUAND_CPN_CODE is an SAP database table in S/4HANA. Coupon Codes. It contains 7 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
CUAN_OFFER_GET_CODES view left_outer Read all coupon codes for offers
E_MKT_CouponCode view from EXTENSION Marketing: Coupon Code Extension
I_MKT_CouponCode view from BASIC Marketing: Coupon Code
P_MKT_Coupon view left_outer BASIC Marketing: Private Coupon Calculations

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY sapclient mandt Client
KEY couponcodeuuid cuan_cpn_code_uuid
couponuuid cuan_cpn_coupon_uuid
couponcode cuan_cpn_code
eancodeimageurl cuan_cpn_ean_image_url
qrcodeimageurl cuan_cpn_qrc_image_url
couponcodeserialnumber cuan_cpn_code_serial_number

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 Codes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CUAND_CPN_CODE (
    SAPCLIENT,               -- Client [mandt]
    COUPONCODEUUID,          -- cuan_cpn_code_uuid
    COUPONUUID,              -- cuan_cpn_coupon_uuid
    COUPONCODE,              -- cuan_cpn_code
    EANCODEIMAGEURL,         -- cuan_cpn_ean_image_url
    QRCODEIMAGEURL,          -- cuan_cpn_qrc_image_url
    COUPONCODESERIALNUMBER,  -- cuan_cpn_code_serial_number
    PRIMARY KEY (SAPCLIENT, COUPONCODEUUID)
);

Learn More