I_OrderOperationBasic

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 I_OrderOperationBasic.
-- 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: IORDEROPBASIC

CREATE VIEW I_OrderOperationBasic AS
SELECT
  afvc.aufpl AS OrderInternalID,
  afvc.aplzl AS OrderOperationInternalID,
  afvc.aplfl AS Sequence,
  afvc.vornr AS Operation,
  cast(afvc.vornr as vdm_vornr preserving type) AS Operation_2,
  afvc.ktsch AS StandardTextInternalID,
  afvc.ltxa1 AS OperationText,
  afvc.ltxa2 AS OperationSecondText,
  afvc.txtsp AS Language,
  afvc.plnfl AS BillOfOperationsSequence,
  afvc.plnty AS BillOfOperationsType,
  afvc.plnnr AS BillOfOperationsGroup,
  afvc.plnal AS BillOfOperationsVariant,
  afvc.plnkn AS BOOOperationInternalID,
  afvc.tl_versn AS BillOfOperationsVersion,
  afvc.sumnr AS SuperiorOperationInternalID,
  afvc.steus AS OperationControlProfile,
  afvc.arbid AS WorkCenterInternalID,
  'A' AS WorkCenterTypeCode,
  'A ' AS WorkCenterTypeCode_2,
  afvc.werks AS Plant,
  afvc.kalid AS FactoryCalendar,
  afvc.objnr AS ObjectInternalID,
  afvc.bedid AS CapacityRequirement,
  afvc.bedzl AS CapacityRequirementItem,
  afvc.anzzl AS NumberOfCapacities,
  afvc.mlstn AS UsageCode,
  afvc.istru AS Assembly,
  cast(afvc.projn as ps_s4_proj_pspnr preserving type) AS ProjectInternalID,
  afvc.rueck AS OperationConfirmation,
  afvc.rmzhl AS NumberOfOperationConfirmations,
  afvc.aennr AS ChangeNumber,
  afvc.pernr AS OperationPersonResponsible,
  afvc.equnr AS Equipment,
  afvc.tplnr AS FunctionalLocation,
  cast(afvc.tplnr as vdm_eam_tplnr preserving type) AS FunctionalLocation_2,
  afvc.sortl AS OperationPurgInfoRecdSearchTxt,
  afvc.frdlb AS ExtProcgOperationHasSubcontrg,
  afvc.kzfix AS PurgInfoRecdDataIsFixed,
  afvc.infnr AS PurchasingInfoRecord,
  afvc.esokz AS PurchasingInfoRecordCategory,
  afvc.ekorg AS PurchasingOrganization,
  afvc.ekgrp AS PurchasingGroup,
  afvc.banfn AS PurchaseRequisition,
  afvc.bnfpo AS PurchaseRequisitionItem,
  afvc.ebeln AS PurchasingDocument,
  afvc.ebelp AS PurchasingDocumentItem,
  afvc.matkl AS MaterialGroup,
  afvc.wempf AS GoodsRecipientName,
  afvc.ablad AS UnloadingPointName,
  afvc.bukrs AS CompanyCode,
  afvc.gsber AS BusinessArea,
  afvc.prctr AS ProfitCenter,
  afvc.sakto AS CostElement,
  afvc.klvar AS CostingVariant,
  afvc.kalnr AS CostEstimate,
  afvc.kalsm AS CostingSheet,
  afvc.anfko AS RequestingCostCenter,
  afvc.indet AS OperationCalculationControl,
  afvc.selkz AS OperationCostingRelevancyType,
  afvc.netzkont AS NtwkAccountAssignmentCode,
  afvc.clasf AS ActyIsTakenAcctForProjSmmry,
  afvc.owaer AS ControllingObjectCurrency,
  cast(afvc.scope as pph_scope preserving type) AS ControllingObjectClass,
  afvc.txjcd AS TaxJurisdiction,
  afvc.func_area AS FunctionalArea,
  afvc.larnt AS CostCtrActivityType,
  afvc.waers AS Currency,
  afvc.prkst AS PlannedActivityCost,
  afvc.rfgrp AS OperationSetupGroupCategory,
  afvc.rfsch AS OperationSetupGroup,
  afvc.rasch AS OperationSetupType,
  afvc.uemus AS OperationOverlappingIsRequired,
  afvc.uekan AS OperationOverlappingIsPossible,
  afvc.flies AS OperationsIsAlwaysOverlapping,
  afvc.spmus AS OperationSplitIsRequired,
  afvc.splim AS MaximumNumberOfSplits,
  afvc.rstra AS LeadTimeReductionStrategy,
  afvc.zschl AS OverheadCode,
  afvc.phflg AS MfgOrderOperationIsPhase,
  afvc.pvzkn AS OrderIntBillOfOpItemOfPhase,
  afvc.nprio AS OperationImportance,
  afvc.spanz AS ActualNumberOfSplits,
  afvc.loekz AS OperationIsToBeDeleted,
  afvc.pprio AS NetworkActivityPriority,
  afvc.aufak AS OperationScrapPercent,
  afvc.anlzu AS OperationSystemCondition,
  afvc.prznt AS OperationWorkPercent,
  cast(afvc.maintopexecutionphasecode as eam_premainpost_cds preserving type) AS MaintOperationExecStageCode,
  afvc.maintordopprocessphasecode AS MaintOrdOpProcessPhaseCode,
  afvc.maintordopprocesssubphasecode AS MaintOrdOpProcessSubPhaseCode,
  afvc.oan_inst_id_setup AS SetupOpActyNtwkInstance,
  afvc.oan_inst_id_produce AS ProduceOpActyNtwkInstance,
  afvc.oan_inst_id_teardown AS TeardownOpActyNtwkInstance
FROM afvc
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenterByInternalID ON _WorkCenterByInternalID.WorkCenterTypeCode = 'A ' AND WorkCenterInternalID = _WorkCenterByInternalID.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationLongText AS _LongText ON OrderInternalID = _LongText.OrderInternalID AND OrderOperationInternalID = _LongText.OrderOperationInternalID  -- association [0..1]
;