I_GLACCOUNTLINEITEMRAWDATA

//////////////////////////////////////////////////////////////////////////////

// Documentation: This view does not implement the logic for extension ledgers

// Result will be incomplete for ledgers other than basis ledgers

// For correct data of all ledgers use

// I_JournalEntryItem (change flows)

// I_GLAccountLineItem (for calculation of balances of Balance Sheet Accounts (includes BCF for GL Account Balances calculation)

@EndUserText.label: 'Raw Data of G/L Account Line Item'

@AbapCatalog: { sqlViewName: 'IFIGLACCTLIR',
                compiler.compareFilter: true,
                preserveKey: true,
                buffering.status: #NOT_ALLOWED }

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { representativeKey: 'LedgerGLLineItem',
                usageType.sizeCategory: #XXL,
                usageType.dataClass:  #TRANSACTIONAL,
                usageType.serviceQuality: #B,
                supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ],
                modelingPattern: #NONE }
@Analytics: {
      dataCategory: #CUBE,
      internalName: #LOCAL,
      dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
          mapping:
            [
              {
                table: 'ACDOCA',
                role: #MAIN,
                viewElement: ['SourceLedger', 'CompanyCode', 'FiscalYear', 'AccountingDocument', 'LedgerGLLineItem'],
                tableElement: ['rldnr', 'rbukrs', 'gjahr', 'belnr', 'docln']
              }
            ]
         }
      }
    }


@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
//@AccessControl.privilegedAssociations: ['_User' ]


define view I_GLAccountLineItemRawData
  as select from P_ACDOCA

  /* *************************************************************
   *  association zur ID
   * *************************************************************
  */

  association [0..1] to I_JournalEntry                 as _JournalEntry                  on  $projection.CompanyCode        = _JournalEntry.CompanyCode
                                                                                         and $projection.FiscalYear         = _JournalEntry.FiscalYear
                                                                                         and $projection.AccountingDocument = _JournalEntry.AccountingDocument
  association [1..1] to I_CompanyCode                  as _CompanyCode                   on  $projection.CompanyCode = _CompanyCode.CompanyCode

  association [1..1] to I_FiscalYearVariant            as _FiscalYearVariant             on  $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant
  association [0..1] to I_FiscalYearForCompanyCode     as _FiscalYear                    on  $projection.FiscalYear  = _FiscalYear.FiscalYear
                                                                                         and $projection.CompanyCode = _FiscalYear.CompanyCode
  association [0..1] to I_FiscalYearForVariant         as _LedgerFiscalYearForVariant    on  $projection.LedgerFiscalYear  = _LedgerFiscalYearForVariant.FiscalYear
                                                                                         and $projection.FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant
  association [0..1] to I_FiscalPeriodForVariant       as _FiscalPeriodForVariant        on  $projection.LedgerFiscalYear  = _FiscalPeriodForVariant.FiscalYear
                                                                                         and $projection.FiscalPeriod      = _FiscalPeriodForVariant.FiscalPeriod
                                                                                         and $projection.FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant
  association [0..1] to I_FiscalYearPeriodForVariant   as _FiscalYearPeriodForVariant    on  $projection.FiscalYearPeriod  = _FiscalYearPeriodForVariant.FiscalYearPeriod
                                                                                         and $projection.FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant

  association [0..1] to I_CalendarDate                 as _CalendarDate                  on  $projection.PostingDate = _CalendarDate.CalendarDate
  association [0..1] to I_FiscalCalendarDate           as _FiscalCalendarDate            on  $projection.PostingDate       = _FiscalCalendarDate.CalendarDate
                                                                                         and $projection.FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant
  association [0..1] to I_ControllingArea              as _ControllingArea               on  $projection.ControllingArea = _ControllingArea.ControllingArea

  association [0..1] to I_Currency                     as _BalanceTransactionCurrency    on  $projection.BalanceTransactionCurrency = _BalanceTransactionCurrency.Currency
  association [0..1] to I_Currency                     as _TransactionCurrency           on  $projection.TransactionCurrency = _TransactionCurrency.Currency
  association [1..1] to I_Currency                     as _CompanyCodeCurrency           on  $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency

  association [0..1] to I_Currency                     as _GlobalCurrency                on  $projection.GlobalCurrency = _GlobalCurrency.Currency
  association [0..1] to I_Currency                     as _FunctionalCurrency            on  $projection.FunctionalCurrency = _FunctionalCurrency.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency1          on  $projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency2          on  $projection.FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency3          on  $projection.FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency4          on  $projection.FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency5          on  $projection.FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency6          on  $projection.FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency7          on  $projection.FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency
  association [0..1] to I_Currency                     as _FreeDefinedCurrency8          on  $projection.FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency

  association [0..1] to I_UnitOfMeasure                as _BaseUnit                      on  $projection.BaseUnit = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _CostSourceUnit                on  $projection.CostSourceUnit = _CostSourceUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _AdditionalQuantity1Unit       on  $projection.AdditionalQuantity1Unit = _AdditionalQuantity1Unit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _AdditionalQuantity2Unit       on  $projection.AdditionalQuantity2Unit = _AdditionalQuantity2Unit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _AdditionalQuantity3Unit       on  $projection.AdditionalQuantity3Unit = _AdditionalQuantity3Unit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _ReferenceQuantityUnit         on  $projection.ReferenceQuantityUnit   = _ReferenceQuantityUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure                as _IncmpltSummableValnQtyUnt     on  $projection.IncmpltSummableValnQtyUnt = _IncmpltSummableValnQtyUnt.UnitOfMeasure

  association [0..1] to I_Segment                      as _Segment                       on  $projection.Segment = _Segment.Segment

  association [0..*] to I_ProfitCenter                 as _ProfitCenter                  on  $projection.ControllingArea = _ProfitCenter.ControllingArea
                                                                                         and $projection.ProfitCenter    = _ProfitCenter.ProfitCenter
  association [0..*] to I_CostCenter                   as _CostCenter                    on  $projection.ControllingArea = _CostCenter.ControllingArea
                                                                                         and $projection.CostCenter      = _CostCenter.CostCenter
  association [0..1] to I_BusinessArea                 as _BusinessArea                  on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_FunctionalArea               as _FunctionalArea                on  $projection.FunctionalArea = _FunctionalArea.FunctionalArea

  association [0..1] to I_GLAccountInChartOfAccounts   as _GLAccountInChartOfAccounts    on  $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                         and $projection.GLAccount       = _GLAccountInChartOfAccounts.GLAccount
  association [0..1] to I_GLAccountInCompanyCode       as _GLAccountInCompanyCode        on  $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode
                                                                                         and $projection.GLAccount   = _GLAccountInCompanyCode.GLAccount
  association [0..1] to I_ChartOfAccounts              as _ChartOfAccounts               on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

  association [0..1] to I_AccountingDocumentType       as _AccountingDocumentType        on  $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType
  association [0..1] to I_FinancialAccountType         as _FinancialAccountType          on  $projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType
  association [0..1] to I_DebitCreditCode              as _DebitCreditCode               on  $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode

  association [0..1] to I_Product                      as _Product                       on  $projection.Product = _Product.Product
  association [0..1] to I_Plant                        as _Plant                         on  $projection.Plant = _Plant.Plant

  association [1..1] to I_Ledger                       as _Ledger                        on  $projection.SourceLedger = _Ledger.Ledger

  association [0..1] to I_Customer                     as _Customer                      on  $projection.Customer = _Customer.Customer
  association [0..1] to I_CustomerCompany              as _CustomerCompany               on  $projection.Customer    = _CustomerCompany.Customer
                                                                                         and $projection.CompanyCode = _CustomerCompany.CompanyCode   
  association [0..1] to I_CustomerGroup                as _CustomerGroup                 on  $projection.CustomerGroup = _CustomerGroup.CustomerGroup

  association [0..1] to I_Supplier                     as _Supplier                      on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_SupplierCompany              as _SupplierCompany               on  $projection.Supplier    = _SupplierCompany.Supplier
                                                                                         and $projection.CompanyCode = _SupplierCompany.CompanyCode 

  association [0..1] to I_ProductGroup                 as _ProductGroup                  on  $projection.ProductGroup = _ProductGroup.MaterialGroup
  association [0..1] to I_ProductGroup_2               as _ProductGroup_2                on  $projection.ProductGroup = _ProductGroup_2.ProductGroup
  association [0..1] to I_ProductGroup                 as _SoldProductGroup              on  $projection.SoldProductGroup = _SoldProductGroup.MaterialGroup
  association [0..1] to I_ProductGroup_2               as _SoldProductGroup_2            on  $projection.SoldProductGroup = _SoldProductGroup_2.ProductGroup

  //  association [0..1] to I_SalesOrder                   as _SalesOrder                    on  $projection.SalesOrder = _SalesOrder.SalesOrder

  //  association [0..1] to I_SalesOrderItem               as _SalesOrderItem                on  $projection.SalesOrder     = _SalesOrderItem.SalesOrder

  //                                                                                         and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem

  association [0..1] to I_SalesDocument                as _SalesDocument                 on  $projection.SalesDocument = _SalesDocument.SalesDocument
  association [0..1] to I_SalesDocumentItem            as _SalesDocumentItem             on  $projection.SalesDocument     = _SalesDocumentItem.SalesDocument
                                                                                         and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem

  association [0..1] to I_Order                        as _Order                         on  $projection.OrderID = _Order.OrderID
  association [0..1] to I_Order                        as _OriginOrder                   on  $projection.OriginOrder  = _OriginOrder.OrderID
  association [0..*] to I_CostAnalysisResource         as _CostAnalysisResource          on  $projection.ControllingArea      = _CostAnalysisResource.ControllingArea
                                                                                         and $projection.CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource

  association [0..1] to I_FinancialTransactionType     as _FinancialTransactionType      on  $projection.FinancialTransactionType = _FinancialTransactionType.FinancialTransactionType
  
  association [0..1] to I_BusinessTransactionCategory  as _BusinessTransactionCategory   on  $projection.BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory  
  association [0..1] to I_BusinessTransactionType      as _BusinessTransactionType       on  $projection.BusinessTransactionType     = _BusinessTransactionType.BusinessTransactionType
  //  association [0..1] to I_ControllingBusTransacType    as _ControllingBusTransacType     on  $projection.ControllingBusTransacType = _ControllingBusTransacType.BusinessTransactionType


  association [0..1] to I_ReferenceDocumentType        as _ReferenceDocumentType         on  $projection.ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType
  association [0..1] to I_ReferenceDocumentType        as _PredecessorReferenceDocType   on  $projection.PredecessorReferenceDocType = _PredecessorReferenceDocType.ReferenceDocumentType
  association [0..*] to I_CostCenter                   as _PartnerCostCenter             on  $projection.ControllingArea   = _PartnerCostCenter.ControllingArea
                                                                                         and $projection.PartnerCostCenter = _PartnerCostCenter.CostCenter
  association [0..*] to I_ProfitCenter                 as _PartnerProfitCenter           on  $projection.ControllingArea     = _PartnerProfitCenter.ControllingArea
                                                                                         and $projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter
  association [0..1] to I_BusinessArea                 as _PartnerBusinessArea           on  $projection.PartnerBusinessArea = _PartnerBusinessArea.BusinessArea
  association [0..1] to I_FunctionalArea               as _PartnerFunctionalArea         on  $projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea
  association [0..1] to I_CompanyCode                  as _PartnerCompanyCode            on  $projection.PartnerCompanyCode = _PartnerCompanyCode.CompanyCode
  association [0..1] to I_Segment                      as _PartnerSegment                on  $projection.PartnerSegment = _PartnerSegment.Segment

  association [0..1] to I_AccountingDocumentCategory   as _AccountingDocumentCategory    on  $projection.AccountingDocumentCategory = _AccountingDocumentCategory.AccountingDocumentCategory

  association [0..1] to I_PostingKey                   as _PostingKey                    on  $projection.PostingKey = _PostingKey.PostingKey

  association [0..1] to I_SubLedgerAccLineItemType     as _SubLedgerAccLineItemType      on  $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType
  association [0..1] to I_User                         as _User                          on  $projection.AccountingDocCreatedByUser = _User.UserID

  association [0..*] to I_ProfitCenter                 as _EliminationProfitCenter       on  $projection.ControllingArea         = _EliminationProfitCenter.ControllingArea
                                                                                         and $projection.EliminationProfitCenter = _EliminationProfitCenter.ProfitCenter

  association [0..1] to I_GLAccountType                as _GLAccountType                 on  $projection.GLAccountType = _GLAccountType.GLAccountType
  association [0..1] to I_FinancialAccountType         as _OffsettingAccountType         on  $projection.OffsettingAccountType = _OffsettingAccountType.FinancialAccountType
  association [0..1] to I_GLAccountInChartOfAccounts   as _AlternativeGLAccount          on  $projection.CountryChartOfAccounts = _AlternativeGLAccount.ChartOfAccounts
                                                                                         and $projection.AlternativeGLAccount   = _AlternativeGLAccount.GLAccount

  association [0..1] to I_OffsettingAccount            as _OffsettingAccount             on  $projection.OffsettingChartOfAccounts = _OffsettingAccount.ChartOfAccounts
                                                                                         and $projection.OffsettingAccountType     = _OffsettingAccount.OffsettingAccountType
                                                                                         and $projection.OffsettingAccount         = _OffsettingAccount.OffsettingAccount

  association [0..1] to I_ChartOfAccounts              as _OffsettingChartOfAccounts     on  $projection.OffsettingChartOfAccounts = _OffsettingChartOfAccounts.ChartOfAccounts
  association [0..1] to I_ChartOfAccounts              as _CountryChartOfAccounts        on  $projection.CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts

