SAP ABAP Table OILRV45A (IS-Oil append structure for RV45A (SAPMV45A data))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_COMMON (Package) Common obj. in IS-Oil Downstream

Basic Data

Table Category	APPEND	Append structure
Append structure	OILRV45A	Table Relationship Diagram
Short Description	IS-Oil append structure for RV45A (SAPMV45A data)

Delivery and Maintenance

Pool/cluster	RV45A
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	OICNTPER	☐	OID_CNTPER	OID_CNTPER	CHAR	35	0	Contact person
2	OICNTNTE	☐	OID_CNTNTE	OID_CNTNTE	CHAR	35	0	Contact note
3	OICNTPHO	☐	OID_CNTPHO	OID_CNTPHO	CHAR	16	0	Contact tel. number
4	OIBYPASS	☐	OID_BYPASS	OI0_SELKZ	CHAR	1	0	IS-Oil plant determination indicator: x=yes blank=no
5	S_OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
6	S_OICERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
7	S_OIDATFM1	☐	OIH_DATFM1	DATUM	DATS	8	0	Excise duty tax certificate valid from date
8	S_OIDATTO1	☐	OIH_DATTO1	DATUM	DATS	8	0	Valid to date for excise duty tax certificate
9	OID_NAMEP	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
10	OID_ORTP	☐	ORT01	TEXT25	CHAR	25	0	City
11	OID_OPEN	☐	OID_OPEN	MENG13	QUAN	13	3	Open quantity in contract
12	OID_VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
13	OID_VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
14	OID_SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
15	S_OILICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	OIHL
16	S_OILICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
17	OITITTXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
18	OID_STS	☐	OID_STS	CHAR1_X	CHAR	1	0	Status of restrictions
19	OID_MSG	☐	OID_MSG	CHAR1_X	CHAR	1	0	Message for restriction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OILRV45A	OID_SPART	TSPA	SPART
2	OILRV45A	OID_VKORG	TVKO	VKORG
3	OILRV45A	OID_VTWEG	TVTW	VTWEG
4	OILRV45A	S_OIHANTYP	OIH5	HANTYP
5	OILRV45A	S_OILICIN	OIHL	LICIN
6	OILRV45A	S_OILICTP	OIH20	LICTP

History

Last changed by/on	SAP	20050223
SAP Release Created in