C_FixedAssetSimlnPostingTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Simulation for Fixed Asset Posting'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@Metadata.allowExtensions: true
//@Analytics.dataCategory: #DIMENSION


define view entity C_FixedAssetSimlnPostingTP

  as select from faad_tr_simdoc
    inner join   faad_tr_post on  faad_tr_simdoc.fixedassetpostinguuid = faad_tr_post.fixedassetpostinguuid
                              and faad_tr_simdoc.referencedocumentitem = faad_tr_post.referencedocumentitem
    inner join   t001         on faad_tr_simdoc.companycode = t001.bukrs
//    inner join P_AssetKeyFigureSpecification as _AssetKeyFigureSpec on _AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn    = faad_tr_simdoc.assetaccttransclassfctn

//                                                                   and _AssetKeyFigureSpec.SubLedgerAcctLineItemType        = faad_tr_simdoc.subledgeracctlineitemtype

//                                                                   and _AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn    = '12'

  association [1..1] to C_FixedAssetPostingTP       as _FixedAssetPosting on  $projection.FixedAssetPostingUUID = _FixedAssetPosting.FixedAssetPostingUUID
                                                                    and $projection.ReferenceDocumentItem = _FixedAssetPosting.ReferenceDocumentItem
  association [0..1] to I_LedgerText                as _LedgerText        on  $projection.Ledger   = _LedgerText.Ledger
                                                                    and _LedgerText.Language = $session.system_language
  association [0..1] to I_DeprAreaForLedgerText     as _DepreciationAreaText         on  $projection.CompanyCode           = _DepreciationAreaText.CompanyCode
                                                                                     and $projection.Ledger                = _DepreciationAreaText.Ledger
                                                                                     and $projection.AssetDepreciationArea = _DepreciationAreaText.AssetDepreciationArea
                                                                                     and _DepreciationAreaText.Language    = $session.system_language
  association [0..1] to I_SubLedgerAccLineItemTypeT as _SubLedgerAccLineItemTypeText on  $projection.SubLedgerAcctLineItemType  = _SubLedgerAccLineItemTypeText.SubLedgerAcctLineItemType
                                                                                     and _SubLedgerAccLineItemTypeText.Language = $session.system_language
  association [0..1] to I_GlAccountTextInCompanycode as _GLAccountText on  $projection.CompanyCode = _GLAccountText.CompanyCode
                                                                       and $projection.GLAccount   = _GLAccountText.GLAccount 
                                                                       and _GLAccountText.Language = $session.system_language
  association [0..1] to I_FunctionalAreaText        as _FunctionalAreaText on  $projection.FunctionalArea = _FunctionalAreaText.FunctionalArea 
                                                                    and _FunctionalAreaText.Language = $session.system_language
  association [0..1] to I_FundText                  as _FundText on  $projection.Fund = _FundText.Fund 
                                                                 and $projection.FinancialManagementArea = _FundText.FinancialManagementArea
                                                                 and _FundText.Language = $session.system_language
  association [0..1] to I_GrantText                 as _GrantText on  $projection.GrantID = _GrantText.GrantID 
                                                                  and _GrantText.Language = $session.system_language
{
       @UI.hidden: true
  key  faad_tr_simdoc.fixedassetpostinguuid          as FixedAssetPostingUUID,

  key  faad_tr_simdoc.referencedocumentitem          as ReferenceDocumentItem,

  key  faad_tr_post.companycode                      as CompanyCode,

       @ObjectModel.text.element: ['LedgerName']
//       @ObjectModel.text.association: '_LedgerText'

       @UI.textArrangement: #TEXT_LAST
  key  faad_tr_simdoc.ledger                         as Ledger,

       @ObjectModel.text.element: ['AssetDepreciationAreaName']
       @UI.textArrangement: #TEXT_LAST
  key  faad_tr_simdoc.assetdepreciationarea          as AssetDepreciationArea,

  key  faad_tr_simdoc.fiscalyear                     as FiscalYear,

       @ObjectModel.text.element: ['SubLedgerAcctLineItemTypeName']
       @UI.textArrangement: #TEXT_LAST
  key  faad_tr_simdoc.subledgeracctlineitemtype      as SubLedgerAcctLineItemType,

  key  faad_tr_simdoc.transactionsubitem             as TransactionSubitem,

  key  faad_tr_simdoc.accountingdocumentitemref      as AccountingDocumentItemRef,

        @UI.hidden: true
        _LedgerText.LedgerName,

        @UI.hidden: true
        _DepreciationAreaText.AssetDepreciationAreaName,
 
        @UI.hidden: true
        _SubLedgerAccLineItemTypeText.SubLedgerAcctLineItemTypeName,

       faad_tr_simdoc.referencedocumenttype          as ReferenceDocumentType,

       faad_tr_simdoc.referencedocument              as ReferenceDocument,

       faad_tr_simdoc.referencedocumentcontext       as ReferenceDocumentContext,

       faad_tr_simdoc.logicalsystem                  as LogicalSystem,

       faad_tr_simdoc.glbusinesstransactiontype      as GLBusinessTransactionType,
       
       @ObjectModel.text.element: ['GLAccountLongName']
       @UI.textArrangement: #TEXT_LAST
       faad_tr_simdoc.glaccount                      as GLAccount,
       
       @UI.hidden: true
       _GLAccountText.GLAccountLongName,

       faad_tr_simdoc.postingdate                    as PostingDate,

       faad_tr_simdoc.assetvaluedate                 as AssetValueDate,

       faad_tr_simdoc.documentdate                   as DocumentDate,


       faad_tr_simdoc.fiscalperiod                   as FiscalPeriod,

       faad_tr_simdoc.debitcreditcode                as DebitCreditCode,

       faad_tr_simdoc.financialaccounttype           as FinancialAccountType,

       @Semantics.quantity.unitOfMeasure : 'BaseUnit'
       faad_tr_simdoc.quantity                       as Quantity,

       faad_tr_simdoc.baseunit                       as BaseUnit,

       faad_tr_simdoc.depreciationfiscalperiod       as DepreciationFiscalPeriod,

       @UI.hidden: true
       faad_tr_simdoc.assetaccttransclassfctn        as AssetAcctTransClassfctn,

       faad_tr_simdoc.assetclass                     as AssetClass,

       faad_tr_simdoc.assetaccountdetermination      as AssetAccountDetermination,

       faad_tr_simdoc.partnermasterfixedasset        as PartnerMasterFixedAsset,

       faad_tr_simdoc.partnerfixedasset              as PartnerFixedAsset,

       faad_tr_simdoc.referencedocumentitemgroup     as ReferenceDocumentItemGroup,

       faad_tr_simdoc.accountingdocumentitem         as AccountingDocumentItem,

       faad_tr_simdoc.isreversal                     as IsReversal,

       faad_tr_simdoc.isreversed                     as IsReversed,

       faad_tr_simdoc.issettlement                   as IsSettlement,

       faad_tr_simdoc.issettled                      as IsSettled,

       faad_tr_simdoc.predecessorreferencedoctype    as PredecessorReferenceDocType,

       faad_tr_simdoc.predecessorreferencedoccntxt   as PredecessorReferenceDocCntxt,

       faad_tr_simdoc.predecessorreferencedocument   as PredecessorReferenceDocument,

       faad_tr_simdoc.reversalreferencedocumentcntxt as ReversalReferenceDocumentCntxt,

       faad_tr_simdoc.reversalreferencedocument      as ReversalReferenceDocument,

       faad_tr_simdoc.reversaltransactionsubitem     as ReversalTransactionSubitem,

       faad_tr_simdoc.documentreferenceid            as DocumentReferenceID,

       faad_tr_simdoc.documentitemtext               as DocumentItemText,

       faad_tr_simdoc.tradingpartner                 as TradingPartner,

       faad_tr_simdoc.assignmentreference            as AssignmentReference,

       faad_tr_simdoc.offsettingaccount              as OffsettingAccount,

       faad_tr_simdoc.customer                       as Customer,

       faad_tr_simdoc.supplier                       as Supplier,

       @ObjectModel.text.element: ['FunctionalAreaName']
       @UI.textArrangement: #TEXT_LAST
       faad_tr_simdoc.functionalarea                 as FunctionalArea,
       
       @UI.hidden: true
       _FunctionalAreaText.FunctionalAreaName        as FunctionalAreaName,

       faad_tr_simdoc.controllingarea                as ControllingArea,

       faad_tr_simdoc.costcenter                     as CostCenter,

       faad_tr_simdoc.costctractivitytype            as CostCtrActivityType,

       faad_tr_simdoc.orderid                        as OrderID,

       faad_tr_simdoc.profitcenter                   as ProfitCenter,

       faad_tr_simdoc.segment                        as Segment,

       faad_tr_simdoc.partnerprofitcenter            as PartnerProfitCenter,
       
       @UI.hidden: true
       t001.fikrs                                    as FinancialManagementArea,
       
       @ObjectModel.text.element: ['FundName']
       @UI.textArrangement: #TEXT_LAST
       faad_tr_simdoc.fund                           as Fund,
       
       @UI.hidden: true
       _FundText.FundName                            as FundName,
       
       @ObjectModel.text.element: ['GrantName']
       @UI.textArrangement: #TEXT_LAST
       faad_tr_simdoc.grantid                        as GrantID,
       
       @UI.hidden: true
       _GrantText.GrantName                          as GrantName,
       
       faad_tr_simdoc.assetglpostingmethod           as AssetGLPostingMethod,
        
       faad_tr_simdoc.balancetransactioncurrency     as BalanceTransactionCurrency,
       @Semantics.amount.currencyCode : 'BalanceTransactionCurrency'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinbalancetransaccrcy     as AmountInBalanceTransacCrcy,

       faad_tr_simdoc.transactioncurrency            as TransactionCurrency,

       @Semantics.amount.currencyCode : 'TransactionCurrency'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountintransactioncurrency    as AmountInTransactionCurrency,

       faad_tr_simdoc.companycodecurrency            as CompanyCodeCurrency,
       @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountincompanycodecurrency    as AmountInCompanyCodeCurrency,

       faad_tr_simdoc.globalcurrency                 as GlobalCurrency,
       @Semantics.amount.currencyCode : 'GlobalCurrency'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinglobalcurrency         as AmountInGlobalCurrency,

       faad_tr_simdoc.functionalcurrency             as FunctionalCurrency,
       @Semantics.amount.currencyCode : 'FunctionalCurrency'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfunctionalcurrency     as AmountInFunctionalCurrency,

       faad_tr_simdoc.freedefinedcurrency1           as FreeDefinedCurrency1,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency1'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency1   as AmountInFreeDefinedCurrency1,

       faad_tr_simdoc.freedefinedcurrency2           as FreeDefinedCurrency2,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency2'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency2   as AmountInFreeDefinedCurrency2,

       faad_tr_simdoc.freedefinedcurrency3           as FreeDefinedCurrency3,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency3'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency3   as AmountInFreeDefinedCurrency3,

       faad_tr_simdoc.freedefinedcurrency4           as FreeDefinedCurrency4,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency4'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency4   as AmountInFreeDefinedCurrency4,

       faad_tr_simdoc.freedefinedcurrency5           as FreeDefinedCurrency5,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency5'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency5   as AmountInFreeDefinedCurrency5,

       faad_tr_simdoc.freedefinedcurrency6           as FreeDefinedCurrency6,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency6'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency6   as AmountInFreeDefinedCurrency6,

       faad_tr_simdoc.freedefinedcurrency7           as FreeDefinedCurrency7,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency7'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency7   as AmountInFreeDefinedCurrency7,

       faad_tr_simdoc.freedefinedcurrency8           as FreeDefinedCurrency8,
       @Semantics.amount.currencyCode : 'FreeDefinedCurrency8'
       @Aggregation.default: #SUM
       faad_tr_simdoc.amountinfreedefinedcurrency8   as AmountInFreeDefinedCurrency8,
       
       faad_tr_post.businesstransactiontype          as BusinessTransactionType,
       
       faad_tr_post.businesstransactioncategory      as BusinessTransactionCategory,
//        @ObjectModel.virtualElement: true

//        @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FAA_POST_BO_FC_EXIT' 

//      cast ( '' as abap.char(1) )                    as SimlFieldsQuantityTrIsHidden,

       //       _BalanceTransactionCurrency,

       //       _TransactionCurrency,

       //       _CompanyCodeCurrency,

       //       _GlobalCurrency,

       //       _FunctionalCurrency,

       //       _FreeDefinedCurrency1,

       //       _FreeDefinedCurrency2,

       //       _FreeDefinedCurrency3,

       //       _FreeDefinedCurrency4,

       //       _FreeDefinedCurrency5,

       //       _FreeDefinedCurrency6,

       //       _FreeDefinedCurrency7,

       //       _FreeDefinedCurrency8,

       //

       //

       //       _FixedAssetPosting : redirected to parent C_FixedAssetPostingTP

       _FixedAssetPosting
}

where faad_tr_simdoc.draftentityoperationcode = 'C'
//  and not ( faad_tr_simdoc.assetaccttransclassfctn is initial and 

//            ( faad_tr_simdoc.subledgeracctlineitemtype = '07900' or faad_tr_simdoc.subledgeracctlineitemtype = '07940' ) 

//           )