SAP ABAP Table BIW_ISU_PARTNER_MKT (IS-U Business Partner 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_PARTNER_MKT	Table Relationship Diagram
Short Description	IS-U Business Partner 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	*
2	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
3	.INCLUDE	☐				0	0	IS-U-Specific Fields for Business Partner
4	WAKLASS	☐	WAKLASS	E_WAKLASS	CHAR	4	0	Employee classification	TE697
5	FIRMART	☐	FIRMART	FIRMART	CHAR	2	0	Type of installation company	TE183
6	ARBFELD	☐	ARBFELD	ARBFELD	CHAR	2	0	Company work field	TE185
7	MITGLIED	☐	MITGLIED	MITGLIED	CHAR	1	0	Membership of installer
8	SPZULASS	☐	SPZULASS	SPZULASS	CHAR	20	0	Division license of installer
9	ARTZULASS	☐	ARTZULASS	ARTZULASS	CHAR	2	0	Installer license type	TE189
10	AUSWANZ	☐	AUSWANZ	AUSWANZ	NUMC	2	0	Number of identifications
11	PLOMBENZ	☐	PLOMBENZ	PLOMBENZ	CHAR	10	0	Sealing pliers number
12	FREMDEVU	☐	FREMDEVU	EVU	CHAR	3	0	Main utility company	TE187
13	STATINS	☐	STATINS	STATINS	CHAR	2	0	Valid status of installer in supply area	TE061
14	STATDATUM	☐	STATDATUM	STATDATUM	DATS	8	0	Date on which status of installer comes into effect
15	ERSTZUL	☐	ERSTZUL	ERSTZUL	DATS	8	0	Date of initial license of installer
16	WERKSTATT	☐	WERKSTATT	WERKSTATT	DATS	8	0	Date of workshop inspection
17	VERLZUL	☐	VERLZUL	VERLZUL	DATS	8	0	Date of license renewal
18	ENDEZUL	☐	ENDEZUL	ENDEZUL	DATS	8	0	Date until which license is renewed
19	ANZEVU	☐	ANZEVU	ANZEVU	NUMC	2	0	Number of utility companies
20	ANZFIL	☐	ANZFIL	ANZFIL	NUMC	2	0	Number of branches supported by an installionr company
21	AUSW_INST	☐	AUSW_INST	AUSW_INST	CHAR	10	0	Identification number for installer license
22	DR_LICENSE_LAND1	☐	DR_LICENSE_LAND1	LAND1	CHAR	3	0	Country in which driver's license was acquired	T005
23	DR_LICENSE_REGIO	☐	DR_LICENSE_REGIO	REGIO	CHAR	3	0	Region in which driver's license was acquired	T005S
24	DR_LICENSE	☐	DR_LICENSE	DR_LICENSE	CHAR	20	0	Driver's license number
25	SOC_SECURE	☐	E_SOC_SECU	E_SOC_SECU	CHAR	12	0	Social Insurance Number
26	WELFARE	☐	WELFARE	WELFARE	CHAR	9	0	Welfare office
27	PLACE_EMPL	☐	PLACE_EMPL	CHAR40	CHAR	40	0	Work center
28	KTOKLASSE	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	KONTOKLASSE
29	BUPINFOREL	☐	BUPINFOREL	BUPINFOREL	CHAR	2	0	Information release for business partner data	TEBUPINFOREL
30	CLERK_ID	☐	E_CLERK_ID	E_CLERK_ID	CHAR	8	0	Business partner-specific criteria for agent determination	TECLERK_ID
31	RECPTYPE	☐	E_RECPTYPE	E_RECPTYPE	CHAR	1	0	Category for Alternate Payee
32	PYMET	☐	E_PYMET_DON	PYMET_KK	CHAR	1	0	Payment method for donations/fund payments	TFK042Z
33	EMBVT	☐	E_EMBVT_DON	CHAR4	CHAR	4	0	Bank details ID for donations/fund payments
34	HKONT	☐	E_HKONT_DON	SAKNR	CHAR	10	0	G/L accounts for donations/fund payments	SKA1
35	CLASSIFICATION	☐	E_CLASSIFICATION	CHAR4	CHAR	4	0	Classification of Business Partner	TE181
36	VIP	☐	E_VIP	KENNZX	CHAR	1	0	Indicate Very Important Business Partner
37	IDENT_INST	☐	IDENT_INST	IDENT_INST	CHAR	18	0	Identification Number for Installer License

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_ISU_PARTNER_MKT	ARBFELD	TE185	ARBFELD
2	BIW_ISU_PARTNER_MKT	ARTZULASS	TE189	ARTZULASS
3	BIW_ISU_PARTNER_MKT	BUPINFOREL	TEBUPINFOREL	INFOREL
4	BIW_ISU_PARTNER_MKT	CLASSIFICATION	TE181	CLASSIFICATION
5	BIW_ISU_PARTNER_MKT	CLERK_ID	TECLERK_ID	CLERK_ID
6	BIW_ISU_PARTNER_MKT	DR_LICENSE_LAND1	T005	LAND1
7	BIW_ISU_PARTNER_MKT	DR_LICENSE_REGIO	T005S	BLAND
8	BIW_ISU_PARTNER_MKT	FIRMART	TE183	FIRMART
9	BIW_ISU_PARTNER_MKT	FREMDEVU	TE187	EVU
10	BIW_ISU_PARTNER_MKT	HKONT	SKA1	SAKNR
11	BIW_ISU_PARTNER_MKT	KTOKLASSE	KONTOKLASSE	KTOKL
12	BIW_ISU_PARTNER_MKT	PARTNER	BUT000	PARTNER
13	BIW_ISU_PARTNER_MKT	PYMET	TFK042Z	ZLSCH
14	BIW_ISU_PARTNER_MKT	STATINS	TE061	STATINS
15	BIW_ISU_PARTNER_MKT	WAKLASS	TE697	WAKLASS

History

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