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

History

Last changed by/on	SAP	20131127
SAP Release Created in