Fins_Plan_Delscope_Cds

DDL: FINS_PLAN_DELSCOPE_CDS SQL: FINSPLANDELSCOPE Type: view
87 Fields 1 Data Sources

View for delete scope

Fins_Plan_Delscope_Cds is a CDS View that provides data about "View for delete scope" in SAP S/4HANA. It reads from 1 data source (fins_plan_delsc) and exposes 87 fields with key fields uuid, pos.

Data Sources (1)

SourceAliasJoin Type
fins_plan_delsc fins_plan_delsc from

Parameters (1)

NameTypeDefault
p_uuid fins_plan_uuid

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FINSPLANDELSCOPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label View for delete scope view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (87)

KeyFieldSource TableSource FieldDescription
KEY uuid uuid Waste Partner UUID
KEY pos pos Table position
aufnr aufnr SettlementOrder
aworg aworg Refer. Org.Unit
awref awref Reference Doc.
awtyp awtyp Reference Document Type
brsch brsch Industry
bsl bsl Exchange Key
bzirk bzirk Sales District
category category Violation Category
co_belkz co_belkz Dr/Cr ind. CO
createdat createdat Time Stamp
csl csl Amount in Currency 4
dsl dsl Amount in Currency 5
esl esl Amount in Currency 6
fiscyearper fiscyearper Period/Year
fkart fkart Ship. cost type
fsl fsl Amount in Currency 7
gsl gsl Amount in Currency 8
hprice hprice Price in CompCd Crcy
hsl hsl Local Crcy Amt
kdauf kdauf SD Document
kdgrp kdgrp Customer group
kdpos kdpos Sales Ord. Item
kokrs kokrs Org. Value
konzs konzs Group
kprice kprice Price in Gl. Crcy
ksl ksl GrpCurr
ktopl ktopl G/L Chart of Accounts
kunnr kunnr Stock customer
kunre kunre Bill-to Party
kunwe kunwe Ship-to Party
land1 land1 Trip Ctry/Reg
lstar lstar Activity Type
matkl matkl Product Sold Group
matnr matnr Vehicle Model
matnr_copa matnr_copa Product Sold
osl osl Other Crcy Amnt
paufnr paufnr Partner order
pbukrs pbukrs Partner CoCode
periv periv FYear Variant
pernr pernr Personnel no.
plstar plstar ParActvy
poper poper Posting periods
pprctr pprctr Partner PC
pps_posid pps_posid Partner WBS Element
pps_pspid pps_pspid Part. Proj. Def
prctr prctr Profit Centers
ps_posid ps_posid WBS Element
ps_psp_pnr ps_psp_pnr WBS Element
ps_pspid ps_pspid Project def.
psegment psegment Partner Segment
racct racct GL Account From
rassc rassc Trading Partner
rbcur rbcur Free Defined Crcy 3
rbukrs rbukrs Company Code
rbusa rbusa Business Area
rccur rccur Third Currency
rcntr rcntr Cost Center
rdcur rdcur Free Defined Crcy 5
recur recur Free Defined Crcy 6
rfarea rfarea R FuncArea
rfcur rfcur Free Defined Crcy 7
rgcur rgcur Free Defined Crcy 8
rhcur rhcur Local Currency
rkcur rkcur Ledger curr.
rldnr rldnr Ledger (Compat.)
rocur rocur Free Defined Crcy 1
rsrce rsrce Resource
rvcur rvcur Free Defined Crcy 4
rvunit rvunit Valuation UoM
rwcur rwcur Transaction Currency
ryear ryear Ref. Year1
sbusa sbusa Trdg Part.BA
scntr scntr Sender Cost Ctr
segment segment Segment number
sfarea sfarea Sender FnArea
spart spart Source supplier
usnam usnam User Name
vkorg vkorg SD Sales Org.
vmsl vmsl Val. quantity
vsl vsl Amount in Currency 2
vtweg vtweg RefDistCh-Cust/Mat.
werks werks Receiving Plant
work_item_id work_item_id Work Item ID
wprice wprice Price in Trans. Crcy
wsl wsl OrigTrnsCrcyAmt

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 Fins_Plan_Delscope_Cds.
-- 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: FINSPLANDELSCOPE
-- Parameters: p_uuid : fins_plan_uuid

CREATE VIEW Fins_Plan_Delscope_Cds AS
SELECT
  uuid,
  pos,
  aufnr,
  aworg,
  awref,
  awtyp,
  brsch,
  bsl,
  bzirk,
  category,
  co_belkz,
  createdat,
  csl,
  dsl,
  esl,
  fiscyearper,
  fkart,
  fsl,
  gsl,
  hprice,
  hsl,
  kdauf,
  kdgrp,
  kdpos,
  kokrs,
  konzs,
  kprice,
  ksl,
  ktopl,
  kunnr,
  kunre,
  kunwe,
  land1,
  lstar,
  matkl,
  matnr,
  matnr_copa,
  osl,
  paufnr,
  pbukrs,
  periv,
  pernr,
  plstar,
  poper,
  pprctr,
  pps_posid,
  pps_pspid,
  prctr,
  ps_posid,
  ps_psp_pnr,
  ps_pspid,
  psegment,
  racct,
  rassc,
  rbcur,
  rbukrs,
  rbusa,
  rccur,
  rcntr,
  rdcur,
  recur,
  rfarea,
  rfcur,
  rgcur,
  rhcur,
  rkcur,
  rldnr,
  rocur,
  rsrce,
  rvcur,
  rvunit,
  rwcur,
  ryear,
  sbusa,
  scntr,
  segment,
  sfarea,
  spart,
  usnam,
  vkorg,
  vmsl,
  vsl,
  vtweg,
  werks,
  work_item_id,
  wprice,
  wsl
FROM fins_plan_delsc
;

Learn More