ATPC_CDS_PLPW

DDL: ATPC_CDS_PLPW SQL: ATPC_PLPW Type: view
20 Fields 1 Data Sources

CDS view on PLPW/PLAF for ATP

ATPC_CDS_PLPW is a CDS View that provides data about "CDS view on PLPW/PLAF for ATP" in SAP S/4HANA. It reads from 1 data source (plaf) and exposes 20 fields.

Data Sources (1)

SourceAliasJoin Type
plaf plaf from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_PLPW 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 PLPW/PLAF for ATP view

Fields (20)

KeyFieldSource TableSource FieldDescription
matnr matnr Vehicle Model
pwwrk pwwrk Production Plant
plnum plnum Planned Order
beskz beskz Procuremt Type
sobes sobes Spec. procuremt
gsmng gsmng Total Quantity
avmng avmng Scrap Quantity
psttr psttr Order Start
lgort lgort Sublocation
reslo reslo Iss. Stor. Loc.
kdauf kdauf SD Document
kdpos kdpos Sales Ord. Item
sobkz sobkz Special Stock
pspel pspel WBS Element
meins meins Valuation Unit
plwrk plwrk Planning Plant
berid berid Single-Character Flag
pedtr pedtr Order End Date
pedti pedti Order End Time
pstti pstti Order Start Time

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

CREATE VIEW ATPC_CDS_PLPW AS
SELECT
  matnr,
  pwwrk,
  plnum,
  beskz,
  sobes,
  gsmng,
  avmng,
  psttr,
  lgort,
  reslo,
  kdauf,
  kdpos,
  sobkz,
  pspel,
  meins,
  plwrk,
  berid,
  pedtr,
  pedti,
  pstti
FROM plaf
;

Learn More