SAP ABAP Table OILKOMDLGN (IS-OIL extensions)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-DS (Application Component) Downstream
⤷ OI0_COMMON (Package) Common obj. in IS-Oil Downstream
⤷ IS-OIL-DS (Application Component) Downstream
⤷ OI0_COMMON (Package) Common obj. in IS-Oil Downstream
Basic Data
Table Category | APPEND | Append structure |
Append structure | OILKOMDLGN | Table Relationship Diagram |
Short Description | IS-OIL extensions |
Delivery and Maintenance
Pool/cluster | KOMDLGN | |
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 | OIHANTYP | OIH_HANTYP | OIH_HANTYP | CHAR | 2 | 0 | Excise Duty Handling Type | OIH5 | |
2 | OITAXFROM | OIH_TAXFRO | OIH_TAXKEY | CHAR | 2 | 0 | Excise duty tax key for 'from' location | OIH4 | |
3 | OITAXTO | OIH_TAXTO | OIH_TAXKEY | CHAR | 2 | 0 | Excise duty tax key for 'to' location | OIH4 | |
4 | OITAXGRP | OIH_TAXGRP | OIH_TAXGRP | CHAR | 2 | 0 | Excise Duty Group | OIH2 | |
5 | .INCLUDE | 0 | 0 | TRACKING FIELDS FOR 2 STEP TRANSFERS | |||||
15 | .INCLUDE | 0 | 0 | Origin, Destination, Trip and ex Batch No for Pipeline | |||||
36 | OIHPIPEVAL | OID_PIPEV | X | CHAR | 1 | 0 | Validation indicator for pipeline fields (X=ON, blank=OFF) | ||
37 | OICHLIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
38 | OICHDCITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | * | |
39 | OICHDCOUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
40 | OICHDREGIO | OIC_DREGIO | REGIO | CHAR | 3 | 0 | Destination region | * | |
41 | OICHDLAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
42 | OICHOCITYC | CITYC | CITYC | CHAR | 4 | 0 | City Code | * | |
43 | OICHOCOUNC | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
44 | OICHOREGIO | OIC_OREGIO | REGIO | CHAR | 3 | 0 | Origin region | * | |
45 | OICHOLAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
46 | OICHPORGIN | OIC_PORGIN | OIC_PORGIN | CHAR | 15 | 0 | Tax origin | ||
47 | OICHPDESTN | OIC_PDESTN | OIC_PDESTN | CHAR | 15 | 0 | Tax destination | ||
48 | OICHPTRIP | OIC_PTRIP | OIC_PTRIP | CHAR | 16 | 0 | Pipeline trip number (external) | ||
49 | OICHPBATCH | OIC_PBATCH | OIC_PBATCH | CHAR | 16 | 0 | Pipeline operator´s external batch number | ||
50 | OICHMOT | OIC_MOT | VKTRA | CHAR | 2 | 0 | IS-OIL MAP external details mode of transport | * | |
51 | OICHAORGIN | OIC_AORGIN | OIC_PORGIN | CHAR | 15 | 0 | Alternate origin | ||
52 | OICHADESTN | OIC_ADESTN | OIC_PDESTN | CHAR | 15 | 0 | Alternate destination | ||
53 | OICHTRUCKN | OIC_TRUCKN | OIC_TRUCKN | CHAR | 10 | 0 | Truck number | ||
54 | OIDHEXTBOL | OID_EXTBOL | OID_EXTBOL | CHAR | 16 | 0 | External bill of lading | ||
55 | OIDHMISCDL | OID_MISCDL | OID_MISCDL | CHAR | 16 | 0 | Miscellaneous delivery number | ||
56 | .INCLUDE | 0 | 0 | External Bill of Lading and Misc. Deliv. No | |||||
59 | OIMBPOS | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
60 | OIINEX | OIH_INEX | OIH_INEX | CHAR | 2 | 0 | Code for internal or external excise duty rate determination | * | |
61 | OIPRICIE | OIH_PRICIE | X | CHAR | 1 | 0 | ED pricing: external (indicator) | ||
62 | OIOILCON | OIH_OILCON | OIH_OILCON | DEC | 5 | 2 | Oil content in a material as a percentage |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OILKOMDLGN | OIC_DCITYC | T005G | CITYC | |||
2 | OILKOMDLGN | OIC_DCOUNC | T005E | COUNC | |||
3 | OILKOMDLGN | OIC_DLAND1 | T005 | LAND1 | |||
4 | OILKOMDLGN | OIC_DREGIO | T005S | BLAND | |||
5 | OILKOMDLGN | OIC_LIFNR | LFA1 | LIFNR | |||
6 | OILKOMDLGN | OIC_MOT | TVTR | VKTRA | |||
7 | OILKOMDLGN | OIC_OCITYC | T005G | CITYC | |||
8 | OILKOMDLGN | OIC_OCOUNC | T005E | COUNC | |||
9 | OILKOMDLGN | OIC_OLAND1 | T005 | LAND1 | |||
10 | OILKOMDLGN | OIC_OREGIO | T005S | BLAND | |||
11 | OILKOMDLGN | OIHANTYP | OIH5 | HANTYP | |||
12 | OILKOMDLGN | OITAXFROM | OIH4 | TAXKEY | |||
13 | OILKOMDLGN | OITAXGRP | OIH2 | TAXGRP | |||
14 | OILKOMDLGN | OITAXTO | OIH4 | TAXKEY | |||
15 | OILKOMDLGN | OIUMBAR | T149D | BWTAR |
History
Last changed by/on | SAP | 20050223 |
SAP Release Created in |