SAP ABAP Table SADSORTCAT (Structure for Field Catalog for Sort Fields)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VCA (Package) CAS - activities
Basic Data
Table Category INTTAB    Structure 
Structure SADSORTCAT   Table Relationship Diagram
Short Description Structure for Field Catalog for Sort Fields    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 .INCLUDE       0   0   Dynamic Part of Address List (Record Body)  
2 .INCLUDE       0   0   Address List: Key Fields for Static and Dynamic Parts  
3 MANDT MANDT MANDT CLNT 3   0   Client T000
4 LISTNR KTANR KTANR CHAR 10   0   Number of the Address List SADLSTIAD
5 VERSION CASVERSION NUM04 NUMC 4   0   Version number SADLSTIAD
6 BLKNR CASBLKNR CHAR6 CHAR 6   0   CAS usage: Address interval number SADLSTIAD
7 COUNTER CASCOUNTER INT4 INT4 10   0   Use in CAS: Artificial key field  
8 .INCLUDE       0   0   Address List: Contact Person Data  
9 PARGE PARGE GESCH CHAR 1   0   Partner's gender  
10 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
11 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
12 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
13 ANRED_AP ANRED_AP TEXT30 CHAR 30   0   Form of address for contact person (Mr, Mrs...etc)  
14 NAMEV_AP NAMEV_VP NAME CHAR 35   0   First name  
15 NAME1_AP NAME1_GP NAME CHAR 35   0   Name 1  
16 SPNAM_AP SPNAM TEXT10 CHAR 10   0   Nickname  
17 TITEL_AP TITEL_AP TEXT35 CHAR 35   0   Title of contact person (description of function)  
18 SPRAS_AP SPRAS SPRAS LANG 1   0   Language Key T002
19 .INCLUDE       0   0   Address List: Business Partner Data  
20 ANRED ANRED TEXT15 CHAR 15   0   Title  
21 NAME1 NAME1_BAS NAME CHAR 35   0   Name 1  
22 NAME2 NAME2_BAS NAME CHAR 35   0   Name 2  
23 NAME3 NAME3_BAS NAME CHAR 35   0   Name 3  
24 NAME4 NAME4_BAS NAME CHAR 35   0   Name 4  
25 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
26 .INCLUDE       0   0   Postal part of an address (for address formatting)  
27 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
28 STREET AD_STREET TEXT60 CHAR 60   0   Street  
29 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
30 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
31 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
32 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
33 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
34 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
35 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
36 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
37 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
38 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
39 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
40 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
41 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
42 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
43 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
44 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
45 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
46 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) *
47 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country *
48 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
49 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
50 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
51 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
52 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
53 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
54 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
55 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
56 TELF1 TLFNR TEXT30 CHAR 30   0   Addresses: telephone no.  
57 TELFX TELFX_BAS TEXT31 CHAR 31   0   Fax number  
58 .INCLUDE       0   0   CAS: Address List Fields Relevant for LIS  
59 .INCLUDE       0   0   CAS: Fields Relevant to LIS - Address List From KNA1  
60 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group *
61 DEAR1 DEAR1 XFELD CHAR 1   0   Indicator: Competitor  
62 DEAR2 DEAR2 XFELD CHAR 1   0   Indicator: Sales partner  
63 DEAR3 DEAR3 DEAR3 CHAR 1   0   Indicator: Sales prospect  
64 DEAR4 DEAR4 XFELD CHAR 1   0   Indicator for customer type 4  
65 BRSCH BRSCH BRSCH CHAR 4   0   Industry key *
66 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 *
67 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 *
68 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 *
69 BRAN4 BRAN4 BRACO CHAR 10   0   Industry code 4 *
70 BRAN5 BRAN5 BRACO CHAR 10   0   Industry code 5 *
71 NIELS NIELS NIELS CHAR 2   0   Nielsen ID *
72 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification *
73 GFORM GFORM GFORM CHAR 2   0   Legal status *
74 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 *
75 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 *
76 KATR3 KATR3 ATTR3 CHAR 2   0   Attribute 3 *
77 KATR4 KATR4 ATTR4 CHAR 2   0   Attribute 4 *
78 KATR5 KATR5 ATTR5 CHAR 2   0   Attribute 5 *
79 KATR6 KATR6 ATTR6 CHAR 3   0   Attribute 6 *
80 KATR7 KATR7 ATTR7 CHAR 3   0   Attribute 7 *
81 KATR8 KATR8 ATTR8 CHAR 3   0   Attribute 8 *
82 KATR9 KATR9 ATTR9 CHAR 3   0   Attribute 9 *
83 KATR10 KATR10 ATTR10 CHAR 3   0   Attribute 10 *
84 .INCLUDE       0   0   CAS: Fields Relevant to LIS - Address List From KNVK  
85 PAVIP PAVIP PAVIP CHAR 1   0   VIP Partner *
86 FAMST FAMST FAMST CHAR 1   0   Marital Status Key *
87 PARGE_LIS PARGE GESCH CHAR 1   0   Partner's gender  
88 ABTNR ABTNR ABTNR CHAR 4   0   Department number *
89 PAFKT PAFKT PAFKT CHAR 2   0   Contact person function *
90 PARVO PARVO PARVO CHAR 1   0   Partner's power of attorney *
91 AKVER AKVER AKVER CHAR 2   0   Buying habits *
92 PARH1 PAAT1 PARHO CHAR 2   0   Contact Partner: Attribute 1 *
93 PARH2 PAAT2 PAAT2 CHAR 2   0   Contact person: Attribute 2 *
94 PARH3 PAAT3 PAAT3 CHAR 2   0   Contact person: Attribute 3 *
95 PARH4 PAAT4 PAAT4 CHAR 2   0   Contact person: Attribute 4 *
96 PARH5 PAAT5 PAAT5 CHAR 2   0   Contact person: Attribute 5 *
97 PAKN1 PAAT6 PAAT6 CHAR 3   0   Contact person: Attribute 6 *
98 PAKN2 PAAT7 PAAT7 CHAR 3   0   Contact person: Attribute 7 *
99 PAKN3 PAAT8 PAAT8 CHAR 3   0   Contact person: Attribute 8 *
100 PAKN4 PAAT9 PAAT9 CHAR 3   0   Contact person: Attribute 9 *
101 PAKN5 PAAT0 PAAT0 CHAR 3   0   Contact person: Attribute 10 *
102 .INCLUDE       0   0   CAS: Fields Relevant to LIS - Address List From the Address  
103 PSTLZ_LIS PSTLZ PSTLZ CHAR 10   0   Postal Code  
104 PSTL2_LIS PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
105 PSTL_LIS PSTL_LIS PSTLZ CHAR 10   0   Postal code of city or PO box  
106 LAND1_LIS LAND1 LAND1 CHAR 3   0   Country Key *
107 REGIO_LIS REGIO REGIO CHAR 3   0   Region (State, Province, County) *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SADSORTCAT BLKNR SADLSTIAD BLKNR KEY 1 CN
2 SADSORTCAT LISTNR SADLSTIAD LISTNR KEY 1 CN
3 SADSORTCAT MANDT T000 MANDT KEY 1 CN
4 SADSORTCAT SPRAS T002 SPRAS    
5 SADSORTCAT SPRAS_AP T002 SPRAS REF 1 CN
6 SADSORTCAT VERSION SADLSTIAD VERSION KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in