SAP ABAP Table SCRMMKT_MDF_BW (Structure for MDF Initiative BW extraction)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MKT-MPL-MDF (Application Component) Marketing Development Funds
     CRM_MKTPL_MDF_BW (Package) Package for BW development for MDF objects
Basic Data
Table Category INTTAB    Structure 
Structure SCRMMKT_MDF_BW   Table Relationship Diagram
Short Description Structure for MDF Initiative BW extraction    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 GUID CRM_MKTPL_IB_INI_GUID   RAW 16   0   Initiative  
2 EXTERNAL_ID CRM_MKTPL_INITIATIVEID CGPL_EXTID CHAR 24   0   MDF Initiative  
3 CAMP_TYPE CRM_MKTPL_CAMPTYPE CRM_MKTPL_CAMPTYPE CHAR 4   0   Type *
4 OBJECTIVE CRM_MKTPL_OBJECTIVE CRM_MKTPL_OBJECTIVE CHAR 4   0   Objective  
5 TACTICS CRM_MKTPL_TACTICS CRM_MKTPL_TACTICS CHAR 4   0   Tactic  
6 PRIORITY CRM_MKTPL_IB_PRIORITY NUMC3 NUMC 3   0   Priority String Element (iBom MKTPL)  
7 RESPONSIBLE BU_PARTNER_GUID SYSUUID RAW 16   0   Business Partner GUID  
8 TERR_PATH_GUID CRMT_TERRITORY_PATH_GUID SYSUUID RAW 16   0   Territory Path GUID  
9 TERR_PATH_ID CRMT_TERRITORY_PATH_ID CRM_TERRITORY_PATH_ID CHAR 30   0   Territory Hierarchy ID  
10 ACTION_PROFILE CRM_MKTPL_ACTION_PROFILE PPFDCNTXT CHAR 30   0   ID of Action Profile *
11 CURRENCY CRM_MKTPL_CUKY WAERS CUKY 5   0   MKTPL: Currency Object *
12 CALENDAR_ID WFCID WFCID CHAR 2   0   Factory Calendar *
13 STSMA J_STSMA J_STSMA CHAR 8   0   Status Profile *
14 PARENT_GUID CRM_MKTPL_IB_MKTPROJECT_GUID   RAW 16   0   Marketing Project  
15 BWIDENTIFIER CGPL_BWIDENTIFIER CGPL_BWIDENTIFIER NUMC 8   0   Project Planning - BW Identification  
16 NO_R3_INT CRM_MKTPL_NO_R3_INT CHAR1 CHAR 1   0   Marketing Planning: Object Not Integrated into ERP PS  
17 REF_TYPE CRM_MKTPL_REF_TYPE CRM_MKTPL_REF_TYPE_DOM CHAR 4   0   Usage Type  
18 PLANSTARTDATE CRM_MKTPL_PLANSTARTDATE DATUM DATS 8   0   Planned Start Date  
19 PLANSTARTTIME CRM_MKTPL_PLANSTARTTIME TIME TIMS 6   0   Planned Start (Time)  
20 PLANFINISHDATE CRM_MKTPL_PLANFINISHDATE DATUM DATS 8   0   Planned Finish Date  
21 PLANFINISHTIME CRM_MKTPL_PLANFINISHTIME TIME TIMS 6   0   Planned Finish (Time)  
22 MKT_ORG CRM_MKTPL_MORG HROBJEC_14 CHAR 14   0   Marketing Organization  
23 SALES_ORG CRMT_SALES_ORG HROBJEC_14 CHAR 14   0   Sales Organization ID  
24 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
25 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
26 TIMEZONE_CREATED CRM_MKTPL_TIMEZONE_CREATED TZNZONE CHAR 6   0   Time Zone of User Who Created the Marketing Project *
27 OBJECT_TYPE CGPL_OBJECT_TYPE CHAR3 CHAR 3   0   Object Type in Project Planning  
28 TEMPLATE CRM_MKTPL_TEMPLATE CRM_BOOLEAN CHAR 1   0   Template Indicator  
29 CREATED_BY CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
30 CREATED_BY_DESC CRM_MKTPL_IB_CREATED_BY_DESC CHAR65 CHAR 65   0   Description of Person Who Created Object  
31 CREATED_ON CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
32 CHANGED_BY CGPL_CHANGED_BY USNAM CHAR 12   0   Name of Person Who Changed Object  
33 CHANGED_BY_DESC CRM_MKTPL_IB_CHANGED_BY_DESC CHAR65 CHAR 65   0   Description of Person Who Changed Object  
34 CHANGED_ON CGPL_CHANGED_ON DATUM DATS 8   0   Date on Which Object Was Last Changed  
35 PARTNER01_BP BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
36 PARTNER02_BP BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
37 PARTNER03_BP BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
38 PARTNER04_BP BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
39 PARTNER05_BP BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
40 PARTNER06_BP BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
41 DATE_RANGE_ST01 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
42 DATE_RANGE_ST02 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
43 DATE_RANGE_ST03 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
44 DATE_RANGE_ST04 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
45 DATE_RANGE_ST05 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
46 DATE_RANGE_ST06 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
47 DATE_RANGE_ST07 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
48 DATE_RANGE_ST08 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
49 DATE_RANGE_ST09 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
50 DATE_RANGE_ST10 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
51 DATE_RANGE_END01 CRM_MKTPL_DATE_TO DATUM DATS 8   0   To Date (Search)  
52 DATE_RANGE_END02 CRM_MKTPL_DATE_TO DATUM DATS 8   0   To Date (Search)  
53 DATE_RANGE_END03 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
54 DATE_RANGE_END04 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
55 DATE_RANGE_END05 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
56 DATE_RANGE_END06 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
57 DATE_RANGE_END07 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
58 DATE_RANGE_END08 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
59 DATE_RANGE_END09 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
60 DATE_RANGE_END10 CRM_MKTPL_DATE_FROM DATUM DATS 8   0   From Date (Search)  
61 DELFLAG CGPL_BW_DELFLAG   CHAR 1   0   BW Deletion Indicator  
62 MDF_PGM_GUID CGPL_GUID16 CGPL_PROJECT_GUID RAW 16   0   Project Planning: 16-Character GUID for Projects and Activts  
63 MDF_SPG_GUID CGPL_GUID16 CGPL_PROJECT_GUID RAW 16   0   Project Planning: 16-Character GUID for Projects and Activts  
64 MDF_INI_GUID CGPL_GUID16 CGPL_PROJECT_GUID RAW 16   0   Project Planning: 16-Character GUID for Projects and Activts  
65 MARKET_PLAN_GUID CGPL_PROJECT_GUID CGPL_PROJECT_GUID RAW 16   0   Project Planning: 16 Character GUID for Projects  
66 MDF_PGM_ID CRM_MKTPL_PROGRAMID CGPL_EXTID CHAR 24   0   MDF Program  
67 MDF_SPG_ID CRM_MKTPL_MDFCAMPAIGNID CGPL_EXTID CHAR 24   0   MDF Special Program ID  
68 MDF_INI_ID CRM_MKTPL_INITIATIVEID CGPL_EXTID CHAR 24   0   MDF Initiative  
69 MDF_MKTPL_ID CGPL_EXTID CGPL_EXTID CHAR 24   0   Project Planning: External Indentifier of an Element  
70 .INCLUDE       0   0    
71 .INCLUDE       0   0    
72 ENROLLMENT_REQ CRM_MKTPL_ENR_ENROLLMENT_REQ XFELD CHAR 1   0   Indicator, that enrollment is required  
73 CHM_RELEVANT CRMT_MKTPL_MDF_CHM_RELEVANT XFELD CHAR 1   0   Open to Partners  
74 FNDPL_GUID CRM_FM_FND_FUNDPLAN_GUID SYSUUID RAW 16   0   Funds Plan GUID  
75 FNDPL_ID CRM_FM_FND_FUNDPLAN_ID CRM_OBJECT_ID CHAR 10   0   Funds Plan ID  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700