SAP ABAP Table OICQOIL (F&A Oil Table for Repository Default)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIC (Package) MAP Marketing, Accounting and Pricing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OICQOIL	Table Relationship Diagram
Short Description	F&A Oil Table for Repository Default

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	FORID	☑	OIC_FORID	OIC_FORID	CHAR	10	0	Formula repository ID
3	CUSTOMER	☑	OIC_CUST	KUNNR	CHAR	10	0	F&A repository customer	KNA1
4	VENDOR	☑	OIC_VEND	LIFNR	CHAR	10	0	F&A repository vendor	LFA1
5	MATERIAL	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	MATGROUP	☑	OIC_MATGRP	MATKL	CHAR	9	0	F&A repository material group	T023
7	PLANT	☑	OIC_PLANT	WERKS	CHAR	4	0	F&A repository plant	T001W

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OICQOIL	CUSTOMER	KNA1	KUNNR
2	OICQOIL	MANDT	T000	MANDT
3	OICQOIL	MATERIAL	MARA	MATNR
4	OICQOIL	MATGROUP	T023	MATKL
5	OICQOIL	PLANT	T001W	WERKS
6	OICQOIL	VENDOR	LFA1	LIFNR

History

Last changed by/on	SAP	20050224
SAP Release Created in