P_DebtorCreditorRblsPyblsItem

@AbapCatalog.sqlViewName: 'PDRCRRBPAYITM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@VDM.private: true

define view P_DebtorCreditorRblsPyblsItem as select from I_OperationalAcctgDocItem
            inner join P_FirstDbtrCrdtrRblsPyblsItem on
            I_OperationalAcctgDocItem.CompanyCode               = P_FirstDbtrCrdtrRblsPyblsItem.CompanyCode and
            I_OperationalAcctgDocItem.AccountingDocument        = P_FirstDbtrCrdtrRblsPyblsItem.AccountingDocument and
            I_OperationalAcctgDocItem.FiscalYear                = P_FirstDbtrCrdtrRblsPyblsItem.FiscalYear and
            I_OperationalAcctgDocItem.AccountingDocumentItem    = P_FirstDbtrCrdtrRblsPyblsItem.AccountingDocumentItem
 {
      
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_OperationalAcctgDocItem.CompanyCode,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key I_OperationalAcctgDocItem.AccountingDocument,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key I_OperationalAcctgDocItem.FiscalYear,
  key I_OperationalAcctgDocItem.AccountingDocumentItem,
  
   
      ChartOfAccounts,
      AccountingDocumentItemType,
      ClearingDate,
      ClearingCreationDate,
      
@API.element.releaseState: #DEPRECATED
@API.element.successor:    'ClearingJournalEntry'      
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntry' 
@ObjectModel.foreignKey.association: '_ClearingAccountingDocument'
ClearingAccountingDocument,
@API.element.releaseState: #DEPRECATED
@API.element.successor:    'ClearingJournalEntryFiscalYear'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'ClearingJournalEntryFiscalYear'
ClearingDocFiscalYear,

@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJournalEntry'
ClearingJournalEntry,
@Analytics.internalName: #LOCAL
@ObjectModel.foreignKey.association: '_ClearingJrnlEntryFiscalYear'
ClearingJournalEntryFiscalYear,       
      
      @ObjectModel.foreignKey.association: '_PostingKey'
      PostingKey,
      @ObjectModel.foreignKey.association: '_FinancialAccountType'
      FinancialAccountType,
      @ObjectModel.foreignKey.association: '_SpecialGLCode'
      SpecialGLCode,
       SpecialGLTransactionType,
      @ObjectModel.foreignKey.association: '_DebitCreditCode'
      DebitCreditCode,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      BusinessArea,
      @ObjectModel.foreignKey.association: '_PartnerBusinessArea'
      PartnerBusinessArea,
//      @ObjectModel.foreignKey.association: '_TaxCode'

      TaxCode,
      WithholdingTaxCode,
      @ObjectModel.foreignKey.association: '_TaxType'
      TaxType,
      TaxItemGroup,
      TransactionTypeDetermination,
      
      ValueDate,
      AssignmentReference,
      DocumentItemText,
      @ObjectModel.foreignKey.association: '_PartnerCompany'
      PartnerCompany,
      @ObjectModel.foreignKey.association: '_FinancialTransactionType'
      FinancialTransactionType,
      CorporateGroupAccount,
      PlanningLevel,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      ControllingArea,
      @ObjectModel.foreignKey.association: '_CostCenter'
      CostCenter,
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: ''      
      Project,
      @ObjectModel.foreignKey.association: '_Order'
      OrderID,      
      BillingDocument,
      @ObjectModel.foreignKey.association: '_SalesDoc'
      SalesDocument,
      @ObjectModel.foreignKey.association: '_SalesDocItem'
      SalesDocumentItem,      
      ScheduleLine,
      @ObjectModel.foreignKey.association: '_MasterFixedAsset'
      MasterFixedAsset,
      @ObjectModel.foreignKey.association: '_FixedAsset'
      FixedAsset,
      @ObjectModel.foreignKey.association: '_AssetTransactionType'
      AssetTransactionType,
      AssetValueDate,
      @ObjectModel.foreignKey.association: '_Employment'      
      PersonnelNumber,
      IsSalesRelated,
      LineItemDisplayIsEnabled,
      IsOpenItemManaged,
      IsNotCashDiscountLiable,
      IsAutomaticallyCreated,
      IsUsedInPaymentTransaction,
      OperationalGLAccount,
      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      GLAccount,
      @ObjectModel.foreignKey.association: '_Customer'
      Customer,
      @ObjectModel.foreignKey.association: '_Supplier'
      Supplier,
      BranchAccount,
      IsBalanceSheetAccount,
      ProfitLossAccountType,
      SpecialGLAccountAssignment,
      DueCalculationBaseDate,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      PaymentMethod,
      PaymentBlockingReason,
      FixedCashDiscount,
      @ObjectModel.foreignKey.association: '_HouseBank'
      HouseBank,
      @ObjectModel.foreignKey.association: '_SupplierBankDetails'
      BPBankAccountInternalID,
      TaxDistributionCode1,
      TaxDistributionCode2,
      TaxDistributionCode3,
      InvoiceReference,
      InvoiceReferenceFiscalYear,
      InvoiceItemReference,
      FollowOnDocumentType,
      StateCentralBankPaymentReason,
      @ObjectModel.foreignKey.association: '_SupplyingCountry'
      SupplyingCountry,
      InvoiceList,
      BillOfExchangeUsage,
      DunningKey,
      DunningBlockingReason,
      LastDunningDate,
      DunningLevel,
      DunningArea,
      WithholdingTaxCertificate,
      @ObjectModel.foreignKey.association: '_Product'
      Product,
@ObjectModel.foreignKey.association: '_Material'
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'Product'
      Material,
      @ObjectModel.foreignKey.association: '_Plant'
      Plant,
      @ObjectModel.foreignKey.association: '_PurchasingDocument'
      PurchasingDocument,
      @ObjectModel.foreignKey.association: '_PurchasingDocumentItem'
      PurchasingDocumentItem,
      AccountAssignmentNumber,
      IsCompletelyDelivered,
      MaterialPriceControl,
      @ObjectModel.foreignKey.association: '_ValuationArea'
      ValuationArea,
      @ObjectModel.foreignKey.association: '_InventoryValuationType'
      InventoryValuationType,
      VATRegistration,
      DelivOfGoodsDestCountry,
      @ObjectModel.foreignKey.association: '_PaymentDifferenceReason'
      PaymentDifferenceReason,
      @ObjectModel.foreignKey.association: '_ProfitCenter'
      ProfitCenter,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityGroup,
      TreasuryContractType,
      AssetContract,
      CashFlowType,
      TaxJurisdiction,
      REInternalFinNumber,
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'REInternalFinNumber'
      RealEstateObject,
      SettlementReferenceDate,
      CommitmentItemShortID,
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'CommitmentItemShortID'
      CommitmentItem,
      CostObject,
      @ObjectModel.foreignKey.association: '_ProjectNetwork'      
      ProjectNetwork,
      OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
      @ObjectModel.foreignKey.association: '_WBSElementInternalID'
      WBSElementInternalID,
      ProfitabilitySegment_2 as ProfitabilitySegment,
      JointVentureEquityType,
      IsEUTriangularDeal,
//      @ObjectModel.foreignKey.association: '_CostOriginGroup'

      CostOriginGroup,
      CompanyCodeCurrencyDetnMethod,
      ClearingIsReversed,
      PaymentMethodSupplement,
//      @ObjectModel.foreignKey.association: '_AlternativeGLAccount'

      AlternativeGLAccount,
//      @ObjectModel.foreignKey.association: '_FundsCenter'

      FundsCenter,
//      @ObjectModel.foreignKey.association: '_Fund'

      Fund,
      @ObjectModel.foreignKey.association: '_PartnerProfitCenter'
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,
      EarmarkedFundsDocument,
      EarmarkedFundsDocumentItem,
      IsNegativePosting,
      PaymentCardItem,
      PaymentCardPaymentSettlement,
      CreditControlArea,
      
      Reference3IDByBusinessPartner,
      DataExchangeInstruction1,
      DataExchangeInstruction2,
      DataExchangeInstruction3,
      DataExchangeInstruction4,
      Region,
      HasPaymentOrder,
      PaymentReference,
      TaxDeterminationDate,
      ClearingItem,
      BusinessPlace,
      TaxSection,
      @ObjectModel.foreignKey.association: '_CostCtrActivityType'
      CostCtrActivityType,
      AcctsReceivablePledgingCode,
@VDM.lifecycle.status:    #DEPRECATED
@VDM.lifecycle.successor: 'AcctsReceivablePledgingCode'      
      AccountsReceivableIsPledged,
      @ObjectModel.foreignKey.association: '_BusinessProcess'
      BusinessProcess,
      GrantID,
      @ObjectModel.foreignKey.association: '_FunctionalArea'
      FunctionalArea,
      CustomerIsInExecution,
      FundedProgram,
      LedgerGLLineItem,
      @ObjectModel.foreignKey.association: '_Segment'
      Segment,
      @ObjectModel.foreignKey.association: '_PartnerSegment'
      PartnerSegment,
      @ObjectModel.foreignKey.association: '_PartnerFunctionalArea'
      PartnerFunctionalArea,
      @ObjectModel.foreignKey.association: '_HouseBankAccount'
      HouseBankAccount,
      CostElement,
      SEPAMandate,
      @ObjectModel.foreignKey.association: '_ReferenceDocumentType'
      ReferenceDocumentType,
      OriginalReferenceDocument,
      ReferenceDocumentLogicalSystem,
      AccountingDocumentItemRef,
      @ObjectModel.foreignKey.association: '_FiscalPeriod'
      FiscalPeriod,
      @ObjectModel.foreignKey.association: '_AccountingDocumentCategory'
      AccountingDocumentCategory,
      PostingDate,
      DocumentDate,
      @ObjectModel.foreignKey.association: '_AccountingDocumentType'
      AccountingDocumentType,
      NetDueDate,
      CashDiscount1DueDate,
      CashDiscount2DueDate,
      @ObjectModel.foreignKey.association: '_OffsettingAccount'
      OffsettingAccount,
      @ObjectModel.foreignKey.association: '_OffsettingAccountType'
      OffsettingAccountType,
//      @ObjectModel.foreignKey.association: '_PartnerFund'

      PartnerFund,
      PartnerGrant,
      @ObjectModel.foreignKey.association: '_BudgetPeriod'
      BudgetPeriod,
      PartnerBudgetPeriod,
      BranchCode,
      @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
      @Semantics.currencyCode:true
      CompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      AmountInCompanyCodeCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      TaxAmountInCoCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      TaxBaseAmountInCoCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      ValuationDiffAmtInCoCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      CashDiscountAmtInCoCodeCrcy,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      InvoiceAmtInCoCodeCrcy,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      @Semantics.currencyCode:true
      TransactionCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      AmountInTransactionCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      OriginalTaxBaseAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      TaxAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      TaxBaseAmountInTransCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxBaseAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      PlannedAmtInTransactionCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      CashDiscountBaseAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      CashDiscountAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      NetPaymentAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxAmount,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      WithholdingTaxExemptionAmt,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
      InvoiceAmountInFrgnCurrency,

      @ObjectModel.foreignKey.association: '_BalanceTransactionCurrency'
      @Semantics.currencyCode:true
      BalanceTransactionCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'BalanceTransactionCurrency'} }
      AmountInBalanceTransacCrcy,


      @ObjectModel.foreignKey.association: '_AdditionalCurrency1'
      @Semantics.currencyCode:true
      AdditionalCurrency1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      ValuationDiffAmtInAddlCrcy1,



      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency1'} }
      AmountInAdditionalCurrency1,

      @ObjectModel.foreignKey.association: '_AdditionalCurrency2'
      @Semantics.currencyCode:true
      AdditionalCurrency2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      AmountInAdditionalCurrency2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'AdditionalCurrency2'} }
      ValuationDiffAmtInAddlCrcy2,

      @ObjectModel.foreignKey.association: '_PaymentCurrency'
      @Semantics.currencyCode:true
      PaymentCurrency,
      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'PaymentCurrency'} }
      AmountInPaymentCurrency,

      @ObjectModel.foreignKey.association: '_CreditControlAreaCurrency'
      @Semantics.currencyCode:true
      CreditControlAreaCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CreditControlAreaCurrency'} }
      HedgedAmount,

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

      @ObjectModel.foreignKey.association: '_GoodsMovementEntryUnit'
      @Semantics.unitOfMeasure:true
      GoodsMovementEntryUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'GoodsMovementEntryUnit'} }
      QuantityInEntryUnit,

      @ObjectModel.foreignKey.association: '_PurchasingDocumentPriceUnit'
      @Semantics.unitOfMeasure:true
      PurchasingDocumentPriceUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'PurchasingDocumentPriceUnit'} }
      PurchaseOrderQty,
      MaterialPriceUnitQty,
      @DefaultAggregation: #SUM
      NumberOfItems,
      
      _JournalEntry,
      _CompanyCode,
      _FiscalYear,
      _ControllingArea,
      _GLAccountInChartOfAccounts,
      _GLAccountInCompanyCode,      
      _ProfitCenter,
      _Segment,
      _CostCenter,
      _Customer,
      _OneTimeAccountBP,
      _Supplier,
      _ChartOfAccounts,
      _AccountingDocumentType,
      _FinancialAccountType,
      _FunctionalArea,
      _BusinessArea,
      _CompanyCodeCurrency,
      _TransactionCurrency,
      _BalanceTransactionCurrency,
      _AdditionalCurrency1,
      _AdditionalCurrency2,
      _PaymentCurrency,
      _CreditControlAreaCurrency,
      _Material,
      _Product,
      _Plant,
      _BaseUnit,
      _GoodsMovementEntryUnit,
      _PurchasingDocumentPriceUnit,
      _InternalOrder,
      _Order,
      _WBSElementBasicData,
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  '_WBSElementBasicData'
      _WBSElementInternalID,

      _AccountingDocumentCategory,

      _PostingKey,
      _DebitCreditCode,
      _PartnerBusinessArea,
      _TaxType,
      _PartnerCompany,
      _SupplyingCountry,
      _InventoryValuationType,
      _PaymentDifferenceReason,
      _PartnerSegment,
      _SupplierBankDetails,

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

      _SpecialGLCode,
      _TaxCode,
      _FinancialTransactionType,
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  '_SalesDoc'
      _SalesDocument,
      @VDM.lifecycle.status:     #DEPRECATED
      @VDM.lifecycle.successor:  '_SalesDocItem'
      _SalesDocumentItem,
      _SalesDoc,
      _SalesDocItem,
      _MasterFixedAsset,
      _FixedAsset,
      _AssetTransactionType,
      _Employment,
      _HouseBank,
      _PurchasingDocument,
      _PurchasingDocumentItem,
      _ValuationArea,
      _ProjectNetwork,
      _CostOriginGroup,
//      _AlternativeGLAccount,

//      _Fund,

//      _PartnerFund,

//      _FundsCenter,

      _PartnerProfitCenter,
      _CostCtrActivityType,
      _BusinessProcess,
      _PartnerFunctionalArea,
      _HouseBankAccount,
      _FiscalPeriod,
      _ReferenceDocumentType,
      _OffsettingAccount,
      _OffsettingAccountType,      
      _BudgetPeriod        
}