C_OplAcctgDocItemCorrespnc

@AbapCatalog.sqlViewName: 'COPLADICOR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering.status: #NOT_ALLOWED

@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations: [ '_CustomerAddress', '_SupplierAddress' ] 

//@Search.searchable: true


@EndUserText.label: 'Correspondence SAP09 - Operational document - items'

define view C_OplAcctgDocItemCorrespnc

  as select from I_OperationalAcctgDocItem as Item

  association [*]    to I_PostingKeyWthSpclGLCodeTxt as _PostingKeyWthSpclGLCodeTxt on  _PostingKeyWthSpclGLCodeTxt.PostingKey    = Item.PostingKey
                                                                                    and _PostingKeyWthSpclGLCodeTxt.SpecialGLCode = Item.SpecialGLCode

  association [*]    to I_GLAccountText           as _GLAccountText            on  _GLAccountText.ChartOfAccounts = Item.ChartOfAccounts
                                                                               and _GLAccountText.GLAccount       = Item.GLAccount

  association [0..1] to I_WBSElementByInternalKey as _WBSElementInternalIDText on  Item.WBSElementInternalID = _WBSElementInternalIDText.WBSElementInternalID
  association [0..1] to I_WBSElementBasicData     as _I_WBSElementBasicData    on  Item.WBSElementInternalID = _I_WBSElementBasicData.WBSElementInternalID

 //INS 2020-10-09:

  association [0..1] to C_CorrespondenceAddress   as _CustomerAddress          on  $projection.CorrespncCustomerAddressID = _CustomerAddress.AddressID
  association [0..1] to C_CorrespondenceAddress   as _SupplierAddress          on  $projection.SupplierAddressID          = _SupplierAddress.AddressID

  association [0..*] to C_CorrespondenceItemNote   as _CorrespondenceItemNote   on  $projection.CompanyCode = _CorrespondenceItemNote.CompanyCode and
                                                                                    $projection.FiscalYear = _CorrespondenceItemNote.FiscalYear and
                                                                                    $projection.AccountingDocument = _CorrespondenceItemNote.AccountingDocument and
                                                                                    $projection.AccountingDocumentItem = _CorrespondenceItemNote.AccountingDocumentItem

  association [1] to E_OperationalAcctgDocItem as _Extension on $projection.CompanyCode = _Extension.CompanyCode and
                                                                $projection.FiscalYear = _Extension.FiscalYear and
                                                                $projection.AccountingDocument = _Extension.AccountingDocument and
                                                                $projection.AccountingDocumentItem = _Extension.AccountingDocumentItem

