SAP ABAP Table BIW_ISU_CONTRACT_MKT (IS-U Contract Data for BW Master Data)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS-MA (Application Component) Marketing
     ⤷ EE_CRM_MKT_BIW (Package) BW Extractors fur IS-U/CRM Marketing

Basic Data

Table Category	INTTAB	Structure
Structure	BIW_ISU_CONTRACT_MKT	Table Relationship Diagram
Short Description	IS-U Contract Data for BW Master Data

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
3	.INCLUDE	☐				0	0	IS-U Contract: General Fields
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TESPT
6	EIGENVERBR	☐	EIGENVERBR	EIGENVERBR	CHAR	1	0	Plant or company consumption
7	KOFIZ	☐	E_KOFIZ	E_KOFIZ	CHAR	2	0	Account determination ID for IS-U contracts	TE097
8	PORTION	☐	PORTIONABW	PORTION	CHAR	8	0	Alternative portion	TE420
9	ABSLANFO	☐	ABSLANFO	ABSLANFOAB	CHAR	1	0	Budget billing request for debtor
10	ABSZYK	☐	ABSZYKV	ABSZYKV	CHAR	2	0	Overrriding BB cycle on contract level
11	ABSMNANP	☐	ABSMNANP	AS4FLAG	CHAR	1	0	Do not adjust budget billing amount automatically
12	GEMFAKT	☐	E_GEMFAKT	E_GEMFAKT	CHAR	1	0	Invoice Contracts Jointly (Mandatory Contracts)
13	MANABR	☐	MANABR	KENNZX	CHAR	1	0	Bill contract manually
14	ABRSPERR	☐	ABRSPERR	ABRSPERR	CHAR	2	0	Reason for blocking billing	TE021
15	ABRFREIG	☐	ABRFREIG	ABRFREIG	CHAR	2	0	Reason for releasing billing	TE023
16	BSTATUS	☐	BEARKZ	BEARSTAT	CHAR	2	0	Processing status	TE643
17	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
18	VBEZ	☐	E_VBEZ	TEXT35	CHAR	35	0	Text for contract
19	VBEGINN	☐	E_VBEGINN	DATUM	DATS	8	0	Start of contract
20	EINZDAT_ALT	☐	EINZDAT_ALT	DATUM	DATS	8	0	Move-in date from legacy system
21	VENDE	☐	E_VENDE	DATUM	DATS	8	0	End of contract
22	KUENDDAT	☐	KUENDAT	DATUM	DATS	8	0	Cancellation date of contract
23	KFRIST	☐	KUENZEIT	PERWERT	NUMC	3	0	Number of time units for cancellation
24	KUENPER	☐	KUENPER	PERART	CHAR	1	0	Time unit for cancellation
25	VBISDAT	☐	E_VBISDAT	DATUM	DATS	8	0	Renewal date of contract
26	VERLAENG	☐	VERZEIT	PERWERT	NUMC	3	0	Number of time units for renewal
27	VERPER	☐	VERPER	PERART	CHAR	1	0	Time unit for renewal
28	VABSCHLEVU	☐	E_VSCHLEVU	DATUM	DATS	8	0	Date on which utility concluded the contract
29	VABSCHLKND	☐	E_VSCHLKND	DATUM	DATS	8	0	Date on which customer concluded the contract
30	VABSCHLKNDTI	☐	E_VSCHLKNDTI	TIMS	TIMS	6	0	Time at which customer signed contract
31	PERSNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
32	VREFER	☐	E_VREFER	TEXT20	CHAR	20	0	Contract number from legacy system
33	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
34	.INCLUDE	☐				0	0	Creation and Change Data
35	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
36	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
37	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
38	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
39	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
40	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
41	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
42	MANOUTSORT	☐	MANOUTSORT	MANOUTSORT	CHAR	8	0	Reason for manual outsorting in billing	TE127
43	FAKTURIERT	☐	FAKTURIERT	KENNZX	CHAR	1	0	Contract has already been invoiced
44	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
45	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
46	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
47	COPAKONT	☐	E_COPAKONT	XFELD	CHAR	1	0	Indicator: Profitability segment assigned (CO-PA)
48	AUSGRUP	☐	AUSGRUP	AUSGRUP	CHAR	8	0	Outsorting check group for billing	TE191
49	OUTCOUNT	☐	OUTCOUNT	OUTNUMBER	NUMC	2	0	Number of manual outsortings to be carried out yet
50	PYPLT	☐	E_PYPLT	E_PYPLT	CHAR	4	0	Payment plan type	TE015
51	PYPLS	☐	E_PYPLS	MONTH	NUMC	2	0	Starting month of payment plan
52	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
53	SEGMENT	☐	SEGMT_KK	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
54	SERVICEID	☐	SERVICE_PROV	SERVICE_PROV	CHAR	10	0	Service Provider	ESERVPROV
55	SRVPRVREF	☐	SRVPRVREF	CHAR30	CHAR	30	0	Reference number of service provider
56	BILLMETHOD	☐	BILLMETHOD	BILLMETHOD	CHAR	2	0	Billing method
57	STAGRUVER	☐	E_STGRUV	E_STGRUV	CHAR	2	0	Statistics group for contract	TE770
58	PYPLA	☐	E_PYPLA	MONTH	NUMC	2	0	Alternative start month of payment plan
59	BILLFINIT	☐	BILLFINIT	KENNZX	CHAR	1	0	Contract terminated for billing reasons
60	BFA_DEB_STAT	☐	E_BFA_PROC_DEBIT	E_BFA_PROCESSING	CHAR	1	0	Payment plan - BF amount not released for receivable
61	BFA_CRED_STAT	☐	E_BFA_PROC_CREDIT	E_BFA_PROCESSING	CHAR	1	0	Payment plan - BF amount not released for credit
62	SALESEMPLOYEE	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
63	SALESPARTNER	☐	ESALESPARTNER	KUNNR	CHAR	10	0	Sales partners	KNA1
64	SALESDOCUMENT	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
65	PS_STARTDAT	☐	PS_STARTDAT	DATS	DATS	8	0	Start Date of Payment Scheme (PS)
66	SERVPROV_PAY	☐	SERVPROV_PAY	SERVPROV_PAY	CHAR	4	0	Payment Class	ESERVPROV_PAY
67	INVOICING_PARTY	☐	INVOICING_PARTY	SERVICE_PROV	CHAR	10	0	Service Provider That Invoices the Contract	*
68	COKEY	☐	COKEY_EE2	CHAR10	CHAR	10	0	CO account assignment key, IS-U contract	TECOK
69	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
70	CONTRACTCLASS	☐	CONTRACTCLASS	ECONTRACTCLASS	CHAR	4	0	Contract Class	TECONTRACTCLASS
71	CANCREASON	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	*
72	CANCREASON_NEW	☐	ECRMT_SRV_CANCEL_REASON	QCODE	CHAR	4	0	Cancellation Reason (CRM)	*
73	EXTRAPOLWASTE	☐	EXTRAPOLWASTE	EXTRAPOLWASTE	CHAR	2	0	Category of Waste Disposal Budget Billing Extrapolation
74	PPM_CONTRACT	☐	E_PP_PPM_CONTRACT	E_PP_PPM_CONTRACT	CHAR	1	0	Identifies Contract as Prepayment Meter Contract
75	OSB_GROUP	☐	E_OSB_GROUP		CHAR	3	0	On-Site Billing Group	TE555
76	OUCONT	☐	OUCONT	KENNZX	CHAR	1	0	Outline Contract
77	RULEGR	☐	RULEGR	RULEGR	CHAR	10	0	Rule Group for Outline Agreements	*
78	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
79	.INCLUDE	☐				0	0	IS-U Contract: Move-in/out Fields
80	ANLAGE	☐	ANLAGE	ANLAGE	CHAR	10	0	Installation	*
81	VKONTO	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
82	KZSONDEINZ	☐	KZSONDEINZ	KZSONDEINZ	CHAR	1	0	Move-In Processing (Special Case)
83	KZSONDAUSZ	☐	KZSONDAUSZ	KZSONDAUSZ	CHAR	1	0	Special move-out processing case exists
84	AUTEIGEINZ	☐	AUTEIGEINZ	KENZX	CHAR	1	0	Automatic Owner Move-In
85	EINZDAT	☐	EINZDAT	DATUM	DATS	8	0	Move-In Date
86	AUSZDAT	☐	AUSZDAT	DATUM	DATS	8	0	Move-Out Date
87	ABSSTOPDAT	☐	ABSSTOPDAT	DATUM	DATS	8	0	Stop date for budget bill. requests in the case of move-out
88	SCHLFAKT	☐	SCHLFAKT	E_GEMFAKT	CHAR	1	0	Joint final billing for move-in/out
89	MAHNV	☐	MAHNV_KK	MAHNV_KK	CHAR	2	0	Dunning Procedure	TFK047A
90	MAHNVUMZ	☐	MAHNV_UMZ	MAHNV_KK	CHAR	2	0	Move-in/out dunning procedure	TFK047A
91	MANSP	☐	MANSP_KK	MANSP_KK	CHAR	1	0	Dunning Lock Reason	TFK047S
92	BEZUG	☐	BEZUG	KENNZX	CHAR	1	0	Reference
93	TRANSVER	☐	E_TRANSVER	VERTRAG	CHAR	10	0	Transfer contract	EVER
94	SSWTCREASON	☐	SSWTCREASON	CHAR2	CHAR	2	0	Reasons for contract change	TE960
95	XVERA	☐	XVERA	KENNZX	CHAR	1	0	Contract created due to data transfer

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_ISU_CONTRACT_MKT	ABRFREIG	TE023	ABRFREIG		1	CN
2	BIW_ISU_CONTRACT_MKT	ABRSPERR	TE021	ABRSPERR		1	CN
3	BIW_ISU_CONTRACT_MKT	AUFNR	AUFK	AUFNR		1	CN
4	BIW_ISU_CONTRACT_MKT	AUSGRUP	TE191	AUSGRUP	KEY	1	CN
5	BIW_ISU_CONTRACT_MKT	BSTATUS	TE643	BEARKZ
6	BIW_ISU_CONTRACT_MKT	BUKRS	T001	BUKRS
7	BIW_ISU_CONTRACT_MKT	BUPLA	J_1BBRANCH	BRANCH
8	BIW_ISU_CONTRACT_MKT	COKEY	TECOK	COKEY
9	BIW_ISU_CONTRACT_MKT	CONTRACTCLASS	TECONTRACTCLASS	CONTRACTCLASS
10	BIW_ISU_CONTRACT_MKT	GSBER	TGSB	GSBER
11	BIW_ISU_CONTRACT_MKT	KOFIZ	TE097	KOFIZ		1	CN
12	BIW_ISU_CONTRACT_MKT	KOSTL	CSKS	KOSTL
13	BIW_ISU_CONTRACT_MKT	MAHNV	TFK047A	MAHNV
14	BIW_ISU_CONTRACT_MKT	MAHNVUMZ	TFK047A	MAHNV
15	BIW_ISU_CONTRACT_MKT	MANDT	T000	MANDT
16	BIW_ISU_CONTRACT_MKT	MANOUTSORT	TE127	MANOUTSORT
17	BIW_ISU_CONTRACT_MKT	MANSP	TFK047S	MANSP
18	BIW_ISU_CONTRACT_MKT	OSB_GROUP	TE555	OSB_GROUP
19	BIW_ISU_CONTRACT_MKT	PORTION	TE420	TERMSCHL		1	CN
20	BIW_ISU_CONTRACT_MKT	PRCTR	CEPC	PRCTR		1	CN
21	BIW_ISU_CONTRACT_MKT	PS_PSP_PNR	PRPS	PSPNR		1	CN
22	BIW_ISU_CONTRACT_MKT	PYPLT	TE015	PYPLT	KEY	1	CN
23	BIW_ISU_CONTRACT_MKT	SALESDOCUMENT	VBUK	VBELN
24	BIW_ISU_CONTRACT_MKT	SALESPARTNER	KNA1	KUNNR
25	BIW_ISU_CONTRACT_MKT	SEGMENT	FAGL_SEGM	SEGMENT
26	BIW_ISU_CONTRACT_MKT	SERVICEID	ESERVPROV	SERVICEID
27	BIW_ISU_CONTRACT_MKT	SERVPROV_PAY	ESERVPROV_PAY	SERVPROV_PAY
28	BIW_ISU_CONTRACT_MKT	SPARTE	TESPT	SPARTE	REF	1	CN
29	BIW_ISU_CONTRACT_MKT	SSWTCREASON	TE960	SSWTCREASON
30	BIW_ISU_CONTRACT_MKT	STAGRUVER	TE770	STAGRUVER
31	BIW_ISU_CONTRACT_MKT	TRANSVER	EVER	VERTRAG
32	BIW_ISU_CONTRACT_MKT	VKONTO	FKKVK	VKONT		1	CN

History

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