SAP ABAP Table E3OILSQ (Shipment item from OIGSVMQ, OIGSVMQM, OIGSVMQO1)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIG (Package) TD Transport and Distribution

Basic Data

Table Category	INTTAB	Structure
Structure	E3OILSQ	Table Relationship Diagram
Short Description	Shipment item from OIGSVMQ, OIGSVMQM, OIGSVMQO1

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	SEQ_NMBR	☐	OIG_SEQNR	OIG_SEQNR	NUMC	3	0	TD master data sequence number
2	COM_NUMBER	☐	OIG_CMPNMR	OIG_CMPNMR	INT1	3	0	TD compartment number	*
3	TU_NUMBER	☐	OIG_TRUNMR	OIG_TRUNMR	CHAR	10	0	TD transport unit number	*
4	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	*
5	TD_ACTION	☐	OIG_TDACT	OIG_TDACT	CHAR	1	0	TD action (schedule, load, delivery confirmation)
6	DOC_TYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
7	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
8	DOC_NUMBER	☐	OIG_DOCNR	OIG_DOCNR	CHAR	10	0	TD document number
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
10	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
11	POSNR	☐	OIG_ITEM	OIG_ITEM	NUMC	6	0	TD document item number
12	TRQTY	☐	OIG_TRQTY	OIB_ADQNT	FLTP	16	16	TD transaction quantity
13	TRUOM	☐	OIG_TRUOM	MEINS	UNIT	3	0	TD transaction unit of measure	*
14	QTY_VOL	☐	OIG_QTYVOL	OIB_ADQNT	FLTP	16	16	Quantity in volume UoM
15	QTY_WGT	☐	OIG_QTYWGT	OIB_ADQNT	FLTP	16	16	Quantity in weight UoM
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
17	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
18	LFIMG	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
19	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
20	LGMNG	☐	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
21	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
22	HPM_ITM	☐	OIG_HPMITM	OIG_POSN5	NUMC	5	0	Sequence number for HPM segments
23	HIS_ITM	☐	OIG_HISITM	NUMC3	NUMC	3	0	TD shipment history item number
24	REAS_CODE	☐	OIG_REASCD	OIG_REASC	CHAR	2	0	Reason code - to group quantities in shipment process	*
25	VGTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
26	OIGROUPNAM	☐	OIG_CCG	OIG_CCG	CHAR	8	0	TD:customer compatibility group	*
27	TSTMP	☐	OIB_TSTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Test Temperature: Observed Density
28	TSTEH	☐	OIB_TSTEH	MEINS	UNIT	3	0	Test Temperature Unit (Density): Measurement	*
29	TDICH	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
30	MTTMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
31	MTTEH	☐	OIB_MTTEH	MEINS	UNIT	3	0	Oil/Gas Material Temperature Unit: Observed Quantity	*
32	BDICH	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
33	HYDRO	☐	OIB_HYDRO	OIB_XFELD	CHAR	1	0	Hydrometer Correction Indicator
34	ABFAC	☐	OIB_ABFAC	OIB_ABFAC	DEC	3	1	Air Bouyancy Factor
35	ABIND	☐	OIB_ABIND	OIB_XFELD	CHAR	1	0	Air Bouyancy Indicator
36	UMRSL	☐	OIB_UMRSL	OIB_UMRSL	CHAR	4	0	Conversion Group (Oil, Natural Gas,..)	*
37	CMODE	☐	OIB_CMODE	OIB_CMODE	CHAR	1	0	Conversion Mode
38	COEFF	☐	OIB_COEFF	OIB_COEFF	FLTP	16	16	Quantity Conversion Coefficient
39	FDICH	☐	OIB_FDICH	OIB_DICHT	FLTP	16	16	Fixed Density
40	BSWCN	☐	OIB_BSWCN	OIB_BSWCN	FLTP	16	16	BSW %
41	MCF	☐	OIB_MCF1	OIB_VCF	FLTP	16	16	Meter correction factor
42	STATUS	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type
43	UPDATEFLAG	☐	TRTYP	TRTYP	CHAR	1	0	Transaction type
44	M_TPU_NR	☐	OIG_TPUNR	OIG_TPUNR	NUMC	3	0	Transport unit sequence number in shipment	*
45	M_SEQ_NMBR	☐	OIG_SEQNR	OIG_SEQNR	NUMC	3	0	TD master data sequence number
46	M_VEH_NR	☐	OIG_VEHNR	OIG_VEHNR	NUMC	3	0	Vehicle Sequence Number in Shipment	*

History

Last changed by/on	SAP	20130529
SAP Release Created in