I_LogisticsOrder

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_LogisticsOrder.
-- 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: ILOGISTCSORDER

CREATE VIEW I_LogisticsOrder AS
SELECT
  cast(aufk.autyp as pph_autyp preserving type) AS OrderCategory,
  cast(aufk.ktext as pph_auftext preserving type) AS OrderDescription,
  cast(aufk.ltext as pph_aufltxt preserving type) AS OrderHasLongText,
  cast(aufk.ltext as pph_longtextlang) AS LongTextLanguage,
  cast(aufk.pspel as ps_s4_pspnr preserving type) AS WBSElementInternalID_2,
  cast(afko.pronr as ps_s4_proj_pspnr preserving type) AS ProjectInternalID_2,
  cast(afko.revlv as vdm_qm_revlv preserving type) AS MaterialRevisionLevel_2,
  cast(aufk.kostv as pph_kostl preserving type) AS ResponsibleCostCenter,
  cast(aufk.kstar as pph_kstar preserving type) AS CostElement,
  cast(aufk.scope as pph_scope preserving type) AS ControllingObjectClass,
  cast(afko.plnbez as billofoperationsmaterial preserving type) AS Material,
  cast(afko.plnty as billofoperationstype preserving type) AS BillOfOperationsType,
  cast(afko.plnnr as billofoperations preserving type) AS BillOfOperations,
  cast(afko.plnnr as billofoperationsgroup preserving type) AS BillOfOperationsGroup,
  cast(afko.plnal as billofoperationsvariant preserving type) AS BillOfOperationsVariant,
  cast(afko.plnaw as billofoperationsapplication preserving type) AS BillOfOperationsApplication,
  cast(afko.pverw as billofoperationsusage preserving type) AS BillOfOperationsUsage,
  cast(afko.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  cast(afko.stlnr as pph_stnum preserving type) AS BillOfMaterialInternalID,
  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,
  cast(afko.upter as vdm_upter preserving type) AS ChangeToScheduledDatesIsMade,
  case aufk.pdat1 when '' then afko.ftrmp else aufk.pdat1 end as PlannedReleaseDate AS pdat1endasPlannedReleaseDate,
  afko.prodnet AS MfgOrderIsPartOfCollvOrder,
  afko.maufnr AS MfgOrderSuperiorMfgOrder,
  afko.aprio AS PriorityCode,
  afko.stufe AS MfgOrderHierarchyLevel,
  afko.flexible_processing AS ProdnProcgIsFlexible,
  afko.aufpl AS OrderInternalBillOfOperations,
  afko.lead_aufnr AS LeadingOrder,
  afko.dispo AS MRPController,
  afko.fevor AS ProductionSupervisor,
  afko.sfcpf AS ProductionSchedulingProfile,
  afko.plgrp AS ResponsiblePlannerGroup,
  afko.pronr 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,
  afko.aennr AS EngineeringChangeOrder,
  afko.terkz AS BasicSchedulingType,
  afko.plart AS ProdAvailyCheckPlanningType,
  afko.netzkont AS NtwkAccountAssignmentCode,
  afko.profid AS NetworkProfile,
  afko.cuobj AS ProductConfiguration,
  afko.naucost AS OrderIsNotCostedAutomatically,
  afko.nauterm AS OrdIsNotSchedldAutomatically,
  afko.kapversa AS CapacityActiveVersion,
  afko.kbed AS CapacityRqmtHasNotToBeCreated,
  afko.cy_seqnr AS OrderSequenceNumber,
  afko.revlv AS MaterialRevisionLevel,
  afko.splstat AS MfgOrderSplitStatus,
  afko.extended_quality_checks AS ExtdQualityCheckIsRequired,
  afko.fsh_mprod_ord AS MasterProductionOrder,
  afko.klvari AS ActualCostsCostingVariant,
  afko.klvarp AS PlannedCostsCostingVariant,
  afko.zaehl AS BOOInternalVersionCounter,
  afko.tl_versn AS BillOfOperationsVersion,
  afko.plauf AS BOOExplosionDate,
  afko.pdatv AS BOOValidityStartDate,
  afko.stlnr AS BillOfMaterial,
  afko.stlal AS BillOfMaterialVariant,
  afko.stlan AS BillOfMaterialVariantUsage,
  afko.bom_versn AS BillOfMaterialVersion,
  afko.aufld AS BOMExplosionDate,
  afko.sdatv AS BOMValidityStartDate,
  afko.freiz AS ReleasePeriodInWorkDays,
  afko.gstrp AS PlannedStartDate,
  afko.gsuzp AS PlannedStartTime,
  afko.gltrp AS PlannedEndDate,
  afko.gluzp AS PlannedEndTime,
  afko.gstrs AS ScheduledBasicStartDate,
  afko.gsuzs AS ScheduledBasicStartTime,
  afko.gltrs AS ScheduledBasicEndDate,
  afko.gluzs AS ScheduledBasicEndTime,
  afko.ftrms AS ScheduledReleaseDate,
  afko.gstri AS ActualStartDate,
  afko.gsuzi AS ActualStartTime,
  afko.gltri AS ActualEndDate,
  afko.ftrmi AS ActualReleasedDate,
  afko.getri AS ConfirmedEndDate,
  afko.geuzi AS ConfirmedEndTime,
  afko.ftrps AS ScheduledFcstdReleaseDate,
  afko.gsbtr AS TotalCommitmentDate,
  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,
  afko.slsvn AS MaterialFromLotSizeQuantity,
  afko.slsbs AS MaterialToLotSizeQuantity,
  afko.bmeins AS MaterialBaseUnit,
  afko.bmenge AS PlannedTotalQtyInBaseUnit,
  aufk.aufnr AS OrderID,
  aufk.auart AS OrderType,
  aufk.loekz AS IsMarkedForDeletion,
  aufk.flg_mltps AS MfgOrderHasMultipleItems,
  aufk.rsord AS OrderIsRefurbishmentOrder,
  aufk.astkz AS IsStatisticalOrder,
  aufk.eb_post AS OrderIsEventBasedPosting,
  aufk.eb_post AS EventBasedPostingMethod,
  aufk.erdat AS CreationDate,
  aufk.erfzeit AS CreationTime,
  aufk.ernam AS CreatedByUser,
  aufk.aedat AS LastChangeDate,
  aufk.aezeit AS LastChangeTime,
  aufk.aenam AS LastChangedByUser,
  aufk.refnr AS ReferenceOrder,
  aufk.werks AS Plant,
  aufk.vaplz AS MainWorkCenter,
  aufk.wawrk AS MainWorkCenterPlant,
  aufk.stort AS MaintenanceObjectLocation,
  aufk.sowrk AS LocationPlant,
  aufk.kdauf AS SalesOrder,
  aufk.kdpos AS SalesOrderItem,
  aufk.pspel AS WBSElementInternalID,
  aufk.zschm AS ProjInterestCalcProfile,
  aufk.objnr AS ObjectInternalID,
  aufk.kappl AS ConditionApplication,
  aufk.aufex AS ExternalOrder,
  aufk.zschl AS OverheadCode,
  aufk.gsber AS BusinessArea,
  aufk.bukrs AS CompanyCode,
  aufk.abukr AS RequestingCompanyCode,
  aufk.kokrs AS ControllingArea,
  aufk.prctr AS ProfitCenter,
  aufk.kostl AS CostCenter,
  aufk.akstl AS RequestingCostCenter,
  aufk.saknr AS GLAccount,
  aufk.pkosa AS ProductCostCollector,
  aufk.kalsm AS CostingSheet,
  aufk.func_area AS FunctionalArea,
  aufk.vname AS JointVenture,
  aufk.jv_jibcl AS JointVentureClass,
  aufk.jv_jibsa AS JointVentureSubClass,
  aufk.jv_oco AS JointVentureOriginalCostObject,
  aufk.otype AS JointVentureObjectType,
  aufk.txjcd AS TaxJurisdiction,
  aufk.izwek AS InvestmentReason,
  aufk.umwkz AS EnvironmentalInvestmentReason,
  aufk.abkrs AS OrderProcessingGroup,
  aufk.pdat2 AS PlannedCompletionDate,
  aufk.idat2 AS TechnicalCompletionDate,
  aufk.waers AS Currency,
  aufk.user4 AS EstimatedTotalOrderCost
FROM aufk
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderTypeDetails AS _OrderTypeDetails ON OrderType = _OrderTypeDetails.OrderType AND Plant = _OrderTypeDetails.Plant  -- association [1..1]
LEFT OUTER JOIN I_Order AS _ReferenceOrder ON ReferenceOrder = _ReferenceOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _LeadingOrder ON LeadingOrder = _LeadingOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON OrderID = _OrderItem.OrderID  -- association [0..*]
LEFT OUTER JOIN I_OrderItem AS _OrderMainItem ON OrderID = _OrderMainItem.OrderID AND _OrderMainItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_OrderSequence AS _OrderSequence ON OrderInternalBillOfOperations = _OrderSequence.OrderInternalID  -- association [0..*]
LEFT OUTER JOIN I_OrderOperation AS _OrderOperation ON OrderInternalBillOfOperations = _OrderOperation.OrderInternalID  -- association [0..*]
LEFT OUTER JOIN I_OrderComponent AS _OrderComponent ON Reservation = _OrderComponent.Reservation  -- association [0..*]
LEFT OUTER JOIN I_OrderLongText AS _LongText ON OrderID = _LongText.OrderID  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrderPriority AS _OrderPriority ON PriorityCode = _OrderPriority.PriorityCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChgdByUserContactCard ON LastChangedByUser = _LastChgdByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguage = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _MainWorkCenterPlant ON MainWorkCenterPlant = _MainWorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _LocationPlant ON LocationPlant = _LocationPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationGroup AS _ConfirmationGroup ON MfgOrderConfirmation = _ConfirmationGroup.ConfirmationGroup  -- 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_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData2 ON WBSElementInternalID_2 = _WBSElementBasicData2.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByInternalKey AS _Project ON ProjectInternalID = _Project.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON ProjectInternalID = _ProjectBasicData.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData2 ON ProjectInternalID_2 = _ProjectBasicData2.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _SuperiorProjectNetwork ON SuperiorProjectNetwork = _SuperiorProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON Plant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_ProductionSchedulingProfile AS _ProductionSchedulingProfile ON Plant = _ProductionSchedulingProfile.Plant AND ProductionSchedulingProfile = _ProductionSchedulingProfile.ProductionSchedulingProfile  -- association [0..1]
LEFT OUTER JOIN I_ResponsiblePlannerGroup AS _ResponsiblePlannerGroup ON Plant = _ResponsiblePlannerGroup.Plant AND ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenter ON MainWorkCenter = _WorkCenter.WorkCenter AND MainWorkCenterPlant = _WorkCenter.Plant  -- association [0..1]
LEFT OUTER JOIN I_CapacityRequirement AS _CapacityRequirement ON CapacityRequirement = _CapacityRequirement.CapacityRequirement  -- association [0..1]
LEFT OUTER JOIN I_Location AS _MaintenanceObjectLocation ON LocationPlant = _MaintenanceObjectLocation.Plant AND MaintenanceObjectLocation = _MaintenanceObjectLocation.Location  -- 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 BillOfOperations = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup2 ON BillOfOperationsType = _BillOfOperationsGroup2.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup2.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_BOOApplication AS _BillOfOperationsApplication ON BillOfOperationsApplication = _BillOfOperationsApplication.BillOfOperationsApplication  -- 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_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON ObjectInternalID = _StatusObjectStatus.StatusObject AND _StatusObjectStatus.StatusIsInactive = ''  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON ControllingArea = _ResponsibleCostCenter.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_ProductCostCtrlgOrder AS _ProductCostCollector ON ProductCostCollector = _ProductCostCollector.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_OrderProcessingGroup AS _OrderProcessingGroup ON ControllingArea = _OrderProcessingGroup.ControllingArea AND OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup  -- 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]
LEFT OUTER JOIN I_SchedulingFloatProfile AS _SchedulingFloatProfile ON Plant = _SchedulingFloatProfile.Plant AND SchedulingFloatProfile = _SchedulingFloatProfile.SchedulingFloatProfile  -- association [0..1]
LEFT OUTER JOIN I_RFM_MasterProductOrder AS _RFM_MasterProductOrder ON MasterProductionOrder = _RFM_MasterProductOrder.MasterProductionOrder  -- association [0..1]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON aufk.aufnr = _Extension.OrderID  -- association [1..1]
;