SADLSTRECB - Dynamic Part of Address List (Record Body)
Dynamic Part of Address List (Record Body) information is stored in SAP table SADLSTRECB.
It is part of development package VCA in software component SD-CAS-SP. This development package consists of objects that can be grouped under "CAS - activities".
It is part of development package VCA in software component SD-CAS-SP. This development package consists of objects that can be grouped under "CAS - activities".
Fields for table SADLSTRECB
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
.INCLUDE | X | SADLSTRECK | 0 | |||
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
LISTNR | Number of the Address List | X | KTANR | CHAR | 20 | SADLSTIAD |
VERSION | Version number | X | CASVERSION | NUMC | 8 | SADLSTIAD |
BLKNR | CAS usage: Address interval number | X | CASBLKNR | CHAR | 12 | SADLSTIAD |
COUNTER | Use in CAS: Artificial key field | X | CASCOUNTER | INT4 | 4 | |
.INCLUDE | SADLSTKNVK | 0 | ||||
PARGE | Partner's gender | PARGE | CHAR | 2 | * | |
PERNR | Personnel Number | PERNR_D | NUMC | 16 | ||
KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | ||
ANRED_AP | Form of address for contact person (Mr, Mrs...etc) | ANRED_AP | CHAR | 60 | ||
NAMEV_AP | First name | NAMEV_VP | CHAR | 70 | ||
NAME1_AP | Name 1 | NAME1_GP | CHAR | 70 | ||
SPNAM_AP | Nickname | SPNAM | CHAR | 20 | ||
TITEL_AP | Title of contact person (description of function) | TITEL_AP | CHAR | 70 | ||
SPRAS_AP | Language Key | SPRAS | LANG | 2 | T002 | |
.INCLUDE | SADLSTKNA1 | 0 | ||||
ANRED | Title | ANRED | CHAR | 30 | ||
NAME1 | Name 1 | NAME1_BAS | CHAR | 70 | ||
NAME2 | Name 2 | NAME2_BAS | CHAR | 70 | ||
NAME3 | Name 3 | NAME3_BAS | CHAR | 70 | ||
NAME4 | Name 4 | NAME4_BAS | CHAR | 70 | ||
SPRAS | Language Key | SPRAS | LANG | 2 | T002 | |
.INCLUDE | ADRS_POST | 0 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 80 | ||
STREET | Street | AD_STREET | CHAR | 120 | ||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 20 | ||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 20 | ||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 80 | ||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 80 | ||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 80 | ||
CITY1 | City | AD_CITY1 | CHAR | 80 | ||
CITY2 | District | AD_CITY2 | CHAR | 80 | ||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 80 | ||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 20 | ||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 20 | ||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 20 | ||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 20 | ||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 20 | ||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 20 | ||
PO_BOX | PO Box | AD_POBX | CHAR | 20 | ||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 2 | ||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 80 | ||
PO_BOX_REG | Region for PO Box (Country/Region, State, Province, ...) | AD_POBXREG | CHAR | 6 | * | |
PO_BOX_CTY | PO Box of Country/Region | AD_POBXCTY | CHAR | 6 | * | |
LOCATION | Street 5 | AD_LCTN | CHAR | 80 | ||
REGION | Region (State, Province, County) | REGIO | CHAR | 6 | * | |
COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | * | |
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 80 | ||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 8 | * | |
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 20 | ||
COUNTY | County | AD_COUNTY | CHAR | 80 | ||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 80 | ||
TELF1 | Addresses: telephone no. | TLFNR | CHAR | 60 | ||
TELFX | Fax number | TELFX_BAS | CHAR | 62 | ||
.INCLUDE | SADLSTLIS | 0 | ||||
.INCLUDE | SADLSTLIS1 | 0 | ||||
KTOKD | Customer Account Group | KTOKD | CHAR | 8 | * | |
DEAR1 | Indicator: Competitor | DEAR1 | CHAR | 2 | ||
DEAR2 | Indicator: Sales partner | DEAR2 | CHAR | 2 | ||
DEAR3 | Indicator: Sales prospect | DEAR3 | CHAR | 2 | ||
DEAR4 | Indicator for customer type 4 | DEAR4 | CHAR | 2 | ||
BRSCH | Industry key | BRSCH | CHAR | 8 | * | |
BRAN1 | Industry code 1 | BRAN1_D | CHAR | 20 | * | |
BRAN2 | Industry code 2 | BRAN2 | CHAR | 20 | * | |
BRAN3 | Industry code 3 | BRAN3 | CHAR | 20 | * | |
BRAN4 | Industry code 4 | BRAN4 | CHAR | 20 | * | |
BRAN5 | Industry code 5 | BRAN5 | CHAR | 20 | * | |
NIELS | Nielsen ID | NIELS | CHAR | 4 | * | |
KUKLA | Customer Classification | KUKLA | CHAR | 4 | * | |
GFORM | Legal status | GFORM | CHAR | 4 | * | |
KATR1 | Attribute 1 | KATR1 | CHAR | 4 | * | |
KATR2 | Attribute 2 | KATR2 | CHAR | 4 | * | |
KATR3 | Attribute 3 | KATR3 | CHAR | 4 | * | |
KATR4 | Attribute 4 | KATR4 | CHAR | 4 | * | |
KATR5 | Attribute 5 | KATR5 | CHAR | 4 | * | |
KATR6 | Attribute 6 | KATR6 | CHAR | 6 | * | |
KATR7 | Attribute 7 | KATR7 | CHAR | 6 | * | |
KATR8 | Attribute 8 | KATR8 | CHAR | 6 | * | |
KATR9 | Attribute 9 | KATR9 | CHAR | 6 | * | |
KATR10 | Attribute 10 | KATR10 | CHAR | 6 | * | |
.INCLUDE | SADLSTLIS2 | 0 | ||||
PAVIP | VIP Partner | PAVIP | CHAR | 2 | * | |
FAMST | Marital Status Key | FAMST | CHAR | 2 | * | |
PARGE_LIS | Partner's gender | PARGE | CHAR | 2 | * | |
ABTNR | Department number | ABTNR | CHAR | 8 | * | |
PAFKT | Contact person function | PAFKT | CHAR | 4 | * | |
PARVO | Partner's Authority | PARVO | CHAR | 2 | * | |
AKVER | Buying habits | AKVER | CHAR | 4 | * | |
PARH1 | Contact person: Attribute 1 | PAAT1 | CHAR | 4 | * | |
PARH2 | Contact person: Attribute 2 | PAAT2 | CHAR | 4 | * | |
PARH3 | Contact person: Attribute 3 | PAAT3 | CHAR | 4 | * | |
PARH4 | Contact person: Attribute 4 | PAAT4 | CHAR | 4 | * | |
PARH5 | Contact person: Attribute 5 | PAAT5 | CHAR | 4 | * | |
PAKN1 | Contact person: Attribute 6 | PAAT6 | CHAR | 6 | * | |
PAKN2 | Contact person: Attribute 7 | PAAT7 | CHAR | 6 | * | |
PAKN3 | Contact person: Attribute 8 | PAAT8 | CHAR | 6 | * | |
PAKN4 | Contact person: Attribute 9 | PAAT9 | CHAR | 6 | * | |
PAKN5 | Contact person: Attribute 10 | PAAT0 | CHAR | 6 | * | |
.INCLUDE | SADLSTLIS3 | 0 | ||||
PSTLZ_LIS | Postal Code | PSTLZ | CHAR | 20 | ||
PSTL2_LIS | P.O. Box Postal Code | PSTL2 | CHAR | 20 | ||
PSTL_LIS | Postal code of city or PO box | PSTL_LIS | CHAR | 20 | ||
LAND1_LIS | Country/Region Key | LAND1 | CHAR | 6 | * | |
REGIO_LIS | Region (State, Province, County) | REGIO | CHAR | 6 | * |