MC02M_0ACC SAP (Extraction Purchasing (Account)) Structure details
Description: Extraction Purchasing (Account)
Structure field list including key, data, relationships and ABAP select examples
MC02M_0ACC 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 "Extraction Purchasing (Account)" 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_MC02M_0ACC TYPE MC02M_0ACC.
The MC02M_0ACC table consists of various fields, each holding specific information or linking keys about Extraction Purchasing (Account) data available in SAP. These include BEDAT (Purchasing Document Date), BSART (Purchasing Document Type), BSTYP (Purchasing Document Category), BUKRS (Company Code).. 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 MC02M_0ACC 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 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
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 | ||||
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 | |
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 | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | Assigned to domain | KNTTP | KNT | ||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
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 | ||
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 | ||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP | |||
TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
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 | ||||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | XFELD | ||||
WERKS | Plant | EWERK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | XFELD | ||||
AEDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
EFFHW | Effective order value in local currency | MC_EFFHW | CURR | 15(2) | WERTV8 | ||||
EFFWR | Effective order value | MC_EFFWR | CURR | 15(2) | WERTV8 | ||||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | Assigned to domain | FIKRS | FIK | ||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
KBLNR | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | Assigned to domain | ALPHA | KBLNR | KBL | |
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | Assigned to domain | KBLPOS | KBP | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
KSTRG | Cost Object | KSTRG | CHAR | 12 | Assigned to domain | KSTRG | KTR | ||
KTOPL | Chart of Accounts | KTOPL | CHAR | 4 | Assigned to domain | KTOPL | KPL | C_KTOPL | |
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
NAVNW | Non-deductible input tax | NAVNW | CURR | 13(2) | WERT7 | ||||
NETHW | Net purchase local value (base unit) | MC_NETHW | CURR | 15(2) | WERTV8 | ||||
NETWR | Net Order Value in PO Currency | BWERT | CURR | 13(2) | WERT7 | ||||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
SAKTO | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VBELP | Sales Document Item | POSNR_VA | NUMC | 6 | Assigned to domain | POSNR | APO | ||
VPROZ | Distribution Percentage in Case of Multiple Account Assgt | VPROZ | DEC | 3(1) | VPROZ | ||||
XBAUF | Post To Order | XBAUF | CHAR | 1 | XFELD | ||||
XBKST | Posting to cost center? | XBKST | CHAR | 1 | XFELD | ||||
XBPRO | Post to project | XBPRO | CHAR | 1 | XFELD | ||||
ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | NUM02 |
Key field | Non-key field |
How do I retrieve data from SAP structure MC02M_0ACC using ABAP code?
As MC02M_0ACC 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 MC02M_0ACC as there is no data to select.How to access SAP table MC02M_0ACC
Within an ECC or HANA version of SAP you can also view further information about MC02M_0ACC 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