VALUATIONREORGLINEITEM

Valuation run: reorged invoices | view: PVALREORG | Extraction: Not supported | Component: Closing Operations / Period-End
Tables used: SCAL_TT_DATE, ACDOCA, FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
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
OriginalPostingDate Posting Date
PostingDate Posting Date
DocumentDate Journal Entry Date
netduedate Net Due Date
oldestopenitemnetduedate Net due date of the oldest open item
clearingdate Clearing Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
accountingdocumentcategory Journal Entry Category Show values
isopenitemmanaged Managed on an Open Item Basis Show values
ISCLEAREDATKEYDATE The open item was cleared in current period before key date Show values
debitcreditcode Debit/Credit Code Show values
financialclosinglineitemstatus Financial Closing Run Line Item Status Show values
financialclosinglineitemtype Financial Closing Run Type Show values
line_item_status_detail Financial Closing Run Line Item Status Detail Show values
FinancialAccountType Account type Show values
GLAccountType Type of a General Ledger Account Show values
Column Name Description Domain name
CreationDateTime Time Stamp of Creation TZNTSTMPS
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
PredecessorJournalEntry Preceding Journal Entry Document Number BELNR
PrdcssrJournalEntryFiscalYear Preceding Journal Entry Fiscal Year GJAHR
PredecessorJournalEntryItem Preceding Journal Entry Line Item DOCLN6
postingkey Posting Key BSCHL
jrnlperiodendclosingrunloguuid UUID of Financial Closing Run UUID
currentfiscalyear Fiscal Year GJAHR
newaccountingdocument Journal Entry BELNR
newledgergllineitem Ledger Journal Entry Item DOCLN6
accountingprinciple Accounting Principle for Ledger/Company Code ACCOUNTING_PRINCIPLE
financialvaluationobjecttype Type of the Financial Valuation Object VAL_OBJ_TYPE
financialvaluationobject Identifier of the Financial Valuation Object VAL_OBJ_ID
financialvaluationsubobject Identifier of the Financial Valuation Subobject VAL_SUBOBJ_ID
chartofaccounts Chart of Accounts KTOPL
offsettingaccount Unrealized Loss from Foreign Currency Valuation SAKNR
exchangerate Key Date Exchange Rate KURSP
assignmentreference Assignment number ZUONR
businesspartner Business Partner Number BU_PARTNER
predecessorreferencedoctype Preceding Document Reference Transaction AWTYP
predecessorreferencedoccntxt Preceding Document Reference Organizational Units AWORG
predecessorreferencedocument Preceding Document Reference Document Number AWREF
predecessorreferencedocitem Preceding Reference Document Line Item NUMC6
prdcssrjournalentrycompanycode Preceding Journal Entry Company Code BUKRS
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
clearingaccountingdocument Clearing Journal Entry BELNR
clearingdocfiscalyear Fiscal Year of Clearing Journal Entry GJAHR
housebank House Bank Key HBKID
housebankaccount House Bank Account HKTID
costctractivitytype Activity Type LSTAR
wbselementinternalid WBS Element Internal ID FIS_WBSINT_NO_CONV
financialtransactiontype Financial Transaction Type RMVCT
jointventure Joint venture JV_NAME
jointventureequitygroup Joint Venture Equity Group JV_EGROUP
partnerventure Partner Venture JV_NAME
jointventurepartner Joint Venture Partner KUNNR
jointventurecostrecoverycode Joint Venture Cost Recovery Code JV_RECIND
projectnetwork Network Number for Account Assignment AUFNR
relatednetworkactivity Network activity VORNR
orderid Order ID AUFNR
businessprocess Business Process CO_PRZNR
salesorder Sales Order VBELN
salesorderitem Sales Order Item POSNR
costobject Cost Object KSTRG
costcenter Cost Center KOSTL
profitcenter Profit Center PRCTR
functionalarea Functional Area FKBER
businessarea Business Area GSBER
controllingarea Controlling Area CACCD
segment Segment for Segmental Reporting FB_SEGMENT
partnercostcenter Partner Cost Center KOSTL
partnerprofitcenter Partner Profit Center PRCTR
partnerfunctionalarea Partner Functional Area FKBER
partnerbusinessarea Partner Business Area GSBER
partnercompany Company ID of Trading Partner RCOMP
partnersegment Partner Segment for Segmental Reporting FB_SEGMENT
supplier Supplier LIFNR
customer Customer Number KUNNR
wbselement WBS Element FIS_WBS
rebusinessentity Business Entity Number REBDBENO
realestatebuilding Number of Building REBDBUNO
realestateproperty Number of Land REBDPRNO
fund Fund BP_GEBER
budgetperiod Budget Period FM_BUDGET_PERIOD
grantid Grant GM_GRANT_NBR
pubsecbudgetaccount Budget Account SAKNR
cashledgeraccount Cash Origin Account SAKNR
sponsoredprogram Sponsored Program GM_SPONSORED_PROG
sponsoredclass Sponsored Class GM_SPONSORED_CLASS
plant Plant WERKS
product Material Number MATNR
shiptoparty Ship-to Party KUNNR
relatednetworkactivityinternal Closing run Internal hepler field for NPLNR_VORGN CHAR33
finclosinglineitemprocessstep 30 Characters CHAR30
finclosingentrycalculationtype Financial Closing Entry Calculation Type CLS_RUN_CALCULATION_TYPE
line_type Financial closing valuation line type CHAR50
creditriskclass Credit Risk Class UKM_RISK_CLASS
taxcode Tax on Sales/Purchases Code MWSKZ
taxcountry Tax Reporting Country/Region LAND1
partnerfund Partner Fund BP_GEBER
partnergrant Partner Grant GM_GRANT_NBR
cashledgercompanycode Cash Origin Company Code BUKRS
customer_supplier_group_key Group key KONZS
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
marked_for_deletion Entries are marked to be deleted CHAR1
Master Data Relations Join Conditions
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • VALUATIONREORGLINEITEM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • VALUATIONREORGLINEITEM.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE
  • VALUATIONREORGLINEITEM.MANDT == FINSC_BTTYPE.MANDT
Company Code
  • Company Code
  • Client
  • VALUATIONREORGLINEITEM.COMPANYCODE == T001.BUKRS
  • VALUATIONREORGLINEITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
  • VALUATIONREORGLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • VALUATIONREORGLINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • VALUATIONREORGLINEITEM.GLACCOUNT == SKB1.SAKNR
  • VALUATIONREORGLINEITEM.COMPANYCODE == SKB1.BUKRS
  • VALUATIONREORGLINEITEM.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • VALUATIONREORGLINEITEM.GLOBALCURRENCY == TCURC.WAERS
  • VALUATIONREORGLINEITEM.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Organizational Change
  • Organizational Change
  • Client
Reference Document Type VALUATIONREORGLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Profit Center
  • ?
  • ?
  • Profit Center
  • Client
  • VALUATIONREORGLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • VALUATIONREORGLINEITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • VALUATIONREORGLINEITEM.REORGPROFITCENTER == CEPC.PRCTR
  • VALUATIONREORGLINEITEM.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • VALUATIONREORGLINEITEM.REORGSEGMENT == FAGL_SEGM.SEGMENT
  • VALUATIONREORGLINEITEM.SEGMENT == FAGL_SEGM.SEGMENT
  • VALUATIONREORGLINEITEM.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Subledger-Specific Line Item Type VALUATIONREORGLINEITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE