SAP ABAP Table SMOPCCAMPN (Campaign)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ SMO3 (Package) Consolidated Database
Basic Data
Table Category TRANSP    Transparent table 
Transparent table SMOPCCAMPN   Table Relationship Diagram
Short Description Campaign    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client *
2 SFAPCCAMPN SMO_SFACPN SMO_GUID CHAR 32   0   SFA KEY of the Campaign  
3 SFAPCPROMO SMO_SFAPMO SMO_GUID CHAR 32   0   SFA Key of the Promotion  
4 SOURCE SMO_SOURCE SMO_SOURCE CHAR 3   0   Source of an object  
5 DATAB SMO3DATAB DATUM DATS 8   0   Valid-from date  
6 DATBI SMO3DATBI DATUM DATS 8   0   Valid to date  
7 CAMTYP SMO_CAMTYP SMO_TXT4 CHAR 4   0   Campaign Type  
8 CAMNUM SMO_CAMNUM SMO_TXT24 CHAR 24   0   Number of the Campaign  
9 EXTCAMP SMO_EXTCAM SMO_LOGICL CHAR 1   0   External Campaign (initiated in other system)  
10 VISIBLE SMO_VISIBL SMO_TEXT1 CHAR 1   0   Visible  
11 PARTNUM SMO_PARTNO INT4 INT4 10   0   Number of participants  
12 PROGRM SMO_PROGRA SMO_TXT4 CHAR 4   0   Program of event/campaign  
13 OWNER SMO_COWNER SMO_GUID CHAR 32   0   Key of the initiator  
14 CABUDGT SMO_CABUDG SMONUM15_2 DEC 15   2   Budget  
15 KVCURR1 SMO3WAERS WAERS CUKY 5   0   Currency key *
16 CACOSTS SMO_CACOST SMONUM15_2 DEC 15   2   Costs  
17 KVCURR2 SMO3WAERS WAERS CUKY 5   0   Currency key *
18 COSDAT SMO_COSDAT SMO_DATE DATS 8   0   Date of costs  
19 PCPROG SMO_PCPROG SMO_NUM3 DEC 3   0   Percentual Stats of the campaign  
20 MDOCDIR SMO_DOCDIR SMO_TXT100 CHAR 100   0   Mail shot Document  
21 MDSDIR SMO_MDSDIR SMO_TXT100 CHAR 100   0   Mail short data source Directory  
22 VBKA_DEF SMO_VBKDEF SMO_LOGICL CHAR 1   0   Flag for assigned activity defined  
23 VBKA_GEN SMO_VBKGEN SMO_TEXT1 CHAR 1   0   Flag for activity generation  
24 OBJT_DEF SMO_OBJDEF SMO_TEXT1 CHAR 1   0   Flag for assigned object defined  
25 OBJT_GEN SMO_OBJGEN SMO_TEXT1 CHAR 1   0   Flag for assigned oppurtunity defined  
26 DOCF_DEF SMO_DOCDEF SMO_TEXT1 CHAR 1   0   Flag for assigned document defined  
27 DOCF_GEN SMO_DOCGEN SMO_TEXT1 CHAR 1   0   Flag for assigned document generated  
28 CAMAT_DEF SMO_CAMDEF SMO_TEXT1 CHAR 1   0   Flag for campaign attributes defined(for mass update)  
29 CAMAT_GEN SMO_CAMGEN SMO_TEXT1 CHAR 1   0   Flag: campaign attributes Generated  
30 KLAH_DEF SMO_KLADEF SMO_TEXT1 CHAR 1   0   Flag for characteristics is defined and assigned  
31 CSTAT SMO_CSTAT SMO_CHOI5 CHAR 5   0   Campaign Status  
32 CPRIO SMO_CPRIO SMO_CHOI4 CHAR 4   0   Priority  
33 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
34 KVCAMCH1 SMO_CAMCH1 SMO_CHOI4 CHAR 4   0   Campaign Choice 1  
35 KVCAMCH2 SMO_CAMCH2 SMO_CHOI4 CHAR 4   0   Campaign choice 2  
36 KVCAMCH3 SMO_CAMCH3 SMO_CHOI4 CHAR 4   0   Campaign Choice 3  
37 FLAG1 SMO_FLAG1 SMO_TEXT1 CHAR 1   0   Flag  
38 NON_GUID SMO_NGUID SMO_NGUID DEC 1   0   Not Guided Record  
39 .INCLUDE       0   0   Record Modification Fields for Mobile Sales/Service  
40 ERFASS SMO_CREATE SMO_DATE DATS 8   0   Date of Creation.  
41 GEAEND SMO_MODIFY SMO_DATE DATS 8   0   Date last Modified  
42 BEARB SMO_BEARB SMO_BEARB CHAR 15   0   Record Edited by User Name  
43 .INCLUDE       0   0   Communication Fields for Mobile Sales/Service  
44 TR_USER SMO_TR_USR SMO_TR_USR CHAR 32   0   Transaction User  
45 TR_ID SMO_TR_ID SMO_TR_ID CHAR 32   0   Transaction Identifier  
46 TR_STATUS SMO_TR_STS SMO_TR_STS CHAR 4   0   Status of Transaction  
47 TIMESTAMP TIMESTAMP TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
48 DELETED SMO_DELETD SMO_DELETD CHAR 1   0   Mobile Sales Deleted  
49 TR_ROOTID SMO_RTGUID SMO_GUID CHAR 32   0   Identifier of BDoc Root object  
50 IMAGELEN SMO_IMAGLG SMO_IMAGLG INT2 5   0   Size of the Image to be stored  
51 TEXTX SMO_LNGTXT SMO_LNGTXT CHAR 34   0   Attachment Pointer (long text data)  
52 SMOPCCAMP2 SMO_SFACPN SMO_GUID CHAR 32   0   SFA KEY of the Campaign  
53 CHANNEL SMO_TEXT4 SMO_TXT4 CHAR 4   0   Text with length 4  
54 MILESTONE SMO_MILES SMO_TEXT1 CHAR 1   0   Campaign Milestone  
55 CONSTTYPE SMO_CONTY SMO_TEXT1 CHAR 1   0   campaign constraint type  
56 CONSTTIME SMO_CONTI SMO_DATE DATS 8   0   campaign constraint time  
57 CRMTYPE SMO_CRMTYP SMO_TEXT1 CHAR 1   0   Marketingplan/Task Flag  
58 DATAB2 SMO3DATAB DATUM DATS 8   0   Valid-from date  
59 DATBI2 SMO3DATBI DATUM DATS 8   0   Valid to date  
60 DATAB3 SMO3DATAB DATUM DATS 8   0   Valid-from date  
61 DATBI3 SMO3DATBI DATUM DATS 8   0   Valid to date  
62 DATAB4 SMO3DATAB DATUM DATS 8   0   Valid-from date  
63 DATBI4 SMO3DATBI DATUM DATS 8   0   Valid to date  
64 DATAB5 SMO3DATAB DATUM DATS 8   0   Valid-from date  
65 DATBI5 SMO3DATBI DATUM DATS 8   0   Valid to date  
66 NOTDEL SMO_NDEL SMO_TEXT1 CHAR 1   0   Flag if it is allowed to delete a campaign  
67 NOTNEW SMO_NNEW SMO_TEXT1 CHAR 1   0   Flag if it is allowed to add childs campaigns  
68 OBJECTIVE SMO_OBJ SMO_TXT4 CHAR 4   0   campaign objective  
69 TACTICS SMO_TAC SMO_TXT4 CHAR 4   0   campaign tactics  
70 AUTHGRP SMO_AUT SMO_TXT4 CHAR 4   0   campaign authorization group  
71 DATAB6 SMO3DATAB DATUM DATS 8   0   Valid-from date  
72 DATBI6 SMO3DATBI DATUM DATS 8   0   Valid to date  
73 DATAB7 SMO3DATAB DATUM DATS 8   0   Valid-from date  
74 DATBI7 SMO3DATBI DATUM DATS 8   0   Valid to date  
75 SFAPCCAMP3 SMO_SFACPN SMO_GUID CHAR 32   0   SFA KEY of the Campaign  
76 SFAPLANCUST SMO_PLANCUST SMO_GUID CHAR 32   0   Guid of Business Partner or Group Hierarchy node  
77 CUSTTYPE SMO_CUSTTYPE SMO_TEXT2 CHAR 2   0   Type of planning customer for Trade Promotion  
78 PLANGRP SMO_PLANGRP SMO_CHAR4 CHAR 4   0   Planning Profile Group  
79 BPATTYPE SMO_DEF_BPAT_TYPE SMO_DEF_BPAT_TYPE CHAR 3   0   Type of Buying Pattern  
80 STSMA SMO_STSMA SMO_TXT8 CHAR 8   0   Status profile  
81 SFATERR SMO_SFATR SMO_GUID CHAR 32   0   SFA Key of Territories  
82 TERRID NTERRID CHAR_30 CHAR 30   0   Territory ID 30 Character length  
83 CPTTYPE SMO_CPTTYPE SMO_TEXT2 CHAR 2   0   Response Type  
84 IDENT WFCID WFCID CHAR 2   0   Factory Calendar *
85 SFAPCCAMP4 SMO_SFACPN SMO_GUID CHAR 32   0   SFA KEY of the Campaign  
86 ACTSTTIME SMO_ACTSTTIME SMO_CAMTIME TIMS 6   0   Actual Date - Start Time  
87 ACTENDTIME SMO_ACTENDTIME SMO_CAMTIME TIMS 6   0   Actual Date - End Time  
88 PLANSTTIME SMO_PLNSTTIME SMO_CAMTIME TIMS 6   0   Planned Date - Start Time  
89 PLANENDTIME SMO_PLNENDTIME SMO_CAMTIME TIMS 6   0   Planned Date - End Time  
90 DATE1STTIME SMO_DT1STTIME SMO_CAMTIME TIMS 6   0   Additional Date 1 - Start Time  
91 DATE1ENDTIME SMO_DT1ENDTIME SMO_CAMTIME TIMS 6   0   Additional Date 1 - End Time  
92 DATE2STTIME SMO_DT2STTIME SMO_CAMTIME TIMS 6   0   Additional Date 2 - Start Time  
93 DATE2ENDTIME SMO_DT2ENDTIME SMO_CAMTIME TIMS 6   0   Additional Date 2 - End Time  
94 DATE3STTIME SMO_DT3STTIME SMO_CAMTIME TIMS 6   0   Additional Date 3 - Start Time  
95 DATE3ENDTIME SMO_DT3ENDTIME SMO_CAMTIME TIMS 6   0   Additional Date 3 - End Time  
96 DATE4STTIME SMO_DT4STTIME SMO_CAMTIME TIMS 6   0   Additional Date 4 - Start Time  
97 DATE4ENDTIME SMO_DT4ENDTIME SMO_CAMTIME TIMS 6   0   Additional Date 4 - End Time  
98 DATE5STTIME SMO_DT5STTIME SMO_CAMTIME TIMS 6   0   Additional Date 5 - Start Time  
99 DATE5ENDTIME SMO_DT5ENDTIME SMO_CAMTIME TIMS 6   0   Additional Date 5 - End Time  
100 MKTORG SMO_MKTORG CHAR14 CHAR 14   0   Marketing Organisation  
101 .INCLUDE       0   0    
102 .INCLUDE       0   0    
103 EXCLFLAG SMO_EXCLFLAG SMO_TEXT1 CHAR 1   0   Exclution Flag for Campaign products  
104 PROD_PL_BASIS SMO_PLBAS SMO_TXT3 CHAR 3   0   Product Planning Basis  
105 NO_UPLIFT_IND UPLIFT_IND UPLIFTIND CHAR 1   0   Significant uplift indicator  
106 PREPOPULATED SMO_FLAG1 SMO_TEXT1 CHAR 1   0   Flag  
107 INDIRECTFLAG SMO_INDIRECTFLAG SMO_TEXT1 CHAR 1   0   Indirect Indicator  
108 RATES_ORIGIN SMO_RATES_ORIGIN SMO_RATES_ORIGIN CHAR 1   0   Rates Origin  
History
Last changed by/on SAP  20110908 
SAP Release Created in