SAP ABAP Table OIB_LIPSO1_WRK (Posting structure for LIPSO1)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       OIB (Package) HPM Hydrocarbon Product Management
Basic Data
Table Category INTTAB    Structure 
Structure OIB_LIPSO1_WRK   Table Relationship Diagram
Short Description Posting structure for LIPSO1    
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 .INCLUDE       0   0   Appendix: Delivery Note - Conversion Parameters  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 VBELN VBELN_VL VBELN CHAR 10   0   Delivery VBUK
4 POSNR POSNR_VL POSNR NUMC 6   0   Delivery Item VBUP
5 .INCLUDE       0   0   Quantity conversion interface - base parameters  
6 UMRSL OIB_UMRSL OIB_UMRSL CHAR 4   0   Conversion Group (Oil, Natural Gas,..) OIB01
7 CMODE OIB_CMODE OIB_CMODE CHAR 1   0   Conversion Mode  
8 FDICHEH OIB_BDNEH MEINS UNIT 3   0   Unit for densities at standard/base conditions T006
9 FDICH OIB_FDICH OIB_DICHT FLTP 16   16   Fixed Density  
10 COEFF OIB_COEFF OIB_COEFF FLTP 16   16   Quantity Conversion Coefficient  
11 BDICHEH OIB_BDNEH MEINS UNIT 3   0   Unit for densities at standard/base conditions T006
12 BDICH OIB_BDICH OIB_DICHT FLTP 16   16   Oil/gas density at standard/base conditions  
13 BHVALEH OIB_BHVEH MEINS UNIT 3   0   Heating value unit at standard/base conditions (natural gas) T006
14 BHVAL OIB_BHVAL OIB_HVAL FLTP 16   16   Heating value at standard/base conditions (natural gas)  
15 .INCLUDE       0   0   Quantity conversion interface - conversion parameters  
16 TSTMP OIB_TSTMP TEMP_VALUE FLTP 16   16   Oil/Gas Test Temperature: Observed Density  
17 TSTEH OIB_TSTEH MEINS UNIT 3   0   Test Temperature Unit (Density): Measurement T006
18 MTTMP OIB_MTTMP TEMP_VALUE FLTP 16   16   Oil/Gas Material Temperature: Observed Quantity  
19 MTTEH OIB_MTTEH MEINS UNIT 3   0   Oil/Gas Material Temperature Unit: Observed Quantity T006
20 THVAL OIB_THVAL OIB_HVAL FLTP 16   16   Heating value at test conditions (natural gas): observed  
21 TDICHEH OIB_DNEH MEINS UNIT 3   0   Unit for densities of petroleum products and natural gas T006
22 TDICH OIB_TDICH OIB_DICHT FLTP 16   16   Oil/Gas Test Density  
23 MTPRES OIB_MTPRES OIB_PRES FLTP 16   16   Oil/gas material pressure: observed quantity  
24 MTPRESEH OIB_MTPRESEH MEINS UNIT 3   0   Oil/gas material pressure unit: observed quantity T006
25 TPRED OIB_TPRED OIB_PRES FLTP 16   16   Oil/gas test pressure: metering (obs. density)  
26 TPREDEH OIB_TPREDEH MEINS UNIT 3   0   Oil/Gas test press. unit: metering (density) T006
27 TPRHV OIB_TPRHV OIB_PRES FLTP 16   16   Natural gas test pressure: combustion (obs. heating value )  
28 TPRHVEH OIB_TPRHVEH MEINS UNIT 3   0   Natural gas test pressure unit: combustion ( heating value ) T006
29 TTMPHV OIB_TTMPHV TEMP_VALUE FLTP 16   16   Natural gas test temperature: combustion (obs. heat. value )  
30 TTMPHVEH OIB_TTMPHVEH MEINS UNIT 3   0   Natural gas test temp. unit: combustion (heating value) T006
31 ATPRES OIB_ATPRES OIB_PRES FLTP 16   16   Atmospheric pressure of the air surrounding a product  
32 ATPRESEH OIB_ATPRESEH MEINS UNIT 3   0   Atmospheric pressure unit T006
33 VAPRES OIB_VAPRES OIB_PRES FLTP 16   16   Vapor pressure of liquid petroleum gases (LPG)  
34 VAPRESEH OIB_VAPRESEH MEINS UNIT 3   0   Vapor pressure unit (LPG) T006
35 THVALEH OIB_HVEH MEINS UNIT 3   0   Heating value unit T006
36 MTCOMBTMP OIB_MTCOMBTMP TEMP_VALUE FLTP 16   16   Natural gas material combustion temp.: observed quantity  
37 MTCOMBTEH OIB_MTCOMBTEH MEINS UNIT 3   0   Natural gas material combustion temp. unit: obs. quantity T006
38 MTCOMBPRES OIB_MTCOMBPRES OIB_PRES FLTP 16   16   Natural gas material combustion pressure: observed quantity  
39 MTCOMBPRESEH OIB_MTCOMBPRESEH MEINS UNIT 3   0   Natural gas material combustion pres. unit: oberved quantity T006
40 TSTMPCAL OIB_TSTMPCAL TEMP_VALUE FLTP 16   16   Natural gas: Calorimeter test temperature (density)  
41 TSTMPCALEH OIB_TSTMPCALEH MEINS UNIT 3   0   Natural gas: unit for calorimeter test temperature (density) T006
42 TPREDCAL OIB_TPREDCAL OIB_PRES FLTP 16   16   Natural gas: Calorimeter test pressure (density)  
43 TPREDCALEH OIB_TPREDCALEH MEINS UNIT 3   0   Natural gas: Unit for calorimeter test pressure (density) T006
44 .INCLUDE       0   0   Quantity conversion interface - other parts  
45 HYDRO OIB_HYDRO OIB_XFELD CHAR 1   0   Hydrometer Correction Indicator  
46 ABIND OIB_ABIND OIB_XFELD CHAR 1   0   Air Bouyancy Indicator  
47 ABFAC OIB_ABFAC OIB_ABFAC DEC 3   1   Air Bouyancy Factor  
48 MCF OIB_MCF1 OIB_VCF FLTP 16   16   Meter correction factor  
49 BSWCN OIB_BSWCN OIB_BSWCN FLTP 16   16   BSW %  
50 BSWCNEH OIB_BSWCNEH MEINS UNIT 3   0   BSW % unit (volume %, mol %, mass % or proportion ) T006
51 HVCLS OIB_HVCLS OIB_HVCLS CHAR 2   0   Heating value class (calorific value class)  
52 HVCLS_TO OIB_HVCLS OIB_HVCLS CHAR 2   0   Heating value class (calorific value class)  
53 DEFAULT_GUID GUID_32 SYSUUID_C CHAR 32   0   GUID in 'CHAR' Format in Uppercase  
54 .INCLUDE       0   0   HPM:QCI:chemical analysis data for natural gas (ISO comp.)  
55 CH4RATIO OIB_CH4RAT OIB_RAT FLTP 16   16   Natural gas CH4 content (ratio)  
56 N2RATIO OIB_N2RAT OIB_RAT FLTP 16   16   Natural gas N2 (nitrogen) content (ratio)  
57 CO2RATIO OIB_CO2RAT OIB_RAT FLTP 16   16   Natural gas CO2 content (ratio)  
58 C2H6RATIO OIB_C2H6RAT OIB_RAT FLTP 16   16   Natural gas C2H6 (ethane) content (ratio)  
59 C3H8RATIO OIB_C3H8RAT OIB_RAT FLTP 16   16   Natural gas C3H8 (propane) content (ratio)  
60 H2ORATIO OIB_H2ORAT OIB_RAT FLTP 16   16   Natural gas H2O content (ratio)  
61 H2SRATIO OIB_H2SRAT OIB_RAT FLTP 16   16   Natural gas H2S content (ratio)  
62 H2RATIO OIB_H2RAT OIB_RAT FLTP 16   16   Natural gas H2 (Hydrogen) content (ratio)  
63 CORATIO OIB_CORAT OIB_RAT FLTP 16   16   Natural gas CO content (ratio)  
64 O2RATIO OIB_O2RAT OIB_RAT FLTP 16   16   Natural gas oxygen (O2) content (ratio)  
65 ISOC4H10RATIO OIB_ISOC4H10RAT OIB_RAT FLTP 16   16   Natural gas ISO-C4H10 (iso-butane ) content (ratio)  
66 NC4H10RATIO OIB_NC4H10RAT OIB_RAT FLTP 16   16   Natural gas n-C4H10 (n-butane ) content (ratio)  
67 ISOC5H12RATIO OIB_ISOC5H12RAT OIB_RAT FLTP 16   16   Natural gas ISO-C5H12 (ISO-pentane ) content (ratio)  
68 NC5H12RATIO OIB_NC5H12RAT OIB_RAT FLTP 16   16   Natural gas n-C5H12 (n-pentane ) content (ratio)  
69 C6H14RATIO OIB_C6H14RAT OIB_RAT FLTP 16   16   Natural gas C6H14 (n-hexane ) content (ratio)  
70 C7H16RATIO OIB_C7H16RAT OIB_RAT FLTP 16   16   Natural gas C7H16 (n-heptane ) content (ratio)  
71 C8H18RATIO OIB_C8H18RAT OIB_RAT FLTP 16   16   Natural gas C8H18 (n-octane ) content (ratio)  
72 C9H20RATIO OIB_C9H20RAT OIB_RAT FLTP 16   16   Natural gas C9H20 (n-Nonane ) content (ratio)  
73 C10H22RATIO OIB_C10H22RAT OIB_RAT FLTP 16   16   Natural gas C10H22 (n-Decane ) content (ratio)  
74 HERATIO OIB_HERAT OIB_RAT FLTP 16   16   Natural gas He (Helium) content (ratio)  
75 ARRATIO OIB_ARRAT OIB_RAT FLTP 16   16   Natural gas Argon content (ratio)  
76 GASCOMPRATEH OIB_GASCOMPRATEH MEINS UNIT 3   0   Unit (vol. %, mol % or mass % ) of natural gas composition T006
77 MOLDEN OIB_MOLDEN OIB_DICHT FLTP 16   16   Natural gas molar density (mol/volume) at standard condition  
78 MOLDENEH OIB_MOLDENEH MEINS UNIT 3   0   Unit for molar density at base conditions ( nat.gas) T006
79 MOLWEIGHT OIB_MOLWEIGHT OIB_MOLWEIGHT FLTP 16   16   Molecular weight of natural gas:return value from AGA c-code  
80 HYDROCARBMOLFRAC OIB_HYDROCARBMOLFRAC OIB_FRAC FLTP 16   16   Hydrocarbon mole fraction calculated from AGA c-code  
81 MOLWEIGHTEH OIB_MOLWEIGHTEH MEINS UNIT 3   0   Unit for molar mass T006
82 .INCLUDE       0   0   Strcuture for QCI parameters: customer defined fields  
83 CUSTPARCHAR1 OIB_CUSTPARCHAR1 OIB_CUSTPARCHAR CHAR 3   0   Customer parameter character field 1  
84 CUSTPARFLOAT1 OIB_CUSTPARFLOAT1 OIB_CUSTPARFLO FLTP 16   16   Customer parameter float 1  
85 CUSTEH1 OIB_CUSTEH1 MEINS UNIT 3   0   Customer parameter 1 unit T006
86 CUSTPARCHAR2 OIB_CUSTPARCHAR2 OIB_CUSTPARCHAR CHAR 3   0   Customer parameter character field 2  
87 CUSTPARFLOAT2 OIB_CUSTPARFLOAT2 OIB_CUSTPARFLO FLTP 16   16   Customer parameter float 2  
88 CUSTEH2 OIB_CUSTEH2 MEINS UNIT 3   0   Customer parameter 2 unit T006
89 CUSTPARCHAR3 OIB_CUSTPARCHAR3 OIB_CUSTPARCHAR CHAR 3   0   Customer parameter character field 3  
90 CUSTPARFLOAT3 OIB_CUSTPARFLOAT3 OIB_CUSTPARFLO FLTP 16   16   Customer parameter float 3  
91 CUSTEH3 OIB_CUSTEH3 MEINS UNIT 3   0   Customer parameter 3 unit T006
92 .INCLUDE       0   0   Runtime Parameters to Control Processing of QCI  
93 QCI_USE_CASE OIB_SD_QCI_USE_CASE OIB_SD_QCI_USE_CASE NUMC 3   0   Use Case of QCI Calculation in SD  
94 IS_QCI_RELEVANT BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
95 CMETH OIB_CMETH OIB_CMETH CHAR 1   0   Quantity Conversion Method  
96 CMETH_WRK OIB_CMETH OIB_CMETH CHAR 1   0   Quantity Conversion Method  
97 UOMGR OIB_UOMGR OIB_UOMGR CHAR 3   0   Unit of Mearsure Group (Oil, Natural Gas,...) *
98 NEW_DEFAULTS BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
99 USE_NEW_QCI_SCREEN BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
100 WKSTA OIB_WKSTA OIB_WKSTA CHAR 1   0   QCI working status  
101 CONVERSION_DONE BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
102 DISPLAY_ONLY BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
103 LIPSO1_FILLED_EXTERNALLY BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
104 LIPSO2_FILLED_EXTERNALLY BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
105 LISOF LISOF LISOF CHAR 1   0   Create delivery immediately  
106 IS_TAS_RELEVANT CHAR_01 CHAR01 CHAR 1   0   Character length 1  
107 IS_BSPLIT_MAIN_ITEM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
108 IS_BSPLIT_SUBITEM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
109 IS_BSPLIT_LAST_ITEM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
110 PSTYV PSTYV_VL PSTYV CHAR 4   0   Delivery item category *
111 OIBOM OIB_BOM OIB_BOM CHAR 1   0   Use of item category as part of an Oil bill of material(BOM)  
112 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator *
113 ORDER_KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
114 .INCLUDE       0   0   Runtime Parameters to Reflect QCI Related Delivery Data  
115 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
116 WADAT WADAT DATUM DATS 8   0   Goods Issue Date  
117 LFDAT LFDAT DATUM DATS 8   0   Delivery date  
118 LFUHR LFUHR LFUHR TIMS 6   0   Time of delivery  
119 .INCLUDE       0   0   Runtime Parameters to Reflect QCI Related Delivery Item Data  
120 MATNR MATNR MATNR CHAR 18   0   Material Number *
121 WERKS WERKS_D WERKS CHAR 4   0   Plant *
122 LGORT LGORT_D LGORT CHAR 4   0   Storage location *
123 CHARG CHARG_D CHARG CHAR 10   0   Batch Number *
124 XCHPF XCHPF XFELD CHAR 1   0   Batch management requirement indicator  
125 UECHA UECHA POSNR NUMC 6   0   Higher-Level Item of Batch Split Item *
126 LFIMG LFIMG MENG13 QUAN 13   3   Actual quantity delivered (in sales units)  
127 PIKMG PIKMG MENG13 QUAN 13   3   Pick/stock quantity in sales units  
128 VRKME VRKME MEINS UNIT 3   0   Sales unit *
129 LFIMG_OLD LFIMG MENG13 QUAN 13   3   Actual quantity delivered (in sales units)  
130 VRKME_OLD VRKME MEINS UNIT 3   0   Sales unit *
131 VRKME_BSMAIN VRKME MEINS UNIT 3   0   Sales unit *
132 QTY_VRKME_BSMAIN_OLD LFIMG MENG13 QUAN 13   3   Actual quantity delivered (in sales units)  
133 QTY_VRKME_BSMAIN_F_OLD OIB_ADQNT OIB_ADQNT FLTP 16   16   Additional Oil and Gas Quantity  
134 VRKME_BSMAIN_OLD VRKME MEINS UNIT 3   0   Sales unit *
135 LGMNG LGMNG MENG13 QUAN 13   3   Actual quantity delivered in stockkeeping units  
136 LGMNG_F OIB_ADQNT OIB_ADQNT FLTP 16   16   Additional Oil and Gas Quantity  
137 LGMNG_OLD LGMNG MENG13 QUAN 13   3   Actual quantity delivered in stockkeeping units  
138 LGMNG_F_OLD OIB_ADQNT OIB_ADQNT FLTP 16   16   Additional Oil and Gas Quantity  
139 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
140 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit *
141 VOLEH VOLEH MEINS UNIT 3   0   Volume unit *
142 DATUM LFDAT_V DATUM DATS 8   0   Delivery Date  
143 KZPOD KZPOD KZPOD CHAR 1   0   POD indicator (relevance, verification, confirmation)  
144 PODREL PODREL PODREL CHAR 1   0   POD Control (Proof of Delivery)  
145 HANDLE_LIPS TSEGGUID_LIPS SYSUUID_22 CHAR 22   0   Worldwide unique key for LIPS-VBELN & LIPS_POSNR  
146 GRUND REACD REACD CHAR 4   0   Reason for variance in POD  
147 OIH_LICTP OIH_LICTP OIH_LICTP CHAR 4   0   License type *
148 OIH_LICIN OIH_LICIN OIH_LICIN CHAR 10   0   Excise tax internal license number *
149 .INCLUDE       0   0   Runtime Parameters for Specific Processing of Oil BoMs  
150 IS_OILBOM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
151 IS_OILBOM_MAIN_ITEM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
152 IS_OILBOM_SUBITEM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
153 IS_OILBOM_LAST_ITEM BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
154 IS_BOM_CONVERTED BOOLEAN BOOLEAN CHAR 1   0   Boolean Variable (X=True, -=False, Space=Unknown)  
155 UEPOS UEPOS POSNR NUMC 6   0   Higher-level item in bill of material structures *
156 TEMP_BOM_HDR OIB_BSTEH MEINS UNIT 3   0   Oil/gas standard/base temperature unit *
157 BASE_UOM_BOM_HDR MEINS MEINS UNIT 3   0   Base Unit of Measure *
158 DENS_BOM_HDR OIB_DNTYP OIB_DNTYP CHAR 1   0   Density Type  
159 UMRSL_BOM_HDR OIB_UMRSL OIB_UMRSL CHAR 4   0   Conversion Group (Oil, Natural Gas,..) *
160 PSTYV_BOM_HDR PSTYV_VL PSTYV CHAR 4   0   Delivery item category *
161 OIBOM_BOM_HDR OIB_BOM OIB_BOM CHAR 1   0   Use of item category as part of an Oil bill of material(BOM)  
162 CMETH_BOM_HDR OIB_CMETH OIB_CMETH CHAR 1   0   Quantity Conversion Method  
163 UPDKZ UPDKZ_D UPDKZ CHAR 1   0   Update indicator  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 OIB_LIPSO1_WRK ATPRESEH T006 MSEHI    
2 OIB_LIPSO1_WRK BDICHEH T006 MSEHI    
3 OIB_LIPSO1_WRK BHVALEH T006 MSEHI    
4 OIB_LIPSO1_WRK BSWCNEH T006 MSEHI    
5 OIB_LIPSO1_WRK CUSTEH1 T006 MSEHI    
6 OIB_LIPSO1_WRK CUSTEH2 T006 MSEHI    
7 OIB_LIPSO1_WRK CUSTEH3 T006 MSEHI    
8 OIB_LIPSO1_WRK FDICHEH T006 MSEHI    
9 OIB_LIPSO1_WRK GASCOMPRATEH T006 MSEHI    
10 OIB_LIPSO1_WRK MANDT T000 MANDT    
11 OIB_LIPSO1_WRK MOLDENEH T006 MSEHI    
12 OIB_LIPSO1_WRK MOLWEIGHTEH T006 MSEHI    
13 OIB_LIPSO1_WRK MTCOMBPRESEH T006 MSEHI    
14 OIB_LIPSO1_WRK MTCOMBTEH T006 MSEHI    
15 OIB_LIPSO1_WRK MTPRESEH T006 MSEHI    
16 OIB_LIPSO1_WRK MTTEH T006 MSEHI    
17 OIB_LIPSO1_WRK POSNR VBUP POSNR    
18 OIB_LIPSO1_WRK TDICHEH T006 MSEHI    
19 OIB_LIPSO1_WRK THVALEH T006 MSEHI    
20 OIB_LIPSO1_WRK TPREDCALEH T006 MSEHI    
21 OIB_LIPSO1_WRK TPREDEH T006 MSEHI    
22 OIB_LIPSO1_WRK TPRHVEH T006 MSEHI    
23 OIB_LIPSO1_WRK TSTEH T006 MSEHI    
24 OIB_LIPSO1_WRK TSTMPCALEH T006 MSEHI    
25 OIB_LIPSO1_WRK TTMPHVEH T006 MSEHI    
26 OIB_LIPSO1_WRK UMRSL OIB01 UMRSL    
27 OIB_LIPSO1_WRK VAPRESEH T006 MSEHI    
28 OIB_LIPSO1_WRK VBELN VBUK VBELN    
History
Last changed by/on SAP  20130529 
SAP Release Created in