@AbapCatalog.entityBuffer.definitionAllowed: false
@AccessControl: {authorizationCheck: #CHECK,
personalData.blocking: #REQUIRED }
@EndUserText.label: 'Journal Entry Item Browser'
@VDM.viewType: #COMPOSITE
@ObjectModel: { representativeKey: 'LedgerGLLineItem',
usageType.sizeCategory: #XXL,
usageType.dataClass: #TRANSACTIONAL,
usageType.serviceQuality: #D,
supportedCapabilities: [#ANALYTICAL_PROVIDER, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE],
modelingPattern: #ANALYTICAL_CUBE }
@Analytics: { dataCategory: #CUBE,
internalName: #LOCAL }
@Analytics.technicalName: 'IFIJELITBROWS'
@Environment.sql.passValueForClient: true
@Metadata: { ignorePropagatedAnnotations: true,
allowExtensions:true }
@AccessControl.auditFilter: #ENABLED
define view entity I_JournalEntryItemBrowser
with parameters P_ClearingStatusSelection : fis_clearingstatusselection
as select from I_JournalEntryItem as I_JournalEntryItem
association [0..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement_1 on $projection.PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement
association [0..1] to I_ProductGroup_2 as _ProductGroup_2 on $projection.ProductGroup = _ProductGroup_2.ProductGroup
association [0..1] to I_ProductGroup_2 as _SoldProductGroup_2 on $projection.SoldProductGroup = _SoldProductGroup_2.ProductGroup
//association [0..1] to I_Order as _PartnerOrder_2 on $projection.PartnerOrder_2 = _PartnerOrder_2.OrderID
//association [0..1] to I_Order as _PartnerOrderText_2 on $projection.PartnerOrder_2 = _PartnerOrderText_2.OrderID
association [0..1] to I_FinServicesProductGroup as _FinServicesProductGroup on $projection.FinancialServicesProductGroup = _FinServicesProductGroup.FinancialServicesProductGroup
association [0..*] to I_FinServicesProductGroupT as _FinServicesProductGroupText on $projection.FinancialServicesProductGroup = _FinServicesProductGroupText.FinancialServicesProductGroup
association [0..1] to I_FinancialServicesBranch as _FinancialServicesBranch on $projection.FinancialServicesBranch = _FinancialServicesBranch.FinancialServicesBranch
association [0..*] to I_FinancialServicesBranchT as _FinancialServicesBranchText on $projection.FinancialServicesBranch = _FinancialServicesBranchText.FinancialServicesBranch
association [0..1] to I_FinancialDataSource as _FinancialDataSource on $projection.FinancialDataSource = _FinancialDataSource.FinancialDataSource
association [0..*] to I_FinancialDataSourceT as _FinancialDataSourceText on $projection.FinancialDataSource = _FinancialDataSourceText.FinancialDataSource
association [0..1] to I_CustomerSupplierIndustry as _CustomerSupplierIndustry on $projection.CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry
association [0..1] to I_WBSElementByExternalID as _WBSElementExternalID on $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID
association [0..1] to I_WBSElementByExternalID as _PartnerWBSElementExternalID on $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID
association [0..1] to I_ProjectByExternalID as _ProjectExternalID on $projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID
association [0..1] to I_ProjectByExternalID as _PartnerProjectExternalID on $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID
association of exact one to exact one 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: '_SourceLedger'
key I_JournalEntryItem.SourceLedger,
@ObjectModel.foreignKey.association: '_CompanyCode'
key I_JournalEntryItem.CompanyCode,
@ObjectModel.foreignKey.association: '_FiscalYear'
key I_JournalEntryItem.FiscalYear,
@ObjectModel.foreignKey.association: '_JournalEntry'
key I_JournalEntryItem.AccountingDocument,
key I_JournalEntryItem.LedgerGLLineItem,
@ObjectModel.foreignKey.association: '_Ledger'
key I_JournalEntryItem.Ledger,
@ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant' //'_LedgerFiscalYear'
I_JournalEntryItem.LedgerFiscalYear,
I_JournalEntryItem.GLRecordType,
I_JournalEntryItem.JrnlEntrAltvFYConsecutiveID,
//LedgerName,
//CompanyCodeName,
// Object which are dependent objects --> first
@ObjectModel.foreignKey.association: '_ChartOfAccounts'
I_JournalEntryItem.ChartOfAccounts,
@ObjectModel.foreignKey.association: '_ControllingArea'
I_JournalEntryItem.ControllingArea,
//ControllingAreaName,
///////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_00 Unified Journal Entry: Transaction, Currencies, Units
///////////////////////////////////////////////////////////////////////////////
I_JournalEntryItem.FinancialTransactionType,
I_JournalEntryItem.BusinessTransactionCategory,
I_JournalEntryItem.BusinessTransactionType,
I_JournalEntryItem.ReferenceDocumentType,
I_JournalEntryItem.LogicalSystem,
I_JournalEntryItem.ReferenceDocumentContext,
I_JournalEntryItem.ReferenceDocument,
I_JournalEntryItem.ReferenceDocumentItem,
I_JournalEntryItem.ReferenceDocumentItemGroup,
//SUBTA,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsReversal,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsReversed,
//XTRUEREV,
//AWTYP_REV,
I_JournalEntryItem.ReversalReferenceDocumentCntxt,
I_JournalEntryItem.ReversalReferenceDocument,
//SUBTA_REV,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsSettlement,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsSettled,
I_JournalEntryItem.PredecessorReferenceDocType,
I_JournalEntryItem.PredecessorReferenceDocCntxt,
I_JournalEntryItem.PredecessorReferenceDocument,
I_JournalEntryItem.PredecessorReferenceDocItem,
I_JournalEntryItem.PrdcssrJournalEntryCompanyCode,
I_JournalEntryItem.PrdcssrJournalEntryFiscalYear,
I_JournalEntryItem.PredecessorJournalEntry,
I_JournalEntryItem.PredecessorJournalEntryItem,
//PREC_SUBTA,
I_JournalEntryItem.SourceReferenceDocumentType,
I_JournalEntryItem.SourceLogicalSystem,
I_JournalEntryItem.SourceReferenceDocumentCntxt,
I_JournalEntryItem.SourceReferenceDocument,
I_JournalEntryItem.SourceReferenceDocumentItem,
I_JournalEntryItem.SourceReferenceDocSubitem,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsCommitment,
I_JournalEntryItem.JrnlEntryItemObsoleteReason,
I_JournalEntryItem.OrganizationalChange,
@ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
I_JournalEntryItem.GLAccount,
//GLAccountName,
//GLAccountLongName,
////////////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_GL_ACCAS Unified Journal Entry: G/L additional account assignments
////////////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_CostCenter'
I_JournalEntryItem.CostCenter,
//CostCenterName,
@ObjectModel.foreignKey.association: '_ProfitCenter'
I_JournalEntryItem.ProfitCenter,
//ProfitCenterName,
@ObjectModel.foreignKey.association: '_FunctionalArea'
I_JournalEntryItem.FunctionalArea,
//FunctionalAreaName,
@ObjectModel.foreignKey.association: '_BusinessArea'
I_JournalEntryItem.BusinessArea,
//BusinessAreaName,
@ObjectModel.foreignKey.association: '_Segment'
I_JournalEntryItem.Segment,
//SegmentName,
I_JournalEntryItem.PartnerCostCenter,
I_JournalEntryItem.PartnerProfitCenter,
I_JournalEntryItem.PartnerFunctionalArea,
I_JournalEntryItem.PartnerBusinessArea,
I_JournalEntryItem.PartnerCompany,
I_JournalEntryItem.PartnerSegment,
/////////////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_VALUE_DATA Unified Journal Entry: Value Fields
/////////////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_BalanceTransactionCurrency'
I_JournalEntryItem.BalanceTransactionCurrency as BalanceTransactionCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} } I_JournalEntryItem.AmountInBalanceTransacCrcy,
@ObjectModel.foreignKey.association: '_TransactionCurrency'
I_JournalEntryItem.TransactionCurrency as TransactionCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} } I_JournalEntryItem.AmountInTransactionCurrency,
@ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
I_JournalEntryItem.CompanyCodeCurrency as CompanyCodeCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} } I_JournalEntryItem.AmountInCompanyCodeCurrency,
////////////////////////////////////
// NEW
@ObjectModel.foreignKey.association: '_GlobalCurrency'
I_JournalEntryItem.GlobalCurrency as GlobalCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.AmountInGlobalCurrency,
@ObjectModel.foreignKey.association: '_FunctionalCurrency'
I_JournalEntryItem.FunctionalCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
I_JournalEntryItem.AmountInFunctionalCurrency,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'
I_JournalEntryItem.FreeDefinedCurrency1 as FreeDefinedCurrency1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} } I_JournalEntryItem.AmountInFreeDefinedCurrency1,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'
I_JournalEntryItem.FreeDefinedCurrency2 as FreeDefinedCurrency2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} } I_JournalEntryItem.AmountInFreeDefinedCurrency2,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'
I_JournalEntryItem.FreeDefinedCurrency3 as FreeDefinedCurrency3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} } I_JournalEntryItem.AmountInFreeDefinedCurrency3,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'
I_JournalEntryItem.FreeDefinedCurrency4 as FreeDefinedCurrency4,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} } I_JournalEntryItem.AmountInFreeDefinedCurrency4,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'
I_JournalEntryItem.FreeDefinedCurrency5 as FreeDefinedCurrency5,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} } I_JournalEntryItem.AmountInFreeDefinedCurrency5,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'
I_JournalEntryItem.FreeDefinedCurrency6 as FreeDefinedCurrency6,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} } I_JournalEntryItem.AmountInFreeDefinedCurrency6,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'
I_JournalEntryItem.FreeDefinedCurrency7 as FreeDefinedCurrency7,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} } I_JournalEntryItem.AmountInFreeDefinedCurrency7,
@ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'
I_JournalEntryItem.FreeDefinedCurrency8 as FreeDefinedCurrency8,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} } I_JournalEntryItem.AmountInFreeDefinedCurrency8,
////////////////////////////////////
////////////////////////////////////
// NEW
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.FixedAmountInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.GrpValnFixedAmtInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.PrftCtrValnFxdAmtInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.TotalPriceVarcInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.GrpValnTotPrcVarcInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.PrftCtrValnTotPrcVarcInGlbCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.FixedPriceVarcInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.GrpValnFixedPrcVarcInGlobCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} } I_JournalEntryItem.PrftCtrValnFxdPrcVarcInGlbCrcy,
////////////////////////////////////
I_JournalEntryItem.ControllingObjectCurrency as ControllingObjectCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} } I_JournalEntryItem.AmountInObjectCurrency,
I_JournalEntryItem.GrantCurrency,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GrantCurrency'} }
I_JournalEntryItem.AmountInGrantCurrency,
@ObjectModel.foreignKey.association: '_BaseUnit'
I_JournalEntryItem.BaseUnit as BaseUnit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } I_JournalEntryItem.Quantity,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} } I_JournalEntryItem.FixedQuantity,
@ObjectModel.foreignKey.association: '_CostSourceUnit'
I_JournalEntryItem.CostSourceUnit as CostSourceUnit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} } I_JournalEntryItem.ValuationQuantity,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} } I_JournalEntryItem.ValuationFixedQuantity,
@ObjectModel.foreignKey.association: '_AdditionalQuantity1Unit'
I_JournalEntryItem.AdditionalQuantity1Unit as AdditionalQuantity1Unit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} } I_JournalEntryItem.AdditionalQuantity1,
@ObjectModel.foreignKey.association: '_AdditionalQuantity2Unit'
I_JournalEntryItem.AdditionalQuantity2Unit as AdditionalQuantity2Unit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} } I_JournalEntryItem.AdditionalQuantity2,
@ObjectModel.foreignKey.association: '_AdditionalQuantity3Unit'
I_JournalEntryItem.AdditionalQuantity3Unit as AdditionalQuantity3Unit,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity3Unit'} } I_JournalEntryItem.AdditionalQuantity3,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_IncmpltSummableValnQtyUnt'
I_JournalEntryItem.IncmpltSummableValnQtyUnt, // IncompleteSummableValuationQuantityUnit
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'IncmpltSummableValnQtyUnt'} }
I_JournalEntryItem.IncmpltSummableValnQty, // IncompleteSummableValuationQuantity
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'IncmpltSummableValnQtyUnt'} }
I_JournalEntryItem.IncmpltSummableValnFxdQty, // IncompleteSummableValuationFixQuantity
/////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FIX Unified Journal Entry: Mandatory fields for G/L
////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_DebitCreditCode'
I_JournalEntryItem.DebitCreditCode,
I_JournalEntryItem.FiscalPeriod,
@ObjectModel.foreignKey.association: '_FiscalYearVariant'
I_JournalEntryItem.FiscalYearVariant,
I_JournalEntryItem.FiscalYearPeriod,
I_JournalEntryItem.PostingDate,
I_JournalEntryItem.DocumentDate,
@ObjectModel.foreignKey.association: '_AccountingDocumentType'
I_JournalEntryItem.AccountingDocumentType,
I_JournalEntryItem.AccountingDocumentItem,
I_JournalEntryItem.AssignmentReference,
I_JournalEntryItem.AccountingDocumentCategory,
I_JournalEntryItem.PostingKey,
I_JournalEntryItem.TransactionTypeDetermination,
@ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'
I_JournalEntryItem.SubLedgerAcctLineItemType,
I_JournalEntryItem.AccountingDocCreatedByUser,
I_JournalEntryItem.LastChangeDateTime,
I_JournalEntryItem.CreationDateTime,
I_JournalEntryItem.CreationDate,
I_JournalEntryItem.EliminationProfitCenter,
I_JournalEntryItem.OriginObjectType,
I_JournalEntryItem.GLAccountType,
I_JournalEntryItem.AlternativeGLAccount,
I_JournalEntryItem.CountryChartOfAccounts,
/////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FINCS Universal Journal Entry: Fields for Group Reporting
////////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_ConsolidationUnit'
I_JournalEntryItem.ConsolidationUnit,
@ObjectModel.foreignKey.association: '_PartnerConsolidationUnit'
I_JournalEntryItem.PartnerConsolidationUnit,
@ObjectModel.foreignKey.association: '_Company'
I_JournalEntryItem.Company,
@ObjectModel.foreignKey.association: '_ConsolidationChartOfAccounts'
I_JournalEntryItem.ConsolidationChartOfAccounts,
@ObjectModel.foreignKey.association: '_CnsldtnFinancialStatementItem'
I_JournalEntryItem.CnsldtnFinancialStatementItem,
@ObjectModel.foreignKey.association: '_CnsldtnSubitemCategory'
I_JournalEntryItem.CnsldtnSubitemCategory,
@ObjectModel.foreignKey.association: '_CnsldtnSubitem'
I_JournalEntryItem.CnsldtnSubitem,
///////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_GEN Unified Journal Entry: Fields for several subledgers
//////////////////////////////////////////////////////////////////////////
I_JournalEntryItem.InvoiceReference,
I_JournalEntryItem.InvoiceReferenceFiscalYear,
I_JournalEntryItem.FollowOnDocumentType,
I_JournalEntryItem.InvoiceItemReference,
I_JournalEntryItem.ReferencePurchaseOrderCategory,
I_JournalEntryItem.PurchasingDocument,
I_JournalEntryItem.PurchasingDocumentItem,
I_JournalEntryItem.AccountAssignmentNumber,
I_JournalEntryItem.DocumentItemText,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'SalesDocument'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'SalesDocument'
I_JournalEntryItem.SalesOrder,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'SalesDocumentItem'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'SalesDocumentItem'
I_JournalEntryItem.SalesOrderItem,
I_JournalEntryItem.SalesDocument,
I_JournalEntryItem.SalesDocumentItem,
@ObjectModel.foreignKey.association: '_Product'
I_JournalEntryItem.Product,
@ObjectModel.foreignKey.association: '_ProductGroup_2'
I_JournalEntryItem.ProductGroup,
@ObjectModel.foreignKey.association: '_Plant'
I_JournalEntryItem.Plant,
I_JournalEntryItem.Supplier,
@ObjectModel.foreignKey.association: '_Customer'
I_JournalEntryItem.Customer,
//@ObjectModel.readOnly:true
//@ObjectModel.virtualElement
//@ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_BP_MULTI_ADDR_BF_CALC_EXIT'
//cast(' ' as fis_bpcustmultiaddr preserving type) as BPCustMultiAddrIsActive,
I_JournalEntryItem.ServicesRenderedDate,
I_JournalEntryItem.PerformancePeriodStartDate,
I_JournalEntryItem.PerformancePeriodEndDate,
I_JournalEntryItem.ComponentBreakdown,
I_JournalEntryItem.CompBreakdownScaleNumerator,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FI Unified Journal Entry: Fields for FI subledgers
/////////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_FinancialAccountType'
I_JournalEntryItem.FinancialAccountType,
I_JournalEntryItem.SpecialGLCode,
I_JournalEntryItem.TaxCode,
I_JournalEntryItem.HouseBank,
I_JournalEntryItem.HouseBankAccount,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsOpenItemManaged,
I_JournalEntryItem.ClearingDate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry'
I_JournalEntryItem.ClearingAccountingDocument,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
I_JournalEntryItem.ClearingDocFiscalYear,
I_JournalEntryItem.ClearingJournalEntry,
I_JournalEntryItem.ClearingJournalEntryFiscalYear,
//@Semantics.booleanIndicator
//cast( ( case ClearingDate when '00000000' then cast( ' ' as abap.char(1))
// else cast( 'X' as abap.char(1))
// end )
//as farp_xaugp ) as IsCleared,
cast( ( case I_JournalEntryItem.ClearingDate when '00000000' then ' '
else 'X'
end )
as farp_xaugp preserving type ) as IsCleared,
I_JournalEntryItem.ValueDate,
I_JournalEntryItem.GeneralLedgerAgingScope,
I_JournalEntryItem.GeneralLedgerAgingIncrement,
/////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FAA Unified Journal Entry: Fields for Asset Accounting
/////////////////////////////////////////////////////////////////////////
I_JournalEntryItem.AssetDepreciationArea,
I_JournalEntryItem.MasterFixedAsset,
I_JournalEntryItem.FixedAsset,
I_JournalEntryItem.AssetValueDate,
I_JournalEntryItem.AssetTransactionType,
I_JournalEntryItem.AssetAcctTransClassfctn,
I_JournalEntryItem.DepreciationFiscalPeriod,
I_JournalEntryItem.GroupMasterFixedAsset,
I_JournalEntryItem.GroupFixedAsset,
I_JournalEntryItem.AssetClass,
//////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_ML Unified Journal Entry: Fields for Material Ledger
//////////////////////////////////////////////////////////////////////////
I_JournalEntryItem.CostEstimate,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'InvtrySpecialStockValnType_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'InvtrySpecialStockValnType_2'
I_JournalEntryItem.InventorySpecialStockValnType,
@Analytics.internalName: #LOCAL
I_JournalEntryItem.InvtrySpecialStockValnType_2,
//xobew,
I_JournalEntryItem.InventorySpecialStockType,
I_JournalEntryItem.InventorySpclStkSalesDocument, // as InventorySpecialStockSalesDocument,
I_JournalEntryItem.InventorySpclStkSalesDocItm, // as InventorySpecialStockSalesDocumentItem,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'InvtrySpclStockWBSElmntIntID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'InvtrySpclStockWBSElmntIntID'
cast( I_JournalEntryItem.InventorySpclStockWBSElement as fis_invspstock_wbs_no_conv_dep preserving type ) as InventorySpclStockWBSElement, //open again at 15.11.22
I_JournalEntryItem.InvtrySpclStockWBSElmntIntID,
I_JournalEntryItem.InventorySpecialStockSupplier,
I_JournalEntryItem.InventoryValuationType,
I_JournalEntryItem.ValuationArea,
////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_CFIN Unified Journal Entry: Fields for Central Finance
//////////////////////////////////////////////////////////////////////////////
I_JournalEntryItem.SenderGLAccount,
I_JournalEntryItem.SenderAccountAssignment,
I_JournalEntryItem.SenderAccountAssignmentType,
////////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_CO Unified Journal Entry: CO fields
///////////////////////////////////////////////////////////////////////////
I_JournalEntryItem.ControllingObject,
I_JournalEntryItem.CostOriginGroup,
I_JournalEntryItem.OriginSenderObject,
I_JournalEntryItem.ControllingDebitCreditCode,
I_JournalEntryItem.ControllingObjectDebitType,
//@Semantics.booleanIndicator
I_JournalEntryItem.QuantityIsIncomplete,
I_JournalEntryItem.OffsettingAccount,
I_JournalEntryItem.OffsettingAccountType,
I_JournalEntryItem.OffsettingChartOfAccounts,
//@Semantics.booleanIndicator
I_JournalEntryItem.LineItemIsCompleted,
I_JournalEntryItem.PersonnelNumber,
I_JournalEntryItem.BillableControl,
I_JournalEntryItem.ControllingObjectClass,
I_JournalEntryItem.PartnerCompanyCode,
I_JournalEntryItem.PartnerControllingObjectClass,
I_JournalEntryItem.OriginCostCenter,
I_JournalEntryItem.OriginProfitCenter,
I_JournalEntryItem.OriginCostCtrActivityType,
I_JournalEntryItem.OriginProduct,
I_JournalEntryItem.VarianceOriginGLAccount,
I_JournalEntryItem.AccountAssignment,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_AccountAssignmentType'
I_JournalEntryItem.AccountAssignmentType,
I_JournalEntryItem.CostCtrActivityType,
I_JournalEntryItem.OrderID,
I_JournalEntryItem.OrderCategory,
I_JournalEntryItem.WBSElementInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'WBSElementInternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementInternalID'
cast( I_JournalEntryItem.WBSElement as fis_wbs_no_conv_depre preserving type ) as WBSElement, //open again at 15.11.22
cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) as WBSElementExternalID, //new 14.10.2024
@ObjectModel.foreignKey.association: '_WorkPackage'
I_JournalEntryItem.WorkPackage,
I_JournalEntryItem.ProjectInternalID,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'ProjectInternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'ProjectInternalID'
cast( I_JournalEntryItem.Project as fis_project_no_conv_depre preserving type ) as Project, //open again at 15.11.22
cast( _ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) as ProjectExternalID, //new 14.10.2024
I_JournalEntryItem.OperatingConcern,
I_JournalEntryItem.ProjectNetwork,
I_JournalEntryItem.RelatedNetworkActivity,
I_JournalEntryItem.BusinessProcess,
I_JournalEntryItem.CostObject,
//bemot,
@ObjectModel.foreignKey.association: '_CostAnalysisResource'
I_JournalEntryItem.CostAnalysisResource,
I_JournalEntryItem.CustomerServiceNotification,
I_JournalEntryItem.ServiceDocumentType,
I_JournalEntryItem.ServiceDocument,
I_JournalEntryItem.ServiceDocumentItem,
I_JournalEntryItem.ServiceContract,
I_JournalEntryItem.ServiceContractType,
I_JournalEntryItem.ServiceContractItem,
I_JournalEntryItem.BusinessSolutionOrder,
I_JournalEntryItem.BusinessSolutionOrderItem,
@ObjectModel.foreignKey.association: '_ProviderContract'
I_JournalEntryItem.ProviderContract,
@ObjectModel.foreignKey.association: '_ProviderContractItem'
I_JournalEntryItem.ProviderContractItem,
I_JournalEntryItem.RevenueAccountingContract,
I_JournalEntryItem.PerformanceObligation,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_TimeSheetOvertimeCat'
I_JournalEntryItem.TimeSheetOvertimeCategory,
I_JournalEntryItem.PartnerServiceDocumentType,
I_JournalEntryItem.PartnerServiceDocument,
I_JournalEntryItem.PartnerServiceDocumentItem,
I_JournalEntryItem.PartnerAccountAssignment,
I_JournalEntryItem.PartnerAccountAssignmentType,
I_JournalEntryItem.PartnerCostCtrActivityType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PartnerOrder_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'PartnerOrder_2'
I_JournalEntryItem.PartnerOrder,
I_JournalEntryItem.PartnerOrder_2,
I_JournalEntryItem.PartnerOrderCategory,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PartnerWBSElementInternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'PartnerWBSElementInternalID'
cast( I_JournalEntryItem.PartnerWBSElement as fis_partner_wbs_no_conv_depre preserving type ) as PartnerWBSElement, //open again at 15.11.22
cast( _PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) as PartnerWBSElementExternalID, //new 14.10.2024
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'PartnerProjectInternalID'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'PartnerProjectInternalID'
cast( I_JournalEntryItem.PartnerProject as fis_part_project_no_conv_depre preserving type ) as PartnerProject, //open again at 15.11.22
cast( _PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) as PartnerProjectExternalID, //new 14.10.2024
I_JournalEntryItem.PartnerSalesDocument,
I_JournalEntryItem.PartnerSalesDocumentItem,
I_JournalEntryItem.PartnerProjectNetwork,
I_JournalEntryItem.PartnerProjectNetworkActivity,
I_JournalEntryItem.PartnerBusinessProcess,
I_JournalEntryItem.PartnerCostObject,
I_JournalEntryItem.PartnerProjectInternalID,
I_JournalEntryItem.PartnerWBSElementInternalID,
@ObjectModel.foreignKey.association: '_WorkPackageWorkItem'
I_JournalEntryItem.WorkItem,
I_JournalEntryItem.VarianceOriginGroup,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_COPA Unified Journal Entry: CO-PA fields
//////////////////////////////////////////////////////////////////////
I_JournalEntryItem.BillingDocumentType,
I_JournalEntryItem.SalesOrganization,
I_JournalEntryItem.DistributionChannel,
I_JournalEntryItem.OrganizationDivision,
//SoldMaterial, //do not use any longer, use SoldProduct
@ObjectModel.foreignKey.association: '_SoldProduct'
I_JournalEntryItem.SoldProduct,
//@ObjectModel.foreignKey.association: '_MaterialGroup'
//MaterialGroup, //do not use any longer, use SoldProduct
@ObjectModel.foreignKey.association: '_SoldProductGroup_2'
I_JournalEntryItem.SoldProductGroup,
@ObjectModel.foreignKey.association: '_CustomerGroup'
I_JournalEntryItem.CustomerGroup,
I_JournalEntryItem.CustomerSupplierCountry,
I_JournalEntryItem.CustomerSupplierIndustry,
I_JournalEntryItem.SalesDistrict,
I_JournalEntryItem.BillToParty,
I_JournalEntryItem.ShipToParty,
I_JournalEntryItem.CustomerSupplierCorporateGroup,
//////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_PS Unified Journal Entry: Fields for Public Sector
/////////////////////////////////////////////////////////////////////
@ObjectModel.foreignKey.association: '_CashLedgerCompanyCode'
I_JournalEntryItem.CashLedgerCompanyCode,
@ObjectModel.foreignKey.association: '_CashLedgerAccount'
I_JournalEntryItem.CashLedgerAccount,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FinMgmtAreaStdVH',
element: 'FinancialManagementArea' }
}]
// @ObjectModel.text.association: '_FinancialManagementAreaText'
@ObjectModel.foreignKey.association: '_FinancialManagementArea'
I_JournalEntryItem.FinancialManagementArea,
I_JournalEntryItem.CommitmentItem,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundsCenterStdVH',
element: 'FundsCenter' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
@ObjectModel.foreignKey.association: '_FundsCenter'
I_JournalEntryItem.FundsCenter,
@ObjectModel.foreignKey.association: '_FundedProgram'
I_JournalEntryItem.FundedProgram,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_FundText'
@ObjectModel.foreignKey.association: '_Fund'
I_JournalEntryItem.Fund,
@ObjectModel.foreignKey.association: '_Grant'
I_JournalEntryItem.GrantID,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_BudgetPeriodStdVH',
element: 'BudgetPeriod' }
}]
// @ObjectModel.text.association: '_BudgetPeriodText'
@ObjectModel.foreignKey.association: '_BudgetPeriod'
I_JournalEntryItem.BudgetPeriod,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_FundStdVH',
element: 'Fund' },
additionalBinding: [{ localElement: 'FinancialManagementArea',
element: 'FinancialManagementArea' }]
}]
// @ObjectModel.text.association: '_PartnerFundText'
@ObjectModel.foreignKey.association: '_PartnerFund'
I_JournalEntryItem.PartnerFund,
@ObjectModel.foreignKey.association: '_PartnerGrant'
I_JournalEntryItem.PartnerGrant,
@ObjectModel.foreignKey.association: '_PartnerBudgetPeriod'
I_JournalEntryItem.PartnerBudgetPeriod,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccount'
I_JournalEntryItem.PubSecBudgetAccount,
@ObjectModel.foreignKey.association: '_PubSecBudgetAccountCoCode'
I_JournalEntryItem.PubSecBudgetAccountCoCode,
@ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnDate'
I_JournalEntryItem.PubSecBudgetCnsmpnDate,
@ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnFsclPeriod'
I_JournalEntryItem.PubSecBudgetCnsmpnFsclPeriod,
@ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnFsclYear'
I_JournalEntryItem.PubSecBudgetCnsmpnFsclYear,
//@Semantics.booleanIndicator
I_JournalEntryItem.PubSecBudgetIsRelevant,
@ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnType'
I_JournalEntryItem.PubSecBudgetCnsmpnType,
@ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnAmtType'
I_JournalEntryItem.PubSecBudgetCnsmpnAmtType,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_SponsoredProgram'
I_JournalEntryItem.SponsoredProgram,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_SponsoredClass'
I_JournalEntryItem.SponsoredClass,
I_JournalEntryItem.EarmarkedFundsDocument,
I_JournalEntryItem.EarmarkedFundsDocumentItem,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_FS Universal Journal Entry: Fields for Financial Services
//
// these 3 fields are not in C-View (24.04.23)
// get via datasource extension -> FK gives VH
// text.association has no effect -> ID+ Text in one column not possible
// with text.element 2 independent columns ID and text , but not in 1 column ID+Text
////////////////////////////////////////////////////////////////////////////////////////
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_FinServicesProductGroup'
@ObjectModel.text.association: '_FinServicesProductGroupText'
@ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
I_JournalEntryItem.FinancialServicesProductGroup,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_FinancialServicesBranch'
@ObjectModel.text.association: '_FinancialServicesBranchText'
@ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
I_JournalEntryItem.FinancialServicesBranch,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_FinancialDataSource'
@ObjectModel.text.association: '_FinancialDataSourceText'
@ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
I_JournalEntryItem.FinancialDataSource,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_JVA Unified Journal Entry: Fields for Joint Venture Accounting
///////////////////////////////////////////////////////////////////////
I_JournalEntryItem.JointVenture,
I_JournalEntryItem.JointVentureEquityGroup,
I_JournalEntryItem.JointVentureCostRecoveryCode,
I_JournalEntryItem.JointVenturePartner,
I_JournalEntryItem.JointVentureBillingType,
I_JournalEntryItem.JointVentureEquityType,
I_JournalEntryItem.JointVentureProductionDate,
I_JournalEntryItem.JointVentureBillingDate,
I_JournalEntryItem.JointVentureOperationalDate,
I_JournalEntryItem.CutbackRun,
I_JournalEntryItem.JointVentureAccountingActivity,
I_JournalEntryItem.PartnerVenture,
I_JournalEntryItem.PartnerEquityGroup,
I_JournalEntryItem.SenderCostRecoveryCode,
I_JournalEntryItem.CutbackAccount,
I_JournalEntryItem.CutbackCostObject,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_RE STRU 0 0 Unified Journal Entry: Fields for Real Estate
///////////////////////////////////////////////////////////////////////
I_JournalEntryItem.REBusinessEntity,
I_JournalEntryItem.RealEstateBuilding,
I_JournalEntryItem.RealEstateProperty,
I_JournalEntryItem.RERentalObject,
I_JournalEntryItem.RealEstateContract,
I_JournalEntryItem.REServiceChargeKey,
I_JournalEntryItem.RESettlementUnitID,
I_JournalEntryItem.SettlementReferenceDate,
I_JournalEntryItem.REPartnerBusinessEntity,
I_JournalEntryItem.RealEstatePartnerBuilding,
I_JournalEntryItem.RealEstatePartnerProperty,
I_JournalEntryItem.REPartnerRentalObject,
I_JournalEntryItem.RealEstatePartnerContract,
I_JournalEntryItem.REPartnerServiceChargeKey,
I_JournalEntryItem.REPartnerSettlementUnitID,
I_JournalEntryItem.PartnerSettlementReferenceDate,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_ACR STRU 0 0 Universal Journal Entry: Fields for Accrual object
///////////////////////////////////////////////////////////////////////
// AccrualObject --(1:N)--> AccrualSubobject --(1:N)--> Accrual(Subobject)Item (this field is not stored in ACDOCA)
// AccrualObjectType AccrualItemType are the corresponding types
//@ObjectModel.foreignKey.association: '_AccrualObjectType'
I_JournalEntryItem.AccrualObjectType,
I_JournalEntryItem.AccrualObjectLogicalSystem,
//@ObjectModel.foreignKey.association: '_AccrualObject'
I_JournalEntryItem.AccrualObject,
//@ObjectModel.foreignKey.association: '_AccrualSubobject'
I_JournalEntryItem.AccrualSubobject,
//@ObjectModel.foreignKey.association: '_AccrualItemType'
I_JournalEntryItem.AccrualItemType,
I_JournalEntryItem.AccrualReferenceObject,
I_JournalEntryItem.AccrualValueDate,
///////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_VAL STRU 0 0 Universal Journal Entry: Fields for Fin. Valuation Object
///////////////////////////////////////////////////////////////////////
I_JournalEntryItem.FinancialValuationObjectType,
I_JournalEntryItem.FinancialValuationObject,
I_JournalEntryItem.FinancialValuationSubobject,
I_JournalEntryItem.NetDueDate,
I_JournalEntryItem.CreditRiskClass,
//////////////////////////////////////////////////////////////////////////
// .INCLUDE ACDOC_SI_TECH: Universal Journal Entry: Technical Fields //
//////////////////////////////////////////////////////////////////////////
I_JournalEntryItem.JrnlEntryItemMigrationSource,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
I_JournalEntryItem.DebitAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
I_JournalEntryItem.CreditAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
I_JournalEntryItem.DebitAmountInTransCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
I_JournalEntryItem.CreditAmountInTransCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
I_JournalEntryItem.DebitAmountInBalanceTransCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
I_JournalEntryItem.CreditAmountInBalanceTransCrcy,
////////////////////////////////////
// NEW
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_JournalEntryItem.DebitAmountInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
I_JournalEntryItem.CreditAmountInGlobalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
I_JournalEntryItem.DebitAmountInFunctionalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
I_JournalEntryItem.CreditAmountInFunctionalCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy1 as DebitAmountInFreeDfndCrcy1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy1 as CreditAmountInFreeDfndCrcy1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy2 as DebitAmountInFreeDfndCrcy2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy2 as CreditAmountInFreeDfndCrcy2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy3 as DebitAmountInFreeDfndCrcy3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy3 as CreditAmountInFreeDfndCrcy3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy4 as DebitAmountInFreeDfndCrcy4,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy4 as CreditAmountInFreeDfndCrcy4,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy5 as DebitAmountInFreeDfndCrcy5,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy5 as CreditAmountInFreeDfndCrcy5,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy6 as DebitAmountInFreeDfndCrcy6,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy6 as CreditAmountInFreeDfndCrcy6,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy7 as DebitAmountInFreeDfndCrcy7,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy7 as CreditAmountInFreeDfndCrcy7,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy8 as DebitAmountInFreeDfndCrcy8,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy8 as CreditAmountInFreeDfndCrcy8,
//////////////////////////////////
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
// case FinancialAccountType when 'S' then cast(DebitAmountInCoCodeCrcy as fis_sdr_hsl)
// else cast( cast( '0' as abap.curr( 23,2)) as fis_sdr_hsl)
// end as GLDebitAmountInCoCodeCrcy,
case I_JournalEntryItem.FinancialAccountType when 'S' then cast( I_JournalEntryItem.DebitAmountInCoCodeCrcy as fis_sdr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_sdr_hsl preserving type )
end
as GLDebitAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
// case FinancialAccountType when 'A' then cast(DebitAmountInCoCodeCrcy as fis_adr_hsl)
// else cast( cast( '0' as abap.curr( 23,2)) as fis_adr_hsl)
// end as AssetDebitAmtInCoCodeCrcy,
case I_JournalEntryItem.FinancialAccountType when 'A' then cast( I_JournalEntryItem.DebitAmountInCoCodeCrcy as fis_adr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_adr_hsl preserving type )
end
as AssetDebitAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'M' then cast( I_JournalEntryItem.DebitAmountInCoCodeCrcy as fis_mdr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_mdr_hsl preserving type )
end
as MaterialDebitAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'D' then cast( I_JournalEntryItem.DebitAmountInCoCodeCrcy as fis_ddr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_ddr_hsl preserving type )
end
as DebtorDebitAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'K' then cast( I_JournalEntryItem.DebitAmountInCoCodeCrcy as fis_kdr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_kdr_hsl preserving type )
end
as CreditorDebitAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'S' then cast( I_JournalEntryItem.CreditAmountInCoCodeCrcy as fis_scr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_scr_hsl preserving type )
end
as GLCreditAmountInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'A' then cast( I_JournalEntryItem.CreditAmountInCoCodeCrcy as fis_acr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_acr_hsl preserving type )
end
as AssetCreditAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'M' then cast( I_JournalEntryItem.CreditAmountInCoCodeCrcy as fis_mcr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_mcr_hsl preserving type )
end
as MaterialCreditAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'D' then cast( I_JournalEntryItem.CreditAmountInCoCodeCrcy as fis_dcr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_dcr_hsl preserving type )
end
as DebtorCreditAmtInCoCodeCrcy,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
case I_JournalEntryItem.FinancialAccountType when 'K' then cast( I_JournalEntryItem.CreditAmountInCoCodeCrcy as fis_kcr_hsl preserving type )
else cast( cast( 0 as abap.curr( 23,2) ) as fis_kcr_hsl preserving type )
end
as CreditorCreditAmtInCoCodeCrcy,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsStatisticalOrder,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsStatisticalCostCenter,
//@Semantics.booleanIndicator
I_JournalEntryItem.IsStatisticalSalesDocument,
//@Semantics.booleanIndicator
I_JournalEntryItem.WBSIsStatisticalWBSElement,
@Aggregation.default: #SUM
I_JournalEntryItem.NumberOfItems,
cast($parameters.P_ClearingStatusSelection as fis_clearingstatusselection preserving type ) as ClearingStatusSelection,
//$extension.*,
//_WBSElementInternalID,
_WBSElementExternalID,
_PartnerWBSElementExternalID,
I_JournalEntryItem._WBSElementBasicData,
//_WBSElement,
//_ProjectInternalID,
_ProjectExternalID,
_PartnerProjectExternalID,
I_JournalEntryItem._ProjectBasicData,
//_Project,
I_JournalEntryItem._JournalEntry,
I_JournalEntryItem._CompanyCode,
I_JournalEntryItem._FiscalYear,
I_JournalEntryItem._LedgerCompanyCodeCrcyRoles,
//_FiscalPeriod,
//_LedgerFiscalYear,
I_JournalEntryItem._FiscalYearVariant,
I_JournalEntryItem._FiscalPeriodForVariant,
I_JournalEntryItem._LedgerFiscalYearForVariant,
I_JournalEntryItem._ControllingArea,
I_JournalEntryItem._BalanceTransactionCurrency,
I_JournalEntryItem._TransactionCurrency,
I_JournalEntryItem._CompanyCodeCurrency,
I_JournalEntryItem._GlobalCurrency,
I_JournalEntryItem._FunctionalCurrency,
I_JournalEntryItem._FreeDefinedCurrency1,
I_JournalEntryItem._FreeDefinedCurrency2,
I_JournalEntryItem._FreeDefinedCurrency3,
I_JournalEntryItem._FreeDefinedCurrency4,
I_JournalEntryItem._FreeDefinedCurrency5,
I_JournalEntryItem._FreeDefinedCurrency6,
I_JournalEntryItem._FreeDefinedCurrency7,
I_JournalEntryItem._FreeDefinedCurrency8,
I_JournalEntryItem._BaseUnit,
I_JournalEntryItem._CostSourceUnit,
I_JournalEntryItem._AdditionalQuantity1Unit,
I_JournalEntryItem._AdditionalQuantity2Unit,
I_JournalEntryItem._AdditionalQuantity3Unit,
I_JournalEntryItem._IncmpltSummableValnQtyUnt,
I_JournalEntryItem._Segment,
I_JournalEntryItem._ProfitCenter,
I_JournalEntryItem._CurrentProfitCenter,
I_JournalEntryItem._CostCenter,
I_JournalEntryItem._CurrentCostCenter,
I_JournalEntryItem._CostAnalysisResource,
I_JournalEntryItem._AccountAssignmentType,
I_JournalEntryItem._BusinessArea,
I_JournalEntryItem._FunctionalArea,
I_JournalEntryItem._GLAccountInChartOfAccounts,
I_JournalEntryItem._GLAccountInCompanyCode,
I_JournalEntryItem._ChartOfAccounts,
I_JournalEntryItem._AccountingDocumentType,
I_JournalEntryItem._FinancialAccountType,
I_JournalEntryItem._DebitCreditCode,
//_Material,
//_MaterialGroup,
I_JournalEntryItem._Product,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ProductGroup_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ProductGroup_2'
I_JournalEntryItem._ProductGroup,
_ProductGroup_2,
I_JournalEntryItem._Plant,
I_JournalEntryItem._WorkPackageWorkItem,
I_JournalEntryItem._WorkPackage,
I_JournalEntryItem._Ledger,
I_JournalEntryItem._SourceLedger,
I_JournalEntryItem._Customer,
I_JournalEntryItem._CustomerCompany,
I_JournalEntryItem._CustomerGroup,
I_JournalEntryItem._Supplier,
I_JournalEntryItem._SupplierCompany,
//_SalesOrder,
//_SalesOrderItem,
I_JournalEntryItem._SalesDocument,
I_JournalEntryItem._SalesDocumentItem,
I_JournalEntryItem._InternalOrder,
I_JournalEntryItem._Order,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_PersonWorkAgreement_1'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_PersonWorkAgreement_1'
I_JournalEntryItem._Employment,
_PersonWorkAgreement_1,
I_JournalEntryItem._BillableControl,
//_Extension Extensions must be local
I_JournalEntryItem._FinancialTransactionType,
I_JournalEntryItem._BusinessTransactionCategory,
I_JournalEntryItem._BusinessTransactionType,
I_JournalEntryItem._ReferenceDocumentType,
I_JournalEntryItem._PredecessorReferenceDocType,
I_JournalEntryItem._PartnerCostCenter,
I_JournalEntryItem._PartnerProfitCenter,
I_JournalEntryItem._PartnerBusinessArea,
I_JournalEntryItem._PartnerFunctionalArea,
I_JournalEntryItem._PartnerCompanyCode,
I_JournalEntryItem._PartnerSegment,
I_JournalEntryItem._AccountingDocumentCategory,
I_JournalEntryItem._PostingKey,
I_JournalEntryItem._SubLedgerAccLineItemType,
I_JournalEntryItem._User,
I_JournalEntryItem._EliminationProfitCenter,
I_JournalEntryItem._ControllingObject,
I_JournalEntryItem._GLAccountType,
I_JournalEntryItem._AlternativeGLAccount,
//_SenderGLAccount,
I_JournalEntryItem._CountryChartOfAccounts,
I_JournalEntryItem._PurchasingDocument,
I_JournalEntryItem._PurchasingDocumentItem,
I_JournalEntryItem._SpecialGLCode,
I_JournalEntryItem._TaxCode,
I_JournalEntryItem._HouseBank,
I_JournalEntryItem._ClearingJrnlEntryFiscalYear,
I_JournalEntryItem._ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ClearingJournalEntry'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ClearingJournalEntry'
I_JournalEntryItem._ClearingAccountingDocument,
I_JournalEntryItem._MasterFixedAsset,
I_JournalEntryItem._GroupMasterFixedAsset,
I_JournalEntryItem._FixedAsset,
I_JournalEntryItem._GroupFixedAsset,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_InventorySpclStockValnType'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_InventorySpclStockValnType'
I_JournalEntryItem._InventorySpecialStockValnType,
I_JournalEntryItem._InventorySpclStockValnType,
I_JournalEntryItem._InventorySpecialStockType,
I_JournalEntryItem._InventorySpclStkSalesDocument,
I_JournalEntryItem._InventorySpclStkSalesDocItm,
//_InventorySpclStockWBSElement,
I_JournalEntryItem._InvtrySpclStockWBSElmntBD as _InvtrySpclStkWBSElmntBscData,
I_JournalEntryItem._InventorySpecialStockSupplier,
I_JournalEntryItem._InventoryValuationType,
I_JournalEntryItem._OriginSenderObject,
I_JournalEntryItem._ControllingObjectClass,
I_JournalEntryItem._PartnerControllingObjectClass,
I_JournalEntryItem._OriginCostCenter,
I_JournalEntryItem._OriginProfitCenter,
I_JournalEntryItem._CostCtrActivityType,
I_JournalEntryItem._OriginCostCtrActivityType,
I_JournalEntryItem._OrderCategory,
//_RelatedNetworkActivity,
//_PartnerProjectNetworkActivity,
I_JournalEntryItem._BusinessProcess,
I_JournalEntryItem._PartnerCostCtrActivityType,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_PartnerOrder_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_PartnerOrder_2'
I_JournalEntryItem._PartnerOrder,
_PartnerOrder_2,
I_JournalEntryItem._PartnerOrderCategory,
I_JournalEntryItem._PartnerWBSElementBasicData,
//_PartnerWBSElement,
I_JournalEntryItem._PartnerProjectBasicData,
//_PartnerProject,
I_JournalEntryItem._PartnerSalesDocument,
I_JournalEntryItem._PartnerSalesDocumentItem,
I_JournalEntryItem._PartnerBusinessProcess,
I_JournalEntryItem._BillingDocumentType,
I_JournalEntryItem._SalesOrganization,
I_JournalEntryItem._DistributionChannel,
I_JournalEntryItem._SoldProduct,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_SoldProductGroup_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_SoldProductGroup_2'
I_JournalEntryItem._SoldProductGroup,
I_JournalEntryItem._SoldProductGroup_2,
I_JournalEntryItem._Fund,
I_JournalEntryItem._PartnerFund,
I_JournalEntryItem._FundsCenter,
I_JournalEntryItem._MovementCategory,
I_JournalEntryItem._AssetTransactionType,
I_JournalEntryItem._BudgetPeriod,
I_JournalEntryItem._CostOriginGroup,
I_JournalEntryItem._FinancialManagementArea,
//_FundedProgram
I_JournalEntryItem._HouseBankAccount,
I_JournalEntryItem._LogicalSystem,
I_JournalEntryItem._OperatingConcern,
I_JournalEntryItem._PartnerCompany,
I_JournalEntryItem._ProjectNetwork,
I_JournalEntryItem._PurReqValuationArea,
I_JournalEntryItem._OffsettingAccountType,
I_JournalEntryItem._OffsettingChartOfAccounts,
I_JournalEntryItem._OffsettingAccount,
I_JournalEntryItem._OffsettingAccountWithBP,
I_JournalEntryItem._LedgerText,
I_JournalEntryItem._DebitCreditCodeText,
I_JournalEntryItem._FunctionalAreaText,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_ProfitCenterTxt'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_ProfitCenterTxt'
I_JournalEntryItem._ProfitCenterText,
I_JournalEntryItem._ProfitCenterTxt,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_CostCenterTxt'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_CostCenterTxt'
I_JournalEntryItem._CostCenterText,
I_JournalEntryItem._CostCenterTxt,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_GLAccountTxt'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_GLAccountTxt'
I_JournalEntryItem._GLAccountText,
I_JournalEntryItem._GLAccountTxt,
I_JournalEntryItem._BusinessAreaText,
I_JournalEntryItem._SegmentText,
I_JournalEntryItem._AccountingDocumentTypeText,
I_JournalEntryItem._SupplierText,
I_JournalEntryItem._ControllingAreaText,
I_JournalEntryItem._CustomerText,
I_JournalEntryItem._CompanyCodeText,
I_JournalEntryItem._OffsettingAccountText,
I_JournalEntryItem._MasterFixedAssetText,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_PartnerOrderText_2'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: '_PartnerOrderText_2'
I_JournalEntryItem._PartnerOrderText,
_PartnerOrderText_2,
I_JournalEntryItem._GroupMasterFixedAssetText,
//_ProjectText,
I_JournalEntryItem._ServiceDocumentType,
I_JournalEntryItem._ServiceDocument,
I_JournalEntryItem._ServiceDocumentItem,
I_JournalEntryItem._ServiceContract,
I_JournalEntryItem._ServiceContractType,
I_JournalEntryItem._ServiceContractItem,
I_JournalEntryItem._TimeSheetOvertimeCat,
I_JournalEntryItem._PartnerServiceDocumentType,
I_JournalEntryItem._PartnerServiceDocument,
I_JournalEntryItem._PartnerServiceDocumentItem,
//_PartnerProjectBasicDataText,
//_PartnerWBSElemntBasicDataText,
I_JournalEntryItem._AccrualObjectType,
I_JournalEntryItem._AccrualObject,
I_JournalEntryItem._AccrualSubobject,
I_JournalEntryItem._AccrualItemType,
I_JournalEntryItem._CreditRiskClass,
I_JournalEntryItem._FinValuationObjectType,
I_JournalEntryItem._CashLedgerCompanyCode,
I_JournalEntryItem._CashLedgerAccount,
I_JournalEntryItem._FundedProgram,
I_JournalEntryItem._Grant,
I_JournalEntryItem._PartnerGrant,
I_JournalEntryItem._PartnerBudgetPeriod,
I_JournalEntryItem._PubSecBudgetAccountCoCode,
I_JournalEntryItem._PubSecBudgetAccount,
I_JournalEntryItem._PubSecBudgetCnsmpnDate,
I_JournalEntryItem._PubSecBudgetCnsmpnFsclPeriod,
I_JournalEntryItem._PubSecBudgetCnsmpnFsclYear,
I_JournalEntryItem._PubSecBudgetCnsmpnType,
I_JournalEntryItem._PubSecBudgetCnsmpnAmtType,
I_JournalEntryItem._SponsoredProgram,
I_JournalEntryItem._SponsoredClass,
I_JournalEntryItem._ConsolidationUnit,
I_JournalEntryItem._PartnerConsolidationUnit,
I_JournalEntryItem._Company,
I_JournalEntryItem._ConsolidationChartOfAccounts,
I_JournalEntryItem._CnsldtnFinancialStatementItem,
I_JournalEntryItem._CnsldtnSubitemCategory,
I_JournalEntryItem._CnsldtnSubitem,
I_JournalEntryItem._ProviderContract,
I_JournalEntryItem._ProviderContractItem,
_FinServicesProductGroup,
_FinServicesProductGroupText,
_FinancialServicesBranch,
_FinancialServicesBranchText,
_FinancialDataSource,
_FinancialDataSourceText,
_CustomerSupplierIndustry,
I_JournalEntryItem._CustomerSupplierCountry
}