FAGL_FC_DOCS SAP (Items Processed in Foreign Currency Valuation) Structure details

Dictionary Type: Structure
Description: Items Processed in Foreign Currency Valuation




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




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

FAGL_FC_DOCS 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 "Items Processed in Foreign Currency Valuation" 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_FAGL_FC_DOCS TYPE FAGL_FC_DOCS.

The FAGL_FC_DOCS table consists of various fields, each holding specific information or linking keys about Items Processed in Foreign Currency Valuation data available in SAP. These include CCODE (Company Code), SORT_DUEGRID_DATE (Date Limit of Grid Group), VALUATION_GROUP (Group key), SORT_ACCOUNT_TYPE (Account Type).. 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 FAGL_FC_DOCS 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
TARGET_CCODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CCODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
SORT_DUEGRID_DATEDate Limit of Grid Group FAGL_DUEGRID_DATEDATS8DATUM
VALUATION_GROUPGroup key KONZSCHAR10KONZS
SORT_ACCOUNT_TYPEAccount Type KOARTCHAR1KOART
SORT_GL_ACCOUNTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
SORT_PARTNERCompany ID VBUNDCHAR6Assigned to domainALPHARCOMP
SORT_ACCOUNT30 Characters CHAR30CHAR30CHAR30
SORT_CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
LEDGER_GROUPLedger Group FAGL_LDGRPCHAR4Assigned to domainFAGL_LDGRPGLDGRP_FLEX
LEDGERLedger in General Ledger Accounting FAGL_RLDNRCHAR2Assigned to domainALPHARLDNRGLN_FLEXFAGL_RLDNR
ACCOUNT_TYPEAccount Type KOARTCHAR1KOART
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
GL_ACCOUNTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
PARTNERCompany ID VBUNDCHAR6Assigned to domainALPHARCOMP
ACCOUNTOpen item account number KONKOCHAR10ALPHAMAXKK
GROUPING_REFERENCE 0
NRAssignment Number DZUONRCHAR18ZUONR
JAFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZNumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
FISCAL_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DOC_NUMBERAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DOC_LINENumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
DEBCRED_INDDebit/Credit Indicator SHKZGCHAR1SHKZG
SOURCE_AMOUNT9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
TARGET_AMOUNT9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
HEDGED_AMOUNTHedged Amount in Foreign Currency GBETRCURR13(2) WERT7
VALUATION_RATEExchange rate KURSFDEC9(5) EXCRTKURSF
ERTYPEExchange Rate Type KURST_CURRCHAR4Assigned to domainKURST
VALU_RATE_TYPEForeign Currency Valuation: Origin of Exchange Rate FAGL_FC_RATE_TYPECHAR1FAGL_FC_RATE_TYPE
HEDGED_RATEHedged Exchange Rate KURSRDEC9(5) KURSP
SPECIAL_GL_INDSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
DOC_TYPEDocument Type BLARTCHAR2Assigned to domainBLARTBAR
POSTING_DATEPosting Date in the Document BUDATDATS8DATUM
GRIR_ITEMSingle-Character Indicator CHAR1CHAR1CHAR1
CLEARING_DOCUMENTDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
CLEARING_DATEClearing Date AUGDTDATS8DATUM
REAL_DIFF_OLDExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
REAL_DIFF_NEWExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
VALU_DIFF_OLD9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
VALU_DIFF_NEW9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
REAL_DIFF1_OLDExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
REAL_DIFF1_NEWExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
VALU_DIFF1_OLDValuation Difference BDIFFCURR13(2) WRTV7
VALU_DIFF1_NEWValuation Difference BDIFFCURR13(2) WRTV7
ORIG_TA_CURRCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
XRESET_VALReset Valuation Run F100RESETCHAR1XFELD
VALU_DIFF_REM29(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
VALU_DIFF_REM39(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
VALU_DIFF_REM2_OLD9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
VALU_DIFF_REM3_OLD9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
TARGET_LC_FIELDNRLocal Currency Type (1,2,3) HWTYPCHAR1HWTYP
TARGET_LC_CURTPCurrency Type and Valuation View CURTPCHAR2CURTP
TARGET_CURRENCYLocal Currency HWAER_CURDCUKY5Assigned to domainWAERSFWS
TC_AMOUNT9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
LC1_AMOUNT9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
LC2_AMOUNT9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
LC3_AMOUNT9(17)-character value field with 2 decimal places WERTV9CURR17(2) WERTV9
VALU_DIFF2_OLDValuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
VALU_DIFF2_NEWValuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
VALU_DIFF3_OLDValuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
VALU_DIFF3_NEWValuation Difference for the Second Local Currency BDIF2CURR13(2) WRTV7
REAL_DIFF2_OLDExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
REAL_DIFF3_OLDExchange Rate Gain/Loss Realized RDIFFCURR13(2) WRTV7
HIST_RATEHistorical Exchange Rate FAGL_HIST_RATEDEC9(5) EXCRTKURSP
HIST_RATE_TEXTHistorical Exchange Rate Used FAGL_HIST_RATE_USEDCHAR70CHAR70
DUEGRID_DATEDate Limit of Grid Group FAGL_DUEGRID_DATEDATS8DATUM
NETDUE_DATEDue Date for Net Payment NETDTDATS8DATUM
TARGET_PLTYPEUse P&L Target Account for Expenses/Revenues FAGL_FCV_PLTYPECHAR1FAGL_FCV_PLTYPE
XRESET_WITH_REVCheckbox FAGL_CHECKBOXCHAR1XFELD
XLGCLRClearing Specific to Ledger Groups XLGCLRCHAR1XFELD
LGOI_LDGRPLedger Group FAGL_LDGRPCHAR4Assigned to domainFAGL_LDGRPGLDGRP_FLEX
LGOI_BSTATDocument Status BSTAT_DCHAR1BSTAT
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PSEGMENTPartner Segment for Segmental Reporting FB_PSEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT
RBUSABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
SBUSATrading Partner Business Area of the Business Partner PPARGBCHAR4Assigned to domainGSBERGSB
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10Assigned to domainALPHAFB_SEGMENT

Key field Non-key field



How do I retrieve data from SAP structure FAGL_FC_DOCS using ABAP code?

As FAGL_FC_DOCS 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 FAGL_FC_DOCS as there is no data to select.

How to access SAP table FAGL_FC_DOCS

Within an ECC or HANA version of SAP you can also view further information about FAGL_FC_DOCS 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!