SADLSTRECH SAP (Static Part of an Address List (Record Header)) Table details

Dictionary Type: Table
Description: Static Part of an Address List (Record Header)




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




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

SADLSTRECH is a standard SAP Table which is used to store Static Part of an Address List (Record Header) data and is available within R/3 SAP systems depending on the version and release level.

The SADLSTRECH table consists of various fields, each holding specific information or linking keys about Static Part of an Address List (Record Header) data available in SAP. These include MANDT (Client), LISTNR (Number of the Address List), VERSION (Version number), BLKNR (CAS usage: Address interval number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP SADLSTRECH table 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
LISTNRNumber of the Address List KTANRCHAR10SADLSTIADKTANR
VERSIONVersion number CASVERSIONNUMC4SADLSTIADNUM04
BLKNRCAS usage: Address interval number CASBLKNRCHAR6SADLSTIADCHAR6
COUNTERUse in CAS: Artificial key field CASCOUNTERINT410INT4
SORTKEY1Sort key for addresses in a list CASSORTKEYCHAR35CHAR35
SORTKEY2Sort key for addresses in a list CASSORTKEYCHAR35CHAR35
SORTKEY3Sort key for addresses in a list CASSORTKEYCHAR35CHAR35
BNRARTType of partner number NRARTCHAR2TVPANRART
BPARNRPartner number (KUNNR, LIFNR, or PERNR) KUNDE_DCHAR10ALPHAKUNDE
BNRART2Type of partner number NRARTCHAR2TVPANRART
BPARNR2Partner number (KUNNR, LIFNR, or PERNR) KUNDE_DCHAR10ALPHAKUNDE
ADRTYPEAddress Type ADRTYPECHAR1ADRTYPE
ADRBPARNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
ADRBPARNR2Address ADRNRCHAR10Assigned to domainALPHAADRNR
ADR_MANAddress ADRNRCHAR10Assigned to domainALPHAADRNR
STATUSApplication CAS: statusflag of an address of an address list CASASTATUSCHAR1CASASTATUS

Key field Non-key field



How do I retrieve data from SAP table SADLSTRECH using ABAP code

The following ABAP code Example will allow you to do a basic selection on SADLSTRECH to SELECT all data from the table
DATA: WA_SADLSTRECH TYPE SADLSTRECH.

SELECT SINGLE *
FROM SADLSTRECH
INTO CORRESPONDING FIELDS OF WA_SADLSTRECH
WHERE...

How to access SAP table SADLSTRECH

Within an ECC or HANA version of SAP you can also view further information about SADLSTRECH 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!