//  association [0..1] to I_PurchasingDocument           as _PurchasingDocument            on  $projection.PurchasingDocument = _PurchasingDocument.PurchasingDocument

//  association [0..1] to I_PurchasingDocumentItem       as _PurchasingDocumentItem        on  $projection.PurchasingDocument     = _PurchasingDocumentItem.PurchasingDocument

//                                                                                           and $projection.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem

  association [0..1] to I_SpecialGLCode                as _SpecialGLCode                 on  $projection.SpecialGLCode        = _SpecialGLCode.SpecialGLCode
                                                                                         and $projection.FinancialAccountType = _SpecialGLCode.FinancialAccountType
  association [0..*] to I_TaxCode                      as _TaxCode                       on  $projection.TaxCode = _TaxCode.TaxCode
  //above solution for association to I_TaxCode not supported. TaxCalculationProcedure required as additional key field to make TaxCode unique

  //association[0..1] to I_TaxCode                      as _TaxCode                       on $projection.TaxCode = _TaxCode.TaxCode and

  //                                                                                         $projection._Company_Country.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure

  association [0..1] to I_Country                      as _TaxCountry                    on  $projection.TaxCountry = _TaxCountry.Country
  //  association [0..1] to I_Housebank                    as _HouseBank                     on  $projection.CompanyCode = _HouseBank.CompanyCode

  //                                                                                         and $projection.HouseBank   = _HouseBank.HouseBank

                                                                                         
