P_ProjCostAcctgLineItms

Projects with Accounting Cost Line Items | view: PPRJBYPMOCST | 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
WBSElement WBS Element FIS_WBS
Project Project FIS_PROJECT
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
  • Client
  • Business Area
  • P_PROJCOSTACCTGLINEITMS.MANDT == TGSB.MANDT
  • P_PROJCOSTACCTGLINEITMS.BUSINESSAREA == TGSB.GSBER
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_PROJCOSTACCTGLINEITMS.MANDT == T004.MANDT
  • P_PROJCOSTACCTGLINEITMS.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • P_PROJCOSTACCTGLINEITMS.COMPANYCODE == T001.BUKRS
  • P_PROJCOSTACCTGLINEITMS.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • P_PROJCOSTACCTGLINEITMS.MANDT == TKA01.MANDT
  • P_PROJCOSTACCTGLINEITMS.CONTROLLINGAREA == TKA01.KOKRS
CO Object Currency
  • Client
  • CO Object Currency
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • P_PROJCOSTACCTGLINEITMS.MANDT == CSKS.MANDT
  • P_PROJCOSTACCTGLINEITMS.[column in domain "DATBI"] == CSKS.DATBI
  • P_PROJCOSTACCTGLINEITMS.CONTROLLINGAREA == CSKS.KOKRS
  • P_PROJCOSTACCTGLINEITMS.COSTCENTER == CSKS.KOSTL
Activity Type
  • Client
  • ?
  • Controlling Area
  • Activity Type
  • P_PROJCOSTACCTGLINEITMS.MANDT == CSLA.MANDT
  • P_PROJCOSTACCTGLINEITMS.[column in domain "DATBI"] == CSLA.DATBI
  • P_PROJCOSTACCTGLINEITMS.CONTROLLINGAREA == CSLA.KOKRS
  • P_PROJCOSTACCTGLINEITMS.COSTCTRACTIVITYTYPE == CSLA.LSTAR
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_PROJCOSTACCTGLINEITMS.FISCALYEARVARIANT == T009.PERIV
  • P_PROJCOSTACCTGLINEITMS.MANDT == T009.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • P_PROJCOSTACCTGLINEITMS.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
Functional Area
  • Client
  • Functional Area
  • P_PROJCOSTACCTGLINEITMS.MANDT == TFKB.MANDT
  • P_PROJCOSTACCTGLINEITMS.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Company Code
  • Client
  • G/L Account
  • P_PROJCOSTACCTGLINEITMS.COMPANYCODE == SKB1.BUKRS
  • P_PROJCOSTACCTGLINEITMS.MANDT == SKB1.MANDT
  • P_PROJCOSTACCTGLINEITMS.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Client
  • Order ID
  • P_PROJCOSTACCTGLINEITMS.MANDT == AUFK.MANDT
  • P_PROJCOSTACCTGLINEITMS.ORDERID == AUFK.AUFNR
Partner Business Process
  • Client
  • ?
  • Controlling Area
  • Partner Business Process
  • P_PROJCOSTACCTGLINEITMS.MANDT == CBPR.MANDT
  • P_PROJCOSTACCTGLINEITMS.[column in domain "DATBI"] == CBPR.DATBI
  • P_PROJCOSTACCTGLINEITMS.CONTROLLINGAREA == CBPR.KOKRS
  • P_PROJCOSTACCTGLINEITMS.PARTNERBUSINESSPROCESS == CBPR.PRZNR
Partner Cost Object
  • Client
  • ?
  • Partner Cost Object
  • P_PROJCOSTACCTGLINEITMS.MANDT == CKPH.MANDT
  • P_PROJCOSTACCTGLINEITMS.[column in domain "DATBI"] == CKPH.DATBI
  • P_PROJCOSTACCTGLINEITMS.PARTNERCOSTOBJECT == CKPH.KSTRG
Partner Order
  • Partner Order
  • Client
  • P_PROJCOSTACCTGLINEITMS.PARTNERORDER == AUFK.AUFNR
  • P_PROJCOSTACCTGLINEITMS.MANDT == AUFK.MANDT
Partner Project Network
  • Client
  • Partner Project Network
  • P_PROJCOSTACCTGLINEITMS.MANDT == AUFK.MANDT
  • P_PROJCOSTACCTGLINEITMS.PARTNERPROJECTNETWORK == AUFK.AUFNR
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • P_PROJCOSTACCTGLINEITMS.MANDT == CEPC.MANDT
  • P_PROJCOSTACCTGLINEITMS.[column in domain "DATBI"] == CEPC.DATBI
  • P_PROJCOSTACCTGLINEITMS.CONTROLLINGAREA == CEPC.KOKRS
  • P_PROJCOSTACCTGLINEITMS.PROFITCENTER == CEPC.PRCTR
Project Internal ID
  • Client
  • Project Internal ID
  • P_PROJCOSTACCTGLINEITMS.MANDT == PROJ.MANDT
  • P_PROJCOSTACCTGLINEITMS.PROJECTINTERNALID == PROJ.PSPNR
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Source Logical System P_PROJCOSTACCTGLINEITMS.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type P_PROJCOSTACCTGLINEITMS.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Transaction Currency
  • Client
  • Transaction Currency
  • P_PROJCOSTACCTGLINEITMS.MANDT == TCURC.MANDT
  • P_PROJCOSTACCTGLINEITMS.TRANSACTIONCURRENCY == TCURC.WAERS