SAP ABAP View V_BUT000_ALL (Selection View for General Partner Data)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷
FS-BP (Application Component) Business Partner
⤷
FTBP (Package) Treasury: Central business partner

⤷

⤷

Basic Data
View Type | D | Database View |
Database View | V_BUT000_ALL | |
Short Description | Selection View for General Partner Data | |
Root table | BUT000 | BP: General data I |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | ![]() |
BUT000 | ||
2 | ![]() |
|||
3 | ![]() |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | ![]() |
CLIENT | JL | EQ | 0 | 0 | ||||
2 | ![]() |
CLIENT | JR | EQ | AND | 0 | 0 | |||
3 | ![]() |
PARTNER | JL | EQ | 0 | 0 | ||||
4 | ![]() |
PARTNER | JR | EQ | AND | 0 | 0 | |||
5 | ![]() |
CLIENT | JL | EQ | 0 | 0 | ||||
6 | ![]() |
CLIENT | JR | EQ | AND | 0 | 0 | |||
7 | ![]() |
PARTNER | JL | EQ | 0 | 0 | ||||
8 | ![]() |
PARTNER | JR | EQ | AND | 0 | 0 | |||
9 | ![]() |
ADDRNUMBER | JL | EQ | 0 | 0 | ||||
10 | ![]() |
ADDRNUMBER | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | ![]() |
![]() |
CLIENT | MANDT | Client | |||
2 | ![]() |
![]() |
PARTNER | BU_PARTNER | Business Partner Number | |||
3 | ![]() |
![]() |
ADDRNUMBER | AD_ADDRNUM | Address number | |||
4 | ![]() |
![]() |
ADR_KIND | BU_ADRKIND | Address Type | |||
5 | ![]() |
![]() |
TYPE | BU_TYPE | Business partner category | |||
6 | ![]() |
![]() |
BPKIND | BU_BPKIND | Business Partner Type | |||
7 | ![]() |
![]() |
BU_GROUP | BU_GROUP | Business Partner Grouping | |||
8 | ![]() |
![]() |
BPEXT | BU_BPEXT | Business Partner Number in External System | |||
9 | ![]() |
![]() |
BU_SORT1 | BU_SORT1 | Search term 1 for business partner | |||
10 | ![]() |
![]() |
BU_SORT2 | BU_SORT2 | Search term 2 for business partner | |||
11 | ![]() |
![]() |
SOURCE | BU_SOURCE | Data Origin Types | |||
12 | ![]() |
![]() |
TITLE | AD_TITLE | Form-of-Address Key | |||
13 | ![]() |
![]() |
XDELE | BU_XDELE | Central Archiving Flag | |||
14 | ![]() |
![]() |
XBLCK | BU_XBLCK | Central Block for Business Partner | |||
15 | ![]() |
![]() |
AUGRP | BU_AUGRP | Authorization Group | |||
16 | ![]() |
![]() |
TITLE_LET | BU_TITLE_LET | Salutation | |||
17 | ![]() |
![]() |
BU_LANGU | BU_LANGU | Business partner: Language | |||
18 | ![]() |
![]() |
NAME_ORG1 | BU_NAMEOR1 | Name 1 of organization | |||
19 | ![]() |
![]() |
NAME_ORG2 | BU_NAMEOR2 | Name 2 of organization | |||
20 | ![]() |
![]() |
NAME_ORG3 | BU_NAMEOR3 | Name 3 of organization | |||
21 | ![]() |
![]() |
NAME_ORG4 | BU_NAMEOR4 | Name 4 of organization | |||
22 | ![]() |
![]() |
LEGAL_ENTY | BU_LEGENTY | BP: Legal form of organization | |||
23 | ![]() |
![]() |
IND_SECTOR | BU_INDSECT | Industry sector | |||
24 | ![]() |
![]() |
FOUND_DAT | BU_FOUND_DAT | Date organization founded | |||
25 | ![]() |
![]() |
LIQUID_DAT | BU_LIQUID_DAT | Liquidation date of organization | |||
26 | ![]() |
![]() |
LEGAL_ORG | BU_LEGAL_ORG | Legal Entity of Organization | |||
27 | ![]() |
![]() |
LOCATION_1 | BBBNR | International location number (part 1) | |||
28 | ![]() |
![]() |
LOCATION_2 | BBSNR | International location number (Part 2) | |||
29 | ![]() |
![]() |
LOCATION_3 | BUBKZ | Check digit for the international location number | |||
30 | ![]() |
![]() |
NAME_LAST | BU_NAMEP_L | Last name of business partner (person) | |||
31 | ![]() |
![]() |
NAME_FIRST | BU_NAMEP_F | First name of business partner (person) | |||
32 | ![]() |
![]() |
NAME_LST2 | BU_NAMEPL2 | Other Last Name of a Person | |||
33 | ![]() |
![]() |
NAME_LAST2 | BU_BIRTHNM | Name at birth of business partner | |||
34 | ![]() |
![]() |
NAMEMIDDLE | BU_NAMEMID | Middle name or second forename of a person | |||
35 | ![]() |
![]() |
TITLE_ACA1 | AD_TITLE1 | Academic Title: Key | |||
36 | ![]() |
![]() |
TITLE_ACA2 | AD_TITLE2 | Second academic title (key) | |||
37 | ![]() |
![]() |
TITLE_ROYL | AD_TITLES | Name supplement, e.g. noble title (key) | |||
38 | ![]() |
![]() |
PREFIX1 | AD_PREFIX | Name Prefix (Key) | |||
39 | ![]() |
![]() |
PREFIX2 | AD_PREFIX2 | 2nd name prefix (key) | |||
40 | ![]() |
![]() |
NAME1_TEXT | BU_NAME1TX | Full Name | |||
41 | ![]() |
![]() |
NICKNAME | BU_NICKNAM | Nickname of Business Partner (Person) | |||
42 | ![]() |
![]() |
INITIALS | AD_INITS | "Middle Initial" or personal initials | |||
43 | ![]() |
![]() |
NAMEFORMAT | AD_FORMAT | Name format | |||
44 | ![]() |
![]() |
NAMCOUNTRY | AD_NAMCTRY | Country for name format rule | |||
45 | ![]() |
![]() |
XSEXM | BU_XSEXM | Selection: Business partner is male | |||
46 | ![]() |
![]() |
XSEXF | BU_XSEXF | Selection: Business partner is female | |||
47 | ![]() |
![]() |
BIRTHDT | BU_BIRTHDT | Date of Birth of Business Partner | |||
48 | ![]() |
![]() |
BIRTHPL | BU_BIRTHPL | Birthplace of business partner | |||
49 | ![]() |
![]() |
DEATHDT | BU_DEATHDT | Date of death of business partner | |||
50 | ![]() |
![]() |
PERNO | BU_PERNO | Personnel Number | |||
51 | ![]() |
![]() |
MARST | BU_MARST | Marital Status of Business Partner | |||
52 | ![]() |
![]() |
EMPLO | BU_EMPLO | Name of Employer of a Natural Person | |||
53 | ![]() |
![]() |
JOBGR | BU_JOBGR | Occupation/group | |||
54 | ![]() |
![]() |
NATIO | BU_NATIO | Nationality | |||
55 | ![]() |
![]() |
CNTAX | BU_CNTAX | Obsolete Field | |||
56 | ![]() |
![]() |
CNDSC | BU_CNDSC | Ctry of Origin: Non-Res. Companies | |||
57 | ![]() |
![]() |
PERSNUMBER | AD_PERSNUM | Person number | |||
58 | ![]() |
![]() |
XSEXU | BU_XSEXU | Selection: Sex of business partner is not known | |||
59 | ![]() |
![]() |
PARTGRPTYP | BU_GRPTYP | Group type | |||
60 | ![]() |
![]() |
NAME_GRP1 | BU_NAMEGR1 | Name 1 (group) | |||
61 | ![]() |
![]() |
NAME_GRP2 | BU_NAMEGR2 | Name 2 (group) | |||
62 | ![]() |
![]() |
MC_NAME1 | BU_MCNAME1 | Search Help Field 1 (Name 1/Last Name) | |||
63 | ![]() |
![]() |
MC_NAME2 | BU_MCNAME2 | Search Help Field 2 (Name 2/First Name) | |||
64 | ![]() |
![]() |
CRUSR | BU_CRUSR | User who created the object | |||
65 | ![]() |
![]() |
CRDAT | BU_CRDAT | Date on which the object was created | |||
66 | ![]() |
![]() |
CRTIM | BU_CRTIM | Time at which the object was created | |||
67 | ![]() |
![]() |
CHUSR | BU_CHUSR | Last user to change object | |||
68 | ![]() |
![]() |
CHDAT | BU_CHDAT | Date when object was last changed | |||
69 | ![]() |
![]() |
CHTIM | BU_CHTIM | Time at which object was last changed | |||
70 | ![]() |
![]() |
XDFADR | BU_XDFADR | Indicator: Address is standard address | |||
71 | ![]() |
![]() |
ADEXT | BU_ADEXT | Address number in external system | |||
72 | ![]() |
![]() |
DATE_FROM | BU_DATE_OBSOLETE | Date Obsolete | |||
73 | ![]() |
![]() |
NATION | AD_NATION | Version ID for International Addresses | |||
74 | ![]() |
![]() |
XDFADU | BU_XDFADU | Indicator: Standard Address Usage | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20141109 |
SAP Release Created in |