I_FailedOrderConfirmation

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_FailedOrderConfirmation.
-- 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: IFAILEDORDERCONF

CREATE VIEW I_FailedOrderConfirmation AS
SELECT
  cast(afrv.afori as ru_orina preserving type) AS ConfirmationApplicationOrigin,
  cast(afrv.afruv as vdm_afruv preserving type) AS FailedOrderConfirmationGroup,
  cast(afrv.counter as failed_conf preserving type) AS FailedOrderConfirmation,
  cast(afrv.vtext as vdm_vtext preserving type) AS FailedOrderConfirmationText,
  cast(afrv.ldate as ru_ersda preserving type) AS ConfirmationEntryDate,
  cast(afrv.ltime as ru_erzet preserving type) AS ConfirmationEntryTime,
  cast(afrv.exerd as ru_exerd preserving type) AS ConfirmationExternalEntryDate,
  cast(afrv.exerz as ru_exerz preserving type) AS ConfirmationExternalEntryTime,
  cast(afrv.exnam as vdm_exnam preserving type) AS EnteredByExternalUser,
  afrv.ausor AS OpenReservationsIsCleared,
  cast(afrv.aueru as pph_aueru preserving type) AS FinalConfirmationType,
  cast(afrv.satza as co_satza preserving type) AS OrderConfirmationRecordType,
  cast(afrv.pdsnr as vdm_pdsnr preserving type) AS SequentialPlantDataCollection,
  cast(afrv.rueck as pph_rueck preserving type) AS ConfirmationGroup,
  cast(afrv.rmzhl as pph_rmzhl preserving type) AS ConfirmationCount,
  cast(afrv.autyp as pph_autyp preserving type) AS OrderCategory,
  case when afrv.afori <> '4' then afrv.aufnr end as OrderID AS aufnrendasOrderID,
  afrv.werks AS Plant,
  afrv.arbpl AS WorkCenter,
  cast(afrv.kapar as pph_kapart preserving type) AS CapacityCategory,
  cast(afrv.split as pph_split preserving type) AS CapacityRequirementSplit,
  afrv.pknum AS KanbanControlCycle,
  afrv.pkpos AS KanbanControlCycleItem,
  afrv.pkkey AS KanbanContainer,
  afrv.gsber AS BusinessArea,
  afrv.bukrs AS CompanyCode,
  afrv.kokrs AS ControllingArea,
  afrv.txjcd AS TaxJurisdiction,
  cast(afrv.pernr as pph_pernr preserving type) AS Personnel,
  cast(afrv.zausw as pph_zausw preserving type) AS TimeRecording,
  cast(afrv.loart as pph_loart preserving type) AS EmployeeWageType,
  cast(afrv.logrp as pph_logrp preserving type) AS EmployeeWageGroup,
  cast(afrv.qualf as pph_qualf preserving type) AS EmployeeSuitability,
  cast(afrv.anzma as pph_anzms preserving type) AS NumberOfEmployees,
  cast(afrv.budat as pph_budat preserving type) AS PostingDate,
  cast(substring(afrv.budat, 1, 4) as calendaryear) AS PostingDateYear,
  cast(afrv.isdd as vdm_isdd preserving type) AS ConfirmedExecutionStartDate,
  cast(afrv.isdz as vdm_isdz preserving type) AS ConfirmedExecutionStartTime,
  cast(afrv.ierd as vdm_ierd preserving type) AS ConfirmedSetupEndDate,
  cast(afrv.ierz as vdm_ierz preserving type) AS ConfirmedSetupEndTime,
  cast(afrv.isbd as vdm_isbd preserving type) AS ConfirmedProcessingStartDate,
  cast(afrv.isbz as vdm_isbz preserving type) AS ConfirmedProcessingStartTime,
  cast(afrv.iebd as vdm_iebd preserving type) AS ConfirmedProcessingEndDate,
  cast(afrv.iebz as vdm_iebz preserving type) AS ConfirmedProcessingEndTime,
  cast(afrv.isad as vdm_isad preserving type) AS ConfirmedTeardownStartDate,
  cast(afrv.isaz as vdm_isaz preserving type) AS ConfirmedTeardownStartTime,
  cast(afrv.iedd as vdm_iedd preserving type) AS ConfirmedExecutionEndDate,
  cast(afrv.iedz as vdm_iedz preserving type) AS ConfirmedExecutionEndTime,
  afrv.meinh AS ConfirmationUnit,
  afrv.lmnga AS ConfirmationYieldQuantity,
  afrv.xmnga AS ConfirmationScrapQuantity,
  afrv.rmnga AS ConfirmationReworkQuantity,
  cast((afrv.lmnga + afrv.xmnga + afrv.rmnga) as pph_tmnga) AS ConfirmationTotalQuantity,
  cast(afrv.grund as pph_agrnd preserving type) AS VarianceReasonCode,
  cast(afrv.ile01 as vdm_ile01 preserving type) AS OpWorkQuantityUnit1,
  cast(afrv.ism01 as vdm_ism01 preserving type) AS OpConfirmedWorkQuantity1,
  cast(afrv.lek01 as vdm_lek01 preserving type) AS NoFurtherOpWorkQuantity1IsExpd,
  cast(afrv.ile02 as vdm_ile02 preserving type) AS OpWorkQuantityUnit2,
  cast(afrv.ism02 as vdm_ism02 preserving type) AS OpConfirmedWorkQuantity2,
  cast(afrv.lek02 as vdm_lek02 preserving type) AS NoFurtherOpWorkQuantity2IsExpd,
  cast(afrv.ile03 as vdm_ile03 preserving type) AS OpWorkQuantityUnit3,
  cast(afrv.ism03 as vdm_ism03 preserving type) AS OpConfirmedWorkQuantity3,
  cast(afrv.lek03 as vdm_lek03 preserving type) AS NoFurtherOpWorkQuantity3IsExpd,
  cast(afrv.ile04 as vdm_ile04 preserving type) AS OpWorkQuantityUnit4,
  cast(afrv.ism04 as vdm_ism04 preserving type) AS OpConfirmedWorkQuantity4,
  cast(afrv.lek04 as vdm_lek04 preserving type) AS NoFurtherOpWorkQuantity4IsExpd,
  cast(afrv.ile05 as vdm_ile05 preserving type) AS OpWorkQuantityUnit5,
  cast(afrv.ism05 as vdm_ism05 preserving type) AS OpConfirmedWorkQuantity5,
  cast(afrv.lek05 as vdm_lek05 preserving type) AS NoFurtherOpWorkQuantity5IsExpd,
  cast(afrv.ile06 as vdm_ile06 preserving type) AS OpWorkQuantityUnit6,
  cast(afrv.ism06 as vdm_ism06 preserving type) AS OpConfirmedWorkQuantity6,
  cast(afrv.lek06 as vdm_lek06 preserving type) AS NoFurtherOpWorkQuantity6IsExpd,
  afrv.ismne AS ActualWorkQuantityUnit,
  afrv.ismnw AS ActualWorkQuantity,
  afrv.ofmne AS RemainingWorkQuantityUnit,
  afrv.ofmnw AS RemainingWorkQuantity,
  afrv.leknw AS NoFurtherWorkQuantityIsExpd,
  afrv.learr AS ActivityType,
  afrv.prz01 AS BusinessProcess,
  afrv.ipre1 AS BusinessProcessEntryUnit,
  afrv.iprz1 AS BusinessProcessConfirmedQty,
  afrv.iprk1 AS NoFurtherBusinessProcQtyIsExpd,
  afrv.opre1 AS BusinessProcRemainingQtyUnit,
  cast(afrv.oprz1 as pph_oprz1 preserving type) AS BusinessProcessRemainingQty,
  cast(afrv.idaue as vdm_idaure preserving type) AS ActualDurationUnit,
  afrv.idaur AS ActualDuration,
  afrv.zeier AS BreakDurationUnit,
  afrv.iserh AS ConfirmedBreakDuration
