MMDA_PUR_S_PO_ITM SAP (Extract Structure For PO ITM Datasource) Structure details
Description: Extract Structure For PO ITM Datasource
Related tables to MMDA_PUR_S_PO_ITM
Access table MMDA_PUR_S_PO_ITM
Structure field list including key, data, relationships and ABAP select examples
MMDA_PUR_S_PO_ITM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Extract Structure For PO ITM Datasource" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MMDA_PUR_S_PO_ITM TYPE MMDA_PUR_S_PO_ITM.
The MMDA_PUR_S_PO_ITM table consists of various fields, each holding specific information or linking keys about Extract Structure For PO ITM Datasource data available in SAP. These include BEDAT (Purchasing Document Date), BSART (Purchasing Document Type), BSTYP (Purchasing Document Category), BUDAT (Posting date of goods received or invoice receipt for order).. 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: Can be enhanced (character-type or numeric)
SAP MMDA_PUR_S_PO_ITM structure 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 |
ROCANCEL | Indicator: Cancel Data Record | ROCANCEL | CHAR | 1 | BOOLE | ||||
BEDAT | Purchasing Document Date | EBDAT | DATS | 8 | DATUM | ||||
BSART | Purchasing Document Type | ESART | CHAR | 4 | Assigned to domain | BSART | BSA | ||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
BUDAT | Posting date of goods received or invoice receipt for order | MC_BUDAT | DATS | 8 | DATUM | ||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EKGRP | Purchasing Group | BKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
KDATB | Start of Validity Period | KDATB | DATS | 8 | DATUM | ||||
KDATE | End of Validity Period | KDATE | DATS | 8 | DATUM | ||||
LBLIF | Field not used | LBLIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | |
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
LIFRE | Different Invoicing Party | LIFRE | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LRE | |
LLIEF | Supplying Vendor | LLIEF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LLI | |
LOGSY | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ORGLOGSY | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
RESWK | Supplying (Issuing) Plant in Stock Transport Order | RESWK | CHAR | 4 | Assigned to domain | WERKS | |||
STATU | Status of Purchasing Document | ESTAK | CHAR | 1 | ESTAK | ||||
SYDAT | Date on which the purchasing document was entered | MC_ERFDAT | DATS | 8 | DATUM | ||||
WAERS | Purchase order currency | BSTWA | CUKY | 5 | Assigned to domain | WAERS | |||
WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
AKTWE | Current goods receipt quantity in order unit | MC_AKTWE | QUAN | 13(3) | MENG13 | ||||
ALAV | Points score: Shipping notif. GR date - notified date | MC_ALAV | DEC | 3 | DEC3 | ||||
ALIEF | Number of deliveries | MC_ALIEF | DEC | 9 | MCZAEHLER | ||||
BSGRU | Reason for Ordering | BSGRU | CHAR | 3 | BSGRU | ||||
BWAPPLNM | Application Component | RSAPPLNM | CHAR | 30 | RSAPPLNM | ||||
BWVORG | SAP BW transaction key | MCW_BWVORG | NUMC | 3 | NUM3 | ||||
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
EMATN | Material Number | EMATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | XFELD | ||||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
KTMNG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
KZMAB | Indicator: relevant quantity deviation | MC_KZMAB | CHAR | 1 | CHAR1 | ||||
KZPOS | Indicator: item counter relevant (R/2->R/3 link, schd.agmt) | MC_KZPOS | CHAR | 1 | X | ||||
KZTAB | Indicator: relevant schedule deviation | MC_KZTAB | CHAR | 1 | CHAR1 | ||||
LAVI | Points score: Shipping notification | MC_LAVI | DEC | 3 | DEC3 | ||||
LFZTA | Total delivery time in days | MC_LFZTA | DEC | 13 | DECV13 | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MABW | Variance in the quantity delivered as % | MC_MABW | DEC | 6(2) | PRZ32V | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
NETWR | Net order value in order currency | MC_BNETWR | CURR | 13(2) | WERT7 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP | |||
PWEV | Points score for compliance with shipping instructions | MC_PWEV | DEC | 3 | DEC3 | ||||
PWFR | Points score for on-time delivery | MC_PWFR | DEC | 3 | DEC3 | ||||
PWMT | Points score for quantity reliability | MC_PWMT | DEC | 3 | DEC3 | ||||
PWTT | Points score for on-time delivery performance | MC_PWTT | DEC | 3 | DEC3 | ||||
PWWE | Points score for quality of services | MC_PWWE | DEC | 3 | DEC3 | ||||
REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
TABW | Delivery Date Variance in Days | MC_TABW | DEC | 3 | PL2 | ||||
TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
UMREN | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5 | UMBSN | ||||
UMREZ | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5 | UMBSZ | ||||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | XFELD | ||||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
WERKS | Plant | EWERK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | XFELD | ||||
ZWERT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13(2) | WERT7 | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
QUAN_INT | Interval for Quantity Interval | MC_QUAN_INT | DEC | 3 | PL2 | ||||
TIME_INT | Interval for Date Split | MC_TIME_INT | DEC | 3 | PL2 | ||||
NOTIME | Counter for Date Split | MC_NOTIME | DEC | 3 | PL2 | ||||
NOQUAN | Counter for Quantity Interval | MC_NOQUAN | DEC | 3 | PL2 | ||||
NOPOS | Counter for Items | MC_NOPOS | DEC | 3 | PL2 | ||||
PWLIF | Goods supplier | PWLIF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PREST | Invoicing party | PREST | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PLIWK | Supplying plant to which partner roles have been assigned | PLIWK | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PLIEF | Vendor to whom partner roles have been assigned | PLIEF | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
PBEST | Ordering address | PBEST | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
MGABW | Smoothing Factor: Quantity Variance | MGABW | DEC | 3(2) | GLATT | ||||
LFABW | Smoothing Factor: Date Variance | LFABW | DEC | 3(2) | GLATT | ||||
MAXBW | Best Score | BEWERX | DEC | 3 | BEWER | ||||
VVABW | Smoothing Factor: Compliance with Shipping Instructions | VVABW | DEC | 3(2) | GLATT | ||||
UZEIT | Time | UZEIT | TIMS | 6 | UZEIT | ||||
MCEX_UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
MCEX_UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
MCEX_UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP structure MMDA_PUR_S_PO_ITM using ABAP code?
As MMDA_PUR_S_PO_ITM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MMDA_PUR_S_PO_ITM as there is no data to select.How to access SAP table MMDA_PUR_S_PO_ITM
Within an ECC or HANA version of SAP you can also view further information about MMDA_PUR_S_PO_ITM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects