P_VALUATIONINVOICE

Valuation run: original invoices(before reorg) | view: PVALINVOICE | 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
DocumentDate Journal Entry Date
PostingDate Posting Date
OriginalPostingDate Posting 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
IsOpenItemManaged Managed on an Open Item Basis 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
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
IsClearedAtKeydate null
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceReference Invoice Reference BELNR
InvoiceItemReference Invoice Item Reference BUZEI
line_type null
CreationDateTime Time Stamp of Creation TZNTSTMPS
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
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 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
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
Master Data Relations Join Conditions
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Budget Period
  • Client
  • ?
  • Fund
  • Budget Period
  • P_VALUATIONINVOICE.MANDT == FMFUNDBPD.MANDT
  • P_VALUATIONINVOICE.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • P_VALUATIONINVOICE.FUND == FMFUNDBPD.FINCODE
  • P_VALUATIONINVOICE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Business Area
  • Business Area
  • Client
  • P_VALUATIONINVOICE.BUSINESSAREA == TGSB.GSBER
  • P_VALUATIONINVOICE.MANDT == TGSB.MANDT
Business Process
  • Controlling Area
  • Business Process
  • Client
  • ?
  • P_VALUATIONINVOICE.CONTROLLINGAREA == CBPR.KOKRS
  • P_VALUATIONINVOICE.BUSINESSPROCESS == CBPR.PRZNR
  • P_VALUATIONINVOICE.MANDT == CBPR.MANDT
  • P_VALUATIONINVOICE.[column in domain "DATBI"] == CBPR.DATBI
Business Transaction Category
  • Business Transaction Category
  • Client
Cash Origin Account
  • Cash Origin Account
  • Chart of Accounts
  • Client
  • P_VALUATIONINVOICE.CASHLEDGERACCOUNT == SKA1.SAKNR
  • P_VALUATIONINVOICE.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_VALUATIONINVOICE.MANDT == SKA1.MANDT
Cash Origin Company Code
  • Cash Origin Company Code
  • Client
  • P_VALUATIONINVOICE.CASHLEDGERCOMPANYCODE == T001.BUKRS
  • P_VALUATIONINVOICE.MANDT == T001.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_VALUATIONINVOICE.CHARTOFACCOUNTS == T004.KTOPL
  • P_VALUATIONINVOICE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Company Code
  • Client
  • P_VALUATIONINVOICE.COMPANYCODE == T001.BUKRS
  • P_VALUATIONINVOICE.PRDCSSRJOURNALENTRYCOMPANYCODE == T001.BUKRS
  • P_VALUATIONINVOICE.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_VALUATIONINVOICE.CONTROLLINGAREA == TKA01.KOKRS
  • P_VALUATIONINVOICE.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Controlling Area
  • Client
  • ?
  • P_VALUATIONINVOICE.COSTCENTER == CSKS.KOSTL
  • P_VALUATIONINVOICE.CONTROLLINGAREA == CSKS.KOKRS
  • P_VALUATIONINVOICE.MANDT == CSKS.MANDT
  • P_VALUATIONINVOICE.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Controlling Area
  • Client
  • Activity Type
  • ?
  • P_VALUATIONINVOICE.CONTROLLINGAREA == CSLA.KOKRS
  • P_VALUATIONINVOICE.MANDT == CSLA.MANDT
  • P_VALUATIONINVOICE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_VALUATIONINVOICE.[column in domain "DATBI"] == CSLA.DATBI
Cost Object
  • Client
  • Cost Object
  • ?
  • P_VALUATIONINVOICE.MANDT == CKPH.MANDT
  • P_VALUATIONINVOICE.COSTOBJECT == CKPH.KSTRG
  • P_VALUATIONINVOICE.[column in domain "DATBI"] == CKPH.DATBI
Customer Number
  • Customer Number
  • Client
  • P_VALUATIONINVOICE.CUSTOMER == KNA1.KUNNR
  • P_VALUATIONINVOICE.MANDT == KNA1.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • P_VALUATIONINVOICE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • P_VALUATIONINVOICE.MANDT == T856.MANDT
Financial Valuation Object Type
  • Client
  • Financial Valuation Object Type
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • P_VALUATIONINVOICE.FUNCTIONALAREA == TFKB.FKBER
  • P_VALUATIONINVOICE.MANDT == TFKB.MANDT
Fund
  • Client
  • ?
  • Fund
  • P_VALUATIONINVOICE.MANDT == FMFINCODE.MANDT
  • P_VALUATIONINVOICE.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_VALUATIONINVOICE.FUND == FMFINCODE.FINCODE
G/L Account
  • G/L Account
  • Company Code
  • Company Code
  • Client
  • P_VALUATIONINVOICE.GLACCOUNT == SKB1.SAKNR
  • P_VALUATIONINVOICE.COMPANYCODE == SKB1.BUKRS
  • P_VALUATIONINVOICE.PRDCSSRJOURNALENTRYCOMPANYCODE == SKB1.BUKRS
  • P_VALUATIONINVOICE.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • P_VALUATIONINVOICE.MANDT == TCURC.MANDT
  • P_VALUATIONINVOICE.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • ?
  • Client
  • Joint venture
  • P_VALUATIONINVOICE.[column in domain "BUKRS"] == T8JV.BUKRS
  • P_VALUATIONINVOICE.MANDT == T8JV.MANDT
  • P_VALUATIONINVOICE.JOINTVENTURE == T8JV.VNAME
