SAP table ROWA (Index table : Chargeable component consumptions)

SAP table ROWA has 4 primary key fields being MANDT,MBLNR,MJAHR,ZEILE.

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 * MANDT
MBLNR Number of Material Document CHAR 10 0 MKPF MBLNR
MJAHR Material Document Year NUMC 4 0 MKPF MJAHR
ZEILE Item in Material Document NUMC 4 0 MSEG MBLPO
STATUS Status for ROWA entry NUMC 2 0 MO_ROWAST
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BUKRS Company Code CHAR 4 0 BUKRS
SOBKZ Special Stock Indicator CHAR 1 0 * SOBKZ
LIFNR Vendor's account number CHAR 10 0 ELIFN
WERKS Plant CHAR 4 0 WERKS_D
MATNR Material Number CHAR 40 0 MATNR
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
GSBER Business Area CHAR 4 0 * GSBER
BWAER Currency Key CUKY 5 0 * WAERS
WRBTR Amount in Document Currency CURR 13 2 WRBTR_CS
BSTME Purchase Order Unit of Measure UNIT 3 0 * BSTME
BSTMG Purchase Order Quantity QUAN 13 3 BSTMG
HKONT General Ledger Account CHAR 10 0 * HKONT
MWSKZ Tax on sales/purchases code CHAR 2 0 * MWSKZ
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Document Item in Invoice Document NUMC 6 0 RBLGP
NAVNW Non-deductible input tax CURR 13 2 NAVNW
PRCTR Profit Center CHAR 10 0 PRCTR
BWART Movement type (inventory management) CHAR 3 0 * BWART
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 * MEINS
WAERS Currency Key CUKY 5 0 * WAERS
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 * EBELP
BKLAS Valuation Class CHAR 4 0 * BKLAS
CKONT General Ledger Account CHAR 10 0 * HKONT
ABWHK Alternative G/L Account CHAR 10 0 * ABWHK
PREIS Net Price in Purchasing Info Record CURR 11 2 IPREI
PEINH Price unit DEC 5 0 EPEIN
CCBTR Amount in Document Currency CURR 13 2 WRBTR_CS
VGART Transaction/Event Type CHAR 2 0 * VGART
XBLNR Reference Document Number CHAR 16 0 XBLNR1
EMLIF Supplier to be Supplied/Who is to Receive Delivery CHAR 10 0 * EMLIF
VBELN Billing Document CHAR 10 0 VBELN_VF
POSNR Billing Item NUMC 6 0 POSNR_VF
MVCTG OBEW Movement Category CHAR 1 0 MVCTG
1 Stock to OBEW
2 Stock from OBEW
3 Consumption from OBEW
4 Reversal of consumption from OBEW
5 Physical inventory from OBEW
6 Physical inventory to OBEW

ROWA foreign key relationships

Table Field Check Table Check Field
0 ROWA MBLNR MKPF Header: Material Document MBLNR
0 ROWA MBLNR MKPF Header: Material Document MJAHR
1 ROWA MJAHR MKPF Header: Material Document MBLNR
1 ROWA MJAHR MKPF Header: Material Document MJAHR
0 ROWA ZEILE MSEG Document Segment: Material MANDT
0 ROWA ZEILE MSEG Document Segment: Material MBLNR
0 ROWA ZEILE MSEG Document Segment: Material MJAHR