FAP_TSI_INVC_entry

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 FAP_TSI_INVC_entry.
-- 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: V_FAP_TSI_INVC

CREATE VIEW FAP_TSI_INVC_entry AS
SELECT
  bsik.bukrs AS bukrs,
  bsik.belnr AS belnr,
  bsik.gjahr AS gjahr,
  bsik.buzei AS kbuzei,
  bsik.lifnr AS lifnr,
  bsik.name1 AS name1,
  bkpf.aedat AS aedat,
  '' AS reason,
  cast(bsik.status as abap.char(1)) AS STATUSINDICATOR,
  '' AS PONUMBER,
  bsik.h_bldat AS bldat,
  '' AS ISOVERDUE,
  bsik.sgtxt AS sgtxt,
  bkpf.xblnr AS xblnr,
  bsik.wrbtr AS wrbtr,
  bsik.h_waers AS waers,
  bsik.dmbtr AS dmbtr,
  bkpf.hwaer AS LOCALCURRENCY,
  ostd.paid_amt_dc AS AMOUNTPAID,
  bsik.h_waers AS CURRENCYPAID,
  bkpf.hwaer AS CURRENCYOSTD,
  ostd.paid_amt_lc AS AMOUNTCRDT,
  bkpf.hwaer AS CURRENCYCRDT,
  ostd.resdi AS resdi,
  '' AS SEARCHTERM,
  '' AS SEARCHTYPE,
  bsis.kostl AS kostl,
  bsik.h_budat AS budat,
  contact.name_first AS name_first,
  contact.name_last AS name_last,
  contact.bname AS bname,
  contact.country AS country,
  contact.city1 AS city1,
  contact.street AS street,
  contact.fax_number AS fax_number,
  contact.fax_extens AS fax_extens,
  contact.tel_number AS tel_number,
  contact.tel_extens AS tel_extens,
  contact.title AS title,
  contact.smtp_addr AS smtp_addr,
  contact.persnumber AS persnumber,
  contact.addrnumber AS addrnumber,
  bkpf.usnam AS usnam,
  bsik.busab AS busab,
  bsik.zlspr AS zlspr,
  bsik.batch_no AS batch_no,
  bsik.poken AS poken,
  bsik.kbegru AS kbegru,
  bsis.sbegru AS sbegru,
  bsik.tbrgru AS tbrgru,
  bsis.gsber AS gsber
FROM TSI_INV_ALL_entry AS bsik
INNER JOIN v_tsi_bsegs AS bsis ON /* join condition not captured in parsed metadata */
INNER JOIN bkpf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_tsi_paid_amt AS ostd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN v_tsi_contact AS contact ON /* join condition not captured in parsed metadata */
;