@AbapCatalog: { sqlViewName: 'IFIGLICMPCUBE',
compiler.compareFilter: true,
preserveKey: true,
buffering.status: #NOT_ALLOWED,
viewEnhancementCategory: [#PROJECTION_LIST, #UNION ] }
@AccessControl: { authorizationCheck: #CHECK,
personalData.blocking: #REQUIRED }
@Analytics: { dataCategory: #CUBE,
internalName: #LOCAL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.dbHints: ['AGGR_TARGET("ACDOCA")','NO_JOIN_THRU_AGGR']
@EndUserText.label: 'Comparison of G/L Account Item - Cube'
@ObjectModel: { representativeKey: 'LedgerGLLineItem',
usageType: {sizeCategory: #XXL,
dataClass: #MIXED,
serviceQuality: #D },
supportedCapabilities: [#ANALYTICAL_PROVIDER, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE],
modelingPattern: #ANALYTICAL_CUBE }
@Metadata: { ignorePropagatedAnnotations: true,
allowExtensions:true }
@VDM.viewType: #COMPOSITE
define view I_GLAccountLineItemComprnCube
with parameters
P_FromFiscalYearPeriod : fis_fromjahrper_c_no_conv,
P_ToFiscalYearPeriod : fis_tojahrper_c_no_conv,
// P_FromPostingDate : fis_budat_from,
// P_ToPostingDate : fis_budat_to,
P_ComprnFromFiscalYearPeriod : fis_fromjahrper_comp_c_no_conv,
P_ComprnToFiscalYearPeriod : fis_tojahrper_comp_c_no_conv
// P_ComprnFromPostingDate : fis_comprn_budat_from,
// P_ComprnToPostingDate : fis_comprn_budat_to
as select from I_GLAccountLineItem
association[0..1] to I_GLAccountInChartOfAccounts as _CorporateGroupAccount on $projection.CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts
and $projection.CorporateGroupAccount = _CorporateGroupAccount.GLAccount
association[0..1] to I_ChartOfAccounts as _CorporateGroupChartOfAccounts on $projection.CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts
association[0..1] to I_GLRecordType as _GLRecordType on $projection.GLRecordType = _GLRecordType.GLRecordType
association [0..1] to I_Order as _PartnerOrder on $projection.PartnerOrder = _PartnerOrder.OrderID
association [1..1] to E_JournalEntryItem as _Extension on $projection.SourceLedger = _Extension.SourceLedger
and $projection.CompanyCode = _Extension.CompanyCode
and $projection.FiscalYear = _Extension.FiscalYear
and $projection.AccountingDocument = _Extension.AccountingDocument
and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem
{
@ObjectModel.foreignKey.association: '_Ledger'
key Ledger,
@ObjectModel.foreignKey.association: '_SourceLedger'
key SourceLedger,
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
// @Semantics.fiscal.year: true
key FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key AccountingDocument,
key LedgerGLLineItem,
// @ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant'
@Semantics.fiscal.year: true
LedgerFiscalYear,
// cast(AccountingDocument as fis_belnr) as JournalEntry,
@ObjectModel.foreignKey.association: '_GLRecordType'
GLRecordType,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
AccountingDocumentItem,
@ObjectModel.foreignKey.association: '_DebitCreditCode'
DebitCreditCode,
// Time Characteristics
// @ObjectModel.foreignKey.association: '_FiscalPeriod'
@Semantics.fiscal.period: true
case when _FiscalCalendarDate.FiscalPeriod is not null
then cast( _FiscalCalendarDate.FiscalPeriod as fis_fscl_period_rep preserving type )
else cast( '001' as fis_fscl_period_rep preserving type ) end as ReportingFiscalPeriod,
@Semantics.fiscal.period: true
FiscalPeriod,
// @ObjectModel.foreignKey.association: '_FiscalYearVariant'
@Semantics.fiscal.yearVariant: true
FiscalYearVariant,
// @ObjectModel.foreignKey.association: '_FiscalYearPeriod'
@Semantics.fiscal.yearPeriod: true
case when _FiscalCalendarDate.FiscalYearPeriod is not null
then cast( _FiscalCalendarDate.FiscalYearPeriod as fis_fyearperiod_rep preserving type )
else cast(concat( LedgerFiscalYear, '001' ) as fis_fyearperiod_rep ) end as ReportingFiscalYearPeriod,
@Semantics.fiscal.yearPeriod: true
FiscalYearPeriod,
// @Semantics.businessDate.at: true
PostingDate,
// @Semantics.businessDate.at: true
DocumentDate,
// free fields
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
AccountingDocumentType,
// cast(AccountingDocumentType as fis_blart) as JournalEntryType,
AssignmentReference,
@ObjectModel.foreignKey.association: '_PostingKey'
PostingKey,
TransactionTypeDetermination,
@ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'
SubLedgerAcctLineItemType,
AccountingDocCreatedByUser,
LastChangeDateTime,
CreationDateTime,
CreationDate,
@ObjectModel.foreignKey.association: '_AlternativeGLAccount'
AlternativeGLAccount,
@ObjectModel.foreignKey.association: '_CountryChartOfAccounts'
CountryChartOfAccounts,
@ObjectModel.foreignKey.association: '_CorporateGroupChartOfAccounts'
_ChartOfAccounts.CorporateGroupChartOfAccounts as CorporateGroupChartOfAccounts,
@ObjectModel.foreignKey.association: '_CorporateGroupAccount'
_GLAccountInChartOfAccounts.CorporateGroupAccount as CorporateGroupAccount,
_GLAccountInChartOfAccounts.IsBalanceSheetAccount,
InvoiceReference,
@Semantics.fiscal.year: true
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
InvoiceItemReference,
ReferencePurchaseOrderCategory,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
PurchasingDocumentItem,
AccountAssignmentNumber,
DocumentItemText,
// @ObjectModel.foreignKey.association: '_SalesDocument'
SalesDocument,
// @ObjectModel.foreignKey.association: '_SalesDocumentItem'
SalesDocumentItem,
@ObjectModel.foreignKey.association: '_Product'
Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_Supplier'
Supplier,
@ObjectModel.foreignKey.association: '_Customer'
Customer,
// ServicesRenderedDate,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
@ObjectModel.foreignKey.association: '_SpecialGLCode'
SpecialGLCode,
// @ObjectModel.foreignKey.association: '_TaxCode'
TaxCode,
@ObjectModel.foreignKey.association: '_HouseBank'
HouseBank,
@ObjectModel.foreignKey.association: '_HouseBankAccount'
HouseBankAccount,
@Semantics.booleanIndicator: true
IsOpenItemManaged,
ClearingDate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
@ObjectModel.foreignKey.association: '_ClearingAccountingDocument'
ClearingAccountingDocument,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
@Semantics.fiscal.year: true
ClearingDocFiscalYear,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJournalEntry'
ClearingJournalEntry,
@Semantics.fiscal.year: true
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJrnlEntryFiscalYear'
ClearingJournalEntryFiscalYear,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
AssetValueDate,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
AssetClass,
// @ObjectModel.foreignKey.association: '_InventorySpecialStockValnType'
InventorySpecialStockValnType,
@ObjectModel.foreignKey.association: '_InventorySpecialStockType'
InventorySpecialStockType,
@ObjectModel.foreignKey.association: '_InventoryValuationType'
InventoryValuationType,
// @ObjectModel.foreignKey.association: '_Purreqvaluationarea'
ValuationArea,
@ObjectModel.foreignKey.association: '_OffsettingAccountWithBP'
OffsettingAccount,
@ObjectModel.foreignKey.association: '_OffsettingAccountType'
OffsettingAccountType,
@ObjectModel.foreignKey.association: '_OffsettingChartOfAccounts'
OffsettingChartOfAccounts,
LineItemIsCompleted,
PersonnelNumber,
// @ObjectModel.foreignKey.association: '_ControllingObjectClass'
// ControllingObjectClass,
// @ObjectModel.foreignKey.association: '_PartnerControllingObjectClass'
// PartnerControllingObjectClass,
@ObjectModel.foreignKey.association: '_PartnerCompany'
PartnerCompany,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
CostCtrActivityType,
@ObjectModel.foreignKey.association: '_Order'
OrderID,
@ObjectModel.foreignKey.association: '_OrderCategory'
OrderCategory,
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
WBSElementInternalID,
@ObjectModel.foreignKey.association: '_OperatingConcern'
OperatingConcern,
@ObjectModel.foreignKey.association: '_PartnerCostCtrActivityType'
PartnerCostCtrActivityType,
@ObjectModel.foreignKey.association: '_BillingDocumentType'
BillingDocumentType,
@ObjectModel.foreignKey.association: '_SalesOrganization'
SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
DistributionChannel,
OrganizationDivision,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
AccountAssignment,
AccountAssignmentType,
@ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
AccountingDocumentCategory,
@ObjectModel.foreignKey.association: '_MovementCategory'
AssetAcctTransClassfctn,
AssetDepreciationArea,
@ObjectModel.foreignKey.association: '_BudgetPeriod'
BudgetPeriod,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
@ObjectModel.foreignKey.association: '_BusinessTransactionType'
BusinessTransactionType,
ControllingObjectDebitType,
// @ObjectModel.foreignKey.association: '_ControllingDebitCreditCode'
// ControllingDebitCreditCode,
CostEstimate,
CostObject,
// @ObjectModel.foreignKey.association: '_BillableControl'
// BillableControl,
@ObjectModel.foreignKey.association: '_CustomerGroup'
CustomerGroup,
CustomerServiceNotification,
DepreciationFiscalPeriod,
@ObjectModel.foreignKey.association: '_EliminationProfitCenter'
EliminationProfitCenter,
@ObjectModel.foreignKey.association: '_FinancialTransactionType'
FinancialTransactionType,
@ObjectModel.foreignKey.association: '_Fund'
Fund,
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
FinancialManagementArea,
@ObjectModel.foreignKey.association: '_GLAccountType'
GLAccountType,
GrantID,
@ObjectModel.foreignKey.association: '_GroupFixedAsset'
GroupFixedAsset,
@ObjectModel.foreignKey.association: '_GroupMasterFixedAsset'
GroupMasterFixedAsset,
// @ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocItm'
InventorySpclStkSalesDocItm,
// @ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocument'
InventorySpclStkSalesDocument,
@ObjectModel.foreignKey.association: '_InvtrySpclStkWBSElmntBscData'
InvtrySpclStockWBSElmntIntID,
@ObjectModel.foreignKey.association: '_InventorySpecialStockSupplier'
InventorySpecialStockSupplier,
IsReversal,
IsReversed,
IsSettled,
IsSettlement,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVentureEquityType,
@ObjectModel.foreignKey.association: '_LogicalSystem'
LogicalSystem,
@ObjectModel.foreignKey.association: '_SoldProductGroup_2'
SoldProductGroup,
@ObjectModel.foreignKey.association: '_OriginCostCenter'
OriginCostCenter,
@ObjectModel.foreignKey.association: '_OriginProfitCenter'
OriginProfitCenter,
@ObjectModel.foreignKey.association: '_OriginCostCtrActivityType'
OriginCostCtrActivityType,
OriginObjectType,
PartnerAccountAssignment,
PartnerAccountAssignmentType,
PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PartnerBusinessArea'
PartnerBusinessArea,
@ObjectModel.foreignKey.association: '_PartnerBusinessProcess'
PartnerBusinessProcess,
@ObjectModel.foreignKey.association: '_PartnerCompanyCode'
PartnerCompanyCode,
@ObjectModel.foreignKey.association: '_PartnerCostCenter'
PartnerCostCenter,
PartnerCostObject,
@ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
PartnerFunctionalArea,
@ObjectModel.foreignKey.association: '_PartnerFund'
PartnerFund,
PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerOrder'
PartnerOrder_2 as PartnerOrder,
@ObjectModel.foreignKey.association: '_PartnerOrderCategory'
PartnerOrderCategory,
@ObjectModel.foreignKey.association: '_PartnerProfitCenter'
PartnerProfitCenter,
@ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
PartnerProjectInternalID,
PartnerProjectNetwork,
// PartnerProjectNetworkActivity,
// @ObjectModel.foreignKey.association: '_PartnerSalesDocument'
PartnerSalesDocument,
// @ObjectModel.foreignKey.association: '_PartnerSalesDocumentItem'
PartnerSalesDocumentItem,
@ObjectModel.foreignKey.association: '_PartnerSegment'
PartnerSegment,
@ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
PartnerWBSElementInternalID,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocItem,
@ObjectModel.foreignKey.association: '_PredecessorReferenceDocType'
PredecessorReferenceDocType,
PredecessorReferenceDocument,
@ObjectModel.foreignKey.association: '_ProjectBasicData'
ProjectInternalID,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
QuantityIsIncomplete,
ReferenceDocument,
ReferenceDocumentContext,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
@ObjectModel.foreignKey.association: '_ReferenceDocumentType'
ReferenceDocumentType,
// RelatedNetworkActivity,
ReversalReferenceDocument,
ReversalReferenceDocumentCntxt,
SenderAccountAssignment,
SenderAccountAssignmentType,
//@ObjectModel.foreignKey.association: '_SenderGLAccount'
SenderGLAccount,
SettlementReferenceDate,
@ObjectModel.foreignKey.association: '_SoldProduct'
SoldProduct,
CostOriginGroup,
@ObjectModel.foreignKey.association: '_OriginSenderObject'
OriginSenderObject,
@ObjectModel.foreignKey.association: '_CostAnalysisResource'
CostAnalysisResource,
CustomerSupplierCountry,
CustomerSupplierIndustry,
SalesDistrict,
BillToParty,
ShipToParty,
CustomerSupplierCorporateGroup,
@ObjectModel.foreignKey.association: '_FundsCenter'
FundsCenter,
FundedProgram,
IsStatisticalOrder,
IsStatisticalCostCenter,
IsStatisticalSalesDocument,
WBSIsStatisticalWBSElement,
WorkCenterInternalID,
// OrderOperation,
// OrderItem,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
//////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_LOG_ACT: New Fields PM //
//////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
// Currency and Amount Fields
///////////////////////////////////////////////////////////////////////////////
@Semantics.currencyCode:true
BalanceTransactionCurrency,
@Semantics.currencyCode:true
TransactionCurrency,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@Semantics.currencyCode:true
GlobalCurrency,
@Semantics.currencyCode:true
FreeDefinedCurrency1,
@Semantics.currencyCode:true
FreeDefinedCurrency2,
@Semantics.currencyCode:true
FreeDefinedCurrency3,
@Semantics.currencyCode:true
FreeDefinedCurrency4,
@Semantics.currencyCode:true
FreeDefinedCurrency5,
@Semantics.currencyCode:true
FreeDefinedCurrency6,
@Semantics.currencyCode:true
FreeDefinedCurrency7,
@Semantics.currencyCode:true
FreeDefinedCurrency8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } AmountInBalanceTransacCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } AmountInTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } AmountInGlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} } AmountInFreeDefinedCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} } AmountInFreeDefinedCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} } AmountInFreeDefinedCurrency3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} } AmountInFreeDefinedCurrency4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} } AmountInFreeDefinedCurrency5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} } AmountInFreeDefinedCurrency6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} } AmountInFreeDefinedCurrency7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} } AmountInFreeDefinedCurrency8,
//////////////////////
// NEW
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } cast( 0 as fis_comprn_tsl ) as ComprnAmountInBalTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( 0 as fis_comprn_wsl ) as ComprnAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( 0 as fis_comprn_hsl ) as ComprnAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } cast( 0 as fis_comprn_ksl ) as ComprnAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} } cast( 0 as fis_comprn_osl ) as ComprnAmountInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} } cast( 0 as fis_comprn_vsl ) as ComprnAmountInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} } cast( 0 as fis_comprn_bsl ) as ComprnAmountInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} } cast( 0 as fis_comprn_csl ) as ComprnAmountInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} } cast( 0 as fis_comprn_dsl ) as ComprnAmountInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} } cast( 0 as fis_comprn_esl ) as ComprnAmountInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} } cast( 0 as fis_comprn_fsl ) as ComprnAmountInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} } cast( 0 as fis_comprn_gsl ) as ComprnAmountInFreeDfndCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
DebitAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
CreditAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
DebitAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
CreditAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
DebitAmountInBalanceTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
CreditAmountInBalanceTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
DebitAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
CreditAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
DebitAmountInFreeDefinedCrcy1 as DebitAmountInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
CreditAmountInFreeDefinedCrcy1 as CreditAmountInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
DebitAmountInFreeDefinedCrcy2 as DebitAmountInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
CreditAmountInFreeDefinedCrcy2 as CreditAmountInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
DebitAmountInFreeDefinedCrcy3 as DebitAmountInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
CreditAmountInFreeDefinedCrcy3 as CreditAmountInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
DebitAmountInFreeDefinedCrcy4 as DebitAmountInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
CreditAmountInFreeDefinedCrcy4 as CreditAmountInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
DebitAmountInFreeDefinedCrcy5 as DebitAmountInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
CreditAmountInFreeDefinedCrcy5 as CreditAmountInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
DebitAmountInFreeDefinedCrcy6 as DebitAmountInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
CreditAmountInFreeDefinedCrcy6 as CreditAmountInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
DebitAmountInFreeDefinedCrcy7 as DebitAmountInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
CreditAmountInFreeDefinedCrcy7 as CreditAmountInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
DebitAmountInFreeDefinedCrcy8 as DebitAmountInFreeDfndCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
CreditAmountInFreeDefinedCrcy8 as CreditAmountInFreeDfndCrcy8,
////////////////////////////////////
// NEW
////////////////////////////////////
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast(0 as fis_comprn_dr_hsl ) as ComprnDebitAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast(0 as fis_comprn_cr_hsl ) as ComprnCreditAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
cast(0 as fis_comprn_dr_wsl ) as ComprnDebitAmtInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
cast(0 as fis_comprn_cr_wsl ) as ComprnCreditAmtInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
cast(0 as fis_comprn_dr_tsl ) as ComprnDebitAmtInBalTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
cast(0 as fis_comprn_cr_tsl ) as ComprnCreditAmtInBalTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast(0 as fis_comprn_dr_ksl ) as ComprnDebitAmtInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast(0 as fis_comprn_cr_ksl ) as ComprnCreditAmtInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast(0 as fis_comprn_dr_osl ) as ComprnDebitAmtInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast(0 as fis_comprn_cr_osl ) as ComprnCreditAmtInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast(0 as fis_comprn_dr_vsl ) as ComprnDebitAmtInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast(0 as fis_comprn_cr_vsl ) as ComprnCreditAmtInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast(0 as fis_comprn_dr_bsl ) as ComprnDebitAmtInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast(0 as fis_comprn_cr_bsl ) as ComprnCreditAmtInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast(0 as fis_comprn_dr_csl ) as ComprnDebitAmtInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast(0 as fis_comprn_cr_csl ) as ComprnCreditAmtInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast(0 as fis_comprn_dr_dsl ) as ComprnDebitAmtInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast(0 as fis_comprn_cr_dsl ) as ComprnCreditAmtInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast(0 as fis_comprn_dr_esl ) as ComprnDebitAmtInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast(0 as fis_comprn_cr_esl ) as ComprnCreditAmtInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast(0 as fis_comprn_dr_fsl ) as ComprnDebitAmtInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast(0 as fis_comprn_cr_fsl ) as ComprnCreditAmtInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast(0 as fis_comprn_dr_gsl ) as ComprnDebitAmtInFreeDfndCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast(0 as fis_comprn_cr_gsl ) as ComprnCreditAmtInFreeDfndCrcy8,
///////////////////////////////////////////////////////////////////////////////
// Fields from associations
///////////////////////////////////////////////////////////////////////////////
// CalendarYear,
// @ObjectModel.foreignKey.association: '_CalendarQuarter'
// CalendarQuarter,
// CalendarYearQuarter,
// @ObjectModel.foreignKey.association: '_CalendarMonth'
// CalendarMonth,
// @ObjectModel.foreignKey.association: '_CalendarYearMonth'
// CalendarYearMonth,
// CalendarWeek,
// CalendarYearWeek,
_FiscalCalendarDate.FiscalQuarter as FiscalQuarter,
_FiscalCalendarDate.FiscalWeek as FiscalWeek,
_FiscalCalendarDate.FiscalYearQuarter as FiscalYearQuarter,
_FiscalCalendarDate.FiscalYearWeek as FiscalYearWeek,
///////////////////////////////////////////////////////////////////////////////
// Associations
///////////////////////////////////////////////////////////////////////////////
_JournalEntry,
_CompanyCode,
_FiscalYear,
// Do not use. DEPRECATED! Use instead _FiscalPeriodForVariant.
// _FiscalPeriod,
// _FiscalPeriodForVariant,
// Do not use. DEPRECATED! Use instead _LedgerFiscalYearForVariant.
// _LedgerFiscalYear,
// _LedgerFiscalYearForVariant,
// _FiscalYearVariant,
// Do not use. DEPRECATED! Use instead _FiscalYearPeriodForVariant.
// _FiscalYearPeriod,
_GLRecordType,
_ControllingArea,
_BalanceTransactionCurrency,
_TransactionCurrency,
_CompanyCodeCurrency,
_GlobalCurrency,
_FreeDefinedCurrency1,
_FreeDefinedCurrency2,
_FreeDefinedCurrency3,
_FreeDefinedCurrency4,
_FreeDefinedCurrency5,
_FreeDefinedCurrency6,
_FreeDefinedCurrency7,
_FreeDefinedCurrency8,
_Segment,
_ProfitCenter,
_CurrentProfitCenter,
_CostCenter,
_CurrentCostCenter,
_WBSElementBasicData,
_ProjectBasicData,
_ProjectNetwork,
_InternalOrder,
_Order,
_BusinessArea,
_FunctionalArea,
_CostCtrActivityType,
_CostAnalysisResource,
_BusinessProcess,
_OrderCategory,
// _ControllingObjectClass,
_GLAccountInChartOfAccounts,
_GLAccountInCompanyCode,
_ChartOfAccounts,
_AccountingDocumentType,
_FinancialAccountType,
_DebitCreditCode,
_Product,
// _ProductGroup,
_SoldProductGroup_2,
_Plant,
_Ledger,
_SourceLedger,
_Customer,
_CustomerGroup,
_Supplier,
_SalesDocument,
_SalesDocumentItem,
// _Order,
_ServiceDocument,
_ServiceDocumentItem,
_PostingKey,
_SubLedgerAccLineItemType,
_AccountingDocumentCategory,
_FinancialTransactionType,
_BusinessTransactionType,
_ReferenceDocumentType,
_PredecessorReferenceDocType,
// _PartnerControllingObjectClass,
_PartnerCostCenter,
_PartnerProfitCenter,
_PartnerBusinessArea,
_PartnerFunctionalArea,
_PartnerCompanyCode,
_PartnerSegment,
_PartnerCostCtrActivityType,
_PartnerOrder,
_PartnerOrderCategory,
_PartnerWBSElementBasicData,
_PartnerProjectBasicData,
_PartnerSalesDocument,
_PartnerSalesDocumentItem,
_PartnerBusinessProcess,
// _User,
_EliminationProfitCenter,
//_ControllingObject,
// _ControllingDebitCreditCode,
_GLAccountType,
_OffsettingAccountType,
_OffsettingChartOfAccounts,
//_OffsettingAccount,
_OffsettingAccountWithBP,
_AlternativeGLAccount,
//_SenderGLAccount,
_CountryChartOfAccounts,
_CorporateGroupChartOfAccounts,
_CorporateGroupAccount,
_PurchasingDocument,
_PurchasingDocumentItem,
_SpecialGLCode,
_TaxCode,
_HouseBank,
_HouseBankAccount,
_ClearingJrnlEntryFiscalYear,
_ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ClearingJournalEntry'
_ClearingAccountingDocument,
_MasterFixedAsset,
_FixedAsset,
_GroupMasterFixedAsset,
_GroupFixedAsset,
_MovementCategory,
_AssetTransactionType,
// _InventorySpecialStockValnType,
_InventorySpecialStockType,
_InventorySpclStkSalesDocument,
_InventorySpclStkSalesDocItm,
_InvtrySpclStkWBSElmntBscData,
_InventorySpecialStockSupplier,
_InventoryValuationType,
_OriginSenderObject,
_OriginCostCenter,
_OriginProfitCenter,
_OriginCostCtrActivityType,
_CostOriginGroup,
//_RelatedNetworkActivity,
//_PartnerProjectNetworkActivity,
_BillingDocumentType,
_SalesOrganization,
_DistributionChannel,
_CustomerSupplierCountry,
_SalesDistrict,
_BillToParty,
_ShipToParty,
_SoldProduct,
_FundsCenter,
_Fund,
_PartnerFund,
_FinancialManagementArea,
//_FundedProgram
_BudgetPeriod,
_LogicalSystem,
_OperatingConcern,
_PartnerCompany,
// _PurReqValuationArea,
_WorkCenter
}
where I_GLAccountLineItem.FiscalYearPeriod between $parameters.P_FromFiscalYearPeriod and $parameters.P_ToFiscalYearPeriod
and ( FiscalPeriod <> '000'
or ( I_GLAccountLineItem.FiscalYearPeriod = $parameters.P_FromFiscalYearPeriod and I_GLAccountLineItem.AccountingDocumentCategory = 'C' and FiscalPeriod = '000' ) /* get BCF only in case it is the BCF of the year selection starts from */
or ( I_GLAccountLineItem.GLRecordType = '5' and I_GLAccountLineItem.AccountingDocumentCategory = 'J') ) /* get year end and opening postings */
/* Alternative would be to select BCF always. As we have to consider BCF with non defined PostingDate where could be like below.
As also the FiscalYearPeriod Range is derived it is not possible that a BCF outside the FiscalYearPeriod Range is selected. */
//where I_GLAccountLineItem.FiscalYearPeriod between $parameters.P_ComprnFromFiscalYearPeriod and $parameters.P_ComprnToFiscalYearPeriod
//and ( I_GLAccountLineItem.PostingDate between $parameters.P_ComprnFromPostingDate and $parameters.P_ComprnToPostingDate or I_GLAccountLineItem.PostingDate = '00000000' )
// or I_GLAccountLineItem.FiscalYearPeriod = $parameters.P_ComprnFromFiscalYearPeriod // get BCF only in case it is the BCF of the year selection starts from
// or ( I_GLAccountLineItem.GLRecordType = '5' and I_GLAccountLineItem.AccountingDocumentCategory = 'J') ) // get year end and opening postings
union all
select from I_GLAccountLineItem
association[0..1] to I_GLAccountInChartOfAccounts as _CorporateGroupAccount on $projection.CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts
and $projection.CorporateGroupAccount = _CorporateGroupAccount.GLAccount
association[0..1] to I_ChartOfAccounts as _CorporateGroupChartOfAccounts on $projection.CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts
association[0..1] to I_GLRecordType as _GLRecordType on $projection.GLRecordType = _GLRecordType.GLRecordType
association [0..1] to I_Order as _PartnerOrder on $projection.PartnerOrder = _PartnerOrder.OrderID
association [1..1] to E_JournalEntryItem as _Extension on $projection.SourceLedger = _Extension.SourceLedger
and $projection.CompanyCode = _Extension.CompanyCode
and $projection.FiscalYear = _Extension.FiscalYear
and $projection.AccountingDocument = _Extension.AccountingDocument
and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem
{
@ObjectModel.foreignKey.association: '_Ledger'
key Ledger,
@ObjectModel.foreignKey.association: '_SourceLedger'
key SourceLedger,
@ObjectModel.foreignKey.association: '_CompanyCode'
key CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
// @Semantics.fiscal.year: true
key FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key AccountingDocument,
key LedgerGLLineItem,
// @ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant'
@Semantics.fiscal.year: true
LedgerFiscalYear,
// cast(AccountingDocument as fis_belnr) as JournalEntry,
@ObjectModel.foreignKey.association: '_GLRecordType'
GLRecordType,
@ObjectModel.foreignKey.association: '_ControllingArea'
ControllingArea,
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
ChartOfAccounts,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
GLAccount,
@ObjectModel.foreignKey.association: '_CostCenter'
CostCenter,
@ObjectModel.foreignKey.association: '_ProfitCenter'
ProfitCenter,
@ObjectModel.foreignKey.association: '_FunctionalArea'
FunctionalArea,
AccountingDocumentItem,
@ObjectModel.foreignKey.association: '_DebitCreditCode'
DebitCreditCode,
// Time Characteristics
// @ObjectModel.foreignKey.association: '_FiscalPeriod'
@Semantics.fiscal.period: true
case when _FiscalCalendarDate.FiscalPeriod is not null
then cast( _FiscalCalendarDate.FiscalPeriod as fis_fscl_period_rep preserving type )
else cast( '001' as fis_fscl_period_rep) end as ReportingFiscalPeriod,
@Semantics.fiscal.period: true
FiscalPeriod,
// @ObjectModel.foreignKey.association: '_FiscalYearVariant'
@Semantics.fiscal.yearVariant: true
FiscalYearVariant,
// @ObjectModel.foreignKey.association: '_FiscalYearPeriod'
@Semantics.fiscal.yearPeriod: true
case when _FiscalCalendarDate.FiscalYearPeriod is not null
then cast( _FiscalCalendarDate.FiscalYearPeriod as fis_fyearperiod_rep preserving type )
else cast(concat( LedgerFiscalYear, '001' ) as fis_fyearperiod_rep ) end as ReportingFiscalYearPeriod,
@Semantics.fiscal.yearPeriod: true
FiscalYearPeriod,
// FiscalYearPeriod as PostedFiscalYearPeriod,
// @Semantics.businessDate.at: true
PostingDate,
// @Semantics.businessDate.at: true
DocumentDate,
// free fields
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
AccountingDocumentType,
// cast(AccountingDocumentType as fis_blart) as JournalEntryType,
AssignmentReference,
@ObjectModel.foreignKey.association: '_PostingKey'
PostingKey,
TransactionTypeDetermination,
@ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'
SubLedgerAcctLineItemType,
AccountingDocCreatedByUser,
LastChangeDateTime,
CreationDateTime,
CreationDate,
@ObjectModel.foreignKey.association: '_AlternativeGLAccount'
AlternativeGLAccount,
@ObjectModel.foreignKey.association: '_CountryChartOfAccounts'
CountryChartOfAccounts,
@ObjectModel.foreignKey.association: '_CorporateGroupChartOfAccounts'
_ChartOfAccounts.CorporateGroupChartOfAccounts as CorporateGroupChartOfAccounts,
@ObjectModel.foreignKey.association: '_CorporateGroupAccount'
_GLAccountInChartOfAccounts.CorporateGroupAccount as CorporateGroupAccount,
_GLAccountInChartOfAccounts.IsBalanceSheetAccount,
InvoiceReference,
@Semantics.fiscal.year: true
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
InvoiceItemReference,
ReferencePurchaseOrderCategory,
@ObjectModel.foreignKey.association: '_PurchasingDocument'
PurchasingDocument,
@ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
PurchasingDocumentItem,
AccountAssignmentNumber,
DocumentItemText,
@ObjectModel.foreignKey.association: '_SalesDocument'
SalesDocument,
@ObjectModel.foreignKey.association: '_SalesDocumentItem'
SalesDocumentItem,
@ObjectModel.foreignKey.association: '_Product'
Product,
@ObjectModel.foreignKey.association: '_Plant'
Plant,
@ObjectModel.foreignKey.association: '_Supplier'
Supplier,
@ObjectModel.foreignKey.association: '_Customer'
Customer,
// ServicesRenderedDate,
@ObjectModel.foreignKey.association: '_FinancialAccountType'
FinancialAccountType,
@ObjectModel.foreignKey.association: '_SpecialGLCode'
SpecialGLCode,
// @ObjectModel.foreignKey.association: '_TaxCode'
TaxCode,
@ObjectModel.foreignKey.association: '_HouseBank'
HouseBank,
@ObjectModel.foreignKey.association: '_HouseBankAccount'
HouseBankAccount,
@Semantics.booleanIndicator: true
IsOpenItemManaged,
ClearingDate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
@ObjectModel.foreignKey.association: '_ClearingAccountingDocument'
ClearingAccountingDocument,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
@Semantics.fiscal.year: true
ClearingDocFiscalYear,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJournalEntry'
ClearingJournalEntry,
@Semantics.fiscal.year: true
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJrnlEntryFiscalYear'
ClearingJournalEntryFiscalYear,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
MasterFixedAsset,
@ObjectModel.foreignKey.association: '_FixedAsset'
FixedAsset,
AssetValueDate,
@ObjectModel.foreignKey.association: '_AssetTransactionType'
AssetTransactionType,
AssetClass,
// @ObjectModel.foreignKey.association: '_InventorySpecialStockValnType'
InventorySpecialStockValnType,
@ObjectModel.foreignKey.association: '_InventorySpecialStockType'
InventorySpecialStockType,
@ObjectModel.foreignKey.association: '_InventoryValuationType'
InventoryValuationType,
// @ObjectModel.foreignKey.association: '_Purreqvaluationarea'
ValuationArea,
@ObjectModel.foreignKey.association: '_OffsettingAccountWithBP'
OffsettingAccount,
@ObjectModel.foreignKey.association: '_OffsettingAccountType'
OffsettingAccountType,
@ObjectModel.foreignKey.association: '_OffsettingChartOfAccounts'
OffsettingChartOfAccounts,
LineItemIsCompleted,
PersonnelNumber,
// @ObjectModel.foreignKey.association: '_ControllingObjectClass'
// ControllingObjectClass,
// @ObjectModel.foreignKey.association: '_PartnerControllingObjectClass'
// PartnerControllingObjectClass,
@ObjectModel.foreignKey.association: '_PartnerCompany'
PartnerCompany,
@ObjectModel.foreignKey.association: '_CostCtrActivityType'
CostCtrActivityType,
@ObjectModel.foreignKey.association: '_Order'
OrderID,
@ObjectModel.foreignKey.association: '_OrderCategory'
OrderCategory,
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
WBSElementInternalID,
@ObjectModel.foreignKey.association: '_OperatingConcern'
OperatingConcern,
@ObjectModel.foreignKey.association: '_PartnerCostCtrActivityType'
PartnerCostCtrActivityType,
@ObjectModel.foreignKey.association: '_BillingDocumentType'
BillingDocumentType,
@ObjectModel.foreignKey.association: '_SalesOrganization'
SalesOrganization,
@ObjectModel.foreignKey.association: '_DistributionChannel'
DistributionChannel,
OrganizationDivision,
@ObjectModel.foreignKey.association: '_Segment'
Segment,
@ObjectModel.foreignKey.association: '_BusinessArea'
BusinessArea,
AccountAssignment,
AccountAssignmentType,
@ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
AccountingDocumentCategory,
@ObjectModel.foreignKey.association: '_MovementCategory'
AssetAcctTransClassfctn,
AssetDepreciationArea,
@ObjectModel.foreignKey.association: '_BudgetPeriod'
BudgetPeriod,
@ObjectModel.foreignKey.association: '_BusinessProcess'
BusinessProcess,
@ObjectModel.foreignKey.association: '_BusinessTransactionType'
BusinessTransactionType,
ControllingObjectDebitType,
// @ObjectModel.foreignKey.association: '_ControllingDebitCreditCode'
// ControllingDebitCreditCode,
CostEstimate,
CostObject,
@ObjectModel.foreignKey.association: '_CustomerGroup'
CustomerGroup,
CustomerServiceNotification,
DepreciationFiscalPeriod,
@ObjectModel.foreignKey.association: '_EliminationProfitCenter'
EliminationProfitCenter,
@ObjectModel.foreignKey.association: '_FinancialTransactionType'
FinancialTransactionType,
@ObjectModel.foreignKey.association: '_Fund'
Fund,
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
FinancialManagementArea,
@ObjectModel.foreignKey.association: '_GLAccountType'
GLAccountType,
GrantID,
@ObjectModel.foreignKey.association: '_GroupFixedAsset'
GroupFixedAsset,
@ObjectModel.foreignKey.association: '_GroupMasterFixedAsset'
GroupMasterFixedAsset,
@ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocItm'
InventorySpclStkSalesDocItm,
@ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocument'
InventorySpclStkSalesDocument,
@ObjectModel.foreignKey.association: '_InvtrySpclStkWBSElmntBscData'
InvtrySpclStockWBSElmntIntID,
@ObjectModel.foreignKey.association: '_InventorySpecialStockSupplier'
InventorySpecialStockSupplier,
IsReversal,
IsReversed,
IsSettled,
IsSettlement,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVentureEquityType,
@ObjectModel.foreignKey.association: '_LogicalSystem'
LogicalSystem,
@ObjectModel.foreignKey.association: '_SoldProductGroup_2'
SoldProductGroup,
@ObjectModel.foreignKey.association: '_OriginCostCenter'
OriginCostCenter,
@ObjectModel.foreignKey.association: '_OriginProfitCenter'
OriginProfitCenter,
@ObjectModel.foreignKey.association: '_OriginCostCtrActivityType'
OriginCostCtrActivityType,
OriginObjectType,
PartnerAccountAssignment,
PartnerAccountAssignmentType,
PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PartnerBusinessArea'
PartnerBusinessArea,
@ObjectModel.foreignKey.association: '_PartnerBusinessProcess'
PartnerBusinessProcess,
@ObjectModel.foreignKey.association: '_PartnerCompanyCode'
PartnerCompanyCode,
@ObjectModel.foreignKey.association: '_PartnerCostCenter'
PartnerCostCenter,
PartnerCostObject,
@ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
PartnerFunctionalArea,
@ObjectModel.foreignKey.association: '_PartnerFund'
PartnerFund,
PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerOrder'
PartnerOrder_2 as PartnerOrder,
@ObjectModel.foreignKey.association: '_PartnerOrderCategory'
PartnerOrderCategory,
@ObjectModel.foreignKey.association: '_PartnerProfitCenter'
PartnerProfitCenter,
@ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
PartnerProjectInternalID,
PartnerProjectNetwork,
// PartnerProjectNetworkActivity,
@ObjectModel.foreignKey.association: '_PartnerSalesDocument'
PartnerSalesDocument,
@ObjectModel.foreignKey.association: '_PartnerSalesDocumentItem'
PartnerSalesDocumentItem,
@ObjectModel.foreignKey.association: '_PartnerSegment'
PartnerSegment,
@ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
PartnerWBSElementInternalID,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocItem,
@ObjectModel.foreignKey.association: '_PredecessorReferenceDocType'
PredecessorReferenceDocType,
PredecessorReferenceDocument,
@ObjectModel.foreignKey.association: '_ProjectBasicData'
ProjectInternalID,
@ObjectModel.foreignKey.association: '_ProjectNetwork'
ProjectNetwork,
QuantityIsIncomplete,
ReferenceDocument,
ReferenceDocumentContext,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
@ObjectModel.foreignKey.association: '_ReferenceDocumentType'
ReferenceDocumentType,
// RelatedNetworkActivity,
ReversalReferenceDocument,
ReversalReferenceDocumentCntxt,
SenderAccountAssignment,
SenderAccountAssignmentType,
//@ObjectModel.foreignKey.association: '_SenderGLAccount'
SenderGLAccount,
SettlementReferenceDate,
@ObjectModel.foreignKey.association: '_SoldProduct'
SoldProduct,
CostOriginGroup,
@ObjectModel.foreignKey.association: '_OriginSenderObject'
OriginSenderObject,
@ObjectModel.foreignKey.association: '_CostAnalysisResource'
CostAnalysisResource,
CustomerSupplierCountry,
CustomerSupplierIndustry,
SalesDistrict,
BillToParty,
ShipToParty,
CustomerSupplierCorporateGroup,
@ObjectModel.foreignKey.association: '_FundsCenter'
FundsCenter,
FundedProgram,
IsStatisticalOrder,
IsStatisticalCostCenter,
IsStatisticalSalesDocument,
WBSIsStatisticalWBSElement,
WorkCenterInternalID,
// OrderOperation,
// OrderItem,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
//////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_LOG_ACT: New Fields PM //
//////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
// Currency and Amount Fields
///////////////////////////////////////////////////////////////////////////////
@Semantics.currencyCode:true
BalanceTransactionCurrency,
@Semantics.currencyCode:true
TransactionCurrency,
@Semantics.currencyCode:true
CompanyCodeCurrency,
@Semantics.currencyCode:true
GlobalCurrency,
@Semantics.currencyCode:true
FreeDefinedCurrency1,
@Semantics.currencyCode:true
FreeDefinedCurrency2,
@Semantics.currencyCode:true
FreeDefinedCurrency3,
@Semantics.currencyCode:true
FreeDefinedCurrency4,
@Semantics.currencyCode:true
FreeDefinedCurrency5,
@Semantics.currencyCode:true
FreeDefinedCurrency6,
@Semantics.currencyCode:true
FreeDefinedCurrency7,
@Semantics.currencyCode:true
FreeDefinedCurrency8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } cast( 0 as fis_wsl ) as AmountInBalanceTransacCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } cast( 0 as fis_tsl ) as AmountInTransactionCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } cast( 0 as fis_hsl ) as AmountInCompanyCodeCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } cast( 0 as fis_ksl ) as AmountInGlobalCurrency,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} } cast( 0 as fis_osl ) as AmountInFreeDefinedCurrency1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} } cast( 0 as fis_vsl ) as AmountInFreeDefinedCurrency2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} } cast( 0 as fis_bsl ) as AmountInFreeDefinedCurrency3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} } cast( 0 as fis_csl ) as AmountInFreeDefinedCurrency4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} } cast( 0 as fis_dsl ) as AmountInFreeDefinedCurrency5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} } cast( 0 as fis_esl ) as AmountInFreeDefinedCurrency6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} } cast( 0 as fis_fsl ) as AmountInFreeDefinedCurrency7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} } cast( 0 as fis_gsl ) as AmountInFreeDefinedCurrency8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } AmountInBalanceTransacCrcy as ComprnAmountInBalTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } AmountInTransactionCurrency as ComprnAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } AmountInCompanyCodeCurrency as ComprnAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } AmountInGlobalCurrency as ComprnAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} } AmountInFreeDefinedCurrency1 as ComprnAmountInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} } AmountInFreeDefinedCurrency2 as ComprnAmountInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} } AmountInFreeDefinedCurrency3 as ComprnAmountInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} } AmountInFreeDefinedCurrency4 as ComprnAmountInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} } AmountInFreeDefinedCurrency5 as ComprnAmountInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} } AmountInFreeDefinedCurrency6 as ComprnAmountInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} } AmountInFreeDefinedCurrency7 as ComprnAmountInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} } AmountInFreeDefinedCurrency8 as ComprnAmountInFreeDfndCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast( 0 as fis_dr_hsl ) as DebitAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast( 0 as fis_cr_hsl ) as CreditAmountInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
cast( 0 as fis_dr_wsl ) as DebitAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
cast( 0 as fis_cr_wsl ) as CreditAmountInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
cast( 0 as fis_dr_tsl ) as DebitAmountInBalanceTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
cast( 0 as fis_cr_tsl ) as CreditAmountInBalanceTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast( 0 as fis_dr_ksl ) as DebitAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast( 0 as fis_cr_ksl ) as CreditAmountInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast( 0 as fis_dr_osl ) as DebitAmountInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast( 0 as fis_cr_osl ) as CreditAmountInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast( 0 as fis_dr_vsl ) as DebitAmountInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast( 0 as fis_cr_vsl ) as CreditAmountInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast( 0 as fis_dr_bsl ) as DebitAmountInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast( 0 as fis_cr_bsl ) as CreditAmountInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast( 0 as fis_dr_csl ) as DebitAmountInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast( 0 as fis_cr_csl ) as CreditAmountInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast( 0 as fis_dr_dsl ) as DebitAmountInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast( 0 as fis_cr_dsl ) as CreditAmountInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast( 0 as fis_dr_esl ) as DebitAmountInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast( 0 as fis_cr_esl ) as CreditAmountInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast( 0 as fis_dr_fsl ) as DebitAmountInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast( 0 as fis_cr_fsl ) as CreditAmountInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast( 0 as fis_dr_gsl ) as DebitAmountInFreeDfndCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast( 0 as fis_cr_gsl ) as CreditAmountInFreeDfndCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
DebitAmountInCoCodeCrcy as ComprnDebitAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
CreditAmountInCoCodeCrcy as ComprnCreditAmtInCoCodeCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
DebitAmountInTransCrcy as ComprnDebitAmtInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
CreditAmountInTransCrcy as ComprnCreditAmtInTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
DebitAmountInBalanceTransCrcy as ComprnDebitAmtInBalTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
CreditAmountInBalanceTransCrcy as ComprnCreditAmtInBalTransCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
DebitAmountInGlobalCrcy as ComprnDebitAmtInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
CreditAmountInGlobalCrcy as ComprnCreditAmtInGlobalCrcy,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
DebitAmountInFreeDefinedCrcy1 as ComprnDebitAmtInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
CreditAmountInFreeDefinedCrcy1 as ComprnCreditAmtInFreeDfndCrcy1,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
DebitAmountInFreeDefinedCrcy2 as ComprnDebitAmtInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
CreditAmountInFreeDefinedCrcy2 as ComprnCreditAmtInFreeDfndCrcy2,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
DebitAmountInFreeDefinedCrcy3 as ComprnDebitAmtInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
CreditAmountInFreeDefinedCrcy3 as ComprnCreditAmtInFreeDfndCrcy3,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
DebitAmountInFreeDefinedCrcy4 as ComprnDebitAmtInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
CreditAmountInFreeDefinedCrcy4 as ComprnCreditAmtInFreeDfndCrcy4,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
DebitAmountInFreeDefinedCrcy5 as ComprnDebitAmtInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
CreditAmountInFreeDefinedCrcy5 as ComprnCreditAmtInFreeDfndCrcy5,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
DebitAmountInFreeDefinedCrcy6 as ComprnDebitAmtInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
CreditAmountInFreeDefinedCrcy6 as ComprnCreditAmtInFreeDfndCrcy6,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
DebitAmountInFreeDefinedCrcy7 as ComprnDebitAmtInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
CreditAmountInFreeDefinedCrcy7 as ComprnCreditAmtInFreeDfndCrcy7,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
DebitAmountInFreeDefinedCrcy8 as ComprnDebitAmtInFreeDfndCrcy8,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
CreditAmountInFreeDefinedCrcy8 as ComprnCreditAmtInFreeDfndCrcy8,
////////////////////////////////////
// NEW
////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
// Fields from associations
///////////////////////////////////////////////////////////////////////////////
// CalendarYear,
// @ObjectModel.foreignKey.association: '_CalendarQuarter'
// CalendarQuarter,
// CalendarYearQuarter,
// @ObjectModel.foreignKey.association: '_CalendarMonth'
// CalendarMonth,
// @ObjectModel.foreignKey.association: '_CalendarYearMonth'
// CalendarYearMonth,
// CalendarWeek,
// CalendarYearWeek,
_FiscalCalendarDate.FiscalQuarter as FiscalQuarter,
_FiscalCalendarDate.FiscalWeek as FiscalWeek,
_FiscalCalendarDate.FiscalYearQuarter as FiscalYearQuarter,
_FiscalCalendarDate.FiscalYearWeek as FiscalYearWeek,
///////////////////////////////////////////////////////////////////////////////
// Associations
///////////////////////////////////////////////////////////////////////////////
_JournalEntry,
_CompanyCode,
_FiscalYear,
// Do not use. DEPRECATED! Use instead _FiscalPeriodForVariant.
// _FiscalPeriod,
// _FiscalPeriodForVariant,
// Do not use. DEPRECATED! Use instead _LedgerFiscalYearForVariant.
// _LedgerFiscalYear,
// _LedgerFiscalYearForVariant,
// _FiscalYearVariant,
// Do not use. DEPRECATED! Use instead _FiscalYearPeriodForVariant.
// _FiscalYearPeriod,
_GLRecordType,
_ControllingArea,
_BalanceTransactionCurrency,
_TransactionCurrency,
_CompanyCodeCurrency,
_GlobalCurrency,
_FreeDefinedCurrency1,
_FreeDefinedCurrency2,
_FreeDefinedCurrency3,
_FreeDefinedCurrency4,
_FreeDefinedCurrency5,
_FreeDefinedCurrency6,
_FreeDefinedCurrency7,
_FreeDefinedCurrency8,
_Segment,
_ProfitCenter,
_CurrentProfitCenter,
_CostCenter,
_CurrentCostCenter,
_WBSElementBasicData,
_ProjectBasicData,
_ProjectNetwork,
_InternalOrder,
_Order,
_BusinessArea,
_FunctionalArea,
_CostCtrActivityType,
_CostAnalysisResource,
_BusinessProcess,
_OrderCategory,
// _ControllingObjectClass,
_GLAccountInChartOfAccounts,
_GLAccountInCompanyCode,
_ChartOfAccounts,
_AccountingDocumentType,
_FinancialAccountType,
_DebitCreditCode,
_Product,
// _ProductGroup,
_SoldProductGroup_2,
_Plant,
_Ledger,
_SourceLedger,
_Customer,
_CustomerGroup,
_Supplier,
_SalesDocument,
_SalesDocumentItem,
// _Order,
_ServiceDocument,
_ServiceDocumentItem,
_PostingKey,
_SubLedgerAccLineItemType,
_AccountingDocumentCategory,
_FinancialTransactionType,
_BusinessTransactionType,
_ReferenceDocumentType,
_PredecessorReferenceDocType,
// _PartnerControllingObjectClass,
_PartnerCostCenter,
_PartnerProfitCenter,
_PartnerBusinessArea,
_PartnerFunctionalArea,
_PartnerCompanyCode,
_PartnerSegment,
_PartnerCostCtrActivityType,
_PartnerOrder,
_PartnerOrderCategory,
_PartnerWBSElementBasicData,
_PartnerProjectBasicData,
_PartnerSalesDocument,
_PartnerSalesDocumentItem,
_PartnerBusinessProcess,
// _User,
_EliminationProfitCenter,
//_ControllingObject,
// _ControllingDebitCreditCode,
_GLAccountType,
_OffsettingAccountType,
_OffsettingChartOfAccounts,
//_OffsettingAccount,
_OffsettingAccountWithBP,
_AlternativeGLAccount,
//_SenderGLAccount,
_CountryChartOfAccounts,
_CorporateGroupChartOfAccounts,
_CorporateGroupAccount,
_PurchasingDocument,
_PurchasingDocumentItem,
_SpecialGLCode,
_TaxCode,
_HouseBank,
_HouseBankAccount,
_ClearingJrnlEntryFiscalYear,
_ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ClearingJournalEntry'
_ClearingAccountingDocument,
_MasterFixedAsset,
_FixedAsset,
_GroupMasterFixedAsset,
_GroupFixedAsset,
_MovementCategory,
_AssetTransactionType,
// _InventorySpecialStockValnType,
_InventorySpecialStockType,
_InventorySpclStkSalesDocument,
_InventorySpclStkSalesDocItm,
_InvtrySpclStkWBSElmntBscData,
_InventorySpecialStockSupplier,
_InventoryValuationType,
_OriginSenderObject,
_OriginCostCenter,
_OriginProfitCenter,
_OriginCostCtrActivityType,
_CostOriginGroup,
//_RelatedNetworkActivity,
//_PartnerProjectNetworkActivity,
_BillingDocumentType,
_SalesOrganization,
_DistributionChannel,
_CustomerSupplierCountry,
_SalesDistrict,
_BillToParty,
_ShipToParty,
_SoldProduct,
_FundsCenter,
_Fund,
_PartnerFund,
_FinancialManagementArea,
//_FundedProgram
_BudgetPeriod,
_LogicalSystem,
_OperatingConcern,
_PartnerCompany,
// _PurReqValuationArea,
_WorkCenter
}
where I_GLAccountLineItem.FiscalYearPeriod between $parameters.P_ComprnFromFiscalYearPeriod and $parameters.P_ComprnToFiscalYearPeriod
and ( FiscalPeriod <> '000'
or ( I_GLAccountLineItem.FiscalYearPeriod = $parameters.P_ComprnFromFiscalYearPeriod and I_GLAccountLineItem.AccountingDocumentCategory = 'C' and FiscalPeriod = '000' ) /* get BCF only in case it is the BCF of the year selection starts from */
or ( I_GLAccountLineItem.GLRecordType = '5' and I_GLAccountLineItem.AccountingDocumentCategory = 'J') ) /* get year end and opening postings */
//// Alternative would be to select BCF always. As we have to consider BCF with non defined PostingDate where could be like this.
//// As also the FiscalYearPeriod Range is derived it is not possible that a BCF outside the FiscalYearPeriod Range is selected.
//where I_GLAccountLineItem.FiscalYearPeriod between $parameters.P_ComprnFromFiscalYearPeriod and $parameters.P_ComprnToFiscalYearPeriod
//and ( I_GLAccountLineItem.PostingDate between $parameters.P_ComprnFromPostingDate and $parameters.P_ComprnToPostingDate or I_GLAccountLineItem.PostingDate = '00000000' )
// or I_GLAccountLineItem.FiscalYearPeriod = $parameters.P_ComprnFromFiscalYearPeriod // get BCF only in case it is the BCF of the year selection starts from
// or ( I_GLAccountLineItem.GLRecordType = '5' and I_GLAccountLineItem.AccountingDocumentCategory = 'J') ) // get year end and opening postings