// the following association is wrong and will be deprecated

  association [1..1] to I_AccountingDocument           as _ClearingAccountingDocument    on  $projection.CompanyCode                = _ClearingAccountingDocument.CompanyCode
                                                                                         and $projection.FiscalYear                 = _ClearingAccountingDocument.FiscalYear
                                                                                         and $projection.ClearingAccountingDocument = _ClearingAccountingDocument.AccountingDocument
                                                                                         
  association [0..1] to I_FiscalYearForCompanyCode     as _ClearingJrnlEntryFiscalYear    on $projection.ClearingJournalEntryFiscalYear = _ClearingJrnlEntryFiscalYear.FiscalYear
                                                                                         and $projection.CompanyCode                    = _ClearingJrnlEntryFiscalYear.CompanyCode
  association [0..1] to I_JournalEntry                 as _ClearingJournalEntry          on  $projection.CompanyCode                    = _ClearingJournalEntry.CompanyCode
                                                                                         and $projection.ClearingJournalEntryFiscalYear = _ClearingJournalEntry.FiscalYear
                                                                                         and $projection.ClearingJournalEntry           = _ClearingJournalEntry.AccountingDocument                                                                                         
                                                                                         
  association [0..1] to I_MasterFixedAsset             as _MasterFixedAsset              on  $projection.CompanyCode                = _MasterFixedAsset.CompanyCode
                                                                                         and $projection.MasterFixedAsset           = _MasterFixedAsset.MasterFixedAsset
  association [0..1] to I_MasterFixedAsset             as _GroupMasterFixedAsset         on  $projection.CompanyCode                = _GroupMasterFixedAsset.CompanyCode
                                                                                         and $projection.GroupMasterFixedAsset      = _GroupMasterFixedAsset.MasterFixedAsset
  association [0..1] to I_MasterFixedAsset             as _PartnerMasterFixedAsset       on  $projection.CompanyCode                = _PartnerMasterFixedAsset.CompanyCode
                                                                                         and $projection.PartnerMasterFixedAsset    = _PartnerMasterFixedAsset.MasterFixedAsset
  association [0..1] to I_FixedAsset                   as _FixedAsset                    on  $projection.CompanyCode                = _FixedAsset.CompanyCode
                                                                                         and $projection.MasterFixedAsset           = _FixedAsset.MasterFixedAsset
                                                                                         and $projection.FixedAsset                 = _FixedAsset.FixedAsset
  association [0..1] to I_FixedAsset                   as _GroupFixedAsset               on  $projection.CompanyCode                = _GroupFixedAsset.CompanyCode
                                                                                         and $projection.GroupMasterFixedAsset      = _GroupFixedAsset.MasterFixedAsset
                                                                                         and $projection.GroupFixedAsset            = _GroupFixedAsset.FixedAsset
  association [0..1] to I_FixedAsset                   as _PartnerFixedAsset             on  $projection.CompanyCode                = _PartnerFixedAsset.CompanyCode
                                                                                         and $projection.PartnerMasterFixedAsset    = _PartnerFixedAsset.MasterFixedAsset
                                                                                         and $projection.PartnerFixedAsset          = _PartnerFixedAsset.FixedAsset

  association [0..1] to I_BusinessProcess              as _BusinessProcess               on  $projection.ControllingArea = _BusinessProcess.ControllingArea
                                                                                         and $projection.BusinessProcess = _BusinessProcess.BusinessProcess

  association [0..*] to I_CostCenterActivityType       as _PartnerCostCtrActivityType    on  $projection.ControllingArea            = _PartnerCostCtrActivityType.ControllingArea
                                                                                         and $projection.PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType
  association [0..1] to I_InternalOrder                as _PartnerOrder                  on  $projection.PartnerOrder    = _PartnerOrder.InternalOrder

  association [0..1] to I_OrderCategory                as _PartnerOrderCategory          on  $projection.PartnerOrderCategory = _PartnerOrderCategory.OrderCategory
  association [0..1] to I_SalesDocument                as _PartnerSalesDocument          on  $projection.PartnerSalesDocument = _PartnerSalesDocument.SalesDocument
  association [0..1] to I_SalesDocumentItem            as _PartnerSalesDocumentItem      on  $projection.PartnerSalesDocument     = _PartnerSalesDocumentItem.SalesDocument
                                                                                         and $projection.PartnerSalesDocumentItem = _PartnerSalesDocumentItem.SalesDocumentItem
  association [0..1] to I_BusinessProcess              as _PartnerBusinessProcess        on  $projection.ControllingArea        = _PartnerBusinessProcess.ControllingArea
                                                                                         and $projection.PartnerBusinessProcess = _PartnerBusinessProcess.BusinessProcess
  association [0..1] to I_BillingDocumentType          as _BillingDocumentType           on  $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType

  association [0..1] to I_SalesOrganization            as _SalesOrganization             on  $projection.SalesOrganization = _SalesOrganization.SalesOrganization
  association [0..1] to I_DistributionChannel          as _DistributionChannel           on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel

  association [0..1] to I_Product                      as _SoldProduct                   on  $projection.SoldProduct = _SoldProduct.Product
  
  association [0..1] to I_Product                      as _OriginProduct                 on  $projection.OriginProduct = _OriginProduct.Product

  association [0..1] to I_InventoryValuationType       as _InventorySpecialStockValnType on  $projection.InventorySpecialStockValnType = _InventorySpecialStockValnType.InventoryValuationType
  association [0..1] to I_InvtrySpecialStockValnType   as _InventorySpclStockValnType    on  $projection.InventorySpecialStockValnType = _InventorySpclStockValnType.InventorySpecialStockValnType
  association [0..1] to I_InventorySpecialStockType    as _InventorySpecialStockType     on  $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType

  association [0..1] to I_SalesDocument                as _InventorySpclStkSalesDocument on  $projection.InventorySpclStkSalesDocument = _InventorySpclStkSalesDocument.SalesDocument

  association [0..1] to I_SalesDocumentItem            as _InventorySpclStkSalesDocItm   on  $projection.InventorySpclStkSalesDocument = _InventorySpclStkSalesDocItm.SalesDocument
                                                                                         and $projection.InventorySpclStkSalesDocItm   = _InventorySpclStkSalesDocItm.SalesDocumentItem

  association [0..1] to I_WBSElementBasicData          as _InvtrySpclStockWBSElmntBasic  on  $projection.InvtrySpclStockWBSElmntIntID = _InvtrySpclStockWBSElmntBasic.WBSElementInternalID  // do not use

  association [0..1] to I_WBSElementBasicData          as _InvtrySpclStkWBSElmntBscData  on  $projection.InvtrySpclStockWBSElmntIntID = _InvtrySpclStkWBSElmntBscData.WBSElementInternalID

  association [0..1] to I_Supplier                     as _InventorySpecialStockSupplier on  $projection.InventorySpecialStockSupplier = _InventorySpecialStockSupplier.Supplier
  association [0..1] to I_Supplier                     as _InvtrySpclStockSupplierText   on  $projection.InventorySpecialStockSupplier = _InvtrySpclStockSupplierText.Supplier

  association [0..1] to I_InventoryValuationType       as _InventoryValuationType        on  $projection.InventoryValuationType = _InventoryValuationType.InventoryValuationType

  association [0..1] to I_ControllingDebitCreditCode   as _ControllingDebitCreditCode    on  $projection.ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode
  association [0..1] to I_ControllingDebitCreditCode   as _OriginCtrlgDebitCreditCode    on  $projection.OriginCtrlgDebitCreditCode = _OriginCtrlgDebitCreditCode.ControllingDebitCreditCode
  association [0..1] to I_ControllingObject            as _OriginSenderObject            on  $projection.OriginSenderObject = _OriginSenderObject.ControllingObject

  association [0..1] to I_ControllingObjectClass       as _ControllingObjectClass        on  $projection.ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass

  association [0..1] to I_Partnercompany               as _PartnerCompany                on  $projection.PartnerCompany = _PartnerCompany.PartnerCompany

  association [0..1] to I_ControllingObjectClass       as _PartnerControllingObjectClass on  $projection.PartnerControllingObjectClass = _PartnerControllingObjectClass.ControllingObjectClass

  association [0..*] to I_CostCenter                   as _OriginCostCenter              on  $projection.ControllingArea  = _OriginCostCenter.ControllingArea
                                                                                         and $projection.OriginCostCenter = _OriginCostCenter.CostCenter

  association [0..*] to I_ProfitCenter                 as _OriginProfitCenter            on  $projection.ControllingArea    = _OriginProfitCenter.ControllingArea
                                                                                         and $projection.OriginProfitCenter = _OriginProfitCenter.ProfitCenter
  association [0..*] to I_CostCenterActivityType       as _CostCtrActivityType           on  $projection.ControllingArea     = _CostCtrActivityType.ControllingArea
                                                                                         and $projection.CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType

  association [0..*] to I_CostCenterActivityType       as _OriginCostCtrActivityType     on  $projection.ControllingArea           = _OriginCostCtrActivityType.ControllingArea
                                                                                         and $projection.OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType

  association [0..1] to I_OrderCategory                as _OrderCategory                 on  $projection.OrderCategory = _OrderCategory.OrderCategory

    association [0..1] to I_MovementCategory             as _MovementCategory              on  $projection.AssetAcctTransClassfctn = _MovementCategory.AssetAcctTransClassfctn
    association [0..1] to I_AssetTransactionType         as _AssetTransactionType          on  $projection.AssetTransactionType = _AssetTransactionType.AssetTransactionType

  association [0..*] to I_CostOriginGroup              as _CostOriginGroup               on  $projection.ControllingArea = _CostOriginGroup.ControllingArea
                                                                                         and $projection.CostOriginGroup = _CostOriginGroup.CostOriginGroup
  association [0..1] to I_Country                      as _CustomerSupplierCountry       on  $projection.CustomerSupplierCountry = _CustomerSupplierCountry.Country
  association [0..1] to I_SalesDistrict                as _SalesDistrict                 on  $projection.SalesDistrict = _SalesDistrict.SalesDistrict
  association [0..1] to I_Customer                     as _BillToParty                   on  $projection.BillToParty = _BillToParty.Customer
  association [0..1] to I_Customer                     as _ShipToParty                   on  $projection.ShipToParty = _ShipToParty.Customer

  //  association [0..1] to I_HouseBankAccount             as _HouseBankAccount              on  $projection.CompanyCode      = _HouseBankAccount.CompanyCode

  //                                                                                         and $projection.HouseBank        = _HouseBankAccount.HouseBank

  //                                                                                         and $projection.HouseBankAccount = _HouseBankAccount.HouseBankAccount

  //  association [0..1] to I_LogicalSystem                as _LogicalSystem                 on  $projection.LogicalSystem = _LogicalSystem.LogicalSystem

  association [0..1] to I_OperatingConcern             as _OperatingConcern              on  $projection.OperatingConcern = _OperatingConcern.OperatingConcern
  //  association [0..1] to I_ProjectNetwork               as _ProjectNetwork                on  $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork

  association [0..1] to I_ValuationArea                as _ValuationArea                 on  $projection.ValuationArea = _ValuationArea.ValuationArea
  association [0..1] to I_WorkCenter                   as _WorkCenter                    on  $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                                                         and _WorkCenter.WorkCenterTypeCode   = 'A'

  association [0..1] to I_BillableControl              as _BillableControl               on  $projection.BillableControl     = _BillableControl.BillableControl

  association [0..1] to I_ConditionContract            as _ConditionContract             on  $projection.ConditionContract = _ConditionContract.ConditionContract

  association [0..1] to I_MaintenanceOrder             as _MaintenanceOrder              on  $projection.OrderID       = _MaintenanceOrder.MaintenanceOrder
                                                                                         and $projection.OrderCategory = '30'
  association [0..1] to I_MaintenanceOrderOperation    as _MaintenanceOrderOperation     on  $projection.OrderID        = _MaintenanceOrderOperation.MaintenanceOrder
                                                                                         and $projection.OrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation
                                                                                         and $projection.OrderCategory  = '30'
  association [0..1] to I_MaintenanceOrderSubOperation as _MaintenanceOrderSubOperation  on  $projection.OrderID           = _MaintenanceOrderSubOperation.MaintenanceOrder
                                                                                         and $projection.OrderOperation    = _MaintenanceOrderSubOperation.MaintenanceOrderOperation
                                                                                         and $projection.OrderSuboperation = _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation

  association [0..1] to I_Equipment                    as _Equipment                     on  $projection.Equipment = _Equipment.Equipment

  association [0..1] to I_FunctionalLocation           as _FunctionalLocation            on  $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
  association [0..1] to I_Product                      as _Assembly                      on  $projection.Assembly = _Assembly.Product
  association [0..1] to I_MaintenanceActivityType      as _MaintenanceActivityType       on  $projection.MaintenanceActivityType = _MaintenanceActivityType.MaintenanceActivityType
  //  association [0..1] to I_MaintOrdPlngDegreeCode      as _MaintOrdPlngDegreeCode       on  $projection.MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode

  //  association [0..1] to I_PMNotificationPriorityType  as _PMNotificationPriorityType   on  $projection.MaintPriorityType            = _PMNotificationPriorityType.MaintPriorityType

  //  association [0..1] to I_PMNotificationPriority      as _PMNotificationPriority       on  $projection.MaintPriority                = _PMNotificationPriority.MaintPriority

  //                                                                                       and $projection.MaintPriorityType            = _PMNotificationPriority.MaintPriorityType


  //  association [0..1] to I_Order                        as _SuperiorOrder                 on  $projection.SuperiorOrder                = _Order.OrderID

  association [0..1] to I_WorkPackage                  as _WorkPackage                   on  $projection.WorkPackage = _WorkPackage.WorkPackage
  association [0..1] to I_WorkPackageWorkItem          as _WorkPackageWorkItem           on  $projection.WorkItem    = _WorkPackageWorkItem.WorkItem
                                                                                         and $projection.WorkPackage = _WorkPackageWorkItem.WorkPackage
  association [0..1] to I_TimeSheetOvertimeCat         as _TimeSheetOvertimeCat          on  $projection.TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory
  association [0..1] to I_ServiceDocumentType          as _ServiceDocumentType           on  $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType

  association [0..1] to I_SrvcDocByDocumentType        as _ServiceDocument               on  $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType
                                                                                         and $projection.ServiceDocument     = _ServiceDocument.ServiceDocument

  association [0..1] to I_SrvcDocItemByDocumentType    as _ServiceDocumentItem           on  $projection.ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType
                                                                                         and $projection.ServiceDocument     = _ServiceDocumentItem.ServiceDocument
                                                                                         and $projection.ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem

  association [0..1] to I_ServiceDocumentType          as _ServiceContractType           on  $projection.ServiceContractType = _ServiceContractType.ServiceDocumentType

  association [0..1] to I_SrvcDocByDocumentType        as _ServiceContract               on  $projection.ServiceContractType = _ServiceContract.ServiceDocumentType
                                                                                         and $projection.ServiceContract     = _ServiceContract.ServiceDocument

  association [0..1] to I_SrvcDocItemByDocumentType    as _ServiceContractItem           on  $projection.ServiceContractType = _ServiceContractItem.ServiceDocumentType
                                                                                         and $projection.ServiceContract     = _ServiceContractItem.ServiceDocument
                                                                                         and $projection.ServiceContractItem = _ServiceContractItem.ServiceDocumentItem

  association [0..1] to I_ServiceDocumentType          as _PartnerServiceDocumentType    on  $projection.PartnerServiceDocumentType = _PartnerServiceDocumentType.ServiceDocumentType

  association [0..1] to I_SrvcDocByDocumentType        as _PartnerServiceDocument        on  $projection.PartnerServiceDocumentType = _PartnerServiceDocument.ServiceDocumentType
                                                                                         and $projection.PartnerServiceDocument     = _PartnerServiceDocument.ServiceDocument

  association [0..1] to I_SrvcDocItemByDocumentType    as _PartnerServiceDocumentItem    on  $projection.PartnerServiceDocumentType = _PartnerServiceDocumentItem.ServiceDocumentType
                                                                                         and $projection.PartnerServiceDocument     = _PartnerServiceDocumentItem.ServiceDocument
                                                                                         and $projection.PartnerServiceDocumentItem = _PartnerServiceDocumentItem.ServiceDocumentItem
  association [0..1] to I_ProjectBasicData             as _ProjectBasicData              on  $projection.ProjectInternalID = _ProjectBasicData.ProjectInternalID
  association [0..1] to I_WBSElementBasicData          as _WBSElementBasicData           on  $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
  association [0..1] to I_ProjectBasicData             as _PartnerProjectBasicData       on  $projection.PartnerProjectInternalID = _PartnerProjectBasicData.ProjectInternalID
  association [0..1] to I_WBSElementBasicData          as _PartnerWBSElementBasicData    on  $projection.PartnerWBSElementInternalID = _PartnerWBSElementBasicData.WBSElementInternalID

  association [0..1] to I_AccrualObjectType            as _AccrualObjectType             on  $projection.AccrualObjectType = _AccrualObjectType.AccrualObjectType

  association [0..1] to I_AccrualObject                as _AccrualObject                 on  $projection.AccrualObjectType = _AccrualObject.AccrualObjectType
                                                                                         and _AccrualObject.AccrualObjectLogicalSystem  = ''
                                                                                         and $projection.CompanyCode       = _AccrualObject.CompanyCode
                                                                                         and $projection.AccrualObject     = _AccrualObject.AccrualObject


  association [0..1] to I_AccrualSubObject             as _AccrualSubobject              on  $projection.AccrualObjectType = _AccrualSubobject.AccrualObjectType
                                                                                         and _AccrualSubobject.AccrualObjectLogicalSystem  = ''
                                                                                         and $projection.CompanyCode       = _AccrualSubobject.CompanyCode
                                                                                         and $projection.AccrualObject     = _AccrualSubobject.AccrualObject
                                                                                         and $projection.AccrualSubobject  = _AccrualSubobject.AccrualSubobject

  association [0..1] to I_AccrualItemType              as _AccrualItemType               on  $projection.AccrualObjectType = _AccrualItemType.AccrualObjectType
                                                                                         and $projection.AccrualItemType   = _AccrualItemType.AccrualItemType

  association [0..1] to I_CreditRiskClass              as _CreditRiskClass               on  $projection.CreditRiskClass = _CreditRiskClass.CreditRiskClass

  association [0..1] to I_FinValuationObjectType       as _FinValuationObjectType        on  $projection.FinancialValuationObjectType = _FinValuationObjectType.FinancialValuationObjectType

  association [0..*] to I_SemTagGLAccount              as _SemTagGLAccount               on  $projection.GLAccount       = _SemTagGLAccount.GLAccount
                                                                                         and $projection.ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts

  // Public Sector (start)

  association [0..1] to I_CompanyCode                  as _CashLedgerCompanyCode         on  $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode

  //  association [0..1] to I_GLAccount                  as _CashLedgerAccount        on  $projection.CashLedgerCompanyCode   = _CashLedgerAccount.CompanyCode

  //                                                                                  and $projection.CashLedgerAccount       = _CashLedgerAccount.GLAccount


  association [0..1] to I_GLAccountInCompanyCode       as _CashLedgerAccount             on  $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode
                                                                                         and $projection.CashLedgerAccount     = _CashLedgerAccount.GLAccount

  association [0..1] to I_FinancialManagementArea      as _FinancialManagementArea       on  $projection.FinancialManagementArea = _FinancialManagementArea.FinancialManagementArea

  association [0..*] to I_FundsCenter                  as _FundsCenter                   on  $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea
                                                                                         and $projection.FundsCenter             = _FundsCenter.FundsCenter

  association [0..1] to I_FundedProgram                as _FundedProgram                 on  $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea
                                                                                         and $projection.FundedProgram           = _FundedProgram.FundedProgram

  association [0..1] to I_Fund                         as _Fund                          on  $projection.FinancialManagementArea = _Fund.FinancialManagementArea
                                                                                         and $projection.Fund                    = _Fund.Fund

  association [0..1] to I_Grant                        as _Grant                         on  $projection.GrantID                 = _Grant.GrantID

  association [0..1] to I_BudgetPeriod                 as _BudgetPeriod                  on  $projection.BudgetPeriod = _BudgetPeriod.BudgetPeriod

  association [0..1] to I_Fund                         as _PartnerFund                   on  $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea
                                                                                         and $projection.PartnerFund             = _PartnerFund.Fund

  association [0..1] to I_Grant                        as _PartnerGrant                  on  $projection.PartnerGrant            = _PartnerGrant.GrantID

  association [0..1] to I_BudgetPeriod                 as _PartnerBudgetPeriod           on  $projection.PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod

  association [0..1] to I_CompanyCode                  as _PubSecBudgetAccountCoCode     on  $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode

  association [0..1] to I_PubSecBudgetAccount          as _PubSecBudgetAccount           on  $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode
                                                                                         and $projection.PubSecBudgetAccount       = _PubSecBudgetAccount.PubSecBudgetAccount
                                                                                         
