SAP ABAP Table RJKSDRETURNWORKLIST (Worklist for Program SAPMJKSD07)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSDI (Package) IS-M/SD SD Integration

Basic Data

Table Category	INTTAB	Structure
Structure	RJKSDRETURNWORKLIST	Table Relationship Diagram
Short Description	Worklist for Program SAPMJKSD07

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	VBELN	☐	JVBELNRETURN	VBELN	CHAR	10	0	Internal Number	*
2	POSNR	☐	JRETURNPOSNR	POSNR	NUMC	6	0	IS-M: Request Item Number	*
3	UNSOLD_TYPE	☐	ISM_UNSOLD_TYPE	UNSOLD_TYPE	CHAR	2	0	Operation	*
4	UNSOLD_TYPET	☐	ISM_UNSOLD_TYPET	TEXT40	CHAR	40	0	Return Type
5	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
7	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
8	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
9	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
10	UNSOLDGPNR	☐	JUNSOLDGPNR	KUNNR	CHAR	10	0	Returning Retailer	*
11	UNSOLDNUMBER	☐	UNSOLDNUMBER	UNSOLDNUMBER	CHAR	10	0	External Request Number
12	UNSOLDDATE	☐	JUNSOLDDATE	DATUM	DATS	8	0	Notification Date
13	ORIGIN	☐	JORIGIN	JORIGIN	CHAR	1	0	Data Origin
14	ORIGINT	☐	JORIGINT	TEXT40	CHAR	40	0	Origin of Data
15	MEDIA_FAMILY	☐	ISMMATNR_FAMILY	MATNR	CHAR	18	0	Media Product Family	*
16	MEDIA_PRODUCT	☐	ISMMATNR_PRODUCT	MATNR	CHAR	18	0	Media Product	*
17	MEDIA_ISSUE	☐	ISMMATNR_ISSUE	MATNR	CHAR	18	0	Media Issue	*
18	COPY_NUMBER	☐	ISMHEFTNUMMER	HEFTNUMMER	CHAR	9	0	Copy Number of Media Issue
19	PUBL_DATE	☐	ISMPUBLDATE	DATUM	DATS	8	0	Publication Date
20	QUANTITY	☐	JRETURNQUANTITYUNCON	JRETURNQUANTITY	CHAR	15	0	Unconfirmed Quantity
21	UNIT	☐	JRETURNUNIT	MEINS	UNIT	3	0	IS-M: Unit of Measure for Unconfirmed Quantity	T006
22	CON_QUANTITY	☐	JRETURNQUANTITYCON	JRETURNQUANTITY	CHAR	15	0	Confirmed Quantity
23	CON_UNIT	☐	JCONFIRMEDRETURNUNIT	MEINS	UNIT	3	0	IS-M: Unit of Measure for Confirmed Unsold Quantity	T006
24	REF_ORDER_VBELN	☐	JREF_VBELN	VBELN	CHAR	10	0	IS-M: Reference Document	VBAK
25	REF_ORDER_POSNR	☐	JREF_POSNR	POSNR	NUMC	6	0	IS-M: Reference Item	VBUP
26	STATE	☐	JRETURNSTATE	JSTATE	CHAR	1	0	IS-M: Processing Status
27	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
28	CREDIT_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
29	CREDIT_POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
30	Q1	☐	JKSDRETURNQUANTITY1	MENG13	QUAN	13	3	Quantity 1
31	Q2	☐	JKSDRETURNQUANTITY2	MENG13	QUAN	13	3	Quantity 2
32	Q3	☐	JKSDRETURNQUANTITY3	MENG13	QUAN	13	3	Quantity 3
33	Q4	☐	JKSDRETURNQUANTITY4	MENG13	QUAN	13	3	Quantity 4
34	Q5	☐	JKSDRETURNQUANTITY5	MENG13	QUAN	13	3	Quantity 5
35	Q6	☐	JKSDRETURNQUANTITY6	MENG13	QUAN	13	3	Quantity 6
36	Q7	☐	JKSDRETURNQUANTITY7	MENG13	QUAN	13	3	Quantity 7
37	Q8	☐	JKSDRETURNQUANTITY8	MENG13	QUAN	13	3	Quantity 8
38	Q9	☐	JKSDRETURNQUANTITY9	MENG13	QUAN	13	3	Quantity 9
39	Q10	☐	JKSDRETURNQUANTITY10	MENG13	QUAN	13	3	Quantity 10
40	UNIT_Q	☐	JKSDUNIT	MEINS	UNIT	3	0	Unit of Measure	T006
41	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
42	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
43	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
44	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
45	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
46	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
47	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
48	R2GENERATION	☐	ISMRETURNSECGENERATION	XFELD	CHAR	1	0	Second Generation Return
49	RETURNREC	☐	ISMRETURNREC	ISMRETURNREC	CHAR	2	0	Return Record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJKSDRETURNWORKLIST	CON_UNIT	T006	MSEHI	REF	1	CN
2	RJKSDRETURNWORKLIST	REF_ORDER_POSNR	VBUP	POSNR	REF	1	CN
3	RJKSDRETURNWORKLIST	REF_ORDER_VBELN	VBAK	VBELN	REF	1	CN
4	RJKSDRETURNWORKLIST	UNIT	T006	MSEHI	REF	1	CN
5	RJKSDRETURNWORKLIST	UNIT_Q	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20050301
SAP Release Created in	600