I_ACTUALPLANJOURNALENTRYITEM
Actual Plan for Journal Entry Item
I_ACTUALPLANJOURNALENTRYITEM is a CDS View in S/4HANA. Actual Plan for Journal Entry Item. It contains 274 fields. 14 CDS views read from this table.
CDS Views using this table (14)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_PnLPlnActlCmtmtJrnlEntrItmQ | view | from | CONSUMPTION | P&L – Plan/Actual/Committed |
| C_REAcctgObjectPlanActualQ | view | from | CONSUMPTION | RE Accounting Objects Plan/Actuals - Qry |
| I_ActlPlnSrvcMargItemCube | view_entity | from | COMPOSITE | Actual and Plan Service Marg Item - Cube |
| I_ActualPlanJrnlEntryItemCube | view | from | COMPOSITE | Actual Plan of Journal Entry Item - Cube |
| I_ActualPlanServiceCube | view_entity | from | COMPOSITE | Service Plan Actuals - Cube |
| I_JVAActualBudgetLineItem | view | from | COMPOSITE | Actual Cost and JV Budget |
| I_MaintOrdActlPlndCostCube | view | from | COMPOSITE | Maint Order Actual Planned Cost - Cube |
| I_PubSecBdgtActlItemBasic | view | from | COMPOSITE | Budget Cmtmt and Actual Items Basic |
| P_EnterpriseProjectRankingCost | view | from | COMPOSITE | |
| P_ProjActlPlnJrnlEntrItm | view | from | COMPOSITE | |
| P_ProjCostAcctgLineItms | view | from | COMPOSITE | |
| P_ProjectBudgetItems | view | inner | COMPOSITE | |
| P_ProjectFinancialSummary | view | from | COMPOSITE | |
| P_WPMO_PROJCOSTLINEITEMS | view | from | COMPOSITE |
Fields (274)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AccountingDocument | AccountingDocument | 2 |
| KEY | ActualPlanJournalEntryItem | ActualPlanJournalEntryItem | 1 |
| KEY | CompanyCode | CompanyCode | 5 |
| KEY | FinancialPlanningDataPacket | FinancialPlanningDataPacket | 1 |
| KEY | FinancialPlanningReqTransSqnc | FinancialPlanningReqTransSqnc | 1 |
| KEY | FiscalPeriod | FiscalPeriod | 4 |
| KEY | FiscalYear | FiscalYear | 2 |
| KEY | FiscalYearPeriod | FiscalYearPeriod | 3 |
| KEY | GlobalCurrency | GlobalCurrency | 2 |
| KEY | Ledger | Ledger | 2 |
| KEY | LedgerFiscalYear | LedgerFiscalYear | 2 |
| KEY | PostingDate | PostingDate | 3 |
| KEY | Project | Project | 2 |
| KEY | ProjectExternalID | Project,ProjectExternalID | 6 |
| KEY | ProjectInternalID | ProjectInternalID | 6 |
| KEY | SourceLedger | SourceLedger | 2 |
| KEY | WBSElement | WBSElement | 1 |
| _AccountingDocumentType | _AccountingDocumentType | 1 | |
| _BillingDocumentType | _BillingDocumentType | 1 | |
| _BillToParty | _BillToParty | 1 | |
| _BudgetingType | _BudgetingType | 1 | |
| _BudgetPeriod | _BudgetPeriod | 1 | |
| _BudgetProcess | _BudgetProcess | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessTransactionType | _BusinessTransactionType | 1 | |
| _CalendarDate | _CalendarDate | 1 | |
| _CashLedgerAccount | _CashLedgerAccount | 1 | |
| _CashLedgerCompanyCode | _CashLedgerCompanyCode | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _ControllingDebitCreditCode | _ControllingDebitCreditCode | 1 | |
| _CostAnalysisResource | _CostAnalysisResource | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _CostCtrActivityType | _CostCtrActivityType | 1 | |
| _CostSourceUnit | _CostSourceUnit | 1 | |
| _CurrentCostCenter | _CurrentCostCenter | 1 | |
| _CurrentProfitCenter | _CurrentProfitCenter | 1 | |
| _Customer | _Customer | 1 | |
| _CustomerGroup | _CustomerGroup | 1 | |
| _CustomerSupplierCountry | _CustomerSupplierCountry | 1 | |
| _CustomerSupplierIndustryText | _CustomerSupplierIndustryText | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _Employment | _Employment | 1 | |
| _FinancialAccountType | _FinancialAccountType | 1 | |
| _FinancialManagementArea | _FinancialManagementArea | 1 | |
| _FinancialTransactionType | _FinancialTransactionType | 1 | |
| _FiscalCalendarDate | _FiscalCalendarDate | 1 | |
| _FiscalPeriodForVariant | _FiscalPeriodForVariant | 1 | |
| _FiscalYear | _FiscalYear | 1 | |
| _FiscalYearPeriodForVariant | _FiscalYearPeriodForVariant | 1 | |
| _FiscalYearVariant | _FiscalYearVariant | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _Fund | _Fund | 1 | |
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | 1 | |
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | 1 | |
| _GlobalCurrency | _GlobalCurrency | 1 | |
| _Grant | _Grant | 1 | |
| _InternalOrder | _InternalOrder | 1 | |
| _JournalEntry | _JournalEntry | 1 | |
| _Ledger | _Ledger | 1 | |
| _LedgerFiscalYearForVariant | _LedgerFiscalYearForVariant | 1 | |
| _MaintenanceOrder | _MaintenanceOrder | 2 | |
| _MaintenanceOrderOperation | _MaintenanceOrderOperation | 2 | |
| _Order | _Order | 1 | |
| _OrganizationDivision | _OrganizationDivision | 1 | |
| _OriginCostCenter | _OriginCostCenter | 1 | |
| _OriginCostCtrActivityType | _OriginCostCtrActivityType | 1 | |
| _OriginProfitCenter | _OriginProfitCenter | 1 | |
| _PartnerBudgetPeriod | _PartnerBudgetPeriod | 1 | |
| _PartnerBusinessArea | _PartnerBusinessArea | 1 | |
| _PartnerCompany | _PartnerCompany | 1 | |
| _PartnerCompanyCode | _PartnerCompanyCode | 1 | |
| _PartnerCostCenter | _PartnerCostCenter | 1 | |
| _PartnerCostCtrActivityType | _PartnerCostCtrActivityType | 1 | |
| _PartnerFunctionalArea | _PartnerFunctionalArea | 1 | |
| _PartnerFund | _PartnerFund | 1 | |
| _PartnerGrant | _PartnerGrant | 1 | |
| _PartnerOrder | _PartnerOrder | 1 | |
| _PartnerOrder_2 | _PartnerOrder_2 | 1 | |
| _PartnerProfitCenter | _PartnerProfitCenter | 1 | |
| _PartnerProjectBasicData | _PartnerProjectBasicData | 1 | |
| _PartnerProjectExternalID | _PartnerProjectExternalID | 1 | |
| _PartnerSegment | _PartnerSegment | 1 | |
| _PartnerWBSElementBasicData | _PartnerWBSElementBasicData | 1 | |
| _PartnerWBSElementExternalID | _PartnerWBSElementExternalID | 1 | |
| _PlanningCategory | _PlanningCategory | 1 | |
| _Plant | _Plant | 1 | |
| _Product | _Product | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProjectBasicData | _ProjectBasicData | 1 | |
| _ProjectExternalID | _ProjectExternalID | 1 | |
| _ProjectExternalIDText | _ProjectExternalIDText | 1 | |
| _PubSecBudgetCnsmpnAmtType | _PubSecBdgtCnsmpnAmtType | 1 | |
| _PubSecBudgetCnsmpnType | _PubSecBdgtCnsmpnType | 1 | |
| _SalesDistrict | _SalesDistrict | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesDocumentItem | _SalesDocumentItem | 1 | |
| _SalesOrganization | _SalesOrganization | 1 | |
| _Segment | _Segment | 1 | |
| _SemTagGLAccount | _SemTagGLAccount | 1 | |
| _ServiceContract | _ServiceContract | 1 | |
| _ServiceContractItem | _ServiceContractItem | 1 | |
| _ServiceContractType | _ServiceContractType | 1 | |
| _ServiceDocument | _ServiceDocument | 1 | |
| _ServiceDocumentItem | _ServiceDocumentItem | 1 | |
| _ServiceDocumentType | _ServiceDocumentType | 1 | |
| _ShipToParty | _ShipToParty | 1 | |
| _SoldProduct | _SoldProduct | 1 | |
| _SourceLedger | _SourceLedger | 1 | |
| _Supplier | _Supplier | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| _WBSElementBasicData | _WBSElementBasicData | 1 | |
| _WBSElementExternalID | _WBSElementExternalID | 1 | |
| _WorkCenter | _WorkCenter | 1 | |
| _WorkPackage | _WorkPackage | 1 | |
| _WorkPackageWorkItem | _WorkPackageWorkItem | 1 | |
| AccountAssignmentType | AccountAssignmentType | 1 | |
| AccountingDocumentType | AccountingDocumentType | 1 | |
| AcctgDocTypeAuthorizationGroup | AcctgDocTypeAuthorizationGroup | 1 | |
| ActlPanDiffValuationQuantity | ActlPanDiffValuationQuantity | 1 | |
| ActlPlnDiffAmtInCoCodeCrcy | ActlPlnDiffAmtInCoCodeCrcy | 1 | |
| ActlPlnDiffAmtInGlobalCrcy | ActlPlnDiffAmtInGlobalCrcy | 1 | |
| ActlPlnDiffAmtInTransCrcy | ActlPlnDiffAmtInTransCrcy | 1 | |
| ActualAmountInCompanyCodeCrcy | ActualAmountInCompanyCodeCrcy | 1 | |
| ActualAmountInGlobalCurrency | ActualAmountInGlobalCurrency | 1 | |
| ActualAmountInTransactionCrcy | ActualAmountInTransactionCrcy | 1 | |
| ActualPlanCode | ActualPlanCode | 1 | |
| ActualValuationQuantity | ActualValuationQuantity | 2 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 1 | |
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | 1 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 2 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| Assembly | Assembly | 1 | |
| AssetClass | AssetClass | 1 | |
| BaseUnit | MaterialBaseUnit | 1 | |
| BillingDocumentType | BillingDocumentType | 1 | |
| BillToParty | BillToParty | 1 | |
| BudgetDocWorkFlowStatus | BudgetDocWorkFlowStatus | 1 | |
| BudgetingType | BudgetingType | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BudgetProcess | BudgetProcess | 2 | |
| BusinessArea | BusinessArea | 2 | |
| BusinessTransactionType | BusinessTransactionType | 2 | |
| CashLedgerAccount | CashLedgerAccount | 1 | |
| CashLedgerCompanyCode | CashLedgerCompanyCode | 1 | |
| ChartOfAccounts | ChartOfAccounts | 5 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| ControllingArea | ControllingArea | 4 | |
| ControllingDebitCreditCode | ControllingDebitCreditCode | 2 | |
| CostAnalysisResource | CostAnalysisResource | 1 | |
| CostCenter | CostCenter,CostCenterCompanyCode | 5 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CostSourceUnit | CostSourceUnit | 2 | |
| CreationDate | CreationDate | 1 | |
| Customer | Customer | 1 | |
| CustomerBasicAuthorizationGrp | CustomerBasicAuthorizationGrp | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerSupplierCorporateGroup | CustomerSupplierCorporateGroup | 1 | |
| CustomerSupplierCountry | CustomerSupplierCountry | 1 | |
| CustomerSupplierIndustry | CustomerSupplierIndustry | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| Equipment | Equipment | 1 | |
| FinancialAccountType | FinancialAccountType | 1 | |
| FinancialManagementArea | FinancialManagementArea | 1 | |
| FinancialPlanningEntryItem | FinancialPlanningEntryItem | 1 | |
| FinancialTransactionType | FinancialTransactionType | 1 | |
| FiscalYearVariant | FiscalYearVariant | 5 | |
| FunctionalArea | FunctionalArea | 5 | |
| FunctionalCurrency | FunctionalCurrency | 1 | |
| FunctionalLocation | FunctionalLocation | 1 | |
| Fund | Fund | 1 | |
| GLAccount | GLAccount | 5 | |
| GLAccountAuthorizationGroup | GLAccountAuthorizationGroup | 1 | |
| GrantID | GrantID | 1 | |
| GteeMBudgetValidityNumber | GteeMBudgetValidityNumber | 1 | |
| IsCommitment | IsCommitment | 1 | |
| IsStatisticalCostCenter | IsStatisticalCostCenter | 1 | |
| IsStatisticalOrder | IsStatisticalOrder | 1 | |
| IsStatisticalSalesDocument | IsStatisticalSalesDocument | 1 | |
| LedgerGLLineItem | LedgerGLLineItem | 1 | |
| MaintenanceActivityType | MaintenanceActivityType | 1 | |
| MaintenanceOrderPlanningCode | MaintenanceOrderPlanningCode | 1 | |
| MaintPriority | MaintPriority | 1 | |
| MaintPriorityType | MaintPriorityType | 1 | |
| MMServicePackage | MMServicePackage | 1 | |
| MMServicePackageLine | MMServicePackageLine | 1 | |
| OrderID | MaintenanceOrder,OrderID | 2 | |
| OrderItem | OrderItem | 1 | |
| OrderOperation | OrderOperation | 2 | |
| OrderSuboperation | OrderSuboperation | 1 | |
| OrderType | OrderType | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| OriginCostCenter | OriginCostCenter | 1 | |
| OriginCostCtrActivityType | OriginCostCtrActivityType | 1 | |
| OriginProfitCenter | OriginProfitCenter | 1 | |
| PartnerAccountAssignmentType | PartnerAccountAssignmentType | 1 | |
| PartnerBudgetPeriod | PartnerBudgetPeriod | 1 | |
| PartnerBusinessArea | PartnerBusinessArea | 1 | |
| PartnerCompany | PartnerCompany | 1 | |
| PartnerCompanyCode | PartnerCompanyCode | 1 | |
| PartnerCostCenter | PartnerCostCenter | 1 | |
| PartnerCostCtrActivityType | PartnerCostCtrActivityType | 1 | |
| PartnerFunctionalArea | PartnerFunctionalArea | 1 | |
| PartnerFund | PartnerFund | 1 | |
| PartnerGrant | PartnerGrant | 1 | |
| PartnerOrder | PartnerOrder | 1 | |
| PartnerOrder_2 | PartnerOrder,PartnerOrder_2 | 5 | |
| PartnerProfitCenter | PartnerProfitCenter | 1 | |
| PartnerProjectExternalID | PartnerProject,PartnerProjectExternalID | 5 | |
| PartnerProjectInternalID | PartnerProjectInternalID | 1 | |
| PartnerSegment | PartnerSegment | 1 | |
| PartnerWBSElement | PartnerWBSElement | 1 | |
| PartnerWBSElementExternalID | PartnerWBSElement,PartnerWBSElementExternalID | 4 | |
| PartnerWBSElementInternalID | PartnerWBSElementInternalID | 1 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| PlanAmountInCompanyCodeCrcy | PlanAmountInCompanyCodeCrcy | 1 | |
| PlanAmountInGlobalCurrency | PlanAmountInGlobalCurrency | 1 | |
| PlanAmountInTransactionCrcy | PlanAmountInTransactionCrcy | 1 | |
| PlanningCategory | PlanningCategory | 4 | |
| PlanPriceInCompanyCodeCurrency | PlanPriceInCompanyCodeCurrency | 1 | |
| PlanPriceInGlobalCurrency | PlanPriceInGlobalCurrency | 1 | |
| PlanPriceInTransactionCurrency | PlanPriceInTransactionCurrency | 1 | |
| Plant | Plant | 1 | |
| PlanValuationQuantity | PlanValuationQuantity | 1 | |
| Product | Product | 2 | |
| ProductGroup | ProductGroup | 1 | |
| ProfitCenter | ProfitCenter | 4 | |
| PubSecBudgetCnsmpnAmtType | PubSecBudgetCnsmpnAmtType | 1 | |
| PubSecBudgetCnsmpnDate | PubSecBudgetCnsmpnDate | 1 | |
| PubSecBudgetCnsmpnFsclPeriod | PubSecBudgetCnsmpnFsclPeriod | 1 | |
| PubSecBudgetCnsmpnFsclYear | PubSecBudgetCnsmpnFsclYear | 1 | |
| PubSecBudgetCnsmpnType | PubSecBudgetCnsmpnType | 1 | |
| ReferenceDocument | ReferenceDocument | 1 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| Reservation | Reservation | 1 | |
| ReservationItem | ReservationItem | 1 | |
| ReservationType | ReservationType | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesOrderType | SalesOrderType | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| Segment | Segment | 1 | |
| ServiceContract | ServiceContract | 1 | |
| ServiceContractItem | ServiceContractItem | 1 | |
| ServiceContractType | ServiceContractType | 1 | |
| ServiceDocument | ServiceDocument | 1 | |
| ServiceDocumentItem | ServiceDocumentItem | 1 | |
| ServiceDocumentType | ServiceDocumentType | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldProduct | SoldProduct | 1 | |
| SourceLogicalSystem | SourceLogicalSystem | 1 | |
| SourceReferenceDocSubitem | SourceReferenceDocSubitem | 1 | |
| SourceReferenceDocument | SourceReferenceDocument | 1 | |
| SourceReferenceDocumentCntxt | SourceReferenceDocumentCntxt | 1 | |
| SourceReferenceDocumentItem | SourceReferenceDocumentItem | 1 | |
| SourceReferenceDocumentType | SourceReferenceDocumentType | 1 | |
| SponsoredClass | SponsoredClass | 1 | |
| SponsoredProgram | SponsoredProgram | 1 | |
| Supplier | Supplier | 1 | |
| SupplierBasicAuthorizationGrp | SupplierBasicAuthorizationGrp | 1 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| ValuationArea | ValuationArea | 1 | |
| ValuationQuantity | ValuationQuantity | 1 | |
| WBSElementExternalID | WBSElement,WBSElementExternalID | 5 | |
| WBSElementInternalID | WBSElementInternalID | 4 | |
| WBSIsStatisticalWBSElement | WBSIsStatisticalWBSElement | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 2 | |
| WorkItem | WorkItem | 1 | |
| WorkPackage | WorkPackage | 1 |
@AbapCatalog: { sqlViewName: 'IFIACTPLNJEI',
preserveKey:true,
compiler.compareFilter:true,
buffering.status: #NOT_ALLOWED }
@AccessControl: { authorizationCheck: #CHECK,
personalData.blocking: #REQUIRED }
@Analytics: { dataCategory: #CUBE }
@EndUserText.label: 'Actual Plan for Journal Entry Item'
@ObjectModel: { usageType.sizeCategory: #XXL,
usageType.dataClass: #MIXED,
usageType.serviceQuality: #D,
supportedCapabilities: [#ANALYTICAL_PROVIDER, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE],
modelingPattern: #ANALYTICAL_CUBE }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata: { ignorePropagatedAnnotations: true,
allowExtensions:true }
@VDM.viewType: #BASIC
define view I_ActualPlanJournalEntryItem
as select from P_ActualPlanJrnlEntryItm as ActualPlanJournalEntryItem
association[0..1] to I_Ledger as _SourceLedger on $projection.SourceLedger = _SourceLedger.Ledger
association[0..1] to I_JournalEntry as _JournalEntry on $projection.CompanyCode = _JournalEntry.CompanyCode and
$projection.FiscalYear = _JournalEntry.FiscalYear and
$projection.AccountingDocument = _JournalEntry.AccountingDocument
association[0..1] to I_ControllingArea as _ControllingArea on $projection.ControllingArea = _ControllingArea.ControllingArea
association[0..1] to I_Ledger as _Ledger on $projection.Ledger = _Ledger.Ledger
association[1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association[0..1] to I_GLAccountInCompanyCode as _GLAccountInCompanyCode on $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode
and $projection.GLAccount = _GLAccountInCompanyCode.GLAccount
association[0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and
$projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount
association[1] to I_ChartOfAccounts as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
// begin DO NOT USE these associations. Use Associations ForVariant instead
association[0..1] to I_FiscalYearForCompanyCode as _FiscalYear on $projection.FiscalYear = _FiscalYear.FiscalYear and
$projection.CompanyCode = _FiscalYear.CompanyCode
association[0..1] to I_FiscalYearForCompanyCode as _LedgerFiscalYear on $projection.LedgerFiscalYear = _LedgerFiscalYear.FiscalYear
and $projection.CompanyCode = _LedgerFiscalYear.CompanyCode
association[0..1] to I_FiscalYearPeriodForCmpnyCode as _FiscalPeriod on $projection.LedgerFiscalYear = _FiscalPeriod.FiscalYear and
$projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod and
$projection.CompanyCode = _FiscalPeriod.CompanyCode
association[0..1] to I_FiscalCalYearPeriodForCoCode as _FiscalYearPeriod on $projection.CompanyCode = _FiscalYearPeriod.CompanyCode
and $projection.FiscalYearPeriod = _FiscalYearPeriod.FiscalYearPeriod
//end
association [0..1] to I_FiscalYearForVariant as _LedgerFiscalYearForVariant on $projection.LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear
and $projection.FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant
association [0..1] to I_FiscalPeriodForVariant as _FiscalPeriodForVariant on $projection.LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear
and $projection.FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod
and $projection.FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant
association [0..1] to I_FiscalYearPeriodForVariant as _FiscalYearPeriodForVariant on $projection.FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod
and $projection.FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant
association[0..1] to I_CalendarDate as _CalendarDate on $projection.PostingDate = _CalendarDate.CalendarDate
association[0..1] to I_FiscalCalendarDate as _FiscalCalendarDate on $projection.PostingDate = _FiscalCalendarDate.CalendarDate and
$projection.FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant
association[0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea
association[0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea and
$projection.ProfitCenter = _ProfitCenter.ProfitCenter
association[0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea and
$projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter and
_CurrentProfitCenter.ValidityStartDate <= $session.system_date and
_CurrentProfitCenter.ValidityEndDate >= $session.system_date
association[0..*] to I_CostCenter as _CostCenter on $projection.ControllingArea = _CostCenter.ControllingArea and
$projection.CostCenter = _CostCenter.CostCenter
association[0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea and
$projection.CostCenter = _CurrentCostCenter.CostCenter and
_CurrentCostCenter.ValidityStartDate <= $session.system_date and
_CurrentCostCenter.ValidityEndDate >= $session.system_date
association[0..1] to I_Project as _Project on $projection.Project = _Project.Project
association [0..1] to I_ProjectByExternalID as _ProjectExternalID on $projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID
association [0..1] to I_ProjectByExternalID as _ProjectExternalIDText on $projection.ProjectExternalID = _ProjectExternalIDText.ProjectExternalID
association [0..1] to I_ProjectByExternalID as _PartnerProjectExternalID on $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID
association [0..1] to I_ProjectByExternalID as _PartnerProjctExtrnalIDText on $projection.PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID
association[0..1] to I_WBSElement as _WBSElement on $projection.WBSElement = _WBSElement.WBSElement
association[0..1] to I_WBSElementByExternalID as _WBSElementExternalID on $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
association[0..1] to I_WBSElementByExternalID as _PartnerWBSElementExternalID on $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
association[0..1] to I_WBSElementByExternalID as _PartnerWBSElemntExtrnalIDText on $projection.PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID
association[0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea
association[0..1] to I_Segment as _Segment on $projection.Segment = _Segment.Segment
association[0..*] to I_CostCenterActivityType as _CostCtrActivityType on $projection.ControllingArea = _CostCtrActivityType.ControllingArea and
$projection.CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType
association[0..*] to I_CostAnalysisResource as _CostAnalysisResource on $projection.ControllingArea = _CostAnalysisResource.ControllingArea and
$projection.CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource
association[0..1] to I_InternalOrder as _InternalOrder on $projection.OrderID = _InternalOrder.InternalOrder
association[0..1] to I_Order as _Order on $projection.OrderID = _Order.OrderID
association[0..1] to I_WorkPackageWorkItem as _WorkPackageWorkItem on $projection.WorkItem = _WorkPackageWorkItem.WorkItem and
$projection.WorkPackage = _WorkPackageWorkItem.WorkPackage
association[0..1] to I_WorkPackage as _WorkPackage on $projection.WorkPackage = _WorkPackage.WorkPackage
association[0..1] to I_CompanyCode as _PartnerCompanyCode on $projection.PartnerCompanyCode = _PartnerCompanyCode.CompanyCode
association[0..1] to I_BusinessArea as _PartnerBusinessArea on $projection.PartnerBusinessArea = _PartnerBusinessArea.BusinessArea
association[0..*] to I_ProfitCenter as _PartnerProfitCenter on $projection.ControllingArea = _PartnerProfitCenter.ControllingArea and
$projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter
association[0..*] to I_CostCenter as _PartnerCostCenter on $projection.ControllingArea = _PartnerCostCenter.ControllingArea and
$projection.PartnerCostCenter = _PartnerCostCenter.CostCenter
association[0..1] to I_Project as _PartnerProject on $projection.PartnerProject = _PartnerProject.Project
association[0..1] to I_WBSElement as _PartnerWBSElement on $projection.PartnerWBSElement = _PartnerWBSElement.WBSElement
association[0..1] to I_FunctionalArea as _PartnerFunctionalArea on $projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea
association[0..1] to I_Segment as _PartnerSegment on $projection.PartnerSegment = _PartnerSegment.Segment
association[0..*] to I_CostCenterActivityType as _PartnerCostCtrActivityType on $projection.ControllingArea = _PartnerCostCtrActivityType.ControllingArea and
$projection.PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType
association[0..1] to I_InternalOrder as _PartnerOrder on $projection.PartnerOrder = _PartnerOrder.InternalOrder
association[0..1] to I_Order as _PartnerOrder_2 on $projection.PartnerOrder_2 = _PartnerOrder_2.OrderID
association[0..1] to I_OrderCategory as _PartnerOrderCategory on $projection.PartnerOrderCategory = _PartnerOrderCategory.OrderCategory
association[0..1] to I_Partnercompany as _PartnerCompany on $projection.PartnerCompany = _PartnerCompany.PartnerCompany
association[1] to I_FiscalYearVariant as _FiscalYearVariant on $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
association[0..1] to I_ControllingDebitCreditCode as _ControllingDebitCreditCode on $projection.ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode
association[0..1] to I_Employment as _Employment on $projection.PersonnelNumber = _Employment.EmploymentInternalID
association[0..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement_1 on $projection.PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement
association[0..1] to I_BusinessTransactionCategory as _BusinessTransactionCategory on $projection.BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory
association[0..1] to I_BusinessTransactionType as _BusinessTransactionType on $projection.BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType
association[0..1] to I_AccountingDocumentType as _AccountingDocumentType on $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
association[0..1] to I_FinancialAccountType as _FinancialAccountType on $projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType
association[0..1] to I_DebitCreditCode as _DebitCreditCode on $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode
association[0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
association[0..1] to I_Material as _Material on $projection.Material = _Material.Material //do not use any longer, use _Product
association[0..1] to I_Product as _Product on $projection.Product = _Product.Product
association[0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
association[0..1] to I_CustomerCompany as _CustomerCompany on $projection.Customer = _CustomerCompany.Customer
and $projection.CompanyCode = _CustomerCompany.CompanyCode
association[0..1] to I_SalesOrder as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder
association[0..1] to I_SalesOrderItem as _SalesOrderItem on $projection.SalesOrder = _SalesOrderItem.SalesOrder and
$projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
association[0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument
association[0..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.SalesDocument = _SalesDocumentItem.SalesDocument and
$projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
association [0..1] to I_ServiceDocumentType as _ServiceDocumentType on $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType
association [0..1] to I_SrvcDocByDocumentType as _ServiceDocument on $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocument.ServiceDocument
association [0..1] to I_SrvcDocItemByDocumentType as _ServiceDocumentItem on $projection.ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType
and $projection.ServiceDocument = _ServiceDocumentItem.ServiceDocument
and $projection.ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem
association [0..1] to I_ServiceDocumentType as _ServiceContractType on $projection.ServiceContractType = _ServiceContractType.ServiceDocumentType
association [0..1] to I_SrvcDocByDocumentType as _ServiceContract on $projection.ServiceContractType = _ServiceContract.ServiceDocumentType
and $projection.ServiceContract = _ServiceContract.ServiceDocument
association [0..1] to I_SrvcDocItemByDocumentType as _ServiceContractItem on $projection.ServiceContractType = _ServiceContractItem.ServiceDocumentType
and $projection.ServiceContract = _ServiceContractItem.ServiceDocument
and $projection.ServiceContractItem = _ServiceContractItem.ServiceDocumentItem
association[0..1] to I_BillingDocumentType as _BillingDocumentType on $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType
association[0..1] to I_SalesOrganization as _SalesOrganization on $projection.SalesOrganization = _SalesOrganization.SalesOrganization
association[0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel
association[0..1] to I_Division as _Division on $projection.Division = _Division.Division
association[0..1] to I_Division as _OrganizationDivision on $projection.OrganizationDivision = _OrganizationDivision.Division
association[0..1] to I_Material as _SoldMaterial on $projection.SoldMaterial = _SoldMaterial.Material //do not use any longer, use _SoldProduct
association[0..1] to I_Product as _SoldProduct on $projection.SoldProduct = _SoldProduct.Product
association[0..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup = _MaterialGroup.MaterialGroup //do not use any longer, use _ProductGroup
association[0..1] to I_ProductGroup as _ProductGroup on $projection.ProductGroup = _ProductGroup.MaterialGroup
association[0..1] to I_ProductGroup_2 as _ProductGroup_2 on $projection.ProductGroup = _ProductGroup_2.ProductGroup
association[0..1] to I_ProductGroup as _SoldProductGroup on $projection.SoldProductGroup = _SoldProductGroup.MaterialGroup
association[0..1] to I_ProductGroup_2 as _SoldProductGroup_2 on $projection.SoldProductGroup = _SoldProductGroup_2.ProductGroup
association[0..1] to I_CustomerGroup as _CustomerGroup on $projection.CustomerGroup = _CustomerGroup.CustomerGroup
association[0..1] to I_Country as _CustomerSupplierCountry on $projection.CustomerSupplierCountry = _CustomerSupplierCountry.Country
association[0..*] to I_SupplierIndustryText as _CustomerSupplierIndustryText on $projection.CustomerSupplierIndustry = _CustomerSupplierIndustryText.SupplierIndustry
association[0..1] to I_SalesDistrict as _SalesDistrict on $projection.SalesDistrict = _SalesDistrict.SalesDistrict
association[0..1] to I_Customer as _BillToParty on $projection.BillToParty = _BillToParty.Customer
association[0..1] to I_Customer as _ShipToParty on $projection.ShipToParty = _ShipToParty.Customer
association[0..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
association[1] to I_Currency as _CompanyCodeCurrency on $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
association[0..1] to I_Currency as _GlobalCurrency on $projection.GlobalCurrency = _GlobalCurrency.Currency
association[0..1] to I_Currency as _FunctionalCurrency on $projection.FunctionalCurrency = _FunctionalCurrency.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency1 on $projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency2 on $projection.FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency3 on $projection.FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency4 on $projection.FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency5 on $projection.FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency6 on $projection.FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency7 on $projection.FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency
association[0..1] to I_Currency as _FreeDefinedCurrency8 on $projection.FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency
association[0..1] to I_Currency as _ControllingObjectCurrency on $projection.ControllingObjectCurrency = _ControllingObjectCurrency.Currency
association[0..1] to I_UnitOfMeasure as _BaseUnit on $projection.BaseUnit = _BaseUnit.UnitOfMeasure
association[0..1] to I_UnitOfMeasure as _CostSourceUnit on $projection.CostSourceUnit = _CostSourceUnit.UnitOfMeasure
association[0..1] to I_UnitOfMeasure as _ReferenceQuantityUnit on $projection.ReferenceQuantityUnit = _ReferenceQuantityUnit.UnitOfMeasure
association[0..1] to I_PlanningCategory as _PlanningCategory on $projection.PlanningCategory = _PlanningCategory.PlanningCategory
association[0..*] to I_CostCenter as _OriginCostCenter on $projection.ControllingArea = _OriginCostCenter.ControllingArea
and $projection.OriginCostCenter = _OriginCostCenter.CostCenter
association[0..*] to I_ProfitCenter as _OriginProfitCenter on $projection.ControllingArea = _OriginProfitCenter.ControllingArea
and $projection.OriginProfitCenter = _OriginProfitCenter.ProfitCenter
association[0..*] to I_CostCenterActivityType as _OriginCostCtrActivityType on $projection.ControllingArea = _OriginCostCtrActivityType.ControllingArea
and $projection.OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType
association[0..1] to I_WorkCenter as _WorkCenter on $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
and _WorkCenter.WorkCenterTypeCode = 'A'
association [0..1] to I_BillableControl as _BillableControl on $projection.BillableControl = _BillableControl.BillableControl
association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [0..1] to I_SupplierCompany as _SupplierCompany on $projection.Supplier = _SupplierCompany.Supplier
and $projection.CompanyCode = _SupplierCompany.CompanyCode
association [0..*] to I_SemTagGLAccount as _SemTagGLAccount on $projection.GLAccount = _SemTagGLAccount.GLAccount
and $projection.ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts
association [0..1] to I_CompanyCode as _CashLedgerCompanyCode on $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode
association [0..1] to I_GLAccountInCompanyCode as _CashLedgerAccount on $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount
association [0..*] to I_FundsCenter as _FundsCenter on $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
and $projection.FundsCenter = _FundsCenter.FundsCenter
association [0..1] to I_FundedProgram as _FundedProgram on $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
and $projection.FundedProgram = _FundedProgram.FundedProgram
association [0..1] to I_Fund as _PartnerFund on $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
and $projection.PartnerFund = _PartnerFund.Fund
association [0..1] to I_Grant as _PartnerGrant on $projection.PartnerGrant = _PartnerGrant.GrantID
association [0..1] to I_BudgetPeriod as _PartnerBudgetPeriod on $projection.PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod
association [0..1] to I_CompanyCode as _PubSecBudgetAccountCoCode on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode
association [0..1] to I_PubSecBudgetAccount as _PubSecBudgetAccount on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount
association [0..1] to I_FiscCalendarDateForCompCode as _PubSecBudgetCnsmpnDate on $projection.PubSecBudgetCnsmpnDate = _PubSecBudgetCnsmpnDate.CalendarDate
and $projection.PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnDate.CompanyCode
association [0..1] to I_FiscalYearPeriodForCmpnyCode as _PubSecBudgetCnsmpnFsclPeriod on $projection.PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclPeriod.CompanyCode