// not C1 released                                                                                         

  association [0..1] to I_SponsoredProgramCore         as _SponsoredProgram           on  $projection.SponsoredProgram             = _SponsoredProgram.SponsoredProgram  
  association [0..1] to I_SponsoredClassCore           as _SponsoredClass             on  $projection.SponsoredClass               = _SponsoredClass.SponsoredClass                                                                                           

  association [0..1] to I_FiscCalendarDateForCompCode  as _PubSecBudgetCnsmpnDate        on  $projection.PubSecBudgetCnsmpnDate    = _PubSecBudgetCnsmpnDate.CalendarDate
                                                                                         and $projection.PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnDate.CompanyCode

  association [0..1] to I_FiscalYearPeriodForCmpnyCode as _PubSecBudgetCnsmpnFsclPeriod  on  $projection.PubSecBudgetAccountCoCode    = _PubSecBudgetCnsmpnFsclPeriod.CompanyCode
                                                                                         and $projection.PubSecBudgetCnsmpnFsclYear   = _PubSecBudgetCnsmpnFsclPeriod.FiscalYear
                                                                                         and $projection.PubSecBudgetCnsmpnFsclPeriod = _PubSecBudgetCnsmpnFsclPeriod.FiscalPeriod

  association [0..1] to I_FiscalYearForCompanyCode     as _PubSecBudgetCnsmpnFsclYear    on  $projection.PubSecBudgetAccountCoCode  = _PubSecBudgetCnsmpnFsclYear.CompanyCode
                                                                                         and $projection.PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclYear.FiscalYear

  association [0..1] to I_PubSecBdgtCnsmpnType         as _PubSecBudgetCnsmpnType        on  $projection.PubSecBudgetCnsmpnType = _PubSecBudgetCnsmpnType.PubSecBudgetCnsmpnType

  association [0..1] to I_PubSecBdgtCnsmpnAmtType      as _PubSecBudgetCnsmpnAmtType     on  $projection.PubSecBudgetCnsmpnAmtType = _PubSecBudgetCnsmpnAmtType.PubSecBudgetCnsmpnAmtType

  // Public Sector (end)

  
  association [0..1] to I_CnsldtnUnit_3             as _ConsolidationUnit                on  $projection.ConsolidationUnit             = _ConsolidationUnit.ConsolidationUnit      
  association [0..1] to I_CnsldtnUnit_3             as _PartnerConsolidationUnit         on  $projection.PartnerConsolidationUnit      = _PartnerConsolidationUnit.ConsolidationUnit
  association [0..1] to I_Globalcompany             as _Company                          on  $projection.Company                       = _Company.Company
  association [0..1] to I_CnsldtnChartOfAccounts    as _ConsolidationChartOfAccounts     on  $projection.ConsolidationChartOfAccounts  = _ConsolidationChartOfAccounts.ConsolidationChartOfAccounts
  association [0..1] to I_CnsldtnFinStmntItem       as _CnsldtnFinancialStatementItem    on  $projection.ConsolidationChartOfAccounts  = _CnsldtnFinancialStatementItem.ConsolidationChartOfAccounts
                                                                                         and $projection.CnsldtnFinancialStatementItem = _CnsldtnFinancialStatementItem.FinancialStatementItem
  association [0..1] to I_CnsldtnSubItemCategory    as _CnsldtnSubitemCategory           on  $projection.CnsldtnSubitemCategory        = _CnsldtnSubitemCategory.SubItemCategory
  association [0..1] to I_CnsldtnSubItem            as _CnsldtnSubitem                   on  $projection.CnsldtnSubitemCategory        = _CnsldtnSubitem.SubItemCategory
                                                                                         and $projection.CnsldtnSubitem                = _CnsldtnSubitem.SubItem  

  association [0..1]  to I_ProviderContract         as _ProviderContract                 on  $projection.ProviderContract     = _ProviderContract.ProviderContract
  association [0..1]  to I_ProviderContractItem     as _ProviderContractItem             on  $projection.ProviderContract     = _ProviderContractItem.ProviderContract
                                                                                         and $projection.ProviderContractItem = _ProviderContractItem.ProviderContractItem
                                                                                         
  association [0..1]  to I_AccountAssignmentType    as _AccountAssignmentType            on  $projection.AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType                                                                                    
                                                                                         
  association [0..1]  to I_JrnlEntryItemObsoleteRsn as _JrnlEntryItemObsoleteRsn         on  $projection.JrnlEntryItemObsoleteReason     = _JrnlEntryItemObsoleteRsn.JrnlEntryItemObsoleteReason
  
  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 rldnr                                                                                            as SourceLedger,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key rbukrs                                                                                           as CompanyCode,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key gjahr                                                                                            as FiscalYear,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key belnr                                                                                            as AccountingDocument,
  key docln                                                                                            as LedgerGLLineItem,

      @ObjectModel.foreignKey.association: '_LedgerFiscalYearForVariant'
      @Semantics.fiscal.year: true
      ryear                                                                                            as LedgerFiscalYear,
      rrcty                                                                                            as GLRecordType,
      DOCNR_LD as JrnlEntrAltvFYConsecutiveID,

      // Test workaround

      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      ktopl                                                                                            as ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      kokrs                                                                                            as ControllingArea,

      ///////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_00  Unified Journal Entry: Transaction, Currencies, Units

      ///////////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_FinancialTransactionType'
      rmvct                                                                                            as FinancialTransactionType,
      vorgn                                                                                            as GLBusinessTransactionType,
@ObjectModel.foreignKey.association: '_BusinessTransactionCategory'
bttype as BusinessTransactionCategory, 
@ObjectModel.foreignKey.association: '_BusinessTransactionType'
cbttype as BusinessTransactionType, 
closingstep as FinancialClosingStep,     
      vrgng                                                                                            as ControllingBusTransacType,
      @ObjectModel.foreignKey.association: '_ReferenceDocumentType'
      awtyp                                                                                            as ReferenceDocumentType,
      //      @ObjectModel.foreignKey.association: '_LogicalSystem'

      awsys                                                                                            as LogicalSystem,
      aworg                                                                                            as ReferenceDocumentContext,
      awref                                                                                            as ReferenceDocument,      
      cast( awitem as fis_awitem preserving type ) as ReferenceDocumentItem,      
      cast( awitgrp as fis_awitgrp preserving type ) as ReferenceDocumentItemGroup,
      subta     as TransactionSubitem,
      ACCTG_NOTIF_UUID as AccountingNotificationUUID,
      P_ACDOCA.offstg_docln as OffsettingLedgerGLLineItem,
      xreversing                                                                                       as IsReversal,
      xreversed                                                                                        as IsReversed,
      //XTRUEREV,

      awtyp_rev as ReversalReferenceDocumentType,      
      cast( aworg_rev as fis_aworg_rev preserving type ) as ReversalReferenceDocumentCntxt,      
      cast( awref_rev as fis_awref_rev preserving type ) as ReversalReferenceDocument,
      subta_rev                                                                                        as ReversalTransactionSubitem,
      xsettling                                                                                        as IsSettlement,
      xsettled                                                                                         as IsSettled,
      cast( prec_awtyp as fis_prec_awtyp preserving type ) as PredecessorReferenceDocType,
      cast( prec_aworg as fis_prec_aworg preserving type ) as PredecessorReferenceDocCntxt,      
      cast( prec_awref as fis_prec_awref preserving type ) as PredecessorReferenceDocument,
      cast( prec_awitem as fis_prec_awitem preserving type ) as PredecessorReferenceDocItem,
      //PREC_SUBTA,

      cast( prec_bukrs as  fins_prec_bukrs_gfc preserving type )                                       as PrdcssrJournalEntryCompanyCode,
      prec_gjahr as PrdcssrJournalEntryFiscalYear,
      cast( prec_belnr as  fins_prec_belnr_gfc preserving type )                                       as PredecessorJournalEntry,
      cast( prec_docln as  fins_prec_docln_gfc preserving type )                                       as PredecessorJournalEntryItem,

      cast( src_awtyp as fis_src_awtyp preserving type ) as SourceReferenceDocumentType,
      cast( src_awsys as fis_src_awsys preserving type ) as SourceLogicalSystem,
      cast( src_aworg as fis_src_aworg preserving type ) as SourceReferenceDocumentCntxt,
      cast( src_awref as fis_src_awref preserving type ) as SourceReferenceDocument,
      cast( src_awitem as fis_src_awitem preserving type ) as SourceReferenceDocumentItem,
      cast( src_awsubit as fis_src_awsubit preserving type ) as SourceReferenceDocSubitem,
      cast( xcommitment as fis_xcommitment preserving type ) as IsCommitment,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_JrnlEntryItemObsoleteRsn'      
      obs_reason                                                                                       as JrnlEntryItemObsoleteReason,
      XSECONDARY as JournalEntryIsSecondaryEntry,
      closing_run_id                                                                                   as JrnlPeriodEndClosingRunLogUUID,
      orgl_change as OrganizationalChange,

      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      racct                                                                                            as GLAccount,


      ////////////////////////////////////////////////////////////////////////////////////

      // .INCLUDE  ACDOC_SI_GL_ACCAS Unified Journal Entry: G/L additional account assignments

      ////////////////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_CostCenter'
      rcntr                                                                                            as CostCenter,
      @ObjectModel.foreignKey.association: '_ProfitCenter'
      prctr                                                                                            as ProfitCenter,
      @ObjectModel.foreignKey.association: '_FunctionalArea'
      rfarea                                                                                           as FunctionalArea,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      rbusa                                                                                            as BusinessArea,
      @ObjectModel.foreignKey.association: '_Segment'
      segment                                                                                          as Segment,
      @ObjectModel.foreignKey.association: '_PartnerCostCenter'
      scntr                                                                                            as PartnerCostCenter,
      @ObjectModel.foreignKey.association: '_PartnerProfitCenter'
      pprctr                                                                                           as PartnerProfitCenter,
      @ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
      sfarea                                                                                           as PartnerFunctionalArea,
      @ObjectModel.foreignKey.association: '_PartnerBusinessArea'
      sbusa                                                                                            as PartnerBusinessArea,
      @ObjectModel.foreignKey.association: '_PartnerCompany'
      rassc                                                                                            as PartnerCompany,
      psegment                                                                                         as PartnerSegment,


      /////////////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_VALUE_DATA Unified Journal Entry: Value Fields

      /////////////////////////////////////////////////////////////////////////////////////


      @ObjectModel.foreignKey.association: '_BalanceTransactionCurrency'
      @Semantics.currencyCode:true
      rtcur                                                                                            as BalanceTransactionCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      tsl                                                                                              as AmountInBalanceTransacCrcy,

      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      @Semantics.currencyCode:true
      rwcur                                                                                            as TransactionCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      wsl                                                                                              as AmountInTransactionCurrency,

      @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
      @Semantics.currencyCode:true
      rhcur                                                                                            as CompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      hsl                                                                                              as AmountInCompanyCodeCurrency,

      ////////////////////////////////////

      // NEW

      @ObjectModel.foreignKey.association: '_GlobalCurrency'
      @Semantics.currencyCode:true
      rkcur                                                                                            as GlobalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      ksl                                                                                              as AmountInGlobalCurrency,
      
      // Functional Currency

      @ObjectModel.foreignKey.association: '_FunctionalCurrency'
      @Semantics.currencyCode:true
      rfccur as FunctionalCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FunctionalCurrency'} }
      fcsl as AmountInFunctionalCurrency,      

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency1'
      @Semantics.currencyCode:true
      rocur                                                                                            as FreeDefinedCurrency1,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      osl                                                                                              as AmountInFreeDefinedCurrency1,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency2'
      @Semantics.currencyCode:true
      rvcur                                                                                            as FreeDefinedCurrency2,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      vsl                                                                                              as AmountInFreeDefinedCurrency2,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency3'
      @Semantics.currencyCode:true
      cast( rbcur as fis_curr3 preserving type ) as FreeDefinedCurrency3,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      bsl                                                                                              as AmountInFreeDefinedCurrency3,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency4'
      @Semantics.currencyCode:true
      cast( rccur as fis_curr4 preserving type ) as FreeDefinedCurrency4,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      csl                                                                                              as AmountInFreeDefinedCurrency4,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency5'
      @Semantics.currencyCode:true
      cast( rdcur as fis_curr5 preserving type ) as FreeDefinedCurrency5,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      dsl                                                                                              as AmountInFreeDefinedCurrency5,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency6'
      @Semantics.currencyCode:true
      cast( recur as fis_curr6 preserving type ) as FreeDefinedCurrency6,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      esl                                                                                              as AmountInFreeDefinedCurrency6,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency7'
      @Semantics.currencyCode:true
      rfcur                                                                                            as FreeDefinedCurrency7,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      fsl                                                                                              as AmountInFreeDefinedCurrency7,

      @ObjectModel.foreignKey.association: '_FreeDefinedCurrency8'
      @Semantics.currencyCode:true
      cast( rgcur as fis_curr8 preserving type ) as FreeDefinedCurrency8,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      gsl                                                                                              as AmountInFreeDefinedCurrency8,
      ////////////////////////////////////


      ////////////////////////////////////

      // NEW

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      kfsl as FixedAmountInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }      
      cast( kfsl2 as fis_vgcur12_fix2 preserving type ) as GrpValnFixedAmtInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }      
      cast( kfsl3 as fis_vgcur12_fix3 preserving type ) as PrftCtrValnFxdAmtInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      hfsl as FixedAmountInCoCodeCrcy,
      
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }      
      wfsl as FixedAmountInTransCrcy,
               
      //

      //      @DefaultAggregation: #SUM

      //      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

      //      hfsl2                                                                                              as GrpValnFixedAmtInCoCodeCrcy,

      //

      //      @DefaultAggregation: #SUM

      //      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

      //      hfsl3                                                                                              as PrftCtrValnFxdAmtInCoCodeCrcy,


      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      psl                                                                                              as TotalPriceVarcInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      cast( psl2 as fis_vpcur12_2 preserving type ) as GrpValnTotPrcVarcInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      cast( psl3 as fis_vpcur12_3 preserving type ) as PrftCtrValnTotPrcVarcInGlbCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      pfsl                                                                                             as FixedPriceVarcInGlobalCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }      
      cast( pfsl2 as fis_vpfcur12_2 preserving type ) as GrpValnFixedPrcVarcInGlobCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }      
      cast( pfsl3 as fis_vpfcur12_3 preserving type ) as PrftCtrValnFxdPrcVarcInGlbCrcy,
      ////////////////////////////////////



      @Semantics.currencyCode:true
      rco_ocur                                                                                         as ControllingObjectCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'ControllingObjectCurrency'} }      
      cast( co_osl as fis_vco_ocur12 preserving type ) as AmountInObjectCurrency,

      @Semantics.currencyCode:true
      rgm_ocur                                                                                         as GrantCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GrantCurrency'} }
      gm_osl                                                                                           as AmountInGrantCurrency,


      @ObjectModel.foreignKey.association: '_BaseUnit'
      @Semantics.unitOfMeasure:true
      runit                                                                                            as BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      msl                                                                                              as Quantity,

      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      cast( mfsl as fis_quan1_12_fix preserving type ) as FixedQuantity,

      @ObjectModel.foreignKey.association: '_CostSourceUnit'
      @Semantics.unitOfMeasure:true
      rvunit                                                                                           as CostSourceUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }    
      cast( vmsl as fis_vquan1_12 preserving type ) as ValuationQuantity, 

      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'CostSourceUnit'} }      
      cast( vmfsl as fis_vquan1_12_fix preserving type ) as ValuationFixedQuantity,

      @ObjectModel.foreignKey.association: '_ReferenceQuantityUnit'
      @Semantics.unitOfMeasure:true
      rrunit                                                                                           as ReferenceQuantityUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'ReferenceQuantityUnit'} }
      rmsl                                                                                             as ReferenceQuantity,

      @ObjectModel.foreignKey.association: '_AdditionalQuantity1Unit'
      @Semantics.unitOfMeasure:true
      cast( qunit1 as fis_qunit1 preserving type )  as AdditionalQuantity1Unit,      
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity1Unit'} }
      cast( quant1 as fis_quan1_l preserving type ) as AdditionalQuantity1,

      @ObjectModel.foreignKey.association: '_AdditionalQuantity2Unit'
      @Semantics.unitOfMeasure:true
      cast( qunit2 as fis_qunit2 preserving type )  as AdditionalQuantity2Unit, 
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity2Unit'} }
      cast( quant2 as fis_quan2_l preserving type ) as AdditionalQuantity2,

      @ObjectModel.foreignKey.association: '_AdditionalQuantity3Unit'
      @Semantics.unitOfMeasure:true
      cast( qunit3 as fis_qunit3 preserving type )  as AdditionalQuantity3Unit, 
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'AdditionalQuantity3Unit'} }
      cast( quant3 as fis_quan3_l preserving type ) as AdditionalQuantity3,

      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_IncmpltSummableValnQtyUnt'
      @Semantics.unitOfMeasure:true
      CO_MEINH as IncmpltSummableValnQtyUnt,       // IncompleteSummableValuationQuantityUnit

      
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'IncmpltSummableValnQtyUnt'} }
      CO_MEGBTR as IncmpltSummableValnQty,                 // IncompleteSummableValuationQuantity

      
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'IncmpltSummableValnQtyUnt'} }
      CO_MEFBTR as IncmpltSummableValnFxdQty,               // IncompleteSummableValuationFixQuantity


      /////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FIX  Unified Journal Entry: Mandatory fields for G/L

      ////////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      drcrk                                                                                            as DebitCreditCode,
      @ObjectModel.foreignKey.association: '_FiscalPeriodForVariant'
      @Semantics.fiscal.period: true
      poper                                                                                            as FiscalPeriod,
      @ObjectModel.foreignKey.association: '_FiscalYearVariant'
      @Semantics.fiscal.yearVariant: true
      periv                                                                                            as FiscalYearVariant,
      @ObjectModel.foreignKey.association: '_FiscalYearPeriodForVariant'
      @Semantics.fiscal.yearPeriod: true
      fiscyearper                                                                                      as FiscalYearPeriod,
      budat                                                                                            as PostingDate,
      bldat                                                                                            as DocumentDate,
      @ObjectModel.foreignKey.association: '_AccountingDocumentType'
      blart                                                                                            as AccountingDocumentType,
      buzei                                                                                            as AccountingDocumentItem,
      zuonr                                                                                            as AssignmentReference,
      @ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
      bstat                                                                                            as AccountingDocumentCategory,
linetype as JournalEntryItemCategory,      
      @ObjectModel.foreignKey.association: '_PostingKey'
      bschl                                                                                            as PostingKey,
      ktosl                                                                                            as TransactionTypeDetermination,
      @ObjectModel.foreignKey.association: '_SubLedgerAccLineItemType'
      slalittype                                                                                       as SubLedgerAcctLineItemType,
      //      @ObjectModel.foreignKey.association: '_User'

      usnam                                                                                            as AccountingDocCreatedByUser,
      cast( 
        (case when last_change_datetime <> 0 then last_change_datetime
              when last_change_datetime =  0 then timestamp 
         end)
                      as fis_lastchange_datetime preserving type )                                     as LastChangeDateTime,
      cast( timestamp as fis_creation_datetime preserving type )                                       as CreationDateTime,
      -- cast(div(timestamp, 1000000) as FIS_TIMESTAMP) as CreationDate,
//    cast( cast(substring( cast(timestamp as abap.char(30)) , 1 , 8) as abap.dats(8))  as fis_cpdat ) as CreationDate,

      cast(substring( cast(timestamp as abap.char(30)) , 1 , 8) as fis_cpdat)                          as CreationDate,
      @ObjectModel.foreignKey.association: '_EliminationProfitCenter'     
      cast( eprctr as fis_eprctr preserving type ) as EliminationProfitCenter, 
      rhoart                                                                                           as OriginObjectType,
      @ObjectModel.foreignKey.association: '_GLAccountType'
      glaccount_type                                                                                   as GLAccountType,
      @ObjectModel.foreignKey.association: '_AlternativeGLAccount'
      cast(lokkt as fis_alternativeglaccount preserving type )                                         as AlternativeGLAccount,
      @ObjectModel.foreignKey.association: '_CountryChartOfAccounts'
      ktop2                                                                                            as CountryChartOfAccounts,
      cast( xsplitmod as xsplitmod_acd preserving type  ) as ItemIsSplit,
      
      
      /////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FINCS   Universal Journal Entry: Fields for Group Reporting

      ////////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_ConsolidationUnit'      
      rbunit                                                                                           as ConsolidationUnit,
      @ObjectModel.foreignKey.association: '_PartnerConsolidationUnit'  
      rbuptr                                                                                           as PartnerConsolidationUnit,
      @ObjectModel.foreignKey.association: '_Company'  
      rcomp                                                                                            as Company, 
      @ObjectModel.foreignKey.association: '_ConsolidationChartOfAccounts' 
      ritclg                                                                                           as ConsolidationChartOfAccounts,
      @ObjectModel.foreignKey.association: '_CnsldtnFinancialStatementItem' 
      ritem                                                                                            as CnsldtnFinancialStatementItem,
      @ObjectModel.foreignKey.association: '_CnsldtnSubitemCategory' 
      sityp                                                                                            as CnsldtnSubitemCategory,
      @ObjectModel.foreignKey.association: '_CnsldtnSubitem' 
      subit                                                                                            as CnsldtnSubitem,      


      ///////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_GEN  Unified Journal Entry: Fields for several subledgers

      //////////////////////////////////////////////////////////////////////////

      rebzg                                                                                            as InvoiceReference,
      rebzj                                                                                            as InvoiceReferenceFiscalYear,
      cast( rebzt as fis_rebzt preserving type ) as FollowOnDocumentType,
      rebzz                                                                                            as InvoiceItemReference,
      rbest                                                                                            as ReferencePurchaseOrderCategory,
//      @ObjectModel.foreignKey.association: '_PurchasingDocument'

      ebeln                                                                                            as PurchasingDocument,
//      @ObjectModel.foreignKey.association: '_PurchasingDocumentItem'

      ebelp                                                                                            as PurchasingDocumentItem,      
      cast( zekkn as fis_dzekkn preserving type ) as AccountAssignmentNumber,
      sgtxt                                                                                            as DocumentItemText,
      //      @ObjectModel.foreignKey.association: '_SalesOrder'

      //      kdauf                                                                                              as SalesOrder,

      //      @ObjectModel.foreignKey.association: '_SalesOrderItem'

      //      kdpos                                                                                              as SalesOrderItem,

      @ObjectModel.foreignKey.association: '_SalesDocument'
      cast(kdauf as vbeln_va preserving type)                                                          as SalesDocument,
      @ObjectModel.foreignKey.association: '_SalesDocumentItem'
      cast(kdpos as posnr_va preserving type)                                                          as SalesDocumentItem,

      @ObjectModel.foreignKey.association: '_Product'
      cast (matnr as productnumber)                                                                    as Product,
      @ObjectModel.foreignKey.association: '_Plant'
      werks                                                                                            as Plant,
      @ObjectModel.foreignKey.association: '_Supplier'
      lifnr                                                                                            as Supplier,
      @ObjectModel.foreignKey.association: '_Customer'
      kunnr                                                                                            as Customer,
      fbuda                                                                                            as ServicesRenderedDate,
      perop_beg as PerformancePeriodStartDate,
      perop_end as PerformancePeriodEndDate,
      @ObjectModel.foreignKey.association: '_ConditionContract'
      coco_num                                                                                         as ConditionContract,
      wwert                                                                                            as ExchangeRateDate,
      /////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FI  Unified Journal Entry: Fields for FI subledgers

      /////////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_FinancialAccountType'
      koart                                                                                            as FinancialAccountType,
      @ObjectModel.foreignKey.association: '_SpecialGLCode'
      umskz                                                                                            as SpecialGLCode,
      //      @ObjectModel.foreignKey.association: '_TaxCode'

      mwskz                                                                                            as TaxCode,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_TaxCountry'
      tax_country        as  TaxCountry,
      //      @ObjectModel.foreignKey.association: '_HouseBank'

      hbkid                                                                                            as HouseBank,
      //      @ObjectModel.foreignKey.association: '_HouseBankAccount'

      hktid                                                                                            as HouseBankAccount,
//      @Semantics.booleanIndicator

      xopvw                                                                                            as IsOpenItemManaged,
      augdt                                                                                            as ClearingDate,
      
@API.element.releaseState: #DEPRECATED
@API.element.successor:    'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'      
cast( auggj as fis_auggj_no_conv_depre preserving type ) as ClearingDocFiscalYear,  
@API.element.releaseState: #DEPRECATED
@API.element.successor:    'ClearingJournalEntry'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry' 
@ObjectModel.foreignKey.association: '_ClearingAccountingDocument'    
cast( augbl as fis_augbl_depre preserving type ) as ClearingAccountingDocument,      
      
