P_FI_CLS_FXV_RL

FI Closing Foreign Currency Valuation Result List Output | view: PFXVRL | Extraction: Not supported | Component: Closing Operations / Period-End
Tables used: SCAL_TT_DATE, ACDOCTEMP, ACDOCA, T004, KNA1, SKA1, FINS_CLS_RUN_RL2, FINSTS_SLALITTYT, LFA1, SKAT, T004, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
PrimaryKey1 Journal Entry
PrimaryKey2 Ledger Journal Entry Item
JrnlPeriodEndClosingRunLogUUID FK UUID of Financial Closing Run
Column Name Description
💲 Transaction Currency (DocumentCurrency):
AmountInDocumentCurrency Valuated Amount in Source/Target Currency
AmountInSourceCurrency Valuated Amount in Source/Target Currency
FinClsgRunRsltAmtInFDCrcy1 Amount in Freely Defined Currency 1
💲 Functional Currency (TargetCurrency):
ValuatedAmountInTargetCurrency Valuated Amount in Source/Target Currency
PrevPerdsDeltaAmtInTgtCrcy Previous Period Difference In Target Currency
RecalculatedAmountInTargetCrcy Revaluation Amount in Target Currency
CurPerdFxAmtInTargetCurrency Current Period Posted Amount In Target Currency
CalcdDeltaAmtInTargetCurrency New Difference in Target Currency
PostedDeltaAmtInTargetCurrency To Be Posted Amount In Target Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
Column Name Description
NetDueDate Net Due Date
OldestOpenItemNetDueDate Net due date of the oldest open item
ClearingDate Clearing Date
PostingDate Posting Date
Column Name Description
FinClosingLineItemDetailStatus Financial Closing Run Line Item Status Detail Show values
FinancialClosingLineItemType Financial Closing Run Type Show values
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
JrnlPerdEndClsgRunResultUUID Financial Closing Run Message ID UUID
AccountingDocument Foreign Currency Valuation Journal Entry BELNR
LedgerGLLineItem Foreign Currency Valuation Journal Entry Item DOCLN6
ALLOWANCETYPE Valuation Line Type TEXT70
FinClosingLineItemStatusIcon Financial Closing Run Type Text CHAR60
FinClosingLineItemStatusName Financial Closing Run Type Text CHAR60
IsReversed Is Reversed CHAR010
FinClsgLineItmDetailStatusName Financial Closing Run Type Text DDTEXT
GLAccountText G/L Account Name CHAR30
IsOpenItemManaged Managed on an Open Item Basis CHAR010
GROUPID Group ID for Grouping Journal Entry Line Items CLS_RUN_GROUP_ID
GROUPRULE Rule for Grouping Journal Entry Line Items for Valuation FINS_VAL_GROUPING_RULE
GROUPRULESTEP Step of a Grouping Rule NUMC4
PredecessorJournalEntry Journal Entry BELNR
PredecessorJournalEntryItem Ledger Journal Entry Item DOCLN6
PrdcssrJournalEntryFiscalYear Fiscal Year GJAHR
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
OriginalExchangeRate Historical Exchange Rate KURSP
ValuationExchangeRate Key Date Exchange Rate KURSP
SalesOrderItem Sales Document Item POSNR
SupplierName Name of Supplier TEXT80
CustomerName Name of Customer TEXT80
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
RelatedNetworkActivity Network activity VORNR
PartnerVenture Partner Venture JV_NAME
FinancialValuationObject Financial Valuation Object VAL_OBJ_ID
FinancialValuationSubobject Financial Valuation Subobject VAL_SUBOBJ_ID
OffsettingAccount Offsetting Account GKONT
FiscalPeriod Fiscal Period POPER
InvoiceItemReference Invoice Item Reference BUZEI
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FinClosingEntryCalculationType Financial Closing Entry Calculation Type CLS_RUN_CALCULATION_TYPE
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Area
  • Business Area
  • Client
  • P_FI_CLS_FXV_RL.BUSINESSAREA == TGSB.GSBER
  • P_FI_CLS_FXV_RL.MANDT == TGSB.MANDT
