SAP ABAP Table MCVBKDB (Reference Structure from MCVBEP 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	MCVBKDB	Table Relationship Diagram
Short Description	Reference Structure from MCVBEP 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	Sales Document: Commercial Data
4	.INCLUDE	☐				0	0	Sales Document: Business Data
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
7	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
8	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
9	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
10	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
11	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
12	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
13	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
14	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
15	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
16	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
17	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
18	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
19	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
20	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
21	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
22	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
23	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
24	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
25	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
26	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
27	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
28	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
29	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
30	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
31	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
32	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
33	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA
34	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
35	ABSSC	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure	T691M
36	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
37	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
38	J_1ARFZ	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	J_1ARFZ
39	J_1AREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
40	J_1AGICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
41	J_1ADTYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
42	J_1ATXREL	☐	J_1ATXREL_	J_1ATXREL	CHAR	10	0	Tax relevant classification	J_1ATXREL
43	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
44	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
45	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
46	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
47	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
48	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
49	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
50	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
51	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	T176
52	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
53	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
54	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
55	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
56	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
57	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
58	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
59	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
60	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
61	WKWAE	☐	WKWAE	WAERS	CUKY	5	0	Value contract currency	TCURC
62	WKKUR	☐	WKKUR	KURRF	DEC	9	5	Exchange rate in value contract currency
63	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade	TCURC
64	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
65	AKPRZ	☐	AKPRZ	PRZ32	DEC	5	2	Depreciation percentage for financial document processing
66	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
67	J_1AIDATEP	☐	J_1AIDATES	J_1AUDATEP	DATS	8	0	Indexing base date
68	BSTKD_M	☐	BSTKD_M	CHAR35	CHAR	35	0	Customer PO number as matchcode field
69	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time	TVDC
70	FFPRF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
71	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
72	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
73	RRREL	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
74	ACDATV	☐	RR_ACDATV	RR_ACDATV	CHAR	1	0	Proposed start date for accrual period
75	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
76	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	TVTY
77	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	MARA
78	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
79	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
80	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
81	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
82	CAMPAIGN	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
83	VKONT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
84	DPBP_REF_FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
85	DPBP_REF_FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
86	REVSP	☐	RR_REVSP	RR_REVSP	CHAR	1	0	Revenue Distribution Type
87	REVEVTYP	☐	RR_REVEVTYP_CUST	RR_REVEVTYP_CUST	CHAR	1	0	Revenue Event Type (Customizing)
88	VTREF	☐	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
89	.INCLU--AP	☐				0	0	Period of Performance
90	PEROP_BEG	☐	FM_PEROP_SD_LOW	DATUM	DATS	8	0	Period of Performance Start Date
91	PEROP_END	☐	FM_PEROP_SD_HIGH	DATUM	DATS	8	0	Period of Performance End Date
92	.INCLU--AP	☐				0	0	Sales forms extension
93	STCODE	☐	J_1ISTCODE	J_1ISTCODE	CHAR	3	0	LST CST applicability code	*
94	FORMC1	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type	*
95	FORMC2	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type	*
96	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
97	.INCLU--AP	☐				0	0	Complaint Management
98	COMPREAS	☐	CMP_COMPREAS_COPY	CMP_COMPREAS_COPY	CHAR	4	0	Abbreviation for Complaints Reason
99	.INCLU--AP	☐				0	0	VBRK_SEPA
100	.INCLUDE	☐				0	0	SEPA SD Struktur
101	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
102	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
103	SEPON	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
104	MNDVG	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
105	.INCLU--AP	☐				0	0	Append for BW Transfer
106	.INCLUDE	☐				0	0	Enhancement MCVBKD for BW Transer
107	WMINR_XX	☐	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	MCVBKDB	ABSSC	T691M	ABSSC	REF	C	CN
2	MCVBKDB	ABTNR	TSAB	ABTNR	REF	1	CN
3	MCVBKDB	AKWAE	TCURC	WAERS	REF	1	CN
4	MCVBKDB	BEMOT	TBMOT	BEMOT	REF	1	CN
5	MCVBKDB	BSARK	T176	BSARK	REF	C	CN
6	MCVBKDB	BSARK_E	T176	BSARK		C	CN
7	MCVBKDB	BZIRK	T171	BZIRK
8	MCVBKDB	DELCO	TVDC	DELCO	KEY	1	CN
9	MCVBKDB	FFPRF	AD01C_PROF	PROFNR		1	CN
10	MCVBKDB	FKBER	TFKB	FKBER
11	MCVBKDB	FPLNR	FPLA	FPLNR
12	MCVBKDB	INCO1	TINC	INCO1
13	MCVBKDB	J_1ADTYP	J_1ADTYP	J_1ADTYP		1	CN
14	MCVBKDB	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
15	MCVBKDB	J_1AGICD	J_1AGICD	J_1AGICD		1	CN
16	MCVBKDB	J_1AINDXP	J_1AINFT20	J_1AINDX	KEY	1	CN
17	MCVBKDB	J_1AREGIO	T005S	BLAND		1	CN
18	MCVBKDB	J_1ARFZ	J_1ARFZ	J_1ARFZ		1	CN
19	MCVBKDB	J_1ATXREL	J_1ATXREL	J_1ATXREL		1	CN
20	MCVBKDB	KDGRP	T151	KDGRP
21	MCVBKDB	KDKG1	TVKGG	KDKGR		C	CN
22	MCVBKDB	KDKG2	TVKGG	KDKGR		C	CN
23	MCVBKDB	KDKG3	TVKGG	KDKGR		C	CN
24	MCVBKDB	KDKG4	TVKGG	KDKGR		C	CN
25	MCVBKDB	KDKG5	TVKGG	KDKGR		C	CN
26	MCVBKDB	KONDA	T188	KONDA
27	MCVBKDB	KTGRD	TVKT	KTGRD
28	MCVBKDB	LCNUM	AKKP	LCNUM		C	CN
29	MCVBKDB	MANDT	T000	MANDT
30	MCVBKDB	MANSP	T040S	MANSP
31	MCVBKDB	MSCHL	T040	MSCHL
32	MCVBKDB	PERFK	TFACD	IDENT
33	MCVBKDB	PERRL	TFACD	IDENT
34	MCVBKDB	PLTYP	T189	PLTYP
35	MCVBKDB	POSNR	VBUP	POSNR
36	MCVBKDB	SDABW	TVSAK	SDABW	KEY	1	CN
37	MCVBKDB	TRATY	TVTY	TRATY	KEY	1	CN
38	MCVBKDB	TRMTYP	MARA	MATNR	KEY	1	CN
39	MCVBKDB	VBELN	VBUK	VBELN
40	MCVBKDB	VSART	T173	VSART	KEY	1	CN
41	MCVBKDB	WAKTION	WAKH	AKTNR	REF	1	CN
42	MCVBKDB	WKWAE	TCURC	WAERS		1	CN
43	MCVBKDB	WMINR	WWMI	WMINR	REF	1	CN
44	MCVBKDB	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in