SADLSTRECB SAP (Dynamic Part of Address List (Record Body)) Table details

Dictionary Type: Table
Description: Dynamic Part of Address List (Record Body)




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




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

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

The SADLSTRECB table consists of various fields, each holding specific information or linking keys about Dynamic Part of Address List (Record Body) 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 SADLSTRECB 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
PARGEPartner's gender PARGECHAR1GESCH
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
ANRED_APForm of address for contact person (Mr, Mrs...etc) ANRED_APCHAR30TEXT30
NAMEV_APFirst name NAMEV_VPCHAR35NAME
NAME1_APName 1 NAME1_GPCHAR35NAME
SPNAM_APNickname SPNAMCHAR10TEXT10
TITEL_APTitle of contact person (description of function) TITEL_APCHAR35TEXT35
SPRAS_APLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 NAME1_BASCHAR35NAME
NAME2Name 2 NAME2_BASCHAR35NAME
NAME3Name 3 NAME3_BASCHAR35NAME
NAME4Name 4 NAME4_BASCHAR35NAME
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
NAME_COc/o name AD_NAME_COCHAR40TEXT40
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3Assigned to domainREGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
TELF1Addresses: telephone no. TLFNRCHAR30TEXT30
TELFXFax number TELFX_BASCHAR31TEXT31
KTOKDCustomer Account Group KTOKDCHAR4Assigned to domainKTOKDKGD
DEAR1Indicator: Competitor DEAR1CHAR1XFELD
DEAR2Indicator: Sales partner DEAR2CHAR1XFELD
DEAR3Indicator: Sales prospect DEAR3CHAR1DEAR3
DEAR4Indicator for customer type 4 DEAR4CHAR1XFELD
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
BRAN1Industry Code 1 BRAN1_DCHAR10Assigned to domainBRACO
BRAN2Industry code 2 BRAN2CHAR10Assigned to domainBRACO
BRAN3Industry code 3 BRAN3CHAR10Assigned to domainBRACO
BRAN4Industry code 4 BRAN4CHAR10Assigned to domainBRACO
BRAN5Industry code 5 BRAN5CHAR10Assigned to domainBRACO
NIELSNielsen ID NIELSCHAR2Assigned to domainNIELS
KUKLACustomer classification KUKLACHAR2Assigned to domainKUKLA
GFORMLegal status GFORMCHAR2Assigned to domainGFORM
KATR1Attribute 1 KATR1CHAR2Assigned to domainATTR1
KATR2Attribute - 2 KATR2CHAR2Assigned to domainATTR2
KATR3Attribute 3 KATR3CHAR2Assigned to domainATTR3
KATR4Attribute 4 KATR4CHAR2Assigned to domainATTR4
KATR5Attribute 5 KATR5CHAR2Assigned to domainATTR5
KATR6Attribute 6 KATR6CHAR3Assigned to domainATTR6
KATR7Attribute 7 KATR7CHAR3Assigned to domainATTR7
KATR8Attribute 8 KATR8CHAR3Assigned to domainATTR8
KATR9Attribute 9 KATR9CHAR3Assigned to domainATTR9
KATR10Attribute 10 KATR10CHAR3Assigned to domainATTR10
PAVIPVIP Partner PAVIPCHAR1Assigned to domainPAVIP
FAMSTMarital Status Key FAMSTCHAR1Assigned to domainFAMST
PARGE_LISPartner's gender PARGECHAR1GESCH
ABTNRDepartment number ABTNRCHAR4Assigned to domainABTNR
PAFKTContact person function PAFKTCHAR2Assigned to domainPAFKT
PARVOPartner's Authority PARVOCHAR1Assigned to domainPARVO
AKVERBuying habits AKVERCHAR2Assigned to domainAKVER
PARH1Contact person: Attribute 1 PAAT1CHAR2Assigned to domainPARHO
PARH2Contact person: Attribute 2 PAAT2CHAR2Assigned to domainPAAT2
PARH3Contact person: Attribute 3 PAAT3CHAR2Assigned to domainPAAT3
PARH4Contact person: Attribute 4 PAAT4CHAR2Assigned to domainPAAT4
PARH5Contact person: Attribute 5 PAAT5CHAR2Assigned to domainPAAT5
PAKN1Contact person: Attribute 6 PAAT6CHAR3Assigned to domainPAAT6
PAKN2Contact person: Attribute 7 PAAT7CHAR3Assigned to domainPAAT7
PAKN3Contact person: Attribute 8 PAAT8CHAR3Assigned to domainPAAT8
PAKN4Contact person: Attribute 9 PAAT9CHAR3Assigned to domainPAAT9
PAKN5Contact person: Attribute 10 PAAT0CHAR3Assigned to domainPAAT0
PSTLZ_LISPostal Code PSTLZCHAR10PSTLZ
PSTL2_LISP.O. Box Postal Code PSTL2CHAR10PSTLZ
PSTL_LISPostal code of city or PO box PSTL_LISCHAR10PSTLZ
LAND1_LISCountry Key LAND1CHAR3Assigned to domainLAND1LND
REGIO_LISSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO

Key field Non-key field



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

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

SELECT SINGLE *
FROM SADLSTRECB
INTO CORRESPONDING FIELDS OF WA_SADLSTRECB
WHERE...

How to access SAP table SADLSTRECB

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