@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Journal Entry Ledger View'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #XXL,
dataClass: #MIXED
}
@VDM: {
viewType: #COMPOSITE,
private: true
}
define view entity P_ManageJournalEntryLedgerView
as select from I_GLAccountLineItemRawData as _Item
inner join I_CoCodeLedgerSourceLedger as _LedgerSourceLedger on _Item .SourceLedger = _LedgerSourceLedger.SourceLedger
and _Item .CompanyCode = _LedgerSourceLedger.CompanyCode
{
key cast( '' as fins_technical_ledger ) as TechnicalLedger,
key _LedgerSourceLedger.Ledger as SourceLedger,
key _Item.CompanyCode,
key _Item.FiscalYear,
key _Item.AccountingDocument,
key _Item.LedgerGLLineItem,
_Item.LedgerFiscalYear,
_Item.GLRecordType,
_Item.JrnlEntrAltvFYConsecutiveID,
_Item.ControllingArea,
_Item.BusinessTransactionCategory,
_Item.BusinessTransactionType,
_Item.ReferenceDocumentType,
_Item.ReferenceDocumentContext,
_Item.ReferenceDocument,
_Item.ReferenceDocumentItem,
_Item.ReferenceDocumentItemGroup,
_Item.FinancialTransactionType,
_Item.IsReversal,
_Item.IsReversed,
_Item.ReversalReferenceDocumentCntxt,
_Item.ReversalReferenceDocument,
_Item.IsSettlement,
_Item.IsSettled,
_Item.PredecessorReferenceDocCntxt,
_Item.PredecessorReferenceDocItem,
_Item.PredecessorReferenceDocType,
_Item.PredecessorReferenceDocument,
_Item.SourceReferenceDocument,
_Item.SourceReferenceDocumentType,
_Item.SourceReferenceDocumentItem,
_Item.SourceReferenceDocumentCntxt,
_Item.SourceLogicalSystem,
_Item.SourceReferenceDocSubitem,
_Item.IsCommitment,
_Item.JrnlEntryItemObsoleteReason,
_Item.GLBusinessTransactionType,
_Item.LogicalSystem,
_Item.GLAccount,
_Item.ChartOfAccounts,
_Item.CostCenter,
_Item.ProfitCenter,
_Item.FunctionalArea,
_Item.BusinessArea,
_Item.Segment,
_Item.PartnerCostCenter,
_Item.PartnerProfitCenter,
_Item.PartnerFunctionalArea,
_Item.PartnerBusinessArea,
_Item.PartnerCompany,
_Item.PartnerSegment,
///
// Amounts
///
_Item.BalanceTransactionCurrency,
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
_Item.AmountInBalanceTransacCrcy,
_Item.TransactionCurrency,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
_Item.AmountInTransactionCurrency,
_Item.CompanyCodeCurrency,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
_Item.AmountInCompanyCodeCurrency,
_Item.GlobalCurrency,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
_Item.AmountInGlobalCurrency,
_Item.FunctionalCurrency,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
_Item.AmountInFunctionalCurrency,
_Item.FreeDefinedCurrency1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
_Item.AmountInFreeDefinedCurrency1,
_Item.FreeDefinedCurrency2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
_Item.AmountInFreeDefinedCurrency2,
_Item.FreeDefinedCurrency3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
_Item.AmountInFreeDefinedCurrency3,
_Item.FreeDefinedCurrency4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
_Item.AmountInFreeDefinedCurrency4,
_Item.FreeDefinedCurrency5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
_Item.AmountInFreeDefinedCurrency5,
_Item.FreeDefinedCurrency6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
_Item.AmountInFreeDefinedCurrency6,
_Item.FreeDefinedCurrency7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
_Item.AmountInFreeDefinedCurrency7,
_Item.FreeDefinedCurrency8,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
_Item.AmountInFreeDefinedCurrency8,
_Item.ControllingObjectCurrency,
@Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }
_Item.AmountInObjectCurrency,
_Item.GrantCurrency,
@Semantics: { amount : {currencyCode: 'GrantCurrency'} }
_Item.AmountInGrantCurrency,
///
// Credit Amounts
///
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInBalanceTransacCrcy
else abap.curr'0.00'
end as fis_cr_tsl) as CreditAmountInBalanceTransCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInTransactionCurrency
else abap.curr'0.00'
end as fis_cr_wsl) as CreditAmountInTransCrcy,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInCompanyCodeCurrency
else abap.curr'0.00'
end as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInGlobalCurrency
else abap.curr'0.00'
end as fis_cr_ksl) as CreditAmountInGlobalCrcy,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFunctionalCurrency
else abap.curr'0.00'
end as fis_cr_amt_funccrcy) as CreditAmountInFunctionalCrcy,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency1
else abap.curr'0.00'
end as fis_cr_osl) as CreditAmountInFreeDfndCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency2
else abap.curr'0.00'
end as fis_cr_vsl) as CreditAmountInFreeDfndCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency3
else abap.curr'0.00'
end as fis_cr_bsl) as CreditAmountInFreeDfndCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency4
else abap.curr'0.00'
end as fis_cr_csl) as CreditAmountInFreeDfndCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency5
else abap.curr'0.00'
end as fis_cr_dsl) as CreditAmountInFreeDfndCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency6
else abap.curr'0.00'
end as fis_cr_esl) as CreditAmountInFreeDfndCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency7
else abap.curr'0.00'
end as fis_cr_fsl) as CreditAmountInFreeDfndCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency8
else abap.curr'0.00'
end as fis_cr_gsl) as CreditAmountInFreeDfndCrcy8,
///
// Debit Amounts
///
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInBalanceTransacCrcy
else abap.curr'0.00'
end as fis_dr_tsl) as DebitAmountInBalanceTransCrcy,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInTransactionCurrency
else abap.curr'0.00'
end as fis_dr_wsl) as DebitAmountInTransCrcy,
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInCompanyCodeCurrency
else abap.curr'0.00'
end as fis_dr_hsl) as DebitAmountInCoCodeCrcy,
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInGlobalCurrency
else abap.curr'0.00'
end as fis_dr_ksl) as DebitAmountInGlobalCrcy,
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFunctionalCurrency
else abap.curr'0.00'
end as fis_dr_amt_funccrcy) as DebitAmountInFunctionalCrcy,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency1
else abap.curr'0.00'
end as fis_dr_osl) as DebitAmountInFreeDfndCrcy1,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency2
else abap.curr'0.00'
end as fis_dr_vsl) as DebitAmountInFreeDfndCrcy2,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency3
else abap.curr'0.00'
end as fis_dr_bsl) as DebitAmountInFreeDfndCrcy3,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency4
else abap.curr'0.00'
end as fis_dr_csl) as DebitAmountInFreeDfndCrcy4,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency5
else abap.curr'0.00'
end as fis_dr_dsl) as DebitAmountInFreeDfndCrcy5,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency6
else abap.curr'0.00'
end as fis_dr_esl) as DebitAmountInFreeDfndCrcy6,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency7
else abap.curr'0.00'
end as fis_dr_fsl) as DebitAmountInFreeDfndCrcy7,
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency8
else abap.curr'0.00'
end as fis_dr_gsl) as DebitAmountInFreeDfndCrcy8,
_Item.BaseUnit,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
_Item.Quantity,
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
_Item.FixedQuantity,
_Item.CostSourceUnit,
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
_Item.ValuationQuantity,
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }
_Item.ValuationFixedQuantity,
_Item.AdditionalQuantity1Unit,
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} }
_Item.AdditionalQuantity1,
_Item.AdditionalQuantity2Unit,
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} }
_Item.AdditionalQuantity2,
_Item.AdditionalQuantity3Unit,
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity3Unit'} }
_Item.AdditionalQuantity3,
_Item.DebitCreditCode,
_Item.ExchangeRateDate,
_Item.FiscalPeriod,
_Item.FiscalYearVariant,
_Item.FiscalYearPeriod,
_Item.PostingDate,
_Item.DocumentDate,
_Item.AccountingDocumentType,
_Item.AccountingDocumentItem,
_Item.AssignmentReference,
_Item.AccountingDocumentCategory,
_Item.PostingKey,
_Item.TransactionTypeDetermination,
_Item.SubLedgerAcctLineItemType,
_Item.AccountingDocCreatedByUser,
_Item.CreationDate,
_Item.CreationDateTime,
_Item.EliminationProfitCenter,
_Item.OriginObjectType,
_Item.GLAccountType,
_Item.AlternativeGLAccount,
_Item.CountryChartOfAccounts,
_Item.ConsolidationUnit,
_Item.InvoiceReference,
_Item.InvoiceReferenceFiscalYear,
_Item.FollowOnDocumentType,
_Item.InvoiceItemReference,
_Item.PartnerConsolidationUnit,
_Item.Company,
_Item.ConsolidationChartOfAccounts,
_Item.CnsldtnFinancialStatementItem,
_Item.CnsldtnSubitemCategory,
_Item.CnsldtnSubitem,
_Item.ReferencePurchaseOrderCategory,
_Item.PurchasingDocument,
_Item.PurchasingDocumentItem,
_Item.AccountAssignmentNumber,
_Item.DocumentItemText,
_Item.SalesDocument,
_Item.SalesDocumentItem,
_Item.Product,
_Item.ProductGroup,
_Item.Plant,
_Item.Supplier,
_Item.Customer,
_Item.ServicesRenderedDate,
_Item.PerformancePeriodStartDate,
_Item.PerformancePeriodEndDate,
_Item.FinancialAccountType,
_Item.SpecialGLCode,
_Item.TaxCode,
_Item.TaxCountry,
_Item.HouseBank,
_Item.HouseBankAccount,
@Semantics.booleanIndicator: true
_Item.IsOpenItemManaged,
_Item.ClearingDate,
_Item.ClearingJournalEntryFiscalYear,
_Item.ClearingJournalEntry,
cast( ( case _Item.ClearingDate when '00000000' then ' '
else 'X'
end ) as farp_xaugp preserving type ) as IsCleared,
_Item.ValueDate,
_Item.AssetDepreciationArea,
_Item.MasterFixedAsset,
_Item.FixedAsset,
_Item.AssetValueDate,
_Item.AssetTransactionType,
_Item.AssetAcctTransClassfctn,
_Item.DepreciationFiscalPeriod,
_Item.GroupMasterFixedAsset,
_Item.GroupFixedAsset,
_Item.PartnerMasterFixedAsset,
_Item.PartnerFixedAsset,
_Item.AssetClass,
_Item.CostEstimate,
_Item.InventorySpecialStockValnType,
_Item.InventorySpecialStockType,
_Item.InventorySpclStkSalesDocument,
_Item.InventorySpclStkSalesDocItm,
_Item.InvtrySpclStockWBSElmntIntID,
_Item.InventorySpecialStockSupplier,
_Item.InventoryValuationType,
_Item.ValuationArea,
cast( _Item._InvtrySpclStkWBSElmntBscData.WBSElementExternalID as fis_invspstock_wbsext_no_conv ) as InvtrySpclStockWBSElmntExtID,
_Item.ProductPriceControl,
_Item.SenderGLAccount,
_Item.SenderAccountAssignment,
_Item.SenderAccountAssignmentType,
_Item.ControllingObject,
_Item.CostOriginGroup,
_Item.OriginSenderObject,
cast(_Item.ControllingDebitCreditCode as fis_co_belkz_conv) as ControllingDebitCreditCode,
_Item.ControllingObjectDebitType,
_Item.QuantityIsIncomplete,
_Item.OffsettingAccount,
_Item.OffsettingAccountType,
_Item.OffsettingChartOfAccounts,
_Item.LineItemIsCompleted,
_Item.PersonnelNumber,
_Item.BillableControl,
_Item.ControllingObjectClass,
_Item.PartnerCompanyCode,
_Item.PartnerControllingObjectClass,
_Item.OriginCostCtrActivityType,
_Item.OriginCostCenter,
_Item.OriginProfitCenter,
_Item.OriginProduct,
_Item.VarianceOriginGLAccount,
_Item.AccountAssignment,
_Item.AccountAssignmentType,
_Item.CostCtrActivityType,
_Item.OrderID,
_Item.OrderCategory,
_Item.WBSElementInternalID,
cast( _Item._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) as WBSElementExternalID,
_Item.PartnerWBSElementInternalID,
cast( _Item._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) as PartnerWBSElementExternalID,
_Item.WorkPackage,
_Item.ProjectInternalID,
_Item.PartnerProjectInternalID,
cast( _Item._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) as PartnerProjectExternalID,
cast( _Item._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) as ProjectExternalID,
_Item.OperatingConcern,
_Item.ProjectNetwork,
cast(_Item.RelatedNetworkActivity as fis_npvrg_conv) as RelatedNetworkActivity,
_Item.BusinessProcess,
_Item.CostObject,
_Item.CostAnalysisResource,
_Item.CustomerServiceNotification,
_Item.ServiceDocumentType,
_Item.ServiceDocument,
_Item.ServiceDocumentItem,
_Item.PartnerServiceDocumentType,
_Item.PartnerServiceDocument,
_Item.PartnerServiceDocumentItem,
_Item.ServiceContractType,
_Item.ServiceContract,
_Item.ServiceContractItem,
_Item.BusinessSolutionOrder,
_Item.BusinessSolutionOrderItem,
_Item.ProviderContract,
_Item.ProviderContractItem,
_Item.TimeSheetOvertimeCategory,
_Item.PartnerAccountAssignment,
_Item.PartnerAccountAssignmentType,
_Item.PartnerCostCtrActivityType,
cast(_Item.PartnerOrder as fis_par_aufnr preserving type ) as PartnerOrder,
_Item.PartnerOrderCategory,
_Item.PartnerSalesDocument,
_Item.PartnerSalesDocumentItem,
_Item.PartnerProjectNetwork,
cast(_Item.PartnerProjectNetworkActivity as fis_par_vornr_auf_conv) as PartnerProjectNetworkActivity,
_Item.PartnerBusinessProcess,
_Item.PartnerCostObject,
_Item.WorkItem,
_Item.BillingDocumentType,
_Item.SalesOrganization,
_Item.DistributionChannel,
_Item.OrganizationDivision,
_Item.SoldProduct,
_Item.SoldProductGroup,
_Item.CustomerGroup,
_Item.CustomerSupplierCountry,
_Item.CustomerSupplierIndustry,
_Item.SalesDistrict,
_Item.BillToParty,
_Item.ShipToParty,
_Item.CustomerSupplierCorporateGroup,
_Item.CashLedgerCompanyCode,
_Item.CashLedgerAccount,
_Item.FinancialManagementArea,
_Item.FundsCenter,
_Item.FundedProgram,
_Item.Fund,
_Item.GrantID,
_Item.BudgetPeriod,
_Item.PartnerFund,
_Item.PartnerGrant,
_Item.PartnerBudgetPeriod,
_Item.PubSecBudgetAccount,
_Item.PubSecBudgetAccountCoCode,
_Item.PubSecBudgetCnsmpnDate,
_Item.PubSecBudgetCnsmpnFsclYear,
_Item.PubSecBudgetCnsmpnFsclPeriod,
_Item.PubSecBudgetIsRelevant,
_Item.PubSecBudgetCnsmpnType,
_Item.PubSecBudgetCnsmpnAmtType,
_Item.SponsoredProgram,
_Item.SponsoredClass,
_Item.GteeMBudgetValidityNumber,
_Item.CommitmentItem,
_Item.JointVenture,
_Item.JointVentureEquityGroup,
_Item.JointVentureCostRecoveryCode,
_Item.JointVenturePartner,
_Item.JointVentureBillingType,
_Item.JointVentureEquityType,
_Item.JointVentureProductionDate,
_Item.JointVentureBillingDate,
_Item.JointVentureOperationalDate,
_Item.CutbackRun,
_Item.JointVentureAccountingActivity,
_Item.SettlementReferenceDate,
_Item.PartnerVenture,
_Item.PartnerEquityGroup,
_Item.SenderCostRecoveryCode,
_Item.CutbackAccount,
_Item.CutbackCostObject,
_Item.REBusinessEntity,
_Item.RealEstateBuilding,
_Item.RealEstateProperty,
_Item.RERentalObject,
_Item.RealEstateContract,
_Item.REServiceChargeKey,
_Item.RESettlementUnitID,
_Item.AccrualObjectType,
_Item.AccrualObjectLogicalSystem,
_Item.AccrualObject,
_Item.AccrualSubobject,
_Item.AccrualItemType,
_Item.AccrualReferenceObject,
_Item.AccrualValueDate,
_Item.FinancialValuationObjectType,
_Item.FinancialValuationObject,
_Item.FinancialValuationSubobject,
_Item.NetDueDate,
_Item.CreditRiskClass,
case when ( _Item.AmountInTransactionCurrency > 0 )
and _Item.DebitCreditCode = 'H' then cast( 'X' as fis_xnegp preserving type )
when ( _Item.AmountInTransactionCurrency < 0 )
and _Item.DebitCreditCode = 'S' then cast( 'X' as fis_xnegp preserving type )
else cast( ' ' as fis_xnegp preserving type ) end as IsNegativePosting,
cast( ( case when ( _Item.AccountAssignmentType != 'OR' and _Item.AccountAssignmentType != 'OP' and _Item.AccountAssignmentType != 'OV' ) and _Item.OrderID != ''
then 'X'
else ' '
end ) as fins_xaufnr_stat preserving type ) as IsStatisticalOrder,
cast( ( case when ( _Item.AccountAssignmentType != 'KL' and _Item.AccountAssignmentType != 'KS' ) and _Item.CostCenter != ''
then 'X'
else ' '
end ) as fins_xkostl_stat preserving type ) as IsStatisticalCostCenter,
cast( ( case when _Item.AccountAssignmentType != 'VB' and _Item.SalesDocument != ''
then 'X'
else ' '
end ) as fis_xkdpos_stat preserving type ) as IsStatisticalSalesDocument,
cast( ( case when ( _Item.AccountAssignmentType != 'PR' ) and ( _Item.WBSElementInternalID != '00000000' )
then 'X'
else ' '
end ) as fins_xps_posid_stat preserving type ) as WBSIsStatisticalWBSElement,
cast(_Item.OrderOperation as vdm_vornr) as OrderOperation,
_Item.JrnlEntryItemMigrationSource,
cast(_Item.FinancialServicesProductGroup as ffs_product_group preserving type) as FinancialServicesProductGroup,
cast(_Item.FinancialServicesBranch as ffs_branch_id preserving type) as FinancialServicesBranch,
cast(_Item.FinancialDataSource as ffs_datasource_id preserving type) as FinancialDataSource,
cast(
case _Item.AccountAssignmentType
when 'EO' then _Item.AccountAssignment
else ''
end as rkeobjnr_char) as ProfitabilitySegment,
cast('STANDARD' as abap.char( 10 )) as Source,
//FOR DCL
_Item._GLAccountInCompanyCode,
_Item._Supplier,
_Item._Order,
_Item._Customer,
_Item._AccountingDocumentType,
_Item._ServiceDocument,
_Item._SalesDocument
}
union all select from I_GLAccountLineItemRawData as _Item
inner join I_TechnicalLedger as _TechnicalLedger on _Item.SourceLedger = _TechnicalLedger.TechnicalLedger
{
key _Item.SourceLedger as TechnicalLedger,
key _TechnicalLedger.Ledger as SourceLedger,
key _Item.CompanyCode,
key _Item.FiscalYear,
key _Item.AccountingDocument,
key _Item.LedgerGLLineItem,
_Item.LedgerFiscalYear,
_Item.GLRecordType,
_Item.JrnlEntrAltvFYConsecutiveID,
_Item.ControllingArea,
_Item.BusinessTransactionCategory,
_Item.BusinessTransactionType,
_Item.ReferenceDocumentType,
_Item.ReferenceDocumentContext,
_Item.ReferenceDocument,
_Item.ReferenceDocumentItem,
_Item.ReferenceDocumentItemGroup,
_Item.FinancialTransactionType,
_Item.IsReversal,
_Item.IsReversed,
_Item.ReversalReferenceDocumentCntxt,
_Item.ReversalReferenceDocument,
_Item.IsSettlement,
_Item.IsSettled,
_Item.PredecessorReferenceDocCntxt,
_Item.PredecessorReferenceDocItem,
_Item.PredecessorReferenceDocType,
_Item.PredecessorReferenceDocument,
_Item.SourceReferenceDocument,
_Item.SourceReferenceDocumentType,
_Item.SourceReferenceDocumentItem,
_Item.SourceReferenceDocumentCntxt,
_Item.SourceLogicalSystem,
_Item.SourceReferenceDocSubitem,
_Item.IsCommitment,
_Item.JrnlEntryItemObsoleteReason,
_Item.GLBusinessTransactionType,
_Item.LogicalSystem,
_Item.GLAccount,
_Item.ChartOfAccounts,
_Item.CostCenter,
_Item.ProfitCenter,
_Item.FunctionalArea,
_Item.BusinessArea,
_Item.Segment,
_Item.PartnerCostCenter,
_Item.PartnerProfitCenter,
_Item.PartnerFunctionalArea,
_Item.PartnerBusinessArea,
_Item.PartnerCompany,
_Item.PartnerSegment,
///
// Amounts
///
_Item.BalanceTransactionCurrency,
_Item.AmountInBalanceTransacCrcy,
_Item.TransactionCurrency,
_Item.AmountInTransactionCurrency,
_Item.CompanyCodeCurrency,
_Item.AmountInCompanyCodeCurrency,
_Item.GlobalCurrency,
_Item.AmountInGlobalCurrency,
_Item.FunctionalCurrency,
_Item.AmountInFunctionalCurrency,
_Item.FreeDefinedCurrency1,
_Item.AmountInFreeDefinedCurrency1,
_Item.FreeDefinedCurrency2,
_Item.AmountInFreeDefinedCurrency2,
_Item.FreeDefinedCurrency3,
_Item.AmountInFreeDefinedCurrency3,
_Item.FreeDefinedCurrency4,
_Item.AmountInFreeDefinedCurrency4,
_Item.FreeDefinedCurrency5,
_Item.AmountInFreeDefinedCurrency5,
_Item.FreeDefinedCurrency6,
_Item.AmountInFreeDefinedCurrency6,
_Item.FreeDefinedCurrency7,
_Item.AmountInFreeDefinedCurrency7,
_Item.FreeDefinedCurrency8,
_Item.AmountInFreeDefinedCurrency8,
_Item.ControllingObjectCurrency,
_Item.AmountInObjectCurrency,
_Item.GrantCurrency,
_Item.AmountInGrantCurrency,
///
// Credit Amounts
///
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInBalanceTransacCrcy
else abap.curr'0.00'
end as fis_cr_tsl) as CreditAmountInBalanceTransCrcy,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInTransactionCurrency
else abap.curr'0.00'
end as fis_cr_wsl) as CreditAmountInTransCrcy,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInCompanyCodeCurrency
else abap.curr'0.00'
end as fis_cr_hsl) as CreditAmountInCoCodeCrcy,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInGlobalCurrency
else abap.curr'0.00'
end as fis_cr_ksl) as CreditAmountInGlobalCrcy,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFunctionalCurrency
else abap.curr'0.00'
end as fis_cr_amt_funccrcy) as CreditAmountInFunctionalCrcy,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency1
else abap.curr'0.00'
end as fis_cr_osl) as CreditAmountInFreeDfndCrcy1,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency2
else abap.curr'0.00'
end as fis_cr_vsl) as CreditAmountInFreeDfndCrcy2,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency3
else abap.curr'0.00'
end as fis_cr_bsl) as CreditAmountInFreeDfndCrcy3,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency4
else abap.curr'0.00'
end as fis_cr_csl) as CreditAmountInFreeDfndCrcy4,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency5
else abap.curr'0.00'
end as fis_cr_dsl) as CreditAmountInFreeDfndCrcy5,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency6
else abap.curr'0.00'
end as fis_cr_esl) as CreditAmountInFreeDfndCrcy6,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency7
else abap.curr'0.00'
end as fis_cr_fsl) as CreditAmountInFreeDfndCrcy7,
cast(case
when _Item.DebitCreditCode = 'H' then -_Item.AmountInFreeDefinedCurrency8
else abap.curr'0.00'
end as fis_cr_gsl) as CreditAmountInFreeDfndCrcy8,
///
// Debit Amounts
///
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInBalanceTransacCrcy
else abap.curr'0.00'
end as fis_dr_tsl) as DebitAmountInBalanceTransCrcy,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInTransactionCurrency
else abap.curr'0.00'
end as fis_dr_wsl) as DebitAmountInTransCrcy,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInCompanyCodeCurrency
else abap.curr'0.00'
end as fis_dr_hsl) as DebitAmountInCoCodeCrcy,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInGlobalCurrency
else abap.curr'0.00'
end as fis_dr_ksl) as DebitAmountInGlobalCrcy,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFunctionalCurrency
else abap.curr'0.00'
end as fis_dr_amt_funccrcy) as DebitAmountInFunctionalCrcy,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency1
else abap.curr'0.00'
end as fis_dr_osl) as DebitAmountInFreeDfndCrcy1,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency2
else abap.curr'0.00'
end as fis_dr_vsl) as DebitAmountInFreeDfndCrcy2,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency3
else abap.curr'0.00'
end as fis_dr_bsl) as DebitAmountInFreeDfndCrcy3,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency4
else abap.curr'0.00'
end as fis_dr_csl) as DebitAmountInFreeDfndCrcy4,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency5
else abap.curr'0.00'
end as fis_dr_dsl) as DebitAmountInFreeDfndCrcy5,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency6
else abap.curr'0.00'
end as fis_dr_esl) as DebitAmountInFreeDfndCrcy6,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency7
else abap.curr'0.00'
end as fis_dr_fsl) as DebitAmountInFreeDfndCrcy7,
cast(case
when _Item.DebitCreditCode = 'S' then _Item.AmountInFreeDefinedCurrency8
else abap.curr'0.00'
end as fis_dr_gsl) as DebitAmountInFreeDfndCrcy8,
_Item.BaseUnit,
_Item.Quantity,
_Item.FixedQuantity,
_Item.CostSourceUnit,
_Item.ValuationQuantity,
_Item.ValuationFixedQuantity,
_Item.AdditionalQuantity1Unit,
_Item.AdditionalQuantity1,
_Item.AdditionalQuantity2Unit,
_Item.AdditionalQuantity2,
_Item.AdditionalQuantity3Unit,
_Item.AdditionalQuantity3,
_Item.DebitCreditCode,
_Item.ExchangeRateDate,
_Item.FiscalPeriod,
_Item.FiscalYearVariant,
_Item.FiscalYearPeriod,
_Item.PostingDate,
_Item.DocumentDate,
_Item.AccountingDocumentType,
_Item.AccountingDocumentItem,
_Item.AssignmentReference,
_Item.AccountingDocumentCategory,
_Item.PostingKey,
_Item.TransactionTypeDetermination,
_Item.SubLedgerAcctLineItemType,
_Item.AccountingDocCreatedByUser,
_Item.CreationDate,
_Item.CreationDateTime,
_Item.EliminationProfitCenter,
_Item.OriginObjectType,
_Item.GLAccountType,
_Item.AlternativeGLAccount,
_Item.CountryChartOfAccounts,
_Item.ConsolidationUnit,
_Item.InvoiceReference,
_Item.InvoiceReferenceFiscalYear,
_Item.FollowOnDocumentType,
_Item.InvoiceItemReference,
_Item.PartnerConsolidationUnit,
_Item.Company,
_Item.ConsolidationChartOfAccounts,
_Item.CnsldtnFinancialStatementItem,
_Item.CnsldtnSubitemCategory,
_Item.CnsldtnSubitem,
_Item.ReferencePurchaseOrderCategory,
_Item.PurchasingDocument,
_Item.PurchasingDocumentItem,
_Item.AccountAssignmentNumber,
_Item.DocumentItemText,
_Item.SalesDocument,
_Item.SalesDocumentItem,
_Item.Product,
_Item.ProductGroup,
_Item.Plant,
_Item.Supplier,
_Item.Customer,
_Item.ServicesRenderedDate,
_Item.PerformancePeriodStartDate,
_Item.PerformancePeriodEndDate,
_Item.FinancialAccountType,
_Item.SpecialGLCode,
_Item.TaxCode,
_Item.TaxCountry,
_Item.HouseBank,
_Item.HouseBankAccount,
_Item.IsOpenItemManaged,
_Item.ClearingDate,
_Item.ClearingJournalEntryFiscalYear,
_Item.ClearingJournalEntry,
cast( ( case _Item.ClearingDate when '00000000' then ' '
else 'X'
end ) as farp_xaugp preserving type ) as IsCleared,
_Item.ValueDate,
_Item.AssetDepreciationArea,
_Item.MasterFixedAsset,
_Item.FixedAsset,
_Item.AssetValueDate,
_Item.AssetTransactionType,
_Item.AssetAcctTransClassfctn,
_Item.DepreciationFiscalPeriod,
_Item.GroupMasterFixedAsset,
_Item.GroupFixedAsset,
_Item.PartnerMasterFixedAsset,
_Item.PartnerFixedAsset,
_Item.AssetClass,
_Item.CostEstimate,
_Item.InventorySpecialStockValnType,
_Item.InventorySpecialStockType,
_Item.InventorySpclStkSalesDocument,
_Item.InventorySpclStkSalesDocItm,
_Item.InvtrySpclStockWBSElmntIntID,
_Item.InventorySpecialStockSupplier,
_Item.InventoryValuationType,
_Item.ValuationArea,
cast( _Item._InvtrySpclStkWBSElmntBscData.WBSElementExternalID as fis_invspstock_wbsext_no_conv ) as InvtrySpclStockWBSElmntExtID,
_Item.ProductPriceControl,
_Item.SenderGLAccount,
_Item.SenderAccountAssignment,
_Item.SenderAccountAssignmentType,
_Item.ControllingObject,
_Item.CostOriginGroup,
_Item.OriginSenderObject,
cast(_Item.ControllingDebitCreditCode as fis_co_belkz_conv) as ControllingDebitCreditCode,
_Item.ControllingObjectDebitType,
_Item.QuantityIsIncomplete,
_Item.OffsettingAccount,
_Item.OffsettingAccountType,
_Item.OffsettingChartOfAccounts,
_Item.LineItemIsCompleted,
_Item.PersonnelNumber,
_Item.BillableControl,
_Item.ControllingObjectClass,
_Item.PartnerCompanyCode,
_Item.PartnerControllingObjectClass,
_Item.OriginCostCtrActivityType,
_Item.OriginCostCenter,
_Item.OriginProfitCenter,
_Item.OriginProduct,
_Item.VarianceOriginGLAccount,
_Item.AccountAssignment,
_Item.AccountAssignmentType,
_Item.CostCtrActivityType,
_Item.OrderID,
_Item.OrderCategory,
_Item.WBSElementInternalID,
cast( _Item._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) as WBSElementExternalID,
_Item.PartnerWBSElementInternalID,
cast( _Item._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) as PartnerWBSElementExternalID,
_Item.WorkPackage,
_Item.ProjectInternalID,
_Item.PartnerProjectInternalID,
cast( _Item._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) as PartnerProjectExternalID,
cast( _Item._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) as ProjectExternalID,
_Item.OperatingConcern,
_Item.ProjectNetwork,
cast(_Item.RelatedNetworkActivity as fis_npvrg_conv) as RelatedNetworkActivity,
_Item.BusinessProcess,
_Item.CostObject,
_Item.CostAnalysisResource,
_Item.CustomerServiceNotification,
_Item.ServiceDocumentType,
_Item.ServiceDocument,
_Item.ServiceDocumentItem,
_Item.PartnerServiceDocumentType,
_Item.PartnerServiceDocument,
_Item.PartnerServiceDocumentItem,
_Item.ServiceContractType,
_Item.ServiceContract,
_Item.ServiceContractItem,
_Item.BusinessSolutionOrder,
_Item.BusinessSolutionOrderItem,
_Item.ProviderContract,
_Item.ProviderContractItem,
_Item.TimeSheetOvertimeCategory,
_Item.PartnerAccountAssignment,
_Item.PartnerAccountAssignmentType,
_Item.PartnerCostCtrActivityType,
cast(_Item.PartnerOrder as fis_par_aufnr preserving type ) as PartnerOrder,
_Item.PartnerOrderCategory,
_Item.PartnerSalesDocument,
_Item.PartnerSalesDocumentItem,
_Item.PartnerProjectNetwork,
cast(_Item.PartnerProjectNetworkActivity as fis_par_vornr_auf_conv) as PartnerProjectNetworkActivity,
_Item.PartnerBusinessProcess,
_Item.PartnerCostObject,
_Item.WorkItem,
_Item.BillingDocumentType,
_Item.SalesOrganization,
_Item.DistributionChannel,
_Item.OrganizationDivision,
_Item.SoldProduct,
_Item.SoldProductGroup,
_Item.CustomerGroup,
_Item.CustomerSupplierCountry,
_Item.CustomerSupplierIndustry,
_Item.SalesDistrict,
_Item.BillToParty,
_Item.ShipToParty,
_Item.CustomerSupplierCorporateGroup,
_Item.CashLedgerCompanyCode,
_Item.CashLedgerAccount,
_Item.FinancialManagementArea,
_Item.FundsCenter,
_Item.FundedProgram,
_Item.Fund,
_Item.GrantID,
_Item.BudgetPeriod,
_Item.PartnerFund,
_Item.PartnerGrant,
_Item.PartnerBudgetPeriod,
_Item.PubSecBudgetAccount,
_Item.PubSecBudgetAccountCoCode,
_Item.PubSecBudgetCnsmpnDate,
_Item.PubSecBudgetCnsmpnFsclYear,
_Item.PubSecBudgetCnsmpnFsclPeriod,
_Item.PubSecBudgetIsRelevant,
_Item.PubSecBudgetCnsmpnType,
_Item.PubSecBudgetCnsmpnAmtType,
_Item.SponsoredProgram,
_Item.SponsoredClass,
_Item.GteeMBudgetValidityNumber,
_Item.CommitmentItem,
_Item.JointVenture,
_Item.JointVentureEquityGroup,
_Item.JointVentureCostRecoveryCode,
_Item.JointVenturePartner,
_Item.JointVentureBillingType,
_Item.JointVentureEquityType,
_Item.JointVentureProductionDate,
_Item.JointVentureBillingDate,
_Item.JointVentureOperationalDate,
_Item.CutbackRun,
_Item.JointVentureAccountingActivity,
_Item.SettlementReferenceDate,
_Item.PartnerVenture,
_Item.PartnerEquityGroup,
_Item.SenderCostRecoveryCode,
_Item.CutbackAccount,
_Item.CutbackCostObject,
_Item.REBusinessEntity,
_Item.RealEstateBuilding,
_Item.RealEstateProperty,
_Item.RERentalObject,
_Item.RealEstateContract,
_Item.REServiceChargeKey,
_Item.RESettlementUnitID,
_Item.AccrualObjectType,
_Item.AccrualObjectLogicalSystem,
_Item.AccrualObject,
_Item.AccrualSubobject,
_Item.AccrualItemType,
_Item.AccrualReferenceObject,
_Item.AccrualValueDate,
_Item.FinancialValuationObjectType,
_Item.FinancialValuationObject,
_Item.FinancialValuationSubobject,
_Item.NetDueDate,
_Item.CreditRiskClass,
case when ( _Item.AmountInTransactionCurrency > 0 )
and _Item.DebitCreditCode = 'H' then cast( 'X' as fis_xnegp preserving type )
when ( _Item.AmountInTransactionCurrency < 0 )
and _Item.DebitCreditCode = 'S' then cast( 'X' as fis_xnegp preserving type )
else cast( ' ' as fis_xnegp preserving type ) end as IsNegativePosting,
cast( ( case when ( _Item.AccountAssignmentType != 'OR' and _Item.AccountAssignmentType != 'OP' and _Item.AccountAssignmentType != 'OV' ) and _Item.OrderID != ''
then 'X'
else ' '
end ) as fins_xaufnr_stat preserving type ) as IsStatisticalOrder,
cast( ( case when ( _Item.AccountAssignmentType != 'KL' and _Item.AccountAssignmentType != 'KS' ) and _Item.CostCenter != ''
then 'X'
else ' '
end ) as fins_xkostl_stat preserving type ) as IsStatisticalCostCenter,
cast( ( case when _Item.AccountAssignmentType != 'VB' and _Item.SalesDocument != ''
then 'X'
else ' '
end ) as fis_xkdpos_stat preserving type ) as IsStatisticalSalesDocument,
cast( ( case when ( _Item.AccountAssignmentType != 'PR' ) and ( _Item.WBSElementInternalID != '00000000' )
then 'X'
else ' '
end ) as fins_xps_posid_stat preserving type ) as WBSIsStatisticalWBSElement,
cast(_Item.OrderOperation as vdm_vornr) as OrderOperation,
_Item.JrnlEntryItemMigrationSource,
cast(_Item.FinancialServicesProductGroup as ffs_product_group preserving type) as FinancialServicesProductGroup,
cast(_Item.FinancialServicesBranch as ffs_branch_id preserving type) as FinancialServicesBranch,
cast(_Item.FinancialDataSource as ffs_datasource_id preserving type) as FinancialDataSource,
cast(
case _Item.AccountAssignmentType
when 'EO' then _Item.AccountAssignment
else ''
end as rkeobjnr_char) as ProfitabilitySegment,
cast('TECHNICAL' as abap.char( 10 )) as Source,
//FOR DCL
_Item._GLAccountInCompanyCode,
_Item._Supplier,
_Item._Order,
_Item._Customer,
_Item._AccountingDocumentType,
_Item._ServiceDocument,
_Item._SalesDocument
}