P_FIVALUATIONRESULTLIST

Output common FI valuation | view: PFIVALRESULT | Extraction: Not supported | Component: Closing Operations / Period-End
Tables used: SCAL_TT_DATE, ACDOCTEMP, ACDOCA, FINS_CLS_RUN_RL2, FINSC_LEDGER_REP
Column Name Description
JrnlPerdEndClsgRunResultUUID Financial Closing Run Message ID
Column Name Description
💲 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
💲 Freely Defined Currency 1 (FinClsgRunRsltFDCrcy1):
FinClsgRunRsltAmtInFDCrcy1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FinClsgRunRsltFDCrcy2):
FinClsgRunRsltAmtInFDCrcy2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FinClsgRunRsltFDCrcy3):
FinClsgRunRsltAmtInFDCrcy3 Amount in Freely Defined Currency 3
FinClsgRunRsltAmtInFDCrcy4 Amount in Freely Defined Currency 4
FinClsgRunRsltAmtInFDCrcy5 Amount in Freely Defined Currency 5
FinClsgRunRsltAmtInFDCrcy6 Amount in Freely Defined Currency 6
FinClsgRunRsltAmtInFDCrcy7 Amount in Freely Defined Currency 7
Column Name Description
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
NetDueDate Net Due Date
OldestOpenItemNetDueDate Net due date of the oldest open item
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
FinancialClosingLineItemType Financial Closing Run Type Show values
FinancialClosingLineItemStatus Financial Closing Run Line Item Status Show values
FinClosingLineItemDetailStatus Financial Closing Run Line Item Status Detail Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
SalesOrderItem Sales Document Item POSNR
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
REBusinessEntity RE Business Entity REBDVDMBENO
RealEstateBuilding Real Estate Building REBDVDMBUNO
RealEstateProperty Real Estate Property REBDVDMPRNO
OffsettingAccount Offsetting Account GKONT
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
FiscalPeriod Fiscal Period POPER
PrdcssrJournalEntryFiscalYear Preceding Journal Entry Fiscal Year GJAHR
PredecessorJournalEntry Preceding Journal Entry Document Number BELNR
PredecessorJournalEntryItem Preceding Journal Entry Line Item DOCLN6
InvoiceItemReference Invoice Item Reference BUZEI
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ExchangeRate Key Date Exchange Rate KURSP
FinClosingRunIsTestExecution Run is Executed in Test Mode CHAR1
FinClosingEntryCalculationType Financial Closing Entry Calculation Type CLS_RUN_CALCULATION_TYPE
CreditRiskClass Credit Risk Class UKM_RISK_CLASS
GeneralLedgerAgingIncrement Aging Increment FINS_INCRMNT
ExpectedCreditLossPercent Expected Credit Loss Percentage
FinancialClosingGroupingRule Rule for Grouping Journal Entry Line Items for Valuation FINS_VAL_GROUPING_RULE
FinClosingGroupingRuleStep Step of a Grouping Rule NUMC4
FinancialClosingGrouping Group ID for Grouping Journal Entry Line Items CLS_RUN_GROUP_ID
InterestCalculationCode Interest Indicator VZSKZ
DiscountingAnnualInterestRate Discounting Interest Rate per Annum
DiscgFiscalPeriodInterestRate Discounting Interest Rate per Fiscal Period
DiscgDurationInFiscalPeriods Discounting Duration in Fiscal Periods
NrOfDiscountedFiscalPeriods Discounting Cumulative Fiscal Periods
LongTrmAstLbltyDiscountFactor Discounting Discounting Factor
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Area
  • Business Area
  • Client
  • P_FIVALUATIONRESULTLIST.BUSINESSAREA == TGSB.GSBER
  • P_FIVALUATIONRESULTLIST.MANDT == TGSB.MANDT