Business Process
  • Business Process
  • Client
  • ?
  • Controlling Area
  • P_FI_CLS_FXV_RL.BUSINESSPROCESS == CBPR.PRZNR
  • P_FI_CLS_FXV_RL.MANDT == CBPR.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "DATBI"] == CBPR.DATBI
  • P_FI_CLS_FXV_RL.CONTROLLINGAREA == CBPR.KOKRS
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_FI_CLS_FXV_RL.MANDT == T004.MANDT
  • P_FI_CLS_FXV_RL.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_FI_CLS_FXV_RL.MANDT == T001.MANDT
  • P_FI_CLS_FXV_RL.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_FI_CLS_FXV_RL.MANDT == TKA01.MANDT
  • P_FI_CLS_FXV_RL.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Cost Center
  • Controlling Area
  • P_FI_CLS_FXV_RL.MANDT == CSKS.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "DATBI"] == CSKS.DATBI
  • P_FI_CLS_FXV_RL.COSTCENTER == CSKS.KOSTL
  • P_FI_CLS_FXV_RL.CONTROLLINGAREA == CSKS.KOKRS
Activity Type
  • Client
  • ?
  • Activity Type
  • Controlling Area
  • P_FI_CLS_FXV_RL.MANDT == CSLA.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "DATBI"] == CSLA.DATBI
  • P_FI_CLS_FXV_RL.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_FI_CLS_FXV_RL.CONTROLLINGAREA == CSLA.KOKRS
Cost Object
  • Client
  • ?
  • Cost Object
  • P_FI_CLS_FXV_RL.MANDT == CKPH.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "DATBI"] == CKPH.DATBI
  • P_FI_CLS_FXV_RL.COSTOBJECT == CKPH.KSTRG
Customer Number
  • Client
  • Customer Number
  • P_FI_CLS_FXV_RL.MANDT == KNA1.MANDT
  • P_FI_CLS_FXV_RL.CUSTOMER == KNA1.KUNNR
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_FI_CLS_FXV_RL.MANDT == T856.MANDT
  • P_FI_CLS_FXV_RL.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Financial Valuation Object Type
  • Client
  • Financial Valuation Object Type
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • P_FI_CLS_FXV_RL.MANDT == TFKB.MANDT
  • P_FI_CLS_FXV_RL.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • P_FI_CLS_FXV_RL.MANDT == SKB1.MANDT
  • P_FI_CLS_FXV_RL.GLACCOUNT == SKB1.SAKNR
  • P_FI_CLS_FXV_RL.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_FI_CLS_FXV_RL.MANDT == TCURC.MANDT
  • P_FI_CLS_FXV_RL.GLOBALCURRENCY == TCURC.WAERS
House Bank Key
  • Client
  • ?
  • House Bank Key
  • P_FI_CLS_FXV_RL.MANDT == T012.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "BUKRS"] == T012.BUKRS
  • P_FI_CLS_FXV_RL.HOUSEBANK == T012.HBKID
House Bank Account
  • Client
  • House Bank Account
  • ?
  • House Bank Key
  • P_FI_CLS_FXV_RL.MANDT == T012K.MANDT
  • P_FI_CLS_FXV_RL.HOUSEBANKACCOUNT == T012K.HKTID
  • P_FI_CLS_FXV_RL.[column in domain "BUKRS"] == T012K.BUKRS
  • P_FI_CLS_FXV_RL.HOUSEBANK == T012K.HBKID
Joint venture
  • Client
  • ?
  • Joint venture
  • P_FI_CLS_FXV_RL.MANDT == T8JV.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "BUKRS"] == T8JV.BUKRS
  • P_FI_CLS_FXV_RL.JOINTVENTURE == T8JV.VNAME
