1. Home
  2. Resources
  3. SAP Tables
  4. OIGSS - TD Shipment Stages

SAP Table OIGSS

TD Shipment Stages

OIGSS (TD Shipment Stages) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIGSS to other SAP tables.

OIGSS table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
SHNUMBER TD shipment number OIG_SHNUM OIGS CHAR 10 0
TSNUM Stage of transport number TSNUM NUMC 4 0
TSTYP Stage category TSTYP CHAR 1 0
1 Transportation
2 Load transfer
3 Border
TSRFO Stage of transport sequence TSRFO NUMC 4 0
VEH_NR Vehicle Sequence Number in Shipment OIG_VEHNR NUMC 3 0
ELUPD Change Indicator ELUPD CHAR 1 0
1 Created automatically
2 Created automatically, changed manually
3 Created manually
CRE_NAME Name of Person who Created the Object ERNAM CHAR 12 0
CRE_DATE Date on Which Record Was Created ERDAT DATS 8 0
CRE_TIME Entry time ERZET TIMS 6 0
CHA_NAME Name of Person Who Changed Object AENAM CHAR 12 0
CHA_DATE Changed On AEDAT DATS 8 0
CHA_TIME Time last change was made AEZET TIMS 6 0
ROUTE Route for shipment stage ROUTES TVRO CHAR 6 0
VSART Shipping type for shipment stage VERSARTS T173 CHAR 2 0
LAUFK Leg indicator for shipment stage LAUFS CHAR 1 0
1 Preliminary leg
2 Main leg
3 Subsequent leg
4 Direct leg
5 Return leg
ADRNA Departure point: Address ADRNA CHAR 10 0
KNOTA Departure Point KNOTA TVKN CHAR 10 0
VSTEL Shipping point at point of departure VSTELA TVST CHAR 4 0
LSTEL Point of departure: Loading point at shipping point LSTELA TVLA CHAR 2 0
WERKA Plant at point of departure WERKSA T001W CHAR 4 0
LGORTA Departure point: Storage location in plant LGORTA T001L CHAR 4 0
KUNNA Departure point: Customer KUNNA KNA1 CHAR 10 0
LIFNA Vendor number of departure point LIFNA LFA1 CHAR 10 0
ADRNZ Destination address ADRNZ CHAR 10 0
KNOTZ Destination point KNOTZ TVKN CHAR 10 0
VSTEZ Shipping point at destination VSTELZ TVST CHAR 4 0
LSTEZ Destination: Loading point at shipping point LSTELZ TVLA CHAR 2 0
WERKZ Plant at destination point WERKSZ T001W CHAR 4 0
LGORTZ Destination: Storage location in plant LGORTZ T001L CHAR 4 0
KUNNZ Customer number for destination point KUNNZ KNA1 CHAR 10 0
LIFNZ Vendor number of destination point LIFNZ LFA1 CHAR 10 0
TDLNR Number of forwarding agent in the shipment stage TDLNRS LFA1 CHAR 10 0
DISTZ Distance DISTZ QUAN 13 3
MEDST Unit of measure for distance MEDST UNIT 3 0
OIG_GESZTD Total time for stage OIG_GESZTD QUAN 13 2
OIG_FAHZTD Total travel time for stage OIG_FAHZTD QUAN 13 2
MEIZT Unit of measure for travelling times MEIZT UNIT 3 0
ADRKNZA Point of departure: Origin indicator of address ADRKNZA CHAR 1 0
A Address from master data (SADR, ADRC, KNA1, LFA1)
B Address entered manually in current document (ADRC)
C Address entered manually in preceding document (SADR)
D Address entered manually in preceding document (ADRC)
KUNABLA Point of departure: Customer's unloading point KUNABLA KNVA CHAR 25 0
ADRKNZZ Destination: Origin indicator of address ADRKNZZ CHAR 1 0
A Address from master data (SADR, ADRC, KNA1, LFA1)
B Address entered manually in current document (ADRC)
C Address entered manually in preceding document (SADR)
D Address entered manually in preceding document (ADRC)
KUNABLZ Destination: Customer's unloading point KUNABLZ KNVA CHAR 25 0
FRKRL Shipment costs relevance FRKRL CHAR 1 0
X Relevant for freight costs
NULL Not relevant for freight costs
SKALSM Pricing procedure in stage of shipment KALSM_TRAB T683 CHAR 6 0
FBSTA Status of shipment costs calculation FBSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
ARSTA Status of shipment costs settlement ARSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
VEH_IND TD-F: Vehicle stage indicator with first and last node OIG_VEHIND CHAR 1 0
CARR_ROUT TD-F carrier is copied from route / stage table OIG_CRROUT CHAR 1 0
X Yes
NULL No
GESZTD TD Planned total time for stage (in days) OIGGESZTDP DEC 11 0
FAHZTD TD - planned duration for stage (in hours:minutes) OIGEFFZTDP DEC 11 0
GESZTDA TD - actual total time for shipment stage (in days) OIGGESZTDA DEC 11 0
FAHZTDA TD - actual duration for shipment stage (in hours:minutes) OIGEFFZTDA DEC 11 0
CONT_DG Indicator: Section contains dangerous goods ADGE_SCDG CHAR 1 0
X Yes
NULL No

