OIGSS SAP (TD Shipment Stages) Table details

Dictionary Type: Table
Description: TD Shipment Stages




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




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

OIGSS is a standard SAP Table which is used to store TD Shipment Stages data and is available within R/3 SAP systems depending on the version and release level.

The OIGSS table consists of various fields, each holding specific information or linking keys about TD Shipment Stages data available in SAP. These include SHNUMBER (TD shipment number), TSNUM (Stage of transport number), TSTYP (Stage category), TSRFO (Stage of transport sequence).. 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 OIGSS 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
SHNUMBERTD shipment number OIG_SHNUMCHAR10OIGSALPHAOIG_SHNUMOIS
TSNUMStage of transport number TSNUMNUMC4Assigned to domainTSNUM
TSTYPStage category TSTYPCHAR1TSTYP
TSRFOStage of transport sequence TSRFONUMC4TSRFO
VEH_NRVehicle Sequence Number in Shipment OIG_VEHNRNUMC3Assigned to domainOIG_VEHNR
ELUPDChange Indicator ELUPDCHAR1ELUPD
CRE_NAMEName of Person who Created the Object ERNAMCHAR12USNAM
CRE_DATEDate on Which Record Was Created ERDATDATS8DATUM
CRE_TIMEEntry time ERZETTIMS6UZEIT
CHA_NAMEName of Person Who Changed Object AENAMCHAR12USNAM
CHA_DATEChanged On AEDATDATS8DATUM
CHA_TIMETime last change was made AEZETTIMS6UZEIT
ROUTERoute for shipment stage ROUTESCHAR6TVROROUTE
VSARTShipping type for shipment stage VERSARTSCHAR2T173VERSART
LAUFKLeg indicator for shipment stage LAUFSCHAR1LAUFK
ADRNADeparture point: Address ADRNACHAR10Assigned to domainALPHAADRNR
KNOTADeparture Point KNOTACHAR10TVKNKNOTN
VSTELShipping point at point of departure VSTELACHAR4TVSTVSTELVST
LSTELPoint of departure: Loading point at shipping point LSTELACHAR2TVLALSTEL
WERKAPlant at point of departure WERKSACHAR4T001WWERKS
LGORTADeparture point: Storage location in plant LGORTACHAR4T001LLGORT
KUNNADeparture point: Customer KUNNACHAR10KNA1ALPHAKUNNR
LIFNAVendor number of departure point LIFNACHAR10LFA1ALPHALIFNR
ADRNZDestination address ADRNZCHAR10Assigned to domainALPHAADRNR
KNOTZDestination point KNOTZCHAR10TVKNKNOTN
VSTEZShipping point at destination VSTELZCHAR4TVSTVSTELVST
LSTEZDestination: Loading point at shipping point LSTELZCHAR2TVLALSTEL
WERKZPlant at destination point WERKSZCHAR4T001WWERKS
LGORTZDestination: Storage location in plant LGORTZCHAR4T001LLGORT
KUNNZCustomer number for destination point KUNNZCHAR10KNA1ALPHAKUNNR
LIFNZVendor number of destination point LIFNZCHAR10LFA1ALPHALIFNR
TDLNRNumber of forwarding agent in the shipment stage TDLNRSCHAR10LFA1ALPHALIFNRF4_CARRIERS
DISTZDistance DISTZQUAN13(3) MENG13
MEDSTUnit of measure for distance MEDSTUNIT3Assigned to domainCUNITMEINS
OIG_GESZTDTotal time for stage OIG_GESZTDQUAN13(2) OIG_GESZT
OIG_FAHZTDTotal travel time for stage OIG_FAHZTDQUAN13(2) OIG_GESZT
MEIZTUnit of measure for travelling times MEIZTUNIT3Assigned to domainCUNITMEINS
ADRKNZAPoint of departure: Origin indicator of address ADRKNZACHAR1ADRKNZ
KUNABLAPoint of departure: Customer's unloading point KUNABLACHAR25KNVATEXT25
ADRKNZZDestination: Origin indicator of address ADRKNZZCHAR1ADRKNZ
KUNABLZDestination: Customer's unloading point KUNABLZCHAR25KNVATEXT25
FRKRLShipment costs relevance FRKRLCHAR1FRKRL
SKALSMPricing procedure in stage of shipment KALSM_TRABCHAR6T683KALSM
FBSTAStatus of shipment costs calculation FBSTACHAR1FBSTA
ARSTAStatus of shipment costs settlement ARSTACHAR1ARSTA
VEH_INDTD-F: Vehicle stage indicator with first and last node OIG_VEHINDCHAR1OIG_VEHIND
CARR_ROUTTD-F carrier is copied from route / stage table OIG_CRROUTCHAR1XFELD
GESZTDTD Planned total time for stage (in days) OIGGESZTDPDEC11TSTRGTSTRDURAG
FAHZTDTD - planned duration for stage (in hours:minutes) OIGEFFZTDPDEC11TSTRNTSTRDURAN
GESZTDATD - actual total time for shipment stage (in days) OIGGESZTDADEC11TSTRGTSTRDURAG
FAHZTDATD - actual duration for shipment stage (in hours:minutes) OIGEFFZTDADEC11TSTRNTSTRDURAN
CONT_DGIndicator: Section contains dangerous goods ADGE_SCDGCHAR1X

Key field Non-key field



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

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

SELECT SINGLE *
FROM OIGSS
INTO CORRESPONDING FIELDS OF WA_OIGSS
WHERE...

How to access SAP table OIGSS

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