SAP ABAP Table RJKSDUNSOLDLINE (IS-M: Line in Return)

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	RJKSDUNSOLDLINE	Table Relationship Diagram
Short Description	IS-M: Line in Return

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	.INCLUDE	☐				0	0	IS-M: Header Data on Unsold Copies
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	JVBELNRETURN	VBELN	CHAR	10	0	Internal Number	*
4	UNSOLD_GROUP	☐	ISM_UNSOLD_GROUP	UNSOLD_GROUP	CHAR	2	0	Group
5	UNSOLD_TYPE	☐	ISM_UNSOLD_TYPE	UNSOLD_TYPE	CHAR	2	0	Operation	*
6	WEEKDISPLAY	☐	ISM_WEEKDISPLAY	XFLAG	CHAR	1	0	Data Changed in Weekly Recording
7	UNSOLDGPNR	☐	JUNSOLDGPNR	KUNNR	CHAR	10	0	Returning Retailer	*
8	UNSOLDNUMBER	☐	UNSOLDNUMBER	UNSOLDNUMBER	CHAR	10	0	External Request Number
9	UNSOLDDATE	☐	JUNSOLDDATE	DATUM	DATS	8	0	Notification Date
10	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
11	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
12	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
13	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
14	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
15	ORIGIN	☐	JORIGIN	JORIGIN	CHAR	1	0	Data Origin
16	.INCLUDE	☐				0	0	Header Data - Mass Credit Memos
17	CREDIT_TYPE	☐	JCREDIT_TYPE	JCREDIT_TYPE	CHAR	1	0	IS-M: Retail - type of credit memo
18	REF_VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
19	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
20	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
21	XCOPYCOND	☐	XCOPYCOND	XFELD	CHAR	1	0	IS-M/SD: Credit Memo Generation - Conditions from Order
22	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
23	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
24	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
25	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
26	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
27	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
28	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
29	COLLNMBR	☐	COLLNMBR	ISPSAMMG	CHAR	10	0	Group Number	*
30	COLLUSER	☐	COLLUSER	USNAM	CHAR	12	0	Created By
31	COLLDATE	☐	COLLDATE	DATUM	DATS	8	0	Created on
32	COLLTIME	☐	COLLTIME	UZEIT	TIMS	6	0	Time of last change
33	APPL_HANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
34	ORD_REASON	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
35	.INCLUDE	☐				0	0	IS-M: Item Data on Request
36	POSNR_EX	☐	JRETURNPOSNR_EX	POSNR	NUMC	6	0	IS-M: External Item Number	*
37	MEDIA_FAMILY	☐	ISMMATNR_FAMILY	MATNR	CHAR	18	0	Media Product Family	*
38	MEDIA_PRODUCT	☐	ISMMATNR_PRODUCT	MATNR	CHAR	18	0	Media Product	*
39	MEDIA_ISSUE	☐	ISMMATNR_ISSUE	MATNR	CHAR	18	0	Media Issue	*
40	COPY_NUMBER	☐	ISMHEFTNUMMER	HEFTNUMMER	CHAR	9	0	Copy Number of Media Issue
41	PUBL_DATE	☐	ISMPUBLDATE	DATUM	DATS	8	0	Publication Date
42	DAY_FROM	☐	DAY_FROM	DATUM	DATS	8	0	IS-M: Summarized Returns From
43	DAY_TO	☐	DAY_TO	DATUM	DATS	8	0	IS-M: Summarized Return To
44	QUANTITY	☐	JRETURNQUANTITY	MENG13	QUAN	13	3	IS-M: Unsold Quantity
45	UNIT	☐	JRETURNUNIT	MEINS	UNIT	3	0	IS-M: Unit of Measure for Unconfirmed Quantity	*
46	CON_QUANTITY	☐	JCONFIRMEDRETURNQUANTITY	MENG13	QUAN	13	3	IS-M: Confirmed Unsold Quantity
47	CON_UNIT	☐	JCONFIRMEDRETURNUNIT	MEINS	UNIT	3	0	IS-M: Unit of Measure for Confirmed Unsold Quantity	*
48	REF_ORDER_VBELN	☐	JREF_VBELN	VBELN	CHAR	10	0	IS-M: Reference Document	*
49	REF_ORDER_POSNR	☐	JREF_POSNR	POSNR	NUMC	6	0	IS-M: Reference Item	*
50	REASON_CODE	☐	JREASON_CODE	AUGRU	CHAR	3	0	IS-M: Reason	TVAU
51	.INCLUDE	☐				0	0	IS-M: Item Data - Mass Credit Memos
52	REF_POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
53	CALCTYPCON	☐	CALCTYPECRED	CALCTYPECRED	CHAR	1	0	IS-M: Condition Calculation Rule for Credit Memo Request
54	COND_VALUE	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
55	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
56	COND_UNIT	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
57	COND_P_UNT	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
58	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
59	STATE	☐	JRETURNSTATE	JSTATE	CHAR	1	0	IS-M: Processing Status
60	CREDIT_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
61	CREDIT_POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
62	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJKSDUNSOLDLINE	COND_UNIT	T006	MSEHI	REF
2	RJKSDUNSOLDLINE	CURRENCY	TCURC	WAERS	REF
3	RJKSDUNSOLDLINE	KUNAG	KNA1	KUNNR	REF	C	CN
4	RJKSDUNSOLDLINE	MANDT	T000	MANDT	KEY	1	CN
5	RJKSDUNSOLDLINE	ORD_REASON	TVAU	AUGRU
6	RJKSDUNSOLDLINE	REASON_CODE	TVAU	AUGRU	REF	C	CN
7	RJKSDUNSOLDLINE	REF_VBELN	VBUK	VBELN	REF	C	CN
8	RJKSDUNSOLDLINE	SPART	TVTA	SPART	REF	1	CN
9	RJKSDUNSOLDLINE	VKBUR	TVKBZ	VKBUR	REF	C	CN
10	RJKSDUNSOLDLINE	VKGRP	TVBVK	VKGRP	REF	C	CN
11	RJKSDUNSOLDLINE	VKORG	TVKO	VKORG	REF	1	CN
12	RJKSDUNSOLDLINE	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20050520
SAP Release Created in	464