P_CcpCustLineItem

@AbapCatalog.sqlViewName: 'PCCPCSTLNITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private:true
@VDM.viewType: #COMPOSITE

@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'CCP customer line items'


define view P_CcpCustLineItem
  as select from I_OperationalAcctgDocItem

{
  key CompanyCode                                  as bukrs,
  key FiscalYear                                   as gjahr,
  key AccountingDocument                           as belnr,
  key AccountingDocumentItem                       as buzei,

      Customer                                     as kunnr,
      SpecialGLTransactionType                     as umsks,
      SpecialGLCode                                as umskz,
      ClearingDate                                 as augdt,
      ClearingJournalEntry                         as augbl,
      AssignmentReference                          as zuonr,

      PostingDate                                  as budat,
      DocumentDate                                 as bldat,
      @Semantics.currencyCode:true
      TransactionCurrency                          as waers,
      _JournalEntry.DocumentReferenceID            as xblnr,
      AccountingDocumentType                       as blart,
      FiscalPeriod                                 as monat,
      PostingKey                                   as bschl,
      DebitCreditCode                              as shkzg,
      BusinessArea                                 as gsber,
      TaxCode                                      as mwskz,

      @Semantics.currencyCode:true
      CompanyCodeCurrency                          as hwaer,
      @Semantics: { amount : {currencyCode: 'hwaer'} }
      AmountInCompanyCodeCurrency                  as dmbtr,
      @Semantics: { amount : {currencyCode: 'waers'} }
      AmountInTransactionCurrency                  as wrbtr,

      @Semantics: { amount : {currencyCode: 'hwaer'} }
      TaxAmountInCoCodeCrcy                        as mwsts,
      @Semantics: { amount : {currencyCode: 'waers'} }
      TaxAmount                                    as wmwst,

      @Semantics: { amount : {currencyCode: 'hwaer'} }
      ValuationDiffAmtInCoCodeCrcy                 as bdiff,

      @Semantics.currencyCode:true
      AdditionalCurrency1                          as hwae2,
      @Semantics.currencyCode:true
      AdditionalCurrency2                          as hwae3,

      @Semantics: { amount : {currencyCode: 'hwae2'} }
      ValuationDiffAmtInAddlCrcy1                  as bdif2,
      DocumentItemText                             as sgtxt,
      Project                                      as projn,
      OrderID                                      as aufnr,
      MasterFixedAsset                             as anln1,
      FixedAsset                                   as anln2,
      OperationalGLAccount                         as saknr,
      GLAccount                                    as hkont,
      BranchAccount                                as filkd,
      DueCalculationBaseDate                       as zfbdt,
      PaymentTerms                                 as zterm,
      CashDiscount1Days                            as zbd1t,
      CashDiscount2Days                            as zbd2t,
      NetPaymentDays                               as zbd3t,
      CashDiscount1Percent                         as zbd1p,
      CashDiscount2Percent                         as zbd2p,
      CashDiscount1DueDate                         as sk1dt, //Cash discount due date1

      CashDiscount2DueDate                         as sk2dt, //Cash discount due date2

      NetDueDate                                   as netdt, //Net due date

      @Semantics: { amount : {currencyCode: 'waers'} }
      CashDiscountBaseAmount                       as skfbt,
      @Semantics: { amount : {currencyCode: 'hwaer'} }
      CashDiscountAmtInCoCodeCrcy                  as sknto,
      @Semantics: { amount : {currencyCode: 'waers'} }
      CashDiscountAmount                           as wskto,
      PaymentMethod                                as zlsch,
      PaymentBlockingReason                        as zlspr,
      FixedCashDiscount                            as zbfix,
      HouseBank                                    as hbkid,
      BPBankAccountInternalID                      as bvtyp,
      InvoiceReference                             as rebzg,
      InvoiceReferenceFiscalYear                   as rebzj,
      InvoiceItemReference                         as rebzz,
      InvoiceList                                  as samnr,
      DunningBlockingReason                        as mansp,
      DunningKey                                   as mschl,
      LastDunningDate                              as madat,
      DunningLevel                                 as manst,
      DunningArea                                  as maber,
      IsUsedInPaymentTransaction                   as xzahl,
      TaxDistributionCode1                         as mwsk1,
      TaxDistributionCode2                         as mwsk2,
      TaxDistributionCode3                         as mwsk3,
      AccountingDocumentCategory                   as bstat,
      PartnerCompany                               as vbund,
      BillingDocument                              as vbeln,
      FollowOnDocumentType                         as rebzt,
      VATRegistration                              as stceg,
      DelivOfGoodsDestCountry                      as egbld,
      PaymentDifferenceReason                      as rstgr,
      TreasuryContractType                         as vertt,
      AssetContract                                as vertn,
      CashFlowType                                 as vbewa,
      BillOfExchangeUsage                          as wverw,
      WBSElementInternalID                         as projk,
      CommitmentItem                               as fipos,
      ProjectNetwork                               as nplnr,
      OrderInternalBillOfOperations                as aufpl,
      OrderIntBillOfOperationsItem                 as aplzl,
      IsEUTriangularDeal                           as xegdr,

      @Semantics: { amount : {currencyCode: 'hwae2'} }
      AmountInAdditionalCurrency1                  as dmbe2,
      @Semantics: { amount : {currencyCode: 'hwae3'} }
      AmountInAdditionalCurrency2                  as dmbe3,
      @Semantics: { amount : {currencyCode: 'hwae3'} }
      ValuationDiffAmtInAddlCrcy2                  as bdif3,
      ClearingIsReversed                           as xragl,
      PaymentMethodSupplement                      as uzawe,
      _JournalEntry.ReversalIsPlanned              as xstov,
      Reference1IDByBusinessPartner                as xref1,
      Reference2IDByBusinessPartner                as xref2,
      @Semantics.currencyCode:true
      BalanceTransactionCurrency                   as pswsl,
      @Semantics: { amount : {currencyCode: 'pswsl'} }
      AmountInBalanceTransacCrcy                   as pswbt,
      StateCentralBankPaymentReason                as lzbkz,
      SupplyingCountry                             as landl,
      RealEstateObject                             as imkey,
      SalesDocument                                as vbel2,
      SalesDocumentItem                            as posn2,
      ScheduleLine                                 as eten2,
      FundsCenter                                  as fistl,
      Fund                                         as geber,
      SettlementReferenceDate                      as dabrz,
      IsNegativePosting                            as xnegp,
      CostCenter                                   as kostl,
      PaymentCardItem                              as rfzei,
      CreditControlArea                            as kkber,
      ProfitCenter                                 as prctr,
      Reference3IDByBusinessPartner                as xref3,
      WithholdingTaxCode                           as qsskz,
      DataExchangeInstruction1                     as dtws1,
      DataExchangeInstruction2                     as dtws2,
      DataExchangeInstruction3                     as dtws3,
      DataExchangeInstruction4                     as dtws4,
      HasPaymentOrder                              as xpypr,
      PaymentReference                             as kidno,

      @Semantics.currencyCode:true
      CreditControlAreaCurrency                    as t014_waers,
      @Semantics: { amount : {currencyCode: 't014_waers'} }
      HedgedAmount                                 as absbt,
      PaymentCardPaymentSettlement                 as ccbtc,
      @Semantics.currencyCode:true
      PaymentCurrency                              as pycur,
      @Semantics: { amount : {currencyCode: 'pycur'} }
      AmountInPaymentCurrency                      as pyamt,
      BusinessPlace                                as bupla,
      TaxSection                                   as secco,
      AccountsReceivableIsPledged                  as cession_kz,
      GrantID                                      as grant_nbr,
      CustomerIsInExecution                        as gmvkz,
      cast(case FunctionalArea when ' '
        then ''
        else FunctionalArea
      end as fkber preserving type)                as fkber,
      PartnerProfitCenter                          as pprct,
      AccountingDocumentItemType                   as buzid,
      ClearingJournalEntryFiscalYear               as auggj,
      HouseBankAccount                             as hktid,
      BudgetPeriod                                 as budget_pd,
      PaymentServiceProvider                       as pays_prov,
      PaymentRefByPaytSrvcProvider                 as pays_tran,
      SEPAMandate                                  as mndid,
      PaymentReason                                as payt_rsn,
      JointVenture                                 as vname,
      JointVentureEquityGroup                      as egrup,
      OffsettingAccount                            as gkont,
      OffsettingAccountType                        as gkart,
      ReferenceDocumentType                        as awtyp,
      _JournalEntry.SenderLogicalSystem            as logsystem_sender,
      _JournalEntry.SenderCompanyCode              as bukrs_sender,
      _JournalEntry.SenderAccountingDocument       as belnr_sender,
      _JournalEntry.SenderFiscalYear               as gjahr_sender

}
where
       FinancialAccountType       =  'D'
  and(
       ClearingJournalEntry       =  ''
    or ClearingJournalEntry       <> ''
  )
  and  AccountingDocumentCategory <> 'D'
  and  AccountingDocumentCategory <> 'M'

  //Below logic is from FM EBPP_BD_GET_CUSTOMER_STATEMENT

  and  AccountingDocumentCategory =  ' '
  and(
       SpecialGLTransactionType   is initial
    or SpecialGLTransactionType   =  'A'
  )