P_AcdocAUnionD_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_AcdocAUnionD_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: PFIACDOCADCUBE

CREATE VIEW P_AcdocAUnionD_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,
  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,
  vtkey,
  vtpos,
  erkrs,
  paccas,
  plstar,
  paufnr,
  pautyp,
  pps_posid,
  pps_pspid,
  pkdauf,
  pkdpos,
  pnplnr,
  pnplnr_vorgn,
  pprznr,
  pkstrg,
  work_item_id,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  re_bukrs,
  re_account,
  fikrs,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  fistl,
  measure,
  vname,
  egrup,
  recid,
  vptnr,
  btype,
  etype,
  prodper,
  swenr,
  sgenr,
  sgrnr,
  smenr,
  recnnr,
  snksl,
  sempsl,
  dabrz,
  pswenr,
  psgenr,
  psgrnr,
  psmenr,
  precnnr,
  psnksl,
  psempsl,
  pdabrz,
  arbid,
  vornr,
  aufps,
  uvorn,
  equnr,
  tplnr,
  istru,
  ilart,
  plknz,
  artpr,
  priok,
  maufnr,
  matkl_mm,
  nbritm
FROM P_ACDOCA_COM
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON rbukrs = _JournalEntry.CompanyCode AND gjahr = _JournalEntry.FiscalYear AND belnr = _JournalEntry.AccountingDocument  -- association [1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON rbukrs = _CompanyCode.CompanyCode  -- association [1]
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 [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON periv = _FiscalYearVariant.FiscalYearVariant  -- association [1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON kokrs = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BalanceTransactionCurrency ON rtcur = _BalanceTransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON rwcur = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON rhcur = _CompanyCodeCurrency.Currency  -- association [1]
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON rkcur = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency1 ON rocur = _FreeDefinedCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency2 ON rvcur = _FreeDefinedCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency3 ON rbcur = _FreeDefinedCurrency3.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency4 ON rccur = _FreeDefinedCurrency4.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency5 ON rdcur = _FreeDefinedCurrency5.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency6 ON recur = _FreeDefinedCurrency6.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency7 ON rfcur = _FreeDefinedCurrency7.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _FreeDefinedCurrency8 ON rgcur = _FreeDefinedCurrency8.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON runit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CostSourceUnit ON rvunit = _CostSourceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity1Unit ON qunit1 = _AdditionalQuantity1Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity2Unit ON qunit2 = _AdditionalQuantity2Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _AdditionalQuantity3Unit ON qunit3 = _AdditionalQuantity3Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON kokrs = _ProfitCenter.ControllingArea AND prctr = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON kokrs = _CostCenter.ControllingArea AND rcntr = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON rbusa = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON rfarea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ktopl = _GLAccountInChartOfAccounts.ChartOfAccounts AND racct = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ktopl = _ChartOfAccounts.ChartOfAccounts  -- association [1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON blart = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON koart = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON drcrk = _DebitCreditCode.DebitCreditCode  -- association [1]
LEFT OUTER JOIN I_Material AS _Material ON matnr = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON matnr = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON werks = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON rldnr = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _SourceLedger ON rldnr_pers = _SourceLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_CostAnalysisResource AS _CostAnalysisResource ON kokrs = _CostAnalysisResource.ControllingArea AND rsrce = _CostAnalysisResource.CostAnalysisResource  -- association [0..*]
-- UNION ALL with additional select branch(es): P_ACDOCD_COM
;