SAP ABAP Table MDKS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDKS	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	AUFNR	☑	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
3	POSNR	☑	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
4	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
5	SAFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number
6	VERID	☐	VERID	VERID	CHAR	4	0	Production Version
7	DWERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	DAUTY	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
10	RTP01	☐	RTP01	XFELD	CHAR	1	0	Cost collector for repetitive manufacturing
11	RTP02	☐	RTP02	XFELD	CHAR	1	0	Cost collector for KANBAN
12	RTP03	☐	RTP03	XFELD	CHAR	1	0	Cost collector for valuated sales order stock
13	KSVON	☐	KSVON	DATUM	DATS	8	0	Cost collector valid from
14	KSBIS	☐	KSBIS	DATUM	DATS	8	0	Cost collector valid to
15	AUART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
16	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
17	LOEKZ	☐	AUFLOEKZ	XFELD	CHAR	1	0	Deletion flag
18	KALSM	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet
19	ZSCHL	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
20	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
21	ABGSL	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	TKKAA
22	KLVARP	☐	KALKVARPLN	KLVAR	CHAR	4	0	Costing variant for planned costs
23	KLVARI	☐	KALKVARIST	KLVAR	CHAR	4	0	Costing variant for actual costs
24	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	PROCNR	☐	CKML_F_PROCNR	CK_KALNR	NUMC	12	0	Production Process

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDKS	ABGSL	TKKAA	ABGSL	REF	C	CN
2	MDKS	AUART	T003O	AUART	REF	1	CN
3	MDKS	AUFNR	AUFK	AUFNR	KEY	1	N
4	MDKS	AWSLS	TKV01	AWSLS	REF	C	CN
5	MDKS	DWERK	T001W	WERKS	REF	1	CN
6	MDKS	GSBER	TGSB	GSBER	REF	1	CN
7	MDKS	MANDT	T000	MANDT	KEY	1	CN
8	MDKS	MATNR	MARA	MATNR	REF	1	CN
9	MDKS	OBJNR	ONR00	OBJNR	REF	1	1
10	MDKS	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in