P_ProjActlPlnJrnlEntrItm

Project Actual Plan Journal Entry Items | view: PPRJACTPLNJITM | Extraction: Not supported | Component: VDM views for Costs
Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, T001, TKA02, TKA01, FINSC_LEDGER, AUFK, PROJ, T000, FINSC_SEM_TAG, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
Column Name Description
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object 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
Column Name Description
Column Name Description
CreationDate Creation Date
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
PartnerOrderCategory Partner Order Category Show values
DebitCreditCode Debit/Credit Code Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
IsCommitment Indicator: Is Commitment Show values
IsLeadingLedger Indicator: Leading Ledger Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProject Partner Project FIS_PROJECT
WBSElementProfitCenter null
WBSDescription null
ProjectObjectNode null
WBSElementCoCode null
WBSElement WBS Element FIS_WBS
ResponsibleCostCenter null
Project Project FIS_PROJECT
ProjectDescription null
ProjectProfileCode null
ProjectObject null
AvailabilityControlProfile null
AvailabilityControlIsActive null
AvailyCtrlTimeRangeType null
BudgetCurrencyRole null
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
OrderOperation Operation/Activity Number VORNR
PlanningCategory Plan Category FCOM_CATEGORY
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
PartnerProjectNetworkActivity Partner Project Network Activity VORNR
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
CtrlgStdFinStatementVersion Leading Controlling Financial Statement Version DHRYID
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • P_PROJACTLPLNJRNLENTRITM.BUSINESSAREA == TGSB.GSBER
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TGSB.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_PROJACTLPLNJRNLENTRITM.CHARTOFACCOUNTS == T004.KTOPL
  • P_PROJACTLPLNJRNLENTRITM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_PROJACTLPLNJRNLENTRITM.COMPANYCODE == T001.BUKRS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • P_PROJACTLPLNJRNLENTRITM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_PROJACTLPLNJRNLENTRITM.CONTROLLINGAREA == TKA01.KOKRS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TKA01.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • P_PROJACTLPLNJRNLENTRITM.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
Cost Center
  • Cost Center
  • Controlling Area
  • Client
  • ?
  • P_PROJACTLPLNJRNLENTRITM.COSTCENTER == CSKS.KOSTL
  • P_PROJACTLPLNJRNLENTRITM.CONTROLLINGAREA == CSKS.KOKRS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == CSKS.MANDT
  • P_PROJACTLPLNJRNLENTRITM.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Controlling Area
  • Activity Type
  • Client
  • ?
  • P_PROJACTLPLNJRNLENTRITM.CONTROLLINGAREA == CSLA.KOKRS
  • P_PROJACTLPLNJRNLENTRITM.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_PROJACTLPLNJRNLENTRITM.MANDT == CSLA.MANDT
  • P_PROJACTLPLNJRNLENTRITM.[column in domain "DATBI"] == CSLA.DATBI
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_PROJACTLPLNJRNLENTRITM.FISCALYEARVARIANT == T009.PERIV
  • P_PROJACTLPLNJRNLENTRITM.MANDT == T009.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • P_PROJACTLPLNJRNLENTRITM.FUNCTIONALAREA == TFKB.FKBER
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_PROJACTLPLNJRNLENTRITM.GLACCOUNT == SKB1.SAKNR
  • P_PROJACTLPLNJRNLENTRITM.COMPANYCODE == SKB1.BUKRS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_PROJACTLPLNJRNLENTRITM.GLOBALCURRENCY == TCURC.WAERS
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Order ID
  • Order ID
  • Client
  • P_PROJACTLPLNJRNLENTRITM.ORDERID == AUFK.AUFNR
  • P_PROJACTLPLNJRNLENTRITM.MANDT == AUFK.MANDT
Partner Business Process
  • Controlling Area
  • Partner Business Process
  • Client
  • ?
  • P_PROJACTLPLNJRNLENTRITM.CONTROLLINGAREA == CBPR.KOKRS
  • P_PROJACTLPLNJRNLENTRITM.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • P_PROJACTLPLNJRNLENTRITM.MANDT == CBPR.MANDT
  • P_PROJACTLPLNJRNLENTRITM.[column in domain "DATBI"] == CBPR.DATBI
Partner Cost Object
  • Client
  • ?
  • Partner Cost Object
  • P_PROJACTLPLNJRNLENTRITM.MANDT == CKPH.MANDT
  • P_PROJACTLPLNJRNLENTRITM.[column in domain "DATBI"] == CKPH.DATBI
  • P_PROJACTLPLNJRNLENTRITM.PARTNERCOSTOBJECT == CKPH.KSTRG
Partner Order
  • Partner Order
  • Client
  • P_PROJACTLPLNJRNLENTRITM.PARTNERORDER == AUFK.AUFNR
  • P_PROJACTLPLNJRNLENTRITM.MANDT == AUFK.MANDT
Partner Project Network
  • Client
  • Partner Project Network
  • P_PROJACTLPLNJRNLENTRITM.MANDT == AUFK.MANDT
  • P_PROJACTLPLNJRNLENTRITM.PARTNERPROJECTNETWORK == AUFK.AUFNR
Profit Center
  • Controlling Area
  • Profit Center
  • Client
  • ?
  • P_PROJACTLPLNJRNLENTRITM.CONTROLLINGAREA == CEPC.KOKRS
  • P_PROJACTLPLNJRNLENTRITM.PROFITCENTER == CEPC.PRCTR
  • P_PROJACTLPLNJRNLENTRITM.MANDT == CEPC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.[column in domain "DATBI"] == CEPC.DATBI
Project Internal ID
  • Project Internal ID
  • Client
  • P_PROJACTLPLNJRNLENTRITM.PROJECTINTERNALID == PROJ.PSPNR
  • P_PROJACTLPLNJRNLENTRITM.MANDT == PROJ.MANDT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Source Logical System P_PROJACTLPLNJRNLENTRITM.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type P_PROJACTLPLNJRNLENTRITM.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • P_PROJACTLPLNJRNLENTRITM.MANDT == TCURC.MANDT
  • P_PROJACTLPLNJRNLENTRITM.TRANSACTIONCURRENCY == TCURC.WAERS