P_ProcOrdMgmtOpDetails

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_ProcOrdMgmtOpDetails.
-- 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: PPORMGMTOPDET

CREATE VIEW P_ProcOrdMgmtOpDetails AS
SELECT
  afvc.aufpl AS aufpl,
  afvc.aplzl AS aplzl,
  afvc.aplfl AS aplfl,
  afvc.plnfl AS plnfl,
  afvc.plnty AS plnty,
  afvc.plnnr AS plnnr,
  afvc.plnal AS plnal,
  afvc.plnkn AS plnkn,
  afvc.vornr AS vornr,
  afvc.sumnr AS sumnr,
  afvc.steus AS steus,
  afvc.arbid AS arbid,
  'A' AS arbty,
  afvc.werks AS werks,
  afvc.kalid AS kalid,
  afvc.bedid AS bedid,
  afvc.bedzl AS bedzl,
  afvc.loekz AS loekz,
  afvc.ktsch AS ktsch,
  afvc.ltxa1 AS ltxa1,
  afvc.txtsp AS txtsp,
  afvc.vplty AS vplty,
  afvc.vplnr AS vplnr,
  afvc.vplal AS vplal,
  afvc.vplfl AS vplfl,
  afvc.vgwts AS vgwts,
  afvc.lar01 AS lar01,
  afvc.lar02 AS lar02,
  afvc.lar03 AS lar03,
  afvc.lar04 AS lar04,
  afvc.lar05 AS lar05,
  afvc.lar06 AS lar06,
  afvc.loanz AS loanz,
  afvc.loart AS loart,
  afvc.logrp AS logrp,
  afvc.rsanz AS rsanz,
  afvc.qualf AS qualf,
  afvc.anzma AS anzma,
  afvc.rfgrp AS rfgrp,
  afvc.rfsch AS rfsch,
  afvc.rasch AS rasch,
  afvc.aufak AS aufak,
  afvc.uemus AS uemus,
  afvc.uekan AS uekan,
  afvc.flies AS flies,
  afvc.spmus AS spmus,
  afvc.splim AS splim,
  afvc.rstra AS rstra,
  afvc.sortl AS sortl,
  afvc.lifnr AS lifnr,
  afvc.preis AS preis,
  afvc.peinh AS peinh,
  afvc.waers AS waers,
  afvc.sakto AS sakto,
  afvc.infnr AS infnr,
  afvc.esokz AS esokz,
  afvc.ekorg AS ekorg,
  afvc.ekgrp AS ekgrp,
  afvc.kzlgf AS kzlgf,
  afvc.kzwrtf AS kzwrtf,
  afvc.matkl AS matkl,
  afvc.ddehn AS ddehn,
  afvc.anzzl AS anzzl,
  afvc.prznt AS prznt,
  afvc.mlstn AS mlstn,
  afvc.pprio AS pprio,
  afvc.bukrs AS bukrs,
  afvc.gsber AS gsber,
  afvc.prctr AS prctr,
  afvc.klvar AS klvar,
  afvc.kalnr AS kalnr,
  afvc.anfko AS anfko,
  afvc.anfkokrs AS anfkokrs,
  afvc.indet AS indet,
  afvc.larnt AS larnt,
  afvc.prkst AS prkst,
  afvc.rueck AS rueck,
  afvc.rmzhl AS rmzhl,
  afvc.projn AS projn,
  afvc.objnr AS objnr,
  afvc.spanz AS spanz,
  afvc.banfn AS banfn,
  afvc.bnfpo AS bnfpo,
  afvc.ebeln AS ebeln,
  afvc.ebelp AS ebelp,
  afvc.wempf AS wempf,
  afvc.ablad AS ablad,
  afvc.clasf AS clasf,
  afvc.frunv AS frunv,
  afvc.zschl AS zschl,
  afvc.kalsm AS kalsm,
  afvc.lek01 AS lek01,
  afvc.lek02 AS lek02,
  afvc.lek03 AS lek03,
  afvc.lek04 AS lek04,
  afvc.lek05 AS lek05,
  afvc.lek06 AS lek06,
  afvc.selkz AS selkz,
  afvc.stdkn AS stdkn,
  afvc.anlzu AS anlzu,
  afvc.istru AS istru,
  afvc.istty AS istty,
  afvc.istnr AS istnr,
  afvc.istkn AS istkn,
  afvc.istpo AS istpo,
  afvc.iupoz AS iupoz,
  afvc.ebort AS ebort,
  afvc.vertl AS vertl,
  afvc.leknw AS leknw,
  afvc.nprio AS nprio,
  afvc.pvzkn AS pvzkn,
  afvc.phflg AS phflg,
  afvc.phseq AS phseq,
  afvc.knobj AS knobj,
  afvc.otype AS otype,
  afvc.objektid AS objektid,
  afvc.qlkapar AS qlkapar,
  afvc.rstuf AS rstuf,
  afvc.subsys AS subsys,
  afvc.packno AS packno,
  afvc.txjcd AS txjcd,
  cast(afvc.scope as pph_scope preserving type) AS scope,
  afvc.no_disp AS no_disp,
  afvc.arbii AS arbii,
  afvc.werki AS werki,
  afvc.qkzprzeit AS qkzprzeit,
  afvc.qkzztmg1 AS qkzztmg1,
  afvc.qkzprmeng AS qkzprmeng,
  afvc.qkzprfrei AS qkzprfrei,
  afvc.qkztlsbest AS qkztlsbest,
  afvc.kzfeat AS kzfeat,
  afvc.aennr AS aennr,
  afvc.cuobj_arb AS cuobj_arb,
  afvc.evgew AS evgew,
  afvc.netzkont AS netzkont,
  afvc.owaer AS owaer,
  afvc.afnam AS afnam,
  afvc.bednr AS bednr,
  afvc.kzfix AS kzfix,
  afvc.pernr AS pernr,
  afvc.frdlb AS frdlb,
  afvc.qpart AS qpart,
  afvc.wkurs AS wkurs,
  afvc.prod_act AS prod_act,
  afvc.fplnr AS fplnr,
  afvc.objtype AS objtype,
  afvc.ch_proc AS ch_proc,
  afvc.fordn AS fordn,
  afvc.fordp AS fordp,
  afvc.mat_prkst AS mat_prkst,
  afvc.prz01 AS prz01,
  afvc.rfpnt AS rfpnt,
  afvc.func_area AS func_area,
  afvc.techs AS techs,
  afvc.adpsp AS adpsp,
  afvc.rfippnt AS rfippnt,
  afvc.mes_operid AS mes_operid,
  afvc.mes_stepid AS mes_stepid,
  afvc.cy_seqnrv AS cy_seqnrv,
  afvc.kapt_puffr AS kapt_puffr,
  afvc.tl_versn AS tl_versn,
  afvv.meinh AS meinh,
  afvv.bmsch AS bmsch,
  afvv.umren AS umren,
  afvv.umrez AS umrez,
  afvv.zmerh AS zmerh,
  afvv.zeier AS zeier,
  afvv.vgw01 AS vgw01,
  afvv.vgw02 AS vgw02,
  afvv.vgw03 AS vgw03,
  afvv.vgw04 AS vgw04,
  afvv.vgw05 AS vgw05,
  afvv.vgw06 AS vgw06,
  afvv.vge01 AS vge01,
  afvv.vge02 AS vge02,
  afvv.vge03 AS vge03,
  afvv.vge04 AS vge04,
  afvv.vge05 AS vge05,
  afvv.vge06 AS vge06,
  afvv.ile01 AS ile01,
  afvv.ile02 AS ile02,
  afvv.ile03 AS ile03,
  afvv.ile04 AS ile04,
  afvv.ile05 AS ile05,
  afvv.ile06 AS ile06,
  afvv.ism01 AS ism01,
  afvv.ism02 AS ism02,
  afvv.ism03 AS ism03,
  afvv.ism04 AS ism04,
  afvv.ism05 AS ism05,
  afvv.ism06 AS ism06,
  afvv.ismnw AS ismnw,
  afvv.zeimu AS zeimu,
  afvv.zminu AS zminu,
  afvv.zeilm AS zeilm,
  afvv.zlmax AS zlmax,
  afvv.zeilp AS zeilp,
  afvv.zlpro AS zlpro,
  afvv.zeiwn AS zeiwn,
  afvv.zwnor AS zwnor,
  afvv.zeiwm AS zeiwm,
  afvv.zwmin AS zwmin,
  afvv.zeitn AS zeitn,
  afvv.ztnor AS ztnor,
  afvv.zeitm AS zeitm,
  afvv.ztmin AS ztmin,
  afvv.plifz AS plifz,
  afvv.dauno AS dauno,
  afvv.daune AS daune,
  afvv.daumi AS daumi,
  afvv.daume AS daume,
  afvv.einsa AS einsa,
  afvv.einse AS einse,
  afvv.arbei AS arbei,
  afvv.arbeh AS arbeh,
  afvv.mgvrg AS mgvrg,
  afvv.asvrg AS asvrg,
  afvv.lmnga AS lmnga,
  afvv.xmnga AS xmnga,
  afvv.gmnga AS gmnga,
  afvv.rmnga AS rmnga,
  afvv.fsavd AS fsavd,
  afvv.fsavz AS fsavz,
  afvv.fssbd AS fssbd,
  afvv.fssbz AS fssbz,
  afvv.fssad AS fssad,
  afvv.fssaz AS fssaz,
  afvv.fsedd AS fsedd,
  afvv.fsedz AS fsedz,
  afvv.fssld AS fssld,
  afvv.fsslz AS fsslz,
  afvv.fseld AS fseld,
  afvv.fselz AS fselz,
  afvv.ssavd AS ssavd,
  afvv.ssavz AS ssavz,
  afvv.sssbd AS sssbd,
  afvv.sssbz AS sssbz,
  afvv.sssad AS sssad,
  afvv.sssaz AS sssaz,
  afvv.ssedd AS ssedd,
  afvv.ssedz AS ssedz,
  afvv.sssld AS sssld,
  afvv.ssslz AS ssslz,
  afvv.sseld AS sseld,
  afvv.sselz AS sselz,
  afvv.isavd AS isavd,
  afvv.ieavd AS ieavd,
  afvv.isdd AS isdd,
  afvv.isdz AS isdz,
  afvv.ierd AS ierd,
  afvv.ierz AS ierz,
  afvv.isbd AS isbd,
  afvv.isbz AS isbz,
  afvv.iebd AS iebd,
  afvv.iebz AS iebz,
  afvv.isad AS isad,
  afvv.isaz AS isaz,
  afvv.iedd AS iedd,
  afvv.iedz AS iedz,
  afvv.pedd AS pedd,
  afvv.pedz AS pedz,
  afvv.puffr AS puffr,
  afvv.pufgs AS pufgs,
  afvv.ntanf AS ntanf,
  afvv.ntanz AS ntanz,
  afvv.ntend AS ntend,
  afvv.ntenz AS ntenz,
  afvv.ewstd AS ewstd,
  afvv.ewstz AS ewstz,
  afvv.ewend AS ewend,
  afvv.ewenz AS ewenz,
  afvv.ewdan AS ewdan,
  afvv.ewdne AS ewdne,
  afvv.ewdam AS ewdam,
  afvv.ewdme AS ewdme,
  afvv.ewste AS ewste,
  afvv.ewsta AS ewsta,
  afvv.wartz AS wartz,
  afvv.wrtze AS wrtze,
  afvv.ruest AS ruest,
  afvv.rstze AS rstze,
  afvv.bearz AS bearz,
  afvv.beaze AS beaze,
  afvv.abrue AS abrue,
  afvv.aruze AS aruze,
  afvv.liegz AS liegz,
  afvv.ligze AS ligze,
  afvv.tranz AS tranz,
  afvv.traze AS traze,
  afvv.iserh AS iserh,
  afvv.ofm01 AS ofm01,
  afvv.ofm02 AS ofm02,
  afvv.ofm03 AS ofm03,
  afvv.ofm04 AS ofm04,
  afvv.ofm05 AS ofm05,
  afvv.ofm06 AS ofm06,
  afvv.ofmnw AS ofmnw,
  afvv.bzoffb AS bzoffb,
  afvv.ehoffb AS ehoffb,
  afvv.offstb AS offstb,
  afvv.offste AS offste,
  afvv.bzoffe AS bzoffe,
  afvv.ehoffe AS ehoffe,
  afvv.fpavd AS fpavd,
  afvv.fpavz AS fpavz,
  afvv.fpedd AS fpedd,
  afvv.fpedz AS fpedz,
  afvv.spavd AS spavd,
  afvv.spavz AS spavz,
  afvv.spedd AS spedd,
  afvv.spedz AS spedz,
  afvv.beazp AS beazp,
  afvv.pufgp AS pufgp,
  afvv.puffp AS puffp,
  afvv.bearp AS bearp,
  afvv.epanf AS epanf,
  afvv.epanz AS epanz,
  afvv.epend AS epend,
  afvv.epenz AS epenz,
  afvv.pdau AS pdau,
  afvv.pdae AS pdae,
  afvv.knote AS knote,
  afvv.vstzw AS vstzw,
  afvv.vstga AS vstga,
  afvv.aufkt AS aufkt,
  afvv.rwfak AS rwfak,
  afvv.iprz1 AS iprz1,
  afvv.ipre1 AS ipre1,
  afvv.iprk1 AS iprk1,
  afvv.oprz1 AS oprz1,
  afvv.opre1 AS opre1,
  afvv.takt AS takt,
  afvu.slwid AS slwid,
  afvu.usr00 AS usr00,
  afvu.usr01 AS usr01,
  afvu.usr02 AS usr02,
  afvu.usr03 AS usr03,
  afvu.usr04 AS usr04,
  afvu.use04 AS use04,
  afvu.usr05 AS usr05,
  afvu.use05 AS use05,
  afvu.usr06 AS usr06,
  afvu.use06 AS use06,
  afvu.usr07 AS usr07,
  afvu.use07 AS use07,
  afvu.usr08 AS usr08,
  afvu.usr09 AS usr09,
  afvu.usr10 AS usr10,
  afvu.usr11 AS usr11,
  '00' AS ProcOrdOpStatusCode,
  cast(0 as abap.int8) AS OpPlannedProcessingDurn,
  cast(0 as abap.int8) AS OpActualProcessingDurn,
  '' AS ConfirmationIsNotPossible,
  '' AS OperationIsInterrupted,
  cast('0000' as abap.char( 4 ) ) AS ManufacturingOrderOperation
INNER JOIN afvv ON /* join condition not captured in parsed metadata */
;