SAP ABAP Table MDFA (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	AFPO
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	AFTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
5	AFART	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
6	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
7	STATF	☐	CO_FREI	CHAR1	CHAR	1	0	Indicator: Order released/partially released (for MRP)
8	DNREL	☐	CO_DNREL	CHAR1	CHAR	1	0	Indicator: Order item not relevant for MRP
9	MATNR	☐	CO_MATNR	MATNR	CHAR	18	0	Material Number for Order	MARA
10	PLWRK	☐	CO_PWERK	WERKS	CHAR	4	0	Planning plant for the order	T001W
11	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
12	PWWRK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
14	SOBES	☐	SOBES	SOBES	CHAR	1	0	Special procurement type
15	GSMNG	☐	CO_PSMNG	MENG13	QUAN	13	3	Order item quantity
16	WEMNG	☐	CO_WEMNG	MENG13	QUAN	13	3	Quantity of goods received for the order item
17	PAMNG	☐	CO_PSAMG	MENG13	QUAN	13	3	Scrap quantity in item
18	IAMNG	☐	CO_IAMNG	MENG13V	QUAN	13	3	Expected surplus/deficit for goods receipt
19	AMEIN	☐	CO_AUFME	MEINS	UNIT	3	0	Unit of measure for in-house production	T006
20	MEINS	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
22	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
23	PEDTR	☐	CO_GLTRP	DATUM	DATS	8	0	Basic finish date
24	SEDTR	☐	CO_GLTRS	DATUM	DATS	8	0	Scheduled finish
25	WEBAZ	☐	PLWEZ	DEC3	DEC	3	0	Goods receipt processing time in days
26	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
27	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
28	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
29	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
30	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
31	KDAUF	☐	CO_KDAUF	VBELN	CHAR	10	0	Sales order number	VBUK
32	KDPOS	☐	CO_KDPOS	POSNR	NUMC	6	0	Sales order item	VBUP
33	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
34	PSPEL	☐	PS_PSP_ELE	PS_POSNR	NUMC	8	0	Work breakdown structure element (WBS element)	PRPS
35	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
36	SAFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number
37	VERID	☐	VERID	VERID	CHAR	4	0	Production Version
38	VERTO	☐	SA_VERTL	SA_VERTL	CHAR	4	0	MRP Distribution Key	T437V
39	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
40	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
41	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
42	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
43	NDISR	☐	CO_NDISR	CHAR1	CHAR	1	0	Ind.: Material in order item is not relevant for MRP
44	VFMNG	☐	CO_VFMNG	MENG13	QUAN	13	3	Committed quantity for order acc. to ATP check components
45	GSBTR	☐	CO_GSBTR	DATUM	DATS	8	0	Overall commitment date
46	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
47	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
48	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
49	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
50	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area
51	KRSNR	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
52	KRSPS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
53	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDFA	AFART	T003O	AUART	REF	1	CN
2	MDFA	AMEIN	T006	MSEHI	REF	C	CN
3	MDFA	AUFNR	AUFK	AUFNR	KEY	1	N
4	MDFA	BWTAR	T149D	BWTAR	REF	C	CN
5	MDFA	CHARG	MCHA	CHARG	REF	C	CN
6	MDFA	KDAUF	VBUK	VBELN
7	MDFA	KDPOS	VBUP	POSNR
8	MDFA	KNTTP	T163K	KNTTP	KEY	1	CN
9	MDFA	LGORT	T001L	LGORT	REF	C	CN
10	MDFA	MANDT	T000	MANDT	KEY	1	CN
11	MDFA	MATNR	MARA	MATNR	REF	1	CN
12	MDFA	MEINS	T006	MSEHI	KEY	1	CN
13	MDFA	PLWRK	T001W	WERKS	REF	C	CN
14	MDFA	PSPEL	PRPS	PSPNR	REF	C	CN
15	MDFA	PWWRK	T001W	WERKS	REF	1	CN
16	MDFA	SERNR	SNUM	SERNR
17	MDFA	SOBKZ	T148	SOBKZ	REF	C	CN
18	MDFA	VERTO	T437V	VERTL	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in