SAP ABAP Table RJKADR (IS-P: Structure for Business Partner Address Changes/Orders)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
⤷ IS-M (Application Component) SAP Media
⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System
Basic Data
Table Category | INTTAB | Structure |
Structure | RJKADR | Table Relationship Diagram |
Short Description | IS-P: Structure for Business Partner Address Changes/Orders |
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 | IS-M/SD: INTTAB for Business Partner Address | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | GPNR | GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | * | |
4 | JPARVW | JPARVW | JPARVW | CHAR | 2 | 0 | IS-M: Business Partner Role | * | |
5 | ROLLZ | ROLLZ | CHAR10 | CHAR | 10 | 0 | IS-M: Counter for role-specific addresses | ||
6 | ADRNR | JADRNR | JADRNR | CHAR | 10 | 0 | IS-M: Address Number | JGTSADR | |
7 | WDAT1 | GUELTIGVON | DATUM | DATS | 8 | 0 | Valid-From Date | ||
8 | WDAT2 | GUELTIGBIS | DATUM | DATS | 8 | 0 | Valid-To Date | ||
9 | ERSGPNR | GPNR | GPNR | CHAR | 10 | 0 | IS-M: Business Partner Key | * | |
10 | XKAHS | XKAHS | XFELD | CHAR | 1 | 0 | IS-M: Customer Pickup Point Indicator | ||
11 | ERFUSER | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
12 | ERFDATE | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
13 | ERFTIME | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
14 | AENUSER | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
15 | AENDATE | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
16 | AENTIME | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
17 | NAME1 | NAME1_ISP | NAME | CHAR | 35 | 0 | IS-M: Business Partner Name | ||
18 | UVADR_ST | UVADR_AD | UVADR_AD | CHAR | 1 | 0 | IS-M: Coding Status of Address | ||
19 | UVADR_PF | UVADR_AD | UVADR_AD | CHAR | 1 | 0 | IS-M: Coding Status of Address | ||
20 | UVADR_GK | UVADR_AD | UVADR_AD | CHAR | 1 | 0 | IS-M: Coding Status of Address | ||
21 | HERK | HERK | HERK | CHAR | 1 | 0 | IS-M: Use of Address | ||
22 | XADRLOE | XLOES | XFELD | CHAR | 1 | 0 | IS-M: Deletion Flag for Address | ||
23 | ANRED | JANRED | JANRED | CHAR | 2 | 0 | IS-M: Form-of-Address Key | * | |
24 | NAME2 | NAME2_ISP | NAME | CHAR | 35 | 0 | IS-M: First Name of Business Partner | ||
25 | NAME3 | NAME3_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
26 | NAME4 | NAME4_ISP | NAME | CHAR | 35 | 0 | IS-M: Further Name Field for Business Partner | ||
27 | TITEL | TITEL_ISP | TITEL | CHAR | 15 | 0 | IS-M: Title | * | |
28 | NAMZU | NAMZU_ISP | TITEL | CHAR | 15 | 0 | IS-M: Name Affix | * | |
29 | VORSW | VORSW_ISP | TITEL | CHAR | 15 | 0 | IS-M: Name Prefix | * | |
30 | PSTLZ | PLZ_ISP | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code | ||
31 | ORT01 | ORT01_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City | ||
32 | POSTEINORT | JALORT | ALORT | CHAR | 8 | 0 | IS-M: City Number (Unique) | * | |
33 | ORT02 | ORT02_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: City District | ||
34 | PSTL2 | PLZPF | PSTLZ | CHAR | 10 | 0 | IS-M: Postal Code for PO Box | ||
35 | PSTL3 | PSTL3 | PSTLZ | CHAR | 10 | 0 | IS-M: Company Postal Code | ||
36 | PFACH | PFACH_ISP | PFACH_ISP | CHAR | 10 | 0 | IS-M: Post Office Box | ||
37 | PEINORTPF | ALORT2 | ALORT | CHAR | 8 | 0 | IS-M: Postal Unit of City for PO Box | * | |
38 | ORTPF | ORTPF | TEXT35 | CHAR | 35 | 0 | IS-M: City for PO Box | ||
39 | ERSTADR | ERSTADR | ERSTADR | CHAR | 1 | 0 | IS-M: Address Proposal for Alternatives | ||
40 | STRAS | STRAS_ISP | TEXT35 | CHAR | 35 | 0 | IS-M: Street Name | ||
41 | POSTEINSTR | STRASSENNR | STRASSENNR | CHAR | 10 | 0 | IS-M: Street Number | * | |
42 | HAUSN | HSNMR1 | HAUSNUMMER | CHAR | 10 | 0 | IS-M: House Number | ||
43 | HSNMR2 | HSNMR2 | CHAR8 | CHAR | 8 | 0 | IS-M: House Number Affix | ||
44 | ADRZUS2 | ADRZUS2 | ADRZUS | CHAR | 6 | 0 | Classification Using a Further Address Affix | ||
45 | STOCK | STOCK | STOCK | CHAR | 6 | 0 | Floor | ||
46 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
47 | SORTL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
48 | SORT2 | SORTL2 | CHAR20 | CHAR | 20 | 0 | IS-M: Sort Field 2 (for Internal Use) | ||
49 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
50 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
51 | TELFP | TELFP | TEXT16 | CHAR | 16 | 0 | IS-M: Home Phone Number | ||
52 | TELFD | TELFD | TEXT16 | CHAR | 16 | 0 | IS-M: Telephone Number at Work | ||
53 | TELFX | TELFX | TEXT31 | CHAR | 31 | 0 | Fax Number | ||
54 | TELTX | TELTX | TEXT30 | CHAR | 30 | 0 | Teletex number | ||
55 | TELX1 | TELX1 | TEXT30 | CHAR | 30 | 0 | Telex number | ||
56 | STDKO | STDKO_D | CHAR1 | CHAR | 1 | 0 | Default communications service | ||
57 | ERFUSER_ST | ERFUSER | USNAM | CHAR | 12 | 0 | Created By | ||
58 | ERFDATE_ST | ERFDATE | DATUM | DATS | 8 | 0 | Created On | ||
59 | ERFTIME_ST | ERFTIME | UZEIT | TIMS | 6 | 0 | Time Created | ||
60 | AENUSER_ST | AENUSER | USNAM | CHAR | 12 | 0 | Last Changed By | ||
61 | AENDATE_ST | AENDATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
62 | AENTIME_ST | AENTIME | UZEIT | TIMS | 6 | 0 | Time of Last Change | ||
63 | .INCLUDE | 0 | 0 | IS-P: Home/Work Telephone Data | |||||
64 | ISPTELVWP | ISPTELVWP | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code (Home) | ||
65 | ISPTELP | ISPTELP | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
66 | ISPTELVWD | ISPTELVWD | ISPTELVW | CHAR | 10 | 0 | IS-M: Area Code - Work | ||
67 | ISPTELD | ISPTELD | ISPTEL | CHAR | 20 | 0 | IS-M: Telephone Number | ||
68 | ISPHANDY | ISPHANDY | CHAR30 | CHAR | 30 | 0 | IS-M: Mobile Phone Number | ||
69 | ISPEMAIL | ISPEMAIL | CHAR50LOW | CHAR | 50 | 0 | IS-M: E-Mail Address | ||
70 | DAT_AEN | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
71 | ADR_AEN | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
72 | ADR_ANL | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
73 | ADR_LOES | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RJKADR | ADRNR | JGTSADR | ADRNR | |||
2 | RJKADR | MANDT | T000 | MANDT |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |