J_7LSADR - Address Management: Company Data
Address Management: Company Data information is stored in SAP table J_7LSADR.
It is part of development package J7LR in software component IS-REA-COR. This development package consists of objects that can be grouped under "REA Core Functionality".
It is part of development package J7LR in software component IS-REA-COR. This development package consists of objects that can be grouped under "REA Core Functionality".
Fields for table J_7LSADR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| ADRNR | Addresses: Address Number | X | CADNR | CHAR | 10 | * |
| NATIO | International address version ID | X | INTER | CHAR | 1 | * |
| ANRED | Title | ANRED | CHAR | 15 | ||
| NAME1 | Name 1 | NAME1_BAS | CHAR | 35 | ||
| NAME2 | Name 2 | NAME2_BAS | CHAR | 35 | ||
| NAME3 | Name 3 | NAME3_BAS | CHAR | 35 | ||
| NAME4 | Name 4 | NAME4_BAS | CHAR | 35 | ||
| PSTLZ | Postal code | PSTLZ_BAS | CHAR | 10 | ||
| ORT01 | City | ORT01_GP | CHAR | 35 | ||
| ORT02 | District | ORT02_BAS | CHAR | 35 | ||
| PSTL2 | PO Box postal code | PSTL2_BAS | CHAR | 10 | ||
| PFACH | PO box | PFACH_BAS | CHAR | 10 | ||
| STRAS | Street and House Number | STRAS_GP | CHAR | 35 | ||
| STRS2 | Street and House Number | STRAS_GP | CHAR | 35 | ||
| HAUSN | House number | HAUSN_BAS | CHAR | 6 | ||
| STOCK | Floor | STOCK | CHAR | 6 | ||
| LAND1 | Country/Region Key | LAND1 | CHAR | 3 | T005 | |
| SORTL | Sort field | SORTL_BAS | CHAR | 10 | ||
| SORT2 | Sort field | SORT20 | CHAR | 20 | ||
| SPRAS | Language Key | SPRAS | LANG | 1 | T002 | |
| LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | TZONE | |
| REGIO | Region (State, Province, County) | REGIO | CHAR | 3 | T005S | |
| PSTBZ | Post delivery district | PSTBZ | CHAR | 15 | ||
| TELF1 | Addresses: telephone no. | TLFNR | CHAR | 30 | ||
| FLAG | Checkbox | XFELD | CHAR | 1 | ||
| TELFX | Fax number | TELFX_BAS | CHAR | 31 | ||
| FLAG2 | Checkbox | XFELD | CHAR | 1 | ||
| TELTX | Teletex number | TELTX | CHAR | 30 | ||
| FLAG3 | Checkbox | XFELD | CHAR | 1 | ||
| TELX1 | Telex number | TELX1 | CHAR | 30 | ||
| FLAG4 | Checkbox | XFELD | CHAR | 1 | ||
| MAIAD | Checkbox | XFELD | CHAR | 1 | ||
| MAILN | Addresses: Document name | OBJ_NAM | CHAR | 12 | ||
| STDKO | Default communications service | STDKO_D | CHAR | 1 | ||
| STDCOM | Addresses: Communication type | COM_ART | CHAR | 3 | ||
| DBNAME | Addresses: System ID | SYM_DST | CHAR | 10 | ||
| KLASSE | Addresses: class assigned to an address | SO_KLASSE | CHAR | 18 | ||
| ANREK | Addresses: Form of address key | ANREK | CHAR | 2 | ||
| CRNAM | Addresses: Created by | CR_NAM | CHAR | 12 | ||
| CRDAT | Addresses: Creation date | CR_DAT | DATS | 8 | ||
| CRTIM | Addresses: Creation time | CR_TIM | TIMS | 6 | ||
| CHNAM | Addresses: Changed by | CH_NAM | CHAR | 12 | ||
| CHDAT | Addresses: Change date | CH_DAT | DATS | 8 | ||
| CHTIM | Addresses: Changed at | CH_TIM | TIMS | 6 | ||
| DUEFL | Status of data transfer into subsequent release | DUEFL_BAS | CHAR | 1 | ||
| TXJCD | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | ||
| PFORT | PO Box city | PFORT_ADRS | CHAR | 40 | ||
| TZONE | Time Zone | TZNZONE | CHAR | 6 | TTZZ |