I_NominationItemFld

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_NominationItemFld.
-- 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: INOMITMFLD

CREATE VIEW I_NominationItemFld AS
SELECT
  a.nomtk AS NominationDoc,
  a.nomit AS NominationDocItem,
  a.sityp AS NominationScheduleType,
  a.istat AS NominationItemStatus,
  a.idate AS NominationScheduleDate,
  a.locid AS LocationId,
  a.menge AS ScheduledQuantity,
  a.actualqty AS ActualScheduledQuantity,
  a.actualuom AS ActualScheduledQuantityUnit,
  a.unit_i AS ScheduledQuantityUnit,
  a.matnr_i AS DemandMaterial,
  a.locnam AS LocationName,
  a.s_matnr_i AS ScheduledMaterial,
  a.erdat AS NominationCreationDate,
  a.erzeit AS NominationCreationTime,
  a.ernam AS NominationCreatedByUser,
  a.aedat AS NominationChangedDate,
  a.aenam AS LastChangedByUser,
  a.oic_lifnr AS Supplier,
  a.valuationtype_o AS ValuationTypeOrigin,
  a.valuationtype_d AS ValuationTypeDestination,
  a.partnr AS LocationPartner,
  a.docnr AS NominationReferenceDocument,
  a.docitm AS NominationReferenceDocItem,
  a.inspe AS NominationInspector,
  a.worklist_i AS IsNominationWorklistEntry,
  a.impoexpo AS ImportExportPartner,
  a.flag_imex AS IsImportExportPartner,
  a.conpat AS ContractPartner,
  a.cons AS ConsigneePartner,
  a.bloind AS NominationIsBlocked,
  a.delind AS NominationIsMarkedForDeletion,
  a.isubstat AS NominationItemSubStatus,
  a.charg_o_create AS IsNominationItmOriginBatCrted,
  a.docind AS NominationReferenceDocType,
  a.quickconf AS QuickConfirm,
  a.locpt AS OilLocationPartnerPlant,
  a.locsl AS OilLocationPartnerStorageLoc,
  a.ilock AS NominationItemIsComplete,
  a.charg_o AS BatchOriginLocation,
  a.charg_d AS BatchDestinationLocation,
  cast(tstmp_to_dats(a.sched_tst_to,abap_user_timezone( $session.user,$session.client, 'NULL' ), $session.client,'NULL') as abap.dats) as ScheduleBatchEndDate AS datsasScheduleBatchEndDate,
  cast(tstmp_to_tims(a.sched_tst_to,abap_user_timezone( $session.user,$session.client, 'NULL' ), $session.client,'NULL') as abap.tims) as ScheduleBatchEndTime AS timsasScheduleBatchEndTime,
  cast(tstmp_to_dats(a.sched_tst_from,abap_user_timezone( $session.user,$session.client, 'NULL' ), $session.client,'NULL') as abap.dats) as ScheduleBatchStartDate AS datsasScheduleBatchStartDate,
  cast(tstmp_to_tims(a.sched_tst_from,abap_user_timezone( $session.user,$session.client, 'NULL' ), $session.client,'NULL') as abap.tims) as ScheduleBatchStartTime AS timsasScheduleBatchStartTime,
  a.sched_tst_to AS ScheduledBatchEndDateTime,
  a.sched_tst_from AS ScheduledBatchStartDateTime,
  a.doctyp AS NominationRefDocCode,
  a.tank AS TankPartner,
  a.co_ship AS ConnectingShipper,
  a.co_carr AS ConnectingCarrier,
  a.ga_nmshipper AS GasShipper,
  b.nomtyp AS NominationType,
  b.tsyst AS TransportSystem,
  b.nmshipper AS NominationShipper,
  b.nmcarrier AS NominationCarrier,
  a.owner AS ValuationType,
  a.actuals AS IsNominationActual,
  a.oic_ocityc AS OriginCityCode,
  a.oic_dcityc AS DestinationCityCode,
  a.charg_d_create AS NominationItmDestBatIsCreated,
  a.charg_l_create AS NominationItmLoadBatIsCreated,
  a.charg_l AS BatchLoad,
  a.sched_tst_to AS NominationScheduleEndDateTime
FROM oijnomi AS a
INNER JOIN oijnomh AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_NominationItem AS _NominationItemExtension ON NominationDoc = _NominationItemExtension.NominationDoc AND NominationDocItem = _NominationItemExtension.NominationDocItem  -- association [0..1]
;