SAP ABAP View IBWG (Commercial application)
Basic Data
View Type    
IBWG  
Short Description Commercial application    
Root table BP030   BP: Business partner - address 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BP030 BP030
2 SANS1 BP030 ADRNR E
3 BP000 BP030 PARTNR E
4 VIMI11 BP000 VADRNR I
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT BP030 MANDT   MANDT Client
2 PARTNR BP030 PARTNR   BP_PARTNR Business Partner Number
3 ADR_REF_K BP030 ADR_REF_K   BP_ADR_REF Address ID
4 ADR_DAT BP030 ADR_DAT   BP_ADR_DAT Business partner address relationship valid from
5 SBWNR VIMI11 SBWNR   SBWNR Application number
6 LAND1 SANS1 LAND1   LAND1 Country Key
7 PSTLZ SANS1 PSTLZ   PSTLZ Postal Code
8 ORT01 SANS1 ORT01   ORT01_GP City
9 ORT02 SANS1 ORT02   ORT02_GP District
10 PSTBZ SANS1 PSTBZ   PSTBZ Post delivery district
11 STRAS SANS1 STRAS   STRAS_GP House number and street
12 STRA1 SANS1 STRA1   STRAS_GP House number and street
13 REGIO SANS1 REGIO   REGIO Region (State, Province, County)
14 CUSTOMER BP000 CUSTOMER   KUNNR Customer Number
15 NAME1 BP000 NAME1   BP_NAME1 Name 1 (surname for persons, otherwise company name)
16 NAME2 BP000 NAME2   BP_NAME2 Name 2 (Continuation of NAME 1)
17 LANGU BP000 LANGU   LANGU Language Key
18 SOURCE BP000 SOURCE   BP_SOURCE Source Key of Business Partner Data
19 CRUSER BP000 CRUSER   BP_CRUSER Entered by
20 CRDAT BP000 CRDAT   BP_CRDAT Creation Date
21 VIP BP000 VIP   BP_VIP Business Partner: VIP Partner
22 GROUP_D BP000 GROUP_D   BP_GROUP_D Target Group
23 NAME_LAST BP000 NAME_LAST   BP_NAMLAST Last Name
24 NAME_FIRST BP000 NAME_FIRST   BP_NAMFRST First Name
25 TITLE_AC BP000 TITLE_AC   BP_TITL_AC Academic Title
26 N_PREFIX BP000 N_PREFIX   BP_PREFIX Name Prefix
27 N_ADDITION BP000 N_ADDITION   BP_ADDITN Name Affix
28 NICKNAME BP000 NICKNAME   BP_NICKNAM Known As
29 SEX BP000 SEX   BP_SEX Gender of business partner
30 PROFESSION BP000 PROFESSION   BP_PROFESS Description of Occupation for Business Partner
31 NATION BP000 NATION   BP_CNTR_N Nationality
32 STATE BP000 STATE   BP_CNTR_ST Citizenship
33 BIRTH_DATE BP000 BIRTH_DATE   BP_BIRTHD Date of Birth of Business Partner
34 BIRTH_PLAC BP000 BIRTH_PLAC   BP_BIRTHPL Birthplace
35 BIRTH_NAME BP000 BIRTH_NAME   BP_BIRTHNA Name at Birth
36 BIRTH_N_AD BP000 BIRTH_N_AD   BP_BIRTH_A Name at Birth Affix
37 DEATH_DATE BP000 DEATH_DATE   BP_DEATH_D Date of Death
38 MARITAL_ST BP000 MARITAL_ST   BP_MARITAL Marital Status
39 PROPRTY_ST BP000 PROPRTY_ST   BP_PROPRTY Marital Property Regime
40 INCOME_CUR BP000 INCOME_CUR   BP_INC_CUR Currency of Net Income
41 NET_INC_Y BP000 NET_INC_Y   BP_N_INC_Y Year of Net Annual Income
42 MO_INC_M BP000 MO_INC_M   BP_M_INC_M Calendar Month of Monthly Net Income
43 MO_INC_Y BP000 MO_INC_Y   BP_M_INC_Y Year of Monthly Net Income
44 PERS_NR BP000 PERS_NR   BP_PERS_NR Personnel Number
45 STAFF_GRP BP000 STAFF_GRP   BP_STAFF_G Employee Group
46 HR_ORG_REF BP000 HR_ORG_REF   HR_ORG_REF HR Org. Link
47 XUBNAME BP000 XUBNAME   XUBNAME User Name in User Master Record
48 STAFF_REF BP000 STAFF_REF   BP_STAFF_R Employee
49 ORG_NAME BP000 ORG_NAME   BP_NAME1 Name 1 (surname for persons, otherwise company name)
50 ORG_NAME2 BP000 ORG_NAME2   BP_NAME2 Name 2 (Continuation of NAME 1)
51 CALENDARID BP000 CALENDARID   BP_CAL_ID Factory calendar
52 LEGAL_ENTY BP000 LEGAL_ENTY   BP_LEG_ETY Legal Form of Organization
53 LEGAL_ORG BP000 LEGAL_ORG   BP_LEG_ORG Legal Entity of Organization
54 BALANCE_FL BP000 BALANCE_FL   BP_BAL_FLG Balance Sheet Display
55 FOUND_YEAR BP000 FOUND_YEAR   BP_FOUND_Y Foundation Year of Organization
56 COMM_REGIS BP000 COMM_REGIS   BP_COM_REG Entry in Commercial Register
57 COMM_REG_D BP000 COMM_REG_D   BP_COM_R_D Date of Entry in Commercial Register
58 CNTRY_COMP BP000 CNTRY_COMP   BP_CNTR_HD Country of Organization's Registered Office
59 COMP_HEAD BP000 COMP_HEAD   BP_COMP_HD Registered Office
60 LIQUID_DAT BP000 LIQUID_DAT   BP_LIQUI_D Date of Liquidation
61 COMP_NR BP000 COMP_NR   BBBNR International location number (part 1)
62 COMP_NR_AD BP000 COMP_NR_AD   BBSNR International location number (Part 2)
63 BUBKZ BP000 BUBKZ   BUBKZ Check digit for the international location number
64 IND_SECTOR BP000 IND_SECTOR   BRSCH Industry key
65 MIN_RESERV BP000 MIN_RESERV   BP_MIN_RSV Bank Subject to Minimum Reserve Requirement
66 BAL_SH_CUR BP000 BAL_SH_CUR   BP_BAL_CUR Balance Sheet Currency
67 CAP_INCR_Y BP000 CAP_INCR_Y   BP_CA_IN_Y Year of Last Capital Increase
68 BANKL BP000 BANKL   BANKK Bank Keys
69 BANKS BP000 BANKS   BANKS Bank country key
70 SBWSTA VIMI11 SBWSTA   SBWSTA Applicant status
71 SBWTYP VIMI11 SBWTYP   SBWTYP Applicant category
72 XANSPRP VIMI11 XANSPRP   XANSPRP Contact person
73 XSTAAT VIMI11 XSTAAT   XSTAAT Nationality
74 XPASSNR VIMI11 XPASSNR   XPASSNR Passport number
75 DPASSV VIMI11 DPASSV   DPASSV Date of submission of passport
76 XREFEREN VIMI11 XREFEREN   XREFEREN Applicant reference data
77 SBONI VIMI11 SBONI   SBONI Credit standing application
78 XWBONI VIMI11 XWBONI   XWBONI Reason for credit standing
79 XALTSEX VIMI11 XALTSEX   XALTSEX Age/sex of children
80 SBUEADR VIMI11 SBUEADR   SBUEADR Guarantor address
81 XTIER1 VIMI11 XTIER1   XTIERE Domestic animal description
82 XABSAGE VIMI11 XABSAGE   XABSAGE Reason for rejection
83 DABSAGE VIMI11 DABSAGE   DABSAGE Rejection date
84 XSITZ VIMI11 XSITZ   XSITZ Company head office
85 JOPTIO VIMI11 JOPTIO   JOPTIO Opting approved
86 RERF VIMI11 RERF   RERF Entered by
87 DERF VIMI11 DERF   DERF First Entered on
88 TERF VIMI11 TERF   TERF Time of Initial Entry
89 REHER VIMI11 REHER   REHER Source of initial entry
90 RBEAR VIMI11 RBEAR   RBEAR Employee ID
91 DBEAR VIMI11 DBEAR   DBEAR Last Edited on
92 TBEAR VIMI11 TBEAR   TBEAR Last Edited at
93 DEINB VIMI11 DEINB   DEINB Date application was received
                 
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  19971002 
SAP Release Created in