1 |
MANDT |
/SAPSLL/ADRCON |
MANDT |
|
|
MANDT |
|
Client |
2 |
PARTNER |
BUT020 |
PARTNER |
|
|
BU_PARTNER |
|
Business Partner Number |
3 |
ADDRNUMBER |
BUT020 |
ADDRNUMBER |
|
|
AD_ADDRNUM |
|
Address number |
4 |
ERNAM |
/SAPSLL/ADRCON |
ERNAM |
|
|
/SAPSLL/ERNAM |
|
Name of User Who Created the Object |
5 |
CRTSP |
/SAPSLL/ADRCON |
CRTSP |
|
|
/SAPSLL/CRTSP |
|
Date and Time When Object Was Added |
6 |
AENAM |
/SAPSLL/ADRCON |
AENAM |
|
|
/SAPSLL/AENAM |
|
Name of User Who Changed the Object |
7 |
CHTSP |
/SAPSLL/ADRCON |
CHTSP |
|
|
/SAPSLL/CHTSP |
|
Date and Time When Object Was Changed |
8 |
ADRNR |
/SAPSLL/ADRCON |
ADRNR |
|
|
/SAPSLL/ADRNR |
|
Address Number of Entry in Address File |
9 |
LGREG |
/SAPSLL/ADRCON |
LGREG |
|
|
/SAPSLL/LGREG |
|
Legal Regulation |
10 |
DATBI |
/SAPSLL/ADRCON |
DATBI |
|
|
/SAPSLL/RPTET |
|
Definitive Date (Valid-To Date) |
11 |
DATAB |
/SAPSLL/ADRCON |
DATAB |
|
|
/SAPSLL/RPTST |
|
Definitive Date (Valid-From Time) |
12 |
PIDEX |
/SAPSLL/ADRCON |
PIDEX |
|
|
/SAPSLL/PIDEX |
|
External Identification of Customs Business Partner |
13 |
SPL_CHK_DATE |
/SAPSLL/ADRCON |
SPL_CHK_DATE |
|
|
/SAPSLL/SPLCT |
|
Date of Sanctioned Party List Screening |
14 |
SPL_CHK_POSITIVE |
/SAPSLL/ADRCON |
SPL_CHK_POSITIVE |
|
|
/SAPSLL/SPLCO |
|
Indicator: Address Appears in Sanction List |
15 |
SPLPN |
/SAPSLL/ADRCON |
SPLPN |
|
|
/SAPSLL/SPLPN |
|
Flagged on Positive/Negative List |
16 |
SPLIB |
/SAPSLL/ADRCON |
SPLIB |
|
|
/SAPSLL/SPLIB |
|
Indicator for "Indirectly Locked" |
17 |
GUID_ADRCON |
/SAPSLL/ADRCON |
GUID_ADRCON |
|
|
/SAPSLL/GUID_16 |
|
Primary Key as GUID in 'RAW' Format |
18 |
MCUSE |
/SAPSLL/ADRCON |
MCUSE |
|
|
/SAPSLL/MCUSE |
|
Military / Civilian Usage Indicator |
19 |
BPCCB |
/SAPSLL/ADRCON |
BPCCB |
|
|
/SAPSLL/BPCCB |
|
Indicator for Chemical/Biological Warfare |
20 |
BPCNT |
/SAPSLL/ADRCON |
BPCNT |
|
|
/SAPSLL/BPCNT |
|
Nuclear Nonproliferation Indicator |
21 |
BPCMT |
/SAPSLL/ADRCON |
BPCMT |
|
|
/SAPSLL/BPCMT |
|
Indicator for Missile Technology |
22 |
BPCNS |
/SAPSLL/ADRCON |
BPCNS |
|
|
/SAPSLL/BPCNS |
|
Indicator for National Security |
23 |
BPCDR |
/SAPSLL/ADRCON |
BPCDR |
|
|
/SAPSLL/BPCDR |
|
Indicator for Drug Products |
24 |
CRECO |
/SAPSLL/ADRCON |
CRECO |
|
|
/SAPSLL/CRECO |
|
Method of Entry |
25 |
MOBJT |
/SAPSLL/ADRCON |
MOBJT |
|
|
/SAPSLL/MOBJT |
|
Type of Main Object |
26 |
GUID_MOBJ |
/SAPSLL/ADRCON |
GUID_MOBJ |
|
|
/SAPSLL/MOBJ_GUID_16 |
|
Primary Key of Main Object |
27 |
POBJT |
/SAPSLL/ADRCON |
POBJT |
|
|
/SAPSLL/POBJT |
|
Type of Preceding Object |
28 |
GUID_POBJ |
/SAPSLL/ADRCON |
GUID_POBJ |
|
|
/SAPSLL/POBJ_GUID_16 |
|
Primary Key of Preceding Object |
29 |
PARTNER_GUID |
BUT000 |
PARTNER_GUID |
|
|
BU_PARTNER_GUID |
|
Business Partner GUID |
30 |
CRUSR |
BUT000 |
CRUSR |
|
|
BU_CRUSR |
|
User who created the object |
31 |
CRDAT |
BUT000 |
CRDAT |
|
|
BU_CRDAT |
|
Date on which the object was created |
32 |
CHUSR |
BUT000 |
CHUSR |
|
|
BU_CHUSR |
|
Last user to change object |
33 |
CHDAT |
BUT000 |
CHDAT |
|
|
BU_CHDAT |
|
Date when object was last changed |
34 |
XDFADR |
BUT020 |
XDFADR |
|
|
BU_XDFADR |
|
Indicator: Address is standard address |
35 |
ADEXT |
BUT020 |
ADEXT |
|
|
BU_ADEXT |
|
Address number in external system |
36 |
GUID |
BUT020 |
GUID |
|
|
SYSUUID_C |
|
UUID in character form |
37 |
ADDRESS_GUID |
BUT020 |
ADDRESS_GUID |
|
|
BU_ADDRESS_GUID |
|
GUID of a Business Partner Address |
38 |
GRVSY |
/SAPSLL/PNTBP |
GRVSY |
|
|
/SAPSLL/GRVSY |
|
Logical System Group |
39 |
BPTYP |
/SAPSLL/PNTBP |
BPTYP |
|
|
/SAPSLL/BPTYP |
|
Business Partner Category in Feeder System |
40 |
BPVSY |
/SAPSLL/PNTBP |
BPVSY |
|
|
/SAPSLL/BPVSY |
|
External Business Partner Number |
41 |
GUID_PRTN |
/SAPSLL/PNTBP |
GUID_PRTN |
|
|
/SAPSLL/PRTN_GUID_16 |
|
Primary Key of Business Partner |
42 |
GUID_BPVSY |
/SAPSLL/PNTBP |
GUID_BPVSY |
|
|
/SAPSLL/GUID_16 |
|
Primary Key as GUID in 'RAW' Format |
43 |
NATION |
ADRC |
NATION |
|
|
AD_NATION |
|
Version ID for International Addresses |
44 |
DATE_TO |
ADRC |
DATE_TO |
|
|
AD_DATE_TO |
|
Valid-to date in current Release only 99991231 possible |
45 |
TITLE |
ADRC |
TITLE |
|
|
AD_TITLE |
|
Form-of-Address Key |
46 |
NAME1 |
ADRC |
NAME1 |
|
|
AD_NAME1 |
|
Name 1 |
47 |
NAME2 |
ADRC |
NAME2 |
|
|
AD_NAME2 |
|
Name 2 |
48 |
NAME3 |
ADRC |
NAME3 |
|
|
AD_NAME3 |
|
Name 3 |
49 |
NAME4 |
ADRC |
NAME4 |
|
|
AD_NAME4 |
|
Name 4 |
50 |
NAME_TEXT |
ADRC |
NAME_TEXT |
|
|
AD_NAMETXT |
|
Converted name field (with form of address) |
51 |
NAME_CO |
ADRC |
NAME_CO |
|
|
AD_NAME_CO |
|
c/o name |
52 |
CITY1 |
ADRC |
CITY1 |
|
|
AD_CITY1 |
|
City |
53 |
CITY2 |
ADRC |
CITY2 |
|
|
AD_CITY2 |
|
District |
54 |
CITY_CODE |
ADRC |
CITY_CODE |
|
|
AD_CITYNUM |
|
City code for city/street file |
55 |
CITYP_CODE |
ADRC |
CITYP_CODE |
|
|
AD_CITYPNM |
|
District code for City and Street file |
56 |
HOME_CITY |
ADRC |
HOME_CITY |
|
|
AD_CITY3 |
|
City (different from postal city) |
57 |
CITYH_CODE |
ADRC |
CITYH_CODE |
|
|
AD_CITYHNM |
|
Different city for city/street file |
58 |
CHCKSTATUS |
ADRC |
CHCKSTATUS |
|
|
AD_CHECKST |
|
City file test status |
59 |
REGIOGROUP |
ADRC |
REGIOGROUP |
|
|
REGIOGROUP |
|
Regional structure grouping |
60 |
POST_CODE1 |
ADRC |
POST_CODE1 |
|
|
AD_PSTCD1 |
|
City postal code |
61 |
POST_CODE2 |
ADRC |
POST_CODE2 |
|
|
AD_PSTCD2 |
|
PO Box postal code |
62 |
POST_CODE3 |
ADRC |
POST_CODE3 |
|
|
AD_PSTCD3 |
|
Company postal code (for large customers) |
63 |
PCODE1_EXT |
ADRC |
PCODE1_EXT |
|
|
AD_PST1XT |
|
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code |
64 |
PCODE2_EXT |
ADRC |
PCODE2_EXT |
|
|
AD_PST2XT |
|
(Not Supported) PO Box Postal Code Extension |
65 |
PCODE3_EXT |
ADRC |
PCODE3_EXT |
|
|
AD_PST3XT |
|
(Not Supported) Major Customer Postal Code Extension |
66 |
PO_BOX |
ADRC |
PO_BOX |
|
|
AD_POBX |
|
PO Box |
67 |
DONT_USE_P |
ADRC |
DONT_USE_P |
|
|
AD_NO_USEP |
|
PO Box Address Undeliverable Flag |
68 |
PO_BOX_NUM |
ADRC |
PO_BOX_NUM |
|
|
AD_POBXNUM |
|
Flag: PO Box without number |
69 |
PO_BOX_LOC |
ADRC |
PO_BOX_LOC |
|
|
AD_POBXLOC |
|
PO Box city |
70 |
CITY_CODE2 |
ADRC |
CITY_CODE2 |
|
|
AD_CIT2NUM |
|
City PO box code (City file) |
71 |
PO_BOX_REG |
ADRC |
PO_BOX_REG |
|
|
AD_POBXREG |
|
Region for PO Box (Country, State, Province, ...) |
72 |
PO_BOX_CTY |
ADRC |
PO_BOX_CTY |
|
|
AD_POBXCTY |
|
PO box country |
73 |
POSTALAREA |
ADRC |
POSTALAREA |
|
|
AD_PSTLAR |
|
(Not Supported) Post Delivery District |
74 |
TRANSPZONE |
ADRC |
TRANSPZONE |
|
|
LZONE |
|
Transportation zone to or from which the goods are delivered |
75 |
STREET |
ADRC |
STREET |
|
|
AD_STREET |
|
Street |
76 |
DONT_USE_S |
ADRC |
DONT_USE_S |
|
|
AD_NO_USES |
|
Street Address Undeliverable Flag |
77 |
STREETCODE |
ADRC |
STREETCODE |
|
|
AD_STRNUM |
|
Street Number for City/Street File |
78 |
STREETABBR |
ADRC |
STREETABBR |
|
|
AD_STRABBR |
|
(Not Supported) Abbreviation of Street Name |
79 |
HOUSE_NUM1 |
ADRC |
HOUSE_NUM1 |
|
|
AD_HSNM1 |
|
House Number |
80 |
HOUSE_NUM2 |
ADRC |
HOUSE_NUM2 |
|
|
AD_HSNM2 |
|
House number supplement |
81 |
HOUSE_NUM3 |
ADRC |
HOUSE_NUM3 |
|
|
AD_HSNM3 |
|
(Not supported) House Number Range |
82 |
STR_SUPPL1 |
ADRC |
STR_SUPPL1 |
|
|
AD_STRSPP1 |
|
Street 2 |
83 |
STR_SUPPL2 |
ADRC |
STR_SUPPL2 |
|
|
AD_STRSPP2 |
|
Street 3 |
84 |
STR_SUPPL3 |
ADRC |
STR_SUPPL3 |
|
|
AD_STRSPP3 |
|
Street 4 |
85 |
LOCATION |
ADRC |
LOCATION |
|
|
AD_LCTN |
|
Street 5 |
86 |
BUILDING |
ADRC |
BUILDING |
|
|
AD_BLDNG |
|
Building (Number or Code) |
87 |
FLOOR |
ADRC |
FLOOR |
|
|
AD_FLOOR |
|
Floor in building |
88 |
ROOMNUMBER |
ADRC |
ROOMNUMBER |
|
|
AD_ROOMNUM |
|
Room or Appartment Number |
89 |
COUNTRY |
ADRC |
COUNTRY |
|
|
LAND1 |
|
Country Key |
90 |
LANGU |
ADRC |
LANGU |
|
|
SPRAS |
|
Language Key |
91 |
REGION |
ADRC |
REGION |
|
|
REGIO |
|
Region (State, Province, County) |
92 |
ADDR_GROUP |
ADRC |
ADDR_GROUP |
|
|
AD_GROUP |
|
Address Group (Key) (Business Address Services) |
93 |
FLAGGROUPS |
ADRC |
FLAGGROUPS |
|
|
AD_FLGGP |
|
Flag: There are more address group assignments |
94 |
PERS_ADDR |
ADRC |
PERS_ADDR |
|
|
AD_PRSADDR |
|
Flag: This is a personal address |
95 |
SORT1 |
ADRC |
SORT1 |
|
|
AD_SORT1 |
|
Search Term 1 |
96 |
SORT2 |
ADRC |
SORT2 |
|
|
AD_SORT2 |
|
Search Term 2 |
97 |
SORT_PHN |
ADRC |
SORT_PHN |
|
|
AD_SRTPHN |
|
(Not Supported) Phonetic Search Sort Field |
98 |
DEFLT_COMM |
ADRC |
DEFLT_COMM |
|
|
AD_COMM |
|
Communication Method (Key) (Business Address Services) |
99 |
TEL_NUMBER |
ADRC |
TEL_NUMBER |
|
|
AD_TLNMBR1 |
|
First telephone no.: dialling code+number |
100 |
TEL_EXTENS |
ADRC |
TEL_EXTENS |
|
|
AD_TLXTNS1 |
|
First Telephone No.: Extension |
101 |
FAX_NUMBER |
ADRC |
FAX_NUMBER |
|
|
AD_FXNMBR1 |
|
First fax no.: dialling code+number |
102 |
FAX_EXTENS |
ADRC |
FAX_EXTENS |
|
|
AD_FXXTNS1 |
|
First fax no.: extension |
103 |
FLAGCOMM2 |
ADRC |
FLAGCOMM2 |
|
|
AD_FLGCM02 |
|
Flag: Telephone number(s) maintained |
104 |
FLAGCOMM3 |
ADRC |
FLAGCOMM3 |
|
|
AD_FLGCM03 |
|
Flag: Fax number(s) maintained |
105 |
FLAGCOMM4 |
ADRC |
FLAGCOMM4 |
|
|
AD_FLGCM04 |
|
Flag: Teletex number(s) maintained |
106 |
FLAGCOMM5 |
ADRC |
FLAGCOMM5 |
|
|
AD_FLGCM05 |
|
Flag: Telex number(s) maintained |
107 |
FLAGCOMM6 |
ADRC |
FLAGCOMM6 |
|
|
AD_FLGCM06 |
|
Indicator: E-Mail Address(es) Maintained |
108 |
FLAGCOMM7 |
ADRC |
FLAGCOMM7 |
|
|
AD_FLGCM07 |
|
Flag: RML (remote mail) addresse(s) maintained |
109 |
FLAGCOMM8 |
ADRC |
FLAGCOMM8 |
|
|
AD_FLGCM08 |
|
Flag: X.400 addresse(s) maintained |
110 |
FLAGCOMM9 |
ADRC |
FLAGCOMM9 |
|
|
AD_FLGCM09 |
|
Flag: RFC destination(s) maintained |
111 |
FLAGCOMM10 |
ADRC |
FLAGCOMM10 |
|
|
AD_FLGCM10 |
|
Flag: Printer maintained |
112 |
FLAGCOMM11 |
ADRC |
FLAGCOMM11 |
|
|
AD_FLGCM11 |
|
Flag: SSF maintained |
113 |
FLAGCOMM12 |
ADRC |
FLAGCOMM12 |
|
|
AD_FLGCM12 |
|
Flag: URI/FTP address maintained |
114 |
FLAGCOMM13 |
ADRC |
FLAGCOMM13 |
|
|
AD_FLGCM13 |
|
Flag: Pager address maintained |
115 |
ADDRORIGIN |
ADRC |
ADDRORIGIN |
|
|
AD_ORIGINA |
|
(Not Supported) Address Data Source (Key) |
116 |
MC_NAME1 |
ADRC |
MC_NAME1 |
|
|
AD_MC_NAME |
|
Name (field NAME1) in upper case for matchcode |
117 |
MC_CITY1 |
ADRC |
MC_CITY1 |
|
|
AD_MC_CITY |
|
City name in upper case for search help |
118 |
MC_STREET |
ADRC |
MC_STREET |
|
|
AD_MC_STRT |
|
Street name in upper case for search help |
119 |
EXTENSION1 |
ADRC |
EXTENSION1 |
|
|
AD_EXTENS1 |
|
Extension (only for data conversion) (e.g. data line) |
120 |
EXTENSION2 |
ADRC |
EXTENSION2 |
|
|
AD_EXTENS2 |
|
Extension (only for data conversion) (e.g. telebox) |
121 |
TIME_ZONE |
ADRC |
TIME_ZONE |
|
|
AD_TZONE |
|
Address time zone |
122 |
TAXJURCODE |
ADRC |
TAXJURCODE |
|
|
AD_TXJCD |
|
Tax Jurisdiction |
123 |
ADDRESS_ID |
ADRC |
ADDRESS_ID |
|
|
AD_ADDR_ID |
|
(Not supported) Physical address ID |
124 |
LANGU_CREA |
ADRC |
LANGU_CREA |
|
|
AD_LANGUCR |
|
Address record creation original language |
125 |
DATE_FROM |
ADRC |
DATE_FROM |
|
|
AD_DATE_FR |
|
Valid-from date - in current Release only 00010101 possible |
|
|
|
|
|
|
|
|
|