OIRADTLT SAP table for – Document transaction link table

Here we would like to draw your attention to OIRADTLT table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIRADTLT is a SAP standard transp table used for storing Document transaction link table related data in SAP. It comes under the package OIR.

SAP OIRADTLT table

Table OIRADTLT technical data

TableOIRADTLT
Data storingDocument transaction link table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIRADTLT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIRADTLT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LINKNR : Link number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITLINKNR : Item link number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • LINKYEAR : Document link number year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOCTYPE : Subsequent document type
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • DOCYEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOCNR : Sales and Distribution Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • POSNR : Item number of the SD document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SRCETAB : Source table
    Its data type is CHAR (Character String) with field length 16
  • DOCDATE : SSR – Document date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TARGETTAB : SSR – Target table
    Its data type is CHAR (Character String) with field length 30
  • COUNTER : Transaction counter
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • PROCDATE : Process execution date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8