SAP ABAP Table JKSDVZSADR (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | JKSDVZSADR | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ADRNR | JADRNR | JADRNR | CHAR | 10 | 0 | IS-M: Address Number | ||
3 | HERK | HERK | HERK | CHAR | 1 | 0 | IS-M: Use of Address | ||
4 | XADRLOE | XLOES | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for Address | ||
5 | NAME1 | NAME1_ISP | NAME | CHAR | 35 | 0 | IS-M: Business Partner Name | ||
6 | NAME2 | NAME2_ISP | NAME | CHAR | 35 | 0 | IS-M: First Name of Business Partner | ||
7 | NAME3 | NAME3_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
8 | NAME4 | NAME4_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
9 | PSTLZ | PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
10 | ORT01 | ORT01_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City | ||
11 | ORT02 | ORT02_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City District | ||
12 | PSTL2 | PLZPF | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code for PO Box | ||
13 | PSTL3 | PSTL3 | PSTLZ | CHAR | 10 | 0 | IS-M: Company Postal Code | ||
14 | PFACH | PFACH_ISP | PFACH_ISP | CHAR | 10 | 0 | IS-M: Post Office Box | ||
15 | ORTPF | ORTPF | TEXT35 | CHAR | 35 | 0 | IS-M: City for PO Box | ||
16 | STRAS | STRAS_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: Street Name | ||
17 | HAUSN | HSNMR1 | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number | ||
18 | HSNMR2 | HSNMR2 | CHAR8 | CHAR | 8 | 0 | IS-M: House Number Affix | ||
19 | ADRZUS2 | ADRZUS2 | ADRZUS | CHAR | 6 | 0 | Classification Using a Further Address Affix | ||
20 | STOCK | STOCK | STOCK | CHAR | 6 | 0 | Floor | ||
21 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
22 | PREDIRECTIONAL | DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
23 | POSTDIRECTIONAL | DIRECTIONAL | DIRECTIONAL | CHAR | 10 | 0 | IS-M: Direction for Street | TJS41 | |
24 | ADDRSECABBREV | ADDRSECABBREV | ADDRSECABBREV | CHAR | 4 | 0 | IS-M: Secondary Address Text | TJS43 | |
25 | ADDRSECNUMBER | ADDRSECNUMBER | ADDRSECNUMBER | CHAR | 8 | 0 | IS-M: Secondary Address Number | ||
26 | STREET2 | STREET2_ISM | TEXT35 | CHAR | 35 | 0 | IS-M: Second street line | ||
27 | ALIASNAME | ALIASNAME | TEXT50 | CHAR | 50 | 0 | IS-M: Alias Text (Street Name + Suffix) | ||
28 | ERSTADR | ERSTADR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Proposal for Alternatives | ||
29 | POSTEINSTR | STRASSENNR | STRASSENNR | CHAR | 10 | 0 | IS-M: Street Number | ||
30 | SORTL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
31 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
32 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
33 | GP_REF | GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | JGTGPNR | |
34 | NAME1_MACO | NAME1_ISPM | NAME_MACO | CHAR | 35 | 0 | IS-M: Business Partner Name (Upper Case for Matchcode) | ||
35 | NAME2_MACO | NAME2_ISPM | NAME_MACO | CHAR | 35 | 0 | IS-M: Bus.Partner's First Name (Upper Case for Matchcode) | ||
36 | STRAS_MACO | STRAS_ISPM | STRAS_MACO | CHAR | 35 | 0 | IS-M: Street Name | ||
37 | ORT01_MACO | ORT01_ISPM | ORT01_MACO | CHAR | 35 | 0 | IS-M/SD: City Name (Upper Case for Matchcode) | ||
38 | ISPTELVWP | ISPTELVWP | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code (Home) | ||
39 | ISPTELP | ISPTELP | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
40 | ISPTELVWD | ISPTELVWD | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code - Work | ||
41 | ISPTELD | ISPTELD | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
42 | ISPHANDY | ISPHANDY | CHAR30 | CHAR | 30 | 0 | IS-M: Mobile Phone Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | JKSDVZSADR | ADDRSECABBREV | TJS43 | ADDRSECABBREV | KEY | 1 | CN |
2 | JKSDVZSADR | GP_REF | JGTGPNR | GPNR | REF | C | CN |
3 | JKSDVZSADR | LAND1 | T005 | LAND1 | REF | C | CN |
4 | JKSDVZSADR | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | JKSDVZSADR | POSTDIRECTIONAL | TJS41 | DIRECTIONAL | KEY | 1 | CN |
6 | JKSDVZSADR | PREDIRECTIONAL | TJS41 | DIRECTIONAL | KEY | 1 | CN |
7 | JKSDVZSADR | REGIO | T005S | BLAND | REF | C | CN |
8 | JKSDVZSADR | SPRAS | T002 | SPRAS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |