SAP ABAP Table ROIFA (screen fields for maintaining business location data)

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	ROIFA	Table Relationship Diagram
Short Description	screen fields for maintaining business location data

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	PBLTYP	☐	OIF_PBLTYP	OIF_PBLTYP	CHAR	4	0	Business Location Type (IS-Oil MRN)	OIFSPBLT
3	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
4	REF_PBLNR	☐	OIF_R_NR	OIF_PBLNR	CHAR	10	0	Reference service station PBL number	*
5	ADDRNR	☐	OIF_ADNUM	AD_ADDRNUM	CHAR	10	0	Address No. in ADRC	ADRC
6	REF_PBLTYP	☐	OIF_R_TYP	OIF_PBLTYP	CHAR	4	0	Reference service station PBL type	OIFSPBLT
7	AN_DAT	☐	OIF_AN_DAT	DATS	DATS	8	0	Analysis date - business partner listing (IS-Oil MRN)
8	AN_TIM	☐	OIF_AN_TIM	TIME	TIMS	6	0	Analysis time - business partner listing (IS-Oil MRN)
9	AS_DAT	☐	OIF_AS_DAT	DATS	DATS	8	0	Analysis start date - business partner listing (IS-Oil MRN)
10	AS_TIM	☐	OIF_AS_TIM	TIME	TIMS	6	0	Analysis start time - business partner listing (IS-Oil MRN)
11	AE_DAT	☐	OIF_AE_DAT	DATS	DATS	8	0	Analysis end date - business partner listing (IS-Oil MRN)
12	AE_TIM	☐	OIF_AE_TIM	TIME	TIMS	6	0	Analysis end time - business partner listing (IS-Oil MRN)
13	BPLMOD	☐	OIF_BPLMOD	OIF_BPLMOD	CHAR	1	0	List mode - business partner listing (IS-Oil MRN)
14	BPLMTX	☐	AS4TEXT	AS4TEXT	CHAR	60	0	Short Description of Repository Objects
15	SHOBLO	☐	OIF_SHOBLO	XFELD	CHAR	1	0	Show blocked flag - business partner listing (IS-Oil MRN)
16	KUNNR	☐	OIF_KUNNR	KUNNR	CHAR	10	0	Sold-to party	KNA1
17	NAME1	☐	OIF_PBNAM1	CHAR35	CHAR	35	0	Internal name field
18	LFIRST	☐	OIF_LFIRST	OIF_LFIRST	NUMC	3	0	List no. of first line in screen loop
19	LTOTAL	☐	OIF_LTOTAL	OIF_LTOTAL	NUMC	3	0	Total number of lines in generated list
20	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
21	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
22	LFIRSTPROJ	☐	OIF_LFIRST	OIF_LFIRST	NUMC	3	0	List no. of first line in screen loop
23	LTOTALPROJ	☐	OIF_LTOTAL	OIF_LTOTAL	NUMC	3	0	Total number of lines in generated list
24	LFIRSTCOAS	☐	OIF_LFIRST	OIF_LFIRST	NUMC	3	0	List no. of first line in screen loop
25	LTOTALCOAS	☐	OIF_LTOTAL	OIF_LTOTAL	NUMC	3	0	Total number of lines in generated list
26	TTMDAT	☐	OIF_TTMDAT	DATS	DATS	8	0	Partner role validity period - end date (IS-Oil MRN)
27	TTMTIM	☐	OIF_TTMTIM	TIME	TIMS	6	0	Partner role validity period - end time (IS-Oil MRN)
28	CLDAT	☐	OIF_CLDAT	DATS	DATS	8	0	Business location close date
29	CLTIM	☐	OIF_CLTIM	TIME	TIMS	6	0	Business location close time
30	TEXTLINE1	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)
31	TEXTLINE2	☐	TEXT80	TEXT80UEB	CHAR	80	0	Text (80 Characters)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIFA	ADDRNR	ADRC	ADDRNUMBER
2	ROIFA	KUNNR	KNA1	KUNNR		1	CN
3	ROIFA	MANDT	T000	MANDT		1	CN
4	ROIFA	PBLTYP	OIFSPBLT	PBLTYP		1	1
5	ROIFA	REF_PBLTYP	OIFSPBLT	PBLTYP		1	1

History

Last changed by/on	SAP	20110901
SAP Release Created in