SAP ABAP Table SMOACCPLN (Account Plan Header)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOACCPLN	Table Relationship Diagram
Short Description	Account Plan Header

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	SFAACCPLN	☑	SMO_SFAACCPLN	SMO_GUID	CHAR	32	0	SFA KEY of the Account Plan Business object
3	DATEFROM	☐	SMO3DATAB	DATUM	DATS	8	0	Valid-from date
4	DATETO	☐	SMO3DATBI	DATUM	DATS	8	0	Valid to date
5	ACCPLNID	☐	SMO_ACCPLNID	TEXT24	CHAR	24	0	Account ID
6	EXTPLN	☐	SMO_EXTACC	SMO_TEXT1	CHAR	1	0	Account plan from CRM Enterprise.
7	CUSTTYPE	☐	SMO_CUSTTYPE	SMO_TEXT2	CHAR	2	0	Type of planning customer for Trade Promotion
8	SFAPCCUST	☐	SMO_PLANCUST	SMO_GUID	CHAR	32	0	Guid of Business Partner or Group Hierarchy node
9	CURRENCY	☐	SMO3WAERS	WAERS	CUKY	5	0	Currency key	*
10	PERIOD	☐	SMO_ACCPERIOD	SMO_TXT24	CHAR	24	0	Period of the Account Plan
11	PLANGRP	☐	SMO_PLANGRP	SMO_CHAR4	CHAR	4	0	Planning Profile Group
12	PLANNINGLEVEL	☐	SMOPLANLEVEL	SMO_TEXT1	CHAR	1	0	Level of planning
13	SOURCE	☐	SMO_SOURCE	SMO_SOURCE	CHAR	3	0	Source of an object
14	PPRTYPE	☐	CDB_PRP_TYPE	CDB_PRP_TYPE	CHAR	4	0	Partner Product Range: Type of Assignment
15	VKORG	☐	SMO3VKORG	SMO3VKORG	CHAR	14	0	Sales organization
16	VTWEG	☐	SMO3VTWEG	SMO3VTWEG	CHAR	2	0	Distribution channel
17	SPART	☐	SMO3SPART	SMO3SPART	CHAR	2	0	Division
18	TERR_PATH_GUID	☐	SMOTERRPATHGUID	CHAR32	CHAR	32	0	Territory Path Guid
19	TERR_PATH_ID	☐	SMOTERRPATHID	CHAR30	CHAR	30	0	Territory Path ID
20	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
21	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
22	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
23	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
24	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
25	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
26	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
27	STSMA	☐	SMO_STSMA	SMO_TXT8	CHAR	8	0	Status profile
28	AUTHGRP	☐	SMO_AUT	SMO_TXT4	CHAR	4	0	campaign authorization group
29	PLANNED_BY	☐	SMO_CREATED_BY	SMO_GUID	CHAR	32	0	Name of the Person that Created the Object
30	CHANGED_BY	☐	SMO_CHANGED_BY	USNAM	CHAR	12	0	Name of the person that changed the object
31	.INCLUDE	☐				0	0	Record Modification Fields for Mobile Sales/Service
32	ERFASS	☐	SMO_CREATE	SMO_DATE	DATS	8	0	Date of Creation.
33	GEAEND	☐	SMO_MODIFY	SMO_DATE	DATS	8	0	Date last Modified
34	BEARB	☐	SMO_BEARB	SMO_BEARB	CHAR	15	0	Record Edited by User Name
35	PROD_PL_BASIS	☐	SMO_PLBAS	SMO_TXT3	CHAR	3	0	Product Planning Basis

History

Last changed by/on	SAP	20100420
SAP Release Created in	400