SAP ABAP Table MCVBRK (Billing Document: Header Data ;)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCV (Package) R/3 application development: Sales Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCVBRK	Table Relationship Diagram
Short Description	Billing Document: Header Data ;

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	Billing Document: Header Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	VBUK
4	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
5	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
6	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
7	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
8	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
9	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
10	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
11	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
12	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
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	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
20	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
21	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
22	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
23	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
24	RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
25	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
26	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
27	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
28	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
29	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
30	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
31	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
32	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
33	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country	T005
34	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
35	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
36	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
37	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
38	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
39	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
40	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
41	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
42	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
43	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
44	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
45	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
46	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
47	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
48	ZUKRI	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
49	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
50	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
51	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
52	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
53	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
54	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
55	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
56	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
57	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
58	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
59	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
60	SFAKN	☐	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number	VBUK
61	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
62	FKART_RL	☐	FKART_RL	FKART	CHAR	4	0	Invoice list type	TVFK
63	FKDAT_RL	☐	FKDAT_RL	DATUM	DATS	8	0	Billing date for the invoice list
64	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
65	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
66	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
67	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
68	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
69	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
70	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
71	CMKUF	☐	CMKUF	KURRF	DEC	9	5	Credit data exchange rate at billing document rate
72	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing	THIT
73	BSTNK_VF	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
74	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
75	FKART_AB	☐	FKART_AB	FKART	CHAR	4	0	Accrual billing type	*
76	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
77	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
78	STCEG_H	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
79	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
80	XBLNR	☐	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
81	ZUONR	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
82	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
83	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
84	FKSTO	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
85	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
86	RPLNR	☐	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number	FPLA
87	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
88	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
89	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
90	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade	TCURC
91	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
92	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
93	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
94	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
95	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
96	VKONT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
97	FKK_DOCSTAT	☐	DOCSTAT_KK	DOCSTAT_KK	CHAR	1	0	Additional Status Transfer to Fin. Accounting (Res. RFBSK)
98	NRZAS	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
99	SPE_BILLING_IND	☐	/SPE/DE_BILLING_IND	/SPE/DE_BILLING_IND	CHAR	1	0	EWM Billing Indicator
100	VTREF	☐	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
101	FK_SOURCE_SYS	☐	FK_SOURCE_SYS	LOGSYS	CHAR	10	0	Source System	*
102	FKTYP_CRM	☐	FKTYP_CRM	FKTYP	CHAR	1	0	Billing Category in CRM
103	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	T041C
104	VBTYP_EXT	☐	TDD_VBTYP_EXT	DOM_VBTYP_EXT	CHAR	4	0	Extension of SD Document Category
105	.INCLU--AP	☐				0	0	VBRK append for Down Payment Chain
106	DPC_REL	☐	/SAPPCE/DPC_REL	CHAR01	CHAR	1	0	Flag: DPC relevant
107	.INCLU--AP	☐				0	0	VBRK_SEPA
108	.INCLUDE	☐				0	0	SEPA SD Struktur
109	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
110	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
111	SEPON	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
112	MNDVG	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
113	.INCLU--AP	☐				0	0	Append Structure for Special Paymenents
114	SPPAYM	☐	SPPAYM	SPPAYM	CHAR	2	0	Payment Form for Special Payment Method
115	SPPORD	☐	SPPORD	VBELN	CHAR	10	0	Sales Order for Special Payment Method	*
116	.INCLUDE	☐				0	0	Additional Specification: Billing Document - Header Data
117	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
118	RFBSK_OLD	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
119	PERIV_CM	☐	PERIV_CM	PERIV	CHAR	2	0	Fiscal year variant of credit control area	*
120	.INCLUDE	☐				0	0	Partner Field String from VBPA
121	PKUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
122	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
123	PKUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
124	PKUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
125	PSPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	*
126	PVRTNR	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
127	PLAAG	☐	PLAAG	LAND1	CHAR	3	0	Country of the sold-to party	*
128	PLAWE	☐	PLAWE	LAND1	CHAR	3	0	Country of ship-to party	*
129	PLARE	☐	PLARE	LAND1	CHAR	3	0	Country of the bill-to party	*
130	PLARG	☐	PLARG	LAND1	CHAR	3	0	Country of the payer	*
131	PLASP	☐	PLASP	LAND1	CHAR	3	0	Country of the carrier	*
132	PLAVE	☐	PLAVE	LAND1	CHAR	3	0	Country of the representative	*
133	PABLA	☐	PABLA	TEXT25	CHAR	25	0	Unloading point of the ship-to party
134	PZONE	☐	PZONE	ZONE	CHAR	10	0	Transportation zone of the ship-to party	*
135	.INCLUDE	☐				0	0	User Section: Additional Partner(s) from VBPA
136	PDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
137	PZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible
138	PLAZM	☐	PLAZM	LAND1	CHAR	3	0	Country of Employee Responsible	*
139	.INCLUDE	☐				0	0	Customer Hierarchy Levels
140	HIEZU01	☐	HIEZU01	KUNNR	CHAR	10	0	Customer hierarchy Level 1	KNA1
141	HIEZU02	☐	HIEZU02	KUNNR	CHAR	10	0	Customer hierarchy Level 2	KNA1
142	HIEZU03	☐	HIEZU03	KUNNR	CHAR	10	0	Customer hierarchy Level 3	KNA1
143	HIEZU04	☐	HIEZU04	KUNNR	CHAR	10	0	Customer hierarchy Level 4	KNA1
144	HIEZU05	☐	HIEZU05	KUNNR	CHAR	10	0	Customer hierarchy Level 5	KNA1
145	HIEZU06	☐	HIEZU06	KUNNR	CHAR	10	0	Customer hierarchy Level 6	KNA1
146	HIEZU07	☐	HIEZU07	KUNNR	CHAR	10	0	Customer hierarchy Level 7	KNA1
147	HIEZU08	☐	HIEZU08	KUNNR	CHAR	10	0	Customer hierarchy Level 8	KNA1
148	HIEZU09	☐	HIEZU09	KUNNR	CHAR	10	0	Customer hierarchy Level 9	KNA1
149	HIEZU10	☐	HIEZU10	KUNNR	CHAR	10	0	Customer hierarchy Level 10	KNA1
150	.INCLUDE	☐				0	0	User Structure: Billing Document - Customer Data
151	DUMMY	☐	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	MCVBRK	AKWAE	TCURC	WAERS	REF	1	CN
2	MCVBRK	BUKRS	T001	BUKRS
3	MCVBRK	BUPLA	J_1BBRANCH	BRANCH		C	CN
4	MCVBRK	BZIRK	T171	BZIRK
5	MCVBRK	CITYC	T005G	CITYC
6	MCVBRK	CMWAE	TCURC	WAERS
7	MCVBRK	COUNC	T005E	COUNC
8	MCVBRK	EXNUM	EIKP	EXNUM
9	MCVBRK	FKART	TVFK	FKART
10	MCVBRK	FKART_RL	TVFK	FKART
11	MCVBRK	HIEZU01	KNA1	KUNNR
12	MCVBRK	HIEZU02	KNA1	KUNNR
13	MCVBRK	HIEZU03	KNA1	KUNNR
14	MCVBRK	HIEZU04	KNA1	KUNNR
15	MCVBRK	HIEZU05	KNA1	KUNNR
16	MCVBRK	HIEZU06	KNA1	KUNNR
17	MCVBRK	HIEZU07	KNA1	KUNNR
18	MCVBRK	HIEZU08	KNA1	KUNNR
19	MCVBRK	HIEZU09	KNA1	KUNNR
20	MCVBRK	HIEZU10	KNA1	KUNNR
21	MCVBRK	HITYP_PR	THIT	HITYP
22	MCVBRK	INCO1	TINC	INCO1
23	MCVBRK	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
24	MCVBRK	KALSM	T683	KALSM
25	MCVBRK	KDGRP	T151	KDGRP
26	MCVBRK	KKBER	T014	KKBER
27	MCVBRK	KNKLI	KNA1	KUNNR
28	MCVBRK	KNUMA	KONA	KNUMA
29	MCVBRK	KONDA	T188	KONDA
30	MCVBRK	KTGRD	TVKT	KTGRD
31	MCVBRK	KUNAG	KNA1	KUNNR
32	MCVBRK	KUNRG	KNA1	KUNNR
33	MCVBRK	KURST	TCURV	KURST
34	MCVBRK	LAND1	T005	LAND1
35	MCVBRK	LCNUM	AKKP	LCNUM		C	CN
36	MCVBRK	MABER	T047M	MABER
37	MCVBRK	MANDT	T000	MANDT
38	MCVBRK	MANSP	T040S	MANSP
39	MCVBRK	MSCHL	T040	MSCHL
40	MCVBRK	PLTYP	T189	PLTYP
41	MCVBRK	REGIO	T005S	BLAND
42	MCVBRK	RPLNR	FPLA	FPLNR	REF	C	C
43	MCVBRK	SFAKN	VBUK	VBELN
44	MCVBRK	SPART	TSPA	SPART
45	MCVBRK	STGRD	T041C	STGRD		1	CN
46	MCVBRK	STWAE	TCURC	WAERS
47	MCVBRK	VBELN	VBUK	VBELN
48	MCVBRK	VBUND	T880	RCOMP
49	MCVBRK	VKORG	TVKO	VKORG
50	MCVBRK	VSBED	TVSB	VSBED
51	MCVBRK	VTWEG	TVTW	VTWEG
52	MCVBRK	WAERK	TCURC	WAERS
53	MCVBRK	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in