auggj as ClearingJournalEntryFiscalYear,
augbl as ClearingJournalEntry,      
      
      valut                                                                                            as ValueDate,
      AGING         as GeneralLedgerAgingScope,
      AGING_INCRMNT as GeneralLedgerAgingIncrement,

      /////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FAA  Unified Journal Entry: Fields for Asset Accounting

      /////////////////////////////////////////////////////////////////////////

      afabe                                                                                            as AssetDepreciationArea,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      anln1                                                                                            as MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
      anln2                                                                                            as FixedAsset,
      bzdat                                                                                            as AssetValueDate,
            @ObjectModel.foreignKey.association: '_AssetTransactionType'
      anbwa                                                                                            as AssetTransactionType,
            @ObjectModel.foreignKey.association: '_MovementCategory'
      movcat                                                                                           as AssetAcctTransClassfctn,
      depr_period                                                                                      as DepreciationFiscalPeriod,
      @ObjectModel.foreignKey.association: '_GroupMasterFixedAsset'
      anlgr                                                                                            as GroupMasterFixedAsset,
      @ObjectModel.foreignKey.association: '_GroupFixedAsset'
      anlgr2                                                                                           as GroupFixedAsset,
      anlkl                                                                                            as AssetClass,
      @ObjectModel.foreignKey.association: '_PartnerMasterFixedAsset'
      panl1                                                                                            as PartnerMasterFixedAsset,
      @ObjectModel.foreignKey.association: '_PartnerFixedAsset'
      panl2                                                                                            as PartnerFixedAsset,

      //////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_ML Unified Journal Entry: Fields for Material Ledger

      //////////////////////////////////////////////////////////////////////////

      kalnr                                                                                            as CostEstimate,
      @ObjectModel.foreignKey.association: '_InventorySpclStockValnType'
      cast( kzbws as fis_inventoryspclstockvalntype preserving type ) as InventorySpecialStockValnType,
      cast( xobew as fis_mlxobew preserving type ) as IsSupplierStockValuation,
      @ObjectModel.foreignKey.association: '_InventorySpecialStockType'
      cast( sobkz as fis_inventoryspecialstocktype preserving type ) as InventorySpecialStockType,
      @ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocument'      
      cast( mat_kdauf as fis_mlmat_kdauf preserving type ) as InventorySpclStkSalesDocument, //  as InventorySpecialStockSalesDocument,

      @ObjectModel.foreignKey.association: '_InventorySpclStkSalesDocItm'
      cast( mat_kdpos as fis_mlmat_kdpos preserving type ) as InventorySpclStkSalesDocItm, //  as InventorySpecialStockSalesDocumentItem,

      @ObjectModel.foreignKey.association: '_InvtrySpclStockWBSElmntBasic'
      cast( mat_pspnr as fis_invspstock_wbsint_no_conv preserving type )                               as InvtrySpclStockWBSElmntIntID,

@API.element.releaseState: #DEPRECATED
@API.element.successor:   'InvtrySpclStockWBSElmntIntID'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'InvtrySpclStockWBSElmntIntID'
      cast( mat_ps_posid as fis_invspstock_wbs_no_conv preserving type )                               as InventorySpclStockWBSElement,

      @ObjectModel.foreignKey.association: '_InventorySpecialStockSupplier'
      mat_lifnr                                                                                        as InventorySpecialStockSupplier,
      @ObjectModel.foreignKey.association: '_InventoryValuationType'
      cast( bwtar as fis_bwtar_d preserving type ) as InventoryValuationType,
      //      @ObjectModel.foreignKey.association: '_Purreqvaluationarea'

      bwkey                                                                                            as ValuationArea,
      
cast(mlptyp as fml_process_type preserving type ) as MaterialLedgerProcessType,
cast(mlcateg as fml_category preserving type ) as MaterialLedgerCategory,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
cast(hvkwrt as fis_lcrcy_sp_value preserving type ) as SlsPriceAmountInCoCodeCrcy,
cast(vprsv as fml_price_control preserving type ) as ProductPriceControl,

      ////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_CFIN   Unified Journal Entry: Fields for Central Finance

      //////////////////////////////////////////////////////////////////////////////

      cast( bukrs_sender as fis_bukrs_sender preserving type ) as SenderCompanyCode,
      //@ObjectModel.foreignKey.association: '_SenderGLAccount'

      racct_sender                                                                                     as SenderGLAccount,
      cast( accas_sender as fis_accas_sender preserving type ) as SenderAccountAssignment,      
      cast( accasty_sender as fis_accasty_sender preserving type ) as SenderAccountAssignmentType,


      ////////////////////////////////////////////////////////////////////////////

      //  .INCLUDE  ACDOC_SI_CO  Unified Journal Entry: CO fields

      ///////////////////////////////////////////////////////////////////////////

      cast( objnr as fis_objnr preserving type)                                                        as ControllingObject,
      //      @ObjectModel.foreignKey.association: '_CostOriginGroup'

      hkgrp                                                                                            as CostOriginGroup,
      @ObjectModel.foreignKey.association: '_OriginSenderObject'
      uspob                                                                                            as OriginSenderObject,
      @ObjectModel.foreignKey.association: '_ControllingDebitCreditCode'      
      cast( co_belkz as fis_co_belkz preserving type )  as ControllingDebitCreditCode,
      @ObjectModel.foreignKey.association: '_OriginCtrlgDebitCreditCode'
      co_beknz                                                                                         as OriginCtrlgDebitCreditCode,      
      cast( beltp as fis_bp_inout preserving type ) as ControllingObjectDebitType,
      muvflg                                                                                           as QuantityIsIncomplete,
      @ObjectModel.foreignKey.association: '_OffsettingAccount'
      gkont                                                                                            as OffsettingAccount,
      @ObjectModel.foreignKey.association: '_OffsettingAccountType'
      cast( gkoar as fis_gkoar preserving type ) as OffsettingAccountType,
      @ObjectModel.foreignKey.association: '_OffsettingChartOfAccounts'
      case gkoar
        when 'D' then cast ('    ' as fis_offsettingktopl preserving type )
        when 'K' then cast ('    ' as fis_offsettingktopl preserving type )
        else cast( ktopl as fis_offsettingktopl preserving type ) 
      end                                                                                              as OffsettingChartOfAccounts,
      erlkz                                                                                            as LineItemIsCompleted,
      pernr                                                                                            as PersonnelNumber,
      @ObjectModel.foreignKey.association: '_ControllingObjectClass'
      scope                                                                                            as ControllingObjectClass,
      @ObjectModel.foreignKey.association: '_PartnerCompanyCode'      
      cast( pbukrs as fis_pbukrs preserving type ) as PartnerCompanyCode,
      @ObjectModel.foreignKey.association: '_PartnerControllingObjectClass'
      pscope                                                                                           as PartnerControllingObjectClass,
      @ObjectModel.foreignKey.association: '_OriginProfitCenter'
      uprctr                                                                                           as OriginProfitCenter,
            
      @ObjectModel.foreignKey.association: '_OriginOrder'
      aufnr_org                                                                                        as OriginOrder,

      @ObjectModel.foreignKey.association: '_OriginCostCtrActivityType'
      ulstar   as OriginCostCtrActivityType,
      @ObjectModel.foreignKey.association: '_OriginCostCenter'
      ukostl as OriginCostCenter,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_OriginProduct'
      UMATNR as OriginProduct,
      VARC_UACCT as VarianceOriginGLAccount,

      accas                                                                                            as AccountAssignment,  
      @Analytics.internalName: #LOCAL    
      @ObjectModel.foreignKey.association: '_AccountAssignmentType'
      accasty                                                                                          as AccountAssignmentType,
      @ObjectModel.foreignKey.association: '_CostCtrActivityType'
      lstar                                                                                            as CostCtrActivityType,
      @ObjectModel.foreignKey.association: '_Order'
      aufnr                                                                                            as OrderID,
      @ObjectModel.foreignKey.association: '_OrderCategory'
      autyp                                                                                            as OrderCategory,
      @ObjectModel.foreignKey.association: '_WBSElementBasicData'
      cast( ps_psp_pnr as fis_wbsint_no_conv preserving type )                                         as WBSElementInternalID,

@API.element.releaseState: #DEPRECATED
@API.element.successor:   'WBSElementInternalID'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'WBSElementInternalID'
      cast( ps_posid as fis_wbs_no_conv preserving type )                                              as WBSElement,

      @ObjectModel.foreignKey.association: '_PartnerWBSElementBasicData'
      cast( pps_psp_pnr as fis_partner_wbsint_no_conv preserving type )                                as PartnerWBSElementInternalID,

@API.element.releaseState: #DEPRECATED
@API.element.successor:    'PartnerWBSElementInternalID'
@VDM.lifecycle.status:     #DEPRECATED
@VDM.lifecycle.successor:  'PartnerWBSElementInternalID'
      cast( pps_posid as fis_partner_wbs_no_conv preserving type )                                     as PartnerWBSElement,

      @ObjectModel.foreignKey.association: '_ProjectBasicData'
      cast( ps_prj_pnr as fis_projectint_no_conv preserving type )                                     as ProjectInternalID,

@API.element.releaseState: #DEPRECATED
@API.element.successor:   'ProjectInternalID'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'ProjectInternalID'
      cast( ps_pspid as fis_project_no_conv preserving type  )                                         as Project,

      @ObjectModel.foreignKey.association: '_PartnerProjectBasicData'
      cast( pps_prj_pnr as fis_part_projectint_no_conv preserving type )                               as PartnerProjectInternalID,

@API.element.releaseState: #DEPRECATED
@API.element.successor:    'PartnerProjectInternalID'
@VDM.lifecycle.status:     #DEPRECATED
@VDM.lifecycle.successor:  'PartnerProjectInternalID'
      cast( pps_pspid as fis_part_project_no_conv preserving type )                                    as PartnerProject,

      @ObjectModel.foreignKey.association: '_OperatingConcern'
      erkrs                                                                                            as OperatingConcern,
      //      @ObjectModel.foreignKey.association: '_ProjectNetwork'

      nplnr                                                                                            as ProjectNetwork,
      //      @ObjectModel.foreignKey.association: '_RelatedNetworkActivity'

      nplnr_vorgn                                                                                      as RelatedNetworkActivity,
      @ObjectModel.foreignKey.association: '_BusinessProcess'
      prznr                                                                                            as BusinessProcess,
      kstrg                                                                                            as CostObject,
      //      @ObjectModel.foreignKey.association: '_BillableControl'

      bemot                                                                                            as BillableControl,
      @ObjectModel.foreignKey.association: '_CostAnalysisResource'
      rsrce                                                                                            as CostAnalysisResource,      
      cast( qmnum as fis_qmnum preserving type ) as CustomerServiceNotification,

      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentTypeVH',
                           element: 'ServiceDocumentType' }
              }]
      //@ObjectModel.foreignKey.association: '_ServiceDocumentType'

      service_doc_type                                                                                 as ServiceDocumentType,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentVH',
                           element: 'ServiceDocument' }
              }]
      //@ObjectModel.foreignKey.association: '_ServiceDocument'

      service_doc_id                                                                                   as ServiceDocument,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentItemVH',
                           element: 'ServiceDocumentItem' }
              }]
      //@ObjectModel.foreignKey.association: '_ServiceDocumentItem'

      service_doc_item_id                                                                              as ServiceDocumentItem,

      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentTypeVH',
                           element: 'ServiceDocumentType' }
              }]
      //@ObjectModel.foreignKey.association: '_PartnerServiceDocumentType'

      cast( pservice_doc_type as fis_psrvdoc_type preserving type )  as PartnerServiceDocumentType,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentVH',
                           element: 'ServiceDocument' }
              }]
      //@ObjectModel.foreignKey.association: '_PartnerServiceDocument'     

      cast( pservice_doc_id as fis_psrvdoc_id preserving type ) as PartnerServiceDocument,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceDocumentItemVH',
                           element: 'ServiceDocumentItem' }
              }]
      //@ObjectModel.foreignKey.association: '_PartnerServiceDocumentItem'

      cast( pservice_doc_item_id as fis_psrvdoc_item_id preserving type ) as PartnerServiceDocumentItem,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_ServiceContractTypeStdVH',
                           element: 'ServiceDocumentType' }
              }]

      //@ObjectModel.foreignKey.association: '_ServiceContractType'

      service_contract_type                                                                            as ServiceContractType,
      @Consumption.valueHelpDefinition: [
              { entity:  { name:    'I_AcctgServiceContractVH',
                           element: 'ServiceContract' }
              }]
      //@Analytics.internalName: #LOCAL

      //@ObjectModel.foreignKey.association: '_ServiceContract'

      service_contract_id                                                                              as ServiceContract,
      //@ObjectModel.foreignKey.association: '_ServiceContractItem'

      service_contract_item_id                                                                         as ServiceContractItem,

