SAP ABAP Table MCVBEPB (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	MCVBEPB	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: Line Data
4	.INCLUDE	☐				0	0	Sales Document: Schedule Line Data
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
7	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
8	ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
9	ETTYP	☐	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	TVEP
10	LFREL	☐	LFREL	XFELD	CHAR	1	0	Item is Relevant for Delivery
11	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
12	EZEIT	☐	EZEIT_VBEP	UZEIT	TIMS	6	0	Arrival time
13	WMENG	☐	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
14	BMENG	☐	BMENG	MENG13	QUAN	13	3	Confirmed quantity
15	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
16	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
17	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
18	BDDAT	☐	BDDAT	DATUM	DATS	8	0	Requirement date (deadline for procurement)
19	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
20	PLART	☐	PLART	PLART	CHAR	1	0	Planning type	*
21	VBELE	☐	VBELE	VBELN	CHAR	10	0	Business document number	VBUK
22	POSNE	☐	POSNE	POSNR	NUMC	6	0	Business item number	VBUP
23	ETENE	☐	ETENE	ETENR	NUMC	4	0	Schedule line	VBEP
24	RSDAT	☐	RSDAT	DATUM	DATS	8	0	Earliest possible reservation date
25	IDNNR	☐	IDNNR	IDNNR	NUMC	10	0	Maintenance request
26	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
27	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	T161
28	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
29	WEPOS	☐	WEPOS_A	ECOST	CHAR	1	0	Confirmation status of schedule line (incl.ALE)
30	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
31	LRGDT	☐	LRGDT	DATUM	DATS	8	0	Return date for returnable packaging
32	PRGRS	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
33	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
34	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
35	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
36	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
37	CMENG	☐	CMENG	MENG13	QUAN	13	3	Corrected quantity in sales unit
38	LIFSP	☐	LIFSP_EP	LIFSP	CHAR	2	0	Schedule line blocked for delivery	TVLS
39	GRSTR	☐	GRSTR	GRSTR	NUMC	3	0	Group definition for structure data
40	ABART	☐	ABART	ABART	CHAR	1	0	Release type
41	ABRUF	☐	ABRUF	ABRUF	NUMC	10	0	Forecast Delivery schedule number
42	ROMS1	☐	DCQNT	MENG13	QUAN	13	3	Committed quantity
43	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
44	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
45	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
46	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	*
47	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
48	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
49	VERFP	☐	VERFP_MAS	XFELD	CHAR	1	0	Availability confirmed automatically
50	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
51	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
52	ETART	☐	EDI_ETTYP	ETART	CHAR	1	0	Schedule line type EDI	TVET
53	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
54	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
55	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
56	AESKD	☐	AESKD	AESKD	CHAR	17	0	Customer Engineering Change Status
57	ABGES	☐	ABGES_CM	FLTP	FLTP	16	16	Guaranteed (factor between 0 and 1)
58	MBUHR	☐	MBUHR	TIME_PLANT	TIMS	6	0	Material Staging Time (Local, Relating to a Plant)
59	TDUHR	☐	TDUHR	TIME_SHIPP	TIMS	6	0	Transp. Planning Time (Local, Relating to a Shipping Point)
60	LDUHR	☐	LDUHR	TIME_SHIPP	TIMS	6	0	Loading Time (Local Time Relating to a Shipping Point)
61	WAUHR	☐	WAUHR	TIME_PLANT	TIMS	6	0	Time of Goods Issue (Local, Relating to a Plant)
62	AULWE	☐	AULWE	AULWE	CHAR	10	0	Route Schedule	VALW
63	.INCLUDE	☐				0	0	Structure: Date for Handover of Goods at Agreed Location
64	HANDOVERDATE	☐	HANDOVER_DATE	HANDOVER_DATE	DATS	8	0	Handover Date at the Handover Location
65	HANDOVERTIME	☐	HANDOVER_TIME	HANDOVER_TIME	TIMS	6	0	Handover time at the handover location
66	.INCLU--AP	☐				0	0	Append for direct shipment processing
67	MBDAT_DRS	☐	MBDAT_DRS	DATUM	DATS	8	0	Material Availability Date Third-Party Order Planning
68	.INCLUDE	☐				0	0	Details: Order Schedule Lines
69	OEIME	☐	MC_OEIME	MENGV15_3	QUAN	15	3	Open order credit quantity (schedule lines)
70	OEIKW	☐	MC_OEIKW_F	FLTP	FLTP	16	16	Open sales order credit value (schedule lines)
71	OEIKWGES	☐	MC_OEIKWGF	FLTP	FLTP	16	16	Total open orders credit value (w/o guarantee) - sched. line
72	OEIKWAA	☐	MC_OEIKWAF	FLTP	FLTP	16	16	Guaranteed open order value (schedule lines)
73	OLFMNG	☐	OLFMNG	MENG13	QUAN	13	3	Open quantity to be delivered (in sales unit)
74	WLDATBE	☐	WLDATBE	DATUM	DATS	8	0	Desired del. date in confirmed schedule lines
75	ERDATA	☐	ERDATA	DATUM	DATS	8	0	Date on which the release order was added
76	AEDATA	☐	AEDATA	DATUM	DATS	8	0	Date on which the release order was last changed
77	.INCLUDE	☐				0	0	User Structure: Sales Document - Purchasing Data
78	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
79	VSMNG	☐	VSMNG	MENG13	QUAN	13	3	Delivered quantity in sales units
80	SWMENG	☐	SWMENG	MENG15	QUAN	15	3	Cumulated order qty (SIS component supplier) in sales unit
81	OFAMNG	☐	MC_OLIME	MENGV15_3	QUAN	15	3	Open delivery quantity

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCVBEPB	AUFNR	AUFK	AUFNR
2	MCVBEPB	AULWE	VALW	AULWE
3	MCVBEPB	BNFPO	EBAN	BNFPO
4	MCVBEPB	BSART	T161	BSART
5	MCVBEPB	BWART	T156	BWART
6	MCVBEPB	ETART	TVET	ETART	REF	C	CN
7	MCVBEPB	ETENE	VBEP	ETENR
8	MCVBEPB	ETTYP	TVEP	ETTYP
9	MCVBEPB	LIFSP	TVLS	LIFSP
10	MCVBEPB	MANDT	T000	MANDT
11	MCVBEPB	MEINS	T006	MSEHI
12	MCVBEPB	PLNUM	PLAF	PLNUM
13	MCVBEPB	POSNE	VBUP	POSNR
14	MCVBEPB	POSNR	VBUP	POSNR
15	MCVBEPB	ROMEI	T006	MSEHI
16	MCVBEPB	SERNR	SNUM	SERNR	REF	C	CN
17	MCVBEPB	VBELE	VBUK	VBELN
18	MCVBEPB	VBELN	VBUK	VBELN
19	MCVBEPB	VRKME	T006	MSEHI

History

Last changed by/on	SAP	20131127
SAP Release Created in