SAP ABAP Table RJKSDBP_GP (Business Partner Address)
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JSDI (Package) IS-M/SD SD Integration
Basic Data
Table Category INTTAB    Structure 
Structure RJKSDBP_GP   Table Relationship Diagram
Short Description Business Partner Address    
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: Extended Adress Management  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 ADRNR JADRNR JADRNR CHAR 10   0   IS-M: Address Number *
4 UVADR_ST UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
5 UVADR_PF UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
6 UVADR_GK UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
7 HERK HERK HERK CHAR 1   0   IS-M: Use of Address  
8 XADRLOE XLOES XFELD CHAR 1   0   IS-M: Deletion Flag for Address  
9 .INCLUDE       0   0   Created-By Data (Medium Scope)  
10 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
11 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
12 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
13 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
14 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
15 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
16 ANRED JANRED JANRED CHAR 2   0   IS-M: Form-of-Address Key TJG43
17 NAME1 NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
18 NAME2 NAME2_ISP NAME CHAR 35   0   IS-M: First Name of Business Partner  
19 NAME3 NAME3_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
20 NAME4 NAME4_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
21 TITEL TITEL_ISP TITEL CHAR 15   0   IS-M: Title T535N
22 NAMZU NAMZU_ISP TITEL CHAR 15   0   IS-M: Name Affix T535N
23 VORSW VORSW_ISP TITEL CHAR 15   0   IS-M: Name Prefix T535N
24 .INCLUDE       0   0   Core address data  
25 PSTLZ PLZ_ISP PSTLZ CHAR 10   0   IS-M: Postal Code  
26 PSTLZ_ADDON PSTLZ_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code  
27 ORT01 ORT01_ISP TEXT35 CHAR 35   0   IS-M: City  
28 ORT02 ORT02_ISP TEXT35 CHAR 35   0   IS-M: City District  
29 PSTL2 PLZPF PSTLZ CHAR 10   0   IS-M: Postal Code for PO Box  
30 PSTL2_ADDON PSTL2_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code (PO Box)  
31 PSTL3 PSTL3 PSTLZ CHAR 10   0   IS-M: Company Postal Code  
32 PSTL3_ADDON PSTL3_ADDON CHAR4 CHAR 4   0   IS-M: Extension to 5-Character ZIP Code (Company)  
33 PFACH PFACH_ISP PFACH_ISP CHAR 10   0   IS-M: Post Office Box  
34 ORTPF ORTPF TEXT35 CHAR 35   0   IS-M: City for PO Box  
35 STRAS STRAS_ISP TEXT35 CHAR 35   0   IS-M: Street Name  
36 HAUSN HSNMR1 HAUSNUMMER CHAR 10   0   IS-M: House Number  
37 HSNMR2 HSNMR2 CHAR8 CHAR 8   0   IS-M: House Number Affix  
38 ADRZUS2 ADRZUS2 ADRZUS CHAR 6   0   Classification Using a Further Address Affix  
39 STOCK STOCK STOCK CHAR 6   0   Floor  
40 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
41 PREDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
42 POSTDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
43 ADDRSECABBREV ADDRSECABBREV ADDRSECABBREV CHAR 4   0   IS-M: Secondary Address Text TJS43
44 ADDRSECNUMBER ADDRSECNUMBER ADDRSECNUMBER CHAR 8   0   IS-M: Secondary Address Number  
45 STREET2 STREET2_ISM TEXT35 CHAR 35   0   IS-M: Second street line  
46 .INCLUDE       0   0   Include Structure for Alias (Alias Name)  
47 ALIASNAME ALIASNAME TEXT50 CHAR 50   0   IS-M: Alias Text (Street Name + Suffix)  
48 .INCLUDE       0   0   Include Structure for Alias (Direction, Area, Search Field)  
49 ALIASPREDIRECTN DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street *
50 ALIASPOSTDIRECTN DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street *
51 ALIASDELADDRLOW ADDRPRIMLOW HAUSNUMMER CHAR 10   0   IS-M: Primary House Number (Lower Limit)  
52 ALIASDELADDRHIGH ADDRPRIMHIGH HAUSNUMMER CHAR 10   0   IS-M: Primary House Number (Upper Limit)  
53 ALIASDELODDEVEN ODDEVENCODE ODDEVENCODE CHAR 1   0   IS-M: Indicator - Even/Odd/All  
54 SUCHFELDALIAS SUCHFELD CHAR40 CHAR 40   0   Search field for accessing postal structures w/o matchcode  
55 POSTEINORT JALORT ALORT CHAR 8   0   IS-M: City Number (Unique) JSTORTPRO
56 ERSTADR ERSTADR ERSTADR CHAR 1   0   IS-M: Address Proposal for Alternatives  
57 POSTEINSTR STRASSENNR STRASSENNR CHAR 10   0   IS-M: Street Number JSTSTRPRO
58 PEINORTPF ALORT2 ALORT CHAR 8   0   IS-M: Postal Unit of City for PO Box JSTORTPRO
59 LOCCO LOCCO LOCCO CHAR 10   0   City Coordinates  
60 NIELS NIELS NIELS CHAR 2   0   Nielsen ID TNLS
61 COUNC COUNC COUNC CHAR 3   0   County Code T005E
62 CITYC CITYC CITYC CHAR 4   0   City Code T005G
63 RPMKR RPMKR RPMKR CHAR 5   0   Regional market  
64 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
65 SORT2 SORTL2 CHAR20 CHAR 20   0   IS-M: Sort Field 2 (for Internal Use)  
66 SORT3 SORTL3 TEXT30 CHAR 30   0   IS-M: Sort field 3 (internal)  
67 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
68 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
69 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
70 TELFP TELFP TEXT16 CHAR 16   0   IS-M: Home Phone Number  
71 TELFD TELFD TEXT16 CHAR 16   0   IS-M: Telephone Number at Work  
72 TELW1 TELWT TEXT16 CHAR 16   0   IS-M: Additional Telephone Number  
73 TELW2 TELWT TEXT16 CHAR 16   0   IS-M: Additional Telephone Number  
74 TELW3 TELWT TEXT16 CHAR 16   0   IS-M: Additional Telephone Number  
75 TELW4 TELWF TEXT20 CHAR 20   0   IS-M: Mobile Phone Number  
76 TELW5 TELWF TEXT20 CHAR 20   0   IS-M: Mobile Phone Number  
77 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
78 TELF1 TELFT TEXT16 CHAR 16   0   IS-M: Additional Fax Number  
79 TELF2 TELFT TEXT16 CHAR 16   0   IS-M: Additional Fax Number  
80 TELF3 TELFT TEXT16 CHAR 16   0   IS-M: Additional Fax Number  
81 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
82 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
83 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
84 DATLT DATLT TEXT14 CHAR 14   0   Data communication line no.  
85 STDKO STDKO_D CHAR1 CHAR 1   0   Default communications service  
86 GPHERK GPHERK GPHERK CHAR 2   0   IS-M: Business Partner Origin TJG41
87 GP_REF GPNR GPNR CHAR 10   0   IS-M: Business Partner Key JGTGPNR
88 VBELN_REF AVNR AVNR CHAR 10   0   IS-M/SD: Publishing Sales Order JKAK
89 POSNR_REF APNR APNR NUMC 6   0   Sales Order Item JKAP
90 JPARVW_REF JPARVW JPARVW CHAR 2   0   IS-M: Business Partner Role TJG39
91 BEABLS_REF BEABLST BEABLST CHAR 10   0   IS-M: Unloading Point JRTBEABST
92 TELFP_COD TELFP TEXT16 CHAR 16   0   IS-M: Home Phone Number  
93 TELFD_COD TELFD TEXT16 CHAR 16   0   IS-M: Telephone Number at Work  
94 NAME1_MACO NAME1_ISPM NAME_MACO CHAR 35   0   IS-M: Business Partner Name (Upper Case for Matchcode)  
95 NAME2_MACO NAME2_ISPM NAME_MACO CHAR 35   0   IS-M: Bus.Partner's First Name (Upper Case for Matchcode)  
96 STRAS_MACO STRAS_ISPM STRAS_MACO CHAR 35   0   IS-M: Street Name  
97 ORT01_MACO ORT01_ISPM ORT01_MACO CHAR 35   0   IS-M/SD: City Name (Upper Case for Matchcode)  
98 .INCLUDE       0   0   IS-P: Home/Work Telephone Data  
99 ISPTELVWP ISPTELVWP ISPTELVW CHAR 10   0   IS-M: Area Code (Home)  
100 ISPTELP ISPTELP ISPTEL CHAR 20   0   IS-M: Telephone Number  
101 ISPTELVWD ISPTELVWD ISPTELVW CHAR 10   0   IS-M: Area Code - Work  
102 ISPTELD ISPTELD ISPTEL CHAR 20   0   IS-M: Telephone Number  
103 ISPHANDY ISPHANDY CHAR30 CHAR 30   0   IS-M: Mobile Phone Number  
104 ISPEMAIL ISPEMAIL CHAR50LOW CHAR 50   0   IS-M: E-Mail Address  
105 ISPADRBSND ISPADRBSND TEXT50 CHAR 50   0   IS-M/SD: Note for Home Delivery to Ship-to Party  
106 TECHNUMZUG TECHNUMZUG XFELD CHAR 1   0   IS-M: Technical Relocation Due to Postal Data Change  
107 XNOMESS XNOMESS XFELD CHAR 1   0   IS-M: Indicator - Do Not Perform Output Determination  
108 ALIASLFDNR ALIASLFDNR NUMC10 NUMC 10   0   IS-M: Sequence Number for Alias Table (Key) JSTALIAS
109 XNOCARPERMESS XNOCARPERMESS XFELD CHAR 1   0   IS-M: No Change of Carrier When Address Changes  
110 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
111 ANI_TELNRP AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
112 ANI_TELNRD AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
113 ANI_ISPHANDY AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
114 HH_REF GPNR_HH BU_PARTNER CHAR 10   0   IS-M: Business Partner Number of Household JGTHH
115 HH_EXCLUDE HH_EXCLUDE XFELD CHAR 1   0   IS-M: Indicator: Exclude Household Assignment  
116 PRIVACY_STATUS ADDRESS_PRIVACY_STATUS ADDRESS_PRIVACY_STATUS CHAR 1   0   IS-M: Status of Address As Regards Data Protection  
117 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
118 STCD1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
119 GPNR BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
120 REFBELEG REMELD_ISP CHAR20 CHAR 20   0   IS-M/SD: Reference Document in Legacy System  
121 LINEK LINES LINES CHAR 80   0   Address line  
122 GP_EXIST XFELD XFELD CHAR 1   0   Checkbox  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJKSDBP_GP ADDRSECABBREV TJS43 ADDRSECABBREV KEY 1 CN
2 RJKSDBP_GP ALIASLFDNR JSTALIAS ALIASLFDNR KEY C CN
3 RJKSDBP_GP ANRED TJG43 JANRED REF C CN
4 RJKSDBP_GP BEABLS_REF JRTBEABST BEABLST REF C CN
5 RJKSDBP_GP CITYC T005G CITYC REF C CN
6 RJKSDBP_GP COUNC T005E COUNC REF C CN
7 RJKSDBP_GP GPHERK TJG41 GPHERK KEY 1 CN
8 RJKSDBP_GP GP_REF JGTGPNR GPNR REF C CN
9 RJKSDBP_GP HH_REF JGTHH PARTNER    
10 RJKSDBP_GP JPARVW_REF TJG39 JPARVW REF C CN
11 RJKSDBP_GP LAND1 T005 LAND1 REF C CN
12 RJKSDBP_GP MANDT T000 MANDT KEY 1 CN
13 RJKSDBP_GP NAMZU T535N TITEL    
14 RJKSDBP_GP NIELS TNLS NIELS REF C CN
15 RJKSDBP_GP PEINORTPF JSTORTPRO ALORT REF C CN
16 RJKSDBP_GP POSNR_REF JKAP POSNR REF C CN
17 RJKSDBP_GP POSTDIRECTIONAL TJS41 DIRECTIONAL KEY 1 CN
18 RJKSDBP_GP POSTEINORT JSTORTPRO ALORT REF C CN
19 RJKSDBP_GP POSTEINSTR JSTSTRPRO STRASSENNR REF C CN
20 RJKSDBP_GP PREDIRECTIONAL TJS41 DIRECTIONAL KEY 1 CN
21 RJKSDBP_GP REGIO T005S BLAND REF C CN
22 RJKSDBP_GP SPRAS T002 SPRAS REF C CN
23 RJKSDBP_GP TITEL T535N TITEL    
24 RJKSDBP_GP TXJCD TTXJ TXJCD REF C CN
25 RJKSDBP_GP VBELN_REF JKAK VBELN REF C CN
26 RJKSDBP_GP VORSW T535N TITEL    
History
Last changed by/on SAP  20140121 
SAP Release Created in 472