P_ACDOCP_COM

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_ACDOCP_COM.
-- 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.

CREATE VIEW P_ACDOCP_COM AS
SELECT
  cast( reqtsn as fis_fp_request_tsn preserving type) AS reqtsn,
  cast( datapakid as fis_fp_data_packet preserving type) AS datapakid,
  cast( record as fis_fp_entry_item_no_sign ) AS record,
  cast(rbukrs as fis_bukrs preserving type) AS rbukrs,
  cast(rldnr as fis_rldnr preserving type) AS rldnr,
  cast(racct as fis_racct preserving type) AS racct,
  cast(rcntr as fis_kostl preserving type) AS rcntr,
  cast(prctr as fis_prctr preserving type) AS prctr,
  cast(rfarea as fm_farea preserving type) AS rfarea,
  cast(rbusa as fis_rbusa preserving type) AS rbusa,
  cast(kokrs as fis_kokrs preserving type) AS kokrs,
  segment,
  cast(scntr as fis_skost preserving type) AS scntr,
  cast(pprctr as fis_pprctr preserving type) AS pprctr,
  cast(sfarea as fis_sfkber preserving type) AS sfarea,
  cast(sbusa as fis_pargb preserving type) AS sbusa,
  cast(rassc as fis_rassc preserving type) AS rassc,
  psegment,
  cast(rwcur as fis_rwcur preserving type) AS rwcur,
  cast(wsl as fis_wsl preserving type) AS wsl,
  cast(rhcur as fis_hwaer preserving type) AS rhcur,
  cast(hsl as fis_hsl preserving type) AS hsl,
  cast(rkcur as fis_rkcur preserving type) AS rkcur,
  cast(ksl as fis_ksl preserving type) AS ksl,
  rfccur,
  cast(fcsl as fis_vfccur12 preserving type) AS fcsl,
  cast(rocur as fis_rocur preserving type) AS rocur,
  cast(osl as fis_osl preserving type) AS osl,
  cast(rvcur as fis_rvcur preserving type) AS rvcur,
  cast(vsl as fis_vsl preserving type) AS vsl,
  rbcur,
  cast(bsl as fis_bsl preserving type) AS bsl,
  rccur,
  cast(csl as fis_csl preserving type) AS csl,
  rdcur,
  cast(dsl as fis_dsl preserving type) AS dsl,
  recur,
  cast(esl as fis_esl preserving type) AS esl,
  cast(rfcur as fis_rfcur preserving type) AS rfcur,
  cast(fsl as fis_fsl preserving type) AS fsl,
  rgcur,
  cast(gsl as fis_gsl preserving type) AS gsl,
  rco_ocur,
  co_osl,
  cast(kfsl as fis_kfsl preserving type) AS kfsl,
  cast(hfsl as fis_hfsl preserving type) AS hfsl,
  cast(wfsl as fis_wfsl preserving type) AS wfsl,
  cast(rvunit as co_meinh preserving type) AS rvunit,
  cast( vmsl as fis_vquan1_12 preserving type ) AS vmsl,
  cast( scrap_qty as ck_ausmg preserving type ) AS scrap_qty,
  cast( vmfsl as fis_vquan1_12_fix preserving type ) AS vmfsl,
  cast( rrunit as fis_ref_qty_uom preserving type ) AS rrunit,
  rmsl,
  cast(ryear as fis_gjahr_no_conv preserving type) AS gjahr,
  cast(ryear as fis_ryear_no_conv preserving type) AS ryear,
  cast(poper as fins_fiscalperiod preserving type) AS poper,
  cast(fiscyearper as fis_jahrper_conv preserving type ) AS fiscyearper,
  cast(budat as fis_budat preserving type) AS budat,
  cast(periv as fis_periv preserving type) AS periv,
  cast(ktopl as fis_ktopl preserving type) AS ktopl,
  zuonr,
  slalittype,
  bttype,
  rmvct,
  cast(awtyp as fis_awtyp preserving type) AS awtyp,
  cast(aworg as fis_aworg preserving type) AS aworg,
  awref,
  usnam,
  cast(kdauf as vdm_sales_order preserving type) AS kdauf,
  cast(kdpos as sales_order_item preserving type) AS kdpos,
  werks,
  matnr,
  kunnr,
  objnr,
  co_belkz,
  cast( ps_psp_pnr as fis_wbsint_no_conv preserving type ) AS ps_psp_pnr,
  ps_posid,
  cast( ps_prj_pnr as fis_projectint_no_conv preserving type ) AS ps_prj_pnr,
  ps_pspid,
  pernr,
  pbukrs,
  cast(ukostl as fis_usp_kostl preserving type) AS ukostl,
  cast(ulstar as fis_usp_lstar preserving type) AS ulstar,
  lstar,
  cast(aufnr as fis_aufnr preserving type) AS aufnr,
  cast(rsrce as fis_co_resource preserving type) AS rsrce,
  cast(plstar as fis_par_lstar preserving type) AS plstar,
  cast(paufnr as fis_par_aufnr preserving type) AS paufnr,
  cast( pps_psp_pnr as fis_partner_wbsint_no_conv preserving type ) AS pps_psp_pnr,
  cast( pps_posid as fis_par_posid preserving type) AS pps_posid,
  cast( pps_prj_pnr as fis_part_projectint_no_conv preserving type) AS pps_prj_pnr,
  cast( pps_pspid as fis_par_pspid preserving type) AS pps_pspid,
  work_item_id,
  cast(bemot as fis_bemot preserving type) AS bemot,
  psknz,
  nplnr,
  cast(gkont as fis_gkont preserving type) AS gkont,
  cast(gkoar as farp_gkoar preserving type) AS gkoar,
  cast( aufnr_org as fco_aufnr_org preserving type) AS aufnr_org,
  losgr,
  lsunit,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  cast(land1 as fis_land1_copa preserving type) AS land1,
  cast(brsch as fis_brsch_copa preserving type) AS brsch,
  bzirk,
  kunre,
  kunwe,
  cast(konzs as fis_konzs_copa preserving type) AS konzs,
  fikrs,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  arbid,
  cast( vornr as fis_vornr_no_conv preserving type ) AS vornr,
  aufps,
  paufps,
  cast( uvorn as fis_uvorn_no_conv preserving type ) AS uvorn,
  equnr,
  tplnr,
  istru,
  ilart,
  plknz,
  artpr,
  priok,
  maufnr,
  matkl_mm,
  cast( vornr_org as fis_origin_order_operation preserving type) AS vornr_org,
  afabe,
  anln1,
  anln2,
  movcat,
  anlkl,
  vname,
  egrup,
  recid,
  prodper,
  rsnum,
  cast(rspos as eam_reservation_item preserving type ) AS rspos,
  cast(rsart as eam_reservation_type preserving type ) AS rsart,
  cast(packno as eam_service_package preserving type ) AS packno,
  cast(introw as eam_service_line_item preserving type ) AS introw,
  cast(swenr as rebdvdmbeno preserving type ) AS SWENR,
  cast(sgenr as rebdvdmbuno preserving type ) AS SGENR,
  cast(sgrnr as rebdvdmprno preserving type ) AS SGRNR,
  cast(smenr as rebdvdmrono preserving type ) AS SMENR,
  cast(recnnr as recnvdmcnnr preserving type ) AS RECNNR,
  cast(snksl as rescvdmsckey preserving type ) AS snksl,
  cast(sempsl as rescvdmsuid preserving type ) AS sempsl,
  cast(dabrz as farp_dabrbez preserving type) AS dabrz,
  cast(pmatnr as fis_produced_product preserving type ) AS pmatnr,
  hkgrp,
  cast(verid as fis_verid preserving type ) AS verid,
  cast(stnum as ck_stnum preserving type ) AS stnum,
  stlan,
  stalt,
  plnty,
  plnnr,
  plnal,
  mkalk,
  baltkz,
  cast(bwtar as fis_inventory_valuation_type preserving type ) AS bwtar,
  prozess,
  acrobjtype,
  acrlogsys,
  acrobj_id,
  acrsobj_id,
  acritmtype,
  cast( acrrefobj_id as fis_acr_refobj_id preserving type ) AS acrrefobj_id,
  acrvaldat,
  category,
  kprice,
  hprice,
  wprice,
  sgtxt
FROM acdocp
LEFT OUTER JOIN I_Product AS _Product ON matnr = _Product.Product  -- association [0..1]
;