SAP ABAP View V_BUT020 (Help view Bus. Part. Bank Account: Search by address details)
Hierarchy
FI-CA (Software Component) FI-CA
   FI-CA (Application Component) Contract Accounts Receivable and Payable
     FKKB (Package) Contract A/R & A/P: Central Objects
Basic Data
View Type D Database View 
Database View V_BUT020  
Short Description Help view Bus. Part. Bank Account: Search by address details    
Root table BUT020   BP: Addresses 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT020 BUT020
2 ADRC  
3 BUT0BK  
4 BUT000  
5 BUT100  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 BUT000 CLIENT JL EQ 0 0
2 BUT020 CLIENT JR EQ AND 0 0
3 BUT000 PARTNER JL EQ 0 0
4 BUT020 PARTNER JR EQ AND 0 0
5 BUT000 CLIENT JL EQ 0 0
6 BUT100 MANDT JR EQ AND 0 0
7 BUT000 PARTNER JL EQ 0 0
8 BUT100 PARTNER JR EQ AND 0 0
9 ADRC CLIENT JL EQ 0 0
10 BUT020 CLIENT JR EQ AND 0 0
11 ADRC ADDRNUMBER JL EQ 0 0
12 BUT020 ADDRNUMBER JR EQ AND 0 0
13 ADRC DATE_FROM JL EQ 0 0
14 BUT020 DATE_FROM JR EQ AND 0 0
15 ADRC NATION JL EQ 0 0
16 BUT020 NATION JR EQ AND 0 0
17 BUT000 CLIENT JL EQ 0 0
18 BUT0BK MANDT JR EQ AND 0 0
19 BUT000 PARTNER JL EQ 0 0
20 BUT0BK PARTNER JR EQ AND 0 0
21 BUT000 CLIENT JL EQ 0 0
22 BUT100 MANDT JR EQ AND 0 0
23 BUT000 PARTNER JL EQ 0 0
24 BUT100 PARTNER JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT BUT000 CLIENT   MANDT Client
2 MC_NAME1 BUT000 MC_NAME1   BU_MCNAME1 Search Help Field 1 (Name 1/Last Name)
3 MC_NAME2 BUT000 MC_NAME2   BU_MCNAME2 Search Help Field 2 (Name 2/First Name)
4 MC_CITY1 ADRC MC_CITY1   AD_MC_CITY City name in upper case for search help
5 MC_STREET ADRC MC_STREET   AD_MC_STRT Street name in upper case for search help
6 PARTNER BUT000 PARTNER   BU_PARTNER Business Partner Number
7 AUGRP BUT000 AUGRP   BU_AUGRP Authorization Group
8 RLTYP BUT100 RLTYP   BU_PARTNERROLE BP Role
9 BANKN BUT0BK BANKN   BU_BANKN Bank Account Number
                 
Maintenance Status
Access
  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  20140121 
SAP Release Created in