SAP ABAP Table V_BPSEARCH3 (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | V_BPSEARCH3 | 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 | 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_BPSEARCH3 | ADRNR | SANS1 | ADRNR | 1 | CN | |
2 | V_BPSEARCH3 | ADR_REF_K | TP14 | ADR_REF | KEY | 1 | CN |
3 | V_BPSEARCH3 | GROUP_ID | TPZ2 | GROUP_ID | KEY | 1 | CN |
4 | V_BPSEARCH3 | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | V_BPSEARCH3 | ROLETYP | TPZ3 | ROLETYP | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |