SAP ABAP Table JKSDUNSOLD (IS-M: Header Data on Unsold Copies)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JKSDUNSOLD	Table Relationship Diagram
Short Description	IS-M: Header Data on Unsold Copies

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	JVBELNRETURN	VBELN	CHAR	10	0	Internal Number	*
3	UNSOLD_GROUP	☐	ISM_UNSOLD_GROUP	UNSOLD_GROUP	CHAR	2	0	Group
4	UNSOLD_TYPE	☐	ISM_UNSOLD_TYPE	UNSOLD_TYPE	CHAR	2	0	Operation	*
5	WEEKDISPLAY	☐	ISM_WEEKDISPLAY	XFLAG	CHAR	1	0	Data Changed in Weekly Recording
6	UNSOLDGPNR	☐	JUNSOLDGPNR	KUNNR	CHAR	10	0	Returning Retailer	*
7	UNSOLDNUMBER	☐	UNSOLDNUMBER	UNSOLDNUMBER	CHAR	10	0	External Request Number
8	UNSOLDDATE	☐	JUNSOLDDATE	DATUM	DATS	8	0	Notification Date
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
12	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
13	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
14	ORIGIN	☐	JORIGIN	JORIGIN	CHAR	1	0	Data Origin
15	.INCLUDE	☐				0	0	Header Data - Mass Credit Memos
16	CREDIT_TYPE	☐	JCREDIT_TYPE	JCREDIT_TYPE	CHAR	1	0	IS-M: Retail - type of credit memo
17	REF_VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
18	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
19	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
20	XCOPYCOND	☐	XCOPYCOND	XFELD	CHAR	1	0	IS-M/SD: Credit Memo Generation - Conditions from Order
21	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
22	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
23	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
24	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
25	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
26	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
27	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
28	COLLNMBR	☐	COLLNMBR	ISPSAMMG	CHAR	10	0	Group Number	*
29	COLLUSER	☐	COLLUSER	USNAM	CHAR	12	0	Created By
30	COLLDATE	☐	COLLDATE	DATUM	DATS	8	0	Created on
31	COLLTIME	☐	COLLTIME	UZEIT	TIMS	6	0	Time of last change
32	APPL_HANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle
33	ORD_REASON	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKSDUNSOLD	KUNAG	KNA1	KUNNR	REF	C	CN
2	JKSDUNSOLD	MANDT	T000	MANDT	KEY	1	CN
3	JKSDUNSOLD	ORD_REASON	TVAU	AUGRU
4	JKSDUNSOLD	REF_VBELN	VBUK	VBELN	REF	C	CN
5	JKSDUNSOLD	SPART	TVTA	SPART	REF	1	CN
6	JKSDUNSOLD	VKBUR	TVKBZ	VKBUR	REF	C	CN
7	JKSDUNSOLD	VKGRP	TVBVK	VKGRP	REF	C	CN
8	JKSDUNSOLD	VKORG	TVKO	VKORG	REF	1	CN
9	JKSDUNSOLD	VTWEG	TVKOV	VTWEG	REF	1	CN

History

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