OIB_LIPSO1_WRK SAP (Posting structure for LIPSO1) Structure details
Description: Posting structure for LIPSO1
Related tables to OIB_LIPSO1_WRK
Access table OIB_LIPSO1_WRK
Structure field list including key, data, relationships and ABAP select examples
OIB_LIPSO1_WRK is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Posting structure for LIPSO1" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_OIB_LIPSO1_WRK TYPE OIB_LIPSO1_WRK.
The OIB_LIPSO1_WRK table consists of various fields, each holding specific information or linking keys about Posting structure for LIPSO1 data available in SAP. These include MANDT (Client), VBELN (Delivery), POSNR (Delivery Item), UMRSL (Conversion Group (Oil, Natural Gas,..)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP OIB_LIPSO1_WRK structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | ALPHA | VBELN | VL | |
POSNR | Delivery Item | POSNR_VL | NUMC | 6 | VBUP | POSNR | |||
UMRSL | Conversion Group (Oil, Natural Gas,..) | OIB_UMRSL | CHAR | 4 | OIB01 | OIB_UMRSL | |||
CMODE | Conversion Mode | OIB_CMODE | CHAR | 1 | OIB_CMODE | ||||
FDICHEH | Unit for densities at standard/base conditions | OIB_BDNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
FDICH | Fixed Density | OIB_FDICH | FLTP | 16(16) | OIB_DICHT | ||||
COEFF | Quantity Conversion Coefficient | OIB_COEFF | FLTP | 16(16) | OIB_COEFF | ||||
BDICHEH | Unit for densities at standard/base conditions | OIB_BDNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BDICH | Oil/gas density at standard/base conditions | OIB_BDICH | FLTP | 16(16) | OIB_DICHT | ||||
BHVALEH | Heating value unit at standard/base conditions (natural gas) | OIB_BHVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
BHVAL | Heating value at standard/base conditions (natural gas) | OIB_BHVAL | FLTP | 16(16) | OIB_HVAL | ||||
TSTMP | Oil/Gas Test Temperature: Observed Density | OIB_TSTMP | FLTP | 16(16) | TEMP_VALUE | ||||
TSTEH | Test Temperature Unit (Density): Measurement | OIB_TSTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MTTMP | Oil/Gas Material Temperature: Observed Quantity | OIB_MTTMP | FLTP | 16(16) | TEMP_VALUE | ||||
MTTEH | Oil/Gas Material Temperature Unit: Observed Quantity | OIB_MTTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
THVAL | Heating value at test conditions (natural gas): observed | OIB_THVAL | FLTP | 16(16) | OIB_HVAL | ||||
TDICHEH | Unit for densities of petroleum products and natural gas | OIB_DNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TDICH | Oil/Gas Test Density | OIB_TDICH | FLTP | 16(16) | OIB_DICHT | ||||
MTPRES | Oil/gas material pressure: observed quantity | OIB_MTPRES | FLTP | 16(16) | OIB_PRES | ||||
MTPRESEH | Oil/gas material pressure unit: observed quantity | OIB_MTPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TPRED | Oil/gas test pressure: metering (obs. density) | OIB_TPRED | FLTP | 16(16) | OIB_PRES | ||||
TPREDEH | Oil/Gas test press. unit: metering (density) | OIB_TPREDEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TPRHV | Natural gas test pressure: combustion (obs. heating value ) | OIB_TPRHV | FLTP | 16(16) | OIB_PRES | ||||
TPRHVEH | Natural gas test pressure unit: combustion ( heating value ) | OIB_TPRHVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TTMPHV | Natural gas test temperature: combustion (obs. heat. value ) | OIB_TTMPHV | FLTP | 16(16) | TEMP_VALUE | ||||
TTMPHVEH | Natural gas test temp. unit: combustion (heating value) | OIB_TTMPHVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
ATPRES | Atmospheric pressure of the air surrounding a product | OIB_ATPRES | FLTP | 16(16) | OIB_PRES | ||||
ATPRESEH | Atmospheric pressure unit | OIB_ATPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VAPRES | Vapor pressure of liquid petroleum gases (LPG) | OIB_VAPRES | FLTP | 16(16) | OIB_PRES | ||||
VAPRESEH | Vapor pressure unit (LPG) | OIB_VAPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
THVALEH | Heating value unit | OIB_HVEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MTCOMBTMP | Natural gas material combustion temp.: observed quantity | OIB_MTCOMBTMP | FLTP | 16(16) | TEMP_VALUE | ||||
MTCOMBTEH | Natural gas material combustion temp. unit: obs. quantity | OIB_MTCOMBTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MTCOMBPRES | Natural gas material combustion pressure: observed quantity | OIB_MTCOMBPRES | FLTP | 16(16) | OIB_PRES | ||||
MTCOMBPRESEH | Natural gas material combustion pres. unit: oberved quantity | OIB_MTCOMBPRESEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TSTMPCAL | Natural gas: Calorimeter test temperature (density) | OIB_TSTMPCAL | FLTP | 16(16) | TEMP_VALUE | ||||
TSTMPCALEH | Natural gas: unit for calorimeter test temperature (density) | OIB_TSTMPCALEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
TPREDCAL | Natural gas: Calorimeter test pressure (density) | OIB_TPREDCAL | FLTP | 16(16) | OIB_PRES | ||||
TPREDCALEH | Natural gas: Unit for calorimeter test pressure (density) | OIB_TPREDCALEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
HYDRO | Hydrometer Correction Indicator | OIB_HYDRO | CHAR | 1 | OIB_XFELD | ||||
ABIND | Air Bouyancy Indicator | OIB_ABIND | CHAR | 1 | OIB_XFELD | ||||
ABFAC | Air Bouyancy Factor | OIB_ABFAC | DEC | 3(1) | OIB_ABFAC | ||||
MCF | Meter correction factor | OIB_MCF1 | FLTP | 16(16) | OIB_VCF | ||||
BSWCN | BSW % | OIB_BSWCN | FLTP | 16(16) | OIB_BSWCN | ||||
BSWCNEH | BSW % unit (volume %, mol %, mass % or proportion ) | OIB_BSWCNEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
HVCLS | Heating value class (calorific value class) | OIB_HVCLS | CHAR | 2 | OIB_HVCLS | ||||
HVCLS_TO | Heating value class (calorific value class) | OIB_HVCLS | CHAR | 2 | OIB_HVCLS | ||||
DEFAULT_GUID | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | SYSUUID_C | ||||
CH4RATIO | Natural gas CH4 content (ratio) | OIB_CH4RAT | FLTP | 16(16) | OIB_RAT | ||||
N2RATIO | Natural gas N2 (nitrogen) content (ratio) | OIB_N2RAT | FLTP | 16(16) | OIB_RAT | ||||
CO2RATIO | Natural gas CO2 content (ratio) | OIB_CO2RAT | FLTP | 16(16) | OIB_RAT | ||||
C2H6RATIO | Natural gas C2H6 (ethane) content (ratio) | OIB_C2H6RAT | FLTP | 16(16) | OIB_RAT | ||||
C3H8RATIO | Natural gas C3H8 (propane) content (ratio) | OIB_C3H8RAT | FLTP | 16(16) | OIB_RAT | ||||
H2ORATIO | Natural gas H2O content (ratio) | OIB_H2ORAT | FLTP | 16(16) | OIB_RAT | ||||
H2SRATIO | Natural gas H2S content (ratio) | OIB_H2SRAT | FLTP | 16(16) | OIB_RAT | ||||
H2RATIO | Natural gas H2 (Hydrogen) content (ratio) | OIB_H2RAT | FLTP | 16(16) | OIB_RAT | ||||
CORATIO | Natural gas CO content (ratio) | OIB_CORAT | FLTP | 16(16) | OIB_RAT | ||||
O2RATIO | Natural gas oxygen (O2) content (ratio) | OIB_O2RAT | FLTP | 16(16) | OIB_RAT | ||||
ISOC4H10RATIO | Natural gas ISO-C4H10 (iso-butane ) content (ratio) | OIB_ISOC4H10RAT | FLTP | 16(16) | OIB_RAT | ||||
NC4H10RATIO | Natural gas n-C4H10 (n-butane ) content (ratio) | OIB_NC4H10RAT | FLTP | 16(16) | OIB_RAT | ||||
ISOC5H12RATIO | Natural gas ISO-C5H12 (ISO-pentane ) content (ratio) | OIB_ISOC5H12RAT | FLTP | 16(16) | OIB_RAT | ||||
NC5H12RATIO | Natural gas n-C5H12 (n-pentane ) content (ratio) | OIB_NC5H12RAT | FLTP | 16(16) | OIB_RAT | ||||
C6H14RATIO | Natural gas C6H14 (n-hexane ) content (ratio) | OIB_C6H14RAT | FLTP | 16(16) | OIB_RAT | ||||
C7H16RATIO | Natural gas C7H16 (n-heptane ) content (ratio) | OIB_C7H16RAT | FLTP | 16(16) | OIB_RAT | ||||
C8H18RATIO | Natural gas C8H18 (n-octane ) content (ratio) | OIB_C8H18RAT | FLTP | 16(16) | OIB_RAT | ||||
C9H20RATIO | Natural gas C9H20 (n-Nonane ) content (ratio) | OIB_C9H20RAT | FLTP | 16(16) | OIB_RAT | ||||
C10H22RATIO | Natural gas C10H22 (n-Decane ) content (ratio) | OIB_C10H22RAT | FLTP | 16(16) | OIB_RAT | ||||
HERATIO | Natural gas He (Helium) content (ratio) | OIB_HERAT | FLTP | 16(16) | OIB_RAT | ||||
ARRATIO | Natural gas Argon content (ratio) | OIB_ARRAT | FLTP | 16(16) | OIB_RAT | ||||
GASCOMPRATEH | Unit (vol. %, mol % or mass % ) of natural gas composition | OIB_GASCOMPRATEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MOLDEN | Natural gas molar density (mol/volume) at standard condition | OIB_MOLDEN | FLTP | 16(16) | OIB_DICHT | ||||
MOLDENEH | Unit for molar density at base conditions ( nat.gas) | OIB_MOLDENEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
MOLWEIGHT | Molecular weight of natural gas:return value from AGA c-code | OIB_MOLWEIGHT | FLTP | 16(16) | OIB_MOLWEIGHT | ||||
HYDROCARBMOLFRAC | Hydrocarbon mole fraction calculated from AGA c-code | OIB_HYDROCARBMOLFRAC | FLTP | 16(16) | OIB_FRAC | ||||
MOLWEIGHTEH | Unit for molar mass | OIB_MOLWEIGHTEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
CUSTPARCHAR1 | Customer parameter character field 1 | OIB_CUSTPARCHAR1 | CHAR | 3 | OIB_CUSTPARCHAR | ||||
CUSTPARFLOAT1 | Customer parameter float 1 | OIB_CUSTPARFLOAT1 | FLTP | 16(16) | OIB_CUSTPARFLO | ||||
CUSTEH1 | Customer parameter 1 unit | OIB_CUSTEH1 | UNIT | 3 | T006 | CUNIT | MEINS | ||
CUSTPARCHAR2 | Customer parameter character field 2 | OIB_CUSTPARCHAR2 | CHAR | 3 | OIB_CUSTPARCHAR | ||||
CUSTPARFLOAT2 | Customer parameter float 2 | OIB_CUSTPARFLOAT2 | FLTP | 16(16) | OIB_CUSTPARFLO | ||||
CUSTEH2 | Customer parameter 2 unit | OIB_CUSTEH2 | UNIT | 3 | T006 | CUNIT | MEINS | ||
CUSTPARCHAR3 | Customer parameter character field 3 | OIB_CUSTPARCHAR3 | CHAR | 3 | OIB_CUSTPARCHAR | ||||
CUSTPARFLOAT3 | Customer parameter float 3 | OIB_CUSTPARFLOAT3 | FLTP | 16(16) | OIB_CUSTPARFLO | ||||
CUSTEH3 | Customer parameter 3 unit | OIB_CUSTEH3 | UNIT | 3 | T006 | CUNIT | MEINS | ||
QCI_USE_CASE | Use Case of QCI Calculation in SD | OIB_SD_QCI_USE_CASE | NUMC | 3 | OIB_SD_QCI_USE_CASE | ||||
IS_QCI_RELEVANT | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
CMETH | Quantity Conversion Method | OIB_CMETH | CHAR | 1 | OIB_CMETH | ||||
CMETH_WRK | Quantity Conversion Method | OIB_CMETH | CHAR | 1 | OIB_CMETH | ||||
UOMGR | Unit of Mearsure Group (Oil, Natural Gas,...) | OIB_UOMGR | CHAR | 3 | Assigned to domain | OIB_UOMGR | |||
NEW_DEFAULTS | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
USE_NEW_QCI_SCREEN | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
WKSTA | QCI working status | OIB_WKSTA | CHAR | 1 | OIB_WKSTA | ||||
CONVERSION_DONE | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
DISPLAY_ONLY | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
LIPSO1_FILLED_EXTERNALLY | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
LIPSO2_FILLED_EXTERNALLY | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
LISOF | Create delivery immediately | LISOF | CHAR | 1 | LISOF | ||||
IS_TAS_RELEVANT | Character length 1 | CHAR_01 | CHAR | 1 | CHAR01 | ||||
IS_BSPLIT_MAIN_ITEM | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
IS_BSPLIT_SUBITEM | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
IS_BSPLIT_LAST_ITEM | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
PSTYV | Delivery item category | PSTYV_VL | CHAR | 4 | Assigned to domain | PSTYV | |||
OIBOM | Use of item category as part of an Oil bill of material(BOM) | OIB_BOM | CHAR | 1 | OIB_BOM | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
ORDER_KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
WADAT | Goods Issue Date | WADAT | DATS | 8 | DATUM | ||||
LFDAT | Delivery date | LFDAT | DATS | 8 | DATUM | ||||
LFUHR | Time of delivery | LFUHR | TIMS | 6 | LFUHR | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
UECHA | Higher-Level Item of Batch Split Item | UECHA | NUMC | 6 | Assigned to domain | POSNR | |||
LFIMG | Actual quantity delivered (in sales units) | LFIMG | QUAN | 13(3) | MENG13 | ||||
PIKMG | Pick/stock quantity in sales units | PIKMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LFIMG_OLD | Actual quantity delivered (in sales units) | LFIMG | QUAN | 13(3) | MENG13 | ||||
VRKME_OLD | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VRKME_BSMAIN | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QTY_VRKME_BSMAIN_OLD | Actual quantity delivered (in sales units) | LFIMG | QUAN | 13(3) | MENG13 | ||||
QTY_VRKME_BSMAIN_F_OLD | Additional Oil and Gas Quantity | OIB_ADQNT | FLTP | 16(16) | OIB_ADQNT | ||||
VRKME_BSMAIN_OLD | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LGMNG | Actual quantity delivered in stockkeeping units | LGMNG | QUAN | 13(3) | MENG13 | ||||
LGMNG_F | Additional Oil and Gas Quantity | OIB_ADQNT | FLTP | 16(16) | OIB_ADQNT | ||||
LGMNG_OLD | Actual quantity delivered in stockkeeping units | LGMNG | QUAN | 13(3) | MENG13 | ||||
LGMNG_F_OLD | Additional Oil and Gas Quantity | OIB_ADQNT | FLTP | 16(16) | OIB_ADQNT | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DATUM | Delivery Date | LFDAT_V | DATS | 8 | DATUM | ||||
KZPOD | POD indicator (relevance, verification, confirmation) | KZPOD | CHAR | 1 | KZPOD | ||||
PODREL | POD Control (Proof of Delivery) | PODREL | CHAR | 1 | PODREL | ||||
HANDLE_LIPS | Worldwide unique key for LIPS-VBELN & LIPS_POSNR | TSEGGUID_LIPS | CHAR | 22 | SYSUUID_22 | ||||
GRUND | Reason for variance in POD | REACD | CHAR | 4 | REACD | ||||
OIH_LICTP | License type | OIH_LICTP | CHAR | 4 | Assigned to domain | OIH_LICTP | OII | ||
OIH_LICIN | Excise tax internal license number | OIH_LICIN | CHAR | 10 | Assigned to domain | ALPHA | OIH_LICIN | OIH | OIHL |
IS_OILBOM | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
IS_OILBOM_MAIN_ITEM | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
IS_OILBOM_SUBITEM | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
IS_OILBOM_LAST_ITEM | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
IS_BOM_CONVERTED | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
UEPOS | Higher-level item in bill of material structures | UEPOS | NUMC | 6 | Assigned to domain | POSNR | |||
TEMP_BOM_HDR | Oil/gas standard/base temperature unit | OIB_BSTEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BASE_UOM_BOM_HDR | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DENS_BOM_HDR | Density Type | OIB_DNTYP | CHAR | 1 | OIB_DNTYP | ||||
UMRSL_BOM_HDR | Conversion Group (Oil, Natural Gas,..) | OIB_UMRSL | CHAR | 4 | Assigned to domain | OIB_UMRSL | |||
PSTYV_BOM_HDR | Delivery item category | PSTYV_VL | CHAR | 4 | Assigned to domain | PSTYV | |||
OIBOM_BOM_HDR | Use of item category as part of an Oil bill of material(BOM) | OIB_BOM | CHAR | 1 | OIB_BOM | ||||
CMETH_BOM_HDR | Quantity Conversion Method | OIB_CMETH | CHAR | 1 | OIB_CMETH | ||||
UPDKZ | Update indicator | UPDKZ_D | CHAR | 1 | UPDKZ |
Key field | Non-key field |
How do I retrieve data from SAP structure OIB_LIPSO1_WRK using ABAP code?
As OIB_LIPSO1_WRK is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on OIB_LIPSO1_WRK as there is no data to select.How to access SAP table OIB_LIPSO1_WRK
Within an ECC or HANA version of SAP you can also view further information about OIB_LIPSO1_WRK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects