SADLSTRECB

Dynamic Part of Address List (Record Body) | #transactional | #language | Component: Sales Promotions
Column Name Description
MANDT FK Client
LISTNR FK Number of the Address List
VERSION FK Version number
BLKNR FK CAS usage: Address interval number
COUNTER Use in CAS: Artificial key field
Column Name Description
Column Name Description
Column Name Description
Column Name Description
PO_BOX_NUM Flag: PO Box Without Number Show values
DEAR1 Indicator: Competitor Show values
DEAR2 Indicator: Sales partner Show values
DEAR3 Indicator: Sales prospect Show values
DEAR4 Indicator for customer type 4 Show values
Column Name Description Domain name
PARGE Partner's gender AD_SEX
PERNR Personnel Number PERNR
KUNNR Customer Number KUNNR
LIFNR Account Number of Supplier LIFNR
ANRED_AP Form of address for contact person (Mr, Mrs...etc) TEXT30
NAMEV_AP First name NAME
NAME1_AP Name 1 NAME
SPNAM_AP Nickname TEXT10
TITEL_AP Title of contact person (description of function) TEXT35
ANRED Title TEXT15
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
NAME_CO c/o name TEXT40
STREET Street TEXT60
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
STR_SUPPL1 Street 2 TEXT40
STR_SUPPL2 Street 3 TEXT40
STR_SUPPL3 Street 4 TEXT40
CITY1 City TEXT40
CITY2 District TEXT40
HOME_CITY City (different from postal city) TEXT40
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR10
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR10
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR10
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) REGIO
PO_BOX_CTY PO Box of Country/Region LAND1
LOCATION Street 5 TEXT40
REGION Region (State, Province, County) REGIO
COUNTRY Country/Region Key LAND1
PO_BOX_LOBBY PO Box Lobby TEXT40
DELI_SERV_TYPE Type of Delivery Service AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER Number of Delivery Service CHAR10
COUNTY County TEXT40
TOWNSHIP Township TEXT40
TELF1 Addresses: telephone no. TEXT30
TELFX Fax number TEXT31
KTOKD Customer Account Group KTOKD
BRSCH Industry key BRSCH
BRAN1 Industry code 1 BRACO
BRAN2 Industry code 2 BRACO
BRAN3 Industry code 3 BRACO
BRAN4 Industry code 4 BRACO
BRAN5 Industry code 5 BRACO
NIELS Nielsen ID NIELS
KUKLA Customer Classification KUKLA
GFORM Legal status GFORM
KATR1 Attribute 1 ATTR1
KATR2 Attribute 2 ATTR2
KATR3 Attribute 3 ATTR3
KATR4 Attribute 4 ATTR4
KATR5 Attribute 5 ATTR5
KATR6 Attribute 6 ATTR6
KATR7 Attribute 7 ATTR7
KATR8 Attribute 8 ATTR8
KATR9 Attribute 9 ATTR9
KATR10 Attribute 10 ATTR10
PAVIP VIP Partner PAVIP
FAMST Marital Status Key FAMST
PARGE_LIS Partner's gender AD_SEX
ABTNR Department number ABTNR
PAFKT Contact person function PAFKT
PARVO Partner's Authority PARVO
AKVER Buying habits AKVER
PARH1 Contact person: Attribute 1 PARHO
PARH2 Contact person: Attribute 2 PAAT2
PARH3 Contact person: Attribute 3 PAAT3
PARH4 Contact person: Attribute 4 PAAT4
PARH5 Contact person: Attribute 5 PAAT5
PAKN1 Contact person: Attribute 6 PAAT6
PAKN2 Contact person: Attribute 7 PAAT7
PAKN3 Contact person: Attribute 8 PAAT8
PAKN4 Contact person: Attribute 9 PAAT9
PAKN5 Contact person: Attribute 10 PAAT0
PSTLZ_LIS Postal Code PSTLZ
PSTL2_LIS P.O. Box Postal Code PSTLZ
PSTL_LIS Postal code of city or PO box PSTLZ
LAND1_LIS Country/Region Key LAND1
REGIO_LIS Region (State, Province, County) REGIO
Master Data Relations Join Conditions
Client SADLSTRECB.MANDT == T000.MANDT
Language Key SADLSTRECB.SPRAS == T002.SPRAS
Language Key SADLSTRECB.SPRAS_AP == T002.SPRAS