SAP ABAP View /SAPNEA/ROWA_V (ROWA view + BWTAR(MSEG))
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ MM (Application Component) Materials Management
⤷ /SAPNEA/J_SC1 (Package) Subcontracting Management
⤷ MM (Application Component) Materials Management
⤷ /SAPNEA/J_SC1 (Package) Subcontracting Management
Basic Data
View Type | D | Database View |
Database View | /SAPNEA/ROWA_V | |
Short Description | ROWA view + BWTAR(MSEG) | |
Root table | MSEG | Document Segment: Material |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | MSEG | MSEG | ||
2 | ROWA |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | MSEG | MANDT | JL | EQ | 0 | 0 | ||||
2 | ROWA | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | MSEG | MBLNR | JL | EQ | 0 | 0 | ||||
4 | ROWA | MBLNR | JR | EQ | AND | 0 | 0 | |||
5 | MSEG | MJAHR | JL | EQ | 0 | 0 | ||||
6 | ROWA | MJAHR | JR | EQ | AND | 0 | 0 | |||
7 | MSEG | ZEILE | JL | EQ | 0 | 0 | ||||
8 | ROWA | ZEILE | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | ROWA | MANDT | MANDT | Client | |||
2 | MBLNR | ROWA | MBLNR | MBLNR | Number of Material Document | |||
3 | MJAHR | ROWA | MJAHR | MJAHR | Year of material document | |||
4 | ZEILE | ROWA | ZEILE | MBLPO | Item in material document | |||
5 | STATUS | ROWA | STATUS | MO_ROWAST | Status for ROWA entry | |||
6 | BLDAT | ROWA | BLDAT | BLDAT | Document Date in Document | |||
7 | BUDAT | ROWA | BUDAT | BUDAT | Posting Date in the Document | |||
8 | BUKRS | ROWA | BUKRS | BUKRS | Company Code | |||
9 | SOBKZ | ROWA | SOBKZ | SOBKZ | Special Stock Indicator | |||
10 | LIFNR | ROWA | LIFNR | ELIFN | Vendor's account number | |||
11 | WERKS | ROWA | WERKS | WERKS_D | Plant | |||
12 | MATNR | ROWA | MATNR | MATNR | Material Number | |||
13 | SHKZG | ROWA | SHKZG | SHKZG | Debit/Credit Indicator | |||
14 | GSBER | ROWA | GSBER | GSBER | Business Area | |||
15 | BWAER | ROWA | BWAER | WAERS | Currency Key | |||
16 | WRBTR | ROWA | WRBTR | WRBTR | Amount in document currency | |||
17 | BSTME | ROWA | BSTME | BSTME | Order unit | |||
18 | BSTMG | ROWA | BSTMG | BSTMG | Purchase Order Quantity | |||
19 | HKONT | ROWA | HKONT | HKONT | General Ledger Account | |||
20 | MWSKZ | ROWA | MWSKZ | MWSKZ | Tax on sales/purchases code | |||
21 | BELNR | ROWA | BELNR | BELNR_D | Accounting Document Number | |||
22 | GJAHR | ROWA | GJAHR | GJAHR | Fiscal Year | |||
23 | BUZEI | ROWA | BUZEI | RBLGP | Document Item in Invoice Document | |||
24 | NAVNW | ROWA | NAVNW | NAVNW | Non-deductible input tax | |||
25 | PRCTR | ROWA | PRCTR | PRCTR | Profit Center | |||
26 | BWART | ROWA | BWART | BWART | Movement type (inventory management) | |||
27 | MENGE | ROWA | MENGE | MENGE_D | Quantity | |||
28 | MEINS | ROWA | MEINS | MEINS | Base Unit of Measure | |||
29 | WAERS | ROWA | WAERS | WAERS | Currency Key | |||
30 | EBELN | ROWA | EBELN | EBELN | Purchasing Document Number | |||
31 | EBELP | ROWA | EBELP | EBELP | Item Number of Purchasing Document | |||
32 | BKLAS | ROWA | BKLAS | BKLAS | Valuation Class | |||
33 | CKONT | ROWA | CKONT | HKONT | General Ledger Account | |||
34 | ABWHK | ROWA | ABWHK | ABWHK | Alternative G/L Account | |||
35 | PREIS | ROWA | PREIS | IPREI | Net Price in Purchasing Info Record | |||
36 | PEINH | ROWA | PEINH | EPEIN | Price unit | |||
37 | CCBTR | ROWA | CCBTR | WRBTR | Amount in document currency | |||
38 | VGART | ROWA | VGART | VGART | Transaction/Event Type | |||
39 | XBLNR | ROWA | XBLNR | XBLNR1 | Reference Document Number | |||
40 | EMLIF | ROWA | EMLIF | EMLIF | Vendor to be supplied/who is to receive delivery | |||
41 | VBELN | ROWA | VBELN | VBELN_VF | Billing document | |||
42 | POSNR | ROWA | POSNR | POSNR_VF | Billing item | |||
43 | MVCTG | ROWA | MVCTG | MVCTG | OBEW Movement Category | |||
44 | BWTAR | MSEG | BWTAR | BWTAR_D | Valuation type | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |