ValuationValuationItems

Impairment postings | view: VALVALUATION | Extraction: Not supported | Component: Closing Operations / Period-End
Tables used: SCAL_TT_DATE, ACDOCA, FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
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
Column Name Description
Column Name Description
netduedate Net Due Date
postingdate Posting Date
DocumentDate Journal Entry Date
OriginalPostingDate Posting Date
ClearingDate Clearing Date
Column Name Description
isopenitemmanaged Managed on an Open Item Basis Show values
AccountingDocumentCategory Journal Entry Category Show values
IsReversal Indicator: Item is Reversing Another Item Show values
financialclosinglineitemtype Financial Closing Run Type Show values
IsClearedAtKeyDate The open item was cleared in current period before key date Show values
Column Name Description Domain name
group_id Group ID for Grouping Journal Entry Line Items CLS_RUN_GROUP_ID
grouping_rule Rule for Grouping Journal Entry Line Items for Valuation FINS_VAL_GROUPING_RULE
grouping_rule_step Step of a Grouping Rule NUMC4
chartofaccounts Chart of Accounts KTOPL
marked_for_deletion Entries are marked to be deleted CHAR1
PredecessorReferenceDocCntxt Predecessor Reference Document Context AWORG
PredecessorReferenceDocument Predecessor Reference Document AWREF
PredecessorReferenceDocItem Predecessor Reference Document Item NUMC6
PrdcssrJournalEntryFiscalYear Preceding Journal Entry Fiscal Year GJAHR
PredecessorJournalEntry Preceding Journal Entry Document Number BELNR
PredecessorJournalEntryItem Preceding Journal Entry Line Item DOCLN6
businesspartner Business Partner Number BU_PARTNER
invoiceitemreference Invoice Item Reference BUZEI
invoicereference Invoice Reference BELNR
invoicereferencefiscalyear Invoice Reference Fiscal Year GJAHR
line_type null
CreationDateTime Time Stamp of Creation TZNTSTMPS
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
finclosinglineitemprocessstep 30 Characters CHAR30
jrnlperiodendclosingrunloguuid UUID of Financial Closing Run UUID
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
AssignmentReference Assignment Reference ZUONR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerVenture Partner Venture JV_NAME
RelatedNetworkActivity Network activity VORNR
SalesOrderItem Sales Document Item POSNR
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
GrantID Grant GM_GRANT_NBR
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
WBSElement WBS Element FIS_WBS
PartnerGrant Partner Grant GM_GRANT_NBR
relatednetworkactivityinternal Closing run Internal hepler field for NPLNR_VORGN CHAR33
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Budget Period
  • Client
  • ?
  • Budget Period
  • Fund
  • VALUATIONVALUATIONITEMS.MANDT == FMFUNDBPD.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • VALUATIONVALUATIONITEMS.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • VALUATIONVALUATIONITEMS.FUND == FMFUNDBPD.FINCODE
Business Area
  • Client
  • Business Area
  • VALUATIONVALUATIONITEMS.MANDT == TGSB.MANDT
  • VALUATIONVALUATIONITEMS.BUSINESSAREA == TGSB.GSBER
Business Process
  • Client
  • ?
  • Controlling Area
  • Business Process
  • VALUATIONVALUATIONITEMS.MANDT == CBPR.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "DATBI"] == CBPR.DATBI
  • VALUATIONVALUATIONITEMS.CONTROLLINGAREA == CBPR.KOKRS
  • VALUATIONVALUATIONITEMS.BUSINESSPROCESS == CBPR.PRZNR
Business Transaction Category
  • Client
  • Business Transaction Category
  • VALUATIONVALUATIONITEMS.MANDT == FINSC_BTTYPE.MANDT
  • VALUATIONVALUATIONITEMS.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE
Cash Origin Account
  • Client
  • Cash Origin Account
  • ?
  • VALUATIONVALUATIONITEMS.MANDT == SKA1.MANDT
  • VALUATIONVALUATIONITEMS.CASHLEDGERACCOUNT == SKA1.SAKNR
  • VALUATIONVALUATIONITEMS.[column in domain "KTOPL"] == SKA1.KTOPL
Cash Origin Company Code
  • Client
  • Cash Origin Company Code
  • VALUATIONVALUATIONITEMS.MANDT == T001.MANDT
  • VALUATIONVALUATIONITEMS.CASHLEDGERCOMPANYCODE == T001.BUKRS
Company Code
  • Client
  • Company Code
  • VALUATIONVALUATIONITEMS.MANDT == T001.MANDT
  • VALUATIONVALUATIONITEMS.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • VALUATIONVALUATIONITEMS.MANDT == TKA01.MANDT
  • VALUATIONVALUATIONITEMS.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • VALUATIONVALUATIONITEMS.MANDT == CSKS.MANDT
  • VALUATIONVALUATIONITEMS.COSTCENTER == CSKS.KOSTL
  • VALUATIONVALUATIONITEMS.[column in domain "DATBI"] == CSKS.DATBI
  • VALUATIONVALUATIONITEMS.CONTROLLINGAREA == CSKS.KOKRS
Activity Type
  • Client
  • ?
  • Controlling Area
  • Activity Type
  • VALUATIONVALUATIONITEMS.MANDT == CSLA.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "DATBI"] == CSLA.DATBI
  • VALUATIONVALUATIONITEMS.CONTROLLINGAREA == CSLA.KOKRS
  • VALUATIONVALUATIONITEMS.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Cost Object
  • Client
  • ?
  • Cost Object
  • VALUATIONVALUATIONITEMS.MANDT == CKPH.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "DATBI"] == CKPH.DATBI
  • VALUATIONVALUATIONITEMS.COSTOBJECT == CKPH.KSTRG
Credit Risk Class
  • Client
  • Credit Risk Class
  • VALUATIONVALUATIONITEMS.MANDT == UKM_RISK_CL.CLIENT
  • VALUATIONVALUATIONITEMS.CREDITRISKCLASS == UKM_RISK_CL.RISK_CLASS
Customer Number
  • Client
  • Customer Number
  • VALUATIONVALUATIONITEMS.MANDT == KNA1.MANDT
  • VALUATIONVALUATIONITEMS.CUSTOMER == KNA1.KUNNR
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • VALUATIONVALUATIONITEMS.MANDT == T856.MANDT
  • VALUATIONVALUATIONITEMS.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Financial Valuation Object Type
  • Client
  • Financial Valuation Object Type
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • VALUATIONVALUATIONITEMS.MANDT == TFKB.MANDT
  • VALUATIONVALUATIONITEMS.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • ?
  • Fund
  • VALUATIONVALUATIONITEMS.MANDT == FMFINCODE.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • VALUATIONVALUATIONITEMS.FUND == FMFINCODE.FINCODE
G/L Account
  • G/L Account
  • Client
  • Company Code
  • VALUATIONVALUATIONITEMS.GLACCOUNT == SKB1.SAKNR
  • VALUATIONVALUATIONITEMS.MANDT == SKB1.MANDT
  • VALUATIONVALUATIONITEMS.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • VALUATIONVALUATIONITEMS.MANDT == TCURC.MANDT
  • VALUATIONVALUATIONITEMS.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • Client
  • ?
  • Joint venture
  • VALUATIONVALUATIONITEMS.MANDT == T8JV.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "BUKRS"] == T8JV.BUKRS
  • VALUATIONVALUATIONITEMS.JOINTVENTURE == T8JV.VNAME
Joint Venture Cost Recovery Code
  • Client
  • ?
  • Joint Venture Cost Recovery Code
  • VALUATIONVALUATIONITEMS.MANDT == T8JJ.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "BUKRS"] == T8JJ.BUKRS
  • VALUATIONVALUATIONITEMS.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Joint Venture Equity Group
  • Client
  • ?
  • Joint Venture Equity Group
  • Joint venture
  • VALUATIONVALUATIONITEMS.MANDT == T8JF.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "BUKRS"] == T8JF.BUKRS
  • VALUATIONVALUATIONITEMS.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • VALUATIONVALUATIONITEMS.JOINTVENTURE == T8JF.VNAME
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • VALUATIONVALUATIONITEMS.MANDT == KNA1.MANDT
  • VALUATIONVALUATIONITEMS.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Order ID
  • Client
  • VALUATIONVALUATIONITEMS.ORDERID == AUFK.AUFNR
  • VALUATIONVALUATIONITEMS.MANDT == AUFK.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • VALUATIONVALUATIONITEMS.MANDT == TGSB.MANDT
  • VALUATIONVALUATIONITEMS.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • VALUATIONVALUATIONITEMS.MANDT == T880.MANDT
  • VALUATIONVALUATIONITEMS.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • Client
  • ?
  • Controlling Area
  • Partner Cost Center
  • VALUATIONVALUATIONITEMS.MANDT == CSKS.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "DATBI"] == CSKS.DATBI
  • VALUATIONVALUATIONITEMS.CONTROLLINGAREA == CSKS.KOKRS
  • VALUATIONVALUATIONITEMS.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • VALUATIONVALUATIONITEMS.MANDT == TFKB.MANDT
  • VALUATIONVALUATIONITEMS.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Fund
  • Client
  • ?
  • Partner Fund
  • VALUATIONVALUATIONITEMS.MANDT == FMFINCODE.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • VALUATIONVALUATIONITEMS.PARTNERFUND == FMFINCODE.FINCODE
Partner Profit Center
  • Client
  • ?
  • Controlling Area
  • Partner Profit Center
  • VALUATIONVALUATIONITEMS.MANDT == CEPC.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • VALUATIONVALUATIONITEMS.CONTROLLINGAREA == CEPC.KOKRS
  • VALUATIONVALUATIONITEMS.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • VALUATIONVALUATIONITEMS.MANDT == FAGL_SEGM.MANDT
  • VALUATIONVALUATIONITEMS.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • VALUATIONVALUATIONITEMS.MANDT == T001W.MANDT
  • VALUATIONVALUATIONITEMS.PLANT == T001W.WERKS
Preceding Journal Entry Company Code
  • Client
  • Preceding Journal Entry Company Code
  • VALUATIONVALUATIONITEMS.MANDT == T001.MANDT
  • VALUATIONVALUATIONITEMS.PRDCSSRJOURNALENTRYCOMPANYCODE == T001.BUKRS
Product Number
  • Client
  • Product Number
  • VALUATIONVALUATIONITEMS.MANDT == MARA.MANDT
  • VALUATIONVALUATIONITEMS.PRODUCT == MARA.MATNR
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • VALUATIONVALUATIONITEMS.MANDT == CEPC.MANDT
  • VALUATIONVALUATIONITEMS.[column in domain "DATBI"] == CEPC.DATBI
  • VALUATIONVALUATIONITEMS.CONTROLLINGAREA == CEPC.KOKRS
  • VALUATIONVALUATIONITEMS.PROFITCENTER == CEPC.PRCTR
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • VALUATIONVALUATIONITEMS.MANDT == AUFK.MANDT
  • VALUATIONVALUATIONITEMS.PROJECTNETWORK == AUFK.AUFNR
Budget Account
  • Client
  • Budget Account
  • ?
  • VALUATIONVALUATIONITEMS.MANDT == SKA1.MANDT
  • VALUATIONVALUATIONITEMS.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • VALUATIONVALUATIONITEMS.[column in domain "KTOPL"] == SKA1.KTOPL
Reference Document Type VALUATIONVALUATIONITEMS.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • VALUATIONVALUATIONITEMS.MANDT == FAGL_SEGM.MANDT
  • VALUATIONVALUATIONITEMS.SEGMENT == FAGL_SEGM.SEGMENT
Ship-to Party
  • Client
  • Ship-to Party
  • VALUATIONVALUATIONITEMS.MANDT == KNA1.MANDT
  • VALUATIONVALUATIONITEMS.SHIPTOPARTY == KNA1.KUNNR
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Subledger-Specific Line Item Type VALUATIONVALUATIONITEMS.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Client
  • Supplier
  • VALUATIONVALUATIONITEMS.MANDT == LFA1.MANDT
  • VALUATIONVALUATIONITEMS.SUPPLIER == LFA1.LIFNR