P_Acdoca_Cube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_Acdoca_Cube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFIACDOCACUBE

CREATE VIEW P_Acdoca_Cube AS
SELECT
  rldnr_pers,
  rbukrs,
  gjahr,
  belnr,
  docln,
  rldnr,
  ryear,
  rrcty,
  rmvct,
  vorgn,
  bttype,
  awtyp,
  awsys,
  aworg,
  awref,
  awitem,
  awitgrp,
  subta,
  xreversing,
  xreversed,
  xtruerev,
  awtyp_rev,
  aworg_rev,
  awref_rev,
  subta_rev,
  xsettling,
  xsettled,
  prec_awtyp,
  prec_aworg,
  prec_awref,
  prec_awitem,
  prec_subta,
  src_awtyp,
  src_awsys,
  src_aworg,
  src_awref,
  src_awitem,
  src_awsubit,
  xcommitment,
  obs_reason,
  racct,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  rtcur,
  tsl,
  rwcur,
  wsl,
  rhcur,
  hsl,
  rkcur,
  ksl,
  rocur,
  osl,
  rvcur,
  vsl,
  rbcur,
  bsl,
  rccur,
  csl,
  rdcur,
  dsl,
  recur,
  esl,
  rfcur,
  fsl,
  rgcur,
  gsl,
  hvkwrt,
  kfsl,
  kfsl2,
  kfsl3,
  psl,
  psl2,
  psl3,
  pfsl,
  pfsl2,
  pfsl3,
  rco_ocur,
  co_osl,
  hstprs,
  hpvprs,
  runit,
  msl,
  mfsl,
  rvunit,
  vmsl,
  vmfsl,
  qunit1,
  quant1,
  qunit2,
  quant2,
  qunit3,
  quant3,
  drcrk,
  poper,
  periv,
  fiscyearper,
  budat,
  bldat,
  blart,
  buzei,
  zuonr,
  bschl,
  bstat,
  ktosl,
  slalittype,
  usnam,
  timestamp,
  eprctr,
  rhoart,
  ktopl,
  lokkt,
  ktop2,
  rebzg,
  rebzj,
  rebzz,
  rebzt,
  rbest,
  ebeln,
  ebelp,
  zekkn,
  sgtxt,
  kdauf,
  kdpos,
  matnr,
  werks,
  lifnr,
  kunnr,
  fbuda,
  coco_num,
  koart,
  umskz,
  mwskz,
  hbkid,
  hktid,
  xopvw,
  augdt,
  augbl,
  auggj,
  XAUGP,
  afabe,
  anln1,
  anln2,
  bzdat,
  anbwa,
  movcat,
  depr_period,
  anlgr,
  anlgr2,
  anlkl,
  ktogr,
  panl1,
  panl2,
  kalnr,
  vprsv,
  kzbws,
  xobew,
  sobkz,
  mat_kdauf,
  mat_kdpos,
  mat_pspnr,
  mat_ps_posid,
  mat_lifnr,
  bwtar,
  bwkey,
  hpeinh,
  mlptyp,
  mlcateg,
  racct_sender,
  accas_sender,
  cast( objnr as fis_objnr preserving type) AS objnr,
  hkgrp,
  uspob,
  co_belkz,
  beltp,
  muvflg,
  gkont,
  gkoar,
  erlkz,
  pernr,
  scope,
  pbukrs,
  pscope,
  aufnr_org,
  ukostl,
  ulstar,
  uprctr,
  accas,
  lstar,
  aufnr,
  autyp,
  ps_psp_pnr,
  ps_posid,
  ps_prj_pnr,
  ps_pspid,
  nplnr,
  nplnr_vorgn,
  prznr,
  kstrg,
  bemot,
  rsrce,
  qmnum,
  erkrs,
  paccas,
  plstar,
  paufnr,
  pautyp,
  pps_posid,
  pps_pspid,
  pkdauf,
  pkdpos,
  pnplnr,
  pnplnr_vorgn,
  pprznr,
  pkstrg,
  overtimecat,
  work_item_id,
  co_beknz,
  uprznr,
  pps_psp_pnr,
  pps_prj_pnr,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  re_bukrs,
  re_account,
  fikrs,
  fistl,
  measure,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  bdgt_account,
  vname,
  egrup,
  recid,
  vptnr,
  btype,
  etype,
  prodper,
  billm,
  pom,
  cbrunid,
  jvactivity,
  pvname,
  pegrup,
  s_recind,
  cbracct,
  cbobjnr,
  swenr,
  sgenr,
  sgrnr,
  smenr,
  recnnr,
  snksl,
  sempsl,
  dabrz,
  pswenr,
  psgenr,
  psgrnr,
  psmenr,
  precnnr,
  psnksl,
  psempsl,
  pdabrz,
  acrobjtype,
  acrobj_id,
  acrsobj_id,
  acritmtype,
  acrvaldat,
  valobjtype,
  valobj_id,
  valsobj_id,
  netdt,
  risk_class,
  arbid,
  vornr,
  aufps,
  uvorn,
  equnr,
  tplnr,
  istru,
  ilart,
  plknz,
  artpr,
  priok,
  maufnr,
  matkl_mm,
  nbritm
FROM P_ACDOCA_COM
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON gjahr = _FiscalYear.FiscalYear AND rbukrs = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON budat = _CalendarDate.CalendarDate association[1] to I_FiscalYearVariant as _FiscalYearVariant on periv = _FiscalYearVariant.FiscalYearVariant association[0..1] to I_ControllingArea as _ControllingArea on kokrs = _ControllingArea.ControllingArea association[0..1] to I_Currency as _BalanceTransactionCurrency on rtcur = _BalanceTransactionCurrency.Currency association[0..1] to I_Currency as _TransactionCurrency on rwcur = _TransactionCurrency.Currency association[1] to I_Currency as _CompanyCodeCurrency on rhcur = _CompanyCodeCurrency.Currency association[0..1] to I_Currency as _GlobalCurrency on rkcur = _GlobalCurrency.Currency association[0..1] to I_Currency as _FreeDefinedCurrency1 on rocur = _FreeDefinedCurrency1.Currency association[0..1] to I_Currency as _FreeDefinedCurrency2 on rvcur = _FreeDefinedCurrency2.Currency association[0..1] to I_Currency as _FreeDefinedCurrency3 on rbcur = _FreeDefinedCurrency3.Currency association[0..1] to I_Currency as _FreeDefinedCurrency4 on rccur = _FreeDefinedCurrency4.Currency association[0..1] to I_Currency as _FreeDefinedCurrency5 on rdcur = _FreeDefinedCurrency5.Currency association[0..1] to I_Currency as _FreeDefinedCurrency6 on recur = _FreeDefinedCurrency6.Currency association[0..1] to I_Currency as _FreeDefinedCurrency7 on rfcur = _FreeDefinedCurrency7.Currency association[0..1] to I_Currency as _FreeDefinedCurrency8 on rgcur = _FreeDefinedCurrency8.Currency association[0..1] to I_UnitOfMeasure as _BaseUnit on runit = _BaseUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _CostSourceUnit on rvunit = _CostSourceUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _AdditionalQuantity1Unit on qunit1 = _AdditionalQuantity1Unit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _AdditionalQuantity2Unit on qunit2 = _AdditionalQuantity2Unit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _AdditionalQuantity3Unit on qunit3 = _AdditionalQuantity3Unit.UnitOfMeasure association[0..1] to I_Segment as _Segment on segment = _Segment.Segment association[0..*] to I_ProfitCenter as _ProfitCenter on kokrs = _ProfitCenter.ControllingArea AND prctr = _ProfitCenter.ProfitCenter association[0..*] to I_CostCenter as _CostCenter on kokrs = _CostCenter.ControllingArea AND rcntr = _CostCenter.CostCenter association[0..1] to I_BusinessArea as _BusinessArea on rbusa = _BusinessArea.BusinessArea association[0..1] to I_FunctionalArea as _FunctionalArea on rfarea = _FunctionalArea.FunctionalArea association[0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on ktopl = _GLAccountInChartOfAccounts.ChartOfAccounts AND racct = _GLAccountInChartOfAccounts.GLAccount association[1] to I_ChartOfAccounts as _ChartOfAccounts on ktopl = _ChartOfAccounts.ChartOfAccounts association[0..1] to I_AccountingDocumentType as _AccountingDocumentType on blart = _AccountingDocumentType.AccountingDocumentType association[0..1] to I_FinancialAccountType as _FinancialAccountType on koart = _FinancialAccountType.FinancialAccountType association[1] to I_DebitCreditCode as _DebitCreditCode on drcrk = _DebitCreditCode.DebitCreditCode association[0..1] to I_Material as _Material on matnr = _Material.Material association[0..1] to I_Product as _Product on matnr = _Product.Product association[0..1] to I_Plant as _Plant on werks = _Plant.Plant association[0..1] to I_Ledger as _Ledger on rldnr = _Ledger.Ledger association[0..1] to I_Ledger as _SourceLedger on rldnr_pers = _SourceLedger.Ledger association[0..*] to I_CostAnalysisResource as _CostAnalysisResource on kokrs = _CostAnalysisResource.ControllingArea AND rsrce = _CostAnalysisResource.CostAnalysisResource  -- association [0..1]
;