SAP ABAP Table BSSP_S_BP (RFC-structure: BP data)
Hierarchy
SAP_BS_FND (Software Component) SAP Business Suite Foundation
   CA-GTF-SP (Application Component) Business Suite Sidepanel
     BSSP7 (Package) Content for FS-PM
Basic Data
Table Category INTTAB    Structure 
Structure BSSP_S_BP   Table Relationship Diagram
Short Description RFC-structure: BP data    
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 BPARTNER 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 *
5 AUTHORIZATIONGROUP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
6 PARTNERLANGUAGE BU_LANGU SPRAS LANG 1   0   Business partner: Language *
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 *
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 PRINT_MODE BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
17 LV_PARTNER_ID BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
18 CATEGORY BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
19 GROUP BU_GROUP BU_GROUP CHAR 4   0   Business Partner Grouping *
20 FULLNAME_CONVERTED AD_NAMCONV AD_NAMCONV CHAR 1   0   Status of Field 'Full Name' NAME_TEXT  
21 TEXT4SEX CHAR30 CHAR30 CHAR 30   0   30 Characters  
22 TEXT4LFORM TEXT40 TEXT40 CHAR 40   0   Text, 40 Characters Long  
23 TEXT4LORG TEXT60 TEXT60 CHAR 60   0   Text Field of Length 60  
24 .INCLUDE       0   0   SAP BP: BAPI Structure for Personal Data  
25 FIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
26 LASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
27 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
28 MIDDLENAME BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
29 SECONDNAME BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
30 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
31 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
32 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
33 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
34 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
35 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
36 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
37 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
38 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
39 NAMCOUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
40 SEX BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
41 BIRTHPLACE BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
42 BIRTHDATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
43 DEATHDATE BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
44 MARITALSTATUS BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
45 CORRESPONDLANGUAGE BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
46 CORRESPONDLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
47 FULLNAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
48 EMPLOYER BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
49 OCCUPATION BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group *
50 NATIONALITY BU_NATIO LAND1 CHAR 3   0   Nationality *
51 NATIONALITYISO INTCA INTCA CHAR 2   0   Country ISO code  
52 COUNTRYORIGIN BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies *
53 .INCLUDE       0   0   SAP BP: BAPI Structure for Organization Data  
54 NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
55 NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
56 NAME3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
57 NAME4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
58 LEGALFORM BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
59 INDUSTRYSECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
60 FOUNDATIONDATE BU_FOUND_DAT DATUM DATS 8   0   Date organization founded  
61 LIQUIDATIONDATE BU_LIQUID_DAT   DATS 8   0   Liquidation date of organization  
62 LOC_NO_1 BBBNR NUM07 NUMC 7   0   International location number (part 1)  
63 LOC_NO_2 BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
64 CHK_DIGIT BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
65 LEGALORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization *
66 .INCLUDE       0   0   SAP BP: BAPI Structure for Group Data  
67 NAMEGROUP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
68 NAMEGROUP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
69 GROUPTYPE BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
70 .INCLUDE       0   0   SAP BP: BAPI Structure for Central Data  
71 CREATIONDATE BU_CRDAT DATUM DATS 8   0   Date on which the object was created  
72 CREATIONTIME BU_CRTIM UZEIT TIMS 6   0   Time at which the object was created  
73 CREATIONUSER BU_CRUSR USNAM CHAR 12   0   User who created the object  
74 LASTCHANGEDATE BU_CHDAT DATUM DATS 8   0   Date when object was last changed  
75 LASTCHANGETIME BU_CHTIM UZEIT TIMS 6   0   Time at which object was last changed  
76 LASTCHANGEUSER BU_CHUSR USNAM CHAR 12   0   Last user to change object  
77 PERS_NO AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
78 .INCLUDE       0   0   Validity Data of Business Partner  
79 VALID_FROM BU_CENTRAL_VALID_FROM DATUM DATS 8   0   Validity Start of Central BP Data (YYYYMMDD)  
80 VALID_TO BU_CENTRAL_VALID_TO DATUM DATS 8   0   Validity End Central BP Data (YYYYMMDD)  
81 .INCLUDE       0   0   SAP BP: BAPI Structure for Address Data  
82 STANDARDADDRESS BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
83 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
84 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
85 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
86 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
87 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
88 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
89 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
90 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
91 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
92 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
93 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
94 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
95 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
96 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
97 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
98 PO_CTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
99 STREET AD_STREET TEXT60 CHAR 60   0   Street  
100 STR_ABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
101 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
102 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
103 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
104 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
105 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
106 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
107 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
108 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
109 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
110 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
111 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
112 COUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
113 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
114 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
115 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
116 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
117 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
118 LANGU SPRAS SPRAS LANG 1   0   Language Key *
119 LANGUISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
120 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
121 EXTADDRESSNUMBER BU_ADEXT BU_ADEXT CHAR 20   0   Address number in external system  
122 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag *
123 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag *
124 MOVE_DATE BU_MOVEDAT DATUM DATS 8   0   Date of Move  
125 MOVE_ADDRESS BU_MOVE_ADDR AD_ADDRNUM CHAR 10   0   Number of Move Target Address for Address Moves *
126 VALIDFROMDATE BU_DATFROM DATUM DATS 8   0   Validity Date (Valid From)  
127 VALIDTODATE BU_DATTO DATUM DATS 8   0   Validity Date (Valid To)  
128 MOVE_ADDR_GUID SYSUUID_C SYSUUID_C CHAR 32   0   UUID in character form  
129 CITY_NO AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file *
130 DISTRCT_NO AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file *
131 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
132 PBOXCIT_NO AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
133 STREET_NO AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
134 HOMECITYNO AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file *
135 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
136 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service *
137 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
138 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
139 COUNTY_NO AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county *
140 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
141 TOWNSHIP_NO AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township *
142 .INCLU-_T       0   0   BAPI Structure for Telephone Numbers (Bus. Address Services)  
143 COUNTRY_T AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number T005
144 COUNTRYISO_T INTCA INTCA CHAR 2   0   Country ISO code  
145 STD_NO_T AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
146 TELEPHONE_T AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
147 EXTENSION_T AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
148 TEL_NO_T AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
149 CALLER_NO_T AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
150 STD_RECIP_T AD_FLGSMS AD_FLGSMS CHAR 1   0   Indicator: Telephone is SMS-Enabled  
151 R_3_USER_T AD_FLGMOB AD_FLGMOB CHAR 1   0   Indicator: Telephone is a Mobile Telephone  
152 HOME_FLAG_T AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
153 CONSNUMBER_T AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
154 ERRORFLAG_T AD_ERRBAPI XFELD CHAR 1   0   Flag: Record not processed  
155 FLG_NOUSE_T AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
156 VALID_FROM_T AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
157 VALID_TO_T AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
158 .INCLU-_E       0   0   BAPI Structure for E-Mail Addresses (Bus. Address Services)  
159 STD_NO_E AD_FLGDFNR XFELD CHAR 1   0   Standard Sender Address in this Communication Type  
160 E_MAIL_E AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
161 EMAIL_SRCH_E AD_SMTPAD2 CHAR20 CHAR 20   0   E-Mail Address Search Field  
162 STD_RECIP_E AD_DFTRCNR XFELD CHAR 1   0   Flag: Recipient is standard recipient for this number  
163 R_3_USER_E AD_R3_USER XFELD CHAR 1   0   Flag: Connected to an SAP System  
164 ENCODE_E AD_ENCODE AD_ENCODE CHAR 1   0   Desired Data Coding (E-Mail)  
165 TNEF_E AD_TNEF6 XFELD CHAR 1   0   Flag: Receiver can receive TNEF coding via SMTP  
166 HOME_FLAG_E AD_FLGHOME XFELD CHAR 1   0   Recipient address in this communication type (mail sys.grp)  
167 CONSNUMBER_E AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
168 ERRORFLAG_E AD_ERRBAPI XFELD CHAR 1   0   Flag: Record not processed  
169 FLG_NOUSE_E AD_FLNOUSE XFELD CHAR 1   0   Flag: This Communication Number is Not Used  
170 VALID_FROM_E AD_VALFROM TIMESTMP CHAR 14   0   Communication Data: Valid From (YYYYMMDDHHMMSS)  
171 VALID_TO_E AD_VALTO TIMESTAMP CHAR 14   0   Communication Data: Valid To (YYYYMMDDHHMMSS)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BSSP_S_BP CORRESPONDLANGUAGE T002 SPRAS REF C CN
2 BSSP_S_BP COUNTRY T005 LAND1 REF 1 CN
3 BSSP_S_BP COUNTRY_T T005 LAND1 REF C CN
4 BSSP_S_BP GROUPTYPE TB025 PARTGRPTYP 1 CN
5 BSSP_S_BP INDUSTRYSECTOR TB023 IND_SECTOR REF 1 CN
6 BSSP_S_BP LEGALFORM TB019 LEGAL_ENTY KEY 1 CN
7 BSSP_S_BP MARITALSTATUS TB027 MARST 1 CN
8 BSSP_S_BP NAMCOUNTRY T005 LAND1 REF C CN
9 BSSP_S_BP NAMEFORMAT T005N NAMEFORMAT REF C CN
10 BSSP_S_BP POBOX_CTRY T005 LAND1 REF C CN
11 BSSP_S_BP PO_BOX_REG T005S BLAND C CN
12 BSSP_S_BP PREFIX1 TSAD4 PREFIX_KEY    
13 BSSP_S_BP PREFIX2 TSAD4 PREFIX_KEY    
14 BSSP_S_BP REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
15 BSSP_S_BP REGION T005S BLAND REF C CN
16 BSSP_S_BP STR_ABBR ADRSTRTYPE STRTYPEAB REF C CN
17 BSSP_S_BP TIME_ZONE TTZZ TZONE REF C CN
18 BSSP_S_BP TITLE_ACA1 TSAD2 TITLE_KEY    
19 BSSP_S_BP TITLE_ACA2 TSAD2 TITLE_KEY    
20 BSSP_S_BP TITLE_SPPL TSAD5 TITLE_KEY    
History
Last changed by/on SAP  20141013 
SAP Release Created in 732