SAP ABAP Table OIFBBP1 (Business partner role assignments (IS-Oil MRN))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIF (Package) MRN Marketing Retail Networks
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ OIF (Package) MRN Marketing Retail Networks
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIFBBP1 | Table Relationship Diagram |
Short Description | Business partner role assignments (IS-Oil MRN) |
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 | PBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | OIFSPBL | |
3 | PARFN | OIF_PARFN | OIF_PARFN | CHAR | 4 | 0 | MRN business partner role / relation type | OIFBRF1 | |
4 | FTMSTM | OIF_FTMSTM | OIF_TMSTM | NUMC | 14 | 0 | Start of partner function validity period: time stamp | ||
5 | PARPOS | OIF_PARPOS | OIF_PARPOS | NUMC | 3 | 0 | Partner counter | ||
6 | TTMSTM | OIF_TTMSTM | OIF_TMSTM | NUMC | 14 | 0 | End of partner function validity period - timestamp | ||
7 | ERDAT | OIF_ERDAT | DATS | DATS | 8 | 0 | Date Record Created on (Date) | ||
8 | ERZEIT | OIF_ERZEIT | TIME | TIMS | 6 | 0 | Time Record Created at (Time) | ||
9 | ERNAM | OIF_ERNAM | USNAM | CHAR | 12 | 0 | User who Created Record | ||
10 | AEDAT | OIF_AEDAT | DATS | DATS | 8 | 0 | Date Record Changed on (Date) | ||
11 | AEZEIT | OIF_AEZEIT | TIME | TIMS | 6 | 0 | Time when Record Was Changed | ||
12 | AENAM | OIF_AENAM | USNAM | CHAR | 12 | 0 | User who Changed Record | ||
13 | BLOIND | OIF_BLOIND | XFELD | CHAR | 1 | 0 | Block Indicator | ||
14 | DELIND | OIF_DELIND | XFELD | CHAR | 1 | 0 | Deletion indicator | ||
15 | KUNNR | OIF_BKUNNR | KUNNR | CHAR | 10 | 0 | ID of customer/debitor business partner | KNA1 | |
16 | LIFNR | OIF_BLIFNR | LIFNR | CHAR | 10 | 0 | ID of vendor/creditor business partner | LFA1 | |
17 | PBEZ | OIF_PBEZ | DEC3_7 | DEC | 10 | 7 | Relationship percentage | ||
18 | BBEZ | OIF_BBEZ | OIF_CURR13 | CURR | 13 | 2 | Relationship amount | ||
19 | SBBEZ | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
20 | PARTC | OIF_PARTC | OIF_PARTC | CHAR | 2 | 0 | Technical characteristic for partner role | OIFBRT1 | |
21 | GENPAR | OIF_GENPAR | XFELD | CHAR | 1 | 0 | Partner entry generated for role: IS-Oil MRN | ||
22 | GENINS | OIF_GENINS | XFELD | CHAR | 1 | 0 | Suppress location entry generation in partner - IS-Oil MRN | ||
23 | MANDEL | OIF_MANDEL | XFELD | CHAR | 1 | 0 | Location entry in partner was manually deleted (IS-Oil MRN) | ||
24 | .INCLUDE | 0 | 0 | Business partner role assignments (IS-Oil SSR) | |||||
25 | BNAME | XUBNAME | XUBNAME | CHAR | 12 | 0 | User Name in User Master Record | USR02 | |
26 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
27 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
28 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIFBBP1 | BNAME | USR02 | BNAME | |||
2 | OIFBBP1 | KUNNR | KNA1 | KUNNR | REF | 1 | CN |
3 | OIFBBP1 | LIFNR | LFA1 | LIFNR | REF | 1 | CN |
4 | OIFBBP1 | MANDT | T000 | MANDT | 1 | CN | |
5 | OIFBBP1 | PARFN | OIFBRF1 | PARFN | KEY | 1 | CN |
6 | OIFBBP1 | PARTC | OIFBRT1 | PARTC | REF | 1 | CN |
7 | OIFBBP1 | PBLNR | OIFSPBL | PBLNR | KEY | 1 | CN |
8 | OIFBBP1 | SBBEZ | TCURC | WAERS | KEY | 1 | CN |
9 | OIFBBP1 | SPART | TSPA | SPART | |||
10 | OIFBBP1 | VKORG | TVKO | VKORG | |||
11 | OIFBBP1 | VTWEG | TVTW | VTWEG |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |