Atpc_Cds_Sto

DDL: ATPC_CDS_STO SQL: ATPC_STO Type: view
47 Fields 1 Data Sources

CDS View for STOs in ATP BOP

Atpc_Cds_Sto is a CDS View that provides data about "CDS View for STOs in ATP BOP" in SAP S/4HANA. It reads from 1 data source (Atpc_Cds_Sto_10) and exposes 47 fields.

Data Sources (1)

SourceAliasJoin Type
Atpc_Cds_Sto_10 Atpc_Cds_Sto_10 from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_STO view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CDS View for STOs in ATP BOP view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (47)

KeyFieldSource TableSource FieldDescription
matnr matnr Vehicle Model
werks werks Receiving Plant
sobkz sobkz Special Stock
sskey sskey Special Stock
sskey_ext sskey_ext Ext. SSKEY
lgort lgort Sublocation
charg
sgt_rcat sgt_rcat Req. Segment
lifnr lifnr Vendor no.
resmd resmd
fixmg fixmg Planned qty
mtvfp mtvfp Avail. check
delnr delnr Order No.(OLTP)
delps delps Order Item
delet delet Scheduling
atpcat atpcat MRP Elmnt Ind.
bstyp bstyp Source doc.cat.
bsart bsart Stnd purch.ord.
base_uom base_uom Weight UoM
order_uom order_uom Valuation Unit
lprio lprio Delivery Prior.
webaz webaz GR Proc. Time
vkorg vkorg SD Sales Org.
vtweg vtweg RefDistCh-Cust/Mat.
spart spart Source supplier
vsbed vsbed Shipping Conditions
vstel vstel ShpPtDeparture
Route Route Vehicle route
aulwe aulwe Route Schedule
plifz plifz Plnd Deliv.Time
tddat tddat TranspPlngDate
tduhr tduhr Tr. Plan. Time
wadat wadat Planned Gds Mvmt
wauhr wauhr GI Time
lddat lddat Loading Date
lduhr lduhr Loading Time
eldat eldat Planned dates
eluhr eluhr GR End Time
sline_date sline_date Initial Entry
sline_time sline_time Time
brgew brgew Weight
gewei gewei Weight Unit
kwmeng kwmeng Sales Quantity
DeliveredQtyInOrderUOM DeliveredQtyInOrderUOM
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
tm_ctrl_key tm_ctrl_key Control Key

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 Atpc_Cds_Sto.
-- 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: ATPC_STO

CREATE VIEW Atpc_Cds_Sto AS
SELECT
  matnr,
  werks,
  sobkz,
  sskey,
  sskey_ext,
  lgort,
  '' AS charg,
  sgt_rcat,
  lifnr,
  resmd,
  fixmg,
  mtvfp,
  delnr,
  delps,
  delet,
  atpcat,
  bstyp,
  bsart,
  base_uom,
  order_uom,
  lprio,
  webaz,
  vkorg,
  vtweg,
  spart,
  vsbed,
  vstel,
  Route,
  aulwe,
  plifz,
  tddat,
  tduhr,
  wadat,
  wauhr,
  lddat,
  lduhr,
  eldat,
  eluhr,
  sline_date,
  sline_time,
  brgew,
  gewei,
  kwmeng,
  DeliveredQtyInOrderUOM,
  CreationDate,
  LastChangeDate,
  tm_ctrl_key
FROM Atpc_Cds_Sto_10
;

Learn More