P_ValuationRunAccountLineItem

Valuation run non-oim items | view: PVALRUNITEM | 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
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
ClearingDate Clearing Date
NetDueDate Net Due Date
PostingDate Posting Date
OriginalPostingDate Posting Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed 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
line_type Financial closing valuation line type CHAR50
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CreationDateTime Time Stamp of Creation TZNTSTMPS
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
ISCLEAREDATKEYDATE null
AssignmentReference Assignment Reference ZUONR
CUSTOMER_SUPPLIER_GROUP_KEY null
FiscalPeriod Fiscal Period POPER
OffsettingAccount Offsetting Account GKONT
WBSElement WBS Element FIS_WBS
TaxCountry Tax Reporting Country/Region LAND1
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
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
CreditRiskClass Risk Class UKM_RISK_CLASS
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Budget Period
  • Budget Period
  • Client
  • ?
  • Fund
  • P_VALUATIONRUNACCOUNTLINEITEM.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FMFUNDBPD.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.FUND == FMFUNDBPD.FINCODE
Business Area
  • Business Area
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.BUSINESSAREA == TGSB.GSBER
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TGSB.MANDT
Business Process
  • ?
  • Controlling Area
  • Business Process
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "DATBI"] == CBPR.DATBI
  • P_VALUATIONRUNACCOUNTLINEITEM.CONTROLLINGAREA == CBPR.KOKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.BUSINESSPROCESS == CBPR.PRZNR
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == CBPR.MANDT
Business Transaction Category
  • Client
  • Business Transaction Category
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FINSC_BTTYPE.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE
Cash Origin Account
  • Chart of Accounts
  • Client
  • Cash Origin Account
  • P_VALUATIONRUNACCOUNTLINEITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == SKA1.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.CASHLEDGERACCOUNT == SKA1.SAKNR
Cash Origin Company Code
  • Cash Origin Company Code
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.CASHLEDGERCOMPANYCODE == T001.BUKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T001.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.COMPANYCODE == T001.BUKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_VALUATIONRUNACCOUNTLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == CSKS.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.COSTCENTER == CSKS.KOSTL
Activity Type
  • ?
  • Controlling Area
  • Activity Type
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • P_VALUATIONRUNACCOUNTLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == CSLA.MANDT
Cost Object
  • ?
  • Client
  • Cost Object
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "DATBI"] == CKPH.DATBI
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == CKPH.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.COSTOBJECT == CKPH.KSTRG
Customer Number
  • Client
  • Customer Number
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == KNA1.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.CUSTOMER == KNA1.KUNNR
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T856.MANDT
Financial Valuation Object Type
  • Client
  • Financial Valuation Object Type
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FINSC_VAL_TYPE.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FINANCIALVALUATIONOBJECTTYPE == FINSC_VAL_TYPE.VALOBJ_TYPE
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
Functional Area
  • Client
  • Functional Area
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TFKB.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.FUNCTIONALAREA == TFKB.FKBER
Fund
  • Client
  • ?
  • Fund
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FMFINCODE.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.FUND == FMFINCODE.FINCODE
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_VALUATIONRUNACCOUNTLINEITEM.COMPANYCODE == SKB1.BUKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == SKB1.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TCURC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • ?
  • Joint venture
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "BUKRS"] == T8JV.BUKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.JOINTVENTURE == T8JV.VNAME
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T8JV.MANDT
Joint Venture Cost Recovery Code
  • ?
  • Client
  • Joint Venture Cost Recovery Code
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "BUKRS"] == T8JJ.BUKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T8JJ.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Joint Venture Equity Group
  • ?
  • Joint venture
  • Client
  • Joint Venture Equity Group
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "BUKRS"] == T8JF.BUKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.JOINTVENTURE == T8JF.VNAME
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T8JF.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == KNA1.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FINSC_LEDGER.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_VALUATIONRUNACCOUNTLINEITEM.LEDGER == FINSC_LEDGER.RLDNR
Order ID
  • Client
  • Order ID
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == AUFK.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.ORDERID == AUFK.AUFNR
Partner Business Area
  • Client
  • Partner Business Area
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TGSB.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.PARTNERCOMPANY == T880.RCOMP
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T880.MANDT
Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • Partner Cost Center
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_VALUATIONRUNACCOUNTLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == CSKS.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PARTNERCOSTCENTER == CSKS.KOSTL
Partner Functional Area
  • Client
  • Partner Functional Area
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == TFKB.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Fund
  • Partner Fund
  • Client
  • ?
  • P_VALUATIONRUNACCOUNTLINEITEM.PARTNERFUND == FMFINCODE.FINCODE
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FMFINCODE.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "FIKRS"] == FMFINCODE.FIKRS
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_VALUATIONRUNACCOUNTLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.PARTNERPROFITCENTER == CEPC.PRCTR
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == CEPC.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FAGL_SEGM.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Client
  • Plant
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T001W.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PLANT == T001W.WERKS
Preceding Journal Entry Company Code
  • Preceding Journal Entry Company Code
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.PRDCSSRJOURNALENTRYCOMPANYCODE == T001.BUKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T001.MANDT
Product Number
  • Client
  • Product Number
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == MARA.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PRODUCT == MARA.MATNR
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_VALUATIONRUNACCOUNTLINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == CEPC.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PROFITCENTER == CEPC.PRCTR
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.PROJECTNETWORK == AUFK.AUFNR
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == AUFK.MANDT
Budget Account
  • Chart of Accounts
  • Client
  • Budget Account
  • P_VALUATIONRUNACCOUNTLINEITEM.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == SKA1.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.PUBSECBUDGETACCOUNT == SKA1.SAKNR
Reference Document Type P_VALUATIONRUNACCOUNTLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.SEGMENT == FAGL_SEGM.SEGMENT
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.SHIPTOPARTY == KNA1.KUNNR
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == KNA1.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • P_VALUATIONRUNACCOUNTLINEITEM.LEDGER == FINSC_LEDGER.RLDNR
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == FINSC_LEDGER.MANDT
Subledger-Specific Line Item Type P_VALUATIONRUNACCOUNTLINEITEM.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Supplier
  • Client
  • P_VALUATIONRUNACCOUNTLINEITEM.SUPPLIER == LFA1.LIFNR
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • Client
  • ?
  • P_VALUATIONRUNACCOUNTLINEITEM.TAXCODE == T007A.MWSKZ
  • P_VALUATIONRUNACCOUNTLINEITEM.MANDT == T007A.MANDT
  • P_VALUATIONRUNACCOUNTLINEITEM.[column in domain "KALSM_D"] == T007A.KALSM