SAP ABAP Table MDVL (Planning file entry for long-term planning)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD (Package) Application development R/3 requirements planning

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MDVL	Table Relationship Diagram
Short Description	Planning file entry for long-term planning

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MAFID	☑	MAFID	MAFID	CHAR	1	0	Record type
3	PLSCN	☑	PLSCN	PLSCN	NUMC	3	0	Planning Scenario of Long-Term Planning	PLSC
4	MDKEY	☑	MDKEY	MDKEY	CHAR	25	0	Total key of MDVM
5	GSAEN	☐	GSAEN	XFELD	CHAR	1	0	Net change planning indicator
6	AKKEN	☐	AKKEN	XFELD	CHAR	1	0	Net change planning indicator in the planning horizon
7	RESDT	☐	RESDT	XFELD	CHAR	1	0	Reset procurement proposals
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	RESAL	☐	RESAL	XFELD	CHAR	1	0	Re-explode BOM
10	MPSKZ	☐	MPSKZ	XFELD	CHAR	1	0	Indicator for MPS items
11	RHYTD	☐	RHYTD	DATUM	DATS	8	0	Date for planning (e.g. as per time-phased mat. planning)
12	USTMP	☐	USTMP	TZNTSTMPS	DEC	15	0	Time stamp of last update for planning file entry
13	DSTMP	☐	DSTMP	TZNTSTMPS	DEC	15	0	Timestamp of last MRP for planning file entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDVL	MANDT	T000	MANDT
2	MDVL	PLSCN	PLSC	PLSCN

History

Last changed by/on	SAP	20050411
SAP Release Created in