SAP MDFA Table in S/4 HANA - Generated Table for View









MDFA is a standard SAP Table which is used to store Generated Table for View data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MDFA table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: MDFA


MDFA table structure field list

Below is the full MDFA field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) T000MANDT
AUFNROrder NumberAUFNRCHAR12(0) AUFKALPHAAUFNRANR
POSNROrder item numberCO_POSNRNUMC4(0) CO_POSNR
AFTYPOrder categoryAUFTYPNUMC2(0) AUFTYP
AFARTOrder TypeAUFARTCHAR4(0) T003OAUFARTAAT
ELIKZ'Delivery Completed' IndicatorELIKZCHAR1(0) XFELD
STATFIndicator: Order released/partially released (for MRP)CO_FREICHAR1(0) CHAR1
DNRELIndicator: Order Item is not Relevant for MRPCO_DNRELCHAR1(0) CHAR1
MATNRMaterial Number for OrderCO_MATNRCHAR40(0) MARAMATN1MATNRMAT
PLWRKPlanning Plant for an OrderCO_PWERKCHAR4(0) T001WWERKS
LGORTStorage locationLGORT_DCHAR4(0) T001LLGORTLAG
PWWRKPlantWERKS_DCHAR4(0) T001WWERKSWRKH_T001W_CWERKS
BESKZProcurement TypeBESKZCHAR1(0) BESKZMBS
SOBESSpecial procurement typeSOBESCHAR1(0) SOBES
GSMNGOrder Item Planned Total QuantityCO_PSMNGQUAN13(3) MENG13
WEMNGQuantity of Goods Received for the Order ItemCO_WEMNGQUAN13(3) MENG13
PAMNGOrder Item Planned Scrap QuantityCO_PSAMGQUAN13(3) MENG13
IAMNGExpected Surplus/Deficit For Goods ReceiptCO_IAMNGQUAN13(3) MENG13V
AMEINUnit of measure for in-house productionCO_AUFMEUNIT3(0) T006CUNITMEINS
MEINSBase Unit of MeasureLAGMEUNIT3(0) T006CUNITMEINS
UMREZNumerator for Conversion to Base Units of MeasureUMREZDEC5(0) UMBSZ
UMRENDenominator for conversion to base units of measureUMRENDEC5(0) UMBSN
PEDTRBasic finish dateCO_GLTRPDATS8(0) DATUM
SEDTRScheduled finishCO_GLTRSDATS8(0) DATUM
WEBAZGoods Receipt Processing Duration in DaysPLWEZDEC3(0) DEC3
SERNRBOM explosion numberSERNRCHAR8(0) SNUMSERNR
CUOBJConfiguration (internal object number)CUOBJNUMC18(0) CUOBJCUX
KNTTPAccount Assignment CategoryKNTTPCHAR1(0) T163KKNTTPKNT
SOBKZSpecial Stock IndicatorSOBKZCHAR1(0) T148SOBKZ
KZVBRConsumption postingKZVBRCHAR1(0) KZVBR
KDAUFSales OrderCO_KDAUFCHAR10(0) VBAKALPHAVBELNAUN
KDPOSSales Order ItemCO_KDPOSNUMC6(0) VBAPPOSNRAUP
KDEINDelivery schedule for sales orderKDEINNUMC4(0) NUM04
PSPELWork breakdown structure element (WBS element)PS_PSP_ELENUMC8(0) PRPSKONPRPS_POSNR
WEPOSGoods Receipt IndicatorWEPOSCHAR1(0) XFELD
SAFNRRun schedule header numberSA_AUFNRCHAR12(0) ALPHASA_AUFNR
VERIDProduction VersionVERIDCHAR4(0) VERIDVER
VERTOMRP Distribution KeySA_VERTLCHAR4(0) T437VSA_VERTL
QUNUMNumber of quota arrangementQUNUMCHAR10(0) ALPHAQUNUM
QUPOSQuota arrangement itemQUPOSNUMC3(0) NUM03
ARSNRSettlement reservation numberARSNRNUMC10(0) MDNUM
ARSPSItem number of the settlement reservationARSPSNUMC4(0) RSPOS
NDISRInd.: Material in order item is not relevant for MRPCO_NDISRCHAR1(0) CHAR1
VFMNGCommitted quantity for order acc. to ATP check componentsCO_VFMNGQUAN13(3) MENG13
GSBTRTotal Commitment DateCO_GSBTRDATS8(0) DATUM
CHARGBatch NumberCHARG_DCHAR10(0) MCHACHARGCHA
BWTARValuation TypeBWTAR_DCHAR10(0) T149DBWTARBWT
UNTTOUnderdelivery ToleranceUNTTODEC3(1) PRZ21
TECHSParameter Variant/Standard VariantTECHSCHAR12(0) TECHS
BERIDMRP AreaBERIDCHAR10(0) BERIDBERID
KRSNRNumber of reservation/dependent requirementsRSNUMNUMC10(0) RSNUMRES
KRSPSItem Number of Reservation / Dependent RequirementsRSPOSNUMC4(0) RSPOSRPO
INSMKStock TypeINSMKCHAR1(0) INSMK
SGT_SCATStock SegmentSGT_SCATCHAR40(0) SGT_SRCASGT_SSGT_CAT_FIELD_POPUPVALUE




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!