P_ReceivablesItem1

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PFIRECITEM1'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ReceivablesItem1

  as select from    I_ReceivablesPayablesItem
  
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key AccountingDocument,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key FiscalYear,
  key AccountingDocumentItem,

      cast( concat(concat(CompanyCode, AccountingDocument), concat(FiscalYear, AccountingDocumentItem)) as swo_typeid ) as DisputeCaseObjectKey,
      @ObjectModel.foreignKey.association: '_FiscalYearVariant'
      FiscalYearVariant,
      ClearingDate,
      ClearingCreationDate,
      ClearingAccountingDocument,
      PostingKey,
      FinancialAccountType,
      SpecialGLCode,
      SpecialGLTransactionType,
      TargetSpecialGLCode,
      DebitCreditCode,
      BusinessArea,
      PartnerBusinessArea,
      TaxCode,
      WithholdingTaxCode,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      AmountInCompanyCodeCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      AmountInTransactionCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'BalanceTransactionCurrency'
      AmountInBalanceTransacCrcy,
      @Semantics.currencyCode: true
      BalanceTransactionCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      TaxAmountInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TaxAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TaxBaseAmountInTransCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      TaxBaseAmountInCoCodeCrcy,
      TaxType,
      TaxItemGroup,
      TransactionTypeDetermination,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      WithholdingTaxBaseAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      ValuationDiffAmtInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode:'AdditionalCurrency1'
      ValuationDiffAmtInAddlCrcy1,
      ValueDate,
      AssignmentReference,
      DocumentItemText,
      PartnerCompany,
      FinancialTransactionType,
      CorporateGroupAccount,
      PlanningLevel,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      PlannedAmtInTransactionCrcy,
      ControllingArea,
      CostCenter,
      OrderID,
      BillingDocument,
      SalesDocument,
      SalesDocumentItem,
      ScheduleLine,
      MasterFixedAsset,
      FixedAsset,
      AssetTransactionType,
      IsSalesRelated,
      LineItemDisplayIsEnabled,
      IsOpenItemManaged,
      AddressAndBankIsSetManually,
      IsAutomaticallyCreated,
      IsUsedInPaymentTransaction,
      GLAccount,
      Debtor,
      Creditor,
      IsBalanceSheetAccount,
      ProfitLossAccountType,
      SpecialGLAccountAssignment,
      DueCalculationBaseDate,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CashDiscountBaseAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CashDiscountAmtInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CashDiscountAmount,
      PaymentMethod,
      PaymentBlockingReason,
      FixedCashDiscount,
      HouseBank,
      TaxDistributionCode1,
      TaxDistributionCode2,
      TaxDistributionCode3,
      InvoiceReference,
      InvoiceReferenceFiscalYear,
      InvoiceItemReference,
      FollowOnDocumentType,
      SupplyingCountry,
      InvoiceList,
      SettlementFiscalYearPeriod,
      BillOfExchangeUsage,
      DunningKey,
      DunningBlockingReason, //FieldGroup: DunningGroup

      LastDunningDate, //FieldGroup: DunningGroup

      DunningLevel,
      DunningArea,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      WithholdingTaxAmount,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      WithholdingTaxExemptionAmt,
      Material,
      Plant,
      @DefaultAggregation:#SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      Quantity,
      @Semantics.unitOfMeasure: true
      BaseUnit,
      @DefaultAggregation:#SUM
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      EntryUnit,
      @DefaultAggregation:#SUM
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderPriceUnit'
      PurchaseOrderQty,
      @Semantics.unitOfMeasure: true
      PurchaseOrderPriceUnit,
      PurchasingDocument,
      PurchasingDocumentItem,
      AccountAssignmentNumber,
      IsCompletelyDelivered,
      MaterialPriceControl,
      MaterialPriceUnitQty,
      ValuationArea,
      InventoryValuationType,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      InvoiceAmtInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      InvoiceAmountInFrgnCurrency,
      VATRegistration,
      DelivOfGoodsDestCountry,
      DelivOfGoodsOriginCountry,
      PaymentDifferenceReason,
      ProfitCenter,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityGroup,
      TreasuryContractType,
      AssetContract,
      CashFlowType,
      TaxJurisdiction,
      RealEstateObject,
      SettlementReferenceDate,
      CostObject,
      ProjectNetwork,
      WBSElement,
      ProfitabilitySegment,
      JointVentureEquityType,
      IsEUTriangularDeal,
      CostOriginGroup,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency1'
      AmountInAdditionalCurrency1,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      AmountInAdditionalCurrency2,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'AdditionalCurrency2'
      ValuationDiffAmtInAddlCrcy2,
      ClearingIsReversed,
      PaymentMethodSupplement,
      AlternativeGLAccount,
      FundsCenter,
      Fund,
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,
      PaymentCardItem,
      PaymentCardPaymentSettlement,

      CreditControlArea,
      Reference3IDByBusinessPartner,
      DataExchangeInstruction1,
      DataExchangeInstruction2,
      DataExchangeInstruction3,
      DataExchangeInstruction4,
      Region,
      HasPaymentOrder,
      PaymentReference,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      HedgedAmount,
      TaxDeterminationDate,
      ClearingItem,
      @Semantics.currencyCode: true
      PaymentCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'PaymentCurrency'
      AmountInPaymentCurrency,
      BusinessPlace,
      TaxSection,
      CostCtrActivityType,
      AccountsReceivableIsPledged,
      BusinessProcess,
      GrantID,
      FunctionalArea,
      CustomerIsInExecution,
      ClearingDocFiscalYear,
      Segment,
      PartnerSegment,
      PartnerFunctionalArea,
      HouseBankAccount,
      CostElement,
      ReferenceDocumentType,
      OriginalReferenceDocument,
      ReferenceDocumentLogicalSystem,
      FiscalPeriod,
      AccountingDocumentCategory,
      PostingDate,
      DocumentDate,
      @Semantics.currencyCode: true
      TransactionCurrency,
      AccountingDocumentType,
      @Semantics.currencyCode: true
      CompanyCodeCurrency,
      @Semantics.currencyCode: true
      AdditionalCurrency1,
      @Semantics.currencyCode: true
      AdditionalCurrency2,
      NetDueDate,
      CashDiscount1DueDate,
      CashDiscount2DueDate,
      OffsettingAccount,
      OffsettingAccountType,
      PartnerFund,
      PartnerGrant,
      BudgetPeriod,
      PartnerBudgetPeriod,
      BPBankAccountInternalID,

      _CompanyCode,
      _CompanyCodeCurrency,
      _PostingKey,
      _FinancialAccountType,
      _SpecialGLCode,
      _TargetSpecialGLCode,
      _DebitCreditCode,
      _BusinessArea,
      _PartnerBusinessArea,
      _BalanceTransactionCurrency,
      _FinancialTransactionType,
      _CorporateGroupAccount,
      _ControllingArea,
      _CostCenter,
      _SalesDocumentItem,

      _GLAccount,
      _PaymentBlockingReason,
      _SupplyingCountry,
      _BillOfExchangeUsage,
      _DunningKey,
      _DunningBlockingReasonCode,
      _DunningArea,
      _Material,
      _BaseUnit,
      _EntryUnit,
      _PurchaseOrderPriceUnit,
      _PaymentDifferenceReason,
      _ProfitCenter,
      _AlternativeGLAccount,
      _Segment,
      _PartnerSegment,
      _PartnerProfitCenter,
      _JournalEntry,
      _Customer,
      _Supplier,
      _FiscalYear,
      _FiscalYearVariant
}
where FinancialAccountType = 'D'                                                                                         
  

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECEIVABLESPAYABLESITEM"
],
"ASSOCIATED":
[
"I_BILLOFEXCHANGEUSAGE",
"I_BUSINESSAREA",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMER",
"I_DEBITCREDITCODE",
"I_DUNNINGAREA",
"I_DUNNINGBLOCKINGREASONCODE",
"I_DUNNINGKEY",
"I_FINANCIALACCOUNTTYPE",
"I_FINANCIALTRANSACTIONTYPE",
"I_FISCALYEAR",
"I_FISCALYEARVARIANT",
"I_GLACCOUNT",
"I_JOURNALENTRY",
"I_MATERIAL",
"I_PAYMENTBLOCKINGREASON",
"I_PAYMENTDIFFERENCEREASON",
"I_POSTINGKEY",
"I_PROFITCENTER",
"I_SALESDOCUMENTITEM",
"I_SEGMENT",
"I_SPECIALGLCODE",
"I_SUPPLIER",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_RECEIVABLESPAYABLESITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/