@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Accrual Simulation Entry Item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #D,
sizeCategory: #XL,
dataClass: #MIXED
}
@VDM.viewType: #BASIC
define view entity I_AccrEngnAccrSimlnEntryItem
as select from I_FinancialPlanningEntryItem
association [1..1] to I_AccrSubLdgrAcctLineItemType as _SubLdgrAcctLineItemType on $projection.SubLedgerAcctLineItemType = _SubLdgrAcctLineItemType.SubLedgerAcctLineItemType
association [1..1] to I_AccrEngnAccrTransactionType as _AccrTransactionType on $projection.accrualtransactiontype = _AccrTransactionType.AccrualTransactionType
association [1..1] to I_AccrEngineAccrObjectType as _AccrObjectType on $projection.AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType
association [0..1] to I_LogicalSystem as _AccrLogicalSystem on $projection.AccrualObjectLogicalSystem = _AccrLogicalSystem.LogicalSystem
association [0..1] to I_AccrEngineAccrItemTypeBasic as _AccrItemType on $projection.AccrualEngineAccrualObjectType = _AccrItemType.AccrualEngineAccrualObjectType
and $projection.AccrualItemType = _AccrItemType.AccrualItemType
association [0..1] to I_ChartOfAccounts as _OffsettingChartOfAccounts on $projection.OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts
association [0..1] to I_GLAccountInChartOfAccounts as _OffstgGLAcctInChartOfAccounts on $projection.OffsettingChartOfAccounts = _OffstgGLAcctInChartOfAccounts.ChartOfAccounts
and $projection.OffsettingAccount = _OffstgGLAcctInChartOfAccounts.GLAccount
association [0..1] to I_WBSElementByExternalID as _WBSElementByExternalID on $projection.wbselementexternalid = _WBSElementByExternalID.WBSElementExternalID
association [0..1] to I_ProjectByExternalID as _ProjectByExternalID on $projection.projectexternalid = _ProjectByExternalID.ProjectExternalID
association [0..1] to I_PlanningCategory as _PlanningCategoryForAccrual on $projection.PlanningCategory = _PlanningCategoryForAccrual.PlanningCategory
{
key cast ( FinancialPlanningReqTransSqnc as fis_fp_request_tsn preserving type ) as FinancialPlanningReqTransSqnc,
key FinancialPlanningDataPacket,
key FinancialPlanningEntryItem,
/***********************Accrual reference**********************************/
@ObjectModel.foreignKey.association: '_AccrObjectType'
cast( AccrualObjectType as ace_comp preserving type ) as AccrualEngineAccrualObjectType,
@ObjectModel.foreignKey.association: '_AccrLogicalSystem'
cast ( AccrualObjectLogicalSystem as ace_logsys preserving type ) as AccrualObjectLogicalSystem,
AccrualObject,
AccrualSubobject,
@ObjectModel.foreignKey.association: '_AccrItemType'
AccrualItemType,
AccrualReferenceObject,
AccrualValueDate,
@ObjectModel.foreignKey.association: '_AccrTransactionType'
_SubLdgrAcctLineItemType.AccrualTransactionType,
@ObjectModel.foreignKey.association: '_ControllingArea'
I_FinancialPlanningEntryItem.ControllingArea,
@ObjectModel.foreignKey.association: '_CompanyCode'
I_FinancialPlanningEntryItem.CompanyCode,
@ObjectModel.foreignKey.association: '_Ledger'
I_FinancialPlanningEntryItem.Ledger,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
cast( I_FinancialPlanningEntryItem.GLAccount as ace_accrual_account preserving type ) as GLAccount,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
I_FinancialPlanningEntryItem.ChartOfAccounts,
@ObjectModel.foreignKey.association: '_FiscalYear'
I_FinancialPlanningEntryItem.FiscalYear,
@ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant'
I_FinancialPlanningEntryItem.LedgerFiscalYear,
@ObjectModel.foreignKey.association: '_BusinessTransactionCategory'
I_FinancialPlanningEntryItem.BusinessTransactionCategory,
@ObjectModel.foreignKey.association: '_BusinessTransactionType'
I_FinancialPlanningEntryItem.BusinessTransactionType,
@ObjectModel.foreignKey.association: '_FinancialTransactionType'
I_FinancialPlanningEntryItem.FinancialTransactionType,
I_FinancialPlanningEntryItem.FinPlngEntryItemCreatedByUser,
I_FinancialPlanningEntryItem.FinPlngEntryItemCrtnDateTime,
@ObjectModel.foreignKey.association: '_BusinessArea'
I_FinancialPlanningEntryItem.BusinessArea,
@ObjectModel.foreignKey.association: '_ProfitCenter'
I_FinancialPlanningEntryItem.ProfitCenter,
@ObjectModel.foreignKey.association: '_CostCenter'
I_FinancialPlanningEntryItem.CostCenter,
@ObjectModel.foreignKey.association: '_ProjectBasicData'
I_FinancialPlanningEntryItem.ProjectInternalID,
@ObjectModel.foreignKey.association: '_ProjectByExternalID'
_ProjectBasicData.ProjectExternalID,
@ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
I_FinancialPlanningEntryItem.PartnerProjectInternalID,
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
I_FinancialPlanningEntryItem.WBSElementInternalID,
@ObjectModel.foreignKey.association: '_WBSElementByExternalID'
I_FinancialPlanningEntryItem._WBSElementBasicData.WBSElementExternalID,
@ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
I_FinancialPlanningEntryItem.PartnerWBSElementInternalID,
@ObjectModel.foreignKey.association: '_FunctionalArea'
I_FinancialPlanningEntryItem.FunctionalArea,
@ObjectModel.foreignKey.association: '_Segment'
I_FinancialPlanningEntryItem.Segment,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
I_FinancialPlanningEntryItem.CostCtrActivityType,
@ObjectModel.foreignKey.association: '_CostAnalysisResource'
I_FinancialPlanningEntryItem.CostAnalysisResource,
@ObjectModel.foreignKey.association: '_WorkPackage'
I_FinancialPlanningEntryItem.WorkPackage,
@ObjectModel.foreignKey.association: '_WorkPackageWorkItem'
I_FinancialPlanningEntryItem.WorkItem,
I_FinancialPlanningEntryItem.BillableControl,
I_FinancialPlanningEntryItem.IsLotSizeIndependent,
@Semantics: { quantity : {unitOfMeasure: 'LotSizeUnit'} }
I_FinancialPlanningEntryItem.CostingLotSize,
@ObjectModel.foreignKey.association: '_LotSizeUnit'
I_FinancialPlanningEntryItem.LotSizeUnit,
@ObjectModel.foreignKey.association: '_PartnerCompanyCode'
I_FinancialPlanningEntryItem.PartnerCompanyCode,
@ObjectModel.foreignKey.association: '_OriginCostCenter'
I_FinancialPlanningEntryItem.OriginCostCenter,
@ObjectModel.foreignKey.association: '_OriginCostCtrActivityType'
I_FinancialPlanningEntryItem.OriginCostCtrActivityType,
@ObjectModel.foreignKey.association: '_PartnerBusinessArea'
I_FinancialPlanningEntryItem.PartnerBusinessArea,
@ObjectModel.foreignKey.association: '_PartnerSegment'
I_FinancialPlanningEntryItem.PartnerSegment,
@ObjectModel.foreignKey.association: '_PartnerProfitCenter'
I_FinancialPlanningEntryItem.PartnerProfitCenter,
@ObjectModel.foreignKey.association: '_PartnerCostCenter'
I_FinancialPlanningEntryItem.PartnerCostCenter,
@ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
I_FinancialPlanningEntryItem.PartnerFunctionalArea,
@ObjectModel.foreignKey.association: '_PartnerCostCtrActivityType'
I_FinancialPlanningEntryItem.PartnerCostCtrActivityType,
@ObjectModel.foreignKey.association: '_Order'
I_FinancialPlanningEntryItem.OrderID,
// @ObjectModel.foreignKey.association: '_PartnerOrder_2'
// I_FinancialPlanningEntryItem.PartnerOrder_2,
@ObjectModel.foreignKey.association: '_PartnerCompany'
I_FinancialPlanningEntryItem.PartnerCompany,
I_FinancialPlanningEntryItem.ReferenceDocumentType,
I_FinancialPlanningEntryItem.ReferenceDocumentContext,
I_FinancialPlanningEntryItem.ReferenceDocument,
/******************************Amounts**********************************/
@ObjectModel.foreignKey.association: '_TransactionCurrency'
TransactionCurrency,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
cast( AmountInTransactionCurrency as ace_smltd_accr_amnt_wcurr preserving type ) as SmltdAccrAmtInTransCrcy,
@ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
CompanyCodeCurrency,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast( AmountInCompanyCodeCurrency as ace_smltd_accr_amnt_hcurr preserving type ) as SmltdAccrAmtInCoCodeCrcy,
@ObjectModel.foreignKey.association: '_GlobalCurrency'
GlobalCurrency,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast( AmountInGlobalCurrency as ace_smltd_accr_amnt_kcurr preserving type ) as SmltdAccrAmtInGlobCrcy,
// I_FinancialPlanningEntryItem.FunctionalCurrency,
// I_FinancialPlanningEntryItem.AmountInFunctionalCurrency,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency1,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency1,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency2,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency2,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency3,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency3,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency4,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency4,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency5,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency5,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency6,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency6,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency7,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency7,
// I_FinancialPlanningEntryItem.FreeDefinedCurrency8,
// I_FinancialPlanningEntryItem.AmountInFreeDefinedCurrency8,
// I_FinancialPlanningEntryItem.ControllingObjectCurrency,
// I_FinancialPlanningEntryItem.AmountInObjectCurrency,
// I_FinancialPlanningEntryItem.FixedAmountInGlobalCrcy,
// I_FinancialPlanningEntryItem.FixedAmountInCoCodeCrcy,
@ObjectModel.foreignKey.association: '_CostSourceUnit'
I_FinancialPlanningEntryItem.CostSourceUnit,
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
I_FinancialPlanningEntryItem.ValuationQuantity,
@ObjectModel.foreignKey.association: '_ReferenceQuantityUnit'
I_FinancialPlanningEntryItem.ReferenceQuantityUnit,
@Semantics: { quantity : {unitOfMeasure: 'ReferenceQuantityUnit'} }
I_FinancialPlanningEntryItem.ReferenceQuantity,
@ObjectModel.foreignKey.association: '_FiscalYearVariant'
I_FinancialPlanningEntryItem.FiscalYearVariant,
@ObjectModel.foreignKey.association: '_FiscalPeriodForVariant'
I_FinancialPlanningEntryItem.FiscalPeriod,
@ObjectModel.foreignKey.association: '_FiscalYearPeriodForVariant'
I_FinancialPlanningEntryItem.FiscalYearPeriod,
I_FinancialPlanningEntryItem.PostingDate,
I_FinancialPlanningEntryItem.AssignmentReference,
@ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'
I_FinancialPlanningEntryItem.SubLedgerAcctLineItemType,
@ObjectModel.foreignKey.association: '_SalesDocument'
I_FinancialPlanningEntryItem.SalesDocument,
@ObjectModel.foreignKey.association: '_SalesDocumentItem'
I_FinancialPlanningEntryItem.SalesDocumentItem,
@ObjectModel.foreignKey.association: '_Plant'
I_FinancialPlanningEntryItem.Plant,
@ObjectModel.foreignKey.association: '_Product'
I_FinancialPlanningEntryItem.Product,
@ObjectModel.foreignKey.association: '_Customer'
I_FinancialPlanningEntryItem.Customer,
I_FinancialPlanningEntryItem.DocumentItemText,
I_FinancialPlanningEntryItem.ControllingObject,
@ObjectModel.foreignKey.association: '_PlanningCategory'
I_FinancialPlanningEntryItem.PlanningCategory,
I_FinancialPlanningEntryItem.AccountAssignmentType,
I_FinancialPlanningEntryItem.PartnerAccountAssignmentType,
// @ObjectModel.foreignKey.association: '_ControllingDebitCreditCode'
// I_FinancialPlanningEntryItem.ControllingDebitCreditCode,
@ObjectModel.foreignKey.association: '_Employment'
I_FinancialPlanningEntryItem.PersonnelNumber,
@ObjectModel.foreignKey.association: '_ServiceDocumentType'
I_FinancialPlanningEntryItem.ServiceDocumentType,
@ObjectModel.foreignKey.association: '_ServiceDocument'
I_FinancialPlanningEntryItem.ServiceDocument,
@ObjectModel.foreignKey.association: '_ServiceDocumentItem'
I_FinancialPlanningEntryItem.ServiceDocumentItem,
@ObjectModel.foreignKey.association: '_ServiceContractType'
I_FinancialPlanningEntryItem.ServiceContractType,
@ObjectModel.foreignKey.association: '_ServiceContract'
I_FinancialPlanningEntryItem.ServiceContract,
@ObjectModel.foreignKey.association: '_ServiceContractItem'
I_FinancialPlanningEntryItem.ServiceContractItem,
I_FinancialPlanningEntryItem.ProjectNetwork,
@ObjectModel.foreignKey.association: '_OffstgGLAcctInChartOfAccounts'
I_FinancialPlanningEntryItem.OffsettingAccount,
I_FinancialPlanningEntryItem.OffsettingAccountType,
@ObjectModel.foreignKey.association: '_OffsettingChartOfAccounts'
I_FinancialPlanningEntryItem.OffsettingChartOfAccounts,
I_FinancialPlanningEntryItem.IsStatisticalOrder,
I_FinancialPlanningEntryItem.IsStatisticalCostCenter,
I_FinancialPlanningEntryItem.IsStatisticalSalesDocument,
I_FinancialPlanningEntryItem.WBSIsStatisticalWBSElement,
@ObjectModel.foreignKey.association: '_BillingDocumentType'
I_FinancialPlanningEntryItem.BillingDocumentType,
@ObjectModel.foreignKey.association: '_SalesOrganization'
I_FinancialPlanningEntryItem.SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
I_FinancialPlanningEntryItem.DistributionChannel,
@ObjectModel.foreignKey.association: '_OrganizationDivision'
I_FinancialPlanningEntryItem.OrganizationDivision,
@ObjectModel.foreignKey.association: '_SoldProduct'
I_FinancialPlanningEntryItem.SoldProduct,
// @ObjectModel.foreignKey.association: '_SoldProductGroup'
I_FinancialPlanningEntryItem.SoldProductGroup,
// @ObjectModel.foreignKey.association: '_ProductGroup_2'
I_FinancialPlanningEntryItem.ProductGroup,
@ObjectModel.foreignKey.association: '_CustomerGroup'
I_FinancialPlanningEntryItem.CustomerGroup,
@ObjectModel.foreignKey.association: '_CustomerSupplierCountry'
I_FinancialPlanningEntryItem.CustomerSupplierCountry,
I_FinancialPlanningEntryItem.CustomerSupplierIndustry,
@ObjectModel.foreignKey.association: '_SalesDistrict'
I_FinancialPlanningEntryItem.SalesDistrict,
@ObjectModel.foreignKey.association: '_BillToParty'
I_FinancialPlanningEntryItem.BillToParty,
@ObjectModel.foreignKey.association: '_ShipToParty'
I_FinancialPlanningEntryItem.ShipToParty,
I_FinancialPlanningEntryItem.CustomerSupplierCorporateGroup,
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
I_FinancialPlanningEntryItem.FinancialManagementArea,
@ObjectModel.foreignKey.association: '_Fund'
I_FinancialPlanningEntryItem.Fund,
@ObjectModel.foreignKey.association: '_Grant'
I_FinancialPlanningEntryItem.GrantID,
@ObjectModel.foreignKey.association: '_BudgetPeriod'
I_FinancialPlanningEntryItem.BudgetPeriod,
@ObjectModel.foreignKey.association: '_SponsoredProgram'
I_FinancialPlanningEntryItem.SponsoredProgram,
@ObjectModel.foreignKey.association: '_SponsoredClass'
I_FinancialPlanningEntryItem.SponsoredClass,
I_FinancialPlanningEntryItem.GteeMBudgetValidityNumber,
@ObjectModel.foreignKey.association: '_BudgetProcess'
I_FinancialPlanningEntryItem.BudgetProcess,
@ObjectModel.foreignKey.association: '_BudgetingType'
I_FinancialPlanningEntryItem.BudgetingType,
I_FinancialPlanningEntryItem.WorkCenterInternalID,
// I_FinancialPlanningEntryItem.OrderOperation,conversion ATC
I_FinancialPlanningEntryItem.OrderItem,
I_FinancialPlanningEntryItem.PartnerOrderItem,
// I_FinancialPlanningEntryItem.OrderSuboperation, conversion ATC
@ObjectModel.foreignKey.association: '_Equipment'
I_FinancialPlanningEntryItem.Equipment,
// @ObjectModel.foreignKey.association: '_FunctionalLocation'
// I_FinancialPlanningEntryItem.FunctionalLocation,
@ObjectModel.foreignKey.association: '_Assembly'
I_FinancialPlanningEntryItem.Assembly,
@ObjectModel.foreignKey.association: '_MaintenanceActivityType'
I_FinancialPlanningEntryItem.MaintenanceActivityType,
I_FinancialPlanningEntryItem.MaintenanceOrderPlanningCode,
I_FinancialPlanningEntryItem.MaintPriorityType,
I_FinancialPlanningEntryItem.MaintPriority,
I_FinancialPlanningEntryItem.SuperiorOrder,
I_FinancialPlanningEntryItem.AssetDepreciationArea,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
I_FinancialPlanningEntryItem.MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
I_FinancialPlanningEntryItem.FixedAsset,
I_FinancialPlanningEntryItem.AssetAcctTransClassfctn,
I_FinancialPlanningEntryItem.AssetClass,
I_FinancialPlanningEntryItem.JointVenture,
I_FinancialPlanningEntryItem.JointVentureEquityGroup,
I_FinancialPlanningEntryItem.JointVentureCostRecoveryCode,
I_FinancialPlanningEntryItem.JointVentureProductionDate,
I_FinancialPlanningEntryItem.Reservation,
I_FinancialPlanningEntryItem.ReservationItem,
I_FinancialPlanningEntryItem.ReservationType,
I_FinancialPlanningEntryItem.MMServicePackage,
I_FinancialPlanningEntryItem.MMServicePackageLine,
I_FinancialPlanningEntryItem.REBusinessEntity,
I_FinancialPlanningEntryItem.RealEstateBuilding,
I_FinancialPlanningEntryItem.RealEstateProperty,
I_FinancialPlanningEntryItem.RERentalObject,
I_FinancialPlanningEntryItem.RealEstateContract,
I_FinancialPlanningEntryItem.REServiceChargeKey,
I_FinancialPlanningEntryItem.RESettlementUnitID,
I_FinancialPlanningEntryItem.SettlementReferenceDate,
@ObjectModel.foreignKey.association: '_ProducedProduct'
I_FinancialPlanningEntryItem.ProducedProduct,
I_FinancialPlanningEntryItem.CostEstimateValidityStartDate,
I_FinancialPlanningEntryItem.CostEstimateValidityEndDate,
// I_FinancialPlanningEntryItem.CostOriginGroup,
// I_FinancialPlanningEntryItem.PlanPriceInGlobalCurrency,
// I_FinancialPlanningEntryItem.PlanPriceInCompanyCodeCurrency,
// I_FinancialPlanningEntryItem.PlanPriceInTransactionCurrency,
// I_FinancialPlanningEntryItem.GLAccountAuthorizationGroup,
// I_FinancialPlanningEntryItem.CustomerBasicAuthorizationGrp,
// I_FinancialPlanningEntryItem.OrderType,
// I_FinancialPlanningEntryItem.SalesOrderType,
/* Associations */
I_FinancialPlanningEntryItem._Assembly,
I_FinancialPlanningEntryItem._BillableControl,
I_FinancialPlanningEntryItem._BillingDocumentType,
I_FinancialPlanningEntryItem._BillToParty,
I_FinancialPlanningEntryItem._BudgetingType,
I_FinancialPlanningEntryItem._BudgetPeriod,
I_FinancialPlanningEntryItem._BudgetProcess,
I_FinancialPlanningEntryItem._BusinessArea,
I_FinancialPlanningEntryItem._BusinessTransactionCategory,
I_FinancialPlanningEntryItem._BusinessTransactionType,
I_FinancialPlanningEntryItem._CalendarDate,
I_FinancialPlanningEntryItem._ChartOfAccounts,
I_FinancialPlanningEntryItem._CompanyCode,
I_FinancialPlanningEntryItem._CompanyCodeCurrency,
I_FinancialPlanningEntryItem._ControllingArea,
// I_FinancialPlanningEntryItem._ControllingDebitCreditCode,
I_FinancialPlanningEntryItem._CostAnalysisResource,
I_FinancialPlanningEntryItem._CostCenter,
I_FinancialPlanningEntryItem._CostCtrActivityType,
I_FinancialPlanningEntryItem._CostSourceUnit,
I_FinancialPlanningEntryItem._CurrentCostCenter,
I_FinancialPlanningEntryItem._CurrentProfitCenter,
I_FinancialPlanningEntryItem._Customer,
I_FinancialPlanningEntryItem._CustomerCompany,
I_FinancialPlanningEntryItem._CustomerGroup,
I_FinancialPlanningEntryItem._CustomerSupplierCountry,
I_FinancialPlanningEntryItem._CustomerSupplierIndustryText,
I_FinancialPlanningEntryItem._DistributionChannel,
I_FinancialPlanningEntryItem._Employment,
I_FinancialPlanningEntryItem._Equipment,
I_FinancialPlanningEntryItem._FinancialManagementArea,
I_FinancialPlanningEntryItem._FinancialTransactionType,
I_FinancialPlanningEntryItem._FiscalCalendarDate,
I_FinancialPlanningEntryItem._FiscalYear,
I_FinancialPlanningEntryItem._FiscalPeriodForVariant,
I_FinancialPlanningEntryItem._FiscalYearPeriodForVariant,
I_FinancialPlanningEntryItem._FiscalYearVariant,
I_FinancialPlanningEntryItem._FixedAsset,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency1,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency2,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency3,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency4,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency5,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency6,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency7,
// I_FinancialPlanningEntryItem._FreeDefinedCurrency8,
I_FinancialPlanningEntryItem._FunctionalArea,
// I_FinancialPlanningEntryItem._FunctionalCurrency,
// I_FinancialPlanningEntryItem._FunctionalLocation,
I_FinancialPlanningEntryItem._Fund,
I_FinancialPlanningEntryItem._GLAccountInChartOfAccounts,
I_FinancialPlanningEntryItem._GLAccountInCompanyCode,
I_FinancialPlanningEntryItem._GlobalCurrency,
I_FinancialPlanningEntryItem._Grant,
I_FinancialPlanningEntryItem._InternalOrder,
I_FinancialPlanningEntryItem._Ledger,
I_FinancialPlanningEntryItem._LedgerFiscalYearForVariant,
I_FinancialPlanningEntryItem._LotSizeUnit,
I_FinancialPlanningEntryItem._MaintenanceActivityType,
I_FinancialPlanningEntryItem._MasterFixedAsset,
I_FinancialPlanningEntryItem._Order,
I_FinancialPlanningEntryItem._OrganizationDivision,
I_FinancialPlanningEntryItem._OriginCostCenter,
I_FinancialPlanningEntryItem._OriginCostCtrActivityType,
I_FinancialPlanningEntryItem._PartnerBusinessArea,
I_FinancialPlanningEntryItem._PartnerCompany,
I_FinancialPlanningEntryItem._PartnerCompanyCode,
I_FinancialPlanningEntryItem._PartnerCostCenter,
I_FinancialPlanningEntryItem._PartnerCostCtrActivityType,
I_FinancialPlanningEntryItem._PartnerFunctionalArea,
// I_FinancialPlanningEntryItem._PartnerOrder_2,
I_FinancialPlanningEntryItem._PartnerProfitCenter,
I_FinancialPlanningEntryItem._PartnerProjectBasicData,
I_FinancialPlanningEntryItem._PartnerSegment,
I_FinancialPlanningEntryItem._PartnerWBSElementBasicData,
I_FinancialPlanningEntryItem._PersonWorkAgreement_1,
I_FinancialPlanningEntryItem._PlanningCategory,
I_FinancialPlanningEntryItem._Plant,
I_FinancialPlanningEntryItem._ProducedProduct,
I_FinancialPlanningEntryItem._Product,
// I_FinancialPlanningEntryItem._ProductGroup,
I_FinancialPlanningEntryItem._ProductGroup_2,
I_FinancialPlanningEntryItem._ProfitCenter,
I_FinancialPlanningEntryItem._ProjectBasicData,
I_FinancialPlanningEntryItem._ReferenceQuantityUnit,
I_FinancialPlanningEntryItem._SalesDistrict,
I_FinancialPlanningEntryItem._SalesDocument,
I_FinancialPlanningEntryItem._SalesDocumentItem,
I_FinancialPlanningEntryItem._SalesOrganization,
I_FinancialPlanningEntryItem._Segment,
I_FinancialPlanningEntryItem._SemTagGLAccount,
I_FinancialPlanningEntryItem._ServiceContract,
I_FinancialPlanningEntryItem._ServiceContractItem,
I_FinancialPlanningEntryItem._ServiceContractType,
I_FinancialPlanningEntryItem._ServiceDocument,
I_FinancialPlanningEntryItem._ServiceDocumentItem,
I_FinancialPlanningEntryItem._ServiceDocumentType,
I_FinancialPlanningEntryItem._ShipToParty,
I_FinancialPlanningEntryItem._SoldProduct,
// I_FinancialPlanningEntryItem._SoldProductGroup,
I_FinancialPlanningEntryItem._SoldProductGroup_2,
I_FinancialPlanningEntryItem._SponsoredClass,
I_FinancialPlanningEntryItem._SponsoredProgram,
I_FinancialPlanningEntryItem._SubLedgerAccLineItemType,
I_FinancialPlanningEntryItem._TransactionCurrency,
I_FinancialPlanningEntryItem._User,
I_FinancialPlanningEntryItem._WBSElementBasicData,
I_FinancialPlanningEntryItem._WBSElementByInternalKey,
I_FinancialPlanningEntryItem._WorkCenter,
I_FinancialPlanningEntryItem._WorkPackage,
I_FinancialPlanningEntryItem._WorkPackageWorkItem,
_PlanningCategoryForAccrual.PlngCatIsForApplSpcfcPlngPrps1,
_PlanningCategoryForAccrual.PlngCatIsForApplSpcfcPlngPrps2,
_SubLdgrAcctLineItemType,
_AccrTransactionType,
_AccrObjectType,
_AccrLogicalSystem,
_AccrItemType,
_OffsettingChartOfAccounts,
_OffstgGLAcctInChartOfAccounts,
_WBSElementByExternalID,
_ProjectByExternalID,
_PlanningCategoryForAccrual
}
where
_PlanningCategoryForAccrual.PlngCategoryApplicationType = '07' and
_PlanningCategoryForAccrual.PlanningCategoryUsage = '000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCRSUBLDGRACCTLINEITEMTYPE",
"I_FINANCIALPLANNINGENTRYITEM",
"I_PLANNINGCATEGORY",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_ACCRENGINEACCRITEMTYPEBASIC",
"I_ACCRENGINEACCROBJECTTYPE",
"I_ACCRENGNACCRTRANSACTIONTYPE",
"I_ACCRSUBLDGRACCTLINEITEMTYPE",
"I_BILLABLECONTROL",
"I_BILLINGDOCUMENTTYPE",
"I_BUDGETINGTYPE",
"I_BUDGETPERIOD",
"I_BUDGETPROCESS",
"I_BUSINESSAREA",
"I_BUSINESSTRANSACTIONCATEGORY",
"I_BUSINESSTRANSACTIONTYPE",
"I_CALENDARDATE",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTANALYSISRESOURCE",
"I_COSTCENTER",
"I_COSTCENTERACTIVITYTYPE",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERGROUP",
"I_CUSTOMERSUPPLIERINDUSTRYTEXT",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_EMPLOYMENT",
"I_EQUIPMENT",
"I_FINANCIALMANAGEMENTAREA",
"I_FINANCIALTRANSACTIONTYPE",
"I_FISCALCALENDARDATE",
"I_FISCALPERIODFORVARIANT",
"I_FISCALYEARFORCOMPANYCODE",
"I_FISCALYEARFORVARIANT",
"I_FISCALYEARPERIODFORVARIANT",
"I_FISCALYEARVARIANT",
"I_FIXEDASSET",
"I_FUNCTIONALAREA",
"I_FUND",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTINCOMPANYCODE",
"I_GRANT",
"I_INTERNALORDER",
"I_LEDGER",
"I_LOGICALSYSTEM",
"I_MAINTENANCEACTIVITYTYPE",
"I_MASTERFIXEDASSET",
"I_ORDER",
"I_PARTNERCOMPANY",
"I_PERSONWORKAGREEMENT_1",
"I_PLANNINGCATEGORY",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTGROUP_2",
"I_PROFITCENTER",
"I_PROJECTBASICDATA",
"I_PROJECTBYEXTERNALID",
"I_SALESDISTRICT",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESORGANIZATION",
"I_SEGMENT",
"I_SEMTAGGLACCOUNT",
"I_SERVICEDOCUMENTTYPE",
"I_SPONSOREDCLASSCORE",
"I_SPONSOREDPROGRAMCORE",
"I_SRVCDOCBYDOCUMENTTYPE",
"I_SRVCDOCITEMBYDOCUMENTTYPE",
"I_SUBLEDGERACCLINEITEMTYPE",
"I_UNITOFMEASURE",
"I_USERCONTACTCARD",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYEXTERNALID",
"I_WBSELEMENTBYINTERNALKEY",
"I_WORKCENTER",
"I_WORKPACKAGE",
"I_WORKPACKAGEWORKITEM"
],
"BASE":
[
"I_FINANCIALPLANNINGENTRYITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/