SAP table SHP_IDX_GDSI (Outbound Deliveries: Not Posted for Goods Issue)

SAP table SHP_IDX_GDSI has 2 primary key fields being MANDT,VBELN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VBELN Delivery CHAR 10 0 LIKP VBELN_VL
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
ROUTE Route CHAR 6 0 TVRO ROUTE
KODAT Picking Date DATS 8 0 KODAT
TDDAT Transportation Planning Date DATS 8 0 TDDAT_D
LDDAT Loading Date DATS 8 0 LDDAT
WADAT Goods Issue Date DATS 8 0 WADAT
LFDAT Delivery Date DATS 8 0 LFDAT_V
LIFSK Delivery Block (Document Header) CHAR 2 0 TVLS LIFSK
LSTEL Loading Point CHAR 2 0 TVLA LSTEL
KUNNR Ship-to Party CHAR 10 0 KNA1 KUNWE
ANZPK Total Number of Packages in Delivery NUMC 5 0 ANZPK
KOSTK Picking Status/Putaway Status (All Items) CHAR 1 0 KOSTK
LVSTK Status of Warehouse Management Activities (All Items) CHAR 1 0 LVSTK
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)

SHP_IDX_GDSI foreign key relationships

Table Field Check Table Check Field
0 SHP_IDX_GDSI KUNNR KNA1 General Data in Customer Master MANDT
0 SHP_IDX_GDSI KUNNR KNA1 General Data in Customer Master KUNNR
1 SHP_IDX_GDSI LIFSK TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 SHP_IDX_GDSI LIFSK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 SHP_IDX_GDSI ROUTE TVRO Routes MANDT
0 SHP_IDX_GDSI ROUTE TVRO Routes ROUTE
1 SHP_IDX_GDSI VBELN LIKP SD Document: Delivery Header Data MANDT
1 SHP_IDX_GDSI VBELN LIKP SD Document: Delivery Header Data VBELN
0 SHP_IDX_GDSI VSTEL TVST Organizational Unit: Shipping Points MANDT
0 SHP_IDX_GDSI VSTEL TVST Organizational Unit: Shipping Points VSTEL