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

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