SAP ABAP Table RJY_BP_ADDRESS (IS-M: SAP Business Partner Address)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category INTTAB    Structure 
Structure RJY_BP_ADDRESS   Table Relationship Diagram
Short Description IS-M: SAP 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 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
2 SEARCHTERM1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
3 SEARCHTERM2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
4 PARTNERTYPE BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
5 AUTHORIZATIONGROUP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
6 PARTNERLANGUAGE BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
7 PARTNERLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
8 DATAORIGINTYPE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types *
9 CENTRALARCHIVINGFLAG BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
10 CENTRALBLOCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
11 TITLE_KEY AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
12 CONTACTALLOWANCE BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
13 PARTNEREXTERNAL BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
14 TITLELETTER BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
15 NOTRELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
16 .INCLUDE       0   0   SAP BP: BAPI Structure for Personal Data  
17 FIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
18 LASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
19 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
20 MIDDLENAME BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
21 SECONDNAME BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
22 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
23 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
24 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
25 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
26 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
27 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
28 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
29 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
30 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
31 NAMCOUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
32 SEX BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
33 BIRTHPLACE BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
34 BIRTHDATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
35 DEATHDATE BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
36 MARITALSTATUS BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
37 CORRESPONDLANGUAGE BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
38 CORRESPONDLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
39 FULLNAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
40 EMPLOYER BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
41 OCCUPATION BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group *
42 NATIONALITY BU_NATIO LAND1 CHAR 3   0   Nationality *
43 NATIONALITYISO INTCA INTCA CHAR 2   0   Country ISO code  
44 COUNTRYORIGIN BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies *
45 .INCLUDE       0   0   SAP BP: BAPI Structure for Organization Data  
46 NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
47 NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
48 NAME3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
49 NAME4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
50 LEGALFORM BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
51 INDUSTRYSECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
52 FOUNDATIONDATE BU_FOUND_DAT DATUM DATS 8   0   Date organization founded  
53 LIQUIDATIONDATE BU_LIQUID_DAT   DATS 8   0   Liquidation date of organization  
54 LOC_NO_1 BBBNR NUM07 NUMC 7   0   International location number (part 1)  
55 LOC_NO_2 BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
56 CHK_DIGIT BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
57 LEGALORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization *
58 .INCLUDE       0   0   SAP BP: BAPI Structure for Group Data  
59 NAMEGROUP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
60 NAMEGROUP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
61 GROUPTYPE BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
62 .INCLUDE       0   0   IS-M: Business Partner Central Data (JGTBP00)  
63 GIFT_RECIPIENT XVERMSACH XFELD CHAR 1   0   IS-M: BP Authorized to Receive Gifts  
64 EMPLOYEE XMITARB XFELD CHAR 1   0   IS-M: Employee Indicator  
65 NO_ADVERTISING XNOWERB XFELD CHAR 1   0   IS-M: No Advertising  
66 ASSOCIATION XVERB XFELD CHAR 1   0   IS-M: Association Indicator  
67 INTERNAL_PARTNER XINTERN XFELD CHAR 1   0   IS-M: Internal Business Partner Indicator  
68 SOCIAL_FACILITY XSOZIAL XFELD CHAR 1   0   IS-M: Social Facility Indicator  
69 OWNED_BY_PUBLISHER XVERLEIG XFELD CHAR 1   0   IS-M: Indicator: Owned By Publisher  
70 PUBLISHER_SALESORG VERLVKORG VKORG CHAR 4   0   IS-M: Publisher's Sales Organization TVKO
71 ADVERTISER XINSERENT XINSERENT CHAR 1   0   IS-M: Selection Indicator for Advertiser  
72 AGENCY XAGENTUR XFELD CHAR 1   0   IS-M: Agency Indicator  
73 CREATIVE_AGENCY XAGEN_KREA XFELD CHAR 1   0   IS-M: Creative Boutique Indicator  
74 DISTRIBUTION_AGENCY XAGEN_STR XFELD CHAR 1   0   IS-M: Distribution Agency Indicator  
75 PLANNING_AGENCY XAGEN_PLAN XFELD CHAR 1   0   IS-M: Planning Agency Indicator  
76 AGENCY_TYPE AGEN_GRUP AGEN_GRUP CHAR 1   0   IS-M: Agency Type TJGJ4
77 CREDIT_STANDING_QUERY JDUBIOS JDUBIOS CHAR 1   0   IS-M: Credit Query Indicator TJGJ0
78 CREDITWORTHINESS JBONITAET JBONITAET CHAR 2   0   IS-M: Creditworthiness Indicator TJGJ2
79 SOCIAL_INSURANCE_NUMBER J_SOC_SECU CHAR020 CHAR 20   0   IS-M: Social Insurance Number  
80 .INCLUDE       0   0   SAP BP: BAPI Structure for Address Data  
81 STANDARDADDRESS BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
82 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
83 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
84 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
85 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
86 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
87 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
88 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
89 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
90 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
91 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
92 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
93 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
94 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
95 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
96 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
97 PO_CTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
98 STREET AD_STREET TEXT60 CHAR 60   0   Street  
99 STR_ABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
100 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
101 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
102 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
103 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
104 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
105 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
106 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
107 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
108 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
109 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
110 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
111 COUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
112 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
113 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
114 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
115 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
116 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
117 LANGU SPRAS SPRAS LANG 1   0   Language Key *
118 LANGUISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
119 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
120 EXTADDRESSNUMBER BU_ADEXT BU_ADEXT CHAR 20   0   Address number in external system  
121 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag *
122 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag *
123 MOVE_DATE BU_MOVEDAT DATUM DATS 8   0   Date of Move  
124 MOVE_ADDRESS BU_MOVE_ADDR AD_ADDRNUM CHAR 10   0   Number of Move Target Address for Address Moves *
125 VALIDFROMDATE BU_DATFROM DATUM DATS 8   0   Validity Date (Valid From)  
126 VALIDTODATE BU_DATTO DATUM DATS 8   0   Validity Date (Valid To)  
127 MOVE_ADDR_GUID SYSUUID_C SYSUUID_C CHAR 32   0   UUID in character form  
128 CITY_NO AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file *
129 DISTRCT_NO AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file *
130 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
131 PBOXCIT_NO AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
132 STREET_NO AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
133 HOMECITYNO AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file *
134 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
135 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
136 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
137 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
138 COUNTY_NO AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county *
139 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
140 TOWNSHIP_NO AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township *
141 .INCLUDE       0   0   IS-M: Telephone.No. SAP BP (Like BAPIADTEL Without Country)  
142 STD_NO AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
143 TELEPHONE AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
144 EXTENSION AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
145 TEL_NO AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
146 CALLER_NO AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
147 STD_RECIP AD_DFTRCNR XFELD CHAR 1   0   Flag: Recipient is standard recipient for this number  
148 R_3_USER AD_R3_USER XFELD CHAR 1   0   Flag: Connected to an SAP System  
149 HOME_FLAG AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
150 CONSNUMBER AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
151 ERRORFLAG AD_ERRBAPI XFELD CHAR 1   0   Flag: Record not processed  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJY_BP_ADDRESS AGENCY_TYPE TJGJ4 AGEN_GRU REF 1 CN
2 RJY_BP_ADDRESS CORRESPONDLANGUAGE T002 SPRAS REF C CN
3 RJY_BP_ADDRESS COUNTRY T005 LAND1 REF 1 CN
4 RJY_BP_ADDRESS CREDITWORTHINESS TJGJ2 BONITAET REF 1 CN
5 RJY_BP_ADDRESS CREDIT_STANDING_QUERY TJGJ0 DUBIOS    
6 RJY_BP_ADDRESS GROUPTYPE TB025 PARTGRPTYP 1 CN
7 RJY_BP_ADDRESS INDUSTRYSECTOR TB023 IND_SECTOR REF 1 CN
8 RJY_BP_ADDRESS LEGALFORM TB019 LEGAL_ENTY KEY 1 CN
9 RJY_BP_ADDRESS MARITALSTATUS TB027 MARST 1 CN
10 RJY_BP_ADDRESS NAMCOUNTRY T005 LAND1 REF C CN
11 RJY_BP_ADDRESS NAMEFORMAT T005N NAMEFORMAT REF C CN
12 RJY_BP_ADDRESS PARTNERLANGUAGE T002 SPRAS REF 1 CN
13 RJY_BP_ADDRESS PARTNERTYPE TB004 BPKIND REF 1 CN
14 RJY_BP_ADDRESS POBOX_CTRY T005 LAND1 REF C CN
15 RJY_BP_ADDRESS PO_BOX_REG T005S BLAND C CN
16 RJY_BP_ADDRESS PREFIX1 TSAD4 PREFIX_KEY    
17 RJY_BP_ADDRESS PREFIX2 TSAD4 PREFIX_KEY    
18 RJY_BP_ADDRESS PUBLISHER_SALESORG TVKO VKORG    
19 RJY_BP_ADDRESS REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
20 RJY_BP_ADDRESS REGION T005S BLAND REF C CN
21 RJY_BP_ADDRESS STR_ABBR ADRSTRTYPE STRTYPEAB REF C CN
22 RJY_BP_ADDRESS TIME_ZONE TTZZ TZONE REF C CN
23 RJY_BP_ADDRESS TITLE_ACA1 TSAD2 TITLE_KEY    
24 RJY_BP_ADDRESS TITLE_ACA2 TSAD2 TITLE_KEY    
25 RJY_BP_ADDRESS TITLE_KEY TSAD3 TITLE REF    
26 RJY_BP_ADDRESS TITLE_SPPL TSAD5 TITLE_KEY    
History
Last changed by/on SAP  20140121 
SAP Release Created in 471