Joint Venture Cost Recovery Code
  • Client
  • Joint Venture Cost Recovery Code
  • ?
  • P_FI_CLS_FXV_RL.MANDT == T8JJ.MANDT
  • P_FI_CLS_FXV_RL.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_FI_CLS_FXV_RL.[column in domain "BUKRS"] == T8JJ.BUKRS
Joint Venture Equity Group
  • Joint Venture Equity Group
  • Client
  • ?
  • Joint venture
  • P_FI_CLS_FXV_RL.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • P_FI_CLS_FXV_RL.MANDT == T8JF.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "BUKRS"] == T8JF.BUKRS
  • P_FI_CLS_FXV_RL.JOINTVENTURE == T8JF.VNAME
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • P_FI_CLS_FXV_RL.MANDT == KNA1.MANDT
  • P_FI_CLS_FXV_RL.JOINTVENTUREPARTNER == KNA1.KUNNR
UUID of Financial Closing Run
  • ?
  • UUID of Financial Closing Run
  • P_FI_CLS_FXV_RL.[column in domain ""] == FINS_CLS_RUN.CLIENT
  • P_FI_CLS_FXV_RL.JRNLPERIODENDCLOSINGRUNLOGUUID == FINS_CLS_RUN.JRNLPERIODENDCLOSINGRUNLOGUUID
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Order ID
  • Client
  • Order ID
  • P_FI_CLS_FXV_RL.MANDT == AUFK.MANDT
  • P_FI_CLS_FXV_RL.ORDERID == AUFK.AUFNR
Partner Business Area
  • Client
  • Partner Business Area
  • P_FI_CLS_FXV_RL.MANDT == TGSB.MANDT
  • P_FI_CLS_FXV_RL.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_FI_CLS_FXV_RL.MANDT == T880.MANDT
  • P_FI_CLS_FXV_RL.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • Partner Cost Center
  • ?
  • Controlling Area
  • P_FI_CLS_FXV_RL.MANDT == CSKS.MANDT
  • P_FI_CLS_FXV_RL.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_FI_CLS_FXV_RL.[column in domain "DATBI"] == CSKS.DATBI
  • P_FI_CLS_FXV_RL.CONTROLLINGAREA == CSKS.KOKRS
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_FI_CLS_FXV_RL.MANDT == TFKB.MANDT
  • P_FI_CLS_FXV_RL.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Profit Center
  • Client
  • ?
  • Partner Profit Center
  • Controlling Area
  • P_FI_CLS_FXV_RL.MANDT == CEPC.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "DATBI"] == CEPC.DATBI
  • P_FI_CLS_FXV_RL.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_FI_CLS_FXV_RL.CONTROLLINGAREA == CEPC.KOKRS
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_FI_CLS_FXV_RL.MANDT == FAGL_SEGM.MANDT
  • P_FI_CLS_FXV_RL.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Preceding Journal Entry Company Code
  • Client
  • Preceding Journal Entry Company Code
  • P_FI_CLS_FXV_RL.MANDT == T001.MANDT
  • P_FI_CLS_FXV_RL.PRDCSSRJOURNALENTRYCOMPANYCODE == T001.BUKRS
Profit Center
  • Client
  • ?
  • Profit Center
  • Controlling Area
  • P_FI_CLS_FXV_RL.MANDT == CEPC.MANDT
  • P_FI_CLS_FXV_RL.[column in domain "DATBI"] == CEPC.DATBI
  • P_FI_CLS_FXV_RL.PROFITCENTER == CEPC.PRCTR
  • P_FI_CLS_FXV_RL.CONTROLLINGAREA == CEPC.KOKRS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • P_FI_CLS_FXV_RL.MANDT == AUFK.MANDT
  • P_FI_CLS_FXV_RL.PROJECTNETWORK == AUFK.AUFNR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Supplier
  • Supplier
  • Client
  • P_FI_CLS_FXV_RL.SUPPLIER == LFA1.LIFNR
  • P_FI_CLS_FXV_RL.MANDT == LFA1.MANDT