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

History

Last changed by/on	SAP	20130529
SAP Release Created in