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