P_ProdOrdMgmtOpBasic

DDL: P_PRODORDMGMTOPBASIC Type: view_entity BASIC
43 Fields 2 Data Sources

P_ProdOrdMgmtOpBasic is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (afvv, I_LogisticsOrder) and exposes 43 fields with key fields aufpl, aplzl.

Data Sources (2)

SourceAliasJoin Type
afvv afvv inner
I_LogisticsOrder aufv inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY aufpl afvc aufpl TaskList No.Ops
KEY aplzl afvc aplzl Plan No.f.Oper.
ManufacturingOrder I_LogisticsOrder OrderID Order ID
ManufacturingOrderCategory I_LogisticsOrder OrderCategory Order Category
ManufacturingOrderType I_LogisticsOrder OrderType Order Type
ProductionPlant I_LogisticsOrder Plant Valuation Area
ProductionSupervisor I_LogisticsOrder ProductionSupervisor Prodn Supervisor
aplfl afvc aplfl Sequence
vornr afvc vornr Operation
ltxa1 afvc ltxa1 Short Text
txtsp afvc txtsp Language
plnfl afvc plnfl Sequence
plnty afvc plnty Task List Type
plnnr afvc plnnr Task List Group
plnal afvc plnal Referenced BOO Variant
plnkn afvc plnkn Task list node
tl_versn afvc tl_versn Routing Version
istty afvc istty BOM category
istnr afvc istnr BOM
istkn afvc istkn Item node
istpo afvc istpo Counter
sumnr afvc sumnr Sup. Op. Node
arbid afvc arbid WorkCtrGp plan.
arbty
werks afvc werks Receiving Plant
objnr afvc objnr Val. Obj. No.
pvzkn afvc pvzkn Node
phflg afvc phflg Ind.: Phase
meinh afvv meinh Unit of Measure
mgvrg afvv mgvrg Operation Qty
asvrg afvv asvrg Planned Scrap
lmnga afvv lmnga Yield Quantity
xmnga afvv xmnga Scrap Quantity
fsedd afvv fsedd EarliestEndDate
fsedz afvv fsedz Earliest finish
ssavd afvv ssavd Latest start
ssavz afvv ssavz Lat. start time
ssedd afvv ssedd Lat.finish date
ssedz afvv ssedz Latest fin.time
isdd afvv isdd Start Execution
isdz afvv isdz Execution Start Time
iedd afvv iedd Finish Execut.
iedz afvv iedz Execution End 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 P_ProdOrdMgmtOpBasic.
-- 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.

CREATE VIEW P_ProdOrdMgmtOpBasic AS
SELECT
  afvc.aufpl AS aufpl,
  afvc.aplzl AS aplzl,
  aufv.OrderID AS ManufacturingOrder,
  aufv.OrderCategory AS ManufacturingOrderCategory,
  aufv.OrderType AS ManufacturingOrderType,
  aufv.Plant AS ProductionPlant,
  aufv.ProductionSupervisor AS ProductionSupervisor,
  afvc.aplfl AS aplfl,
  afvc.vornr AS vornr,
  afvc.ltxa1 AS ltxa1,
  afvc.txtsp AS txtsp,
  afvc.plnfl AS plnfl,
  afvc.plnty AS plnty,
  afvc.plnnr AS plnnr,
  afvc.plnal AS plnal,
  afvc.plnkn AS plnkn,
  afvc.tl_versn AS tl_versn,
  afvc.istty AS istty,
  afvc.istnr AS istnr,
  afvc.istkn AS istkn,
  afvc.istpo AS istpo,
  afvc.sumnr AS sumnr,
  afvc.arbid AS arbid,
  'A' AS arbty,
  afvc.werks AS werks,
  afvc.objnr AS objnr,
  afvc.pvzkn AS pvzkn,
  afvc.phflg AS phflg,
  afvv.meinh AS meinh,
  afvv.mgvrg AS mgvrg,
  afvv.asvrg AS asvrg,
  afvv.lmnga AS lmnga,
  afvv.xmnga AS xmnga,
  afvv.fsedd AS fsedd,
  afvv.fsedz AS fsedz,
  afvv.ssavd AS ssavd,
  afvv.ssavz AS ssavz,
  afvv.ssedd AS ssedd,
  afvv.ssedz AS ssedz,
  afvv.isdd AS isdd,
  afvv.isdz AS isdz,
  afvv.iedd AS iedd,
  afvv.iedz AS iedz
INNER JOIN I_LogisticsOrder AS aufv ON /* join condition not captured in parsed metadata */
INNER JOIN afvv ON /* join condition not captured in parsed metadata */
;

Learn More