OIKLID SAP (TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)) Table details

Dictionary Type: Table
Description: TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)




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




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

OIKLID is a standard SAP Table which is used to store TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) data and is available within R/3 SAP systems depending on the version and release level.

The OIKLID table consists of various fields, each holding specific information or linking keys about TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) data available in SAP. These include LIDNO (LOAD ID), LIDTYPE (LOAD ID type), CONTRTYP (Control structure type), LIDDESC (Load ID description).. 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 OIKLID 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
CLIENTClient MANDTCLNT3T000MANDT
LIDNOLOAD ID OIK_LIDCHAR30Assigned to domainALPHAOIK_LIDLIN
LIDTYPELOAD ID type OIK_LIDTYPCHAR6OIKLTOIK_LIDTYP
CONTRTYPControl structure type OIK_CNTTYPCHAR1OIK_CNTTYP
LIDDESCLoad ID description OIK_LIDTXTCHAR36TEXT36
LIDDEPOTLID used at depot OIK_LIDDEPCHAR30CHAR30
LID3COD13rd party code OIK_3RDCODCHAR30TEXT30
LIDACTINDLID activation indicator OIK_ACTINDCHAR1OIK_ACTIND
LIDDELINDLID deletion indicator OIK_DELINDCHAR1OIK_DELIND
LIDBLKINDLID blocking indicator OIK_BLKINDCHAR1OIK_BLKIND
LIDACTREASLID activation reason code OIK_ACTRCDCHAR2Assigned to domainOIK_REACOD
LIDDELREASLID deletion reason code OIK_DELRCDCHAR2Assigned to domainOIK_REACOD
LIDBLKREASLID blocking reason code OIK_BLKRCDCHAR2Assigned to domainOIK_REACOD
LID3RDPRTY3rd-party delivery number OIK_3RDDELCHAR30CHAR30
MATNR3RDP3rd party material info OIK_MAT3RDCHAR40TEXT40
MATTXT3RDP3rd party material text OIK_MTXTRDCHAR64TEXT64
CUST3RDP3rd party customer info OIK_CST3RDCHAR40TEXT40
MATNRTASTAS material number OIK_MATTASCHAR40TEXT40
ADDITTASTAS additive number OIK_ADDTASCHAR40TEXT40
LIDTASLoad ID TAS OIK_LIDTASCHAR30TEXT30
BSTYPPurchasing Document Category EBSTYPCHAR1EBSTYP
MMDOCNRSAP MM document number for TAS OIK_MDOCNOCHAR10EKKOALPHAEBELN
MMDITMNRSAP MM document item for TAS OIK_MITMNONUMC5EKPOEBELP
TASGRP1TAS Group 1 OIK_TASGRPCHAR8TOIKTGRPOIK_TASGRP
TASGRP2TAS Group 2 OIK_TASGR2CHAR8TOIKTGRPOIK_TASGRP
FUNCGROUPLOAD ID function group OIK_LIDGRPCHAR6TOIKLIDGOIK_LIDGRP
SDOCARTSubsequent document type OIK_DOCARTCHAR4Assigned to domainAUARTAUART
TASCFLAGCheck flag for load ID OIK_CFLAGCHAR1OIK_CFLAG
KALSUProcedure for material determination KALSUCHAR6Assigned to domainKALSM
CREAAUTHORAddresses: Created by CR_NAMCHAR12USERNAME
CREADATECreated on CRDATEDATS8DATUM
CREATIMECalendar: Creation or change time CRTIMETIMS6UZEIT
CHAUTHORAddresses: Changed by CH_NAMCHAR12USERNAME
CHDATEChanged On CHDATEDATS8DATUM
CHTIMECalendar: Creation or change time CRTIMETIMS6UZEIT
SOLDTOSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
SHIPTOShip-to party KUNWECHAR10KNA1ALPHAKUNNR
VSTELShipping Point/Receiving Point VSTELCHAR4TVSTVSTELVST
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
CHARGBatch Number CHARG_DCHAR10MCHBCHARGCHA
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
OIHANTYPExcise Duty Handling Type OIH_HANTYPCHAR2OIH5OIH_HANTYP
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
VEHICLETD Vehicle Number OIG_VHLNMRCHAR10OIGVALPHAOIG_VHLNMROIV
DRIVERCODETD driver number OIG_DRVNMRCHAR10OIGDALPHAOIG_DRVNMRDNO
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
SHIFTTD driver shift OIG_SHIFTCHAR1TOIGHOIG_SHIFT
TRIPTrip Number OIG_TRIPNUMC5OIG_TRIP
OIC_MOTIS-OIL MAP external details mode of transport OIC_MOTCHAR2TVTRVKTRA
VSBEDShipping Conditions VSBEDCHAR2TVSBVSBED
USERFLD1TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD2TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD3TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD4TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD5TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD6TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD7TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD8TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD9TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD10TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD11TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD12TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD13TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD14TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD15TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD16TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD17TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD18TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD19TAS user fields OIK_TASFLDCHAR30TEXT30
USERFLD20TAS user fields OIK_TASFLDCHAR30TEXT30

Key field Non-key field



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

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

SELECT SINGLE *
FROM OIKLID
INTO CORRESPONDING FIELDS OF WA_OIKLID
WHERE...

How to access SAP table OIKLID

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