SAP ABAP Table MCJKAKB (IS-PSD: Ref.Structure for MCJKAKB for LIS Function Module)

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	MCJKAKB	Table Relationship Diagram
Short Description	IS-PSD: Ref.Structure for MCJKAKB for LIS Function Module

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

History

Last changed by/on	SAP	20110901
SAP Release Created in