SAP ABAP Table CRMT_ACC_PL_ATTRIBUTES (Account Planning attributes)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-ACP-APL (Application Component) Account Planner
⤷ CRM_ACCOUNT_PLANNING (Package) CRM account planning
⤷ CRM-ACP-APL (Application Component) Account Planner
⤷ CRM_ACCOUNT_PLANNING (Package) CRM account planning
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_ACC_PL_ATTRIBUTES | Table Relationship Diagram |
Short Description | Account Planning attributes |
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 | CGPL_GUID16 | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16-Character GUID for Projects and Activts | ||
2 | LANGU | LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
3 | .INCLUDE | 0 | 0 | Account Planning : BSP Account Plan identification | |||||
4 | EXTERNAL_ID | CRM_BSP_ACC_PL_EXT_ID | CGPL_EXTID | CHAR | 24 | 0 | Project ID | ||
5 | TEXT1 | CGPL_TEXT1 | TEXT40 | CHAR | 40 | 0 | Language-Dependent Short Text | ||
6 | .INCLUDE | 0 | 0 | Project Planning: Projects and Activities Include Structure | |||||
7 | PROJECT_GUID | CGPL_PROJECT_GUID | CGPL_PROJECT_GUID | RAW | 16 | 0 | Project Planning: 16 Character GUID for Projects | ||
8 | OBJECT_TYPE | CGPL_OBJECT_TYPE | CHAR3 | CHAR | 3 | 0 | Object Type in Project Planning | ||
9 | PRIORITY | CGPL_PRIORITY | NUMC3 | NUMC | 3 | 0 | Priority | CGPL_PRIO | |
10 | ACTUALSTART | CGPL_ACTUALSTART | BCOS_TSTMP | DEC | 15 | 0 | Actual Start Date | ||
11 | ACTUALFINISH | CGPL_ACTUALFINISH | BCOS_TSTMP | DEC | 15 | 0 | Actual Finish Date | ||
12 | PLANSTART | CGPL_PLANSTART | BCOS_TSTMP | DEC | 15 | 0 | Planned start date | ||
13 | PLANFINISH | CGPL_PLANFINISH | BCOS_TSTMP | DEC | 15 | 0 | Planned Finish Date | ||
14 | COMPLETION | CGPL_COMPLETION | CGPL_COMPLETION | NUMC | 3 | 0 | Percentage of Completion | ||
15 | MILESTONE | CGPL_MILESTONE | CHAR1 | CHAR | 1 | 0 | Milestone indicator | ||
16 | CONSTRAINT_TYPE | CGPL_CONSTRAINT | CGPL_CONSTRAINT | CHAR | 1 | 0 | Type of Scheduling Constraint | ||
17 | CONSTRAINT_TIME | CGPL_CONSTRAINT_TIME | BCOS_TSTMP | DEC | 15 | 0 | Constraint Date | ||
18 | CREATED_BY | CGPL_CREATED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Created Object | ||
19 | CREATED_ON | CGPL_CREATED_ON | DATUM | DATS | 8 | 0 | Date on Which the Object was Created | ||
20 | CREATED_IN_BW | CGPL_CREATED_BW | CHAR1 | CHAR | 1 | 0 | Transfer Object to BW | ||
21 | CHANGED_BY | CGPL_CHANGED_BY | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
22 | CHANGED_ON | CGPL_CHANGED_ON | DATUM | DATS | 8 | 0 | Date on Which Object Was Last Changed | ||
23 | UPDATED_IN_BW | CGPL_UPDATED_BW | CHAR1 | CHAR | 1 | 0 | Current Object in BW | ||
24 | BWIDENTIFIER | CGPL_BWIDENTIFIER | CGPL_BWIDENTIFIER | NUMC | 8 | 0 | Project Planning - BW Identification | ||
25 | PLANGROUP | CGPL_SEM_PLGRP | CHAR | 4 | 0 | Planning Profile Group | CGPL_PLANGRP | ||
26 | LATEST_START | CGPL_LATEST_START | BCOS_TSTMP | DEC | 15 | 0 | Latest start | ||
27 | LATEST_FINISH | CGPL_LATEST_FINISH | BCOS_TSTMP | DEC | 15 | 0 | Latest finish date | ||
28 | TOTAL_FLOAT | CGPL_TOTAL_FLOAT | CGPL_FLOAT | DEC | 8 | 2 | Total Float | ||
29 | DURATION | CGPL_DURATION | CGPL_DURATION | DEC | 8 | 2 | Duration of Execution | ||
30 | DURATION_UNIT | CGPL_DURATION_UNIT | MEINS | UNIT | 3 | 0 | Time Unit for Execution Duration | * | |
31 | CALENDAR_ID | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | * | |
32 | CONSTR_TYPE_FIN | CGPL_CONSTRAINT | CGPL_CONSTRAINT | CHAR | 1 | 0 | Type of Scheduling Constraint | ||
33 | CONSTR_TIME_FIN | CGPL_CONSTRAINT_TIME | BCOS_TSTMP | DEC | 15 | 0 | Constraint Date | ||
34 | APPLICATION | CGPL_APPLICATION_TYPE | CGPL_APPLICATION_TYPE | CHAR | 3 | 0 | Application in Project Planning | * | |
35 | FORECAST_START | CGPL_FORECAST_START | BCOS_TSTMP | DEC | 15 | 0 | Forecast Start | ||
36 | FORECAST_FINISH | CGPL_FORECAST_FINISH | BCOS_TSTMP | DEC | 15 | 0 | Forecast Finish | ||
37 | .INCLUDE | 0 | 0 | CRM Account Planning: Include Structure Appl. Attrtibutes | |||||
38 | .INCLUDE | 0 | 0 | ACP: Include Structure Appl. Attrtibutes - Internal | |||||
39 | .INCLUDE | 0 | 0 | ACP: Include Structure Appl. Attrtibutes - Internal | |||||
40 | AUTH_GROUP | CRM_ACC_PL_AUTH_GROUP | CRM_ACC_PL_AUTH_GROUP | CHAR | 4 | 0 | Authorization Group | * | |
41 | PERIOD | CRM_ACC_PL_PERIOD | CRM_ACC_PL_PERIOD | CHAR | 24 | 0 | Planning Period | * | |
42 | BP_GUID | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
43 | NODE_GUID | BU_NODE_GUID | SYSUUID | RAW | 16 | 0 | GUID of Hierarchy Node | ||
44 | SALES_ORG | CRMT_ACC_PL_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization | ||
45 | DIVISION | CRMT_ACC_PL_DIVISION | CRM_ACC_PL_DIVISION | CHAR | 2 | 0 | Division | ||
46 | DIS_CHANNEL | CRMT_ACC_PL_DISTR_CHANNEL | CRM_ACC_PL_DISTR_CHANNEL | CHAR | 2 | 0 | Distribution Channel | ||
47 | CURRENCY | CRM_MKTPL_CUKY | WAERS | CUKY | 5 | 0 | MKTPL: Currency Object | TCURC | |
48 | CREATED_ONLINE | CRM_ACC_PL_CREATED_ONLINE | FLAG | CHAR | 1 | 0 | Created Online | ||
49 | TERR_PATH_GUID | CRMT_TERRITORY_PATH_GUID | SYSUUID | RAW | 16 | 0 | Territory Path GUID | ||
50 | TERR_PATH_ID | CRMT_TERRITORY_PATH_ID | CRM_TERRITORY_PATH_ID | CHAR | 30 | 0 | Territory Hierarchy ID | ||
51 | PLANBASIS | CRM_ACC_PL_PLAN_BASIS | CRM_ACC_PL_PLAN_BASIS | CHAR | 1 | 0 | Planning Basis (Product or Product Category) | ||
52 | PLANNED_BY | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
53 | TERR_ID | CRMT_TERRITORY_ID | CRM_TERRITORY_ID | CHAR | 30 | 0 | Territory ID | ||
54 | ACTION_PROFILE | CRM_ACC_PL_ACTION_PROFILE | PPFDCNTXT | CHAR | 30 | 0 | Account Planner: Name of Action Profile | * | |
55 | ORIG_SYSTEM | CRM_MKTPL_ORIG_SYST | CHAR1 | CHAR | 1 | 0 | CRM Marketing Planning - Campaign Original System | ||
56 | TIME_ZONE | SYSTZONLO | SYCHAR06 | CHAR | 6 | 0 | Time Zone | ||
57 | PROD_PL_BASIS | CRM_MKTSS_PL_BASIS | CRM_MKTSS_PL_BASIS | NUMC | 3 | 0 | Product Planning Basis | ||
58 | RESPONSIBLE | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
59 | .INCLUDE | 0 | 0 | Extension Include - Account Plan Header | |||||
60 | ACCPL_HEADER | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
61 | PLAN_DATA_VERSION | CRM_MKTPL_SEM_VERSION | CRM_MKTPL_SEM_VERSION | CHAR | 10 | 0 | CRM Marketing SEM Version | ||
62 | RESPONSIBLE_NAME | CRM_MKTPL_RESPONSIBLE | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible for Marketing Project | * | |
63 | .INCLUDE | 0 | 0 | ACP: Include Structure Appl. Attrtibutes - External | |||||
64 | TERR_DESCRIPTION | CRMT_TERRITORY_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Territory Description | ||
65 | RESPONSIBLE_TEXT | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
66 | CHANNEL_DESC2 | CRMT_CHANNEL_DESC | CRMT_CHANNEL_DESC | CHAR | 40 | 0 | Distribution Channel Description | ||
67 | DIVISION_DESC2 | CRMT_DIVISION_DESC | CRMT_DIVISION_DESC | CHAR | 40 | 0 | Division Description | ||
68 | .INCLUDE | 0 | 0 | CRM Account Planning- External Format of Attribute | |||||
69 | CUSTOMER_ID | CRM_ACC_PL_CUSTOMER_ID | CHAR20 | CHAR | 20 | 0 | ID of Planning Customer | ||
70 | CUSTOMER_DESC | CRM_ACC_PL_PLANCUST_DESC | CHAR | 50 | 0 | Account Planner : Planning Customer Description | |||
71 | PERIOD_DESC | CRM_ACC_PL_PERIOD_DESC | CRM_ACC_PL_PERIOD_DESC | CHAR | 40 | 0 | Description of Planning Period | ||
72 | SALES_ORG_DESC | CRMT_SALES_ORG_DESC | CRMT_SALES_ORG_DESC | CHAR | 40 | 0 | Sales Organization Description | ||
73 | CHANNEL_DESC | CRMT_CHANNEL_DESC | CRMT_CHANNEL_DESC | CHAR | 40 | 0 | Distribution Channel Description | ||
74 | DIVISION_DESC | CRMT_DIVISION_DESC | CRMT_DIVISION_DESC | CHAR | 40 | 0 | Division Description | ||
75 | CURRENCY_TEXT | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
76 | PLANSTART_IO | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
77 | PLANFINISH_IO | DATS | DATS | DATS | 8 | 0 | Field of type DATS | ||
78 | PPR_TYPE_DESC | CRMT_PRP_TYPE_DESCRIPTION | CRM_PRP_DESCRIPTION | CHAR | 40 | 0 | Description of a PPR Type | ||
79 | NODE_DESCR | BU_NODE_DESCRIPTION | BU_TEXT40 | CHAR | 40 | 0 | Description of a Hierarchy Node | ||
80 | PLANBASIS_DESC | CRM_ACC_PL_PLAN_BASIS_DESC | CHAR20 | CHAR | 20 | 0 | Description of Planning Basis in Account Plan | ||
81 | CUSTOMER_TYPE | CRM_ACC_PL_PLCUST_TYPE | CRM_ACC_PL_PLCUST_TYPE | CHAR | 2 | 0 | ACP: Type of Planning Customer (BP, Hierarchy Node, TG) | ||
82 | PROD_PL_BASIS_TEXT | CRM_MKTSS_PL_BASIS_TEXT | CRM_MKTSS_PL_BASIS_TEXT | CHAR | 40 | 0 | Description of Product Planning Basis | ||
83 | PLANGROUP_DESC | CGPL_SEM_PLGRPT | TEXT40 | CHAR | 40 | 0 | Description of Planning Profile Group | ||
84 | .INCLUDE | 0 | 0 | Guids from CRMT_ACC_PL_ATTRIBUTES in char32 format | |||||
85 | GUID32 | SYSUUID_C | SYSUUID_C | CHAR | 32 | 0 | UUID in character form | ||
86 | PROJECT_GUID32 | SYSUUID_C | SYSUUID_C | CHAR | 32 | 0 | UUID in character form | ||
87 | BP_GUID32 | SYSUUID_C | SYSUUID_C | CHAR | 32 | 0 | UUID in character form | ||
88 | NODE_GUID32 | SYSUUID_C | SYSUUID_C | CHAR | 32 | 0 | UUID in character form | ||
89 | TERR_PATH_GUID32 | SYSUUID_C | SYSUUID_C | CHAR | 32 | 0 | UUID in character form |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_ACC_PL_ATTRIBUTES | CURRENCY | TCURC | WAERS | |||
2 | CRMT_ACC_PL_ATTRIBUTES | LANGU | T002 | SPRAS | |||
3 | CRMT_ACC_PL_ATTRIBUTES | PLANGROUP | CGPL_PLANGRP | PLANGRP | KEY | ||
4 | CRMT_ACC_PL_ATTRIBUTES | PRIORITY | CGPL_PRIO | PRIORITY | KEY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 400 |