P_ProjCostLineItemUnion

Project Cost Line Items Union | view: PPRCSLINITMUN | Extraction: Not supported | Component: VDM views for Costs

Tables used: AFIH, AFKO, ACDOCA, ACDOCP, FINSC_AVC_PROF, T001, TKA02, TKA01, AUFK, FINSC_LEDGER, PROJ, T000, FINSC_SEM_TAG, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, PSORDERCATMAP, FINSC_FISC_DATE, FINSC_PERIOD

🔑 Keys (8)
💰 Amounts (45)
∑ Quantities
📅 Dates (3)
☰ Categorical (8)
Other (26)
🔗 Relations (36)

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
ActlCostInProjCrcy	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
ActualAmountInGlobalCurrency	Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
ActualAmountInFunctionalCrcy	Amount in Functional Currency
CmtmtAmountInFunctionalCrcy	Amount in Functional Currency
PlanAmountInFunctionalCurrency	Amount in Functional Currency
CmtmtCostInGlobalCurrency	Amount in Global Currency
CmtmtCostInProjCrcy	Amount in CO Object Currency
CmtmtCostInFreeDefinedCrcy1	Amount in Freely Defined Currency 1
CmtmtCostInFreeDefinedCrcy2	Amount in Freely Defined Currency 2
CmtmtCostInFreeDefinedCrcy3	Amount in Freely Defined Currency 3
CmtmtCostInFreeDefinedCrcy4	Amount in Freely Defined Currency 4
CmtmtCostInFreeDefinedCrcy5	Amount in Freely Defined Currency 5
CmtmtCostInFreeDefinedCrcy6	Amount in Freely Defined Currency 6
CmtmtCostInFreeDefinedCrcy7	Amount in Freely Defined Currency 7
CmtmtCostInFreeDefinedCrcy8	Amount in Freely Defined Currency 8
PlanAmountInGlobalCurrency	Amount in Global Currency
PlndCostAmtInProjCrcy	Amount in CO Object Currency
PlanAmountInFreeDefinedCrcy1	Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy2	Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy3	Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy4	Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy5	Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy6	Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy7	Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy8	Amount in Freely Defined Currency 8
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
ActualAmountInFreeDfndCrcy1	Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
ActualAmountInFreeDfndCrcy2	Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
ActualAmountInFreeDfndCrcy3	Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
ActualAmountInFreeDfndCrcy4	Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
ActualAmountInFreeDfndCrcy5	Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
ActualAmountInFreeDfndCrcy6	Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
ActualAmountInFreeDfndCrcy7	Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
ActualAmountInFreeDfndCrcy8	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
MaintenanceOrderIsSelected	Boolean Variable (X = True, - = False, Space = Unknown)	Show values
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
AvailabilityControlIsActive	Availability control indicator(AVC)	Show values
AvailyCtrlTimeRangeType	Budget Availability Control: Time Range	Show values
BudgetCurrencyRole	Budget Availability Control: Budget Currency Type	Show values

Column Name	Description	Domain name
LedgerFiscalYear	Ledger Fiscal Year	GJAHR
LedgerGLLineItem	Ledger Journal Entry Item	DOCLN6
FinancialPlanningEntryItem	Financial Planning Entry Item	RSNUMRECORD
OrderOperation	null
MaintenanceOrderDesc	Description	TEXT40
OperationDescription	Operation Short Text	TEXT40
PlanningCategory1	Plan Category	FCOM_CATEGORY
PlanningCategory2	Plan Category	FCOM_CATEGORY
PartnerWBSElement	Partner WBS Element	FIS_WBS_NO_CONV
PartnerProject	Partner Project	FIS_PROJECT_NO_CONV
WBSElement	Work Breakdown Structure Element (WBS Element) Edited	PS_POSID_EDIT
Project	Project Number (External) Edited	PS_PSPID_EDIT
ProjectInternalID	Project (internal)	PS_S4_PROJ_PSPNR
WBSElementInternalID	WBS Element Internal ID	FIS_WBSINT_NO_CONV
SourceReferenceDocumentCntxt	Source Reference Document Context	AWORG
SourceReferenceDocument	Source Reference Document	AWREF
SourceReferenceDocumentItem	Source Reference Document Item	NUMC6
SourceReferenceDocSubitem	Source Reference Document Subitem	NUMC6
IsSettled	null
PlanningCategory	Plan Category	FCOM_CATEGORY
FiscalPeriod	Fiscal Period	POPER
FiscalYearPeriod	Fiscal Year Period	FIS_JAHRPER_CONV
SemanticTag	Semantic Tag of a Hierarchy Node	FINS_SEM_TAG
WBSDescription	WBS Element Name	TEXT40
ProjectObjectNode	Object number	J_OBJNR
ProjectDescription	Project Name	TEXT40

