I_SourceNominationScheduleTP

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_SourceNominationScheduleTP.
-- 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: ISRCENOMSCHEDTP

CREATE VIEW I_SourceNominationScheduleTP AS
SELECT
  _Source.nomtk AS NominationDoc,
  _Source.nomit AS NominationDocItem,
  _Source.guid AS NominationSourceScheduleUUID,
  _Source.source_id AS NominationSourceScheduleID,
  _Source.source_seq AS NominationSourceScheduleSeq,
  _Source.locid AS LocationId,
  _Source.tsyst AS TransportSystem,
  _Source.rank AS SourceNominationSchedRankValue,
  _Source.s_matnr_i AS ScheduledMaterial,
  _Source.physical_stock AS PhysicalStockQuantity,
  _Source.physical_stock_unit AS PhysicalStockQuantityUnit,
  _Source.material_valuation_price AS MaterialValuationPrice,
  _Source.material_valuation_price_unit AS MaterialValuationPriceUnit,
  cast(( _Source.docnr ) as ebeln) AS PurchaseContract,
  cast(right( _Source.docitm, 5) as abap.char(16)) AS PurchaseContractItem,
  cast(0 as ktmng) AS TargetQuantity,
  _Source.purch_contract_open_qty AS TSWPurContrOpenTargetQuantity,
  _Source.purch_contract_qty_unit AS OrderQuantityUnit,
  _Source.purch_contract_item_price AS PurchaseContractItemNetPrice,
  _Source.purch_contract_item_price_unit AS PurchaseContractItemNetPrcUnit,
  _Source.netwr AS ScheduleLogisticCost,
  _Source.currency AS ScheduleLogisticCostUnit,
  _Source.total_cost AS ScheduleTotalCost,
  _Source.total_curr AS ScheduleTotalCostUnit,
  _Source.transhpt_total_cost AS SchedTransshipmentCost,
  _Source.transhpt_total_curr AS SchedTransshipmentCostUnit,
  _Source.duration_in_days AS ScheduleLogisticDurationInDays,
  _Source.idate AS NominationScheduleDate,
  _Source.vktra AS ModeOfTransport,
  cast('' as bezei20) AS ModeOfTransportDesc,
  _Source.route AS TSWTransportRoute,
  _Source.loc_pt AS NominationLocationPartnerPlant,
  _Source.nmselect AS NominationDocIsBlocked,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  _Source.partner_maintained_count AS NmbrOfMntndNominationSchedPart,
  _Source.sched_option_status AS SourceNominationScheduleStatus,
  source_type AS SourceNominationSchedSrceType,
  _Source.sim_sched_id AS NominationSimlnID,
  _Source.sim_sched_ln AS NominationSimlnLineItm,
  _Source.sim_version AS NominationSimlnVersion
FROM oij09_schedsrc AS _Source
INNER JOIN oijts AS _TransportSystem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN toigs AS _ShipmentType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tvfp AS _ShipmentCostPurData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DemandNominationScheduleTP AS _DemandNominationSchedule ON _DemandNominationSchedule.NominationDoc = NominationDoc AND _DemandNominationSchedule.NominationDocItem = NominationDocItem  -- association [1..1]
LEFT OUTER JOIN I_SourceNominationSchedPartner AS _SourceNominationSchedPartner ON _SourceNominationSchedPartner.NominationDoc = NominationDoc AND _SourceNominationSchedPartner.NominationDocItem = NominationDocItem AND _SourceNominationSchedPartner.NominationSourceScheduleUUID = NominationSourceScheduleUUID  -- association [1..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _unitofmeasure ON _unitofmeasure.UnitOfMeasure = 'DAY'  -- association [1..1]
LEFT OUTER JOIN I_SourceNominationSchedStatusT AS _SourceNominationSchedStatusT ON _SourceNominationSchedStatusT.SourceNominationScheduleStatus = SourceNominationScheduleStatus  -- association [0..*]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_ModeOfTransportText AS _ModeOfTransportText ON _ModeOfTransportText.ModeOfTransport = ModeOfTransport  -- association [0..*]
LEFT OUTER JOIN E_SourceNominationSchedule AS _SourceNomExtension ON NominationSourceScheduleUUID = _SourceNomExtension.NominationSourceScheduleUUID AND NominationSimlnID = _SourceNomExtension.NominationSimlnID AND NominationSimlnLineItm = _SourceNomExtension.NominationSimlnLineItm AND NominationSimlnVersion = _SourceNomExtension.NominationSimlnVersion  -- association [1..1]
LEFT OUTER JOIN I_NominationLocation AS _NominationLocation ON _NominationLocation.LocationId = LocationId  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _PlantTxt ON _PlantTxt.Plant = NominationLocationPartnerPlant  -- association [0..1]
LEFT OUTER JOIN I_RouteText AS _RouteText ON _RouteText.Route = TSWTransportRoute  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = ScheduledMaterial  -- association [0..*]
LEFT OUTER JOIN I_NominationTransptSystVH AS _NominationTransptSystVH ON _NominationTransptSystVH.TransportSystem = TransportSystem  -- association [0..1]
LEFT OUTER JOIN I_SourceTypeText AS _SourceTypeText ON _SourceTypeText.SourceNominationSchedSrceType = SourceNominationSchedSrceType  -- association [0..*]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup  -- association [0..1]
;