solution_order_id as BusinessSolutionOrder,
solution_order_item_id as BusinessSolutionOrderItem,

      @ObjectModel.foreignKey.association: '_ProviderContract'
      vtkey as ProviderContract,
      @ObjectModel.foreignKey.association: '_ProviderContractItem'
      vtpos as ProviderContractItem,
      
      ra_contract_id as RevenueAccountingContract,
      ra_pob_id as PerformanceObligation,         

      //@ObjectModel.foreignKey.association: '_TimeSheetOvertimeCat'

      overtimecat                                                                                      as TimeSheetOvertimeCategory,
      paccas                                                                                           as PartnerAccountAssignment,
      paccasty                                                                                         as PartnerAccountAssignmentType,      
      co_accasty_n1 as StstclAccountAssignmentType1,
      co_accasty_n2 as StstclAccountAssignmentType2,
      co_accasty_n3 as StstclAccountAssignmentType3,       
      
      cast( ps_posid as /cpd/plan_item_id )                                                            as WorkPackage,
      work_item_id                                                                                     as WorkItem,
      @ObjectModel.foreignKey.association: '_PartnerCostCtrActivityType'
      plstar                                                                                           as PartnerCostCtrActivityType,
         
      @ObjectModel.foreignKey.association: '_PartnerOrder'
      paufnr as PartnerOrder,

      @ObjectModel.foreignKey.association: '_PartnerOrderCategory'
      pautyp                                                                                           as PartnerOrderCategory,
      @ObjectModel.foreignKey.association: '_PartnerSalesDocument'
      pkdauf                                                                                           as PartnerSalesDocument,
      @ObjectModel.foreignKey.association: '_PartnerSalesDocumentItem'
      pkdpos                                                                                           as PartnerSalesDocumentItem,      
      cast( pnplnr as fis_par_npln preserving type ) as PartnerProjectNetwork,
      //      @ObjectModel.foreignKey.association: '_PartnerProjectNetworkActivity'      

      pnplnr_vorgn as PartnerProjectNetworkActivity,
      @ObjectModel.foreignKey.association: '_PartnerBusinessProcess'
      cast( pprznr as fis_par_prznr preserving type ) as PartnerBusinessProcess,     
      pkstrg                                                                                           as PartnerCostObject,
      cast( co_buzei as co_buzei_acd preserving type  ) as ControllingDocumentItem,
      
      varc_hkgrp as VarianceOriginGroup, 

      //////////////////////////////////////////////////////////////////////

      //  .INCLUDE  ACDOC_SI_COPA  Unified Journal Entry: CO-PA fields

      //////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_BillingDocumentType'
      fkart                                                                                            as BillingDocumentType,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
      vkorg                                                                                            as SalesOrganization,
      @ObjectModel.foreignKey.association: '_DistributionChannel'
      vtweg                                                                                            as DistributionChannel,
      spart                                                                                            as OrganizationDivision,
      @ObjectModel.foreignKey.association: '_SoldProduct'
      matnr_copa                                                                                       as SoldProduct,
      @ObjectModel.foreignKey.association: '_SoldProductGroup'
      matkl                                                                                            as SoldProductGroup,

      @ObjectModel.foreignKey.association: '_CustomerGroup'
      kdgrp                                                                                            as CustomerGroup,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_CustomerSupplierCountry'      
      cast( land1 as fis_land1_gp preserving type ) as CustomerSupplierCountry,            
      cast( brsch as fis_brsch preserving type ) as CustomerSupplierIndustry,
      @Analytics.internalName: #LOCAL
      @ObjectModel.foreignKey.association: '_SalesDistrict'
      bzirk                                                                                            as SalesDistrict,
      kunre                                                                                            as BillToParty,
      kunwe                                                                                            as ShipToParty,
      cast( konzs as fis_konzs preserving type ) as CustomerSupplierCorporateGroup,


      //////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_PS  Unified Journal Entry: Fields for Public Sector

      /////////////////////////////////////////////////////////////////////

      @ObjectModel.foreignKey.association: '_CashLedgerCompanyCode'
      re_bukrs                                                                                         as CashLedgerCompanyCode,

      @ObjectModel.foreignKey.association: '_CashLedgerAccount'
      re_account                                                                                       as CashLedgerAccount,

      @ObjectModel.foreignKey.association: '_FinancialManagementArea'
      fikrs                                                                                            as FinancialManagementArea,
      
      fipex as CommitmentItem,      

      @ObjectModel.foreignKey.association: '_FundsCenter'
      fistl                                                                                            as FundsCenter,

      @ObjectModel.foreignKey.association: '_FundedProgram'
      measure                                                                                          as FundedProgram,

      @ObjectModel.foreignKey.association: '_Fund'
      rfund                                                                                            as Fund,

      @ObjectModel.foreignKey.association: '_Grant'
      rgrant_nbr                                                                                       as GrantID,

      @ObjectModel.foreignKey.association: '_BudgetPeriod'
      rbudget_pd                                                                                       as BudgetPeriod,

      @ObjectModel.foreignKey.association: '_PartnerFund'
      sfund                                                                                            as PartnerFund,

      @ObjectModel.foreignKey.association: '_PartnerGrant'
      sgrant_nbr                                                                                       as PartnerGrant,

      @ObjectModel.foreignKey.association: '_PartnerBudgetPeriod'     
      cast( sbudget_pd as fis_fm_pbudget_period preserving type ) as PartnerBudgetPeriod,

      @ObjectModel.foreignKey.association: '_PubSecBudgetAccount'
      bdgt_account                                                                                     as PubSecBudgetAccount,

      @ObjectModel.foreignKey.association: '_PubSecBudgetAccountCoCode'
      bdgt_account_cocode                                                                              as PubSecBudgetAccountCoCode,

      @ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnDate'
      bdgt_cnsmpn_date                                                                                 as PubSecBudgetCnsmpnDate,

      @ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnFsclPeriod'
      bdgt_cnsmpn_period                                                                               as PubSecBudgetCnsmpnFsclPeriod,

      @ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnFsclYear'
      bdgt_cnsmpn_year                                                                                 as PubSecBudgetCnsmpnFsclYear,

      bdgt_relevant                                                                                    as PubSecBudgetIsRelevant,

      @ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnType'
      bdgt_cnsmpn_type                                                                                 as PubSecBudgetCnsmpnType,

      @ObjectModel.foreignKey.association: '_PubSecBudgetCnsmpnAmtType'
      bdgt_cnsmpn_amount_type                                                                          as PubSecBudgetCnsmpnAmtType,

//      @ObjectModel.foreignKey.association: '_SponsoredProgram'

      rsponsored_prog as SponsoredProgram,

//      @ObjectModel.foreignKey.association: '_SponsoredClass'

      rsponsored_class as SponsoredClass,
      
      rbdgt_vldty_nbr as GteeMBudgetValidityNumber,     
      
      kblnr as EarmarkedFundsDocument,
      kblpos as EarmarkedFundsDocumentItem,       
      
      
      ///////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_JVA  Universal Journal Entry: Fields for Financial Services

      ///////////////////////////////////////////////////////////////////////

FS_PRODUCT_GROUP as FinancialServicesProductGroup,
BRANCH_ID as FinancialServicesBranch,
DATASOURCE_ID as FinancialDataSource,
        

      ///////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_JVA  Unified Journal Entry: Fields for Joint Venture Accounting

      ///////////////////////////////////////////////////////////////////////

      vname                                                                                            as JointVenture,
      cast( egrup as jv_egroup_cds preserving type )                                                   as JointVentureEquityGroup,
      cast( recid as jv_recind_cds preserving type )                                                   as JointVentureCostRecoveryCode,
      cast( vptnr as jv_part_cds preserving type )                                                     as JointVenturePartner,
      cast( btype as jv_bilind_cds preserving type )                                                   as JointVentureBillingType,
      cast( etype as jv_etype_cds preserving type )                                                    as JointVentureEquityType,
      cast( prodper as jv_prodper_cds preserving type )                                                as JointVentureProductionDate,
      cast( billm as jv_billm_cds preserving type )                                                    as JointVentureBillingDate,
      cast( pom as jv_pom_cds preserving type )                                                        as JointVentureOperationalDate,
      cast( cbrunid as jv_cbrunid_cds preserving type )                                                as CutbackRun,
      cast( jvactivity as jv_activity_cds preserving type )                                            as JointVentureAccountingActivity,
      cast( pvname as jv_pvname_cds preserving type )                                                  as PartnerVenture,
      cast( pegrup as jv_pegrup_cds preserving type )                                                  as PartnerEquityGroup,
      cast( s_recind as jv_srecind_cds preserving type )                                               as SenderCostRecoveryCode,
      cast( cbracct as jv_cbracct_cds preserving type )                                                as CutbackAccount,
      cast( cbobjnr as jv_cbobjnr_cds preserving type )                                                as CutbackCostObject,

      ///////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_RE STRU  0 0 Unified Journal Entry: Fields for Real Estate

      ///////////////////////////////////////////////////////////////////////

      SWENR as REBusinessEntity,
      SGENR as RealEstateBuilding,
      SGRNR as RealEstateProperty,
      SMENR as RERentalObject,
      RECNNR as RealEstateContract,
snksl as REServiceChargeKey,
sempsl as RESettlementUnitID,      
cast( dabrz as fis_dabrbez preserving type ) as SettlementReferenceDate,      
pswenr as REPartnerBusinessEntity,
psgenr as RealEstatePartnerBuilding,
psgrnr as RealEstatePartnerProperty,
psmenr as REPartnerRentalObject,
precnnr as RealEstatePartnerContract,
psnksl as REPartnerServiceChargeKey,
psempsl as REPartnerSettlementUnitID,
pdabrz as 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'

      acrobjtype   as AccrualObjectType,
      acrlogsys    as AccrualObjectLogicalSystem,
      //@ObjectModel.foreignKey.association: '_AccrualObject'

      acrobj_id    as AccrualObject,
      //@ObjectModel.foreignKey.association: '_AccrualSubobject'

      acrsobj_id   as AccrualSubobject,
      //@ObjectModel.foreignKey.association: '_AccrualItemType'

      acritmtype   as AccrualItemType,
      acrrefobj_id as AccrualReferenceObject,
      acrvaldat    as AccrualValueDate,


      ///////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_VAL STRU  0 0 Universal Journal Entry: Fields for Fin. Valuation Object

      ///////////////////////////////////////////////////////////////////////      

      cast( valobjtype as fis_val_obj_type preserving type ) as FinancialValuationObjectType,    
      cast( valobj_id as fis_val_obj_id preserving type ) as FinancialValuationObject,
      cast( valsobj_id as fis_val_subobj_id preserving type ) as FinancialValuationSubobject,
      netdt                                                                                            as NetDueDate,
      risk_class                                                                                       as CreditRiskClass,

      //////////////////////////////////////////////////////////////////////

      //  .INCLUDE  ACDOC_SI_LOG  Universal Journal Entry: Fields for Logistics

      //////////////////////////////////////////////////////////////////////


      arbid                                                                                            as WorkCenterInternalID,
      vornr                                                                                            as OrderOperation,
      aufps                                                                                            as OrderItem,
      paufps                                                                                           as PartnerOrderItem,

      //////////////////////////////////////////////////

      // .INCLUDE  ACDOC_SI_LOG_ACT:  New Fields  PM  //

      //////////////////////////////////////////////////

      //  @ObjectModel.foreignKey.association: '_MaintenanceOrderSubOperation'      // Triangle Condition

      uvorn                                                                                            as OrderSuboperation,
      @ObjectModel.foreignKey.association: '_Equipment'
      equnr                                                                                            as Equipment,
      @ObjectModel.foreignKey.association: '_FunctionalLocation'
      tplnr                                                                                            as FunctionalLocation,
      @ObjectModel.foreignKey.association: '_Assembly'
      istru                                                                                            as Assembly,
      @ObjectModel.foreignKey.association: '_MaintenanceActivityType'
      ilart                                                                                            as MaintenanceActivityType,
      //@ObjectModel.foreignKey.association: '_MaintOrdPlngDegreeCode'

      plknz                                                                                            as MaintenanceOrderPlanningCode,
      //@ObjectModel.foreignKey.association: '_PMNotificationPriorityType'

      artpr                                                                                            as MaintPriorityType,
      //@ObjectModel.foreignKey.association: '_PMNotificationPriority'

      priok                                                                                            as MaintPriority,
      //@ObjectModel.foreignKey.association: '_SuperiorOrder'

      maufnr                                                                                           as SuperiorOrder,
      @ObjectModel.foreignKey.association: '_ProductGroup'
      cast( matkl_mm  as fis_matkl_mm preserving type )                                                as ProductGroup,
      planned_parts_work                                                                               as MaintenanceOrderIsPlanned,
      vornr_org as OriginOrderOperation,
      
      
      //////////////////////////////////////////////////////////////////////////

      // .INCLUDE  ACDOC_SI_TECH:  Universal Journal Entry: Technical Fields  //

      ////////////////////////////////////////////////////////////////////////// 

