P_IJE_LOG_DETAIL_PRE

@AbapCatalog.sqlViewName: 'PIJELOGPRE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.type: #CLIENT_DEPENDENT 
@ClientHandling.algorithm: #AUTOMATED 
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #BASIC

define view P_IJE_LOG_DETAIL_PRE as select from acdocu
{
key rldnr as cnsldtnledger

  ,
  key rdimen as cnsldtndimension

  ,
  key ryear as fiscalyear

  ,
  key docnr as cnsldtndocumentnumber

  ,
  key docln as cnsldtnpostingitem

  ,
      rrcty as glrecordtype

  ,
      rvers as cnsldtnversion

  ,
      @Semantics.currencyCode
      rtcur as transactioncurrency

  ,
      @Semantics.currencyCode
      rhcur as CnsldtnLocalCurrency

  ,
      @Semantics.currencyCode
      rkcur as CnsldtnGroupCurrency

  ,
      runit as BaseUnit

  ,
      poper as FiscalPeriod

  ,
      docty as CnsldtnDocumentType

  ,

      rcomp as Company

  ,
      rbunit as CnsldtnUnit

  ,
      ritclg as CnsldtnChartOfAccounts

  ,
      ritem as CnsldtnFinStmntItm

  ,
      rbuptr as CnsldtnPartnerUnit

  ,
      rcongr as CnsldtnGroup

  ,
      robukrs as CompanyCode

  ,
      sityp as CnsldtnFinStmntSubItmCat

  ,
      subit as CnsldtnFinStmntSubItm

  ,
      plevl as CnsldtnPostingLevel

  ,
      rpflg as CnsldtnApportionment

  ,
      rtflg as CnsldtnCrcyCnvrsnDiffType

  ,
      yracq as CnsldtnAcquisitionYear

  ,
      pracq as CnsldtnAcquisitionPeriod

  ,
      coicu as CnsldtnInvesteeUnit

  ,
      @Semantics.amount.currencyCode: 'TRANSACTIONCURRENCY' @DefaultAggregation: #SUM
      tsl as AmountInTransactionCurrency

  ,
      @Semantics.amount.currencyCode: 'CNSLDTNLOCALCURRENCY' @DefaultAggregation: #SUM
      hsl as AmountInCnsldtnLocalCrcy

  ,
      @Semantics.amount.currencyCode: 'CNSLDTNGROUPCURRENCY' @DefaultAggregation: #SUM
      ksl as  AmountInCnsldtnGroupCrcy

  ,
      msl as QuantityInBaseUnit

  ,
      sgtxt as DocumentItemText

  ,
      autom as CnsldtnIsAutoPosting

  ,
      activ as CnsldtnBusinessTransactionType

  ,
      budat as PostingDate

  ,
      wsdat as CnsldtnCrcyTranslationDate

  ,
      refdocnr as CnsldtnRefAcctgDocument

  ,
      refryear as CnsldtnRefFiscalYear

  ,
      refdocln as  CnsldtnRefAcctgDocItem

  ,
      refdocct as CnsldtnRefDocumentType

  ,
      refactiv as CnsldtnRefBusTransType

  ,
      cpudt as CreationDate

  ,
      cputm as CreationTime

  ,
      usnam as UserID

  ,
      rvsdocnr as CnsldtnReverseDocument

  ,
      orndocnr as CnsldtnReversedDocument

  ,
      coiac as CnsldtnInvmtActivityType

  ,
      coinr as CnsldtnInvmtActivity

  ,
      revyear as CnsldtnDocReversalYear

  ,
      awtyp as ReferenceDocumentType

  ,
      aworg as ReferenceDocumentContext

  ,
      logsys as LogicalSystem

  ,
      ktopl as ChartOfAccounts

  ,
      racct as GLAccount
      //xblnr,

  ,
      zuonr as AssignmentReference

  ,
      rcntr as CostCenter

  ,
      prctr as ProfitCenter

  ,
      rfarea as FunctionalArea

  ,
      rbusa as BusinessArea

  ,
      kokrs as ControllingArea

  ,
      segment as Segment

  ,
      scntr as PartnerCostCenter

  ,
      pprctr as PartnerProfitCenter

  ,
      sfarea as PartnerFunctionalArea

  ,
      sbusa as PartnerBusinessArea

  ,
      rassc as PartnerCompany

  ,
      psegment as PartnerSegment

  ,
      aufnr as OrderID

  ,
      kunnr as Customer

  ,
      lifnr as Supplier

  ,
      matnr as Material

  ,
      matkl_mm as Plant

  ,
      werks as FinancialTransactionType

  ,
      rmvct as WBSElementInternalID

  ,
      ps_psp_pnr as WBSElement

  ,
      ps_pspid as Project

  ,

      fkart as BillingDocumentType

  ,
      vkorg as SalesOrganization

  ,
      vtweg as DistributionChannel

  ,
      spart as OrganizationDivision

  ,
      matnr_copa as SoldProduct

      //,matnr_copa


  ,
      matkl as SoldProductGroup

  ,
      kdgrp as CustomerGroup

  ,
  
      land1 as CustomerSupplierCountry
  
  ,

      brsch as CustomerSupplierIndustry

  ,
      bzirk as SalesDistrict

  ,
      kunre as BillToParty

  ,
      kunwe as ShipToParty

  ,
      konzs as CustomerSupplierCorporateGroup

}