TXI_SADR SAP (Address Management: Company Data) Structure details

Dictionary Type: Structure
Description: Address Management: Company Data




ABAP Code to SELECT data from TXI_SADR
Related tables to TXI_SADR
Access table TXI_SADR




Structure field list including key, data, relationships and ABAP select examples

TXI_SADR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Address Management: Company Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TXI_SADR TYPE TXI_SADR.

The TXI_SADR table consists of various fields, each holding specific information or linking keys about Address Management: Company Data data available in SAP. These include MANDT (Client), ADRNR (Addresses: Address Number), NATIO (International address version ID), ANRED (Title).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP TXI_SADR structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
ADRNRAddresses: Address Number CADNRCHAR10Assigned to domainALPHACADRNR
NATIOInternational address version ID INTERCHAR1Assigned to domainNATION
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 NAME1_BASCHAR35NAME
NAME2Name 2 NAME2_BASCHAR35NAME
NAME3Name 3 NAME3_BASCHAR35NAME
NAME4Name 4 NAME4_BASCHAR35NAME
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_BASCHAR35TEXT35
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFACHPO box PFACH_BASCHAR10PFACH
STRASHouse number and street STRAS_GPCHAR35TEXT35
STRS2House number and street STRAS_GPCHAR35TEXT35
HAUSNHouse number HAUSN_BASCHAR6CHAR6
STOCKFloor STOCKCHAR6STOCK
LAND1Country Key LAND1CHAR3T005LAND1LND
SORTLSort field SORTL_BASCHAR10CHAR10
SORT2Sort field SORT20CHAR20CHAR20
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
LZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
PSTBZPost delivery district PSTBZCHAR15PSTBZ
TELF1Addresses: telephone no. TLFNRCHAR30TEXT30
FLAGCheckbox XFELDCHAR1XFELD
TELFXFax number TELFX_BASCHAR31TEXT31
FLAG2Checkbox XFELDCHAR1XFELD
TELTXTeletex number TELTXCHAR30TEXT30
FLAG3Checkbox XFELDCHAR1XFELD
TELX1Telex number TELX1CHAR30TEXT30
FLAG4Checkbox XFELDCHAR1XFELD
MAIADCheckbox XFELDCHAR1XFELD
MAILNAddresses: Document name OBJ_NAMCHAR12DOC_NAM
STDKODefault communications service STDKO_DCHAR1CHAR1
STDCOMAddresses: Communication type COM_ARTCHAR3COM_ART
DBNAMEAddresses: System ID SYM_DSTCHAR10CHAR10
KLASSEAddresses: class assigned to an address SO_KLASSECHAR18KLASSE
ANREKAddresses: Form of address key ANREKCHAR2ANREK
CRNAMAddresses: Created by CR_NAMCHAR12USERNAME
CRDATAddresses: Creation date CR_DATDATS8DATUM
CRTIMAddresses: Creation time CR_TIMTIMS6UZEIT
CHNAMAddresses: Changed by CH_NAMCHAR12USERNAME
CHDATAddresses: Change date CH_DATDATS8DATUM
CHTIMAddresses: Changed at CH_TIMTIMS6UZEIT
DUEFLStatus of data transfer into subsequent release DUEFL_BASCHAR1DUEFL_BAS
TXJCDTax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
TZONETime Zone TZNZONECHAR6TTZZTZNZONE
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME

Key field Non-key field



How do I retrieve data from SAP structure TXI_SADR using ABAP code?

As TXI_SADR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TXI_SADR as there is no data to select.

How to access SAP table TXI_SADR

Within an ECC or HANA version of SAP you can also view further information about TXI_SADR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!