I_FinPostingClearingItem

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Posting and Clearing Service Item'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:#MIXED
@Metadata.ignorePropagatedAnnotations: true

define view entity I_FinPostingClearingItem
  as select from I_OperationalAcctgDocItem //Posted document


  association [0..*] to I_DunningKeyText            as _DunningKeyText            on  $projection.DunningKey = _DunningKeyText.DunningKey
  association [0..*] to I_DunningBlockingReasonText as _DunningBlockingReasonText on  $projection.DunningBlockingReason = _DunningBlockingReasonText.DunningBlockingReason
  association [0..*] to I_DunningAreaText           as _DunningAreaText           on  $projection.DunningArea = _DunningAreaText.DunningArea
                                                                                  and $projection.CompanyCode = _DunningAreaText.CompanyCode
{
  key cast ( hextobin('00000000000000000000000000000000') as fdc_dft_key preserving type ) as PostingClearingDocumentUUID,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
  key FiscalYear,
  key AccountingDocument,
  key AccountingDocumentItem,
  key cast('0000000000' as posnr_acc preserving type )                                     as PostingClearingDocumentTmpItem,

      /* BSEG fields */
      AccountingDocumentItemType, //288

      ClearingDate,
      ClearingCreationDate,
      ClearingJournalEntryFiscalYear,
      ClearingJournalEntry,
      PostingKey, 
      FinancialAccountType,
      SpecialGLCode,
      SpecialGLTransactionType, //318

      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      DebitCreditCode, //324

      TaxCode,         //327

      TaxCountry, 
      TaxRateValidityStartDate,     //331

      TransactionTypeDetermination, //341

      AssignmentReference, //344

      DocumentItemText, //345

      ControllingArea,  //358

      CostCenter,       //360

      OrderID,          //369

      SalesDocument,    //372

      ServiceDocumentType, //383

      ServiceDocument, //390

      MasterFixedAsset, //400

      FixedAsset,       //402

      OperationalGLAccount, //435

      GLAccount,
      @ObjectModel.foreignKey.association: '_Customer'
      Customer,
      Supplier, //441

      IsBalanceSheetAccount, //444

      SpecialGLAccountAssignment, //446

      DueCalculationBaseDate, //447

      DunningKey, //488

      DunningBlockingReason, //489

      DunningArea,      //492

      ValuationArea,    //516

      PaymentDifferenceReason, //532

      ProfitCenter,     //536

      CompanyCodeCurrencyDetnMethod,  //588

      TaxDeterminationDate, //632

      FunctionalArea,   //657

      Segment,          //666

      PostingDate,      //688

      AccountingDocumentType, //691

      NetDueDate,             //692

      CompanyCodeCurrency, //770

      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      AmountInCompanyCodeCurrency, //774

      TransactionCurrency,         //848

      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      AmountInTransactionCurrency, //852

      BalanceTransactionCurrency,  //934

      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      AmountInBalanceTransacCrcy,
      AdditionalCurrency1,         //943

      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      AmountInAdditionalCurrency1, //954

      AdditionalCurrency2,         //987

      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      AmountInAdditionalCurrency2, //991



      /* Foreign Key Associations */
      _AccountingDocumentType, //1103

      _CurrentCostCenter, //1137

      _CurrentProfitCenter,
      _Customer,   //1139

      _FixedAsset, //1162

      _Order,      //1194

      _SalesDoc,   //1233

      _Supplier,   //1249

      _CompanyCode, //1260

      _ServiceDocument, //1279

      _DebitCreditCode, //1281


      /* Text Associations */
      _DunningKeyText,
      _DunningBlockingReasonText,
      _DunningAreaText
}