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









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

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


MDSA table structure field list

Below is the full MDSA 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
AUFNRRun schedule header numberSA_AUFNRCHAR12(0) Assigned to domainALPHASA_AUFNR
MATNRMaterial numberSA_MATNRCHAR40(0) MARAMATN1MATNR
WERKSPlantWERKS_DCHAR4(0) T001WWERKSWRKH_T001W_CWERKS
VERIDProduction VersionVERIDCHAR4(0) MKALVERIDVER
PHAS0Indicator for blocking run schedule headerSA_PHAS0CHAR1(0) XFELD
BSTMIMinimum Lot Size QuantitySA_LOSVNQUAN13(3) MENG13
BSTMAMaterial Maximum Lot Size QuantitySA_LOSBSQUAN13(3) MENG13
STDAYStart of the validity period of the RS headerSTDAYDATS8(0) DATUM
ENDAYEnd of validity period of the RS headerENDAYDATS8(0) DATUM
VERTODistribution key for quantity producedSA_VERTOCHAR4(0) T437VSA_VERTL
STLALAlternative BOMSTALTCHAR2(0) ALPHAALTNR
STLANBOM UsageSTLANCHAR1(0) T416STLANCSV
PLNTYTask List TypePLNTYCHAR1(0) TCA01PLNTYPTYH_TCA01PLNTY
PLNNRKey for Task List GroupPLNNRCHAR8(0) ALPHAPLNNRPLNPLKSPLNNR
APLALGroup CounterPLNALCHAR2(0) ALPHAALTNRPAL




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!