Master Data Relations	Join Conditions
Availability profile for project Budget Availability Control: Profile Client	`P_PROJCOSTLINEITEMUNION.AVAILABILITYCONTROLPROFILE == FINSC_AVC_PROF.PROFILE` `P_PROJCOSTLINEITEMUNION.MANDT == FINSC_AVC_PROF.MANDT`
Business Area Business Area Client	`P_PROJCOSTLINEITEMUNION.BUSINESSAREA == TGSB.GSBER` `P_PROJCOSTLINEITEMUNION.MANDT == TGSB.MANDT`
Business Transaction Type Business Transaction Type Client	`P_PROJCOSTLINEITEMUNION.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `P_PROJCOSTLINEITEMUNION.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`P_PROJCOSTLINEITEMUNION.CHARTOFACCOUNTS == T004.KTOPL` `P_PROJCOSTLINEITEMUNION.MANDT == T004.MANDT`
Company Code Company Code Client	`P_PROJCOSTLINEITEMUNION.COMPANYCODE == T001.BUKRS` `P_PROJCOSTLINEITEMUNION.MANDT == T001.MANDT`
Company Code Currency Client Company Code Currency	`P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT` `P_PROJCOSTLINEITEMUNION.COMPANYCODECURRENCY == TCURC.WAERS`
Controlling Area Controlling Area Client	`P_PROJCOSTLINEITEMUNION.CONTROLLINGAREA == TKA01.KOKRS` `P_PROJCOSTLINEITEMUNION.MANDT == TKA01.MANDT`
CO Object Currency CO Object Currency Client	`P_PROJCOSTLINEITEMUNION.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Cost Center Cost Center ? Controlling Area Client	`P_PROJCOSTLINEITEMUNION.COSTCENTER == CSKS.KOSTL` `P_PROJCOSTLINEITEMUNION.[column in domain "DATBI"] == CSKS.DATBI` `P_PROJCOSTLINEITEMUNION.CONTROLLINGAREA == CSKS.KOKRS` `P_PROJCOSTLINEITEMUNION.MANDT == CSKS.MANDT`
Activity Type ? Controlling Area Activity Type Client	`P_PROJCOSTLINEITEMUNION.[column in domain "DATBI"] == CSLA.DATBI` `P_PROJCOSTLINEITEMUNION.CONTROLLINGAREA == CSLA.KOKRS` `P_PROJCOSTLINEITEMUNION.COSTCTRACTIVITYTYPE == CSLA.LSTAR` `P_PROJCOSTLINEITEMUNION.MANDT == CSLA.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`P_PROJCOSTLINEITEMUNION.FISCALYEARVARIANT == T009.PERIV` `P_PROJCOSTLINEITEMUNION.MANDT == T009.MANDT`
Freely Defined Currency 1 Freely Defined Currency 1 Client	`P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY1 == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Freely Defined Currency 2 Freely Defined Currency 2 Client	`P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY2 == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Freely Defined Currency 3 Freely Defined Currency 3 Client	`P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY3 == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Freely Defined Currency 4 Freely Defined Currency 4 Client	`P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY4 == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Freely Defined Currency 5 Freely Defined Currency 5 Client	`P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY5 == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Freely Defined Currency 6 Client Freely Defined Currency 6	`P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT` `P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY6 == TCURC.WAERS`
Freely Defined Currency 7 Client Freely Defined Currency 7	`P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT` `P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY7 == TCURC.WAERS`
Freely Defined Currency 8 Freely Defined Currency 8 Client	`P_PROJCOSTLINEITEMUNION.FREEDEFINEDCURRENCY8 == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Functional Area Functional Area Client	`P_PROJCOSTLINEITEMUNION.FUNCTIONALAREA == TFKB.FKBER` `P_PROJCOSTLINEITEMUNION.MANDT == TFKB.MANDT`
Functional Currency Functional Currency Client	`P_PROJCOSTLINEITEMUNION.FUNCTIONALCURRENCY == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
G/L Account G/L Account Company Code Client	`P_PROJCOSTLINEITEMUNION.GLACCOUNT == SKB1.SAKNR` `P_PROJCOSTLINEITEMUNION.COMPANYCODE == SKB1.BUKRS` `P_PROJCOSTLINEITEMUNION.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`P_PROJCOSTLINEITEMUNION.GLOBALCURRENCY == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Ledger in General Ledger Accounting Ledger in General Ledger Accounting Source Ledger Client	`P_PROJCOSTLINEITEMUNION.LEDGER == FINSC_LEDGER.RLDNR` `P_PROJCOSTLINEITEMUNION.SOURCELEDGER == FINSC_LEDGER.RLDNR` `P_PROJCOSTLINEITEMUNION.MANDT == FINSC_LEDGER.MANDT`
Order ID Order ID Client	`P_PROJCOSTLINEITEMUNION.ORDERID == AUFK.AUFNR` `P_PROJCOSTLINEITEMUNION.MANDT == AUFK.MANDT`
Partner Order Partner Order Client	`P_PROJCOSTLINEITEMUNION.PARTNERORDER == AUFK.AUFNR` `P_PROJCOSTLINEITEMUNION.MANDT == AUFK.MANDT`
Profit Center ? Profit Center Profit Center Controlling Area Client	`P_PROJCOSTLINEITEMUNION.[column in domain "DATBI"] == CEPC.DATBI` `P_PROJCOSTLINEITEMUNION.PROFITCENTER == CEPC.PRCTR` `P_PROJCOSTLINEITEMUNION.WBSELEMENTPROFITCENTER == CEPC.PRCTR` `P_PROJCOSTLINEITEMUNION.CONTROLLINGAREA == CEPC.KOKRS` `P_PROJCOSTLINEITEMUNION.MANDT == CEPC.MANDT`
Profile ID for project structure Project Profile Client	`P_PROJCOSTLINEITEMUNION.PROJECTPROFILECODE == TCJ41.PROFIDPROJ` `P_PROJCOSTLINEITEMUNION.MANDT == TCJ41.MANDT`
Responsible cost center Responsible Cost Center ? ? Client	`P_PROJCOSTLINEITEMUNION.RESPONSIBLECOSTCENTER == CSKS.KOSTL` `P_PROJCOSTLINEITEMUNION.[column in domain "DATBI"] == CSKS.DATBI` `P_PROJCOSTLINEITEMUNION.[column in domain "KOKRS"] == CSKS.KOKRS` `P_PROJCOSTLINEITEMUNION.MANDT == CSKS.MANDT`
Source Ledger Ledger in General Ledger Accounting Source Ledger Client	`P_PROJCOSTLINEITEMUNION.LEDGER == FINSC_LEDGER.RLDNR` `P_PROJCOSTLINEITEMUNION.SOURCELEDGER == FINSC_LEDGER.RLDNR` `P_PROJCOSTLINEITEMUNION.MANDT == FINSC_LEDGER.MANDT`
Source Logical System	`P_PROJCOSTLINEITEMUNION.SOURCELOGICALSYSTEM == TBDLS.LOGSYS`
Source Reference Document Type	`P_PROJCOSTLINEITEMUNION.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP`
Transaction Currency Transaction Currency Client	`P_PROJCOSTLINEITEMUNION.TRANSACTIONCURRENCY == TCURC.WAERS` `P_PROJCOSTLINEITEMUNION.MANDT == TCURC.MANDT`
Profit Center ? ? Profit Center Profit Center Client	`P_PROJCOSTLINEITEMUNION.[column in domain "KOKRS"] == CEPC.KOKRS` `P_PROJCOSTLINEITEMUNION.[column in domain "DATBI"] == CEPC.DATBI` `P_PROJCOSTLINEITEMUNION.PROFITCENTER == CEPC.PRCTR` `P_PROJCOSTLINEITEMUNION.WBSELEMENTPROFITCENTER == CEPC.PRCTR` `P_PROJCOSTLINEITEMUNION.MANDT == CEPC.MANDT`