MMDA_PUR_S_PO_ACC SAP (Extract structure for purchasing account) Structure details
Description: Extract structure for purchasing account
Related tables to MMDA_PUR_S_PO_ACC
Access table MMDA_PUR_S_PO_ACC
Structure field list including key, data, relationships and ABAP select examples
MMDA_PUR_S_PO_ACC 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 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_MMDA_PUR_S_PO_ACC TYPE MMDA_PUR_S_PO_ACC.
The MMDA_PUR_S_PO_ACC table consists of various fields, each holding specific information or linking keys about Extract structure for purchasing account data available in SAP. These include BEDAT (Purchasing Document Date), BSART (Purchasing Document Type), BSTYP (Purchasing Document Category), EBELN (Purchasing Document Number).. 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_ACC 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 | ||||
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 | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
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 | ||||
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 | |||
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 | ||||
WERKS | Plant | EWERK | CHAR | 4 | Assigned to domain | WERKS | WRK | ||
XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | XFELD | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | Assigned to domain | KNTTP | KNT | ||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
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_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
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 MMDA_PUR_S_PO_ACC using ABAP code?
As MMDA_PUR_S_PO_ACC 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_ACC as there is no data to select.How to access SAP table MMDA_PUR_S_PO_ACC
Within an ECC or HANA version of SAP you can also view further information about MMDA_PUR_S_PO_ACC 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