I_FreightContractVH

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_FreightContractVH.
-- 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: IFRCNTRCTVH

CREATE VIEW I_FreightContractVH AS
SELECT
  a.ebeln AS FreightContract,
  b.FreightContractItem AS FreightContractItem,
  f.seqnr AS SequenceNumber,
  d.etenr AS ScheduleLine,
  b.Material AS Material,
  b.Plant AS Plant,
  b.StorageLocation AS StorageLocation,
  a.lifnr AS Supplier,
  c.name1 AS OrganizationBPName1,
  a.ekorg AS PurchasingOrganization,
  a.bsart AS PurchasingDocumentType,
  b.OrderQuantity AS OrderQuantity,
  b.OrderQuantityUnit AS OrderQuantityUnit,
  b.ValuationType AS ValuationType,
  d.charg AS Batch,
  b.NetPriceAmount AS NetPriceAmount,
  b.DocumentCurrency AS DocumentCurrency,
  b.ExchangeAgreement AS ExchangeAgreement,
  b.ExchangeAgreementType AS ExchangeAgreementType,
  b.ModeOfTransport AS ModeOfTransport,
  f.locid AS LocationId,
  g.vehicle AS VehicleId,
  a.bukrs AS CompanyCode
FROM ekko AS a
LEFT OUTER JOIN I_FreightContractItemVH AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN eket AS d ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t161 AS e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oij_el_layt_inf AS f ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN oij_el_cp_layt AS g ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationVehicleIdVH AS _VehicleId ON VehicleId = _VehicleId.VehicleId  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;