I_LogisticsOrderBasic

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_LogisticsOrderBasic.
-- 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: ILOGSORDBASIC

CREATE VIEW I_LogisticsOrderBasic AS
SELECT
  afko.aufnr AS OrderID,
  cast(afko.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  afko.aprio AS PriorityCode,
  afko.prodnet AS MfgOrderIsPartOfCollvOrder,
  cast(afko.naucost as vdm_naucost preserving type) AS OrderIsNotCostedAutomatically,
  cast(afko.nauterm as vdm_nauterm preserving type) AS OrdIsNotSchedldAutomatically,
  afko.stufe AS MfgOrderHierarchyLevel,
  afko.stufe AS OrderHierarchyLevelValue,
  afko.wegxx AS OrderHierarchyPathValue,
  afko.flexible_processing AS ProdnProcgIsFlexible,
  afko.maufnr AS MfgOrderSuperiorMfgOrder,
  cast(afko.pronr as ps_s4_proj_pspnr preserving type) AS ProjectInternalID,
  afko.rsnum AS Reservation,
  afko.arsnr AS SettlementReservation,
  afko.rueck AS MfgOrderConfirmation,
  afko.rmzhl AS MfgOrderConfirmationCount,
  afko.bedid AS CapacityRequirement,
  afko.prueflos AS InspectionLot,
  afko.aennr AS ChangeNumber,
  cast(afko.terkz as pph_termkz preserving type) AS BasicSchedulingType,
  afko.breaks AS SchedulingIsAllowingForBreaks,
  afko.plart AS ProdAvailyCheckPlanningType,
  afko.netzkont AS NtwkAccountAssignmentCode,
  afko.profid AS NetworkProfile,
  afko.cuobj AS ProductConfiguration,
  cast(afko.revlv as vdm_qm_revlv preserving type) AS MaterialRevisionLevel,
  afko.kapversa AS CapacityActiveVersion,
  afko.kbed AS CapacityRqmtHasNotToBeCreated,
  afko.cy_seqnr AS OrderSequenceNumber,
  afko.splstat AS MfgOrderSplitStatus,
  afko.extended_quality_checks AS ExtdQualityCheckIsRequired,
  afko.is_rework_order AS MfgOrderIsProductReworkOrder,
  afko.klvari AS ActualCostsCostingVariant,
  afko.klvarp AS PlannedCostsCostingVariant,
  cast(afko.plnbez as billofoperationsmaterial preserving type) AS Material,
  cast(afko.plnty as billofoperationstype preserving type) AS BillOfOperationsType,
  cast(afko.plnnr as billofoperationsgroup preserving type) AS BillOfOperationsGroup,
  cast(afko.plnal as billofoperationsvariant preserving type) AS BillOfOperationsVariant,
  afko.zaehl AS BOOInternalVersionCounter,
  cast(afko.pverw as billofoperationsusage preserving type) AS BillOfOperationsUsage,
  cast(afko.plnaw as billofoperationsapplication preserving type) AS BillOfOperationsApplication,
  afko.tl_versn AS BillOfOperationsVersion,
  afko.plauf AS BOOExplosionDate,
  afko.pdatv AS BOOValidityStartDate,
  cast(afko.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  cast(afko.stlnr as pph_stnum preserving type) AS BillOfMaterial,
  afko.stlal AS BillOfMaterialVariant,
  afko.stlan AS BillOfMaterialVariantUsage,
  afko.bom_versn AS BillOfMaterialVersion,
  afko.stlst AS BillOfMaterialStatus,
  afko.aufld AS BOMExplosionDate,
  afko.sdatv AS BOMValidityStartDate,
  afko.fsh_mprod_ord AS MasterProductionOrder,
  cast(afko.fhori as vdm_fhori preserving type) AS SchedulingFloatProfile,
  cast(afko.vorgz as vdm_vorgz preserving type) AS FloatBeforeProductionInWrkDays,
  cast(afko.sichz as vdm_sichz preserving type) AS FloatAfterProductionInWorkDays,
  afko.freiz AS ReleasePeriodInWorkDays,
  cast(afko.upter as vdm_upter preserving type) AS ChangeToScheduledDatesIsMade,
  afko.gsuzp AS PlannedStartTime,
  afko.gltrp AS PlannedEndDate,
  afko.gluzp AS PlannedEndTime,
  cast(afko.ftrmp as fis_co_ftrmp preserving type) AS PlannedReleaseDate,
  afko.gsuzs AS ScheduledBasicStartTime,
  cast(afko.gltrs as fis_co_gltrs preserving type) AS ScheduledBasicEndDate,
  afko.gluzs AS ScheduledBasicEndTime,
  cast(afko.ftrms as fis_co_ftrms preserving type) AS ScheduledReleaseDate,
  afko.gsuzi AS ActualStartTime,
  afko.getri AS ConfirmedEndDate,
  afko.geuzi AS ConfirmedEndTime,
  afko.gltri AS ActualEndDate,
  cast(afko.gltri as co_ltrmi preserving type) AS ActualDeliveryDate,
  cast(afko.ftrmi as fis_co_ftrmi preserving type) AS ActualReleasedDate,
  afko.ftrps AS ScheduledFcstdReleaseDate,
  afko.trmdt AS LastScheduledDate,
  afko.gmein AS BaseUnit,
  afko.gamng AS OrderPlannedTotalQty,
  afko.gasmg AS OrderPlannedScrapQty,
  afko.igmng AS OrderConfirmedYieldQty,
  afko.iasmg AS OrderConfirmedScrapQty,
  afko.rmnga AS MfgOrderConfirmedReworkQty,
  (igmng + iasmg + rmnga) AS TotalConfirmedQuantity,
  afko.slsvn AS MaterialFromLotSizeQuantity,
  afko.slsbs AS MaterialToLotSizeQuantity,
  afko.bmeins AS MaterialBaseUnit,
  afko.bmenge AS PlannedTotalQtyInBaseUnit
FROM afko
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [1..1]
LEFT OUTER JOIN I_LogisticsOrderPriority AS _OrderPriority ON PriorityCode = _OrderPriority.PriorityCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnit ON MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _SettlementReservation ON SettlementReservation = _SettlementReservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _SuperiorProjectNetwork ON SuperiorProjectNetwork = _SuperiorProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_CapacityRequirement AS _CapacityRequirement ON CapacityRequirement = _CapacityRequirement.CapacityRequirement  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationGroup AS _ConfirmationGroup ON MfgOrderConfirmation = _ConfirmationGroup.ConfirmationGroup  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant AND BOOInternalVersionCounter = _BillOfOperationsChangeState.BOOInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsUsage AS _BillOfOperationsUsage ON BillOfOperationsUsage = _BillOfOperationsUsage.BillOfOperationsUsage  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_SchedulingType AS _BasicSchedulingType ON BasicSchedulingType = _BasicSchedulingType.SchedulingType  -- association [0..1]
LEFT OUTER JOIN I_SchedulingType AS _ForecastSchedulingType ON ForecastSchedulingType = _ForecastSchedulingType.SchedulingType  -- association [0..1]
;