PARTNER |
Business Partner Number |
BU_PARTNER |
|
CHAR |
|
10 |
0 |
|
ADDRESS_TYPE |
Address Type |
BU_ADRKIND |
|
CHAR |
|
10 |
0 |
|
ADDRESS_PF |
|
ADRS_PRINT |
|
STRU |
|
0 |
0 |
|
LINE0 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE1 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE2 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE3 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE4 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE5 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE6 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE7 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE8 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
LINE9 |
Address line |
LINES |
|
CHAR |
|
80 |
0 |
|
ADDRESS_SF |
One-line short form of formatted address |
AD_LINE_S |
|
CHAR |
|
80 |
0 |
|
ADDRESS_SFS |
One-line short form of formatted address |
AD_LINE_S |
|
CHAR |
|
80 |
0 |
|
ADDRESS_DC |
Short form of the formatted address for the data medium |
AD_LINE_DC |
|
CHAR |
|
80 |
0 |
|
ADDRESS_DC0 |
Short form of the formatted address for the data medium |
AD_LINE_DC |
|
CHAR |
|
80 |
0 |
|
NOUL |
Number of lines in address |
ANZEI |
|
DEC |
|
2 |
0 |
|
ADDRESS_PF_TABLE |
|
CMS_TAB_ADDRESS_PFTLINE |
|
TTYP |
|
0 |
0 |
|
ADDRESS_PF_TABLE_10 |
|
CMS_TAB_ADDRESS_PFTLINE |
|
TTYP |
|
0 |
0 |
|
BUS020_EXT |
|
BUS020_EXT |
|
STRU |
|
0 |
0 |
|
PARTNER |
Business Partner Number |
BU_PARTNER |
|
CHAR |
|
10 |
0 |
|
ADDRNUMBER |
Address number |
AD_ADDRNUM |
|
CHAR |
|
10 |
0 |
|
XDFADR |
Indicator: Address is standard address |
BU_XDFADR |
|
CHAR |
|
1 |
0 |
Possible values
|
ADEXT |
Address number in external system |
BU_ADEXT |
|
CHAR |
|
20 |
0 |
|
NATION |
Version ID for International Addresses |
AD_NATION |
|
CHAR |
|
1 |
0 |
|
GUID |
UUID in character form |
SYSUUID_C |
|
CHAR |
|
32 |
0 |
|
MOVE_ADDR |
Number of Move Target Address for Address Moves |
BU_MOVE_ADDR |
|
CHAR |
|
10 |
0 |
|
DATE_FROM |
Date Obsolete |
BU_DATE_OBSOLETE |
|
DATS |
|
8 |
0 |
|
ADDRESS_GUID |
GUID of a Business Partner Address |
BU_ADDRESS_GUID |
|
RAW |
|
16 |
0 |
|
ADDR_VALID_FROM |
Validity Start of a Business Partner Address |
BU_ADDR_VALID_FROM |
|
DEC |
|
15 |
0 |
|
ADDR_VALID_TO |
Validity End of a Business Partner Address |
BU_ADDR_VALID_TO |
|
DEC |
|
15 |
0 |
|
ADDR_MOVE_DATE |
Date of Move for Address Moves |
BU_ADDR_MOVE_DATE |
|
DEC |
|
15 |
0 |
|
NAME_CO |
c/o name |
AD_NAME_CO |
|
CHAR |
|
40 |
0 |
|
CITY1 |
City |
AD_CITY1 |
|
CHAR |
|
40 |
0 |
|
CITY2 |
District |
AD_CITY2 |
|
CHAR |
|
40 |
0 |
|
CITY_CODE |
City code for city/street file |
AD_CITYNUM |
|
CHAR |
|
12 |
0 |
|
CITYP_CODE |
District code for City and Street file |
AD_CITYPNM |
|
CHAR |
|
8 |
0 |
|
HOME_CITY |
City (different from postal city) |
AD_CITY3 |
|
CHAR |
|
40 |
0 |
|
CITYH_CODE |
Different city for city/street file |
AD_CITYHNM |
|
CHAR |
|
12 |
0 |
|
CHCKSTATUS |
City file test status |
AD_CHECKST |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not checked |
C |
checked against city index |
D |
differs from city index |
|
REGIOGROUP |
Regional structure grouping |
REGIOGROUP |
|
CHAR |
|
8 |
0 |
|
POST_CODE1 |
City postal code |
AD_PSTCD1 |
|
CHAR |
|
10 |
0 |
|
POST_CODE2 |
PO Box Postal Code |
AD_PSTCD2 |
|
CHAR |
|
10 |
0 |
|
POST_CODE3 |
Company Postal Code (for Large Customers) |
AD_PSTCD3 |
|
CHAR |
|
10 |
0 |
|
PCODE1_EXT |
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code |
AD_PST1XT |
|
CHAR |
|
10 |
0 |
|
PCODE2_EXT |
(Not Supported) PO Box Postal Code Extension |
AD_PST2XT |
|
CHAR |
|
10 |
0 |
|
PCODE3_EXT |
(Not Supported) Major Customer Postal Code Extension |
AD_PST3XT |
|
CHAR |
|
10 |
0 |
|
PO_BOX |
PO Box |
AD_POBX |
|
CHAR |
|
10 |
0 |
|
DONT_USE_P |
PO Box Address Undeliverable Flag |
AD_NO_USEP |
|
CHAR |
|
4 |
0 |
|
PO_BOX_NUM |
Flag: PO Box Without Number |
AD_POBXNUM |
|
CHAR |
|
1 |
0 |
Possible values
|
PO_BOX_LOC |
PO Box city |
AD_POBXLOC |
|
CHAR |
|
40 |
0 |
|
CITY_CODE2 |
City PO box code (City file) |
AD_CIT2NUM |
|
CHAR |
|
12 |
0 |
|
PO_BOX_REG |
Region for PO Box (Country, State, Province, ...) |
AD_POBXREG |
|
CHAR |
|
3 |
0 |
|
PO_BOX_CTY |
PO box country |
AD_POBXCTY |
|
CHAR |
|
3 |
0 |
|
POSTALAREA |
(Not Supported) Post Delivery District |
AD_PSTLAR |
|
CHAR |
|
15 |
0 |
|
TRANSPZONE |
Transportation zone to or from which the goods are delivered |
LZONE |
|
CHAR |
|
10 |
0 |
|
STREET |
Street |
AD_STREET |
|
CHAR |
|
60 |
0 |
|
DONT_USE_S |
Street Address Undeliverable Flag |
AD_NO_USES |
|
CHAR |
|
4 |
0 |
|
STREETCODE |
Street Number for City/Street File |
AD_STRNUM |
|
CHAR |
|
12 |
0 |
|
STREETABBR |
(Not Supported) Abbreviation of Street Name |
AD_STRABBR |
|
CHAR |
|
2 |
0 |
|
HOUSE_NUM1 |
House Number |
AD_HSNM1 |
|
CHAR |
|
10 |
0 |
|
HOUSE_NUM2 |
House number supplement |
AD_HSNM2 |
|
CHAR |
|
10 |
0 |
|
HOUSE_NUM3 |
(Not supported) House Number Range |
AD_HSNM3 |
|
CHAR |
|
10 |
0 |
|
STR_SUPPL1 |
Street 2 |
AD_STRSPP1 |
|
CHAR |
|
40 |
0 |
|
STR_SUPPL2 |
Street 3 |
AD_STRSPP2 |
|
CHAR |
|
40 |
0 |
|
STR_SUPPL3 |
Street 4 |
AD_STRSPP3 |
|
CHAR |
|
40 |
0 |
|
LOCATION |
Street 5 |
AD_LCTN |
|
CHAR |
|
40 |
0 |
|
BUILDING |
Building (Number or Code) |
AD_BLDNG |
|
CHAR |
|
20 |
0 |
|
FLOOR |
Floor in building |
AD_FLOOR |
|
CHAR |
|
10 |
0 |
|
ROOMNUMBER |
Room or Appartment Number |
AD_ROOMNUM |
|
CHAR |
|
10 |
0 |
|
COUNTRY |
Country Key |
LAND1 |
|
CHAR |
|
3 |
0 |
|
LANGU |
Language Key |
SPRAS |
|
LANG |
|
1 |
0 |
|
REGION |
Region (State, Province, County) |
REGIO |
|
CHAR |
|
3 |
0 |
|
SORT1 |
Search Term 1 |
AD_SORT1UL |
|
CHAR |
|
20 |
0 |
|
SORT2 |
Search Term 2 |
AD_SORT2UL |
|
CHAR |
|
20 |
0 |
|
SORT_PHN |
(Not Supported) Phonetic Search Sort Field |
AD_SRTPHN |
|
CHAR |
|
20 |
0 |
|
ADDRORIGIN |
(Not Supported) Address Data Source (Key) |
AD_ORIGINA |
|
CHAR |
|
4 |
0 |
|
EXTENSION1 |
Extension (only for data conversion) (e.g. data line) |
AD_EXTENS1 |
|
CHAR |
|
40 |
0 |
|
EXTENSION2 |
Extension (only for data conversion) (e.g. telebox) |
AD_EXTENS2 |
|
CHAR |
|
40 |
0 |
|
TIME_ZONE |
Address time zone |
AD_TZONE |
|
CHAR |
|
6 |
0 |
|
TAXJURCODE |
Tax Jurisdiction |
AD_TXJCD |
|
CHAR |
|
15 |
0 |
|
ADDRESS_ID |
(Not supported) Physical address ID |
AD_ADDR_ID |
|
CHAR |
|
10 |
0 |
|
REMARK |
Address notes |
AD_REMARK1 |
|
CHAR |
|
50 |
0 |
|
LANGU_CREA |
Address record creation original language |
AD_LANGUCR |
|
LANG |
|
1 |
0 |
|
PO_BOX_LOBBY |
PO Box Lobby |
AD_PO_BOX_LBY |
|
CHAR |
|
40 |
0 |
|
DELI_SERV_TYPE |
Type of Delivery Service |
AD_DELIVERY_SERVICE_TYPE |
|
CHAR |
|
4 |
0 |
|
DELI_SERV_NUMBER |
Number of Delivery Service |
AD_DELIVERY_SERVICE_NUMBER |
|
CHAR |
|
10 |
0 |
|
COUNTY_CODE |
County code for county |
AD_CNTYNUM |
|
CHAR |
|
8 |
0 |
|
COUNTY |
County |
AD_COUNTY |
|
CHAR |
|
40 |
0 |
|
TOWNSHIP_CODE |
Township code for Township |
AD_TWSHPNUM |
|
CHAR |
|
8 |
0 |
|
TOWNSHIP |
Township |
AD_TOWNSHIP |
|
CHAR |
|
40 |
0 |
|
DEFLT_COMM |
Standard communication type |
AD_DFLTCMM |
|
CHAR |
|
3 |
0 |
|
TEL_NUMBER |
Telephone no.: dialling code+number |
AD_TLNMBR |
|
CHAR |
|
30 |
0 |
|
TEL_EXTENS |
Telephone no.: Extension |
AD_TLXTNS |
|
CHAR |
|
10 |
0 |
|
FAX_NUMBER |
Fax number: dialling code+number |
AD_FXNMBR |
|
CHAR |
|
30 |
0 |
|
FAX_EXTENS |
Fax no.: Extension |
AD_FXXTNS |
|
CHAR |
|
10 |
0 |
|
VALID_FROM |
Valid From |
BU_VALID_FROM_DATS |
|
DATS |
|
8 |
0 |
|
VALID_TO |
Valid To |
BU_VALID_TO_DATS |
|
DATS |
|
8 |
0 |
|