SAP ABAP Table ROIFOANLA (Update data transfer structure for OIFOANLA)

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	ROIFOANLA	Table Relationship Diagram
Short Description	Update data transfer structure for OIFOANLA

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	Object links - FI-AA asset master (IS-Oil SSR)
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	RNBT	☐	OIRA_RNBT	OIRA_RNBT	CHAR	4	0	Business type	OIRBPBLB
5	OBJPOS	☐	OIF_OBJPOS	OIF_OBJPOS	NUMC	3	0	Object counter
6	.INCLUDE	☐				0	0	Object link data status fields (IS-Oil MRN)
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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
16	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
17	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
18	.INCLUDE	☐				0	0	Structure for icon and status information (IS-Oil MRN)
19	OBSTAT	☐	OIF_OBSTAT	OIF_OBSTAT	CHAR	4	0	Object status (IS-Oil MRN)	OIFXST
20	ICSTAT	☐	OIF_ICSTAT	OIF_ICSTAT	CHAR	36	0	General object status (icon display) - IS-Oil MRN
21	STASTX	☐	OIF_STASTX	TXT15	CHAR	15	0	Short description of object status
22	STALTX	☐	OIF_STALTX	TXT40	CHAR	40	0	Object status - long text (IS-Oil MRN)
23	ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	ANKA
24	TXK50	☐	TXT50_ANKT	TEXT50	CHAR	50	0	Asset class description
25	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
26	TXT50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
27	XANLGR	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
28	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	ROIFOANLA	ANLKL	ANKA	ANLKL
2	ROIFOANLA	ANLN1	ANLH	ANLN1	REF	1	CN
3	ROIFOANLA	ANLN2	ANLA	ANLN2	REF	1	CN
4	ROIFOANLA	BUKRS	T001	BUKRS	REF	1	CN
5	ROIFOANLA	MANDT	T000	MANDT	KEY	1	CN
6	ROIFOANLA	OBSTAT	OIFXST	OBSTAT
7	ROIFOANLA	PBLNR	OIFSPBL	PBLNR	KEY	1	CN
8	ROIFOANLA	RNBT	OIRBPBLB	RNBT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in