SAP ABAP Table PPMRP_SOL_CARD (Solution View Card - OData MRP Cockpit)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP (Application Component) Production Planning and Control
     ⤷ ODATA_PP_MRP (Package) OData Services for MRP/MRP Cockpit

Basic Data

Table Category	INTTAB	Structure
Structure	PPMRP_SOL_CARD	Table Relationship Diagram
Short Description	Solution View Card - OData MRP Cockpit

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	INDEX	☐	SYST_INDEX	SYST_LONG	INT4	10	0	ABAP System Field: Loop Index
2	ORDERID	☐	DEL12	DEL12	CHAR	12	0	MRP element number
3	ORDERITEMID	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
4	ORDERSCHEDULELINEID	☐	DELET	DELET	NUMC	4	0	Scheduling number planning element
5	ORDERID_EXT	☐	DEL12	DEL12	CHAR	12	0	MRP element number
6	ORDERITEMID_EXT	☐	PPMRP_ELEMITEM_EXT		CHAR	5	0	MRP Element Item (External)
7	ORDERSCHEDULELINEID_EXT	☐	PPMRP_ELEMLINE_EXT		CHAR	4	0	MRP Element Schedule Line (External)
8	SOLUTION_TYPE	☐	PPMRP_SOLUTION_TYPE	PPMRP_SOLUTION_TYPE	CHAR	2	0	Solution Card: Solution Type
9	MRPPLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
10	MRPAREA	☐	BERID	BERID	CHAR	10	0	MRP Area	*
11	MRPPLANNINGSEGMENTTYPE	☐	PLAAB	PLAAB	NUMC	2	0	Material requirements planning segment
12	MRPPLANNINGSEGMENTNUMBER	☐	PLANR	PLANR	CHAR	20	0	Planning segment number
13	MATERIALSHORTAGEPROFILE	☐	MATERIALSHORTAGEPROFILE	SDM_PROFILE	CHAR	12	0	Material Shortage Profile
14	MATERIALSHORTAGEPROFILECOUNT	☐	SDM_COUNTER	NUMC3	NUMC	3	0	Counter for SDM customizing settings
15	MRPELEMENTCATEGORY	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
16	MRPELEMENTCATEGORYSHORTNAME	☐	DELB0	DELB0	CHAR	6	0	Abbreviation for MRP element
17	MRPELEMENTORDERTYPE	☐	DELKZ	DELKZ	CHAR	2	0	MRP element
18	MATERIALID	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
19	MATERIALGROUPNAME	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
20	MATERIALSHORTAGESTARTDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
21	MATERIALSHORTAGEENDDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
22	MATERIALSHORTAGEQUANTITY	☐	MATERIALSHORTAGEQUANTITY	MENG13	QUAN	13	3	Shortage Quantity at First Shortage Date
23	MATERIALBASEUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
24	MATERIALBASEUNITSHORT	☐	MSEH6	MSEH6	CHAR	6	0	External Unit of Measurement in Technical Format (6-Char.)
25	PRECISION	☐	PPMRP_PRECISION		INT1	3	0	Number of Decimals
26	VENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
27	VENDORNAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
28	VENDORPLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
29	MRPELEMENTAVORRQMTDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
30	MRPELEMENTCHANGEDAVORRQMTDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
31	MRPELEMENTOPENQUANTITY	☐	MNG01	MENGV13	QUAN	13	3	Quantity received or quantity required
32	MRPELEMENTCHANGEDOPENQUANTITY	☐	MNG01	MENGV13	QUAN	13	3	Quantity received or quantity required
33	MRPELEMENTQUANTITYISFIRM	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
34	MRPELEMENTDELIVERYDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
35	MRPELEMENTCHANGEDDELIVERYDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
36	CHANGESTATEID	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
37	MRPAVAILABILITYDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
38	PROPOSALRANKING	☐			CHAR	1	0
39	CONTACTNAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
40	CONTACTMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
41	CONTACTPHONE	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
42	PURCHASEORDERTYPE	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
43	PURCHASINGORGANIZATION	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
44	PURCHASINGGROUP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	*
45	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
46	PURCHASINGDOCUMENTCATEGORY	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
47	ACCTASSIGNMENTCATEGORY	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
48	SALESORDER	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
49	SALESORDERITEM	☐	VBELP	POSNR	NUMC	6	0	Sales document item	*
50	RECEIVINGPLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
51	SUPPLYINGSTORAGELOCATION	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
52	RECEIVINGSTORAGELOCATION	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
53	PURCHASINGINFORECORD	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
54	PURCHASECONTRACT	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
55	PURCHASECONTRACTITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
56	MATERIALGOODSRECEIPTDURATION	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
57	COMMENT	☐			STRG	0	0
58	SOLUTION_OPTION	☐	MRPREQUESTSTATUS	MRPREQUESTSTATUS	CHAR	2	0	Status of MRP Request
59	RELEASED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
60	PARTIALLYDELIVERED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
61	REQUESTSTATUS	☐			CHAR	2	0
62	MATERIALPROCUREMENTTYPE	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
63	.INCLUDE	☐				0	0	Dummy Field for Solution View Card - OData MRP Cockpit
64	DUMMY_MRP_SOL_CARD	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20140121
SAP Release Created in	618