1. Home
  2. Resources
  3. SAP Tables
  4. REBW_ADRC - RE BW: Extract structure addressees

SAP Table REBW_ADRC

RE BW: Extract structure addressees

REBW_ADRC (RE BW: Extract structure addressees) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link REBW_ADRC to other SAP tables.

Source: REBW_ADRC (RE BW: Extract structure addressees)

REBW_ADRC table fields

Field Data element Checktable Datatype Length Decimals
BUKRS Company Code BUKRS CHAR 4 0
SWENR Site Number SWENR CHAR 8 0
SGENR Building Number SGENR CHAR 8 0
SGRNR Property Number for BE SGRNR CHAR 8 0
REOBJ BW RE: InfoObject Real Estate Object (WE, GE, GR) REOBJ CHAR 22 0
SMENR Number of Rental Unit SMENR CHAR 8 0
SMIVE Lease-Out Number SMIVE CHAR 13 0
CLIENT Client MANDT CLNT 3 0
ADDRNUMBER Address number AD_ADDRNUM CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
NATION Version ID for International Addresses AD_NATION CHAR 1 0
DATE_TO Valid-to date in current Release only 99991231 possible AD_DATE_TO DATS 8 0
TITLE Form-of-Address Key AD_TITLE CHAR 4 0
NAME1 Name 1 AD_NAME1 CHAR 40 0
NAME2 Name 2 AD_NAME2 CHAR 40 0
NAME3 Name 3 AD_NAME3 CHAR 40 0
NAME4 Name 4 AD_NAME4 CHAR 40 0
NAME_TEXT Converted name field (with form of address) AD_NAMETXT CHAR 50 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
CHCKSTATUS City file test status AD_CHECKST CHAR 1 0
NULL Not checked
C checked against city index
D differs from city index
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
PO_BOX PO Box AD_POBX CHAR 10 0
PO_BOX_NUM Flag: PO Box Without Number AD_POBXNUM CHAR 1 0
X Yes
NULL No
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
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
ADDR_GROUP Address Group (Key) (Business Address Services) AD_GROUP CHAR 4 0
PERS_ADDR Flag: This is a personal address AD_PRSADDR CHAR 1 0
X Yes
NULL No
SORT1 Search Term 1 AD_SORT1 CHAR 20 0
SORT2 Search Term 2 AD_SORT2 CHAR 20 0
SORT_PHN (Not Supported) Phonetic Search Sort Field AD_SRTPHN CHAR 20 0
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM CHAR 3 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
TEL_EXTENS First Telephone No.: Extension AD_TLXTNS1 CHAR 10 0
FAX_NUMBER First fax no.: dialling code+number AD_FXNMBR1 CHAR 30 0
FAX_EXTENS First fax no.: extension AD_FXXTNS1 CHAR 10 0
FLAGCOMM2 Flag: Telephone number(s) maintained AD_FLGCM02 CHAR 1 0
X Yes
NULL No
FLAGCOMM3 Flag: Fax number(s) maintained AD_FLGCM03 CHAR 1 0
X Yes
NULL No
FLAGCOMM4 Flag: Teletex number(s) maintained AD_FLGCM04 CHAR 1 0
X Yes
NULL No
FLAGCOMM5 Flag: Telex number(s) maintained AD_FLGCM05 CHAR 1 0
X Yes
NULL No
FLAGCOMM6 Indicator: E-Mail Address(es) Maintained AD_FLGCM06 CHAR 1 0
X Yes
NULL No
FLAGCOMM7 Flag: RML (remote mail) addresse(s) maintained AD_FLGCM07 CHAR 1 0
X Yes
NULL No
FLAGCOMM8 Flag: X.400 addresse(s) maintained AD_FLGCM08 CHAR 1 0
X Yes
NULL No
FLAGCOMM9 Flag: RFC destination(s) maintained AD_FLGCM09 CHAR 1 0
X Yes
NULL No
ADDRORIGIN (Not Supported) Address Data Source (Key) AD_ORIGINA CHAR 4 0
MC_NAME1 Name (field NAME1) in upper case for matchcode AD_MC_NAME CHAR 25 0
MC_CITY1 City name in upper case for search help AD_MC_CITY CHAR 25 0
MC_STREET Street name in upper case for search help AD_MC_STRT CHAR 25 0
EXTENSION1 Extension (only for data conversion) (data line/telebox) AD_EXTENS CHAR 40 0
EXTENSION2 Extension (only for data conversion) (data line/telebox) AD_EXTENS 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
LANGU_CREA Address record creation original language AD_LANGUCR LANG 1 0