Business Process
  • Controlling Area
  • Business Process
  • ?
  • Client
  • P_FIVALUATIONRESULTLIST.CONTROLLINGAREA == CBPR.KOKRS
  • P_FIVALUATIONRESULTLIST.BUSINESSPROCESS == CBPR.PRZNR
  • P_FIVALUATIONRESULTLIST.[column in domain "DATBI"] == CBPR.DATBI
  • P_FIVALUATIONRESULTLIST.MANDT == CBPR.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_FIVALUATIONRESULTLIST.MANDT == T004.MANDT
  • P_FIVALUATIONRESULTLIST.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_FIVALUATIONRESULTLIST.MANDT == T001.MANDT
  • P_FIVALUATIONRESULTLIST.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • P_FIVALUATIONRESULTLIST.COMPANYCODECURRENCY == TCURC.WAERS
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_FIVALUATIONRESULTLIST.CONTROLLINGAREA == TKA01.KOKRS
  • P_FIVALUATIONRESULTLIST.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Cost Center
  • ?
  • Client
  • P_FIVALUATIONRESULTLIST.CONTROLLINGAREA == CSKS.KOKRS
  • P_FIVALUATIONRESULTLIST.COSTCENTER == CSKS.KOSTL
  • P_FIVALUATIONRESULTLIST.[column in domain "DATBI"] == CSKS.DATBI
  • P_FIVALUATIONRESULTLIST.MANDT == CSKS.MANDT
Activity Type
  • Controlling Area
  • Activity Type
  • ?
  • Client
  • P_FIVALUATIONRESULTLIST.CONTROLLINGAREA == CSLA.KOKRS
  • P_FIVALUATIONRESULTLIST.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_FIVALUATIONRESULTLIST.[column in domain "DATBI"] == CSLA.DATBI
  • P_FIVALUATIONRESULTLIST.MANDT == CSLA.MANDT
Cost Object
  • ?
  • Client
  • Cost Object
  • P_FIVALUATIONRESULTLIST.[column in domain "DATBI"] == CKPH.DATBI
  • P_FIVALUATIONRESULTLIST.MANDT == CKPH.MANDT
  • P_FIVALUATIONRESULTLIST.COSTOBJECT == CKPH.KSTRG
Customer Number
  • Customer Number
  • Client
  • P_FIVALUATIONRESULTLIST.CUSTOMER == KNA1.KUNNR
  • P_FIVALUATIONRESULTLIST.MANDT == KNA1.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_FIVALUATIONRESULTLIST.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_FIVALUATIONRESULTLIST.MANDT == T856.MANDT
Financial Valuation Object Type
  • Financial Valuation Object Type
  • Client
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • P_FIVALUATIONRESULTLIST.FUNCTIONALAREA == TFKB.FKBER
  • P_FIVALUATIONRESULTLIST.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_FIVALUATIONRESULTLIST.GLACCOUNT == SKB1.SAKNR
  • P_FIVALUATIONRESULTLIST.MANDT == SKB1.MANDT
  • P_FIVALUATIONRESULTLIST.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_FIVALUATIONRESULTLIST.MANDT == TCURC.MANDT
  • P_FIVALUATIONRESULTLIST.GLOBALCURRENCY == TCURC.WAERS
House Bank Key
  • ?
  • House Bank Key
  • Client
  • P_FIVALUATIONRESULTLIST.[column in domain "BUKRS"] == T012.BUKRS
  • P_FIVALUATIONRESULTLIST.HOUSEBANK == T012.HBKID
  • P_FIVALUATIONRESULTLIST.MANDT == T012.MANDT
House Bank Account
  • House Bank Account
  • ?
  • House Bank Key
  • Client
  • P_FIVALUATIONRESULTLIST.HOUSEBANKACCOUNT == T012K.HKTID
  • P_FIVALUATIONRESULTLIST.[column in domain "BUKRS"] == T012K.BUKRS
  • P_FIVALUATIONRESULTLIST.HOUSEBANK == T012K.HBKID
  • P_FIVALUATIONRESULTLIST.MANDT == T012K.MANDT
Joint venture
  • ?
  • Client
  • Joint venture
  • P_FIVALUATIONRESULTLIST.[column in domain "BUKRS"] == T8JV.BUKRS
  • P_FIVALUATIONRESULTLIST.MANDT == T8JV.MANDT
  • P_FIVALUATIONRESULTLIST.JOINTVENTURE == T8JV.VNAME
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • ?
  • Client
  • P_FIVALUATIONRESULTLIST.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • P_FIVALUATIONRESULTLIST.[column in domain "BUKRS"] == T8JJ.BUKRS
  • P_FIVALUATIONRESULTLIST.MANDT == T8JJ.MANDT