Joint Venture Cost Recovery Code
  • ?
  • Client
  • Joint Venture Cost Recovery Code
  • P_VALUATIONINVOICE.[column in domain "BUKRS"] == T8JJ.BUKRS
  • P_VALUATIONINVOICE.MANDT == T8JJ.MANDT
  • P_VALUATIONINVOICE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Joint Venture Equity Group
  • ?
  • Joint Venture Equity Group
  • Client
  • Joint venture
  • P_VALUATIONINVOICE.[column in domain "BUKRS"] == T8JF.BUKRS
  • P_VALUATIONINVOICE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • P_VALUATIONINVOICE.MANDT == T8JF.MANDT
  • P_VALUATIONINVOICE.JOINTVENTURE == T8JF.VNAME
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • P_VALUATIONINVOICE.MANDT == KNA1.MANDT
  • P_VALUATIONINVOICE.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Order ID
  • Client
  • P_VALUATIONINVOICE.ORDERID == AUFK.AUFNR
  • P_VALUATIONINVOICE.MANDT == AUFK.MANDT
Organizational Change
  • Client
  • Organizational Change
Partner Business Area
  • Client
  • Partner Business Area
  • P_VALUATIONINVOICE.MANDT == TGSB.MANDT
  • P_VALUATIONINVOICE.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • P_VALUATIONINVOICE.PARTNERCOMPANY == T880.RCOMP
  • P_VALUATIONINVOICE.MANDT == T880.MANDT
Partner Cost Center
  • Controlling Area
  • Client
  • Partner Cost Center
  • ?
  • P_VALUATIONINVOICE.CONTROLLINGAREA == CSKS.KOKRS
  • P_VALUATIONINVOICE.MANDT == CSKS.MANDT
  • P_VALUATIONINVOICE.PARTNERCOSTCENTER == CSKS.KOSTL
  • P_VALUATIONINVOICE.[column in domain "DATBI"] == CSKS.DATBI
Partner Functional Area
  • Partner Functional Area
  • Client
  • P_VALUATIONINVOICE.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_VALUATIONINVOICE.MANDT == TFKB.MANDT
Partner Fund
  • Partner Fund
  • Client
  • ?
  • P_VALUATIONINVOICE.PARTNERFUND == FMFINCODE.FINCODE
  • P_VALUATIONINVOICE.MANDT == FMFINCODE.MANDT
  • P_VALUATIONINVOICE.[column in domain "FIKRS"] == FMFINCODE.FIKRS
Partner Profit Center
  • Controlling Area
  • Client
  • ?
  • Partner Profit Center
  • P_VALUATIONINVOICE.CONTROLLINGAREA == CEPC.KOKRS
  • P_VALUATIONINVOICE.MANDT == CEPC.MANDT
  • P_VALUATIONINVOICE.[column in domain "DATBI"] == CEPC.DATBI
  • P_VALUATIONINVOICE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • P_VALUATIONINVOICE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • P_VALUATIONINVOICE.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • P_VALUATIONINVOICE.MANDT == T001W.MANDT
  • P_VALUATIONINVOICE.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • P_VALUATIONINVOICE.POSTINGKEY == TBSL.BSCHL
  • P_VALUATIONINVOICE.MANDT == TBSL.MANDT
Company Code
  • Company Code
  • Company Code
  • Client
  • P_VALUATIONINVOICE.COMPANYCODE == T001.BUKRS
  • P_VALUATIONINVOICE.PRDCSSRJOURNALENTRYCOMPANYCODE == T001.BUKRS
  • P_VALUATIONINVOICE.MANDT == T001.MANDT
Product Number
  • Product Number
  • Client
  • P_VALUATIONINVOICE.PRODUCT == MARA.MATNR
  • P_VALUATIONINVOICE.MANDT == MARA.MANDT
Profit Center
  • Profit Center
  • Controlling Area
  • Client
  • ?
  • P_VALUATIONINVOICE.PROFITCENTER == CEPC.PRCTR
  • P_VALUATIONINVOICE.CONTROLLINGAREA == CEPC.KOKRS
  • P_VALUATIONINVOICE.MANDT == CEPC.MANDT
  • P_VALUATIONINVOICE.[column in domain "DATBI"] == CEPC.DATBI
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • P_VALUATIONINVOICE.MANDT == AUFK.MANDT
  • P_VALUATIONINVOICE.PROJECTNETWORK == AUFK.AUFNR
Budget Account
  • Chart of Accounts
  • Client
  • Budget Account
  • P_VALUATIONINVOICE.CHARTOFACCOUNTS == SKA1.KTOPL
  • P_VALUATIONINVOICE.MANDT == SKA1.MANDT
  • P_VALUATIONINVOICE.PUBSECBUDGETACCOUNT == SKA1.SAKNR
Reference Document Type P_VALUATIONINVOICE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_VALUATIONINVOICE.SEGMENT == FAGL_SEGM.SEGMENT
  • P_VALUATIONINVOICE.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Client
  • Ship-to Party
  • P_VALUATIONINVOICE.MANDT == KNA1.MANDT
  • P_VALUATIONINVOICE.SHIPTOPARTY == KNA1.KUNNR
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Subledger-Specific Line Item Type P_VALUATIONINVOICE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Client
  • Supplier
  • P_VALUATIONINVOICE.MANDT == LFA1.MANDT
  • P_VALUATIONINVOICE.SUPPLIER == LFA1.LIFNR
Tax on Sales/Purchases Code
  • ?
  • Client
  • Tax on Sales/Purchases Code
  • P_VALUATIONINVOICE.[column in domain "KALSM_D"] == T007A.KALSM
  • P_VALUATIONINVOICE.MANDT == T007A.MANDT
  • P_VALUATIONINVOICE.TAXCODE == T007A.MWSKZ