TXI_OIHSLA SAP (TDP (excise duty) special ledger actual line item table) Structure details

Dictionary Type: Structure
Description: TDP (excise duty) special ledger actual line item table




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




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

TXI_OIHSLA 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 "TDP (excise duty) special ledger actual line item table" 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_TXI_OIHSLA TYPE TXI_OIHSLA.

The TXI_OIHSLA table consists of various fields, each holding specific information or linking keys about TDP (excise duty) special ledger actual line item table data available in SAP. These include RCLNT (Client), GL_SIRID (Record number of the line item record), RLDNR (Ledger), RRCTY (Record Type).. 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 (character-type or numeric)


SAP TXI_OIHSLA 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
RCLNTClient MANDTCLNT3T000MANDT
GL_SIRIDRecord number of the line item record GU_RECIDCHAR18OBJNROBN
RLDNRLedger RLDNRCHAR2T881ALPHARLDNRGLNH_T881
RRCTYRecord Type RRCTYCHAR1RRCTY
RVERSVersion RVERSCHAR3T894ALPHARVERSGVS
RYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
RTCURCurrency Key RTCURCUKY5TCURCWAERSFWS
RUNITBase Unit of Measure MEINSUNIT3T006CUNITMEINS
DRCRKDebit/Credit Indicator SHKZGCHAR1SHKZG
POPERPosting period POPERNUMC3POPERPOPR
DOCCTDocument Type DOCCTCHAR1DOCCTGCT
DOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DOCLNDocument line DOCLNCHAR3DOCLN
RBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RACCTAccount Number RACCTCHAR10Assigned to domainALPHASAKNRACC
RBWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
RWERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
ROITAXGRPExcise Duty Group OIH_TAXGRPCHAR2OIH2OIH_TAXGRP
ROIHANTYPExcise Duty Handling Type OIH_HANTYPCHAR2OIH5OIH_HANTYP
ROITAXFROExcise duty tax key for 'from' location OIH_TAXFROCHAR2OIH4OIH_TAXKEY
ROITAXTOExcise duty tax key for 'to' location OIH_TAXTOCHAR2OIH4OIH_TAXKEY
RBUSABusiness Area GSBERCHAR4TGSBGSBERGSB
ROIPRICIEED pricing: external (indicator) OIH_PRICIECHAR1X
ROITXVAL0Excise duty tax value 0 OIH_TXVAL0CURR13(2) OIH_TXVAL
ROITXVAL1Excise duty tax value 1 OIH_TXVAL1CURR13(2) OIH_TXVAL
ROITXVAL2Excise duty tax value 2 OIH_TXVAL2CURR13(2) OIH_TXVAL
ROITXVAL3Excise duty tax value 3 OIH_TXVAL3CURR13(2) OIH_TXVAL
ROITXVAL4Excise duty tax value 4 OIH_TXVAL4CURR13(2) OIH_TXVAL
ROITXVAL5Excise duty tax value 5 OIH_TXVAL5CURR13(2) OIH_TXVAL
ROITXVAL6Excise duty tax value 6 OIH_TXVAL6CURR13(2) OIH_TXVAL
ROIOILCONOil content in a material as a percentage OIH_OILCONDEC5(2) OIH_OILCON
ROITAXCONExcise duty tax from pricing conditions OIH_TAXCONCURR13(2) OIH_TAXCON
ROITAXVALExcise duty value in material inventory account OIH_TAXVALCURR13(2) OIH_TXVAL
ROIOILCON2Oil content of a material as a percentage (2) OIH_OILCN2DEC5(2) OIH_OILCON
ROIUOMQTBase quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQTUNIT3T006CUNITMEINS
ROITAXQTExcise duty tax quantity in STBME OIH_TAXQTQUAN13(3) MENGE
ROIFUTQTFuture tax quantity OIH_FUTQTQUAN13(3) MENGE
ROIFUTTXFuture tax value OIH_FUTTXCURR13(2) OIH_TXVAL
ROIFUTDTFuture tax date OIH_FUTDTDATS8DATUM
ROIFUTQT2Future tax quantity 2 OIH_FUTQT2QUAN13(3) MENGE
ROIFUTTX2Future tax value 2 OIH_FUTTX2CURR13(2) OIH_TXVAL
ROIFUTDT2Future tax date 2 OIH_FUTDT2DATS8DATUM
RCNTRCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
TSLValue in Transaction Currency VTCUR9CURR17(2) WERTV9
HSLValue in local currency VLCUR9CURR17(2) WERTV9
KSLValue in group currency VGCUR9CURR17(2) WERTV9
MSLQuantity QUAN1QUAN15(3) MENG8
AUNITAdditional unit of measure AUNITUNIT3T006CUNITMEINS
SGTXTItem Text SGTXTCHAR50TEXT50
AUTOMIndicator: Automatic posting lines AUTOMCHAR1TEXT1
DOCTYFI-SL Document Type DOCTYCHAR2T889DOCTYBAR
ACTIVBusiness Transaction GLVORCHAR4CHAR4
BUDATPosting Date in the Document BUDATDATS8DATUM
WSDATValue Date for Currency Translation WSDATDATS8DATUMWSD
REFDOCNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
REFRYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
REFDOCLNNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
REFDOCCTDocument Type DOCCTCHAR1DOCCTGCT
REFACTIVBusiness Transaction GLVORCHAR4CHAR4
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AWORGReference Organizational Units AWORGCHAR10AWORG
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
ROITXVAL0_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITXVAL1_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITXVAL2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITXVAL3_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITXVAL4_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITXVAL5_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITXVAL6_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITAXCON_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITAXVAL_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROITAXQT_QYBase quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQTUNIT3Assigned to domainCUNITMEINS
ROIFUTQT_QYBase quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQTUNIT3Assigned to domainCUNITMEINS
ROIFUTTX_CYCUKY for SYST SYCUKYCUKY5SYCUKY
ROIFUTQT2_QYBase quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQTUNIT3Assigned to domainCUNITMEINS
ROIFUTTX2_CYCUKY for SYST SYCUKYCUKY5SYCUKY
TSL_CYCUKY for SYST SYCUKYCUKY5SYCUKY
HSL_CYCUKY for SYST SYCUKYCUKY5SYCUKY
KSL_CYCUKY for SYST SYCUKYCUKY5SYCUKY
MSL_QYUnit of measure RUNITUNIT3CUNITEINHEIT

Key field Non-key field



How do I retrieve data from SAP structure TXI_OIHSLA using ABAP code?

As TXI_OIHSLA 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 TXI_OIHSLA as there is no data to select.

How to access SAP table TXI_OIHSLA

Within an ECC or HANA version of SAP you can also view further information about TXI_OIHSLA 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!