SAP ABAP Table MCJKAK (IS-PSD: Return/Complaint Header, LIS Communication Structure)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	INTTAB	Structure
Structure	MCJKAK	Table Relationship Diagram
Short Description	IS-PSD: Return/Complaint Header, LIS Communication Structure

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	Sales Order Header Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
4	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
5	JPARVWGPAG	☐	JPARVWGPAG	JPARVWGPAG	CHAR	1	0	IS-M: Partner usage of sold-to party
6	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
7	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
8	VBTYP	☐	VBTYP_ISP	VBTYP_ISP	CHAR	1	0	Sales document category, IS-M
9	TRVOG	☐	TRVOG_ISP	TRVOG_ISP	CHAR	1	0	Transaction Group for IS-M Order Processing
10	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
11	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
12	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
13	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
16	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
17	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
18	VKBUR	☐	JVKBUR	VKBUR	CHAR	4	0	IS-M/SD: Receiving Sales Office	TVKBZ
19	EXEMPLART	☐	EXEMPLART	EXEMPLART	CHAR	1	0	IS-M: Copy Type
20	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
21	GSKST	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	TGSB
22	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
23	FAKSP	☐	FAKTSPERRE	FAKSP	CHAR	2	0	Billing Block	TVFS
24	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
25	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
26	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
27	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
28	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
29	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
30	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
31	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
32	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
33	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
34	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
35	XIMMATRIK	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
36	IMMATDAT	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
37	XSEPFKKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
38	XREMRECHT	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
39	REMSP	☐	REMSP	XFELD	CHAR	1	0	IS-M: Billing Block for Return Notification
40	KORRGRD	☐	KORRGRD	KORRGRD	CHAR	3	0	IS-M: Reason for correction	TJK81
41	REMVON	☐	REMVON_ISP	DATUM	DATS	8	0	IS-M: Return date from
42	REMBIS	☐	REMBIS_ISP	DATUM	DATS	8	0	IS-M: Return date valid to
43	REFBELEG	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
44	REMDATUM	☐	REMDAT_ISP	DATUM	DATS	8	0	IS-M: Date of return notification
45	REMSCHEIN	☐	RSCHEIN_IS	NUM6	NUMC	6	0	IS-M: Return slip number
46	IVWDATUM	☐	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns
47	POSNR_LAST	☐	POSNR_LAST	APNR	NUMC	6	0	Last Assigned Item Number	JKAP
48	POSEX_LAST	☐	POSEX_LAST	POSEX_ISP	NUMC	6	0	Last purchase order item number assigned
49	KPOSN_LAST	☐	KPOSN_LAST	NUM6	NUMC	6	0	IS-M: Last condition item number assigned
50	XFKBASAUFT	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
51	XFKBASLIEF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
52	XJKSOFAKT	☐	XJKSOFAKT	XFELD	CHAR	1	0	IS-M/SD: Immed.billing for credit memo request (subsc.only)
53	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
54	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
55	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
56	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
57	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
58	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
59	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
60	XWBZABO	☐	XWBZABO	XFELD	CHAR	1	0	IS-M: WBZ subscription
61	XFKVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
62	XSTATARC	☐	XJSTATARC	XFELD	CHAR	1	0	IS-M: Order archived in full (only placed in archive)
63	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
64	KALSM_AMO	☐	KALSM_AMO	KALSM	CHAR	6	0	IS-M/SD: Pricing Procedure for Amortization	T683
65	XRENEWAL	☐	XRENEWAL	XFELD	CHAR	1	0	IS-M/SD: Order extended by renewal offer
66	AMORTN	☐	AMORTN	AMORTN	CHAR	1	0	IS-M/SD: Use of Liability Account in Order
67	REKLERGB	☐	ISM_REKLERGB	ISM_REKLERGB	CHAR	2	0	IS-M: Complaint Result	TJK17
68	REKLTYP	☐	ISM_REKLTYP	ISM_REKLTYP	NUMC	1	0	IS-M: Complaint Category
69	REKLDATUM	☐	ISM_COMPLDATE	DATUM	DATS	8	0	IS-M/SD: Complaint Date
70	.INCLUDE	☐				0	0	IS-M/SD: Partner Field String for LIS Connection
71	GPNRAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
72	GPNRWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	*
73	GPNRRE	☐	GPNR_RE	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
74	GPNRRG	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	*
75	GPNRVM	☐	GPVERM	GPNR	CHAR	10	0	Business Partner Sales Agent	*
76	PLZWE	☐	JMCPLZWE	PSTLZ	CHAR	10	0	Postal code in ship-to party address from order
77	PLZRE	☐	JMCPLZRE	PSTLZ	CHAR	10	0	Postal code in bill-to party address from order
78	KGSWE	☐	JMCKGSWE	KREISG_SCH	CHAR	15	0	District municip. key for ship-to party address from order	*
79	.INCLUDE	☐				0	0	IS-PSD: LIS Comm.Structure, Additional Order Header Data
80	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
81	BUKRS	☐	VKBUK	BUKRS	CHAR	4	0	Company code of the sales organization	*
82	.INCLUDE	☐				0	0	IS-PSD: LIS Comm.Structure - Order Header, User Data
83	DUMMYUSR	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCJKAK	AUART	TJAK	AUART
2	MCJKAK	BSARK	T176	BSARK
3	MCJKAK	FAKSP	TVFS	FAKSP
4	MCJKAK	GPAG	JGTGPNR	GPNR
5	MCJKAK	GSBER	TGSB	GSBER
6	MCJKAK	GSKST	TGSB	GSBER
7	MCJKAK	KALSM	T683	KALSM
8	MCJKAK	KALSM_AMO	T683	KALSM	REF	C	CN
9	MCJKAK	KORRGRD	TJK81	KORRGRD
10	MCJKAK	KURST	TCURV	KURST
11	MCJKAK	MANDT	T000	MANDT
12	MCJKAK	POSNR_LAST	JKAP	POSNR
13	MCJKAK	REKLERGB	TJK17	REKLERGB	KEY	1	CN
14	MCJKAK	SPART	TVTA	SPART
15	MCJKAK	STAFO	TMCB	STAFO
16	MCJKAK	STWAE	TCURC	WAERS
17	MCJKAK	VKBUR	TVKBZ	VKBUR
18	MCJKAK	VKGRP	TVBVK	VKGRP
19	MCJKAK	VKORG	TVKO	VKORG
20	MCJKAK	VTWEG	TVKOV	VTWEG
21	MCJKAK	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20110901
SAP Release Created in