FROM afrv
LEFT OUTER JOIN I_ConfirmationApplOrigin AS _ConfirmationApplOrigin ON ConfirmationApplicationOrigin = _ConfirmationApplOrigin.ConfirmationApplicationOrigin  -- association [1..1]
LEFT OUTER JOIN I_FailedOrderConfirmationGroup AS _FailedOrderConfirmationGroup ON ConfirmationApplicationOrigin = _FailedOrderConfirmationGroup.ConfirmationApplicationOrigin AND FailedOrderConfirmationGroup = _FailedOrderConfirmationGroup.FailedOrderConfirmationGroup  -- association [1..1]
LEFT OUTER JOIN I_ConfirmationGroup AS _ConfirmationGroup ON ConfirmationGroup = _ConfirmationGroup.ConfirmationGroup  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationCount AS _ConfirmationCount ON ConfirmationGroup = _ConfirmationCount.ConfirmationGroup AND ConfirmationCount = _ConfirmationCount.ConfirmationCount  -- association [0..1]
LEFT OUTER JOIN I_FinalConfirmationType AS _FinalConfirmationType ON FinalConfirmationType = _FinalConfirmationType.FinalConfirmationType  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationRecordType AS _ConfirmationRecordType ON OrderConfirmationRecordType = _ConfirmationRecordType.OrderConfirmationRecordType  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [1..1]
LEFT OUTER JOIN I_OrderSequenceBySemKey AS _OrderSequence ON OrderID = _OrderSequence.OrderID AND Sequence = _OrderSequence.Sequence  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenter ON Plant = _WorkCenter.Plant AND WorkCenter = _WorkCenter.WorkCenter  -- association [0..1]
LEFT OUTER JOIN I_CapacityCategory AS _CapacityCategory ON CapacityCategory = _CapacityCategory.CapacityCategoryCode  -- association [0..1]
LEFT OUTER JOIN I_KanbanControlCycle AS _KanbanControlCycle ON KanbanControlCycle = _KanbanControlCycle.KanbanControlCycle  -- association [0..1]
LEFT OUTER JOIN I_KanbanControlCycleItem AS _KanbanControlCycleItem ON KanbanControlCycle = _KanbanControlCycleItem.KanbanControlCycle AND KanbanControlCycleItem = _KanbanControlCycleItem.KanbanControlCycleItem  -- association [0..1]
LEFT OUTER JOIN I_KanbanContainer AS _KanbanContainer ON KanbanContainer = _KanbanContainer.KanbanContainer  -- association [0..1]
LEFT OUTER JOIN I_FailedConfirmationLog AS _FailedConfirmationLog ON SequentialPlantDataCollection = _FailedConfirmationLog.SequentialPlantDataCollection  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _Fund ON Fund = _Fund.Fund  -- association [0..*]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON ControllingArea = _BusinessProcess.ControllingArea AND BusinessProcess = _BusinessProcess.BusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BusinessProcessUnit ON BusinessProcessEntryUnit = _BusinessProcessUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConfirmationUnit ON ConfirmationUnit = _ConfirmationUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit1 ON OpWorkQuantityUnit1 = _WorkQuantityUnit1.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit2 ON OpWorkQuantityUnit2 = _WorkQuantityUnit2.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit3 ON OpWorkQuantityUnit3 = _WorkQuantityUnit3.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit4 ON OpWorkQuantityUnit4 = _WorkQuantityUnit4.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit5 ON OpWorkQuantityUnit5 = _WorkQuantityUnit5.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit6 ON OpWorkQuantityUnit6 = _WorkQuantityUnit6.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ActualWorkQuantityUnit ON ActualWorkQuantityUnit = _ActualWorkQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RemainingWorkQuantityUnit ON RemainingWorkQuantityUnit = _RemainingWorkQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ActualDurationUnit ON ActualDurationUnit = _ActualDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BreakDurationUnit ON BreakDurationUnit = _BreakDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_VarianceReason AS _VarianceReason ON Plant = _VarianceReason.Plant AND VarianceReasonCode = _VarianceReason.VarianceReasonCode  -- association [0..1]
LEFT OUTER JOIN I_EmployeeWageGroup AS _EmployeeWageGroup ON Plant = _EmployeeWageGroup.Plant AND EmployeeWageGroup = _EmployeeWageGroup.EmployeeWageGroup  -- association [0..1]
LEFT OUTER JOIN I_EmployeeSuitability AS _EmployeeSuitability ON Plant = _EmployeeSuitability.Plant AND EmployeeSuitability = _EmployeeSuitability.EmployeeSuitability  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _Employee ON Personnel = _Employee.PersonExternalID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON Personnel = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PostingDate ON PostingDate = _PostingDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_CalendarYear AS _PostingDateYear ON PostingDateYear = _PostingDateYear.CalendarYear  -- association [1..1]
;