/SCWM/ESI_BPART - Partner Data for a Parcel

Partner Data for a Parcel information is stored in SAP table /SCWM/ESI_BPART.
It is part of development package /SCWM/ESI in software component SCM-EWM-SR. This development package consists of objects that can be grouped under "Express Delivery Company Interface".

Fields for table /SCWM/ESI_BPART

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		/SCWM/S_ESI_KEYITM	0
.INCLUDE		X		/SCWM/S_ESI_KEY	0
CLIENT	Client	X	MANDT	CLNT	6	*
GUID_ESI	Unique Internal Identification for Parcel/Label	X	/SCWM/DE_GUID_ESI	RAW	16
ITMID	Item Number (Internal)	X	/SCWM/DE_ESI_ITMID	NUMC	12
.INCLUDE				/SCWM/S_ESI_PARTNER	0
PARTNER_ROLE	Partner Role		/SCWM/DE_ESI_PARTNER_ROLE	CHAR	4
.INCLUDE				/SCWM/S_ESI_ADRESS	0
ADDR_NO	Address Number		AD_ADDRNUM	CHAR	20	*
FORMOFADDR	Form of address text		AD_TITLE_T	CHAR	40
NAME	Name 1		AD_NAME1	CHAR	80
NAME_2	Name 2		AD_NAME2	CHAR	80
NAME_3	Name 3		AD_NAME3	CHAR	80
NAME_4	Name 4		AD_NAME4	CHAR	80
C_O_NAME	c/o name		AD_NAME_CO	CHAR	80
CITY	City		AD_CITY1	CHAR	80
DISTRICT	District		AD_CITY2	CHAR	80
CITY_NO	City code for city/street file		AD_CITYNUM	CHAR	24	*
POSTL_COD1	City postal code		AD_PSTCD1	CHAR	20
POSTL_COD2	PO Box Postal Code		AD_PSTCD2	CHAR	20
POSTL_COD3	Company Postal Code (for Large Customers)		AD_PSTCD3	CHAR	20
PO_BOX	PO Box		AD_POBX	CHAR	20
PO_BOX_CIT	PO Box city		AD_POBXLOC	CHAR	80
DELIV_DIS	(Not Supported) Post Delivery District		AD_PSTLAR	CHAR	30
STREET	Street		AD_STR_OLD	CHAR	80
STREET_NO	Street Number for City/Street File		AD_STRNUM	CHAR	24	*
STR_ABBR	(Not Supported) Abbreviation of Street Name		AD_STRABBR	CHAR	4	*
HOUSE_NO	House Number		AD_HSNM1	CHAR	20
STR_SUPPL1	Street 2		AD_STRSPP1	CHAR	80
STR_SUPPL2	Street 3		AD_STRSPP2	CHAR	80
LOCATION	Street 5		AD_LCTN	CHAR	80
BUILDING	old: building (no. or abbreviation)		AD_BLD_OLD	CHAR	20
FLOOR	Floor in building		AD_FLOOR	CHAR	20
ROOM_NO	Room or Apartment Number		AD_ROOMNUM	CHAR	20
COUNTRY	Country/Region Key		LAND1	CHAR	6	T005
LANGU	Language Key		SPRAS	LANG	2	T002
REGION	Region (State, Province, County)		REGIO	CHAR	6	T005S
SORT1	Search Term 1		AD_SORT1	CHAR	40
SORT2	Search Term 2		AD_SORT2	CHAR	40
TIME_ZONE	Address time zone		AD_TZONE	CHAR	12	TTZZ
TAXJURCODE	Tax Jurisdiction		AD_TXJCD	CHAR	30
ADR_NOTES	Address notes		AD_REMARK1	CHAR	100
COMM_TYPE	Communication Method (Key) (Business Address Services)		AD_COMM	CHAR	6	TSAC
TEL1_NUMBR	First telephone no.: dialling code+number		AD_TLNMBR1	CHAR	60
TEL1_EXT	First Telephone No.: Extension		AD_TLXTNS1	CHAR	20
FAX_NUMBER	First Fax No.: Area Code + Number		AD_FXNMBR1	CHAR	60
FAX_EXTENS	First fax no.: extension		AD_FXXTNS1	CHAR	20
STREET_LNG	Street		AD_STREET	CHAR	120
DISTRCT_NO	District code for City and Street file		AD_CITYPNM	CHAR	16	*
CHCKSTATUS	City file test status		AD_CHECKST	CHAR	2
PBOXCIT_NO	City PO box code (City file)		AD_CIT2NUM	CHAR	24	*
TRANSPZONE	Transportation zone to or from which the goods are delivered		LZONE	CHAR	20	TZONE
HOUSE_NO2	House number supplement		AD_HSNM2	CHAR	20
E_MAIL	E-Mail Address		AD_SMTPADR	CHAR	482
STR_SUPPL3	Street 4		AD_STRSPP3	CHAR	80
TITLE	Title text		AD_TITLETX	CHAR	60
COUNTRYISO	ISO Code of the Country/Region		INTCA	CHAR	4
LANGU_ISO	2-Character SAP Language Code		LAISO	CHAR	4
BUILD_LONG	Building (Number or Code)		AD_BLDNG	CHAR	40
REGIOGROUP	Regional structure grouping		REGIOGROUP	CHAR	16	*
HOME_CITY	City (different from postal city)		AD_CITY3	CHAR	80
HOMECITYNO	Different city for city/street file		AD_CITYHNM	CHAR	24	*
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code		AD_PST1XT	CHAR	20
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension		AD_PST2XT	CHAR	20
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension		AD_PST3XT	CHAR	20
PO_W_O_NO	Flag: PO Box Without Number		AD_POBXNUM	CHAR	2
PO_BOX_REG	Region for PO Box (Country/Region, State, Province, ...)		AD_POBXREG	CHAR	6	*
POBOX_CTRY	PO Box of Country/Region		AD_POBXCTY	CHAR	6	*
PO_CTRYISO	ISO Code of the Country/Region		INTCA	CHAR	4
HOMEPAGE	URI, e.g. Homepage or ftp Address		AD_URISCR	CHAR	264
DONT_USE_S	Street Address Undeliverable Flag		AD_NO_USES	CHAR	8	TSAD12
DONT_USE_P	PO Box Address Undeliverable Flag		AD_NO_USEP	CHAR	8	TSAD12
HOUSE_NO3	(Not supported) House Number Range		AD_HSNM3	CHAR	20