SAP ABAP Table OIK37 (IS OIL: Shadow table for SD document processing)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
     ⤷ OIK (Package) TAS/TPI Common Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIK37	Table Relationship Diagram
Short Description	IS OIL: Shadow table for SD document processing

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	*
2	VBTYP	☑	VBTYP	VBTYP	CHAR	1	0	SD document category
3	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
5	COUNTER	☑	OIK_VSEQNR	OIK_VSEQNR	NUMC	12	0	Sequence number for doc.item shadow table
6	APPLIC	☑	OIK_APPLA	OIK_APPLA	CHAR	2	0	OIL Application
7	.INCLUDE	☐				0	0	TPI Tank ID
8	SOCNR	☐	OII_SOCNR	OII_SOCNR	CHAR	20	0	SOC: Storage object characteristic segment number	OIISOCK
9	SOCAM	☐	OII_SOCAM	OII_SOCAM	CHAR	2	0	SOC access mode	OIISOCAM
10	OWNOBJ	☐	OII_OWNOBJ	OII_OWNOBJ	CHAR	20	0	OIL-BDRP: Owning object ID of BDRP sub-object
11	SUBOBJ	☐	OII_SUBOBJ	OII_SUBOBJ	CHAR	10	0	OIL-BDRP: Sequence number of BDRP sub-object
12	.INCLUDE	☐				0	0	Additional vehicle related data from TPS
13	SHNUMBER	☐	OIG_SHNUM	OIG_SHNUM	CHAR	10	0	TD shipment number	*
14	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
15	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
16	SHIFT_STDT	☐	OIK_SHSTDT	DATUM	DATS	8	0	Planned date for start of shift
17	.INCLUDE	☐				0	0	Additional delivery related data from TPS
18	ETA	☐	OIK_ETA_D	TIME	TIMS	6	0	Estimated time of arrival
19	EDA	☐	OIK_EDA_L	DATUM	DATS	8	0	Estimated date of arrival
20	.INCLUDE	☐				0	0	Additional order related data from TPS
21	EXT_DOC_NR	☐	OIG_DOCNR	OIG_DOCNR	CHAR	10	0	TD document number
22	.INCLUDE	☐				0	0	TPI time window data
23	TIME_FRAME	☐	OIK_TIME_F	OIK_TIME_F	CHAR	4	0	Time frame	*
24	FROMTIME	☐	OIG_STTIME	UZEIT	TIMS	6	0	Start time
25	TOTIME	☐	OIG_EDTIME	UZEIT	TIMS	6	0	Rota end time
26	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
27	TF_DATE	☐	OIK_TF_DATE	DATS	DATS	8	0	TPI Time Frame From Date
28	INVERT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
29	INCLOSE	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
30	TO_DATE	☐	OIK_TF_TODATE	DATS	DATS	8	0	TPI Time Frame To Date
31	.INCLUDE	☐				0	0	time frame window (2)
32	FROMDATE	☐	OIK_FROMDATE	DATS	DATS	8	0	TPI From Date
33	TIME_WIND	☐	OIK_TIME_F	OIK_TIME_F	CHAR	4	0	Time frame	*
34	TODATE	☐	OIK_TO_DATE	DATS	DATS	8	0	TPI To Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIK37	SOCAM	OIISOCAM	SOCAM
2	OIK37	SOCNR	OIISOCK	SOCNR
3	OIK37	TZONE	TTZZ	TZONE

History

Last changed by/on	SAP	20130529
SAP Release Created in