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









MFAUF 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 MFAUF table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
View reference: NSDM_V_MFAUF
DDL Object: NSDM_DDL_MFAUF


MFAUF data in SAP S/4 Hana is actually from NSDM_E_MARC

MFAUF table is actually just a a DDL object CDS view which selects the data from NSDM_E_MARC and presents it as if the table exists. Clever really as this means all ABAP code that performs a select on this table will actually work as if this isna traditional table in SAP.


NSDM_E_MARC used for fields of table MFAUF

The data and therefore the actual field list comes from the ddl cds view and are mapped from the source hana table to match the legacy ECC SAP MFAUF Table. Below is the CDS code that builds this table view

MFAUF table structure field list

Also Below is the traditional view of MFAUF field list that makes up the SAP database table structure as you would see it within SE11, including highlighted 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
MATNRMaterial NumberMATNRCHAR40(0) MATN1MATNRMATS_MAT1MATNR
WERKSPlantWERKS_DCHAR4(0) T001WWERKSWRKH_T001W_CWERKS
MTARTMaterial typeMTARTCHAR4(0) T134MTARTMTA
MATKLMaterial GroupMATKLCHAR9(0) T023MATKLMKLS_WBWGMATKL
MEINSBase Unit of MeasureMEINSUNIT3(0) T006CUNITMEINS
FERTHProduction/inspection memoFERTHCHAR18(0) FERTH
FORMTPage Format of Production MemoFORMTCHAR4(0) DINFO
DISSTLow-Level CodeDISSTCHAR3(0) DISST
SPARTDivisionSPARTCHAR2(0) TSPASPARTSPAC_SPARTSPART
KZREVRevision Level Has Been Assigned to the MaterialKZREVCHAR1(0) XFELD
KZKFGConfigurable MaterialKZKFGCHAR1(0) XFELD
MBRSHIndustry SectorMBRSHCHAR1(0) T137MBRSHMTP
VPSTAMaintenance status of complete materialVPSTACHAR15(0) PSTAT
BWTTYValuation CategoryBWTTY_DCHAR1(0) T149CBWTTY
XCHARBatch management indicator (internal)XCHARCHAR1(0) XFELD
MMSTAPlant-Specific Material StatusMMSTACHAR2(0) T141MMSTA
MMSTDDate from Which the Plant-Specific Material Status Is ValidMMSTDDATS8(0) DATUM
EKGRPPurchasing GroupEKGRPCHAR3(0) T024EKGRPEKG
AUSMEUnit of issueAUSMEUNIT3(0) T006CUNITMEINS
DISMMMRP TypeDISMMCHAR2(0) T438ADISMM
DISPOMRP ControllerDISPOCHAR3(0) T024DDISPODGRHS_T024DDISPO
PLIFZPlanned Delivery Time in DaysPLIFZDEC3(0) DEC3
WEBAZGoods receipt processing time in daysWEBAZDEC3(0) DEC3
AUSSSAssembly scrap in percentAUSSSDEC5(2) DEC3_2
BESKZProcurement TypeBESKZCHAR1(0) BESKZMBS
SOBSLSpecial procurement typeSOBSLCHAR2(0) T460ASOBSL
EISBESafety stockEISBEQUAN13(3) MENG13
BSTFEFixed lot sizeBSTFEQUAN13(3) MENG13
BSTRFRounding value for purchase order quantityBSTRFQUAN13(3) MENG13
SBDKZDependent requirements ind. for individual and coll. reqmtsSBDKZCHAR1(0) SBDKZ
ALTSLMethod for Selecting Alternative Bills of MaterialALTSLCHAR1(0) ALTSL
KZAUSDiscontinuation indicatorKZAUSCHAR1(0) KZAUS
AUSDTEffective-Out DateAUSDTDATS8(0) DATUM
NFMATFollow-Up MaterialNFMATCHAR40(0) MARAMATN1MATNRMAT
KZBEDIndicator for Requirements GroupingKZBEDCHAR1(0) KZBED
MISKZMixed MRP indicatorMISKZCHAR1(0) MISKZ
FHORIScheduling Margin Key for FloatsFHORICHAR3(0) T436AFHORI
FFREIRelease indicator for production ordersFFREICHAR1(0) XFELD
RGEKZIndicator: BackflushRGEKMCHAR1(0) RGEKM
FEVORProduction SupervisorFEVORCHAR3(0) T024FFEVORCFV
BEARZProcessing timeBEARZDEC5(2) DEC3_2
RUEZTSetup and teardown timeRUEZTDEC5(2) DEC3_2
TRANZInteroperation timeTRANZDEC5(2) DEC3_2
BASMGBase quantityBASMGQUAN13(3) MENG13
DZEITIn-house production timeDZEITDEC3(0) DEC3
KZPROIndicator: withdrawal of stock from production binKZPROCHAR1(0) XFELD
UEETOOverdelivery tolerance limitUEETODEC3(1) DEC2_1
UEETKIndicator: Unlimited Overdelivery AllowedUEETKCHAR1(0) XFELD
UNETOUnderdelivery tolerance limitUNETODEC3(1) DEC2_1
WZEITTotal replenishment lead time (in workdays)WZEITDEC3(0) DEC3
INSMKPost to Inspection StockINSMK_MATCHAR1(0) QKZ
KZDKZDocumentation required indicatorKZDKZCHAR1(0) XFELD
UMLMCStock in transfer (plant to plant)UMLMEQUAN13(3) MENG13V
XCHPFBatch Management Requirement Indicator for PlantXCHPF_WERKSCHAR1(0) XFELD
USEQUQuota arrangement usageUSEQUCHAR1(0) TMQ2USEQU
MTVFPChecking Group for Availability CheckMTVFPCHAR2(0) TMVFMTVFP
PRCTRProfit CenterPRCTRCHAR10(0) ALPHAPRCTRPRCPRCTR_EMPTYPRCTR
SAUFTIndicator: Repetitive Manufacturing AllowedSA_SAUFTCHAR1(0) XFELD
VERKZVersion IndicatorCK_VERK1CHAR1(0) XFELD
FRTMEProduction unitFRTMEUNIT3(0) T006CUNITMEINS
LGPROIssue Storage LocationLGPROCHAR4(0) T001LLGORT
AWSLSVariance KeyAWSLSCHAR6(0) TKV01AWSLS
CUOBJInternal object numberCUOBMNUMC18(0) CUOBJ
SFEPRRepetitive Manufacturing ProfileSFEPRCHAR4(0) T437SSFEPR
LVORMFlag Material for Deletion at Plant LevelLVOWKCHAR1(0) XFELD
KAUSFComponent Scrap in PercentKAUSFDEC5(2) DEC3_2
STDPDConfigurable materialSTDPDCHAR40(0) MARAMATN1MATNR
SOBSKSpecial Procurement Type for CostingCK_SOBSLCHAR2(0) T460ASOBSL
PSTATMaintenance statusPSTAT_DCHAR15(0) PSTAT
SCHGTIndicator: bulk materialSCHGTCHAR1(0) XFELD
DISGRMRP GroupDISGRCHAR4(0) T438MDISGR
SFCPFProduction Scheduling ProfileCO_PRODPRFCHAR6(0) TCO43CO_PRODPRF
EPRIOStock determination groupBF_GROUPCHAR4(0) T434GBF_GROUP
KZECHDetermination of batch entry in the production/process orderKZECHCHAR1(0) KZECH
SERNPSerial Number ProfileSERAILCHAR4(0) T377PSERAIL
QMATVInspection Setup Exists for Material/PlantQMATVCHAR1(0) XFELD
STRGRPlanning Strategy GroupSTRGRCHAR2(0) T461PSTRGR
CUOBFInternal object numberCUOBMNUMC18(0) CUOBJ
SERLVLevel of Explicitness for Serial NumberSERLVCHAR1(0) SERLV
KZWSMUnits of measure usageKZWSOCHAR1(0) KZWSO
MSTAECross-Plant Material StatusMSTAECHAR2(0) T141MMSTAH_T141MMSTA
FXPRUFixed-Price Co-ProductCK_FIXPRKUCHAR1(0) XFELD
OCMPFOverall profile for order change managementOCM_GPROFILECHAR6(0) TCO48CHAR6
VSPVBProposed Supply Area in Material Master RecordVSPVBCHAR10(0) PVBEPRVBE
KZEFFAssign effectivity parameter values/ override change numbersCC_MTEFFCHAR1(0) XFELD
UCHKZIndicator for Original Batch ManagementUCHKZCHAR1(0) UCHKZ
HKMATMaterial-related originHKMATCHAR1(0) HKMAT
SGT_RELSegmentation RelevantSGT_RELCHAR1(0) CHAR1
SGT_COVSSegmentation StrategySGT_COVSCHAR8(0) SGT_COVS_TSGT_COVSSGT_ESGT_COVS_SHLPSGT_COVS
SGT_STATCSegmentation StatusSGT_STATCCHAR1(0) SGT_STAT
SGT_SCOPESegmentation Strategy ScopeSGT_SCOPECHAR1(0) SGT_SCOPE
ATTYPMaterial CategoryATTYPCHAR2(0) ATTYPMTY




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!