OIGSS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIGSS CLIENT OIGSS CLIENT T000 Clients MANDT
OIGSS KNOTA OIGSS CLIENT TVKN Routes: Transportation Connection Points MANDT
OIGSS KNOTA OIGSS KNOTA TVKN Routes: Transportation Connection Points KNOTE
OIGSS KNOTZ OIGSS KNOTZ TVKN Routes: Transportation Connection Points KNOTE
OIGSS KNOTZ OIGSS CLIENT TVKN Routes: Transportation Connection Points MANDT
OIGSS KUNABLA OIGSS KUNABLA KNVA Customer Master Unloading Points ABLAD
OIGSS KUNABLA OIGSS CLIENT KNVA Customer Master Unloading Points MANDT
OIGSS KUNABLA OIGSS KUNNA KNVA Customer Master Unloading Points KUNNR
OIGSS KUNABLZ OIGSS CLIENT KNVA Customer Master Unloading Points MANDT
OIGSS KUNABLZ OIGSS KUNNA KNVA Customer Master Unloading Points KUNNR
OIGSS KUNABLZ OIGSS KUNABLZ KNVA Customer Master Unloading Points ABLAD
OIGSS KUNNA OIGSS CLIENT KNA1 General Data in Customer Master MANDT
OIGSS KUNNA OIGSS KUNNA KNA1 General Data in Customer Master KUNNR
OIGSS KUNNZ OIGSS CLIENT KNA1 General Data in Customer Master MANDT
OIGSS KUNNZ OIGSS KUNNZ KNA1 General Data in Customer Master KUNNR
OIGSS LGORTA OIGSS CLIENT T001L Storage Locations MANDT
OIGSS LGORTA OIGSS WERKA T001L Storage Locations WERKS
OIGSS LGORTA OIGSS LGORTA T001L Storage Locations LGORT
OIGSS LGORTZ OIGSS CLIENT T001L Storage Locations MANDT
OIGSS LGORTZ OIGSS WERKA T001L Storage Locations WERKS
OIGSS LGORTZ OIGSS LGORTZ T001L Storage Locations LGORT
OIGSS LIFNA OIGSS LIFNA LFA1 Vendor Master (General Section) LIFNR
OIGSS LIFNA OIGSS CLIENT LFA1 Vendor Master (General Section) MANDT
OIGSS LIFNZ OIGSS CLIENT LFA1 Vendor Master (General Section) MANDT
OIGSS LIFNZ OIGSS LIFNZ LFA1 Vendor Master (General Section) LIFNR
OIGSS LSTEL OIGSS CLIENT TVLA Org.unit: Loading points per shipping point MANDT
OIGSS LSTEL OIGSS VSTEL TVLA Org.unit: Loading points per shipping point VSTEL
OIGSS LSTEL OIGSS LSTEL TVLA Org.unit: Loading points per shipping point LSTEL
OIGSS LSTEZ OIGSS VSTEL TVLA Org.unit: Loading points per shipping point VSTEL
OIGSS LSTEZ OIGSS LSTEZ TVLA Org.unit: Loading points per shipping point LSTEL
OIGSS LSTEZ OIGSS CLIENT TVLA Org.unit: Loading points per shipping point MANDT
OIGSS ROUTE OIGSS CLIENT TVRO Routes MANDT
OIGSS ROUTE OIGSS ROUTE TVRO Routes ROUTE
OIGSS SHNUMBER OIGSS CLIENT OIGS TD Shipment Header CLIENT
OIGSS SHNUMBER OIGSS SHNUMBER OIGS TD Shipment Header SHNUMBER
OIGSS SKALSM 'A' T683 Pricing procedures KVEWE
OIGSS SKALSM 'F' T683 Pricing procedures KAPPL
OIGSS SKALSM OIGSS SKALSM T683 Pricing procedures KALSM
OIGSS SKALSM OIGSS CLIENT T683 Pricing procedures MANDT
OIGSS TDLNR OIGSS CLIENT LFA1 Vendor Master (General Section) MANDT
OIGSS TDLNR OIGSS TDLNR LFA1 Vendor Master (General Section) LIFNR
OIGSS VSART OIGSS CLIENT T173 Routes: Mode of Transport for Each Shipping Type MANDT
OIGSS VSART OIGSS VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
OIGSS VSTEL OIGSS VSTEL TVST Organizational Unit: Shipping Points VSTEL
OIGSS VSTEL OIGSS CLIENT TVST Organizational Unit: Shipping Points MANDT
OIGSS VSTEZ OIGSS CLIENT TVST Organizational Unit: Shipping Points MANDT
OIGSS VSTEZ OIGSS VSTEZ TVST Organizational Unit: Shipping Points VSTEL
OIGSS WERKA OIGSS CLIENT T001W Plants/Branches MANDT
OIGSS WERKA OIGSS WERKA T001W Plants/Branches WERKS
OIGSS WERKZ OIGSS CLIENT T001W Plants/Branches MANDT
OIGSS WERKZ OIGSS WERKZ T001W Plants/Branches WERKS