SAP ABAP Table JKSDUNSOLDITEM (IS-M: Item Data on Unsold Copies/Credit Memos)

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	JKSDUNSOLDITEM	Table Relationship Diagram
Short Description	IS-M: Item Data on Unsold Copies/Credit Memos

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	JKSDUNSOLD
3	POSNR	☑	JRETURNPOSNR	POSNR	NUMC	6	0	IS-M: Request Item Number	*
4	UE_POSNR	☐	JRETURNPOSNR	POSNR	NUMC	6	0	IS-M: Request Item Number	*
5	.INCLUDE	☐				0	0	IS-M: Item Data on Request
6	POSNR_EX	☐	JRETURNPOSNR_EX	POSNR	NUMC	6	0	IS-M: External Item Number	*
7	MEDIA_FAMILY	☐	ISMMATNR_FAMILY	MATNR	CHAR	18	0	Media Product Family	*
8	MEDIA_PRODUCT	☐	ISMMATNR_PRODUCT	MATNR	CHAR	18	0	Media Product	*
9	MEDIA_ISSUE	☐	ISMMATNR_ISSUE	MATNR	CHAR	18	0	Media Issue	*
10	COPY_NUMBER	☐	ISMHEFTNUMMER	HEFTNUMMER	CHAR	9	0	Copy Number of Media Issue
11	PUBL_DATE	☐	ISMPUBLDATE	DATUM	DATS	8	0	Publication Date
12	DAY_FROM	☐	DAY_FROM	DATUM	DATS	8	0	IS-M: Summarized Returns From
13	DAY_TO	☐	DAY_TO	DATUM	DATS	8	0	IS-M: Summarized Return To
14	QUANTITY	☐	JRETURNQUANTITY	MENG13	QUAN	13	3	IS-M: Unsold Quantity
15	UNIT	☐	JRETURNUNIT	MEINS	UNIT	3	0	IS-M: Unit of Measure for Unconfirmed Quantity	*
16	CON_QUANTITY	☐	JCONFIRMEDRETURNQUANTITY	MENG13	QUAN	13	3	IS-M: Confirmed Unsold Quantity
17	CON_UNIT	☐	JCONFIRMEDRETURNUNIT	MEINS	UNIT	3	0	IS-M: Unit of Measure for Confirmed Unsold Quantity	*
18	REF_ORDER_VBELN	☐	JREF_VBELN	VBELN	CHAR	10	0	IS-M: Reference Document	*
19	REF_ORDER_POSNR	☐	JREF_POSNR	POSNR	NUMC	6	0	IS-M: Reference Item	*
20	REASON_CODE	☐	JREASON_CODE	AUGRU	CHAR	3	0	IS-M: Reason	TVAU
21	.INCLUDE	☐				0	0	IS-M: Item Data - Mass Credit Memos
22	REF_POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
23	CALCTYPCON	☐	CALCTYPECRED	CALCTYPECRED	CHAR	1	0	IS-M: Condition Calculation Rule for Credit Memo Request
24	COND_VALUE	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
25	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	COND_UNIT	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
27	COND_P_UNT	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
28	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
29	STATE	☐	JRETURNSTATE	JSTATE	CHAR	1	0	IS-M: Processing Status
30	CREDIT_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
31	CREDIT_POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
32	XCORASSIGEND	☐	XCORASSIGEND	XFELD	CHAR	1	0	IS-M: Correction Quantities Assigned to Contract

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKSDUNSOLDITEM	COND_UNIT	T006	MSEHI	REF
2	JKSDUNSOLDITEM	CURRENCY	TCURC	WAERS	REF
3	JKSDUNSOLDITEM	MANDT	T000	MANDT	KEY	1	CN
4	JKSDUNSOLDITEM	MATNR	MARA	MATNR	REF	1	CN
5	JKSDUNSOLDITEM	REASON_CODE	TVAU	AUGRU	REF	C	CN
6	JKSDUNSOLDITEM	VBELN	JKSDUNSOLD	VBELN	KEY	1	CN

History

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