I_NominationAnalysisPath

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_NominationAnalysisPath.
-- 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: ANALYSISPATH

CREATE VIEW I_NominationAnalysisPath AS
SELECT
  h.nomtk AS NominationDoc,
  i.nomit AS NominationDocItem,
  h.nomnr AS NominationExtNumber,
  h.nomtyp AS NominationType,
  h.nomst AS NominationHeaderStatus,
  i.locid AS LocationId,
  i.s_matnr_i AS ScheduledMaterial,
  i.menge AS ScheduledQuantity,
  i.unit_i AS ScheduledQuantityUnit,
  i.docind AS IsReferenceDocument,
  i.docnr AS NominationReferenceDocument,
  h.cycle AS NominationPipelineCycleID,
  h.nmshipper AS NominationShipper,
  h.nmcarrier AS NominationCarrier,
  h.nmwerk AS InTransitPlant,
  h.nmlgort AS InTransitStorageLocation,
  h.nmvehicle AS VehicleId,
  v.veh_xblck AS VehicleIsBlocked,
  h.tsyst AS TransportSystem,
  h.sentdat AS NominationLastHeaderActionDate,
  h.nmtplst AS TransportationPlanningPoint,
  h.route AS ShippingRoute,
  h.bookts AS IsBookedTransportSystem,
  h.ev_group AS NominationEventDefaultGroup,
  h.unit AS NominationHeaderUom,
  h.nmshtype AS BulkShipmentType,
  h.vktra AS NominationModeOfTransport,
  i.aedat AS NominationChangedDate,
  i.erdat AS NominationCreationDate,
  i.erzeit AS NominationCreationTime,
  i.ernam AS NominationCreatedByUser,
  i.bloind AS NominationIsBlocked,
  h.bustyp AS BusinessType,
  i.conpat AS ContractPartner,
  i.cons AS ConsigneePartner,
  i.delind AS NominationIsMarkedForDeletion,
  i.docitm AS NominationReferenceDocItem,
  i.doctyp AS NominationReferenceDocType,
  i.flag_imex AS IsImportExportPartner,
  i.charg_o AS BatchOriginLocation,
  i.charg_d AS BatchDestinationLocation,
  i.idate AS NominationScheduleDate,
  i.impoexpo AS ImportExportPartner,
  i.inspe AS NominationInspector,
  i.istat AS NominationItemStatus,
  i.isubstat AS NominationItemSubStatus,
  i.matnr_i AS LoadDemandMaterialId,
  i.matnr_i AS DischargeDemandMaterialId,
  i.partnr AS LocationPartner,
  i.locpt AS LocationPlant,
  i.sityp AS NominationScheduleType,
  i.owner AS ValuationType,
  i.valuationtype_d AS ValuationTypeDestination,
  i.valuationtype_o AS ValuationTypeOrigin,
  i.worklist_i AS IsNominationWorklistEntry,
  i.actualqty AS ActualScheduledQuantity,
  i.actualuom AS ActualScheduledQuantityUnit,
  i.quickconf AS QuickConfirmationCode,
  i.ilock AS NominationItemIsComplete,
  h.nmvessel AS VehicleIdentifier,
  i.sched_tst_from AS ScheduledBatchStartDateTime,
  i.sched_tst_to AS ScheduledBatchEndDateTime,
  i.oic_dcityc AS DestinationCityCode,
  i.oic_ocityc AS OriginCityCode,
  i.actuals AS IsNominationActual,
  i.itbotol AS ToleranceOver,
  i.itbutol AS ToleranceUnder,
  i.itbotolabs AS ToleranceOverAbs,
  i.itbutolabs AS ToleranceUnderAbs,
  i.ittolunit AS ToleranceUnitAbs,
  i.unlimited AS IsUnlimited,
  ts.botol AS ToleranceOverTs,
  ts.butol AS ToleranceUnderTs,
  ts.botolabs AS ToleranceOverAbsTs,
  ts.butolabs AS ToleranceUnderAbsTs,
  ts.bultoluom AS ToleranceUnitAbsTs,
  ts.unlimited AS IsUnlimitedTs,
  e.NominationEventType AS NominationEventType,
  cast('' as char200) AS NominationEventComments,
  cast('' as char200) AS NominationGeneralComments,
  cast('' as char50) AS NominationTicketStatus,
  cast('' as char3) AS NumberOfNominationTickets,
  (case when e.NominationEventNumber = '0000' then ' ' else e.NominationEventNumber end) AS NominationEventNumber,
  e.NominationEventChangedDate AS NominationEventChangedDate,
  e.NominationEventChangedTime AS NominationEventChangedTime,
  ' ' AS NominationEvents,
  ' ' AS NominationDocComments,
  ' ' AS NominationLoadIsToBeCopied,
  ' ' AS NominationIsUpdated,
  ' ' AS NominationIsToBeCopied,
  ' ' AS NominationItemIsToBeCopied
FROM oijnomh AS h
LEFT OUTER JOIN I_Oij06_Recent_Event AS e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oijts AS ts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oigv AS v ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Oij06_Myeventss1_Object AS _Events ON _Events.NominationDoc = NominationDoc AND _Events.NominationDocItem = NominationDocItem  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Shipper ON NominationShipper = _Shipper.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Carrier ON NominationCarrier = _Carrier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Inspector ON NominationInspector = _Inspector.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ImportExportPartner ON ImportExportPartner = _ImportExportPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ConsigneePartnerVendor ON ConsigneePartner = _ConsigneePartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ConsigneePartnerCustomer ON ConsigneePartner = _ConsigneePartnerCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ContractPartnerVendor ON ContractPartner = _ContractPartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ContractPartnerCustomer ON ContractPartner = _ContractPartnerCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _LocationPartnerVendor ON LocationPartner = _LocationPartnerVendor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _LocationPartnerCustomer ON LocationPartner = _LocationPartnerCustomer.Customer  -- association [0..1]
;