SAP ABAP Table WIC_CUSTOMER (Screen Structure IAC Online Store: Customer (Address Data))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PCT (Application Component) Product Catalog
     ⤷ WWMB (Package) Advertising medium: BAPI & IAC prod.catalog

Basic Data

Table Category	INTTAB	Structure
Structure	WIC_CUSTOMER	Table Relationship Diagram
Short Description	Screen Structure IAC Online Store: Customer (Address 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	.INCLUDE	☐				0	0	Customer Data Structure for BAPIs for BO Customer
2	TITLE_P	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
3	FIRSTNAME	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
4	LASTNAME	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
5	MIDDLENAME	☐	AD_NAMEMID	TEXT40	CHAR	40	0	Middle name or second forename of a person
6	SECONDNAME	☐	AD_NAMLAS2	TEXT40	CHAR	40	0	Second surname of a person
7	DATE_BIRTH	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
8	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
9	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
10	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
11	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
12	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
13	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
14	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
15	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
16	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
17	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
18	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
19	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
20	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
21	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
22	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
23	TEL1_EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
24	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
25	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
26	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
27	LANGU_P	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
28	LANGUP_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
29	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
30	CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
31	TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
32	ONLY_CHANGE_COMADDRESS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
33	NO_NAME	☐	XFELD	XFELD	CHAR	1	0	Checkbox
34	NO_VALID_D	☐	XFELD	XFELD	CHAR	1	0	Checkbox
35	NO_CITY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
36	NO_COUNTRY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
37	NO_REGION	☐	XFELD	XFELD	CHAR	1	0	Checkbox
38	NO_EMAIL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
39	DATE_FORMAT	☐	XUDATFM	XUDATFM	CHAR	1	0	Date format
40	CREATE_CHANGE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
41	COUNTRY_DESCR	☐	LANDX	TEXT15	CHAR	15	0	Country Name
42	COMPANY_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
43	COMPANY_NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
44	COMPANY_NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
45	COMPANY_NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
46	COMPANY_C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
47	NO_NAME_COMPANY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
48	ADDR_TYPE	☐	ADDR_TYPE	ADDR_TYPE	CHAR	1	0	Addresses: Address type
49	DIFFER_SHIP_TO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
50	CHANGE_SHIPTO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
51	CHANGE_BILLTO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
52	NO_REGISTRATION	☐	XFELD	XFELD	CHAR	1	0	Checkbox
53	SHIP_EQUAL_BILL	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WIC_CUSTOMER	COUNTRY	T005	LAND1
2	WIC_CUSTOMER	CURRENCY	TCURC	WAERS
3	WIC_CUSTOMER	LANGU_P	T002	SPRAS
4	WIC_CUSTOMER	REGION	T005S	BLAND
5	WIC_CUSTOMER	TITLE_KEY	TSAD3	TITLE

History

Last changed by/on	SAP	20140121
SAP Release Created in