Joint Venture Equity Group
  • ?
  • Joint Venture Equity Group
  • Client
  • Joint venture
  • P_FIVALUATIONRESULTLIST.[column in domain "BUKRS"] == T8JF.BUKRS
  • P_FIVALUATIONRESULTLIST.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • P_FIVALUATIONRESULTLIST.MANDT == T8JF.MANDT
  • P_FIVALUATIONRESULTLIST.JOINTVENTURE == T8JF.VNAME
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • P_FIVALUATIONRESULTLIST.MANDT == KNA1.MANDT
  • P_FIVALUATIONRESULTLIST.JOINTVENTUREPARTNER == KNA1.KUNNR
UUID of Financial Closing Run
  • ?
  • UUID of Financial Closing Run
  • P_FIVALUATIONRESULTLIST.[column in domain ""] == FINS_CLS_RUN.CLIENT
  • P_FIVALUATIONRESULTLIST.JRNLPERIODENDCLOSINGRUNLOGUUID == FINS_CLS_RUN.JRNLPERIODENDCLOSINGRUNLOGUUID
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order ID
  • Order ID
  • Client
  • P_FIVALUATIONRESULTLIST.ORDERID == AUFK.AUFNR
  • P_FIVALUATIONRESULTLIST.MANDT == AUFK.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • P_FIVALUATIONRESULTLIST.PARTNERBUSINESSAREA == TGSB.GSBER
  • P_FIVALUATIONRESULTLIST.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_FIVALUATIONRESULTLIST.PARTNERCOMPANY == T880.RCOMP
  • P_FIVALUATIONRESULTLIST.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • ?
  • Client
  • Partner Cost Center
  • P_FIVALUATIONRESULTLIST.CONTROLLINGAREA == CSKS.KOKRS
  • P_FIVALUATIONRESULTLIST.[column in domain "DATBI"] == CSKS.DATBI
  • P_FIVALUATIONRESULTLIST.MANDT == CSKS.MANDT
  • P_FIVALUATIONRESULTLIST.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_FIVALUATIONRESULTLIST.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_FIVALUATIONRESULTLIST.MANDT == TFKB.MANDT
Partner Profit Center
  • Controlling Area
  • ?
  • Partner Profit Center
  • Client
  • P_FIVALUATIONRESULTLIST.CONTROLLINGAREA == CEPC.KOKRS
  • P_FIVALUATIONRESULTLIST.[column in domain "DATBI"] == CEPC.DATBI
  • P_FIVALUATIONRESULTLIST.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_FIVALUATIONRESULTLIST.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_FIVALUATIONRESULTLIST.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_FIVALUATIONRESULTLIST.MANDT == FAGL_SEGM.MANDT
Preceding Journal Entry Company Code
  • Preceding Journal Entry Company Code
  • Client
  • P_FIVALUATIONRESULTLIST.PRDCSSRJOURNALENTRYCOMPANYCODE == T001.BUKRS
  • P_FIVALUATIONRESULTLIST.MANDT == T001.MANDT
Profit Center
  • Controlling Area
  • ?
  • Client
  • Profit Center
  • P_FIVALUATIONRESULTLIST.CONTROLLINGAREA == CEPC.KOKRS
  • P_FIVALUATIONRESULTLIST.[column in domain "DATBI"] == CEPC.DATBI
  • P_FIVALUATIONRESULTLIST.MANDT == CEPC.MANDT
  • P_FIVALUATIONRESULTLIST.PROFITCENTER == CEPC.PRCTR
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • P_FIVALUATIONRESULTLIST.MANDT == AUFK.MANDT
  • P_FIVALUATIONRESULTLIST.PROJECTNETWORK == AUFK.AUFNR
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_FIVALUATIONRESULTLIST.MANDT == FAGL_SEGM.MANDT
  • P_FIVALUATIONRESULTLIST.SEGMENT == FAGL_SEGM.SEGMENT
Subledger-Specific Line Item Type P_FIVALUATIONRESULTLIST.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Supplier
  • Client
  • P_FIVALUATIONRESULTLIST.SUPPLIER == LFA1.LIFNR
  • P_FIVALUATIONRESULTLIST.MANDT == LFA1.MANDT