I_FBO

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_FBO.
-- 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: PFBO_DET

CREATE VIEW I_FBO AS
SELECT
  fbo.CONTRACT_NUMBER AS CONTRACT_NUMBER,
  fbo.TARGET_PRICE_TYPE AS TARGET_PRICE_TYPE,
  fbo.STRIKE_PRICE_AMOUNT AS STRIKE_PRICE_AMOUNT,
  fbo.STRIKE_PRICE_CURRENCY AS STRIKE_PRICE_CURRENCY,
  fbo.STRIKE_PRICE_PER_UNIT AS STRIKE_PRICE_PER_UNIT,
  fbo.STRIKE_PRICE_UOM AS STRIKE_PRICE_UOM,
  fbo.DCSID AS DCSID,
  fbo.MATURITY_CODE AS MATURITY_CODE,
  fbo.FBO_EXPIRY_DATE AS FBO_EXPIRY_DATE,
  fbo.TARGET_CONTRACT_TYPE AS TARGET_CONTRACT_TYPE,
  fbo.AUTOMATIC_CONVERT_TO_CONTRACT AS AUTOMATIC_CONVERT_TO_CONTRACT,
  fbo.LOCK_INSTRUCTION_TYPE AS LOCK_INSTRUCTION_TYPE,
  fbo.LOCK_PRICE AS LOCK_PRICE,
  fbo.LOCK_CURRENCY AS LOCK_CURRENCY,
  fbo.LOCK_FX AS LOCK_FX,
  fbo.LOCK_FX_CURRENCY_FROM AS LOCK_FX_CURRENCY_FROM,
  fbo.LOCK_FX_CURRENCY_TO AS LOCK_FX_CURRENCY_TO,
  fbo.FUTURE_LOCK_INSTRUCTION_TYPE AS FUTURE_LOCK_INSTRUCTION_TYPE,
  fbo.FUTURE_LOCK_PRICE AS FUTURE_LOCK_PRICE,
  fbo.FUTURE_LOCK_CURRENCY AS FUTURE_LOCK_CURRENCY,
  fbo.FUTURE_LOCK_FX AS FUTURE_LOCK_FX,
  fbo.FUTURE_LOCK_FX_CURRENCY_FROM AS FUTURE_LOCK_FX_CURRENCY_FROM,
  fbo.FUTURE_LOCK_FX_CURRENCY_TO AS FUTURE_LOCK_FX_CURRENCY_TO,
  fbo.FUTURE_CHECK AS FUTURE_CHECK,
  fbo.BASIS_CHECK AS BASIS_CHECK,
  fbo.BASIS_ID AS BASIS_ID
FROM I_ContractHead AS CONT_HEADER
INNER JOIN P_ACMFIRMBIDOFFERDETAILS AS fbo ON /* join condition not captured in parsed metadata */
;