mig_source as JrnlEntryItemMigrationSource,
      

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

      //   case drcrk  when 'S' then  cast( hsl as fis_dr_hsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_hsl preserving type)

      //   end as DebitAmountInCoCodeCrcy,

      //   @DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }

      //   case drcrk  when 'H' then  cast( hsl as fis_cr_hsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_hsl preserving type)

      //   end as CreditAmountInCoCodeCrcy,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }

      //   case drcrk  when 'S' then  cast( wsl as fis_dr_wsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_wsl preserving type)

      //   end as DebitAmountInTransCrcy,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }

      //   case drcrk  when 'H' then  cast( wsl as fis_cr_wsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_wsl preserving type)

      //   end as CreditAmountInTransCrcy,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }

      //   case drcrk  when 'S' then  cast( tsl as fis_dr_tsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_tsl preserving type)

      //   end as DebitAmountInBalanceTransCrcy,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }

      //   case drcrk  when 'H' then  cast( tsl as fis_cr_tsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_tsl preserving type)

      //   end as CreditAmountInBalanceTransCrcy,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

      //   case drcrk  when 'S' then  cast( ksl as fis_dr_ksl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_ksl preserving type)

      //   end as DebitAmountInGlobalCrcy,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'GlobalCurrency'} }

      //   case drcrk  when 'H' then  cast( ksl as fis_cr_ksl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_ksl preserving type)

      //   end as CreditAmountInGlobalCrcy,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

      //   case drcrk  when 'S' then  cast( osl as fis_dr_osl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_osl preserving type)

      //   end as DebitAmountInFreeDfndCrcy1,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }

      //   case drcrk  when 'H' then  cast( osl as fis_cr_osl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_osl preserving type)

      //   end as CreditAmountInFreeDfndCrcy1,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

      //   case drcrk  when 'S' then  cast( vsl as fis_dr_vsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_vsl preserving type)

      //   end as DebitAmountInFreeDfndCrcy2,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }

      //   case drcrk  when 'H' then  cast( vsl as fis_cr_vsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_vsl preserving type)

      //   end as CreditAmountInFreeDfndCrcy2,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

      //   case drcrk  when 'S' then  cast( bsl as fis_dr_bsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_bsl preserving type)

      //   end as DebitAmountInFreeDfndCrcy3,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }

      //   case drcrk  when 'H' then  cast( bsl as fis_cr_bsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_bsl preserving type)

      //   end as CreditAmountInFreeDfndCrcy3,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

      //   case drcrk  when 'S' then  cast( csl as fis_dr_csl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_csl preserving type)

      //   end as DebitAmountInFreeDfndCrcy4,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }

      //   case drcrk  when 'H' then  cast( csl as fis_cr_csl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_csl preserving type)

      //   end as CreditAmountInFreeDfndCrcy4,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

      //   case drcrk  when 'S' then  cast( dsl as fis_dr_dsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_dsl preserving type)

      //   end as DebitAmountInFreeDfndCrcy5,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }

      //   case drcrk  when 'H' then  cast( dsl as fis_cr_dsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_dsl preserving type)

      //   end as CreditAmountInFreeDfndCrcy5,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

      //   case drcrk  when 'S' then  cast( esl as fis_dr_esl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_esl preserving type)

      //   end as DebitAmountInFreeDfndCrcy6,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }

      //   case drcrk  when 'H' then  cast( esl as fis_cr_esl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_esl preserving type)

      //   end as CreditAmountInFreeDfndCrcy6,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

      //   case drcrk  when 'S' then  cast( fsl as fis_dr_fsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_fsl preserving type)

      //   end as DebitAmountInFreeDfndCrcy7,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }

      //   case drcrk  when 'H' then  cast( fsl as fis_cr_fsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_fsl preserving type)

      //   end as CreditAmountInFreeDfndCrcy7,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

      //   case drcrk  when 'S' then  cast( gsl as fis_dr_gsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_dr_gsl preserving type)

      //   end as DebitAmountInFreeDfndCrcy8,

      //

      //@DefaultAggregation: #SUM

      //@Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }

      //   case drcrk  when 'H' then  cast( gsl as fis_cr_gsl preserving type)

      //                        else  cast( cast( '0' as abap.curr( 23,2))   as fis_cr_gsl preserving type)

      //   end as CreditAmountInFreeDfndCrcy8,

      //

      //

      //case when ( accasty != 'OR' and accasty != 'OP' and accasty != 'OV' ) and aufnr != ''    then cast( 'X' as fins_xaufnr_stat preserving type)

      //                                                                                         else cast( ' ' as fins_xaufnr_stat preserving type)

      //end as IsStatisticalOrder,

      //

      //case when ( accasty != 'KL' and accasty != 'KS' ) and rcntr != ''    then cast( 'X' as fins_xkostl_stat preserving type)

      //                                                                     else cast( ' ' as fins_xkostl_stat preserving type)

      //end as IsStatisticalCostCenter,

      //

      //case when accasty != 'VB' and kdauf != ''   then cast( 'X' as fins_xkdpos_stat preserving type)

      //                                            else cast( ' ' as fins_xkdpos_stat preserving type)

      //end as IsStatisticalSalesDocument,

      //

      //case when ( accasty != 'PR' ) and ( ps_posid != ' ' and ps_pspid != ' ' ) then cast( 'X' as fins_xps_posid_stat preserving type )

      //                                                                          else cast( ' ' as fins_xps_posid_stat preserving type )

      //end as WBSIsStatisticalWBSElement,



      ///////////////////////////////////////////////////////////////////////////////

      // Associations

      ///////////////////////////////////////////////////////////////////////////////


      _JournalEntry,
      _CompanyCode,
      _FiscalYear,
      _FiscalPeriodForVariant,
      _LedgerFiscalYearForVariant,
      _FiscalYearVariant,
      _FiscalYearPeriodForVariant,
      _CalendarDate,
      _FiscalCalendarDate,
      _ControllingArea,
      _BalanceTransactionCurrency,
      _TransactionCurrency,
      _CompanyCodeCurrency,
      _GlobalCurrency,
      _FunctionalCurrency,
      _FreeDefinedCurrency1,
      _FreeDefinedCurrency2,
      _FreeDefinedCurrency3,
      _FreeDefinedCurrency4,
      _FreeDefinedCurrency5,
      _FreeDefinedCurrency6,
      _FreeDefinedCurrency7,
      _FreeDefinedCurrency8,
      _BaseUnit,
      _CostSourceUnit,
      _AdditionalQuantity1Unit,
      _AdditionalQuantity2Unit,
      _AdditionalQuantity3Unit,
      _ReferenceQuantityUnit,
      _IncmpltSummableValnQtyUnt,
      _Segment,
      _ProfitCenter,
      _CostCenter,
      _CostAnalysisResource,
      _AccountAssignmentType,

      _PartnerWBSElementBasicData,
      _BusinessArea,
      _FunctionalArea,
      _GLAccountInChartOfAccounts,
      _GLAccountInCompanyCode,
      _ChartOfAccounts,
      _AccountingDocumentType,
      _FinancialAccountType,
      _DebitCreditCode,
      _Product,
      _Plant,
      _Ledger,
      //      _SourceLedger,

      //      @UI.hidden: true

      //      _SourceLedgerText,


      _Customer,
      _CustomerCompany,
      _CustomerGroup,

      _Supplier,
      _SupplierCompany,

@API.element.releaseState: #DEPRECATED
@API.element.successor:    '_ProductGroup_2'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: '_ProductGroup_2'
_ProductGroup,
_ProductGroup_2,

@API.element.releaseState: #DEPRECATED
@API.element.successor:    '_SoldProductGroup_2'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: '_SoldProductGroup_2'
_SoldProductGroup,
_SoldProductGroup_2,

      //      _SalesOrder,

      //      _SalesOrderItem,

      _SalesDocument,
      _SalesDocumentItem,

      //      _InternalOrder,

      _Order,
      _OriginOrder,

      _FinancialTransactionType,
      _BusinessTransactionCategory,
      _BusinessTransactionType,
      //      _ControllingBusTransacType,

      _ReferenceDocumentType,
_PredecessorReferenceDocType,
      _PartnerCostCenter,
      _PartnerProfitCenter,
      _PartnerBusinessArea,
      _PartnerFunctionalArea,
      _PartnerCompanyCode,
      _PartnerSegment,

      _AccountingDocumentCategory,

      _PostingKey,
      _SubLedgerAccLineItemType,
      //      _User,


      _EliminationProfitCenter,

      //_ControllingObject,


      _GLAccountType,
      _OffsettingAccountType,
      _OffsettingChartOfAccounts,
      _OffsettingAccount,

      _AlternativeGLAccount,
      _CountryChartOfAccounts,

//      _PurchasingDocument,

//      _PurchasingDocumentItem,


      _SpecialGLCode,
      _TaxCode,
      _TaxCountry,
      //      _HouseBank,


_ClearingJrnlEntryFiscalYear,
_ClearingJournalEntry,
@API.element.releaseState: #DEPRECATED
@API.element.successor:    '_ClearingJournalEntry'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: '_ClearingJournalEntry'
_ClearingAccountingDocument,      

      _MasterFixedAsset,
      _GroupMasterFixedAsset,
      _PartnerMasterFixedAsset,
      _FixedAsset,
      _GroupFixedAsset,
      _PartnerFixedAsset,
@API.element.releaseState: #DEPRECATED
@API.element.successor:    '_InventorySpclStockValnType'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: '_InventorySpclStockValnType'
      _InventorySpecialStockValnType,
      _InventorySpclStockValnType,
      _InventorySpecialStockType,
      _InventorySpclStkSalesDocument,
      _InventorySpclStkSalesDocItm,
      _InvtrySpclStockWBSElmntBasic,     // do not use

      _InvtrySpclStkWBSElmntBscData,
      _InventorySpecialStockSupplier,
      _InventoryValuationType,
      _ControllingDebitCreditCode,
      _OriginCtrlgDebitCreditCode,
      _OriginSenderObject,
      _ControllingObjectClass,
      _PartnerControllingObjectClass,
      _OriginCostCenter,
      _OriginProfitCenter,
      _CostCtrActivityType,
      _OriginCostCtrActivityType,
      _OrderCategory,
      //_RelatedNetworkActivity,

      //_PartnerProjectNetworkActivity,


      _BusinessProcess,
      _PartnerCostCtrActivityType,     
      _PartnerOrder,
      _PartnerOrderCategory,
      _PartnerSalesDocument,
      _PartnerSalesDocumentItem,
      _PartnerBusinessProcess,
      _BillingDocumentType,

      _SalesOrganization,
      _DistributionChannel,
      _SoldProduct,
      _OriginProduct,
            _MovementCategory,
            _AssetTransactionType,
      _CostOriginGroup,
      _CustomerSupplierCountry,
      _SalesDistrict,
      _BillToParty,
      _ShipToParty,
      //      _HouseBankAccount,

      //      _LogicalSystem,

      _OperatingConcern,
      _PartnerCompany,
      //      _ProjectNetwork,

            _ValuationArea,
      _WorkCenter,
            _BillableControl,
      _ServiceDocumentType,
      _ServiceDocument,
      _ServiceDocumentItem,
      _ServiceContract,
      _ServiceContractItem,
      _ServiceContractType,
      _PartnerServiceDocumentType,
      _PartnerServiceDocument,
      _PartnerServiceDocumentItem,
      _ConditionContract,
      _Equipment,
      _FunctionalLocation,
      _MaintenanceActivityType,
      //_MaintOrdPlngDegreeCode,

      //_PMNotificationPriorityType,

      //_PMNotificationPriority,

      _MaintenanceOrder,
      _MaintenanceOrderOperation,
      _MaintenanceOrderSubOperation,
      _Assembly,
      //_SuperiorOrder,

      _WorkPackage,
      _WorkPackageWorkItem,
      _TimeSheetOvertimeCat,
      _WBSElementBasicData,
      _ProjectBasicData,
      _PartnerProjectBasicData,

      _AccrualObjectType,
      _AccrualObject,
      _AccrualSubobject,
      _AccrualItemType,

      _CreditRiskClass,
      _FinValuationObjectType,

      _SemTagGLAccount,

      _CashLedgerCompanyCode,
      _CashLedgerAccount,
      _FinancialManagementArea,
      _FundsCenter,
      _FundedProgram,
      _Fund,
      _Grant,
      _BudgetPeriod,
      _PartnerFund,
      _PartnerGrant,
      _PartnerBudgetPeriod,
      _PubSecBudgetAccountCoCode,
      _PubSecBudgetAccount,
      _PubSecBudgetCnsmpnDate,
      _PubSecBudgetCnsmpnFsclPeriod,
      _PubSecBudgetCnsmpnFsclYear,
      _PubSecBudgetCnsmpnType,
      _PubSecBudgetCnsmpnAmtType,
      _SponsoredProgram,
      _SponsoredClass,
      
      _ConsolidationUnit,
      _PartnerConsolidationUnit,
      _Company,
      _ConsolidationChartOfAccounts,
      _CnsldtnFinancialStatementItem,
      _CnsldtnSubitemCategory,
      _CnsldtnSubitem,     

      _ProviderContract,
      _ProviderContractItem,
      _JrnlEntryItemObsoleteRsn

      //_Extension  Extensions must be local

}