SAP table OIGS (TD Shipment Header)

SAP table OIGS has 2 primary key fields being CLIENT,SHNUMBER.

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
SHNUMBER TD shipment number CHAR 10 0 OIG_SHNUM
SHTYPE TD shipment type CHAR 4 0 TOIGS OIG_TDSTYP
XBLNR Reference Document Number CHAR 16 0 XBLNR1
VEH_MODE TD vehicle mode of transport CHAR 1 0 OIG_VMOT
1 Road
2 Rail
3 Marine
4 Barge
5 Pipeline
VMRQT Vehicle meter required indicator CHAR 1 0 OIG_VMRQT
CPLID Compartment load indicator CHAR 1 0 OIG_CPLID
1 One delivery per compartment
2 One material per compartment (multiple delivery)
3 Multiple material per compartment
CHKCMP_P_C Check compatibility at scheduling for product/compartment NUMC 1 0 OIG_CMP_PC
CHKCMP_V_C Check compatibility at scheduling for vehicle/customer NUMC 1 0 OIG_CMP_VC
PART_DC TD partial delivery confirmation allowance CHAR 1 0 OIG_PRTDC
UOMID Unit of measure identification CHAR 1 0 OIG_UOMID
1 weight
2 volume
CFBLL Confirm balance load of deliveries CHAR 1 0 OIG_CFBLL
Automatic balance processing
1 No balancing required
X Manual balance process - shipment must balance
INPGP Intransit posting group CHAR 2 0 TOIGS2 OIG_INPGP
WGT_UOM TD weight unit of measure UNIT 3 0 T006 OIG_WGTUOM
VOL_UOM TD volume unit of measure UNIT 3 0 T006 OIG_VOLUOM
NR_DECV Number of decimal places for shipment quantities NUMC 2 0 OIG_NRDEC
NR_DECW Number of decimal places for shipment quantities NUMC 2 0 OIG_NRDEC
VOLA_UOM TD volume unit of measure (ambient) UNIT 3 0 T006 OIG_VOLA
VOLC_UOM TD volume unit of measure, corrected (temperature) UNIT 3 0 T006 OIG_VOLC
OVLD_WRNG TD check overloading at loading - (only warning) CHAR 1 0 OIG_CHKOWE
OIG_DLNMCK Sequence number check for TD document CHAR 1 0 OIG_DLNMCK
Not active
X Active
SCHUND TD-S Underdelivery tolerance message level CHAR 1 0 OIG_SCHUND
SCHOVR TD-S Overdelivery tolerance message level CHAR 1 0 OIG_SCHOVR
LOAUND TD-L under-delivery tolerance message level CHAR 1 0 OIG_LOAUND
LOAOVR TD-L Over-delivery tolerance message level CHAR 1 0 OIG_LOAOVR
DELUND TD-D Under-delivery tolerance message level CHAR 1 0 OIG_DELUND
DELOVR TD-D over-delivery tolerance message level CHAR 1 0 OIG_DELOVR
EV_SEQ_UNI TD Event sequence number (unique) CHAR 1 0 OIG_EVSEQU
EV_GROUP TD - event default group CHAR 4 0 TOIGEG OIG_EVGRP
SHFT_MNT TD - shift mandatory CHAR 1 0 OIG_SHFTMT
CHK_OVL TD check overloading CHAR 1 0 OIG_CHKOVL
VCLOSE Vehicle close flag; set confirmation to complete (status=6) CHAR 1 0 OIG_VCLOSE
VBALNC TD vehicle balance check against tolerance table (TOIGS5) CHAR 1 0 OIG_VBALNC
GLPST TD gain/loss postings at vehicle close CHAR 1 0 OIG_GLPST
EXCH_SCH Automatically access user exit for exchange assignment CHAR 1 0 OIG_EXCH
FFTYP Fulfillment indicator for exchange assignments CHAR 1 0 OIA_FFTYP
Not specified
E Exchange entitlement only
N No assignment possible
EXGASS Purchase assignment user exit NUMC 3 0 * OIA_EXGASS
BWART Movement Type (Inventory Management) CHAR 3 0 T156 BWARTWE
VSART Shipping Type CHAR 2 0 T173 VSARTTR
EXCH_LOAD Automatically access user exit for exchange assignment CHAR 1 0 OIG_EXCH
EXCH_CHECK Check exchange assignments at scheduling CHAR 1 0 OIG_EXCHCH
AUSTGASGN TD-F auto assignment of stages to document items CHAR 1 0 OIG_ASTGAS
FKART Shipment cost type CHAR 4 0 * FKART_T
FRKRL Proposal freight costs relevance, Shipment header CHAR 1 0 FRKRL_KOP
FRKRL_STR Proposal freight costs relevance, shipment leg CHAR 1 0 FRKRL_STR
FRKRL_UMP Proposal for shipment costs relevance - Load transfer point CHAR 1 0 FRKRL_UMP
FRKRL_GRP Proposal for freight costs relevance, Border cross.pt CHAR 1 0 FRKRL_GRP
FRKRL_VEH TD - shipment cost relevance for vehicles CHAR 1 0 OIG_FRKRLV
SCLDTYPE TD-F -Shipment costing based on loaded or disch. quantitites CHAR 1 0 OIG_STYPE
0 based on loaded quantities
1 based on disch. quantities
CPL_CUSFNT TD compartment planning - customer function CHAR 1 0 OIG_CPCUSF
NEW_COMP Adopt compartment allocation when the vehicle is changed CHAR 1 0 OIG_NCOMP
CHGDOCS IS-OIL TD Write Change Documents for TD shipments CHAR 1 0 OIG_CHGDOCS
PROLI Dangerous Goods Management Profile in SD Documents CHAR 3 0 ADGE_PROLI
DGTLOCK Block Indicator for Dangerous Goods CHAR 1 0 ADGE_TLOCK
DGMDDAT Selection date dangerous goods master data DATS 8 0 ADGE_MDDAT
CONT_DG Indicator: Document contains dangerous goods CHAR 1 0 ADGE_NCDG
C_SHTYP Shipment type CHAR 4 0 TVTK SHTYP
TPLST Transportation planning point CHAR 4 0 TTDS TPLST
ROUTE Route CHAR 6 0 TVRO ROUTE
CARRIER Number of forwarding agent CHAR 10 0 LFA1 TDLNR
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
OIG_SSTSF TD Shipment Status (Functional) CHAR 1 0 OIG_SSTSF
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
SCHED_STDT Planned date for start of shipment DATS 8 0 OIG_SHSTDT
SCHED_STTM Scheduling start time TIMS 6 0 OIG_SHSTTM
LOAD_STDT Planned date for start of loading DATS 8 0 OIG_LDSTDT
LOAD_STTM Planned time for start of loading TIMS 6 0 OIG_LDSTTM
LOAD_EDDT Planned date for end of loading DATS 8 0 OIG_LDEDDT
LOAD_EDTM Planned time for end of loading TIMS 6 0 OIG_LDEDTM
DEL_STDT Planned date for start of delivery confirmation DATS 8 0 OIG_DESTDT
DEL_STTM Planned time for start of delivery confirmation TIMS 6 0 OIG_DESTTM
DEL_EDDT Planned date for end of delivery confirmation DATS 8 0 OIG_DEEDDT
DEL_EDTM Planned time for end of delivery confirmation TIMS 6 0 OIG_DEEDTM
LOAD_STDTA Date for start of loading DATS 8 0 OIG_LDSTDA
LOAD_STTMA Actual time for start of loading TIMS 6 0 OIG_LDSTTA
LOAD_EDDTA Actual date for end of loading DATS 8 0 OIG_LDEDDA
LOAD_EDTMA Actual time for end of loading TIMS 6 0 OIG_LDEDTA
DEL_STDTA Actual date for start of delivery confirmation DATS 8 0 OIG_DESTDA
DEL_STTMA Actual time for start of delivery confirmation TIMS 6 0 OIG_DESTTA
DEL_EDDTA Actual date for end of delivery confirm DATS 8 0 OIG_DEEDDA
DEL_EDTMA Actual time for end of delivery confirmation TIMS 6 0 OIG_DEEDTA
FBSTA Status of shipment costs calculation CHAR 1 0 FBSTA
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
FBGST Overall status of calculation of shipment costs for shipment CHAR 1 0 FBGST
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
ARGST Total status of shipment costs settlement for shipment CHAR 1 0 ARGST
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
FRKRL_SHP Shipment costs relevance CHAR 1 0 FRKRL
Not relevant for freight costs
X Relevant for freight costs
SKALSM Pricing procedure in shipment header CHAR 6 0 T683 KALSM_KOPF
TSWUSEIND OIL TSW: TSW usage indicator CHAR 1 0 OIJ_TSWUSEIND
CHG_REASON OIL-TPI: Change reason code CHAR 2 0 TOIGS4 OIG_CHREAS
SHSTA_SCD TD Shipment Status (Functional) CHAR 1 0 OIG_SSTSF
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
SHSELECT Flag to Set Shipments Selectable CHAR 1 0 OIG_SHPSELECT

