FDM_DOC_MPAIR SAP (Fixed Raw Data Pair (New and Old)) Structure details
Description: Fixed Raw Data Pair (New and Old)
Related tables to FDM_DOC_MPAIR
Access table FDM_DOC_MPAIR
Structure field list including key, data, relationships and ABAP select examples
FDM_DOC_MPAIR 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 "Fixed Raw Data Pair (New and Old)" 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_FDM_DOC_MPAIR TYPE FDM_DOC_MPAIR.
The FDM_DOC_MPAIR table consists of various fields, each holding specific information or linking keys about Fixed Raw Data Pair (New and Old) data available in SAP. These include USTATUS (Single-Character Indicator), NEW (), MANDT (Client), M_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 (Deep)
SAP FDM_DOC_MPAIR 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 |
CHANGE_ACTION | Action for Changed Raw Data | FDM_MIRR_CHANGE_ACTION | NUMC | 1 | FDM_MIRR_CHANGE_ACTION | ||||
USTATUS | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
NEW | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
M_BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
ITEM_TYPE | Object Type of Accounting Document | FDM_MIRR_SWO_OBJTYP | CHAR | 10 | OJ_NAME | ||||
ITEM_KEY | Object Key of Accounting Document in Original System | FDM_MIRR_SWO_TYPEID | CHAR | 70 | SWO_TYPEID | ||||
INVOICE_REF_TYPE | Object Type of Accounting Doc to which Transaction Belongs | FDM_MIRR_INV_REF_SWO_OBJTYP | CHAR | 10 | OJ_NAME | ||||
INVOICE_REF_KEY | Key of Accounting Document to which Transaction Belongs | FDM_MIRR_INV_REF_SWO_TYPEID | CHAR | 70 | SWO_TYPEID | ||||
M_XPOSTED | Line Item Posted in Substitute System | FDM_MIRR_XPOSTED | CHAR | 1 | XFELD | ||||
M_KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
M_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
M_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
M_BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
M_REBZT | Type of Document | FDM_MIRR_REBZT | CHAR | 1 | REBZT | ||||
M_BELNR_CORR | Document Number of Posted Adjustment Document | FDM_MIRR_BELNR_CORR | CHAR | 10 | ALPHA | BELNR | |||
M_GJAHR_CORR | Fiscal Year of Posted Adjustment Document | FDM_MIRR_GJAHR_CORR | NUMC | 4 | GJAHR | GJAHR | |||
M_BUZEI_CORR | Number of Posting Item Within Adjustment Document | FDM_MIRR_BUZEI_CORR | NUMC | 3 | BUZEI | ||||
M_FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
AMT_DOCCUR | Amount in document currency | BAPIWRBTR | DEC | 23(4) | BAPICURR | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
LC_AMOUNT | Amount in Local Currency | BAPIDMBTR | DEC | 23(4) | BAPICURR | ||||
DB_CR_IND | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
XPAYMT_ON_ACCT | Item is a Payment On Account | FDM_MIRR_XPAYMT_ON_ACCT | CHAR | 1 | XFELD | ||||
XCLOSED | Invoice Completed | FDM_MIRR_XCLOSED | CHAR | 1 | FDM_MIRR_XCLOSED | ||||
CLOSED_AT | Date on which the item was closed | FDM_MIRR_CLOSED_AT | DATS | 8 | DATUM | ||||
XREVERSED | Line Item Reversed | FDM_MIRR_XREVERSED | CHAR | 1 | XFELD | ||||
DOC_DATE | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
INV_REF | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
BLINE_DATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
DSCT_DAYS1 | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
DSCT_DAYS2 | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
NETTERMS | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
DSCT_PCT1 | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
DSCT_PCT2 | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
FIXEDTERMS | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
DISC_BASE | Amount Eligible for Cash Discount in Document Currency | BAPISKFBT | DEC | 23(4) | BAPICURR | ||||
DSC_AMT_DC | Cash Discount Amount in Document Currency | BAPIWSKTO | DEC | 23(4) | BAPICURR | ||||
PYMT_METH | Payment Method in Substitute System | FDM_MIRR_DZLSCH | CHAR | 1 | ZLSCH | ||||
PMNT_BLOCK | Line Item Blocked for Payment? | FDM_MIRR_DZLSPR | CHAR | 1 | ZAHLS | ||||
DUNN_BLOCK | Line Item Blocked for Dunning? | FDM_MIRR_MANSP | CHAR | 1 | MANSP | ||||
LAST_DUNN | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
DUNN_LEVEL | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
DUNN_AREA | Dunning Area | MABER | CHAR | 2 | MABER | ||||
ITEM_TEXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
REF_DOC_NO | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
REF_KEY_1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
REF_KEY_2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
ALLOC_NMBR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
AW_OBJ_TYPE | Reference Transaction | AWTYP | CHAR | 5 | AWTYP | ||||
AW_OBJ_KEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
AW_LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | ALPHA | LOGSYS | |||
M_TIMESTAMP | Time Stamep: Time Data Was Created or Updated | BDM_COLL_TIMESTAMP | DEC | 15 | TSTPS | BDM_TIMESTAMP | |||
M_UNAME | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
OLD | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
M_BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
ITEM_TYPE | Object Type of Accounting Document | FDM_MIRR_SWO_OBJTYP | CHAR | 10 | OJ_NAME | ||||
ITEM_KEY | Object Key of Accounting Document in Original System | FDM_MIRR_SWO_TYPEID | CHAR | 70 | SWO_TYPEID | ||||
INVOICE_REF_TYPE | Object Type of Accounting Doc to which Transaction Belongs | FDM_MIRR_INV_REF_SWO_OBJTYP | CHAR | 10 | OJ_NAME | ||||
INVOICE_REF_KEY | Key of Accounting Document to which Transaction Belongs | FDM_MIRR_INV_REF_SWO_TYPEID | CHAR | 70 | SWO_TYPEID | ||||
M_XPOSTED | Line Item Posted in Substitute System | FDM_MIRR_XPOSTED | CHAR | 1 | XFELD | ||||
M_KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
M_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
M_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
M_BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
M_REBZT | Type of Document | FDM_MIRR_REBZT | CHAR | 1 | REBZT | ||||
M_BELNR_CORR | Document Number of Posted Adjustment Document | FDM_MIRR_BELNR_CORR | CHAR | 10 | ALPHA | BELNR | |||
M_GJAHR_CORR | Fiscal Year of Posted Adjustment Document | FDM_MIRR_GJAHR_CORR | NUMC | 4 | GJAHR | GJAHR | |||
M_BUZEI_CORR | Number of Posting Item Within Adjustment Document | FDM_MIRR_BUZEI_CORR | NUMC | 3 | BUZEI | ||||
M_FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
AMT_DOCCUR | Amount in document currency | BAPIWRBTR | DEC | 23(4) | BAPICURR | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
LC_AMOUNT | Amount in Local Currency | BAPIDMBTR | DEC | 23(4) | BAPICURR | ||||
DB_CR_IND | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
XPAYMT_ON_ACCT | Item is a Payment On Account | FDM_MIRR_XPAYMT_ON_ACCT | CHAR | 1 | XFELD | ||||
XCLOSED | Invoice Completed | FDM_MIRR_XCLOSED | CHAR | 1 | FDM_MIRR_XCLOSED | ||||
CLOSED_AT | Date on which the item was closed | FDM_MIRR_CLOSED_AT | DATS | 8 | DATUM | ||||
XREVERSED | Line Item Reversed | FDM_MIRR_XREVERSED | CHAR | 1 | XFELD | ||||
DOC_DATE | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
INV_REF | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
BLINE_DATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
DSCT_DAYS1 | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
DSCT_DAYS2 | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
NETTERMS | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
DSCT_PCT1 | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
DSCT_PCT2 | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
FIXEDTERMS | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
DISC_BASE | Amount Eligible for Cash Discount in Document Currency | BAPISKFBT | DEC | 23(4) | BAPICURR | ||||
DSC_AMT_DC | Cash Discount Amount in Document Currency | BAPIWSKTO | DEC | 23(4) | BAPICURR | ||||
PYMT_METH | Payment Method in Substitute System | FDM_MIRR_DZLSCH | CHAR | 1 | ZLSCH | ||||
PMNT_BLOCK | Line Item Blocked for Payment? | FDM_MIRR_DZLSPR | CHAR | 1 | ZAHLS | ||||
DUNN_BLOCK | Line Item Blocked for Dunning? | FDM_MIRR_MANSP | CHAR | 1 | MANSP | ||||
LAST_DUNN | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
DUNN_LEVEL | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
DUNN_AREA | Dunning Area | MABER | CHAR | 2 | MABER | ||||
ITEM_TEXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
REF_DOC_NO | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
REF_KEY_1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
REF_KEY_2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
ALLOC_NMBR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
AW_OBJ_TYPE | Reference Transaction | AWTYP | CHAR | 5 | AWTYP | ||||
AW_OBJ_KEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
AW_LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | ALPHA | LOGSYS | |||
M_TIMESTAMP | Time Stamep: Time Data Was Created or Updated | BDM_COLL_TIMESTAMP | DEC | 15 | TSTPS | BDM_TIMESTAMP | |||
M_UNAME | User Name | SYUNAME | CHAR | 12 | SYCHAR12 | ||||
FICHANGE | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure FDM_DOC_MPAIR using ABAP code?
As FDM_DOC_MPAIR 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 FDM_DOC_MPAIR as there is no data to select.How to access SAP table FDM_DOC_MPAIR
Within an ECC or HANA version of SAP you can also view further information about FDM_DOC_MPAIR 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