Atpc_Cds_Afpo

DDL: ATPC_CDS_AFPO SQL: ATPC_AFPO Type: view

CDS View on AFPO Table for ATP

Atpc_Cds_Afpo is a CDS View that provides data about "CDS View on AFPO Table for ATP" in SAP S/4HANA. It reads from 1 data source (afpo) and exposes 27 fields.

Data Sources (1)

SourceAliasJoin Type
afpo afpo from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ATPC_AFPO 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 AFPO Table for ATP view

Fields (27)

KeyFieldSource TableSource FieldDescription
delnr afpo aufnr SettlementOrder
delps afpo posnr WBS Element
mandt afpo mandt Editing Client
matnr afpo matnr Vehicle Model
werks afpo pwerk Planning Plant
lgort afpo lgort Sublocation
charg afpo charg Chargeable Proc.
sgt_scat afpo sgt_scat Stock Segment
kdauf afpo kdauf SD Document
kdpos afpo kdpos Sales Ord. Item
projn afpo projn WBS Element
dgltp afpo dgltp Basic fin. date
atpdate
psmng afpo psmng Total Quantity
wemng afpo wemng Received
iamng afpo iamng ExpectVarRecipt
psamg afpo psamg Planned Scrap
verto afpo verto Distribution
krsnr afpo krsnr Reservation
krsps afpo krsps Item no.
dfrei afpo dfrei Release ind.
amein afpo amein Order Un
umrez afpo umrez Numerator
umren afpo umren Denominator
bwtar afpo bwtar Valuation Type
dauty afpo dauty Order category
webaz afpo webaz GR Proc. 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_Afpo.
-- 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_AFPO

CREATE VIEW Atpc_Cds_Afpo AS
SELECT
  afpo.aufnr AS delnr,
  afpo.posnr AS delps,
  afpo.mandt AS mandt,
  afpo.matnr AS matnr,
  afpo.pwerk AS werks,
  afpo.lgort AS lgort,
  afpo.charg AS charg,
  afpo.sgt_scat AS sgt_scat,
  afpo.kdauf AS kdauf,
  afpo.kdpos AS kdpos,
  afpo.projn AS projn,
  afpo.dgltp AS dgltp,
  afpo.psmng AS psmng,
  afpo.wemng AS wemng,
  afpo.iamng AS iamng,
  afpo.psamg AS psamg,
  afpo.verto AS verto,
  afpo.krsnr AS krsnr,
  afpo.krsps AS krsps,
  afpo.dfrei AS dfrei,
  afpo.amein AS amein,
  afpo.umrez AS umrez,
  afpo.umren AS umren,
  afpo.bwtar AS bwtar,
  afpo.dauty AS dauty,
  afpo.webaz AS webaz
FROM afpo
;