SAP ABAP Table ROIFBBP1 (Business p/func. assignments update structure (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	INTTAB	Structure
Structure	ROIFBBP1	Table Relationship Diagram
Short Description	Business p/func. assignments update structure (IS-Oil MRN)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Business partner role assignments (IS-Oil MRN)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
4	PARFN	☐	OIF_PARFN	OIF_PARFN	CHAR	4	0	MRN business partner role / relation type	OIFBRF1
5	FTMSTM	☐	OIF_FTMSTM	OIF_TMSTM	NUMC	14	0	Start of partner function validity period: time stamp
6	PARPOS	☐	OIF_PARPOS	OIF_PARPOS	NUMC	3	0	Partner counter
7	TTMSTM	☐	OIF_TTMSTM	OIF_TMSTM	NUMC	14	0	End of partner function validity period - timestamp
8	ERDAT	☐	OIF_ERDAT	DATS	DATS	8	0	Date Record Created on (Date)
9	ERZEIT	☐	OIF_ERZEIT	TIME	TIMS	6	0	Time Record Created at (Time)
10	ERNAM	☐	OIF_ERNAM	USNAM	CHAR	12	0	User who Created Record
11	AEDAT	☐	OIF_AEDAT	DATS	DATS	8	0	Date Record Changed on (Date)
12	AEZEIT	☐	OIF_AEZEIT	TIME	TIMS	6	0	Time when Record Was Changed
13	AENAM	☐	OIF_AENAM	USNAM	CHAR	12	0	User who Changed Record
14	BLOIND	☐	OIF_BLOIND	XFELD	CHAR	1	0	Block Indicator
15	DELIND	☐	OIF_DELIND	XFELD	CHAR	1	0	Deletion indicator
16	KUNNR	☐	OIF_BKUNNR	KUNNR	CHAR	10	0	ID of customer/debitor business partner	KNA1
17	LIFNR	☐	OIF_BLIFNR	LIFNR	CHAR	10	0	ID of vendor/creditor business partner	LFA1
18	PBEZ	☐	OIF_PBEZ	DEC3_7	DEC	10	7	Relationship percentage
19	BBEZ	☐	OIF_BBEZ	OIF_CURR13	CURR	13	2	Relationship amount
20	SBBEZ	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
21	PARTC	☐	OIF_PARTC	OIF_PARTC	CHAR	2	0	Technical characteristic for partner role	OIFBRT1
22	GENPAR	☐	OIF_GENPAR	XFELD	CHAR	1	0	Partner entry generated for role: IS-Oil MRN
23	GENINS	☐	OIF_GENINS	XFELD	CHAR	1	0	Suppress location entry generation in partner - IS-Oil MRN
24	MANDEL	☐	OIF_MANDEL	XFELD	CHAR	1	0	Location entry in partner was manually deleted (IS-Oil MRN)
25	.INCLUDE	☐				0	0	Business partner role assignments (IS-Oil SSR)
26	BNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	USR02
27	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
28	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
29	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
30	TTMDAT	☐	OIF_TTMDAT	DATS	DATS	8	0	Partner role validity period - end date (IS-Oil MRN)
31	TTMTIM	☐	OIF_TTMTIM	TIME	TIMS	6	0	Partner role validity period - end time (IS-Oil MRN)
32	FTMDAT	☐	OIF_FTMDAT	DATS	DATS	8	0	Partner role validity period: Start date (IS-Oil MRN)
33	FTMTIM	☐	OIF_FTMTIM	TIME	TIMS	6	0	Partner role validity period - Start time (IS-Oil MRN)
34	PARSTX	☐	OIF_PARSTX	TXT15	CHAR	15	0	Partner role short text (IS-Oil MRN)
35	PARLTX	☐	OIF_PARLTX	TXT40	CHAR	40	0	Partner role long text (IS-Oil MRN)
36	TABNAM	☐	OIF_TABNAM	AS4TAB	CHAR	30	0	Name of DDIC table supporting technical category	DD02L
37	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
38	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	T077K
39	KTOTXT	☐	TXT30_077T	TEXT30	CHAR	30	0	Account Group Name
40	PTCSTX	☐	OIF_PTCSTX	TXT15	CHAR	15	0	Short text: Partner role tech. characteristic (IS-Oil MRN)
41	PTCLTX	☐	OIF_PTCLTX	TXT40	CHAR	40	0	Long text: Partner role tech. characteristic (IS-Oil MRN)
42	GENIND	☐	OIF_GENIND	XFELD	CHAR	1	0	Generate location entry in bus.partner master (IS-Oil MRN)
43	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
44	PARTNR	☐	OIF_PARTNR	TEXT10	CHAR	10	0	Business partner ID (common) - IS-Oil MRN
45	PARNAM	☐	OIF_PARNAM	NAME	CHAR	35	0	Partner name from business partner record (IS-Oil MRN)
46	NAME_FIRST	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
47	ICSTAT	☐	OIF_ICSTAT	OIF_ICSTAT	CHAR	36	0	General object status (icon display) - IS-Oil MRN
48	ICGPAR	☐	OIF_ICGPAR	OIF_ICSTAT	CHAR	36	0	Location entry status (icon display) - IS-Oil MRN
49	BPSTAT	☐	OIF_BPSTAT	OIF_OBSTAT	CHAR	4	0	Business partner status (IS-Oil MRN)	*
50	STALTX	☐	OIF_STALTX	TXT40	CHAR	40	0	Object status - long text (IS-Oil MRN)
51	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
52	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
53	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
54	TELF1EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
55	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
56	CHKBOX	☐	OIF_CHKBOX	OIF_CHKBOX	CHAR	1	0	Checkbox for loop processing
57	UPD_FLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIFBBP1	BNAME	USR02	BNAME
2	ROIFBBP1	KTOKD	T077D	KTOKD
3	ROIFBBP1	KTOKK	T077K	KTOKK
4	ROIFBBP1	KUNNR	KNA1	KUNNR	REF	1	CN
5	ROIFBBP1	LIFNR	LFA1	LIFNR	REF	1	CN
6	ROIFBBP1	MANDT	T000	MANDT		1	CN
7	ROIFBBP1	PARFN	OIFBRF1	PARFN	KEY	1	CN
8	ROIFBBP1	PARTC	OIFBRT1	PARTC	REF	1	CN
9	ROIFBBP1	PBLNR	OIFSPBL	PBLNR	KEY	1	CN
10	ROIFBBP1	SBBEZ	TCURC	WAERS	KEY	1	CN
11	ROIFBBP1	SPART	TSPA	SPART
12	ROIFBBP1	TABNAM	DD02L	TABNAME
13	ROIFBBP1	VKORG	TVKO	VKORG
14	ROIFBBP1	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in