SAP ABAP Table BP000 (Business Partner Master (General Data))
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ CA-FS-BP (Application Component) Business Partner Enhancements for Financial Services
⤷ FBPAR (Package) Business Partner (Treasury/Real Estate)
⤷ CA-FS-BP (Application Component) Business Partner Enhancements for Financial Services
⤷ FBPAR (Package) Business Partner (Treasury/Real Estate)
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | BP000 | Table Relationship Diagram |
Short Description | Business Partner Master (General Data) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | PARTNR_OLD | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
4 | .INCLUDE | 0 | 0 | BP: Attributes of General Business Partner | |||||
5 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
6 | PERSNUMBER | AD_PERSNUM | AD_PERSNUM | CHAR | 10 | 0 | Person number | ADRP | |
7 | BU_GROUP | BU_GROUP | BU_GROUP | CHAR | 4 | 0 | Business Partner Grouping | * | |
8 | EXTPARTNR | BP_EXT_PNR | CHAR15 | CHAR | 15 | 0 | External Business Partner ID | ||
9 | CUSTOMER | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
10 | TYPE | BP_TYPE_OLD | BP_TYPE | CHAR | 1 | 0 | Partner category | ||
11 | BP_GROUP | BP_GROUP | XFELD | CHAR | 1 | 0 | BP: Collective Business Partner Indicator | ||
12 | GROUP_ID | BP_GRP_ID_OLD | BP_GRP_ID | CHAR | 4 | 0 | Business Partner Grouping | TPZ2 | |
13 | NAME1 | BP_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 (surname for persons, otherwise company name) | ||
14 | NAME2 | BP_NAME2 | TEXT40 | CHAR | 40 | 0 | Name 2 (Continuation of NAME 1) | ||
15 | LANGU | LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
16 | TITLE | BP_TITLE_OLD | BP_TITLE | NUMC | 2 | 0 | Form of Address (Key) | TP01 | |
17 | TITLE_LET | BP_TITL_LT | BP_TITL_LT | NUMC | 2 | 0 | Salutation | TP02 | |
18 | ADR_REF | BP_ADR_REF_OLD | BP_ADR_REF | CHAR | 10 | 0 | Address ID | TP14 | |
19 | SORT1 | BP_SORT1 | CHAR20 | CHAR | 20 | 0 | Sort Field 1 | ||
20 | SORT2 | BP_SORT2 | CHAR20 | CHAR | 20 | 0 | Sort Field 2 | ||
21 | SORT_PHON | BP_SORT_PH | CHAR20 | CHAR | 20 | 0 | Sort Field for Phonetic Search; Obsolete | ||
22 | MC_NAME1 | BP_MC_NAM1 | CHAR25 | CHAR | 25 | 0 | Field NAME1 in Upper Case | ||
23 | MC_NAME2 | BP_MC_NAM2 | CHAR25 | CHAR | 25 | 0 | Field NAME2 in Upper Case | ||
24 | SOURCE | BP_SOURCE | BP_SOURCE | CHAR | 4 | 0 | Source Key of Business Partner Data | ||
25 | CRUSER | BP_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
26 | CRDAT | BP_CRDAT | DATUM | DATS | 8 | 0 | Creation Date | ||
27 | VIP | BP_VIP | PAVIP | CHAR | 1 | 0 | Business Partner: VIP Partner | TVIP | |
28 | GROUP_D | BP_GROUP_D | BP_GROUP_D | CHAR | 4 | 0 | Target Group | TP13 | |
29 | DEL_IND | BP_DEL_IND | XFELD | CHAR | 1 | 0 | Deletion Flag | ||
30 | BEGRU | BEGRU | BEGRU | CHAR | 4 | 0 | Authorization Group | ||
31 | XTITLE | BP_XTITLE | TEXT50 | CHAR | 50 | 0 | Text of Form of Address | ||
32 | XTIT_LE | BP_XTIT_LE | TEXT50 | CHAR | 50 | 0 | Salutation | ||
33 | PAR_REL | BP_PAR_REL | BP_PAR_REL | CHAR | 1 | 0 | Business Partner Released | ||
34 | .INCLUDE | 0 | 0 | BP: Attributes of Natural Persons | |||||
35 | NAME_LAST | BP_NAMLAST | TEXT40 | CHAR | 40 | 0 | Last Name | ||
36 | NAME_FIRST | BP_NAMFRST | TEXT40 | CHAR | 40 | 0 | First Name | ||
37 | TITLE_AC | BP_TITL_AC_OLD | TEXT20 | CHAR | 20 | 0 | Academic Title | ||
38 | N_PREFIX | BP_PREFIX_OLD | TEXT20 | CHAR | 20 | 0 | Name Prefix | ||
39 | N_ADDITION | BP_ADDITN_OLD | TEXT20 | CHAR | 20 | 0 | Name Affix | ||
40 | NICKNAME | BP_NICKNAM | TEXT20 | CHAR | 20 | 0 | Known As | ||
41 | SEX | BP_SEX_OLD | BP_SEX | CHAR | 1 | 0 | Gender of Business Partner | ||
42 | PROFESSION | BP_PROFESS_OLD | TEXT40 | CHAR | 40 | 0 | Description of Occupation for Business Partner | ||
43 | NATION | BP_CNTR_N | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
44 | STATE | BP_CNTR_ST | LAND1 | CHAR | 3 | 0 | Citizenship | T005 | |
45 | BIRTH_DATE | BP_BIRTHD | DATUM | DATS | 8 | 0 | Date of Birth of Business Partner | ||
46 | BIRTH_PLAC | BP_BIRTHPL | TEXT40 | CHAR | 40 | 0 | Birthplace | ||
47 | BIRTH_NAME | BP_BIRTHNA | TEXT40 | CHAR | 40 | 0 | Name at Birth | ||
48 | BIRTH_N_AD | BP_BIRTH_A | TEXT40 | CHAR | 40 | 0 | Name at Birth Affix | ||
49 | DEATH_DATE | BP_DEATH_D | DATUM | DATS | 8 | 0 | Date of Death | ||
50 | MARITAL_ST | BP_MARITAL_OLD | BP_MARITAL | NUMC | 2 | 0 | Marital Status | TP03 | |
51 | PROPRTY_ST | BP_PROPRTY_OLD | BP_PROPRTY | NUMC | 2 | 0 | Marital property regime | TP04 | |
52 | CHILDREN | BP_CHILDRN | DEC2 | DEC | 2 | 0 | Number of Children Belonging to the Business Partner | ||
53 | MEM_HOUSE | BP_MEM_HOU | DEC2 | DEC | 2 | 0 | Number of People Living in the Household | ||
54 | INCOME_CUR | BP_INC_CUR | WAERS | CUKY | 5 | 0 | Currency of Net Income | TCURC | |
55 | NET_INCOME | BP_NET_INC | WERTV8 | CURR | 15 | 2 | Net Annual Income | ||
56 | MO_NET_INC | BP_MO_INC | WERTV8 | CURR | 15 | 2 | Monthly Net Income of Business Partner | ||
57 | NET_INC_Y | BP_N_INC_Y | GJAHR | NUMC | 4 | 0 | Year of Net Annual Income | ||
58 | MO_INC_M | BP_M_INC_M | BP_M_INC_M | NUMC | 2 | 0 | Calendar Month of Monthly Net Income | ||
59 | MO_INC_Y | BP_M_INC_Y | GJAHR | NUMC | 4 | 0 | Year of Monthly Net Income | ||
60 | PERS_NR | BP_PERS_NR | CHAR15 | CHAR | 15 | 0 | Personnel Number | ||
61 | STAFF_GRP | BP_STAFF_G | BP_STAFF_G | CHAR | 4 | 0 | Employee Group | TP05 | |
62 | HR_ORG_REF | HR_ORG_REF | XFELD | CHAR | 1 | 0 | HR Org. Link | ||
63 | XUBNAME | XUBNAME | XUBNAME | CHAR | 12 | 0 | User Name in User Master Record | USR02 | |
64 | STAFF_REF | BP_STAFF_R | XFELD | CHAR | 1 | 0 | Employee | ||
65 | .INCLUDE | 0 | 0 | BP: Attributes of Organizations | |||||
66 | ORG_NAME | BP_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 (surname for persons, otherwise company name) | ||
67 | ORG_NAME2 | BP_NAME2 | TEXT40 | CHAR | 40 | 0 | Name 2 (Continuation of NAME 1) | ||
68 | CALENDARID | BP_CAL_ID | WFCID | CHAR | 2 | 0 | Factory calendar | TFACD | |
69 | LEGAL_ENTY | BP_LEG_ETY_OLD | BP_LEG_ETY | NUMC | 2 | 0 | Legal Form of Organization | TP08 | |
70 | LEGAL_ORG | BP_LEG_ORG_OLD | BP_LEG_ORG | NUMC | 2 | 0 | Legal Entity of Organization | TP09 | |
71 | BALANCE_FL | BP_BAL_FLG | BP_BAL_FLG | CHAR | 1 | 0 | Balance Sheet Display | ||
72 | FOUND_YEAR | BP_FOUND_Y | GJAHR | NUMC | 4 | 0 | Foundation Year of Organization | ||
73 | COMM_REGIS | BP_COM_REG | TEXT50 | CHAR | 50 | 0 | Entry in Commercial Register | ||
74 | COMM_REG_D | BP_COM_R_D | DATUM | DATS | 8 | 0 | Date of Entry in Commercial Register | ||
75 | CNTRY_COMP | BP_CNTR_HD | LAND1 | CHAR | 3 | 0 | Country of Organization's Registered Office | T005 | |
76 | REGIO | BP_REGIO_HD | REGIO | CHAR | 3 | 0 | Region of Registered Office | T005S | |
77 | COMP_HEAD | BP_COMP_HD | TEXT35 | CHAR | 35 | 0 | Registered Office | ||
78 | LIQUID_DAT | BP_LIQUI_D | DATUM | DATS | 8 | 0 | Date of Liquidation | ||
79 | COMP_NR | BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
80 | COMP_NR_AD | BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
81 | BUBKZ | BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
82 | IND_SECTOR | BP_BRSCH_OLD | BRSCH | CHAR | 4 | 0 | Industry Keys | T016 | |
83 | MIN_RESERV | BP_MIN_RSV | XFELD | CHAR | 1 | 0 | Bank Subject to Minimum Reserve Requirement | ||
84 | BAL_SH_CUR | BP_BAL_CUR | WAERS | CUKY | 5 | 0 | Balance Sheet Currency | TCURC | |
85 | CAP_INCR_A | BP_CA_IN_A | WERTV8 | CURR | 15 | 2 | Amount of last capital increase | ||
86 | CAP_INCR_Y | BP_CA_IN_Y | GJAHR | NUMC | 4 | 0 | Year of Last Capital Increase | ||
87 | BANKL | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
88 | BANKS | BANKS | LAND1 | CHAR | 3 | 0 | Bank country key | * | |
89 | .INCLU--AP | 0 | 0 | BP: Attribute switch-off parallel maintenance | |||||
90 | NO_CONV | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BP000 | ADR_REF | TP14 | ADR_REF | |||
2 | BP000 | BAL_SH_CUR | TCURC | WAERS | |||
3 | BP000 | CALENDARID | TFACD | IDENT | |||
4 | BP000 | CNTRY_COMP | T005 | LAND1 | |||
5 | BP000 | GROUP_D | TP13 | GROUP_D | KEY | 1 | CN |
6 | BP000 | GROUP_ID | TPZ2 | GROUP_ID | KEY | 1 | CN |
7 | BP000 | INCOME_CUR | TCURC | WAERS | KEY | 1 | CN |
8 | BP000 | IND_SECTOR | T016 | BRSCH | |||
9 | BP000 | LANGU | T002 | SPRAS | KEY | 1 | CN |
10 | BP000 | LEGAL_ENTY | TP08 | LEGAL_ENTY | |||
11 | BP000 | LEGAL_ORG | TP09 | LEGAL_ORG | |||
12 | BP000 | MANDT | T000 | MANDT | KEY | 1 | CN |
13 | BP000 | MARITAL_ST | TP03 | MARITAL_ST | KEY | 1 | CN |
14 | BP000 | NATION | T005 | LAND1 | KEY | 1 | CN |
15 | BP000 | PERSNUMBER | ADRP | PERSNUMBER | KEY | ||
16 | BP000 | PROPRTY_ST | TP04 | PROPRTY_ST | KEY | 1 | CN |
17 | BP000 | REGIO | T005S | BLAND | KEY | ||
18 | BP000 | STAFF_GRP | TP05 | STAFF_GRP | KEY | 1 | CN |
19 | BP000 | STATE | T005 | LAND1 | KEY | 1 | CN |
20 | BP000 | TITLE | TP01 | TITLE | KEY | 1 | CN |
21 | BP000 | TITLE_LET | TP02 | TITLE_LET | KEY | 1 | CN |
22 | BP000 | VIP | TVIP | PAVIP | KEY | 1 | CN |
23 | BP000 | XUBNAME | USR02 | BNAME | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |