VALUATIONPARTIALCLEARING

Valuation run: partial clearing items(before reorg) | view: VALPARTIALCL | Extraction: Not supported | Component: Closing Operations / Period-End
Tables used: SCAL_TT_DATE, ACDOCA, BUT000, UKMBP_CMS, KNA1, CVI_CUST_LINK, TBSL, LFA1, CVI_VEND_LINK, 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
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
ClearingDate Clearing Date
NetDueDate Net Due Date
OriginalPostingDate Posting Date
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
financialclosinglineitemtype Financial Closing Run Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
AccountingDocumentCategory Journal Entry Category Show values
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
TaxCountry Tax Reporting Country/Region LAND1
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
line_type null
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
IsClearedAtKeydate null
jrnlperiodendclosingrunloguuid null
marked_for_deletion Entries are marked to be deleted CHAR1
CreationDateTime Time Stamp of Creation TZNTSTMPS
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceReference Invoice Reference BELNR
InvoiceItemReference Invoice Item Reference BUZEI
AssignmentReference Assignment Reference ZUONR
CUSTOMER_SUPPLIER_GROUP_KEY null
FiscalPeriod Fiscal Period POPER
OffsettingAccount Offsetting Account GKONT
WBSElement WBS Element FIS_WBS
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
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
PartnerGrant Partner Grant GM_GRANT_NBR
relatednetworkactivityinternal Closing run Internal hepler field for NPLNR_VORGN CHAR33
PrdcssrJournalEntryCompanyCode Company Code BUKRS
PrdcssrJournalEntryFiscalYear Fiscal Year GJAHR
PredecessorJournalEntry Journal Entry BELNR
PredecessorJournalEntryItem Ledger Journal Entry Item DOCLN6
BusinessPartner Business Partner Number BU_PARTNER
CreditRiskClass Risk Class UKM_RISK_CLASS
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
  • VALUATIONPARTIALCLEARING.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Budget Period
  • ?
  • Budget Period
  • Client
  • Fund
  • VALUATIONPARTIALCLEARING.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • VALUATIONPARTIALCLEARING.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • VALUATIONPARTIALCLEARING.MANDT == FMFUNDBPD.MANDT
  • VALUATIONPARTIALCLEARING.FUND == FMFUNDBPD.FINCODE
Business Area
  • Business Area
  • Client
  • VALUATIONPARTIALCLEARING.BUSINESSAREA == TGSB.GSBER
  • VALUATIONPARTIALCLEARING.MANDT == TGSB.MANDT
Business Process
  • Controlling Area
  • Business Process
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.CONTROLLINGAREA == CBPR.KOKRS
  • VALUATIONPARTIALCLEARING.BUSINESSPROCESS == CBPR.PRZNR
  • VALUATIONPARTIALCLEARING.[column in domain "DATBI"] == CBPR.DATBI
  • VALUATIONPARTIALCLEARING.MANDT == CBPR.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • VALUATIONPARTIALCLEARING.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE
  • VALUATIONPARTIALCLEARING.MANDT == FINSC_BTTYPE.MANDT
Cash Origin Account
  • Cash Origin Account
  • Chart of Accounts
  • Client
  • VALUATIONPARTIALCLEARING.CASHLEDGERACCOUNT == SKA1.SAKNR
  • VALUATIONPARTIALCLEARING.CHARTOFACCOUNTS == SKA1.KTOPL
  • VALUATIONPARTIALCLEARING.MANDT == SKA1.MANDT
Cash Origin Company Code
  • Cash Origin Company Code
  • Client
  • VALUATIONPARTIALCLEARING.CASHLEDGERCOMPANYCODE == T001.BUKRS
  • VALUATIONPARTIALCLEARING.MANDT == T001.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • VALUATIONPARTIALCLEARING.CHARTOFACCOUNTS == T004.KTOPL
  • VALUATIONPARTIALCLEARING.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • VALUATIONPARTIALCLEARING.COMPANYCODE == T001.BUKRS
  • VALUATIONPARTIALCLEARING.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • VALUATIONPARTIALCLEARING.COMPANYCODECURRENCY == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • VALUATIONPARTIALCLEARING.CONTROLLINGAREA == TKA01.KOKRS
  • VALUATIONPARTIALCLEARING.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Client
  • Cost Center
  • VALUATIONPARTIALCLEARING.CONTROLLINGAREA == CSKS.KOKRS
  • VALUATIONPARTIALCLEARING.[column in domain "DATBI"] == CSKS.DATBI
  • VALUATIONPARTIALCLEARING.MANDT == CSKS.MANDT
  • VALUATIONPARTIALCLEARING.COSTCENTER == CSKS.KOSTL
Activity Type
  • Controlling Area
  • Activity Type
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.CONTROLLINGAREA == CSLA.KOKRS
  • VALUATIONPARTIALCLEARING.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • VALUATIONPARTIALCLEARING.[column in domain "DATBI"] == CSLA.DATBI
  • VALUATIONPARTIALCLEARING.MANDT == CSLA.MANDT
Cost Object
  • Cost Object
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.COSTOBJECT == CKPH.KSTRG
  • VALUATIONPARTIALCLEARING.[column in domain "DATBI"] == CKPH.DATBI
  • VALUATIONPARTIALCLEARING.MANDT == CKPH.MANDT
Customer Number
  • Customer Number
  • Client
  • VALUATIONPARTIALCLEARING.CUSTOMER == KNA1.KUNNR
  • VALUATIONPARTIALCLEARING.MANDT == KNA1.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • VALUATIONPARTIALCLEARING.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • VALUATIONPARTIALCLEARING.MANDT == T856.MANDT
Financial Valuation Object Type
  • Financial Valuation Object Type
  • Client
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
  • VALUATIONPARTIALCLEARING.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • VALUATIONPARTIALCLEARING.FUNCTIONALAREA == TFKB.FKBER
  • VALUATIONPARTIALCLEARING.MANDT == TFKB.MANDT
Fund
  • ?
  • Client
  • Fund
  • VALUATIONPARTIALCLEARING.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • VALUATIONPARTIALCLEARING.MANDT == FMFINCODE.MANDT
  • VALUATIONPARTIALCLEARING.FUND == FMFINCODE.FINCODE
G/L Account
  • G/L Account
  • Company Code
  • Client
  • VALUATIONPARTIALCLEARING.GLACCOUNT == SKB1.SAKNR
  • VALUATIONPARTIALCLEARING.COMPANYCODE == SKB1.BUKRS
  • VALUATIONPARTIALCLEARING.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • VALUATIONPARTIALCLEARING.GLOBALCURRENCY == TCURC.WAERS
  • VALUATIONPARTIALCLEARING.MANDT == TCURC.MANDT
Joint venture
  • Joint venture
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.JOINTVENTURE == T8JV.VNAME
  • VALUATIONPARTIALCLEARING.[column in domain "BUKRS"] == T8JV.BUKRS
  • VALUATIONPARTIALCLEARING.MANDT == T8JV.MANDT
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • VALUATIONPARTIALCLEARING.[column in domain "BUKRS"] == T8JJ.BUKRS
  • VALUATIONPARTIALCLEARING.MANDT == T8JJ.MANDT
Joint Venture Equity Group
  • Joint venture
  • Joint Venture Equity Group
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.JOINTVENTURE == T8JF.VNAME
  • VALUATIONPARTIALCLEARING.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • VALUATIONPARTIALCLEARING.[column in domain "BUKRS"] == T8JF.BUKRS
  • VALUATIONPARTIALCLEARING.MANDT == T8JF.MANDT
Joint Venture Partner
  • Joint Venture Partner
  • Client
  • VALUATIONPARTIALCLEARING.JOINTVENTUREPARTNER == KNA1.KUNNR
  • VALUATIONPARTIALCLEARING.MANDT == KNA1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order ID
  • Order ID
  • Client
  • VALUATIONPARTIALCLEARING.ORDERID == AUFK.AUFNR
  • VALUATIONPARTIALCLEARING.MANDT == AUFK.MANDT
Organizational Change
  • Organizational Change
  • Client
