SAP ABAP Table EECRM_CRMCONTRACTPOS (Transfer Structure: Contract Status from CRM to IS-U)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS (Application Component) Customer Service
     ⤷ EECRM_CONTRACT (Package) Integration of CRM Contract

Basic Data

Table Category	INTTAB	Structure
Structure	EECRM_CRMCONTRACTPOS	Table Relationship Diagram
Short Description	Transfer Structure: Contract Status from CRM to IS-U

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_H	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
2	GUID_I	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
3	VAL_PER	☐	VLAUF_VEDA	NUM3	NUMC	3	0	Contract Term
4	VAL_PER_UN	☐	VLAUE_VEDA	KDZEH	CHAR	1	0	Unit of validity period of contract
5	VAL_PER_CA	☐	VLAUK_VEDA	VLAUK_VEDA	CHAR	2	0	Validity period category of contract	TVLZ
6	INST_DATE	☐	VIDAT_VEDA	DATUM	DATS	8	0	Installation date
7	ACCEPT_DAT	☐	VADAT_VEDA	DATUM	DATS	8	0	Agreement acceptance date
8	CON_ST_DAT	☐	VBDAT_VEDA	DATUM	DATS	8	0	Contract start date
9	CON_SI_DAT	☐	VUDAT_VEDA	DATUM	DATS	8	0	Date on which contract is signed
10	CANC_PROC	☐	VKUES_VEDA	VKUES_VEDA	CHAR	4	0	Assignment cancellation procedure/cancellation rule	TVKS
11	CON_EN_ACT	☐	VASCH_VEDA	AKTVT	CHAR	4	0	Activity at end of contract	TVAS
12	CANC_R_DAT	☐	VEDAT_VEDA	DATUM	DATS	8	0	Date on which cancellation request was received
13	R_CANC_DAT	☐	VWDAT_VEDA	DATUM	DATS	8	0	Requested cancellation date
14	CANC_PARTY	☐	VKPAR_VEDA	VKPAR_VEDA	CHAR	1	0	Cancelling Party
15	CANCREASON	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	TVKG
16	CON_EN_DAT	☐	VNDAT_VEDA	DATUM	DATS	8	0	Contract End Date
17	CANC_DOC	☐	VBELK_VEDA	CHAR20	CHAR	20	0	Cancellation document number of contract partner
18	CANCDOCDAT	☐	VBEDK_VEDA	DATUM	DATS	8	0	Date of cancellation document from contract partner
19	CON_ST_RUL	☐	VBREG_VEDA	VDREG_VEDA	CHAR	2	0	Rule for calculating contract start date	TVRG
20	DISM_DATE	☐	VDDAT_VEDA	DATUM	DATS	8	0	Dismantling date
21	ACTION_DAT	☐	VASDA	DATUM	DATS	8	0	Date of Activity
22	ACT_DATRUL	☐	VASDR	VDREG_VEDA	CHAR	2	0	Date Rule for Activity	*
23	CON_EN_RUL	☐	RGVTE	VDREG_VEDA	CHAR	2	0	Rule for contract end date	TVRG
24	BU_PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
25	BUAG_GUID	☐	ECRM_VKONT_GUID	SYSUUID	RAW	16	0	Business Agreement GUID
26	SALES_PRODUCT	☐	ESALES_CRM_PRODUCT	ESALES_CRM_PRODUCT	CHAR	40	0	CRM Product
27	IBASE_NODE	☐	EHAU_GUID	SYSUUID	RAW	16	0	CRM GUID of Connection Object
28	CAMPAIGN	☐	ISU_MARKETING_CAMPAIGN	ISU_MARKETING_CAMPAIGN	RAW	16	0	IS-U: Marketing Campaign
29	CAMPAIGN_TO_DATE	☐	ISU_CAMPAIGN_TO_DATE	DATS	DATS	8	0	IS-U: Individual To-Date Campaign Analysis
30	SALES_ORG_RESP	☐	EECRM_SALES_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Organizational Unit Responsible for Sales in CRM
31	SALES_ORG	☐	EECRM_SALES_ORG_SHORT	TEXT12	CHAR	12	0	CRM Sales Organization: Description of Department
32	DISTRIBUTION_CHANNEL	☐	EECRM_DISTRIBUTION_CHANNEL	CHAR2	CHAR	2	0	CRM Distribution Channel
33	SALES_OFFICE	☐	EECRM_SALES_OFFICE_SHORT	TEXT12	CHAR	12	0	CRM Sales Office ID
34	SALES_GROUP	☐	EECRM_SALES_GROUP_SHORT	TEXT12	CHAR	12	0	CRM Sales Group ID
35	SERVICE_ORG_RESP	☐	EECRM_SERVICE_ORG_RESP_SHORT	TEXT12	CHAR	12	0	CRM Responsible Organization Unit ID (Service)
36	SERVICE_ORG	☐	EECRM_SERVICE_ORG_SHORT	TEXT12	CHAR	12	0	CRM Service Organization ID
37	PROCESS_TYPE	☐	EECRM_PROCESS_TYPE	CHAR4	CHAR	4	0	CRM Business Transaction Type
38	KENNZ1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
39	KENNZ2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
40	KENNZ3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
41	COUNTER	☐	NUM2	NUM2	NUMC	2	0	Numeric, 2-digit value
42	PROZKZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
43	GUID	☐	RAW16	RAW16	RAW	16	0	RAW16
44	STRING	☐	CHAR200	CHAR200	CHAR	200	0	Text field length 200
45	VETRAG_NR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
46	POS_NR	☐	NUMC10	NUMC10	NUMC	10	0	Numeric Character Field, Length 10
47	PRODUCT_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
48	BUPA_NR	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
49	CON_ST_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
50	CON_END_TIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
51	TIME_ZONE	☐	SYSTZONLO	SYCHAR06	CHAR	6	0	Time Zone
52	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
53	CANC_PARTY_NEW	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
54	CANCREASON_NEW	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
55	VAL_PER_UN_NEW	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
56	DATE1	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
57	DATE2	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
58	DATE3	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
59	DATE4	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
60	DATE5	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
61	VAL_PER_UN1	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
62	VAL_PER_UN2	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
63	VAL_PER_UN3	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
64	OUCONT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
65	OUCONTRACT_I	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EECRM_CRMCONTRACTPOS	CANCREASON	TVKG	KUEGRU
2	EECRM_CRMCONTRACTPOS	CANC_PROC	TVKS	VKUESCH
3	EECRM_CRMCONTRACTPOS	CON_EN_ACT	TVAS	AKTVT
4	EECRM_CRMCONTRACTPOS	CON_EN_RUL	TVRG	REGEL
5	EECRM_CRMCONTRACTPOS	CON_ST_RUL	TVRG	REGEL
6	EECRM_CRMCONTRACTPOS	VAL_PER_CA	TVLZ	VLAUFK

History

Last changed by/on	SAP	20130529
SAP Release Created in	463