{
  key Item.CompanyCode,
  key Item.FiscalYear,
  key Item.AccountingDocument,
  key Item.AccountingDocumentItem, //commented till 2020-10-09

      ////  key cast( cast( Item.AccountingDocumentItem as char6 ) as buzei6 ) as AccountingDocumentItem,


      Item.PostingKey,
      _PostingKeyWthSpclGLCodeTxt[1:Language = $session.system_language].PostingKeyName,

      Item.GLAccount,
      _GLAccountText[1:Language = $session.system_language].GLAccountName,
      _GLAccountText[1:Language = $session.system_language].GLAccountLongName,

      Item.Customer,
      Item._Customer.CustomerName,
      Item._Customer.CustomerFullName,
      Item._Customer.AddressID as CorrespncCustomerAddressID,

      Item.Supplier,
      Item._Supplier.SupplierName,
      Item._Supplier.SupplierFullName,
      Item._Supplier.AddressID as SupplierAddressID,


      Item.AmountInCompanyCodeCurrency,
      Item.CompanyCodeCurrency,

      Item.AmountInTransactionCurrency,
      Item.TransactionCurrency,
      Item.DocumentItemText,


      //Item

      Item.ChartOfAccounts,
      AccountingDocumentItemType,
      ClearingDate,
      ClearingCreationDate,
      ClearingJournalEntry as ClearingAccountingDocument,
      Item.FinancialAccountType,
      Item.SpecialGLCode,
      SpecialGLTransactionType,
      DebitCreditCode,
      BusinessArea,
      PartnerBusinessArea,
      TaxCode,
      TaxCountry, //INS

      WithholdingTaxCode,
      TaxType,
      TaxItemGroup,
      TransactionTypeDetermination,
      ValueDate,
      AssignmentReference,
      PartnerCompany,
      FinancialTransactionType,
      CorporateGroupAccount,
      PlanningLevel,
      ControllingArea,
      CostCenter,
      Project,
      OrderID,
      BillingDocument,
      SalesDocument,
      SalesDocumentItem,
      ScheduleLine,
      ServiceDocumentType,
      ServiceDocument,
      ServiceDocumentItem,
      MasterFixedAsset,
      FixedAsset,
      AssetTransactionType,
      AssetValueDate,
      PersonnelNumber,
      IsSalesRelated,
      LineItemDisplayIsEnabled,
      IsOpenItemManaged,
      IsNotCashDiscountLiable,
      IsAutomaticallyCreated,
      IsUsedInPaymentTransaction,
      OperationalGLAccount,
      BranchAccount,
      IsBalanceSheetAccount,
      ProfitLossAccountType,
      SpecialGLAccountAssignment,
      DueCalculationBaseDate,
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      NetPaymentDays,
      CashDiscount1Percent,
      CashDiscount2Percent,
      PaymentMethod,
      PaymentBlockingReason,
      FixedCashDiscount,
      HouseBank,
      BPBankAccountInternalID,
      TaxDistributionCode1,
      TaxDistributionCode2,
      TaxDistributionCode3,
      InvoiceReference,
      InvoiceReferenceFiscalYear,
      InvoiceItemReference,
      FollowOnDocumentType,
      StateCentralBankPaymentReason,
      SupplyingCountry,
      InvoiceList,
      BillOfExchangeUsage,
      DunningKey,
      DunningBlockingReason,
      LastDunningDate,
      DunningLevel,
      DunningArea,
      WithholdingTaxCertificate,
      Material,
      Product,
      Plant,
      PurchasingDocument,
      PurchasingDocumentItem,
      AccountAssignmentNumber,
      IsCompletelyDelivered,
      MaterialPriceControl,
      ValuationArea,
      InventoryValuationType,
      VATRegistration,
      DelivOfGoodsDestCountry,
      PaymentDifferenceReason,
      ProfitCenter,
      JointVenture,
      JointVentureCostRecoveryCode,
      JointVentureEquityGroup,
      TreasuryContractType,
      AssetContract,
      CashFlowType,
      TaxJurisdiction,
      RealEstateObject,
      SettlementReferenceDate,
      CommitmentItem,
      CostObject,
      ProjectNetwork,
      OrderInternalBillOfOperations,
      OrderIntBillOfOperationsItem,
      WBSElementInternalID,
      _WBSElementInternalIDText.WBSDescription,
      _I_WBSElementBasicData.WBSElementExternalID,
      ProfitabilitySegment_2 as ProfitabilitySegment,
      JointVentureEquityType,
      IsEUTriangularDeal,
      CostOriginGroup,
      CompanyCodeCurrencyDetnMethod,
      ClearingIsReversed,
      PaymentMethodSupplement,
      AlternativeGLAccount,
      FundsCenter,
      Fund,
      PartnerProfitCenter,
      Reference1IDByBusinessPartner,
      Reference2IDByBusinessPartner,

      //      @API.element.releaseState: #DEPRECATED

      //      @API.element.successor: 'EarmarkedFundsDocument'

      //      EarmarkedFunds,

      EarmarkedFundsDocument,

      //      @API.element.releaseState: #DEPRECATED

      //      @API.element.successor: 'EarmarkedFundsDocumentItem'

      //      EarmarkedFundsItem,

      EarmarkedFundsDocumentItem,

      IsNegativePosting,
      PaymentCardItem,
      PaymentCardPaymentSettlement,
      CreditControlArea,
      Reference3IDByBusinessPartner,
      DataExchangeInstruction1,
      DataExchangeInstruction2,
      DataExchangeInstruction3,
      DataExchangeInstruction4,
      Region,
      HasPaymentOrder,
      PaymentReference,
      TaxDeterminationDate,
      ClearingItem,
      BusinessPlace,
      TaxSection,
      CostCtrActivityType,
      AccountsReceivableIsPledged,
      BusinessProcess,
      GrantID,
      FunctionalArea,
      CustomerIsInExecution,
      FundedProgram,
      ClearingJournalEntryFiscalYear as ClearingDocFiscalYear,
      LedgerGLLineItem,
      Segment,
      PartnerSegment,
      PartnerFunctionalArea,
      HouseBankAccount,
      CostElement,
      PaymentServiceProvider,
      PaymentRefByPaytSrvcProvider,
      SEPAMandate,
      ReferenceDocumentType,
      OriginalReferenceDocument,
      ReferenceDocumentLogicalSystem,
      AccountingDocumentItemRef,
      FiscalPeriod,
      AccountingDocumentCategory,
      PostingDate,
      DocumentDate,
      AccountingDocumentType,
      NetDueDate,
      CashDiscount1DueDate,
      CashDiscount2DueDate,
      OffsettingAccount,
      OffsettingAccountType,
      OffsettingChartOfAccounts,
      PartnerFund,
      PartnerGrant,
      BudgetPeriod,
      PartnerBudgetPeriod,
      BranchCode,
      // INS 2020-10-09 beg

      OplAcctgDocItmCntrySpcfcRef1,
      CashLedgerCompanyCode,
      CashLedgerAccount,
      PubSecBudgetAccountCoCode,
      PubSecBudgetAccount,
      // INS 2020-10-09 end


      TaxAmountInCoCodeCrcy,
      TaxBaseAmountInCoCodeCrcy,
      ValuationDiffAmtInCoCodeCrcy,
      CashDiscountAmtInCoCodeCrcy,
      InvoiceAmtInCoCodeCrcy,
      OriginalTaxBaseAmount,
      TaxAmount,
      TaxBaseAmountInTransCrcy,
      WithholdingTaxBaseAmount,
      PlannedAmtInTransactionCrcy,
      CashDiscountBaseAmount,
      CashDiscountAmount,
      NetPaymentAmount,
      WithholdingTaxAmount,
      WithholdingTaxExemptionAmt,
      InvoiceAmountInFrgnCurrency,
      BalanceTransactionCurrency,
      AmountInBalanceTransacCrcy,
      AdditionalCurrency1,
      ValuationDiffAmtInAddlCrcy1,
      AmountInAdditionalCurrency1,
      AdditionalCurrency2,
      AmountInAdditionalCurrency2,
      ValuationDiffAmtInAddlCrcy2,
      PaymentCurrency,
      AmountInPaymentCurrency,
      CreditControlAreaCurrency,
      HedgedAmount,
      BaseUnit,
      Quantity,
      GoodsMovementEntryUnit,
      QuantityInEntryUnit,
      PurchasingDocumentPriceUnit,
      PurchaseOrderQty,
      MaterialPriceUnitQty,
      NumberOfItems,
      GLAccountAuthorizationGroup,
      SupplierBasicAuthorizationGrp,
      CustomerBasicAuthorizationGrp,
      AcctgDocTypeAuthorizationGroup,
      OrderType,
      SalesOrderType,
      AssetClass,
  
      /* Associations */
      _CustomerAddress,  //INS 2020-10-09

      _SupplierAddress,  //INS 2020-10-09


      /*For Access Control*/
      _AccountingDocumentType,
      _CurrentCostCenter,
      _CurrentProfitCenter,
      _FixedAsset,
      _GLAccountInCompanyCode,
      _Order,
      _SalesDoc,
      _ServiceDocument,
      _Customer,
      _Supplier,
      
      @ObjectModel.filter.enabled: false
      _CorrespondenceItemNote

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_GLACCOUNTTEXT",
"I_OPERATIONALACCTGDOCITEM",
"I_POSTINGKEYWTHSPCLGLCODETXT",
"I_SUPPLIER",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYINTERNALKEY"
],
"ASSOCIATED":
[
"C_CORRESPONDENCEADDRESS",
"C_CORRESPONDENCEITEMNOTE",
"E_OPERATIONALACCTGDOCITEM",
"I_ACCOUNTINGDOCUMENTTYPE",
"I_COSTCENTER",
"I_CUSTOMER",
"I_FIXEDASSET",
"I_GLACCOUNTINCOMPANYCODE",
"I_GLACCOUNTTEXT",
"I_ORDER",
"I_POSTINGKEYWTHSPCLGLCODETXT",
"I_PROFITCENTER",
"I_SALESDOCUMENT",
"I_SRVCDOCBYDOCUMENTTYPE",
"I_SUPPLIER",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYINTERNALKEY"
],
"BASE":
[
"I_OPERATIONALACCTGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/