MMDA_PUR_S_PUR_C01 SAP (Purchasing Data (Similar to InfoCube 0PUR_C01)) Structure details
Dictionary Type: Structure
Description: Purchasing Data (Similar to InfoCube 0PUR_C01)
Description: Purchasing Data (Similar to InfoCube 0PUR_C01)
ABAP Code to SELECT data from MMDA_PUR_S_PUR_C01
Related tables to MMDA_PUR_S_PUR_C01
Access table MMDA_PUR_S_PUR_C01
Related tables to MMDA_PUR_S_PUR_C01
Access table MMDA_PUR_S_PUR_C01
Structure field list including key, data, relationships and ABAP select examples
MMDA_PUR_S_PUR_C01 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 "Purchasing Data (Similar to InfoCube 0PUR_C01)" 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_PUR_C01 TYPE MMDA_PUR_S_PUR_C01.
The MMDA_PUR_S_PUR_C01 table consists of various fields, each holding specific information or linking keys about Purchasing Data (Similar to InfoCube 0PUR_C01) data available in SAP. These include CALMONTH (Calendar year / month), CALWEEK (Calendar year / week), FISCPER (Fiscal year / period), FISCVARNT (Fiscal year variant).. 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_PUR_C01 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 |
| CALDAY | Calendar day | RSCALDAY | DATS | 8 | DATUM | ||||
| CALMONTH | Calendar year / month | RSCALMONTH | NUMC | 6 | PERI6 | RSCALMONTH | |||
| CALWEEK | Calendar year / week | RSCALWEEK | NUMC | 6 | PERI6 | RSCALWEEK | |||
| FISCPER | Fiscal year / period | RSFISCPER | NUMC | 7 | PERI7 | RSFISCPER | |||
| FISCVARNT | Fiscal year variant | RSFISCVAR | CHAR | 2 | RSFISCVAR | ||||
| DOC_DATE | Purchase Order Date | BEDAT | DATS | 8 | DATUM | ||||
| COUNTRY | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
| INFO_REC | Number of Purchasing Info Record | INFNR | CHAR | 10 | Assigned to domain | ALPHA | INFNR | INF | MEIN_C |
| INFO_TYPE | Purchasing info record category | ESOKZ | CHAR | 1 | ESOKZ | ESO | |||
| MATERIAL | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| MATL_GROUP | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
| PURCH_ORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
| REVERSEDOC | Purchasing info: General data flagged for deletion | ILOEA | CHAR | 1 | XFELD | ||||
| VENDOR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
| VERSION | Version | VERSN | CHAR | 3 | Assigned to domain | ALPHA | COVERSI | KVS | |
| VTYPE | Value type for Reporting | RSVTYPE | NUMC | 3 | Assigned to domain | RSVTYPE | |||
| CT_FLG | Boolean type | MMPUR_BOOL | CHAR | 1 | CHAR1 | ||||
| PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| GR_RE_IND | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
| DELIVERIES | Number of Deliveries | DELIVERIES | DEC | 17(3) | |||||
| DEL_DT_VR1 | Delivery Date Variance | DEL_DT_VR | DEC | 17(3) | |||||
| DEL_DT_VR2 | Delivery Date Variance | DEL_DT_VR | DEC | 17(3) | |||||
| DEL_DT_VR3 | Delivery Date Variance | DEL_DT_VR | DEC | 17(3) | |||||
| DEL_DT_VR4 | Delivery Date Variance | DEL_DT_VR | DEC | 17(3) | |||||
| DEL_DT_VR5 | Delivery Date Variance | DEL_DT_VR | DEC | 17(3) | |||||
| QTY_DEV_1 | Delivery Quantity Variance | QTY_DEV | DEC | 17(3) | |||||
| QTY_DEV_2 | Delivery Quantity Variance | QTY_DEV | DEC | 17(3) | |||||
| QTY_DEV_3 | Delivery Quantity Variance | QTY_DEV | DEC | 17(3) | |||||
| QTY_DEV_4 | Delivery Quantity Variance | QTY_DEV | DEC | 17(3) | |||||
| QTY_DEV_5 | Delivery Quantity Variance | QTY_DEV | DEC | 17(3) | |||||
| IR_VAL_RET | Invoiced Amount: Returns | IR_VAL_RET | CURR | 17(2) | WERTV9 | ||||
| WTDDELTIME | Weighted Total Delivery Time | WTDDELTIME | DEC | 17(3) | |||||
| EFF_VAL_RE | Effective Order Value of Returns | EFF_VAL_RE | CURR | 17(2) | WERTV9 | ||||
| GR_VAL | Value of Goods Received | GR_VAL | CURR | 17(2) | WERTV9 | ||||
| GR_VAL_PD | Goods Receipt Value at Posting Date | GR_VAL_PD | CURR | 17(2) | WERTV9 | ||||
| INV_RC_QTY | Invoice Receipt Quantity at Posting Date | INV_RC_QTY | QUAN | 15(3) | MENGV15_3 | ||||
| INV_RC_VAL | Invoice Amount as Posting Date | INV_RC_VAL | CURR | 17(2) | WERTV9 | ||||
| GR_QTY | Actual Goods Receipt Quantity | GR_QTY | QUAN | 15(3) | MENGV15_3 | ||||
| GR_QTY_RET | Goods Receipt Quantity of Returns | GR_QTY_RET | QUAN | 15(3) | MENGV15_3 | ||||
| GR_QTY_WDT | GR Qty in Base Unit (Calculate Weighted Delivery Time) | GR_QTY_WDT | QUAN | 15(3) | MENGV15_3 | ||||
| GR_VAL_R_P | GR Value: Returns at Posting Date | GR_VAL_R_P | CURR | 17(2) | WERTV9 | ||||
| INVCD_AMNT | Invoiced Amount | INVCD_AMNT | CURR | 17(2) | WERTV9 | ||||
| IR_QTY_RET | Invoice Receipt Quantity of Returns | IR_QTY_RET | QUAN | 15(3) | MENGV15_3 | ||||
| IR_QTY_R_P | IR Quantity: Returns at Posting Date | IR_QTY_R_P | QUAN | 15(3) | MENGV15_3 | ||||
| IR_VAL_R_P | IR Value: Returns at Posting Date | IR_VAL_R_P | CURR | 17(2) | WERTV9 | ||||
| IV_REC_QTY | Invoice Receipt Quantity | IV_REC_QTY | QUAN | 15(3) | MENGV15_3 | ||||
| ORDER_VAL | Effective Purchase Order Value | ORDER_VAL | CURR | 17(2) | WERTV9 | ||||
| TAR_DL_QTY | Target Delivery Quantity | TAR_DL_QTY | QUAN | 15(3) | MENGV15_3 | ||||
| PO_QTY_RET | Order Quantity (Returns) | PO_QTY_RET | QUAN | 15(3) | MENGV15_3 | ||||
| CONTR_ITEM | Number of Contract Items | CONTR_ITEM | DEC | 17(3) | |||||
| DEL_SCHEDS | Number of Scheduling Agreement Schedule Lines | DEL_SCHEDS | DEC | 17(3) | |||||
| PO_ITEMLNS | Number of Purchase Order Schedule Lines | PO_ITEMLNS | DEC | 17(3) | |||||
| PO_ITEMS | Number of Purchase Order Items | PO_ITEMS | DEC | 17(3) | |||||
| PO_QTY | Order Quantity | PO_QTY | QUAN | 15(3) | MENGV15_3 | ||||
| QUOT_ITEMS | Number of Quotation Items | QUOT_ITEMS | DEC | 17(3) | |||||
| RFQ_ITEMS | Number of Request for Quotation Items | RFQ_ITEMS | DEC | 17(3) | |||||
| SCH_AGR_IT | Number of Scheduling Agreement Items | SCH_AGR_IT | DEC | 17(3) | |||||
| TOTDELTIME | Total Delivery Time in Days | TOTDELTIME | DEC | 17(3) | |||||
| BASE_UOM | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| LOC_CURRCY | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
| 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_PUR_C01 using ABAP code?
As MMDA_PUR_S_PUR_C01 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_PUR_C01 as there is no data to select.How to access SAP table MMDA_PUR_S_PUR_C01
Within an ECC or HANA version of SAP you can also view further information about MMDA_PUR_S_PUR_C01 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