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

History

Last changed by/on	SAP	20130529
SAP Release Created in