SAP ABAP View V_MAA (View for BW extraction MAA)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
⤷ SRM-EBP (Application Component) Enterprise Buyer
⤷ BBP_APPLICATION (Package) Structure Package EBP
⤷ ME (Package) Application development R/3 Purchasing
Basic Data
View Type | D | Database View |
Database View | V_MAA | |
Short Description | View for BW extraction MAA | |
Root table | EKKO | Purchasing Document Header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | EKKO | EKKO | ||
2 | EKPO |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | EKKO | MANDT | JL | EQ | 0 | 0 | ||||
2 | EKPO | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | EKKO | EBELN | JL | EQ | 0 | 0 | ||||
4 | EKPO | EBELN | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | BEDAT | EKKO | BEDAT | EBDAT | Purchasing Document Date | |||
2 | BSART | EKKO | BSART | ESART | Purchasing Document Type | |||
3 | BSTYP | EKKO | BSTYP | EBSTYP | Purchasing Document Category | |||
4 | EBELN | EKKO | EBELN | EBELN | Purchasing Document Number | |||
5 | EKGRP | EKKO | EKGRP | BKGRP | Purchasing Group | |||
6 | EKORG | EKKO | EKORG | EKORG | Purchasing organization | |||
7 | KDATB | EKKO | KDATB | KDATB | Start of Validity Period | |||
8 | KDATE | EKKO | KDATE | KDATE | End of Validity Period | |||
9 | LBLIF | EKKO | LBLIF | LBLIF | Field not used | |||
10 | LIFNR | EKKO | LIFNR | ELIFN | Vendor's account number | |||
11 | LIFRE | EKKO | LIFRE | LIFRE | Different Invoicing Party | |||
12 | LLIEF | EKKO | LLIEF | LLIEF | Supplying Vendor | |||
13 | LOGSY | EKKO | LOGSY | LOGSYSTEM | Logical System | |||
14 | RESWK | EKKO | RESWK | RESWK | Supplying (issuing) plant in case of stock transport order | |||
15 | STATU | EKKO | STATU | ESTAK | Status of Purchasing Document | |||
16 | WAERS | EKKO | WAERS | WAERS | Currency Key | |||
17 | WKURS | EKKO | WKURS | WKURS | Exchange Rate | |||
18 | BUKRS | EKKO | BUKRS | BUKRS | Company Code | |||
19 | AFNAM | EKPO | AFNAM | AFNAM | Name of requisitioner/requester | |||
20 | AKTNR | EKPO | AKTNR | WAKTION | Promotion | |||
21 | BSGRU | EKPO | BSGRU | BSGRU | Reason for Ordering | |||
22 | EBELP | EKPO | EBELP | EBELP | Item Number of Purchasing Document | |||
23 | ELIKZ | EKPO | ELIKZ | ELIKZ | "Delivery Completed" Indicator | |||
24 | EMATN | EKPO | EMATN | EMATNR | Material number | |||
25 | EREKZ | EKPO | EREKZ | EREKZ | Final Invoice Indicator | |||
26 | KONNR | EKPO | KONNR | KONNR | Number of principal purchase agreement | |||
27 | KTPNR | EKPO | KTPNR | KTPNR | Item number of principal purchase agreement | |||
28 | LGORT | EKPO | LGORT | LGORT_D | Storage location | |||
29 | LMEIN | EKPO | LMEIN | LAGME | Base Unit of Measure | |||
30 | MATKL | EKPO | MATKL | MATKL | Material Group | |||
31 | MATNR | EKPO | MATNR | MATNR | Material Number | |||
32 | MEINS | EKPO | MEINS | BSTME | Order unit | |||
33 | NETPR | EKPO | NETPR | BPREI | Net Price in Purchasing Document (in Document Currency) | |||
34 | PEINH | EKPO | PEINH | EPEIN | Price unit | |||
35 | PSTYP | EKPO | PSTYP | PSTYP | Item category in purchasing document | |||
36 | TXZ01 | EKPO | TXZ01 | TXZ01 | Short Text | |||
37 | UMREN | EKPO | UMREN | UMBSN | Denominator for Conversion of Order Unit to Base Unit | |||
38 | UMREZ | EKPO | UMREZ | UMBSZ | Numerator for Conversion of Order Unit to Base Unit | |||
39 | WEBRE | EKPO | WEBRE | WEBRE | Indicator: GR-Based Invoice Verification | |||
40 | WERKS | EKPO | WERKS | EWERK | Plant | |||
41 | XERSY | EKPO | XERSY | XERSY | Evaluated Receipt Settlement (ERS) | |||
42 | KNTTP | EKPO | KNTTP | KNTTP | Account assignment category | |||
43 | VRTKZ | EKPO | VRTKZ | VRTKZ | Distribution indicator for multiple account assignment | |||
44 | EMLIF | EKPO | EMLIF | EMLIF | Vendor to be supplied/who is to receive delivery | |||
45 | EMNFR | EKPO | EMNFR | EMNFR | External manufacturer code name or number | |||
46 | EMPST | EKPO | EMPST | EMPST | Receiving point | |||
47 | TWRKZ | EKPO | TWRKZ | TWRKZ | Partial invoice indicator | |||
48 | MANDT | EKKO | MANDT | MANDT | Client | |||
49 | EFFWR | EKPO | EFFWR | EFFWR | Effective value of item | |||
50 | NETWR | EKPO | NETWR | BWERT | Net Order Value in PO Currency | |||
51 | MENGE | EKPO | MENGE | BSTMG | Purchase Order Quantity | |||
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 | 20140121 |
SAP Release Created in | 606 |