OIHSLA

TDP (excise duty) special ledger actual line item table | #transactional | Component: Tariffs, Duties and Permits
Column Name Description
RCLNT FK Client
GL_SIRID Record number of the line item record
Column Name Description
💲 Currency Key (T001.WAERS):
ROITXVAL0 Excise duty tax value 0
ROITXVAL1 Excise duty tax value 1
ROITXVAL2 Excise duty tax value 2
ROITXVAL3 Excise duty tax value 3
ROITXVAL4 Excise duty tax value 4
ROITXVAL5 Excise duty tax value 5
ROITXVAL6 Excise duty tax value 6
ROITAXCON Excise duty tax from pricing conditions
ROITAXVAL Excise duty value in material inventory account
ROIFUTTX Future tax value
ROIFUTTX2 Future tax value 2
💲 Currency Key (RTCUR):
TSL Value in Transaction Currency
💲 Currency key of currency 2 (T882.CURR1):
HSL Value in local currency
💲 Currency key of currency 3 (T882.CURR2):
KSL Value in group currency
Column Name Description
📏 Base quantity for excise duty rate (e.g.per 1 or 100 UoM) (ROIUOMQT):
ROITAXQT Excise duty tax quantity in STBME
ROIFUTQT Future tax quantity
ROIFUTQT2 Future tax quantity 2
📏 Base Unit of Measure (RUNIT):
MSL Quantity
Column Name Description
ROIFUTDT Future tax date
ROIFUTDT2 Future tax date 2
BUDAT Posting Date in the Document
WSDAT Value Date for Currency Translation
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
Column Name Description
RRCTY Record Type Show values
DRCRK Debit/Credit Indicator Show values
DOCCT Document Category Show values
ROIPRICIE ED pricing: external (indicator) Show values
ROIOILCON Oil content in a material as a percentage Show values
ROIOILCON2 Oil content of a material as a percentage (2) Show values
REFDOCCT Document Category Show values
Column Name Description Domain name
RYEAR Fiscal Year GJAHR
POPER Posting period POPER
DOCNR Document Number of an Accounting Document BELNR
DOCLN Document line DOCLN
RACCT Account Number SAKNR
RCNTR Cost Center KOSTL
SGTXT Item Text TEXT50
AUTOM Indicator: Automatic posting lines TEXT1
ACTIV Business Transaction CHAR4
REFDOCNR Document Number of an Accounting Document BELNR
REFRYEAR Fiscal Year GJAHR
REFDOCLN Number of Line Item Within Accounting Document BUZEI
REFACTIV Business Transaction CHAR4
USNAM User Name XUBNAME
AWTYP Reference procedure AWTYP
AWORG Reference Organizational Units AWORG
Master Data Relations Join Conditions
Additional unit of measure
  • OIHSLA.RCLNT == T006.MANDT
  • OIHSLA.AUNIT == T006.MSEHI
FI-SL Document Type
  • OIHSLA.RCLNT == T889.MANDT
  • OIHSLA.DOCTY == T889.DOCTY
Logical system OIHSLA.LOGSYS == TBDLS.LOGSYS
Company Code
  • OIHSLA.RCLNT == T001.MANDT
  • OIHSLA.RBUKRS == T001.BUKRS
Business Area
  • OIHSLA.RCLNT == TGSB.MANDT
  • OIHSLA.RBUSA == TGSB.GSBER
Valuation Type
  • OIHSLA.RCLNT == T149D.MANDT
  • OIHSLA.RBWTAR == T149D.BWTAR
Client OIHSLA.RCLNT == T000.MANDT
Ledger
  • Ledger
  • Client
  • OIHSLA.RLDNR == T881.RLDNR
  • OIHSLA.RCLNT == T881.MANDT
Excise Duty Handling Type
  • Excise Duty Handling Type
  • Client
  • OIHSLA.ROIHANTYP == OIH5.HANTYP
  • OIHSLA.RCLNT == OIH5.MANDT
Excise duty tax key for 'from' location
  • OIHSLA.RCLNT == OIH4.MANDT
  • OIHSLA.ROITAXFRO == OIH4.TAXKEY
Excise Duty Group
  • OIHSLA.RCLNT == OIH2.MANDT
  • OIHSLA.ROITAXGRP == OIH2.TAXGRP
Excise duty tax key for 'to' location
  • OIHSLA.RCLNT == OIH4.MANDT
  • OIHSLA.ROITAXTO == OIH4.TAXKEY
Base quantity for excise duty rate (e.g.per 1 or 100 UoM)
  • OIHSLA.RCLNT == T006.MANDT
  • OIHSLA.ROIUOMQT == T006.MSEHI
Currency Key
  • OIHSLA.RCLNT == TCURC.MANDT
  • OIHSLA.RTCUR == TCURC.WAERS
Base Unit of Measure
  • OIHSLA.RCLNT == T006.MANDT
  • OIHSLA.RUNIT == T006.MSEHI
Version
  • Ledger
  • Client
  • Version
  • OIHSLA.RLDNR == T894.RLDNR
  • OIHSLA.RCLNT == T894.MANDT
  • OIHSLA.RVERS == T894.RVERS
Plant
  • OIHSLA.RCLNT == T001W.MANDT
  • OIHSLA.RWERKS == T001W.WERKS