SAP ABAP Table EIAC_MOVE_IN (Structure for move-in)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS (Application Component) Customer Service
     ⤷ EWEBIAC (Package) IS-U: Internet Application Components

Basic Data

Table Category	INTTAB	Structure
Structure	EIAC_MOVE_IN	Table Relationship Diagram
Short Description	Structure for move-in

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	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
2	.INCLUDE	☐				0	0	BP: Bank Details (Data Fields - External)
3	.INCLUDE	☐				0	0	BP: Bank Details (CHAR Data Fields External)
4	BANKS	☐	BU_BANKS	LAND1	CHAR	3	0	Bank Country Key	T005
5	BANKL	☐	BU_BANKK	CHAR15	CHAR	15	0	Bank Key
6	BANKN	☐	BU_BANKN	CHAR18	CHAR	18	0	Bank Account Number
7	BKONT	☐	BU_BKONT	CHAR2	CHAR	2	0	Bank Control Key
8	BKREF	☐	BU_BKREF	CHAR20	CHAR	20	0	Reference Details for Bank Details
9	KOINH	☐	BU_KOINH	BU_KOINH	CHAR	60	0	Account Holder Name
10	BKEXT	☐	BU_BKEXT	CHAR20	CHAR	20	0	Bank details ID in external system
11	XEZER	☐	BU_XEZER	XFELD	CHAR	1	0	Indicator: Collection Authorization
12	ACCNAME	☐	BU_BANKACCNAME	BU_BKCCNAME	CHAR	40	0	Name of Bank Account
13	MOVE_BKVID	☐	BU_MOVE_BKVID	CHAR4	CHAR	4	0	ID of Target Details for Change of Bank Details (BP)
14	.INCLUDE	☐				0	0	BP: Bank Details (Non-CHAR Data Fields External)
15	BK_VALID_FROM	☐	BU_BK_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of Business Partner Bank Details
16	BK_VALID_TO	☐	BU_BK_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of Business Partner Bank Details
17	BK_MOVE_DATE	☐	BU_BK_MOVE_DATE	TZNTSTMPS	DEC	15	0	Date of Change to Bank Details (BP)
18	.INCLUDE	☐				0	0	BP: Bank Details (External Bank Data)
19	IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
20	BANK_GUID	☐	BU_BANK_GUID	UUID	RAW	16	0	Bank GUID
21	ACCOUNT_ID	☐	BU_ACCOUNT_ID	CHAR35	CHAR	35	0	Bank Account Number (New)
22	CHECK_DIGIT	☐	BU_ACCOUNT_CHECK	CHAR2	CHAR	2	0	Bank Account Check Digit
23	ACCOUNT_TYPE	☐	BU_ACCOUNT_TYPE	CHAR3	CHAR	3	0	Bank Account Type
24	.INCLUDE	☐				0	0	BP: Payment Cards (External Data)
25	CCINS	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
26	CCNUM	☐	BU_CCNUM	CHAR25	CHAR	25	0	Payment Cards: Card Number
27	CCDEF	☐	BU_CCDEF	XFELD	CHAR	1	0	BP: Standard Payment Card
28	CCACCNAME	☐	BU_CREDITCNAME	BU_BKCCNAME	CHAR	40	0	Description of Credit Card Details
29	MOVEINDATE	☐	EINZDAT	DATUM	DATS	8	0	Move-In Date
30	.INCLUDE	☐				0	0	Business Partner General Data for BAPIs
31	BPKIND	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	*
32	BP_EXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
33	BU_SORT1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
34	BU_SORT2	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
35	SOURCE	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types	*
36	TITLE	☐	AD_TITLE_T	TEXT20	CHAR	20	0	Form of address text
37	MARKED_FOR_DEL	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
38	BLOCKED	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
39	AUTH_GROUP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	*
40	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
41	NAME_ORG2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
42	NAME_ORG3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
43	NAME_ORG4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
44	LEGAL_ENTY	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
45	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
46	NAME_LAST	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
47	NAME_FIRST	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
48	NAME_LAST2	☐	DUMMY_BAPI_FIELD	CHAR40	CHAR	40	0	Inactive Field - No Longer Used -> BIRTHNAME
49	TITLE_ACA1	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
50	TITLE_ACA2	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
51	TITLE_ROYL	☐	AD_TITLEST	TEXT20	CHAR	20	0	Name supplement, e.g. noble title (written form)
52	PREFIX1	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
53	PREFIX2	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
54	NAME1_TEXT	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
55	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
56	SEX_M	☐	BU_XSEXM	XFELD	CHAR	1	0	Selection: Business partner is male
57	SEX_F	☐	BU_XSEXF	XFELD	CHAR	1	0	Selection: Business partner is female
58	BIRTHDATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
59	BIRTH_PLACE	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
60	DEATH_DATE	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
61	PERS_NUMB	☐	BU_PERNO	PERSONID	NUMC	8	0	Personnel Number
62	MARRIAGE_STATE	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	*
63	EMPLO	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
64	JOB_GROUP	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	*
65	NATIO	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
66	COUNTRY_TAX	☐	BU_CNTAX	LAND1	CHAR	3	0	Obsolete Field	*
67	COUNTRY_TAX_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
68	COUNTRY_DSC	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	*
69	COUNTRY_DSC_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
70	PARTGRPTYP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	*
71	NAME_GRP1	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
72	NAME_GRP2	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
73	LEG_TYPE	☐	BU_LGTYP	BU_LGTYP	CHAR	4	0	Legitimation Type	*
74	LEG_NUMB	☐	BU_LGNUM	BU_LGNUM	CHAR	16	0	Identification number of legitimation document
75	INFCT	☐	BU_INFCT	BU_INFCT	CHAR	30	0	Responsible local court
76	COM_REG	☐	BU_COMRG	CHAR30	CHAR	30	0	Entry in commercial register
77	ASS_REG	☐	BU_CLBRG	CHAR30	CHAR	30	0	BP: Entry in register of associations
78	COOP_REG	☐	BU_COPRG	CHAR30	CHAR	30	0	Entry in Register of Cooperatives
79	MAN_CRED_WORTH	☐	BONIWRT_KK	BONIT_KK	NUMC	4	0	Creditworthiness value set manually
80	DATE_MAN_CRED_WORTH	☐	BONIDAT_KK	DATUM	DATS	8	0	Date on Which Creditworthiness was Manually Set
81	NAME1	☐	BU_NAME1	BU_NAME	CHAR	40	0	Name field 1 (name1/last name)
82	NAME2	☐	BU_NAME2	BU_NAME	CHAR	40	0	Name field 2 (name2/first name)
83	EMPL_CLASS	☐	WAKLASS	E_WAKLASS	CHAR	4	0	Employee classification	*
84	ISTALL_COMP	☐	FIRMART	FIRMART	CHAR	2	0	Type of installation company
85	COMP_WORK_FIELD	☐	ARBFELD	ARBFELD	CHAR	2	0	Company work field
86	MEM_SHIP_INST	☐	MITGLIED	MITGLIED	CHAR	1	0	Membership of installer
87	DIV_LICENSE	☐	SPZULASS	SPZULASS	CHAR	20	0	Division license of installer
88	INST_LIC_TYPE	☐	ARTZULASS	ARTZULASS	CHAR	2	0	Installer license type
89	NUMB_IDS	☐	AUSWANZ	AUSWANZ	NUMC	2	0	Number of identifications
90	SEAL_PLIER	☐	PLOMBENZ	PLOMBENZ	CHAR	10	0	Sealing pliers number
91	MAIN_UTIL_COMP	☐	FREMDEVU	EVU	CHAR	3	0	Main utility company	*
92	STATUS_INST	☐	STATINS	STATINS	CHAR	2	0	Valid status of installer in supply area
93	STATUS_DATE	☐	STATDATUM	STATDATUM	DATS	8	0	Date on which status of installer comes into effect
94	INIT_LIC_DATE	☐	ERSTZUL	ERSTZUL	DATS	8	0	Date of initial license of installer
95	WORKSHOP_INSP_DATE	☐	WERKSTATT	WERKSTATT	DATS	8	0	Date of workshop inspection
96	LIC_RENEWAL_DATE	☐	VERLZUL	VERLZUL	DATS	8	0	Date of license renewal
97	LIC_RENEWED_DATE	☐	ENDEZUL	ENDEZUL	DATS	8	0	Date until which license is renewed
98	NUMB_UTIL_COMP	☐	ANZEVU	ANZEVU	NUMC	2	0	Number of utility companies
99	NUMB_BRANCHES	☐	ANZFIL	ANZFIL	NUMC	2	0	Number of branches supported by an installionr company
100	ID_NUMBER	☐	AUSW_INST	AUSW_INST	CHAR	10	0	Identification number for installer license
101	DR_LICENSE_LAND1	☐	DR_LICENSE_LAND1	LAND1	CHAR	3	0	Country in which driver's license was acquired	T005
102	DR_LICENSE_REGIO	☐	DR_LICENSE_REGIO	REGIO	CHAR	3	0	Region in which driver's license was acquired	T005S
103	DR_LICENSE	☐	DR_LICENSE	DR_LICENSE	CHAR	20	0	Driver's license number
104	SOC_SECURE	☐	E_SOC_SECU	E_SOC_SECU	CHAR	12	0	Social Insurance Number
105	WELFARE	☐	WELFARE	WELFARE	CHAR	9	0	Welfare office
106	PLACE_EMPL	☐	PLACE_EMPL	CHAR40	CHAR	40	0	Work center
107	ACCOUNT_CLASS	☐	KTOKLASSE	KTOKLASSE	CHAR	4	0	Account class	*
108	NAMEMIDDLE	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
109	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
110	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	*
111	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	*
112	PERS_NO	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
113	XSEXU	☐	BU_XSEXU	XFELD	CHAR	1	0	Selection: Sex of business partner is not known
114	USERNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
115	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
116	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
117	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
118	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
119	BUPINFOREL	☐	BUPINFOREL	BUPINFOREL	CHAR	2	0	Information release for business partner data	*
120	CLERK_ID	☐	E_CLERK_ID	E_CLERK_ID	CHAR	8	0	Business partner-specific criteria for agent determination
121	RECPTYPE	☐	E_RECPTYPE	E_RECPTYPE	CHAR	1	0	Category for Alternate Payee
122	PMNT_METH	☐	PYMET_KK	PYMET_KK	CHAR	1	0	Payment Method	*
123	BK_DETAILS	☐	EMBVT_KK	CHAR4	CHAR	4	0	Bank Details ID of Payee
124	G_L_ACCT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	*
125	TITLELETTER	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
126	CONTACTALLOWANCE	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
127	LEGALORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
128	BIRTHNAME	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
129	MIDDLENAME	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
130	CORRESPONDLANGUAGE	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language	*
131	CORRESPONDLANGUAGE_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
132	PARTNERLANGUAGE	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	*
133	PARTNERLANGUAGE_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
134	NOTRELEASED	☐	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
135	SECONDNAME	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
136	CLASSIFICATION	☐	E_CLASSIFICATION	CHAR4	CHAR	4	0	Classification of Business Partner
137	VIP	☐	E_VIP	KENNZX	CHAR	1	0	Indicate Very Important Business Partner
138	IDENT_INSTALLER	☐	IDENT_INST	IDENT_INST	CHAR	18	0	Identification Number for Installer License
139	NATURALPERSON	☐	BU_NATURAL_PERSON	BU_NATURAL_PERSON	CHAR	1	0	Business Partner Is a Natural Person Under the Tax Laws
140	.INCLUDE	☐				0	0	Business Partner Bank Data for BAPIs
141	BKVID	☐	BU_BKVID	CHAR4	CHAR	4	0	Bank details ID
142	BANK_CTRY	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
143	BANK_CTRY_ISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
144	BANK_KEY	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
145	BANK_ACCT	☐	BANKN	BANKN	CHAR	18	0	Bank account number
146	CTRL_KEY	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
147	BANK_REF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
148	ACCOUNT_HOLDER	☐	BU_KOINH	BU_KOINH	CHAR	60	0	Account Holder Name
149	BANK_KEY_EXT	☐	BU_BKEXT	CHAR20	CHAR	20	0	Bank details ID in external system
150	COLL_AUTH	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
151	BANKACCOUNTNAME	☐	BU_BANKACCNAME	BU_BKCCNAME	CHAR	40	0	Name of Bank Account
152	BANKDETAILVALIDFROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
153	BANKDETAILVALIDTO	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
154	BANKDETAILMOVEDATE	☐	BU_MOVEDAT	DATUM	DATS	8	0	Date of Move
155	BANKDETAILMOVEID	☐	BU_MOVE_BKVID	CHAR4	CHAR	4	0	ID of Target Details for Change of Bank Details (BP)
156	.INCLUDE	☐				0	0	Business Partner Credit Card Data for BAPIs
157	CCARD_ID	☐	BU_CCID	CHAR6	CHAR	6	0	Payment Card ID
158	CCARD_INSTITUTE	☐	CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment card type	TB033
159	CCARD_NUMBER	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
160	CCARD_DEFAULT	☐	BU_CCDEF	XFELD	CHAR	1	0	BP: Standard Payment Card
161	CCARD_HOLDER	☐	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
162	CCARD_FROMDATE	☐	CC_DATAB	DATUM	DATS	8	0	Payment cards: Valid from
163	CCARD_TODATE	☐	CC_DATBI	DATUM	DATS	8	0	Payment Cards: Valid To
164	CCARD_EXP_DATE	☐	CC_AUSGDAT	DATUM	DATS	8	0	Payment Cards: Date of Issue
165	CCARD_ISS_BANK	☐	CC_ISSBANK	TEXT40	CHAR	40	0	Payment cards: Issuing bank
166	CCARD_CATEGORY	☐	CC_CCTYP	CCTYPE	CHAR	2	0	Payment cards: Card category	TB034
167	CCARD_REASON	☐	CC_LOCK	CC_LOCK	CHAR	2	0	Payment Cards: Reason for Payment Card Lock	*
168	PAYTYPE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EIAC_MOVE_IN	BANKS	T005	LAND1	REF	1	CN
2	EIAC_MOVE_IN	BANK_CTRY	T005	LAND1
3	EIAC_MOVE_IN	CCARD_CATEGORY	TB034	CCTYP
4	EIAC_MOVE_IN	CCARD_INSTITUTE	TB033	CCINS
5	EIAC_MOVE_IN	CCINS	TB033	CCINS
6	EIAC_MOVE_IN	DR_LICENSE_LAND1	T005	LAND1
7	EIAC_MOVE_IN	DR_LICENSE_REGIO	T005S	BLAND

History

Last changed by/on	SAP	20140121
SAP Release Created in