MGV_ROWA SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from MGV_ROWA
Related tables to MGV_ROWA
Access table MGV_ROWA




Table View field list including key, data, relationships and ABAP select examples

MGV_ROWA is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The MGV_ROWA table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include MBLNR (Number of Material Document), MJAHR (Material Document Year), ZEILE (Item in Material Document), STATUS (Status for ROWA entry).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP MGV_ROWA table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3MANDT
MBLNRNumber of Material Document MBLNRCHAR10MKPFALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4MKPFGJAHRGJAHRMJA
ZEILEItem in Material Document MBLPONUMC4MSEGMBLPOPOS
STATUSStatus for ROWA entry MO_ROWASTNUMC2NUM02
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
SOBKZSpecial Stock Indicator SOBKZCHAR1SOBKZ
LIFNRVendor Account Number ELIFNCHAR10ALPHALIFNRLIFKRED_C
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4GSBERGSB
BWAERCurrency Key WAERSCUKY5WAERSFWS
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
BSTMEPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
BSTMGPurchase Order Quantity BSTMGQUAN13(3) MENG13
HKONTGeneral Ledger Account HKONTCHAR10ALPHASAKNR
MWSKZTax on sales/purchases code MWSKZCHAR2MWSKZ
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEIDocument Item in Invoice Document RBLGPNUMC6NUMC6
NAVNWNon-deductible input tax NAVNWCURR13(2) WERT7
PRCTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
BWARTMovement Type (Inventory Management) BWARTCHAR3BWARTBWA
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3CUNITMEINS
WAERSCurrency Key WAERSCUKY5WAERSFWS
EBELNPurchasing Document Number EBELNCHAR10ALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EBELPBSP
BKLASValuation Class BKLASCHAR4BKLAS
CKONTGeneral Ledger Account HKONTCHAR10ALPHASAKNR
ABWHKAlternative G/L Account ABWHKCHAR10ALPHASAKNR
PREISNet Price in Purchasing Info Record IPREICURR11(2) WERT11
PEINHPrice Unit EPEINDEC5DEC5
CCBTRAmount in document currency WRBTRCURR13(2) WERT7
VGARTTransaction/Event Type VGARTCHAR2VGART
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
EMLIFVendor to be supplied/who is to receive delivery EMLIFCHAR10ALPHALIFNR
VBELNBilling Document VBELN_VFCHAR10ALPHAVBELNVF
POSNRBilling item POSNR_VFNUMC6POSNR
MVCTGOBEW Movement Category MVCTGCHAR1MVCTG
MATNR_INTMaterial Number MATNR_INTCHAR18MATN1MATNR_INTMATMAT1
MATNR_EXTExternal Long Material Number MATNR_EXTCHAR40MATNLMATNR_EXT
MATNR_VERSMaterial Version Number MATNR_VERSCHAR10MATNWMATNR_VERSMATVERS

Key field Non-key field



How do I retrieve data from SAP table MGV_ROWA using ABAP code

The following ABAP code Example will allow you to do a basic selection on MGV_ROWA to SELECT all data from the table
DATA: WA_MGV_ROWA TYPE MGV_ROWA.

SELECT SINGLE *
FROM MGV_ROWA
INTO CORRESPONDING FIELDS OF WA_MGV_ROWA
WHERE...

How to access SAP table MGV_ROWA

Within an ECC or HANA version of SAP you can also view further information about MGV_ROWA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


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!