SAP ABAP Table MMVBKD (Purchase Order Item + Sales Document Commercial Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MMVBKD	ABSSC	T691M	ABSSC	REF	C	CN
2	MMVBKD	ABTNR	TSAB	ABTNR	REF	1	CN
3	MMVBKD	AKWAE	TCURC	WAERS	REF	1	CN
4	MMVBKD	BEMOT	TBMOT	BEMOT	REF	1	CN
5	MMVBKD	BSARK	T176	BSARK	REF	C	CN
6	MMVBKD	BSARK_E	T176	BSARK		C	CN
7	MMVBKD	BZIRK	T171	BZIRK	REF	C	CN
8	MMVBKD	DELCO	TVDC	DELCO	KEY	1	CN
9	MMVBKD	FFPRF	AD01C_PROF	PROFNR		1	CN
10	MMVBKD	FKBER	TFKB	FKBER
11	MMVBKD	FPLNR	FPLA	FPLNR	REF	C	CN
12	MMVBKD	INCO1	TINC	INCO1	REF	C	CN
13	MMVBKD	J_1ADTYP	J_1ADTYP	J_1ADTYP		1	CN
14	MMVBKD	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
15	MMVBKD	J_1AGICD	J_1AGICD	J_1AGICD		1	CN
16	MMVBKD	J_1AINDXP	J_1AINFT20	J_1AINDX	KEY	1	CN
17	MMVBKD	J_1AREGIO	T005S	BLAND		1	CN
18	MMVBKD	J_1ARFZ	J_1ARFZ	J_1ARFZ		1	CN
19	MMVBKD	J_1ATXREL	J_1ATXREL	J_1ATXREL		1	CN
20	MMVBKD	KDGRP	T151	KDGRP	REF	C	CN
21	MMVBKD	KDKG1	TVKGG	KDKGR		C	CN
22	MMVBKD	KDKG2	TVKGG	KDKGR		C	CN
23	MMVBKD	KDKG3	TVKGG	KDKGR		C	CN
24	MMVBKD	KDKG4	TVKGG	KDKGR		C	CN
25	MMVBKD	KDKG5	TVKGG	KDKGR		C	CN
26	MMVBKD	KONDA	T188	KONDA	REF	C	CN
27	MMVBKD	KTGRD	TVKT	KTGRD	REF	C	CN
28	MMVBKD	LCNUM	AKKP	LCNUM		C	CN
29	MMVBKD	MANDT	T000	MANDT	KEY	1	CN
30	MMVBKD	MANSP	T040S	MANSP	REF	C	CN
31	MMVBKD	MSCHL	T040	MSCHL	REF	C	CN
32	MMVBKD	PERFK	TFACD	IDENT	REF	C	CN
33	MMVBKD	PERRL	TFACD	IDENT	REF	C	CN
34	MMVBKD	PLTYP	T189	PLTYP	REF	C	CN
35	MMVBKD	POSNR	VBUP	POSNR	KEY	1	CN
36	MMVBKD	SDABW	TVSAK	SDABW	KEY	1	CN
37	MMVBKD	TRATY	TVTY	TRATY	KEY	1	CN
38	MMVBKD	TRMTYP	MARA	MATNR	KEY	1	CN
39	MMVBKD	VBELN	VBUK	VBELN	KEY	1	C
40	MMVBKD	VSART	T173	VSART	KEY	1	CN
41	MMVBKD	WAKTION	WAKH	AKTNR	REF	1	CN
42	MMVBKD	WKWAE	TCURC	WAERS		1	CN
43	MMVBKD	WMINR	WWMI	WMINR	REF	1	CN
44	MMVBKD	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in