SAP Table OIGSI

Shipment Item

OIGSI (Shipment Item) 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 OIGSI to other SAP tables.

OIGSI 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
SHITEM Shipment item OIG_SHITM NUMC 4 0
DOC_TYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
DOC_NUMBER TD document number OIG_DOCNR CHAR 10 0
VGTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
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
OIG_SSTSFP TD Shipment Status (Functional) OIG_SSTSF CHAR 1 0
1 Partially Scheduled
2 Scheduled
3 Partially Loaded (Plants Missing)
4 Completely Loaded
5 Partially Confirmed (Deliveries Missing)
6 Completely Confirmed
DOC_SEQ TD document sequence field OIG_DELSEQ CHAR 4 0
LOAD_INDI TD shipment item load indicator OIG_LDIND CHAR 1 0
DISCH_INDI TD shipment item discharge indicator OIG_DCIND CHAR 1 0
LONGTEXT TD Longtext indicator OIG_LTXT CHAR 1 0
TCODE Transaction Code TCODE CHAR 20 0
OIG_GLPOD Goods issue at loading, proof of delivery (POD) OIG_GLPOD CHAR 1 0
NULL GI at delivery confirmation for sales deliveries
1 GI at loading, proof of delivery at delivery confirmation
2 GI at loading, quantities at del.conf. statistic and freight
3 GI at loading, no delivery confirmation
CONT_DG Indicator: Section contains dangerous goods ADGE_SCDG CHAR 1 0
X Yes
NULL No

OIGSI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIGSI CLIENT OIGSI CLIENT T000 Clients MANDT
OIGSI SHNUMBER OIGSI CLIENT OIGS TD Shipment Header CLIENT
OIGSI SHNUMBER OIGSI SHNUMBER OIGS TD Shipment Header SHNUMBER