SAP ABAP Table /ISDFPS/SHPVSTOSTRUC (Structure for Relocation Documents)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-MM (Application Component) Materials Management
     ⤷ /ISDFPS/MM (Package) SDP BW Enhancements in Materials Management

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/SHPVSTOSTRUC	Table Relationship Diagram
Short Description	Structure for Relocation Documents

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
2	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
3	VBELN_INB	☐	VBELN_VLAV	VBELN	CHAR	10	0	Inbound delivery	*
4	POSNR_INB	☐	/ISDFPS/POSNR_INB	POSNR	NUMC	6	0	Item Number of the Inbound Delivery	*
5	.INCLUDE	☐				0	0	Generated Table for View
6	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
7	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
12	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
13	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
14	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
15	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
16	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
17	WADAT	☐	WADAK	DATUM	DATS	8	0	Planned goods movement date
18	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
19	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
20	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
21	KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
22	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
23	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
24	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
25	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
26	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
27	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
28	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
29	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
30	KNFAK	☐	KNFAK	WFCID	CHAR	2	0	Customer factory calendar	TFACD
31	TPQUA	☐	TPQUA	TPQUA	CHAR	1	0	not currently in use
32	TPGRP	☐	TPGRP	TPGRP	CHAR	2	0	not currently in use
33	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
34	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
35	KUNNR	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
36	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
37	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
38	STZKL	☐	STZKL	STZKL	DEC	3	2	Not Currently in Use
39	STZZU	☐	STZZU	STZZU	DEC	3	0	not currently in use
40	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
41	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
42	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
43	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
44	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
45	ANZPK	☐	ANZPK	ANZPK	NUMC	5	0	Total number of packages in delivery
46	BEROT	☐	BEROT	BEROT	CHAR	20	0	Picked items location
47	LFUHR	☐	LFUHR	LFUHR	TIMS	6	0	Time of delivery
48	GRULG	☐	GRULG	GRULG	CHAR	4	0	Weight group for delivery (To group)	TVLG
49	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
50	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
51	FKARV	☐	FKARV	FKART	CHAR	4	0	Proposed billing type for a delivery-related billing doc.	TVFK
52	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
53	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
54	ROUTA	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
55	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
56	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
57	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
58	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
59	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
60	VBEAK	☐	VBEAK	DEC4_2	DEC	6	2	Shipping processing time for the entire document
61	ZUKRL	☐	DZUKRL	CHAR40	CHAR	40	0	Combination criteria for delivery
62	VERUR	☐	VERUR_VL	CHAR35	CHAR	35	0	Distribution delivery
63	COMMN	☐	COMMN	COMMN	CHAR	5	0	Communication number for Q-API interface	TQCOM
64	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
65	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
66	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
67	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
68	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
69	WADAT_IST	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
70	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	VALW
71	LGTOR	☐	LGTOR	LGTOR	CHAR	3	0	Door for Warehouse Number	T30B
72	RFSTK	☐	RFSTK	STATV	CHAR	1	0	Reference document header status
73	RFGSK	☐	RFGSK	STATV	CHAR	1	0	Total reference status of all items
74	BESTK	☐	BESTK	STATV	CHAR	1	0	Confirmation status
75	LFSTK	☐	LFSTK	STATV	CHAR	1	0	Delivery status
76	LFGSK	☐	LKGSK	STATV	CHAR	1	0	Overall delivery status for all items
77	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
78	FKSTK	☐	FKSTK	STATV	CHAR	1	0	Billing status
79	FKSAK	☐	FKSAK	STATV	CHAR	1	0	Billing status (order-related billing document)
80	BUCHK	☐	BUCHK	STATV	CHAR	1	0	Posting Status of Billing Document
81	ABSTK	☐	ABSTK	STATV	CHAR	1	0	Overall rejection status of all sales document items
82	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
83	KOSTK	☐	KOSTK	STATV	CHAR	1	0	Overall picking / putaway status
84	KOQUK	☐	KOQUK	STATV	CHAR	1	0	Status of pick confirmation
85	LVSTK	☐	LVSTK	STATV	CHAR	1	0	Overall status of warehouse management activities
86	UVALS	☐	UVALL_SU	STATV	CHAR	1	0	Total incompletion status of all items in general
87	UVVLS	☐	UVVLS_SU	STATV	CHAR	1	0	Total incompletion status of all items: Delivery
88	UVFAS	☐	UVFAK_SU	STATV	CHAR	1	0	Total incompletion status of all items: Billing
89	UVALL	☐	UVALL_UK	STATV	CHAR	1	0	General incompletion status of the header
90	UVVLK	☐	UVVLK_UK	STATV	CHAR	1	0	Header incompletion status concerning delivery
91	UVFAK	☐	UVFAK_UK	STATV	CHAR	1	0	Header incompletion status with respect to billing
92	UVPRS	☐	UVPRS_UK	STATV	CHAR	1	0	Document is incomplete with respect to pricing
93	VBTYP_VBUK	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
94	VBOBJ	☐	VBOBJ	VBOBJ	CHAR	1	0	SD document object
95	PKSTK	☐	PKSTK	STATV_PKST	CHAR	1	0	Overall packing status of all items
96	TRSTA	☐	TRSTA	TRSTA	CHAR	1	0	Transportation planning status
97	CMGST	☐	CMGST	CMGST	CHAR	1	0	Overall status of credit checks
98	PDSTK	☐	PDSTK	STATV	CHAR	1	0	POD status on header level
99	PODAT	☐	PODAT	DATUM	DATS	8	0	Date (proof of delivery)
100	POTIM	☐	POTIM	TIME_PLANT	TIMS	6	0	Confirmation time
101	MSR_ACTIVE	☐	MSR_ACTIVE	MSR_ACTIVE	CHAR	1	0	Advanced Returns Management Active
102	POSNR_OUTB	☐	/ISDFPS/POSNR_OUTB	POSNR	NUMC	6	0	Item Number of the Outbound Delivery	*
103	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
104	VTLSTATUS	☐	/ISDFPS/SHPVTLSTATUS	/ISDFPS/SHPVTLSTATUS	NUMC	1	0	Distribution Status of Delivery for Autarkic Systems
105	VTLSTATUS_ICON	☐	/ISDFPS/VTLSTATUS_ICON	CHAR30	CHAR	30	0	Icon for Distribution Status
106	LOGSYSAUTK	☐	/ISDFPS/LOGSYSAUTK	LOGSYS	CHAR	10	0	Logical System ID of Offline System	*
107	AUTBESTNR	☐	/ISDFPS/AUTBESTNR	EBELN	CHAR	10	0	Number of Autarkic Purchase Order	*
108	RECV_FORCE_OBJID	☐	/ISDFPS/RECV_FORCE_OBJID	HROBJID	NUMC	8	0	Object ID of Receiving Force Element	*
109	.INCLUDE	☐				0	0	Relocation: Fields Relevant for Logistics
110	RECV_FORCE_ID	☐	/ISDFPS/FORCE_ID	SYSUUID_C	CHAR	32	0	Internal Key for Force Element
111	RECV_FORCE_CNT	☐	/ISDFPS/FORCE_CNT	NUMC6	NUMC	6	0	Internal (Version) Counter
112	RELOC_ID	☐	/ISDFPS/RELOC_ID	/ISDFPS/RELOC_ID	CHAR	10	0	Relocation ID	*
113	RELOC_SEQ_ID	☐	/ISDFPS/RELOC_SEQ_ID	/ISDFPS/RELOC_SEQ_ID	CHAR	4	0	Relocation Step ID	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/SHPVSTOSTRUC	AULWE	VALW	AULWE	REF	1	CN
2	/ISDFPS/SHPVSTOSTRUC	BZIRK	T171	BZIRK	REF	C	CN
3	/ISDFPS/SHPVSTOSTRUC	COMMN	TQCOM	COMMN	REF	C	CN
4	/ISDFPS/SHPVSTOSTRUC	EXNUM	EIKP	EXNUM	REF	C	CN
5	/ISDFPS/SHPVSTOSTRUC	FAKSK	TVFS	FAKSP	REF	C	CN
6	/ISDFPS/SHPVSTOSTRUC	FKARV	TVFK	FKART	REF	C	CN
7	/ISDFPS/SHPVSTOSTRUC	GEWEI	T006	MSEHI	REF	C	CN
8	/ISDFPS/SHPVSTOSTRUC	GRULG	TVLG	GRULG	REF	C	CN
9	/ISDFPS/SHPVSTOSTRUC	INCO1	TINC	INCO1	REF	C	CN
10	/ISDFPS/SHPVSTOSTRUC	KALSM	T683	KALSM	REF	C	CN
11	/ISDFPS/SHPVSTOSTRUC	KDGRP	T151	KDGRP	REF	C	CN
12	/ISDFPS/SHPVSTOSTRUC	KNFAK	TFACD	IDENT	REF	C	CN
13	/ISDFPS/SHPVSTOSTRUC	KUNAG	KNA1	KUNNR	REF	C	CN
14	/ISDFPS/SHPVSTOSTRUC	KUNNR	KNA1	KUNNR	REF	1	CN
15	/ISDFPS/SHPVSTOSTRUC	LFART	TVLK	LFART	REF	C	CN
16	/ISDFPS/SHPVSTOSTRUC	LGNUM	T300	LGNUM	REF	C	CN
17	/ISDFPS/SHPVSTOSTRUC	LGTOR	T30B	LGTOR	REF	1	CN
18	/ISDFPS/SHPVSTOSTRUC	LIFSK	TVLS	LIFSP	REF	C	CN
19	/ISDFPS/SHPVSTOSTRUC	LPRIO	TPRIO	LPRIO	REF	C	CN
20	/ISDFPS/SHPVSTOSTRUC	LSTEL	TVLA	LSTEL	REF	C	CN
21	/ISDFPS/SHPVSTOSTRUC	MANDT	T000	MANDT	KEY	1	CN
22	/ISDFPS/SHPVSTOSTRUC	PERFK	TFACD	IDENT	REF	C	CN
23	/ISDFPS/SHPVSTOSTRUC	ROUTA	TVRO	ROUTE	REF	C	CN
24	/ISDFPS/SHPVSTOSTRUC	ROUTE	TVRO	ROUTE	REF	C	CN
25	/ISDFPS/SHPVSTOSTRUC	STWAE	TCURC	WAERS	REF	C	CN
26	/ISDFPS/SHPVSTOSTRUC	TRAGR	TTGR	TRAGR	REF	C	CN
27	/ISDFPS/SHPVSTOSTRUC	VBELN	VBUK	VBELN	KEY	1	C
28	/ISDFPS/SHPVSTOSTRUC	VKBUR	TVBUR	VKBUR	REF	C	CN
29	/ISDFPS/SHPVSTOSTRUC	VKORG	TVKO	VKORG	REF	C	CN
30	/ISDFPS/SHPVSTOSTRUC	VOLEH	T006	MSEHI	REF	C	CN
31	/ISDFPS/SHPVSTOSTRUC	VSBED	TVSB	VSBED	REF	C	CN
32	/ISDFPS/SHPVSTOSTRUC	VSTEL	TVST	VSTEL	REF	1	CN
33	/ISDFPS/SHPVSTOSTRUC	WAERK	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	470