SAP table OIGSS (TD Shipment Stages)

SAP table OIGSS has 3 primary key fields being CLIENT,SHNUMBER,TSNUM.

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

OIGSS foreign key relationships

Table Field Check Table Check Field
0 OIGSS CLIENT T000 Clients MANDT
1 OIGSS KNOTA TVKN Routes: Transportation Connection Points MANDT
1 OIGSS KNOTA TVKN Routes: Transportation Connection Points KNOTE
0 OIGSS KNOTZ TVKN Routes: Transportation Connection Points MANDT
0 OIGSS KNOTZ TVKN Routes: Transportation Connection Points KNOTE
1 OIGSS KUNABLA KNVA Customer Master Unloading Points MANDT
1 OIGSS KUNABLA KNVA Customer Master Unloading Points KUNNR
0 OIGSS KUNABLZ KNVA Customer Master Unloading Points MANDT
0 OIGSS KUNABLZ KNVA Customer Master Unloading Points KUNNR
1 OIGSS KUNNA KNA1 General Data in Customer Master MANDT
1 OIGSS KUNNA KNA1 General Data in Customer Master KUNNR
0 OIGSS KUNNZ KNA1 General Data in Customer Master MANDT
0 OIGSS KUNNZ KNA1 General Data in Customer Master KUNNR
1 OIGSS LGORTA T001L Storage Locations MANDT
1 OIGSS LGORTA T001L Storage Locations WERKS
0 OIGSS LGORTZ T001L Storage Locations MANDT
0 OIGSS LGORTZ T001L Storage Locations WERKS
1 OIGSS LIFNA LFA1 Supplier Master (General Section) MANDT
1 OIGSS LIFNA LFA1 Supplier Master (General Section) LIFNR
0 OIGSS LIFNZ LFA1 Supplier Master (General Section) MANDT
0 OIGSS LIFNZ LFA1 Supplier Master (General Section) LIFNR
1 OIGSS ROUTE TVRO Routes MANDT
1 OIGSS ROUTE TVRO Routes ROUTE
0 OIGSS SHNUMBER OIGS TD Shipment Header CLIENT
0 OIGSS SHNUMBER OIGS TD Shipment Header SHNUMBER
1 OIGSS SKALSM T683 Pricing procedures KAPPL
1 OIGSS SKALSM T683 Pricing procedures KALSM
0 OIGSS TDLNR LFA1 Supplier Master (General Section) MANDT
0 OIGSS TDLNR LFA1 Supplier Master (General Section) LIFNR
1 OIGSS VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
1 OIGSS VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
0 OIGSS VSTEL TVST Organizational Unit: Shipping Points MANDT
0 OIGSS VSTEL TVST Organizational Unit: Shipping Points VSTEL
1 OIGSS VSTEZ TVST Organizational Unit: Shipping Points MANDT
1 OIGSS VSTEZ TVST Organizational Unit: Shipping Points VSTEL
0 OIGSS WERKA T001W Plants/Branches MANDT
0 OIGSS WERKA T001W Plants/Branches WERKS
1 OIGSS WERKZ T001W Plants/Branches MANDT
1 OIGSS WERKZ T001W Plants/Branches WERKS