Partner Business Area
  • Client
  • Partner Business Area
  • VALUATIONPARTIALCLEARING.MANDT == TGSB.MANDT
  • VALUATIONPARTIALCLEARING.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • VALUATIONPARTIALCLEARING.PARTNERCOMPANY == T880.RCOMP
  • VALUATIONPARTIALCLEARING.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • ?
  • Client
  • Partner Cost Center
  • VALUATIONPARTIALCLEARING.CONTROLLINGAREA == CSKS.KOKRS
  • VALUATIONPARTIALCLEARING.[column in domain "DATBI"] == CSKS.DATBI
  • VALUATIONPARTIALCLEARING.MANDT == CSKS.MANDT
  • VALUATIONPARTIALCLEARING.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Partner Functional Area
  • Client
  • VALUATIONPARTIALCLEARING.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • VALUATIONPARTIALCLEARING.MANDT == TFKB.MANDT
Partner Fund
  • ?
  • Partner Fund
  • Client
  • VALUATIONPARTIALCLEARING.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • VALUATIONPARTIALCLEARING.PARTNERFUND == FMFINCODE.FINCODE
  • VALUATIONPARTIALCLEARING.MANDT == FMFINCODE.MANDT
Partner Profit Center
  • Controlling Area
  • Partner Profit Center
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.CONTROLLINGAREA == CEPC.KOKRS
  • VALUATIONPARTIALCLEARING.PARTNERPROFITCENTER == CEPC.PRCTR
  • VALUATIONPARTIALCLEARING.[column in domain "DATBI"] == CEPC.DATBI
  • VALUATIONPARTIALCLEARING.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • VALUATIONPARTIALCLEARING.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • VALUATIONPARTIALCLEARING.MANDT == FAGL_SEGM.MANDT
Plant
  • Plant
  • Client
  • VALUATIONPARTIALCLEARING.PLANT == T001W.WERKS
  • VALUATIONPARTIALCLEARING.MANDT == T001W.MANDT
Posting Key
  • Posting Key
  • Client
  • VALUATIONPARTIALCLEARING.POSTINGKEY == TBSL.BSCHL
  • VALUATIONPARTIALCLEARING.MANDT == TBSL.MANDT
Product Number
  • Product Number
  • Client
  • VALUATIONPARTIALCLEARING.PRODUCT == MARA.MATNR
  • VALUATIONPARTIALCLEARING.MANDT == MARA.MANDT
Profit Center
  • Controlling Area
  • Profit Center
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.CONTROLLINGAREA == CEPC.KOKRS
  • VALUATIONPARTIALCLEARING.PROFITCENTER == CEPC.PRCTR
  • VALUATIONPARTIALCLEARING.[column in domain "DATBI"] == CEPC.DATBI
  • VALUATIONPARTIALCLEARING.MANDT == CEPC.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • VALUATIONPARTIALCLEARING.PROJECTNETWORK == AUFK.AUFNR
  • VALUATIONPARTIALCLEARING.MANDT == AUFK.MANDT
Budget Account
  • Chart of Accounts
  • Budget Account
  • Client
  • VALUATIONPARTIALCLEARING.CHARTOFACCOUNTS == SKA1.KTOPL
  • VALUATIONPARTIALCLEARING.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • VALUATIONPARTIALCLEARING.MANDT == SKA1.MANDT
Reference Document Type VALUATIONPARTIALCLEARING.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • VALUATIONPARTIALCLEARING.SEGMENT == FAGL_SEGM.SEGMENT
  • VALUATIONPARTIALCLEARING.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • VALUATIONPARTIALCLEARING.SHIPTOPARTY == KNA1.KUNNR
  • VALUATIONPARTIALCLEARING.MANDT == KNA1.MANDT
Subledger-Specific Line Item Type VALUATIONPARTIALCLEARING.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Supplier
  • Client
  • VALUATIONPARTIALCLEARING.SUPPLIER == LFA1.LIFNR
  • VALUATIONPARTIALCLEARING.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • VALUATIONPARTIALCLEARING.TAXCODE == T007A.MWSKZ
  • VALUATIONPARTIALCLEARING.[column in domain "KALSM_D"] == T007A.KALSM
  • VALUATIONPARTIALCLEARING.MANDT == T007A.MANDT