/SCWM/ESI_BPART

Partner Data for a Parcel | #transactional | #language | Component: Shipping and Receiving
Column Name Description
CLIENT Client
GUID_ESI Unique Internal Identification for Parcel/Label
ITMID Item Number (Internal)
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CHCKSTATUS City file test status Show values
PO_W_O_NO Flag: PO Box Without Number Show values
Column Name Description Domain name
PARTNER_ROLE Partner Role
FORMOFADDR Form of address text TEXT20
NAME Name 1 TEXT40
NAME_2 Name 2 TEXT40
NAME_3 Name 3 TEXT40
NAME_4 Name 4 TEXT40
C_O_NAME c/o name TEXT40
CITY City TEXT40
DISTRICT District TEXT40
POSTL_COD1 City postal code CHAR10
POSTL_COD2 PO Box Postal Code CHAR10
POSTL_COD3 Company Postal Code (for Large Customers) CHAR10
PO_BOX PO Box CHAR10
PO_BOX_CIT PO Box city TEXT40
DELIV_DIS (Not Supported) Post Delivery District TEXT15
STREET Street TEXT40
HOUSE_NO House Number TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
LOCATION Street 5 TEXT40
BUILDING old: building (no. or abbreviation) TEXT10
FLOOR Floor in building TEXT10
ROOM_NO Room or Apartment Number TEXT10
SORT1 Search Term 1 CHAR20
SORT2 Search Term 2 CHAR20
TAXJURCODE Tax Jurisdiction AD_TXJCD
ADR_NOTES Address notes TEXT50
TEL1_NUMBR First telephone no.: dialling code+number CHAR30
TEL1_EXT First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
STREET_LNG Street TEXT60
HOUSE_NO2 House number supplement TEXT10
E_MAIL E-Mail Address AD_SMTPADR
STR_SUPPL3 Street 4 TEXT40
TITLE Title text TEXT30
COUNTRYISO ISO Code of the Country/Region INTCA
LANGU_ISO 2-Character SAP Language Code LAISO
BUILD_LONG Building (Number or Code) TEXT20
HOME_CITY City (different from postal city) TEXT40
HOMECITYNO Different city for city/street file CITY_CODE
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR10
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR10
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR10
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) REGIO
POBOX_CTRY PO Box of Country/Region LAND1
PO_CTRYISO ISO Code of the Country/Region INTCA
HOMEPAGE URI, e.g. Homepage or ftp Address AD_URISCR
HOUSE_NO3 (Not supported) House Number Range TEXT10
Master Data Relations Join Conditions
Communication Method (Key) (Business Address Services) /SCWM/ESI_BPART.COMM_TYPE == TSAC.COMM_TYPE
Country/Region Key
  • Country/Region Key
  • Client
  • /SCWM/ESI_BPART.COUNTRY == T005.LAND1
  • /SCWM/ESI_BPART.CLIENT == T005.MANDT
Reason for Non-Delivery
  • /SCWM/ESI_BPART.CLIENT == TSAD12.CLIENT
  • /SCWM/ESI_BPART.DONT_USE_P == TSAD12.UNDELIVER
Reason for Non-Delivery
  • /SCWM/ESI_BPART.CLIENT == TSAD12.CLIENT
  • /SCWM/ESI_BPART.DONT_USE_S == TSAD12.UNDELIVER
Language Key /SCWM/ESI_BPART.LANGU == T002.SPRAS
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • /SCWM/ESI_BPART.CLIENT == T005S.MANDT
  • /SCWM/ESI_BPART.COUNTRY == T005S.LAND1
  • /SCWM/ESI_BPART.REGION == T005S.BLAND
Address time zone
  • /SCWM/ESI_BPART.CLIENT == TTZZ.CLIENT
  • /SCWM/ESI_BPART.TIME_ZONE == TTZZ.TZONE
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • /SCWM/ESI_BPART.COUNTRY == TZONE.LAND1
  • /SCWM/ESI_BPART.CLIENT == TZONE.MANDT
  • /SCWM/ESI_BPART.TRANSPZONE == TZONE.ZONE1