SAP ABAP Table MCVBRKB (Reference Structure from MCVBRK for Function Module)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCVBRKB	AKWAE	TCURC	WAERS	REF	1	CN
2	MCVBRKB	BUKRS	T001	BUKRS
3	MCVBRKB	BUPLA	J_1BBRANCH	BRANCH		C	CN
4	MCVBRKB	BZIRK	T171	BZIRK
5	MCVBRKB	CITYC	T005G	CITYC
6	MCVBRKB	CMWAE	TCURC	WAERS
7	MCVBRKB	COUNC	T005E	COUNC
8	MCVBRKB	EXNUM	EIKP	EXNUM
9	MCVBRKB	FKART	TVFK	FKART
10	MCVBRKB	FKART_RL	TVFK	FKART
11	MCVBRKB	HIEZU01	KNA1	KUNNR
12	MCVBRKB	HIEZU02	KNA1	KUNNR
13	MCVBRKB	HIEZU03	KNA1	KUNNR
14	MCVBRKB	HIEZU04	KNA1	KUNNR
15	MCVBRKB	HIEZU05	KNA1	KUNNR
16	MCVBRKB	HIEZU06	KNA1	KUNNR
17	MCVBRKB	HIEZU07	KNA1	KUNNR
18	MCVBRKB	HIEZU08	KNA1	KUNNR
19	MCVBRKB	HIEZU09	KNA1	KUNNR
20	MCVBRKB	HIEZU10	KNA1	KUNNR
21	MCVBRKB	HITYP_PR	THIT	HITYP
22	MCVBRKB	INCO1	TINC	INCO1
23	MCVBRKB	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
24	MCVBRKB	KALSM	T683	KALSM
25	MCVBRKB	KDGRP	T151	KDGRP
26	MCVBRKB	KKBER	T014	KKBER
27	MCVBRKB	KNKLI	KNA1	KUNNR
28	MCVBRKB	KNUMA	KONA	KNUMA
29	MCVBRKB	KONDA	T188	KONDA
30	MCVBRKB	KTGRD	TVKT	KTGRD
31	MCVBRKB	KUNAG	KNA1	KUNNR
32	MCVBRKB	KUNRG	KNA1	KUNNR
33	MCVBRKB	KURST	TCURV	KURST
34	MCVBRKB	LAND1	T005	LAND1
35	MCVBRKB	LCNUM	AKKP	LCNUM		C	CN
36	MCVBRKB	MABER	T047M	MABER
37	MCVBRKB	MANDT	T000	MANDT
38	MCVBRKB	MANSP	T040S	MANSP
39	MCVBRKB	MSCHL	T040	MSCHL
40	MCVBRKB	PLTYP	T189	PLTYP
41	MCVBRKB	REGIO	T005S	BLAND
42	MCVBRKB	RPLNR	FPLA	FPLNR	REF	C	C
43	MCVBRKB	SFAKN	VBUK	VBELN
44	MCVBRKB	SPART	TSPA	SPART
45	MCVBRKB	STGRD	T041C	STGRD		1	CN
46	MCVBRKB	STWAE	TCURC	WAERS
47	MCVBRKB	VBELN	VBUK	VBELN
48	MCVBRKB	VBUND	T880	RCOMP
49	MCVBRKB	VKORG	TVKO	VKORG
50	MCVBRKB	VSBED	TVSB	VSBED
51	MCVBRKB	VTWEG	TVTW	VTWEG
52	MCVBRKB	WAERK	TCURC	WAERS
53	MCVBRKB	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in