LIPSO1 SAP (Appendix: Delivery Note - Conversion Parameters) Table details

Dictionary Type: Table
Description: Appendix: Delivery Note - Conversion Parameters




ABAP Code to SELECT data from LIPSO1
Related tables to LIPSO1
Access table LIPSO1




Table field list including key, data, relationships and ABAP select examples

LIPSO1 is a standard SAP Table which is used to store Appendix: Delivery Note - Conversion Parameters data and is available within R/3 SAP systems depending on the version and release level.

The LIPSO1 table consists of various fields, each holding specific information or linking keys about Appendix: Delivery Note - Conversion Parameters data available in SAP. These include VBELN (Delivery), POSNR (Delivery Item), UMRSL (Conversion Group (Oil, Natural Gas,..)), CMODE (Conversion Mode).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP LIPSO1 table 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
MANDTClient MANDTCLNT3T000MANDT
VBELNDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
POSNRDelivery Item POSNR_VLNUMC6VBUPPOSNR
UMRSLConversion Group (Oil, Natural Gas,..) OIB_UMRSLCHAR4OIB01OIB_UMRSL
CMODEConversion Mode OIB_CMODECHAR1OIB_CMODE
FDICHEHUnit for densities at standard/base conditions OIB_BDNEHUNIT3T006CUNITMEINS
FDICHFixed Density OIB_FDICHFLTP16(16) OIB_DICHT
COEFFQuantity Conversion Coefficient OIB_COEFFFLTP16(16) OIB_COEFF
BDICHEHUnit for densities at standard/base conditions OIB_BDNEHUNIT3T006CUNITMEINS
BDICHOil/gas density at standard/base conditions OIB_BDICHFLTP16(16) OIB_DICHT
BHVALEHHeating value unit at standard/base conditions (natural gas) OIB_BHVEHUNIT3T006CUNITMEINS
BHVALHeating value at standard/base conditions (natural gas) OIB_BHVALFLTP16(16) OIB_HVAL
TSTMPOil/Gas Test Temperature: Observed Density OIB_TSTMPFLTP16(16) TEMP_VALUE
TSTEHTest Temperature Unit (Density): Measurement OIB_TSTEHUNIT3T006CUNITMEINS
MTTMPOil/Gas Material Temperature: Observed Quantity OIB_MTTMPFLTP16(16) TEMP_VALUE
MTTEHOil/Gas Material Temperature Unit: Observed Quantity OIB_MTTEHUNIT3T006CUNITMEINS
THVALHeating value at test conditions (natural gas): observed OIB_THVALFLTP16(16) OIB_HVAL
TDICHEHUnit for densities of petroleum products and natural gas OIB_DNEHUNIT3T006CUNITMEINS
TDICHOil/Gas Test Density OIB_TDICHFLTP16(16) OIB_DICHT
MTPRESOil/gas material pressure: observed quantity OIB_MTPRESFLTP16(16) OIB_PRES
MTPRESEHOil/gas material pressure unit: observed quantity OIB_MTPRESEHUNIT3T006CUNITMEINS
TPREDOil/gas test pressure: metering (obs. density) OIB_TPREDFLTP16(16) OIB_PRES
TPREDEHOil/Gas test press. unit: metering (density) OIB_TPREDEHUNIT3T006CUNITMEINS
TPRHVNatural gas test pressure: combustion (obs. heating value ) OIB_TPRHVFLTP16(16) OIB_PRES
TPRHVEHNatural gas test pressure unit: combustion ( heating value ) OIB_TPRHVEHUNIT3T006CUNITMEINS
TTMPHVNatural gas test temperature: combustion (obs. heat. value ) OIB_TTMPHVFLTP16(16) TEMP_VALUE
TTMPHVEHNatural gas test temp. unit: combustion (heating value) OIB_TTMPHVEHUNIT3T006CUNITMEINS
ATPRESAtmospheric pressure of the air surrounding a product OIB_ATPRESFLTP16(16) OIB_PRES
ATPRESEHAtmospheric pressure unit OIB_ATPRESEHUNIT3T006CUNITMEINS
VAPRESVapor pressure of liquid petroleum gases (LPG) OIB_VAPRESFLTP16(16) OIB_PRES
VAPRESEHVapor pressure unit (LPG) OIB_VAPRESEHUNIT3T006CUNITMEINS
THVALEHHeating value unit OIB_HVEHUNIT3T006CUNITMEINS
MTCOMBTMPNatural gas material combustion temp.: observed quantity OIB_MTCOMBTMPFLTP16(16) TEMP_VALUE
MTCOMBTEHNatural gas material combustion temp. unit: obs. quantity OIB_MTCOMBTEHUNIT3T006CUNITMEINS
MTCOMBPRESNatural gas material combustion pressure: observed quantity OIB_MTCOMBPRESFLTP16(16) OIB_PRES
MTCOMBPRESEHNatural gas material combustion pres. unit: oberved quantity OIB_MTCOMBPRESEHUNIT3T006CUNITMEINS
TSTMPCALNatural gas: Calorimeter test temperature (density) OIB_TSTMPCALFLTP16(16) TEMP_VALUE
TSTMPCALEHNatural gas: unit for calorimeter test temperature (density) OIB_TSTMPCALEHUNIT3T006CUNITMEINS
TPREDCALNatural gas: Calorimeter test pressure (density) OIB_TPREDCALFLTP16(16) OIB_PRES
TPREDCALEHNatural gas: Unit for calorimeter test pressure (density) OIB_TPREDCALEHUNIT3T006CUNITMEINS
HYDROHydrometer Correction Indicator OIB_HYDROCHAR1OIB_XFELD
ABINDAir Bouyancy Indicator OIB_ABINDCHAR1OIB_XFELD
ABFACAir Bouyancy Factor OIB_ABFACDEC3(1) OIB_ABFAC
MCFMeter correction factor OIB_MCF1FLTP16(16) OIB_VCF
BSWCNBSW % OIB_BSWCNFLTP16(16) OIB_BSWCN
BSWCNEHBSW % unit (volume %, mol %, mass % or proportion ) OIB_BSWCNEHUNIT3T006CUNITMEINS
HVCLSHeating value class (calorific value class) OIB_HVCLSCHAR2OIB_HVCLS
HVCLS_TOHeating value class (calorific value class) OIB_HVCLSCHAR2OIB_HVCLS
DEFAULT_GUIDGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
CH4RATIONatural gas CH4 content (ratio) OIB_CH4RATFLTP16(16) OIB_RAT
N2RATIONatural gas N2 (nitrogen) content (ratio) OIB_N2RATFLTP16(16) OIB_RAT
CO2RATIONatural gas CO2 content (ratio) OIB_CO2RATFLTP16(16) OIB_RAT
C2H6RATIONatural gas C2H6 (ethane) content (ratio) OIB_C2H6RATFLTP16(16) OIB_RAT
C3H8RATIONatural gas C3H8 (propane) content (ratio) OIB_C3H8RATFLTP16(16) OIB_RAT
H2ORATIONatural gas H2O content (ratio) OIB_H2ORATFLTP16(16) OIB_RAT
H2SRATIONatural gas H2S content (ratio) OIB_H2SRATFLTP16(16) OIB_RAT
H2RATIONatural gas H2 (Hydrogen) content (ratio) OIB_H2RATFLTP16(16) OIB_RAT
CORATIONatural gas CO content (ratio) OIB_CORATFLTP16(16) OIB_RAT
O2RATIONatural gas oxygen (O2) content (ratio) OIB_O2RATFLTP16(16) OIB_RAT
ISOC4H10RATIONatural gas ISO-C4H10 (iso-butane ) content (ratio) OIB_ISOC4H10RATFLTP16(16) OIB_RAT
NC4H10RATIONatural gas n-C4H10 (n-butane ) content (ratio) OIB_NC4H10RATFLTP16(16) OIB_RAT
ISOC5H12RATIONatural gas ISO-C5H12 (ISO-pentane ) content (ratio) OIB_ISOC5H12RATFLTP16(16) OIB_RAT
NC5H12RATIONatural gas n-C5H12 (n-pentane ) content (ratio) OIB_NC5H12RATFLTP16(16) OIB_RAT
C6H14RATIONatural gas C6H14 (n-hexane ) content (ratio) OIB_C6H14RATFLTP16(16) OIB_RAT
C7H16RATIONatural gas C7H16 (n-heptane ) content (ratio) OIB_C7H16RATFLTP16(16) OIB_RAT
C8H18RATIONatural gas C8H18 (n-octane ) content (ratio) OIB_C8H18RATFLTP16(16) OIB_RAT
C9H20RATIONatural gas C9H20 (n-Nonane ) content (ratio) OIB_C9H20RATFLTP16(16) OIB_RAT
C10H22RATIONatural gas C10H22 (n-Decane ) content (ratio) OIB_C10H22RATFLTP16(16) OIB_RAT
HERATIONatural gas He (Helium) content (ratio) OIB_HERATFLTP16(16) OIB_RAT
ARRATIONatural gas Argon content (ratio) OIB_ARRATFLTP16(16) OIB_RAT
GASCOMPRATEHUnit (vol. %, mol % or mass % ) of natural gas composition OIB_GASCOMPRATEHUNIT3T006CUNITMEINS
MOLDENNatural gas molar density (mol/volume) at standard condition OIB_MOLDENFLTP16(16) OIB_DICHT
MOLDENEHUnit for molar density at base conditions ( nat.gas) OIB_MOLDENEHUNIT3T006CUNITMEINS
MOLWEIGHTMolecular weight of natural gas:return value from AGA c-code OIB_MOLWEIGHTFLTP16(16) OIB_MOLWEIGHT
HYDROCARBMOLFRACHydrocarbon mole fraction calculated from AGA c-code OIB_HYDROCARBMOLFRACFLTP16(16) OIB_FRAC
MOLWEIGHTEHUnit for molar mass OIB_MOLWEIGHTEHUNIT3T006CUNITMEINS
CUSTPARCHAR1Customer parameter character field 1 OIB_CUSTPARCHAR1CHAR3OIB_CUSTPARCHAR
CUSTPARFLOAT1Customer parameter float 1 OIB_CUSTPARFLOAT1FLTP16(16) OIB_CUSTPARFLO
CUSTEH1Customer parameter 1 unit OIB_CUSTEH1UNIT3T006CUNITMEINS
CUSTPARCHAR2Customer parameter character field 2 OIB_CUSTPARCHAR2CHAR3OIB_CUSTPARCHAR
CUSTPARFLOAT2Customer parameter float 2 OIB_CUSTPARFLOAT2FLTP16(16) OIB_CUSTPARFLO
CUSTEH2Customer parameter 2 unit OIB_CUSTEH2UNIT3T006CUNITMEINS
CUSTPARCHAR3Customer parameter character field 3 OIB_CUSTPARCHAR3CHAR3OIB_CUSTPARCHAR
CUSTPARFLOAT3Customer parameter float 3 OIB_CUSTPARFLOAT3FLTP16(16) OIB_CUSTPARFLO
CUSTEH3Customer parameter 3 unit OIB_CUSTEH3UNIT3T006CUNITMEINS

Key field Non-key field



How do I retrieve data from SAP table LIPSO1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on LIPSO1 to SELECT all data from the table
DATA: WA_LIPSO1 TYPE LIPSO1.

SELECT SINGLE *
FROM LIPSO1
INTO CORRESPONDING FIELDS OF WA_LIPSO1
WHERE...

How to access SAP table LIPSO1

Within an ECC or HANA version of SAP you can also view further information about LIPSO1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!