SAP table SHP_IDX_GDRC (Inbound Deliveries: Not Posted for Goods Receipt)
SAP table SHP_IDX_GDRC 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 | |
| LFDAT | Delivery Date | DATS | 8 | 0 | LFDAT_LA | ||
| VSTEL | Shipping Point / Receiving Point | CHAR | 4 | 0 | TVST | VSTEL | |
| TRAID | Means of Transport ID | CHAR | 20 | 0 | TRAID | ||
| LIFNR | Account Number of Supplier | CHAR | 10 | 0 | LFA1 | LIFNR | |
| LIFEX | External Delivery Note ID (Capital Letters) | CHAR | 35 | 0 | LIFEX_CAP | ||
| KOSTK | Picking Status/Putaway Status (All Items) | CHAR | 1 | 0 | KOSTK | ||
| LVSTK | Status of Warehouse Management Activities (All Items) | CHAR | 1 | 0 | LVSTK |
SHP_IDX_GDRC foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 SHP_IDX_GDRC | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 SHP_IDX_GDRC | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 SHP_IDX_GDRC | VBELN | LIKP | SD Document: Delivery Header Data | MANDT |
| 1 SHP_IDX_GDRC | VBELN | LIKP | SD Document: Delivery Header Data | VBELN |
| 0 SHP_IDX_GDRC | VSTEL | TVST | Organizational Unit: Shipping Points | MANDT |
| 0 SHP_IDX_GDRC | VSTEL | TVST | Organizational Unit: Shipping Points | VSTEL |