FDM_DOC_MIRROR SAP (Document Information (Raw Data in Substitute System)) Table details

Dictionary Type: Table
Description: Document Information (Raw Data in Substitute System)




ABAP Code to SELECT data from FDM_DOC_MIRROR
Related tables to FDM_DOC_MIRROR
Access table FDM_DOC_MIRROR




Table field list including key, data, relationships and ABAP select examples

FDM_DOC_MIRROR is a standard SAP Table which is used to store Document Information (Raw Data in Substitute System) data and is available within R/3 SAP systems depending on the version and release level.

The FDM_DOC_MIRROR table consists of various fields, each holding specific information or linking keys about Document Information (Raw Data in Substitute System) data available in SAP. These include M_BUKRS (Company Code), ITEM_TYPE (Object Type of Accounting Document), ITEM_KEY (Object Key of Accounting Document in Original System), INVOICE_REF_TYPE (Object Type of Accounting Doc to which Transaction Belongs).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FDM_DOC_MIRROR table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
M_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
ITEM_TYPEObject Type of Accounting Document FDM_MIRR_SWO_OBJTYPCHAR10Assigned to domainOJ_NAME
ITEM_KEYObject Key of Accounting Document in Original System FDM_MIRR_SWO_TYPEIDCHAR70SWO_TYPEID
INVOICE_REF_TYPEObject Type of Accounting Doc to which Transaction Belongs FDM_MIRR_INV_REF_SWO_OBJTYPCHAR10Assigned to domainOJ_NAME
INVOICE_REF_KEYKey of Accounting Document to which Transaction Belongs FDM_MIRR_INV_REF_SWO_TYPEIDCHAR70SWO_TYPEID
M_XPOSTEDLine Item Posted in Substitute System FDM_MIRR_XPOSTEDCHAR1XFELD
M_KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
M_BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
M_GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
M_BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
M_REBZTType of Document FDM_MIRR_REBZTCHAR1REBZT
M_BELNR_CORRDocument Number of Posted Adjustment Document FDM_MIRR_BELNR_CORRCHAR10ALPHABELNR
M_GJAHR_CORRFiscal Year of Posted Adjustment Document FDM_MIRR_GJAHR_CORRNUMC4GJAHRGJAHR
M_BUZEI_CORRNumber of Posting Item Within Adjustment Document FDM_MIRR_BUZEI_CORRNUMC3BUZEI
M_FILKDAccount Number of the Branch FILKDCHAR10ALPHAMAXKK
AMT_DOCCURAmount in document currency BAPIWRBTRDEC23(4) BAPICURR
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
LC_AMOUNTAmount in Local Currency BAPIDMBTRDEC23(4) BAPICURR
DB_CR_INDDebit/Credit Indicator SHKZGCHAR1SHKZG
XPAYMT_ON_ACCTItem is a Payment On Account FDM_MIRR_XPAYMT_ON_ACCTCHAR1XFELD
XCLOSEDInvoice Completed FDM_MIRR_XCLOSEDCHAR1FDM_MIRR_XCLOSED
CLOSED_ATDate on which the item was closed FDM_MIRR_CLOSED_ATDATS8DATUM
XREVERSEDLine Item Reversed FDM_MIRR_XREVERSEDCHAR1XFELD
DOC_DATEDocument Date in Document BLDATDATS8DATUM
INV_REFNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
BLINE_DATEBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
DSCT_DAYS1Cash discount days 1 DZBD1TDEC3ZBDXT
DSCT_DAYS2Cash discount days 2 DZBD2TDEC3ZBDXT
NETTERMSNet Payment Terms Period DZBD3TDEC3ZBDXT
DSCT_PCT1Cash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
DSCT_PCT2Cash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
FIXEDTERMSFixed Payment Terms DZBFIXCHAR1ZBFIX
DISC_BASEAmount Eligible for Cash Discount in Document Currency BAPISKFBTDEC23(4) BAPICURR
DSC_AMT_DCCash Discount Amount in Document Currency BAPIWSKTODEC23(4) BAPICURR
PYMT_METHPayment Method in Substitute System FDM_MIRR_DZLSCHCHAR1Assigned to domainZLSCH
PMNT_BLOCKLine Item Blocked for Payment? FDM_MIRR_DZLSPRCHAR1Assigned to domainZAHLS
DUNN_BLOCKLine Item Blocked for Dunning? FDM_MIRR_MANSPCHAR1Assigned to domainMANSP
LAST_DUNNLast dunned on MADATDATS8DATUM
DUNN_LEVELDunning level MAHNS_DNUMC1MAHNS
DUNN_AREADunning Area MABERCHAR2Assigned to domainMABER
ITEM_TEXTItem Text SGTXTCHAR50TEXT50
REF_DOC_NOReference Document Number XBLNR1CHAR16XBLNR1
REF_KEY_1Business partner reference key XREF1CHAR12CHAR12
REF_KEY_2Business partner reference key XREF2CHAR12CHAR12
ALLOC_NMBRAssignment Number DZUONRCHAR18ZUONR
AW_OBJ_TYPEReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AW_OBJ_KEYReference Key AWKEYCHAR20AWKEY
AW_LOGSYSTEMLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
M_TIMESTAMPTime Stamep: Time Data Was Created or Updated BDM_COLL_TIMESTAMPDEC15TSTPSBDM_TIMESTAMP
M_UNAMEUser Name SYUNAMECHAR12SYCHAR12

Key field Non-key field



How do I retrieve data from SAP table FDM_DOC_MIRROR using ABAP code

The following ABAP code Example will allow you to do a basic selection on FDM_DOC_MIRROR to SELECT all data from the table
DATA: WA_FDM_DOC_MIRROR TYPE FDM_DOC_MIRROR.

SELECT SINGLE *
FROM FDM_DOC_MIRROR
INTO CORRESPONDING FIELDS OF WA_FDM_DOC_MIRROR
WHERE...

How to access SAP table FDM_DOC_MIRROR

Within an ECC or HANA version of SAP you can also view further information about FDM_DOC_MIRROR and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!