P_IJE_LOG_DETAIL_PRE

DDL: P_IJE_LOG_DETAIL_PRE SQL: PIJELOGPRE Type: view BASIC

P_IJE_LOG_DETAIL_PRE is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (acdocu) and exposes 84 fields with key field fiscalyear.

1 data source(s) 84 fields

Data Sources (1)

SourceAliasJoin Type
acdocu acdocu from

Annotations (11)

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

Fields (84)

KeyFieldSource TableSource FieldDescription
KEY fiscalyear ryear
glrecordtype rrcty
CnsldtnLocalCurrency rhcur
CnsldtnGroupCurrency rkcur
BaseUnit runit
FiscalPeriod poper
CnsldtnDocumentType docty
Company rcomp
CnsldtnUnit rbunit
CnsldtnChartOfAccounts ritclg
CnsldtnFinStmntItm ritem
CnsldtnPartnerUnit rbuptr
CnsldtnGroup rcongr
CompanyCode robukrs
CnsldtnFinStmntSubItmCat sityp
CnsldtnFinStmntSubItm subit
CnsldtnPostingLevel plevl
CnsldtnApportionment rpflg
CnsldtnCrcyCnvrsnDiffType rtflg
CnsldtnAcquisitionYear yracq
CnsldtnAcquisitionPeriod pracq
CnsldtnInvesteeUnit coicu
AmountInTransactionCurrency tsl
AmountInCnsldtnLocalCrcy hsl
AmountInCnsldtnGroupCrcy ksl
QuantityInBaseUnit msl
DocumentItemText sgtxt
CnsldtnIsAutoPosting autom
CnsldtnBusinessTransactionType activ
PostingDate budat
CnsldtnCrcyTranslationDate wsdat
CnsldtnRefAcctgDocument refdocnr
CnsldtnRefFiscalYear refryear
CnsldtnRefAcctgDocItem refdocln
CnsldtnRefDocumentType refdocct
CnsldtnRefBusTransType refactiv
CreationDate cpudt
CreationTime cputm
UserID usnam
CnsldtnReverseDocument rvsdocnr
CnsldtnReversedDocument orndocnr
CnsldtnInvmtActivityType coiac
CnsldtnInvmtActivity coinr
CnsldtnDocReversalYear revyear
ReferenceDocumentType awtyp
ReferenceDocumentContext aworg
LogicalSystem logsys
ChartOfAccounts ktopl
GLAccount racct
AssignmentReference zuonr
CostCenter rcntr
ProfitCenter prctr
FunctionalArea rfarea
BusinessArea rbusa
ControllingArea kokrs
Segment segment
PartnerCostCenter scntr
PartnerProfitCenter pprctr
PartnerFunctionalArea sfarea
PartnerBusinessArea sbusa
PartnerCompany rassc
PartnerSegment psegment
OrderID aufnr
Customer kunnr
Supplier lifnr
Material matnr
Plant matkl_mm
FinancialTransactionType werks
WBSElementInternalID rmvct
WBSElement ps_psp_pnr
Project ps_pspid
BillingDocumentType fkart
SalesOrganization vkorg
DistributionChannel vtweg
OrganizationDivision spart
SoldProduct matnr_copa
SoldProductGroup matkl
CustomerGroup kdgrp
CustomerSupplierCountry land1
CustomerSupplierIndustry brsch
SalesDistrict bzirk
BillToParty kunre
ShipToParty kunwe
CustomerSupplierCorporateGroup konzs 
@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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCU"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More