SAP ABAP Table /SPE/RET_DELV_ALL (Returns: Delivery header and items)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-SPM-RET (Application Component) Complaints and Returns
     ⤷ /SPE/RET_ERROR_CORRECTION (Package) Service Parts Management returns process DDIC enh.

Basic Data

Table Category	INTTAB	Structure
Structure	/SPE/RET_DELV_ALL	Table Relationship Diagram
Short Description	Returns: Delivery header and items

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	HEADER	☐	LIKP		STRU	0	0
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
3	VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery
4	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
5	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district
8	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
10	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type
11	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
12	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
13	WADAT	☐	WADAK	DATUM	DATS	8	0	Planned goods movement date
14	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
15	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
16	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
17	KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
18	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
19	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)
20	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
21	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
22	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route
23	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document
24	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)
25	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
26	KNFAK	☐	KNFAK	WFCID	CHAR	2	0	Customer factory calendar
27	TPQUA	☐	TPQUA	TPQUA	CHAR	1	0	not currently in use
28	TPGRP	☐	TPGRP	TPGRP	CHAR	2	0	not currently in use
29	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority
30	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions
31	KUNNR	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party
32	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party
33	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group
34	STZKL	☐	STZKL	STZKL	DEC	3	2	Not Currently in Use
35	STZZU	☐	STZZU	STZZU	DEC	3	0	not currently in use
36	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
37	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
38	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
39	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
40	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit
41	ANZPK	☐	ANZPK	ANZPK	NUMC	5	0	Total number of packages in delivery
42	BEROT	☐	BEROT	BEROT	CHAR	20	0	Picked items location
43	LFUHR	☐	LFUHR	LFUHR	TIMS	6	0	Time of delivery
44	GRULG	☐	GRULG	GRULG	CHAR	4	0	Weight group for delivery (To group)
45	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point
46	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group
47	FKARV	☐	FKARV	FKART	CHAR	4	0	Proposed billing type for a delivery-related billing doc.
48	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
49	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)
50	ROUTA	☐	ROUTE	ROUTE	CHAR	6	0	Route
51	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
52	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
53	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
54	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency
55	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
56	VBEAK	☐	VBEAK	DEC4_2	DEC	6	2	Shipping processing time for the entire document
57	ZUKRL	☐	DZUKRL	CHAR40	CHAR	40	0	Combination criteria for delivery
58	VERUR	☐	VERUR_VL	CHAR35	CHAR	35	0	Distribution delivery
59	COMMN	☐	COMMN	COMMN	CHAR	5	0	Communication number for Q-API interface
60	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency
61	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
62	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents
63	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
64	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
65	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex
66	LISPL	☐	LNSPL_LIKP	LNSPL_LIKP	CHAR	1	0	Delivery within one warehouse
67	VKOIV	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing
68	VTWIV	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing
69	SPAIV	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing
70	FKAIV	☐	FKAIV	FKART	CHAR	4	0	Billing type for intercompany billing
71	PIOIV	☐	PIOIV	WFCID	CHAR	2	0	Date for intercompany billing
72	FKDIV	☐	FKDIV	DATUM	DATS	8	0	Billing date for intercompany billing
73	KUNIV	☐	KUNIV	KUNNR	CHAR	10	0	Customer number for intercompany billing
74	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area
75	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference
76	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group
77	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management
78	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category
79	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area
80	AMTBL	☐	AMTBL_CM	WERTV8	CURR	15	2	Released credit value of the document
81	BOLNR	☐	BOLNR	CHAR35	CHAR	35	0	Bill of lading
82	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number
83	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type
84	TRAID	☐	TRAID	TRAID	CHAR	20	0	Means-of-transport ID
85	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
86	CMNGV	☐	CMNGV	DATUM	DATS	8	0	Next date
87	XABLN	☐	XABLN	BELNR	CHAR	10	0	Goods receipt/issue slip number
88	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
89	WADAT_IST	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
90	TRSPG	☐	TRSPG	TRSPG	CHAR	2	0	Shipment Blocking Reason
91	TPSID	☐	TPSID	COMMN	CHAR	5	0	ID for external transport system
92	LIFEX	☐	LIFEX	TEXT35	CHAR	35	0	External Identification of Delivery Note
93	TERNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
94	KALSM_CH	☐	KALSMA_CH	KALSM	CHAR	6	0	Search procedure for batch determination
95	KLIEF	☐	KLIEF	XFELD	CHAR	1	0	Correction delivery
96	KALSP	☐	KALSP	KALSM	CHAR	6	0	Shipping: Pricing procedure
97	KNUMP	☐	KNUMP	KNUMV	CHAR	10	0	Number of document condition - pricing
98	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
99	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule
100	WERKS	☐	EMPFW	WERKS	CHAR	4	0	Receiving plant for deliveries
101	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number
102	ABSSC	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure
103	KOUHR	☐	KOUHR	TIME_PLANT	TIMS	6	0	Picking time (local time, with reference to a plant)
104	TDUHR	☐	TDUHR	TIME_SHIPP	TIMS	6	0	Transp. Planning Time (Local, Relating to a Shipping Point)
105	LDUHR	☐	LDUHR	TIME_SHIPP	TIMS	6	0	Loading Time (Local Time Relating to a Shipping Point)
106	WAUHR	☐	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
107	LGTOR	☐	LGTOR	LGTOR	CHAR	3	0	Door for Warehouse Number
108	LGBZO	☐	LGBZO	LGBZO	CHAR	10	0	Staging Area for Warehouse Complex
109	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade
110	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
111	AKPRZ	☐	AKPRZ	PRZ32	DEC	5	2	Depreciation percentage for financial document processing
112	PROLI	☐	ADGE_PROLI	ADGD_PROLI	CHAR	3	0	Dangerous Goods Management Profile in SD Documents
113	XBLNR	☐	XBLNR_LIKP	XBLNR_LIKP	CHAR	25	0	Reference Document Number
114	HANDLE	☐	TSEGGUID_LIKP	SYSUUID_22	CHAR	22	0	Worldwide unique key for LIKP-VBELN
115	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
116	TSEGTP	☐	TSEGTPLLIK	TSEGTEMPLA	CHAR	10	0	Event group time segment delivery header
117	TZONIS	☐	TSEGZONISS	TZNZONE	CHAR	6	0	Time zone of delivering location
118	TZONRC	☐	TSEGZONREC	TZNZONE	CHAR	6	0	Time zone of recipient location
119	CONT_DG	☐	ADGE_NCDG	X	CHAR	1	0	Indicator: Document contains dangerous goods
120	VERURSYS	☐	VERURSYS	LOGSYS	CHAR	10	0	Distribution delivery: Original system
121	KZWAB	☐	KZWAB	KZWAB	CHAR	1	0	Indicator for controlling goods movement
122	VLSTK	☐	VLSTK	VLSTK	CHAR	1	0	Distribution Status (Decentralized Warehouse Processing)
123	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code
124	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type
125	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation
126	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator
127	VBUND	☐	VBUND	RCOMP	CHAR	6	0	Company ID
128	XWOFF	☐	XWOFF	XFELD	CHAR	1	0	Calculation of val. open
129	DIRTA	☐	LVS_DIRTA	XFELD	CHAR	1	0	Automatic TO Creation Immediately After TR Generation
130	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area
131	FOLAR	☐	LFART	LFART	CHAR	4	0	Delivery Type
132	PODAT	☐	PODAT	DATUM	DATS	8	0	Date (proof of delivery)
133	POTIM	☐	POTIM	TIME_PLANT	TIMS	6	0	Confirmation time
134	VGANZ	☐	SHP_VGANZ		INT4	10	0	Number of Delivery Items with Precedessor in Other System
135	IMWRK	☐	IMWRK	XFELD	CHAR	1	0	Delivery has Status 'In Plant'
136	SPE_LOEKZ	☐	LOEKZ_BK	XFELD	CHAR	1	0	Document deletion indicator
137	SPE_LOC_SEQ	☐	/SPE/RET_LOC_SEQ_D	CHAR3	CHAR	3	0	Sequence of Intermediate Locations in Returns Process
138	SPE_ACC_APP_STS	☐	/SPE/RET_ACC_APP_STS	/SPE/RET_ACC_APP_STS	CHAR	1	0	Delivery Confirmation Status
139	SPE_SHP_INF_STS	☐	/SPE/RET_SHP_INF_STS	/SPE/RET_SHP_INF_STS	CHAR	1	0	Shipment Information Status
140	SPE_RET_CANC	☐	/SPE/RET_CANC	XFELD	CHAR	1	0	Returns: Flag showing that an ASN is cancelled
141	SPE_WAUHR_IST	☐	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
142	SPE_WAZONE_IST	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone
143	SPE_REV_VLSTK	☐	VLSTK	VLSTK	CHAR	1	0	Distribution Status (Decentralized Warehouse Processing)
144	SPE_LE_SCENARIO	☐	/SPE/LE_SCENARIO	/SPE/LE_SCENARIO	CHAR	1	0	Scenario Logistic Execution
145	SPE_ORIG_SYS	☐	/SPE/INB_ORIGIN_SYS	/SPE/SYSTYPE_SHORT	CHAR	1	0	Original System Type
146	SPE_CHNG_SYS	☐	/SPE/INB_CHNG_SYS	/SPE/SYSTYPE_SHORT	CHAR	1	0	Last Changer's System Type
147	SPE_GEOROUTE	☐	/SPE/DE_ROUTE_ID	CHAR10	CHAR	10	0	Description of a Geographical Route
148	SPE_GEOROUTEIND	☐	/SPE/DE_ROUTE_IND	/SPE/DE_ROUTE_IND	CHAR	1	0	Change Indicator for the Route
149	SPE_CARRIER_IND	☐	/SPE/DE_CARRIER_IND	CHAR1	CHAR	1	0	Change Indicator for the Carrier
150	SPE_GTS_REL	☐	/SPE/DE_LEG_GTS_CODE	CHAR2	CHAR	2	0	Goods Traffic Type
151	SPE_GTS_RT_CDE	☐	/SPE/DE_ROUTE_GTS_CODE	CHAR10	CHAR	10	0	Route Code for SAP Global Trade Services
152	SPE_REL_TMSTMP	☐	/SPE/DE_RELEASE_TMSTMP	TZNTSTMPS	DEC	15	0	Release Time Stamp
153	SPE_UNIT_SYSTEM	☐	/SPE/DE_UNIT_SYSTEM	CHAR10	CHAR	10	0	Measurement Unit System
154	SPE_INV_BFR_GI	☐	/SPE/INV_BFR_GI	/SPE/INV_BFR_GI	CHAR	1	0	Invoice Creation Before Goods Issue
155	SPE_QI_STATUS	☐	/SPE/RET_QI_STATUS	/SPE/RET_QI_STATUS	CHAR	1	0	Status of Quality Inspection for Returns Deliveries
156	SPE_RED_IND	☐	/SPE/RED_IND	/SPE/RED_IND	CHAR	1	0	SPE indicator if redirecting has occured
157	SAKES	☐	GTS_SAKES	GTS_SAKES	CHAR	1	0	SAP Global Trade Services: Storage Status of Delivery
158	SPE_LIFEX_TYPE	☐	/SPE/DE_LIFEX_TYPE	/SPE/DO_LIFEX_TYPE	CHAR	1	0	Type of External Identification
159	SPE_TTYPE	☐	/SPE/TTYPE	/SPE/TTYPE	CHAR	10	0	Means of Transport
160	SPE_PRO_NUMBER	☐	/SPE/PRO_NUMBER	/SPE/PRO_NUMBER	CHAR	35	0	Partner Identification : Progressive Identification Number
161	LOC_GUID	☐	LOC_GUID16	SYSUUID	RAW	16	0	Akkreditiv (GUID)
162	SPE_BILLING_IND	☐	/SPE/DE_BILLING_IND	/SPE/DE_BILLING_IND	CHAR	1	0	EWM Billing Indicator
163	PRINTER_PROFILE	☐	DRUCK_PROFIL_ID	DPROFIL_ID	CHAR	10	0	Description of print profile
164	MSR_ACTIVE	☐	MSR_ACTIVE	MSR_ACTIVE	CHAR	1	0	Advanced Returns Management Active
165	PRTNR	☐	PRTNR	PRTNR	NUMC	10	0	Confirmation number
166	STGE_LOC_CHANGE	☐	SHP_STGE_LOC_CHANGE	SHP_STGE_LOC_CHANGE	CHAR	1	0	Temporary Change of Storage Locations in Delivery
167	TM_CTRL_KEY	☐	TM_CTRL_KEY		CHAR	4	0	Control Key for Document Transfer to TM
168	DLV_SPLIT_INITIA	☐	DLV_SPLIT_INITIATOR	DLV_SPLIT_INITIATOR	CHAR	1	0	Delivery Split Initiator
169	DLV_VERSION	☐	DLV_VERSION	DLV_VERSION	NUMC	4	0	Delivery Version
170	.INCLUDE	☐				0	0	Structure: Handover of Goods at Agreed Location
171	HANDOVERLOC	☐	HANDOVER_LOC	HANDOVER_LOC	CHAR	10	0	Location for a physical handover of goods
172	HANDOVERDATE	☐	HANDOVER_DATE	HANDOVER_DATE	DATS	8	0	Handover Date at the Handover Location
173	HANDOVERTIME	☐	HANDOVER_TIME	HANDOVER_TIME	TIMS	6	0	Handover time at the handover location
174	HANDOVERTZONE	☐	HANDOVER_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Handover Location
175	.INCLU--AP	☐				0	0	Append Structure for LIKP Delivery Note Header Loading Units
176	.INCLUDE	☐				0	0	Include Basic Structure (1Feld) for Appends
177	/BEV1/LULEINH	☐	/BEV1/LULEINH	/BEV1/LULEINH	NUMC	8	0	Loading Units
178	.INCLU--AP	☐				0	0	Delivery Header Enhancement (for Transportation Planning)
179	.INCLUDE	☐				0	0	Totals Fields Statistics Shipment Header from Deliveries
180	/BEV1/RPFAESS	☐	/BEV1/RPFAESSER	DEC7	DEC	7	0	Number Category 1
181	/BEV1/RPKIST	☐	/BEV1/RPKISTEN	DEC7	DEC	7	0	Number Category 2
182	/BEV1/RPCONT	☐	/BEV1/RPONTAIN	DEC7	DEC	7	0	Number Category 3
183	/BEV1/RPSONST	☐	/BEV1/RPSONST	DEC7	DEC	7	0	Number Category 4
184	.INCLUDE	☐				0	0	Dynamic Dispatch: Sequence Number
185	/BEV1/RPFLGNR	☐	/DSD/RP_SEQUENCENR	/DSD/RP_SEQUENCENR	NUMC	5	0	Loading Sequence Number in the Tour
186	.INCLU--AP	☐				0	0	DIMP GR Append for Delivery Header Table
187	BORGR_GRP	☐	BORGR_GRP	CHAR35	CHAR	35	0	Inbound Dely Group: Multi-Level Goods Receipt Automotive
188	ITEMS	☐	/SPE/RET_LIPS_T		TTYP	0	0

History

Last changed by/on	SAP	20140121
SAP Release Created in	100