SAP ABAP Table MCJVBKB (IS-PSD: Ref.Structure for MCJVBK for LIS Function Modules)

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

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	IS-M/SD: Billing - Header Data
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	VBELN	☐	ISPVBELN	ISPVBELN	CHAR	10	0	IS-M/SD: Billing Document	JFRK
6	FKART	☐	JFKART	JFKART	CHAR	4	0	IS-M: Billing/Settlement Type	TJFK
7	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
8	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
11	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
12	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
13	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
14	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
15	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
16	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
17	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
18	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
19	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
20	RFBSK	☐	JFRFBSK	JFRFBSK	CHAR	1	0	IS-M/SD: Status for transfer to Accounting
21	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
22	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
23	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
24	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
25	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
26	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
27	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
28	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
29	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
30	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
31	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
32	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
33	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
34	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
35	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
36	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
37	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
38	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
39	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
40	ZUKRI	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
41	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
42	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
43	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
44	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
45	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
46	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
47	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
48	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
49	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
50	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
51	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
52	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
53	STCEG_H	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
54	STCEG_L	☐	LAND1TX	LAND1	CHAR	3	0	Tax Destination Country	*
55	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
56	SAMMG	☐	ISPSAMMG	ISPSAMMG	CHAR	10	0	IS-M: Group Number	JFSK
57	.INCLUDE	☐				0	0	IS-PSD: Billing Document Header Data
58	ISPOBJART	☐	LABART	JOBJART	CHAR	4	0	IS-M: Object type for document flow
59	ISPBANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
60	ISPBANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
61	ISPBANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
62	ISPBVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
63	ISPXEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
64	ISPBKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
65	ISPJAVNR	☐	JAVNR	AVNR	CHAR	10	0	IS-M: Merge criterion for order	*
66	ISPJAPNR	☐	JAPNR	APNR	NUMC	6	0	IS-M: Merge criterion for sales order item	*
67	ISPZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
68	ISPSFAKT	☐	ISPSFAKT	VBELN	CHAR	10	0	IS-M: Number of Billing Document Reversed	*
69	ISPJSTORN	☐	JSTORN	JVBELN	CHAR	10	0	IS-M: Reversal Number	*
70	ISPJSNFAK	☐	ISPSNFAK	JVBELN	CHAR	10	0	IS-M: Number of Reversal in Subsequent Document	*
71	ISPBRTWR	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
72	ISPSFKOPF	☐	XSEPFKKOPF	XFELD	CHAR	1	0	Separate billing document for sales order
73	ISPJUEBART	☐	JUEBART	JUEBART	CHAR	1	0	IS-M: Transfer Type
74	ISPXDRUCK	☐	XRECHDRUCK	XFELD	CHAR	1	0	IS-M: Print Invoice
75	ISPANZFPOS	☐	JANZFPOS	JANZFPOS	NUMC	4	0	IS-M: Number of billing items in billing document
76	ISPSHKZGK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
77	ISPBUPER	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
78	ISPUMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
79	ISPSTOGRD	☐	JSTOGRDF	JSTOGRDF	CHAR	3	0	IS-M: Billing Document Reversal Reason	TJF27
80	ISPXJSIND	☐	XJSIND	XFELD	CHAR	1	0	Repeat Billing After Reversal
81	ISPUKONT	☐	UKONT_042I	SAKNR	CHAR	10	0	G/L Account to be Posted to (Bank Subaccount)	*
82	ISPUEBDAT	☐	ISPUEBDAT	ISPUEBDAT	DATS	8	0	IS-M: Accrual Date
83	ISPUEBNR	☐	ISPUEBNR	ISPUEBNR	CHAR	10	0	IS-M: Number of Transfer Run to FI	*
84	ISPXINK	☐	XKINKASSO	XFELD	CHAR	1	0	IS-M: Payment by field collector
85	ISPXUINK	☐	XJUINK	CHAR1	CHAR	1	0	IS-M: Collection billing doc.transferred to company code
86	ISPXWBZABO	☐	XWBZABO	XFELD	CHAR	1	0	IS-M: WBZ subscription
87	ISPINKVSG	☐	ISPINKVSG	KUNNR	CHAR	10	0	IS-M: Field Collector is Service Company	*
88	ISPINKGP	☐	ISPINKGP	KUNNR	CHAR	10	0	IS-M: Field Collector is Employee	*
89	ISPXVDICHT	☐	XFKVDICHT	XFELD	CHAR	1	0	IS-M: Summarize deliveries according to billing item
90	ISPJUEBARH	☐	JUEBARTFKH	JUEBART	CHAR	1	0	IS-M: Transfer type at time of billing
91	ISPXNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
92	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
93	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
94	XRENEWAL	☐	XRENEWAL	XFELD	CHAR	1	0	IS-M/SD: Order extended by renewal offer
95	AMORTN	☐	AMORTN	AMORTN	CHAR	1	0	IS-M/SD: Use of Liability Account in Order
96	XINVAUTHOR	☐	XINVAUTHOR	XFELD	CHAR	1	0	IS-M/SD: Billing document authorized
97	AWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
98	XTRANSFER	☐	XTRANSFER_INV	XFELD	CHAR	1	0	IS-M/SD: Transfer billing document
99	JAVCYCLENR	☐	JAVCYCLENR	CYCLENR	NUMC	3	0	IS-M: Merge Criterion for Order Billing Cycle	*
100	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
101	XPAYMODE_FIX	☐	XPAYMODE_FIX	XFELD	CHAR	1	0	IS-M/SD: Payment Arrangement in Order Fixed
102	BELNR_FKK	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
103	NRZAS	☐	NRZAS_KK	NRZAS_KK	CHAR	12	0	Payment Form Number
104	.INCLUDE	☐				0	0	IS-M/SD: Partner Field String for LIS Connection
105	GPNRAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
106	GPNRWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	*
107	GPNRRE	☐	GPNR_RE	GPNR	CHAR	10	0	IS-M: Business Partner - Bill-To Party	*
108	GPNRRG	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	*
109	GPNRVM	☐	GPVERM	GPNR	CHAR	10	0	Business Partner Sales Agent	*
110	PLZWE	☐	JMCPLZWE	PSTLZ	CHAR	10	0	Postal code in ship-to party address from order
111	PLZRE	☐	JMCPLZRE	PSTLZ	CHAR	10	0	Postal code in bill-to party address from order
112	KGSWE	☐	JMCKGSWE	KREISG_SCH	CHAR	15	0	District municip. key for ship-to party address from order	*
113	.INCLUDE	☐				0	0	IS-PSD: Affix to Billing Header Data, LIS Communic.Structure
114	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
115	.INCLUDE	☐				0	0	IS-PSD: User Fields for Billing Header Data, LIS Comm.Struc.
116	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	MCJVBKB	BUKRS	T001	BUKRS
2	MCJVBKB	CITYC	T005G	CITYC
3	MCJVBKB	COUNC	T005E	COUNC
4	MCJVBKB	FKART	TJFK	FKART
5	MCJVBKB	ISPSTOGRD	TJF27	STOGRD
6	MCJVBKB	ISPUMSKZ	T074U	UMSKZ
7	MCJVBKB	KALSM	T683	KALSM
8	MCJVBKB	KDGRP	T151	KDGRP
9	MCJVBKB	KONDA	T188	KONDA
10	MCJVBKB	KTGRD	TVKT	KTGRD
11	MCJVBKB	KUNAG	KNA1	KUNNR
12	MCJVBKB	KUNRG	KNA1	KUNNR
13	MCJVBKB	KURST	TCURV	KURST
14	MCJVBKB	LAND1	T005	LAND1
15	MCJVBKB	MABER	T047M	MABER
16	MCJVBKB	MANDT	T000	MANDT
17	MCJVBKB	PLTYP	T189	PLTYP
18	MCJVBKB	REGIO	T005S	BLAND
19	MCJVBKB	SAMMG	JFSK	SAMMG	REF	1	CN
20	MCJVBKB	SPART	TSPA	SPART
21	MCJVBKB	STWAE	TCURC	WAERS
22	MCJVBKB	VBELN	JFRK	VBELN
23	MCJVBKB	VKORG	TVKO	VKORG
24	MCJVBKB	VTWEG	TVTW	VTWEG
25	MCJVBKB	WAERK	TCURC	WAERS
26	MCJVBKB	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in