SAP table MDFA (Generated Table for View)

SAP table MDFA has 3 primary key fields being MANDT,AUFNR,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
POSNR Order item number NUMC 4 0 CO_POSNR
AFTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
AFART Order Type CHAR 4 0 T003O AUFART
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
STATF Indicator: Order released/partially released (for MRP) CHAR 1 0 CO_FREI
DNREL Indicator: Order Item is not Relevant for MRP CHAR 1 0 CO_DNREL
MATNR Material Number for Order CHAR 40 0 MARA CO_MATNR
PLWRK Planning Plant for an Order CHAR 4 0 T001W CO_PWERK
LGORT Storage location CHAR 4 0 T001L LGORT_D
PWWRK Plant CHAR 4 0 T001W WERKS_D
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
SOBES Special procurement type CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
GSMNG Order Item Planned Total Quantity QUAN 13 3 CO_PSMNG
WEMNG Quantity of Goods Received for the Order Item QUAN 13 3 CO_WEMNG
PAMNG Order Item Planned Scrap Quantity QUAN 13 3 CO_PSAMG
IAMNG Expected Surplus/Deficit For Goods Receipt QUAN 13 3 CO_IAMNG
AMEIN Unit of measure for in-house production UNIT 3 0 T006 CO_AUFME
MEINS Base Unit of Measure UNIT 3 0 T006 LAGME
UMREZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
UMREN Denominator for conversion to base units of measure DEC 5 0 UMREN
PEDTR Basic finish date DATS 8 0 CO_GLTRP
SEDTR Scheduled finish DATS 8 0 CO_GLTRS
WEBAZ Goods Receipt Processing Duration in Days DEC 3 0 PLWEZ
SERNR BOM explosion number CHAR 8 0 SNUM SERNR
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
KDAUF Sales Order CHAR 10 0 VBAK CO_KDAUF
KDPOS Sales Order Item NUMC 6 0 VBAP CO_KDPOS
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
PSPEL Work breakdown structure element (WBS element) NUMC 8 0 PRPS PS_PSP_ELE
WEPOS Goods Receipt Indicator CHAR 1 0 WEPOS
SAFNR Run schedule header number CHAR 12 0 SA_AUFNR
VERID Production Version CHAR 4 0 VERID
VERTO MRP Distribution Key CHAR 4 0 T437V SA_VERTL
QUNUM Number of quota arrangement CHAR 10 0 QUNUM
QUPOS Quota arrangement item NUMC 3 0 QUPOS
ARSNR Settlement reservation number NUMC 10 0 ARSNR
ARSPS Item number of the settlement reservation NUMC 4 0 ARSPS
NDISR Ind.: Material in order item is not relevant for MRP CHAR 1 0 CO_NDISR
VFMNG Committed quantity for order acc. to ATP check components QUAN 13 3 CO_VFMNG
GSBTR Total Commitment Date DATS 8 0 CO_GSBTR
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
BERID MRP Area CHAR 10 0 BERID
KRSNR Number of reservation/dependent requirements NUMC 10 0 RSNUM
KRSPS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
INSMK Stock Type CHAR 1 0 INSMK
Unrestricted use
S Blocked stock
X Quality inspection
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT

MDFA foreign key relationships

Table Field Check Table Check Field
0 MDFA AFART T003O Order Types AUART
1 MDFA AMEIN T006 Units of Measurement MANDT
1 MDFA AMEIN T006 Units of Measurement MSEHI
0 MDFA AUFNR AUFK Order master data AUFNR
1 MDFA BWTAR T149D Global Valuation Types MANDT
1 MDFA BWTAR T149D Global Valuation Types BWTAR
0 MDFA CHARG MCHA Batches MANDT
0 MDFA CHARG MCHA Batches WERKS
0 MDFA CHARG MCHA Batches CHARG
1 MDFA KDAUF VBAK Sales Document: Header Data MANDT
1 MDFA KDAUF VBAK Sales Document: Header Data VBELN
0 MDFA KDPOS VBAP Sales Document: Item Data VBELN
0 MDFA KDPOS VBAP Sales Document: Item Data POSNR
1 MDFA KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
1 MDFA KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
0 MDFA LGORT T001L Storage Locations MANDT
0 MDFA LGORT T001L Storage Locations WERKS
1 MDFA MANDT T000 Clients MANDT
0 MDFA MATNR MARA General Material Data MANDT
0 MDFA MATNR MARA General Material Data MATNR
1 MDFA MEINS T006 Units of Measurement MANDT
1 MDFA MEINS T006 Units of Measurement MSEHI
0 MDFA PLWRK T001W Plants/Branches WERKS
1 MDFA PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 MDFA PSPEL PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 MDFA PWWRK T001W Plants/Branches WERKS
1 MDFA SERNR SNUM BOM explosion number MANDT
0 MDFA SOBKZ T148 Special Stock Indicator MANDT
0 MDFA SOBKZ T148 Special Stock Indicator SOBKZ
1 MDFA VERTO T437V Distribution key in MRP MANDT
1 MDFA VERTO T437V Distribution key in MRP WERKS