OIGS foreign key relationships

Table Field Check Table Check Field
0 OIGS BWART T156 Movement Type MANDT
0 OIGS BWART T156 Movement Type BWART
1 OIGS CARRIER LFA1 Supplier Master (General Section) MANDT
1 OIGS CARRIER LFA1 Supplier Master (General Section) LIFNR
0 OIGS CHG_REASON TOIGS4 TD Reason Codes CLIENT
1 OIGS CLIENT T000 Clients MANDT
0 OIGS C_SHTYP TVTK Shipment Types MANDT
1 OIGS EV_GROUP TOIGEG TD Event Default Groups EV_GROUP
0 OIGS INPGP TOIGS2 TD Intransit Posting Group INPGP
1 OIGS ROUTE TVRO Routes MANDT
1 OIGS ROUTE TVRO Routes ROUTE
0 OIGS SKALSM T683 Pricing procedures KAPPL
0 OIGS SKALSM T683 Pricing procedures KALSM
1 OIGS TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 OIGS VOLA_UOM T006 Units of Measurement MANDT
1 OIGS VOLC_UOM T006 Units of Measurement MANDT
0 OIGS VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
0 OIGS VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
1 OIGS WGT_UOM T006 Units of Measurement MANDT
1 OIGS WGT_UOM T006 Units of Measurement MSEHI