SAP ABAP Table /SAPSLL/ADRCMP (Prepared Address for Address Comparison)
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷ SLL-LEG (Application Component) Global Trade Services
⤷ /SAPSLL/CORE_LEGAL (Package) Legal Services: Core Functions
⤷ SLL-LEG (Application Component) Global Trade Services
⤷ /SAPSLL/CORE_LEGAL (Package) Legal Services: Core Functions
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | /SAPSLL/ADRCMP | Table Relationship Diagram |
Short Description | Prepared Address for Address Comparison |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | SLL: Formatted Address for Address Comparison - PK | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - PK w/o Clnt | |||||
4 | GUID_ADRCMP | /SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
5 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - Data | |||||
6 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - SK | |||||
7 | ADRNR | /SAPSLL/ADRNR | AD_ADDRNUM | CHAR | 10 | 0 | Address Number of Entry in Address File | ADRC | |
8 | CMPCT | /SAPSLL/CMPCT | /SAPSLL/CMPCT | CHAR | 5 | 0 | Control Procedure for Comparing Address/String | /SAPSLL/TCOCMP | |
9 | DOCST | /SAPSLL/DOCST | /SAPSLL/DOCST | CHAR | 1 | 0 | Internal (Technical) Status of a Document | ||
10 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - Detail | |||||
11 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - Name | |||||
12 | CMPAD_N1 | /SAPSLL/CMPAD_N | /SAPSLL/CMPAD_N | CHAR | 230 | 0 | Data Container for Name for Address Comparison | ||
13 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - Street | |||||
14 | CMPAD_S1 | /SAPSLL/CMPAD_S | /SAPSLL/CMPAD_S | CHAR | 240 | 0 | Data Container for Street and Building for Address Compare | ||
15 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - House Number | |||||
16 | CMPAD_H1 | /SAPSLL/CMPAD_H1 | /SAPSLL/CMPAD_H1 | CHAR | 30 | 0 | Data Container for House No./Floor for Comparing Addresses | ||
17 | CMPAD_H2 | /SAPSLL/CMPAD_H2 | /SAPSLL/CMPAD_H2 | CHAR | 20 | 0 | Data Container for House No./Floor for Comparing Addresses | ||
18 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - PO Box | |||||
19 | CMPAD_B2 | /SAPSLL/CMPAD_B | /SAPSLL/CMPAD_B | CHAR | 10 | 0 | Data Container for PO Box for Comparing Addresses | ||
20 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - City | |||||
21 | CMPAD_I1 | /SAPSLL/CMPAD_I1 | /SAPSLL/CMPAD_I1 | CHAR | 80 | 0 | Data Container for City (District) for Comparing Addresses | ||
22 | CMPAD_I2 | /SAPSLL/CMPAD_I | /SAPSLL/CMPAD_I | CHAR | 40 | 0 | Data Container for City (District) for Comparing Addresses | ||
23 | CMPAD_I3 | /SAPSLL/CMPAD_I | /SAPSLL/CMPAD_I | CHAR | 40 | 0 | Data Container for City (District) for Comparing Addresses | ||
24 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - Postal Code | |||||
25 | CMPAD_P1 | /SAPSLL/CMPAD_P | /SAPSLL/CMPAD_P | CHAR | 20 | 0 | Data Container for Postal Code for Comparing Addresses | ||
26 | CMPAD_P2 | /SAPSLL/CMPAD_P | /SAPSLL/CMPAD_P | CHAR | 20 | 0 | Data Container for Postal Code for Comparing Addresses | ||
27 | CMPAD_P3 | /SAPSLL/CMPAD_P | /SAPSLL/CMPAD_P | CHAR | 20 | 0 | Data Container for Postal Code for Comparing Addresses | ||
28 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - Country | |||||
29 | CMPAD_C1 | /SAPSLL/CMPAD_C | LAND1 | CHAR | 3 | 0 | Data Container for Country Key for Comparing Addresses | * | |
30 | CMPAD_C2 | /SAPSLL/CMPAD_C | LAND1 | CHAR | 3 | 0 | Data Container for Country Key for Comparing Addresses | * | |
31 | .INCLUDE | 0 | 0 | SLL: Formatted Address for Address Comparison - Region | |||||
32 | CMPAD_R1 | /SAPSLL/CMPAD_R | REGIO | CHAR | 3 | 0 | Data Container for Region for Comparing Addresses | * | |
33 | CMPAD_R2 | /SAPSLL/CMPAD_R | REGIO | CHAR | 3 | 0 | Data Container for Region for Comparing Addresses | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /SAPSLL/ADRCMP | ADRNR | ADRC | ADDRNUMBER | KEY | 1 | CN |
2 | /SAPSLL/ADRCMP | CMPCT | /SAPSLL/TCOCMP | MANDT | KEY | 1 | CN |
3 | /SAPSLL/ADRCMP | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in | 100 |