SWXMKTCPG
Marketing Campaign
SWXMKTCPG is an SAP database table in S/4HANA. Marketing Campaign. It contains 10 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Swx_Sddl_Mktcpg | view | from | DDL for Marketing Campaing Scenario |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | instid | sibfinstid | Instance ID | |||
| name | swx_mc_name | Campaign Name | ||||
| target_group_size | swx_mc_tgt_grp_size | Target Group Size | ||||
| region | swx_mc_region | Campaign Region | ||||
| status | swx_procst | Editing State | ||||
| createdate | swx_date | Date | ||||
| createdby | swx_ordby | Issuer | ||||
| approvdate | swx_date | Date | ||||
| approvby | swx_approv | Approver |
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 Campaign
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWXMKTCPG (
MANDT, -- Client [mandt]
INSTID, -- Instance ID [sibfinstid]
NAME, -- Campaign Name [swx_mc_name]
TARGET_GROUP_SIZE, -- Target Group Size [swx_mc_tgt_grp_size]
REGION, -- Campaign Region [swx_mc_region]
STATUS, -- Editing State [swx_procst]
CREATEDATE, -- Date [swx_date]
CREATEDBY, -- Issuer [swx_ordby]
APPROVDATE, -- Date [swx_date]
APPROVBY, -- Approver [swx_approv]
PRIMARY KEY (MANDT, INSTID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA