Atpc_Cds_Resb_D

DDL: ATPC_CDS_RESB_D SQL: ATPC_RESB_D Type: view
21 Fields 1 Data Sources

CDS View on RESB for Reading of Own Deltas in ATP

Atpc_Cds_Resb_D is a CDS View that provides data about "CDS View on RESB for Reading of Own Deltas in ATP" in SAP S/4HANA. It reads from 1 data source (resb) and exposes 21 fields.

Data Sources (1)

SourceAliasJoin Type
resb resb from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_RESB_D view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
EndUserText.label CDS View on RESB for Reading of Own Deltas in ATP view

Fields (21)

KeyFieldSource TableSource FieldDescription
delnr Reservation
delps rspos Item no.
matnr matnr Vehicle Model
werks werks Receiving Plant
lgort lgort Sublocation
charg charg Chargeable Proc.
sobkz sobkz Special Stock
kdauf kdauf SD Document
kdpos kdpos Sales Ord. Item
pspel pspel WBS Element
lifnr lifnr Vendor no.
bdart bdart RequirementType
umwrk umwrk Receiving plant
umlgo umlgo Receiving SLoc.
umsok umsok Special Stock
atpdate bdter Reqmts date
shkzg shkzg Returns
bdmng bdmng Threshold value
enmng enmng Withdrawal Qty
vmeng vmeng Received
xwaok xwaok Mvt Allowed

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_Resb_D.
-- 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_RESB_D

CREATE VIEW Atpc_Cds_Resb_D AS
SELECT
  cast (rsnum as delnr) AS delnr,
  rspos AS delps,
  matnr,
  werks,
  lgort,
  charg,
  sobkz,
  kdauf,
  kdpos,
  pspel,
  lifnr,
  bdart,
  umwrk,
  umlgo,
  umsok,
  bdter AS atpdate,
  shkzg,
  bdmng,
  enmng,
  vmeng,
  xwaok
FROM resb
;

Learn More