SAP ABAP Table V_BPSEARCH1 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_BPSEARCH1   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 PARTNR BP_PARTNR_OLD BP_PARTNR CHAR 10   0   Business Partner Number  
3 EXTPARTNR BP_EXT_PNR CHAR15 CHAR 15   0   External Business Partner ID  
4 CUSTOMER KUNNR KUNNR CHAR 10   0   Customer Number  
5 NAME1 BP_NAME1 TEXT40 CHAR 40   0   Name 1 (surname for persons, otherwise company name)  
6 NAME2 BP_NAME2 TEXT40 CHAR 40   0   Name 2 (Continuation of NAME 1)  
7 GROUP_ID BP_GRP_ID_OLD BP_GRP_ID CHAR 4   0   Business Partner Grouping TPZ2
8 SORT1 BP_SORT1 CHAR20 CHAR 20   0   Sort Field 1  
9 SORT2 BP_SORT2 CHAR20 CHAR 20   0   Sort Field 2  
10 DEL_IND BP_DEL_IND XFELD CHAR 1   0   Deletion Flag  
11 BP_GROUP BP_GROUP XFELD CHAR 1   0   BP: Collective Business Partner Indicator  
12 TYPE BP_TYPE_OLD BP_TYPE CHAR 1   0   Partner category  
13 SORT_PHON BP_SORT_PH CHAR20 CHAR 20   0   Sort Field for Phonetic Search; Obsolete  
14 ADRNR BP_ADRNR_OLD SADRNR CHAR 10   0   Address Number SANS1
15 ADR_DAT BP_ADR_DAT DATUM DATS 8   0   Business partner address relationship valid from  
16 ADR_D_E BP_ADR_D_E DATUM DATS 8   0   Business Partner Address Relationship Valid Until  
17 ADR_REF_K BP_ADR_REF_OLD BP_ADR_REF CHAR 10   0   Address ID TP14
18 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
19 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
20 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
21 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
22 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
23 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
24 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
25 STRA1 STRAS_GP TEXT35 CHAR 35   0   House number and street  
26 PSTBZ PSTBZ PSTBZ CHAR 15   0   Post delivery district  
27 ROLETYP BP_ROLETYP_OLD BP_ROLETYP CHAR 4   0   Business Partner Role Category TPZ3
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_BPSEARCH1 ADRNR SANS1 ADRNR 1 CN
2 V_BPSEARCH1 ADR_REF_K TP14 ADR_REF KEY 1 CN
3 V_BPSEARCH1 GROUP_ID TPZ2 GROUP_ID KEY 1 CN
4 V_BPSEARCH1 LAND1 T005 LAND1 KEY 1 1
5 V_BPSEARCH1 MANDT T000 MANDT KEY 1 CN
6 V_BPSEARCH1 REGIO T005S BLAND KEY 1 1
7 V_BPSEARCH1 ROLETYP TPZ3 ROLETYP KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in