P_RunSettlmtJournalEntryItem

Allocation Run | view: PRUNSETTLJEI | TRAN | Extraction: Not supported | Component: Fiori UI for Overhead Cost Controlling
Tables used: ACDOCA, T001, TKA02, FINSC_LEDGER, FCO_REFDOC_DR, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
ControllingObject Object number
SettlementDraftUUID GUID in 'CHAR' Format in Uppercase
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
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in 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
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
FixedQuantity Fixed Quantity
ValuationQuantity Valuation Quantity
ValuationFixedQuantity Valuation Fixed Quantity
Column Name Description
Column Name Description
IsLeadingLedger Indicator: Leading Ledger Show values
DebitCreditCode Debit/Credit Code Show values
GLRecordType Record Type Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
CompanyCodeName Name of Company Code or Company TEXT25
referencedocumenttype Reference Document Type AWTYP
referencedocument Reference document number AWREF
GrantID Receiver Grant GM_GRANT_NBR
PartnerGrant Sender Grant GM_GRANT_NBR
WBSElement WBS Element FIS_WBS
Master Data Relations Join Conditions
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.BASEUNIT == T006.MSEHI
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == T006.MANDT
FM: Receiver Budget Period
  • Receiver Fund
  • ?
  • FM: Receiver Budget Period
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FUND == FMFUNDBPD.FINCODE
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • P_RUNSETTLMTJOURNALENTRYITEM.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == FMFUNDBPD.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Company Code
  • Client
  • Company Code
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == T001.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.COMPANYCODECURRENCY == TCURC.WAERS
CO Object Currency
  • Client
  • CO Object Currency
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Center
  • ?
  • Cost Center
  • ?
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "KOKRS"] == CSKS.KOKRS
  • P_RUNSETTLMTJOURNALENTRYITEM.COSTCENTER == CSKS.KOSTL
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == CSKS.MANDT
Financial Transaction Type
  • Client
  • Financial Transaction Type
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == T856.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Receiver Functional Area
  • Receiver Functional Area
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FUNCTIONALAREA == TFKB.FKBER
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TFKB.MANDT
Functional Currency
  • Functional Currency
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FUNCTIONALCURRENCY == TCURC.WAERS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
Receiver Fund
  • Receiver Fund
  • ?
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.FUND == FMFINCODE.FINCODE
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == FMFINCODE.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_RUNSETTLMTJOURNALENTRYITEM.GLACCOUNT == SKB1.SAKNR
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == SKB1.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Global Currency
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.GLOBALCURRENCY == TCURC.WAERS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
FM: Sender Budget Period
  • Sender fund
  • ?
  • Client
  • FM: Sender Budget Period
  • P_RUNSETTLMTJOURNALENTRYITEM.PARTNERFUND == FMFUNDBPD.FINCODE
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "FIKRS"] == FMFUNDBPD.FIKRS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == FMFUNDBPD.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
Sender Functional Area
  • Sender Functional Area
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TFKB.MANDT
Sender fund
  • Sender fund
  • ?
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.PARTNERFUND == FMFINCODE.FINCODE
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "FIKRS"] == FMFINCODE.FIKRS
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == FMFINCODE.MANDT
Profit Center
  • ?
  • Profit Center
  • ?
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • P_RUNSETTLMTJOURNALENTRYITEM.PROFITCENTER == CEPC.PRCTR
  • P_RUNSETTLMTJOURNALENTRYITEM.[column in domain "DATBI"] == CEPC.DATBI
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_RUNSETTLMTJOURNALENTRYITEM.SEGMENT == FAGL_SEGM.SEGMENT
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == FAGL_SEGM.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Transaction Currency
  • Client
  • Transaction Currency
  • P_RUNSETTLMTJOURNALENTRYITEM.MANDT == TCURC.MANDT
  • P_RUNSETTLMTJOURNALENTRYITEM.TRANSACTIONCURRENCY == TCURC.WAERS