F-53

-- ============================================================
-- T-Code : F-53 Post Outgoing Payments
-- Purpose: Post Outgoing Payments — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per BKPF joined to BSEG, BSIK, BSAK, LFB1, T052
-- Tables : BKPF, BSEG, BSIK, BSAK, LFB1, T052
-- Notes  : Auto-generated skeleton. Add MAKT/T001W/LFA1/KNA1 enrichment joins as needed for the business question. Set catalog/schema to your Unity Catalog location; fill remaining placeholders (<...>) for your tenant.
-- ============================================================
SELECT
  h.MANDT  AS "Client",
  h.BUKRS  AS "Company Code",
  h.BELNR  AS "Accounting Document Number",
  h.GJAHR  AS "Fiscal Year",
  l.BUZEI  AS "Number of Line Item Within Accounting Document",
  b.LIFNR  AS "Vendor Account Number",
  b.UMSKS  AS "Special G/L Transaction Type",
  b.UMSKZ  AS "Special G/L Indicator",
  b.AUGDT  AS "Clearing Date",
  b.AUGBL  AS "Document Number of the Clearing Document",
  b.ZUONR  AS "Assignment number",
  b.BUZEI  AS "Number of Line Item Within Accounting Document",
  bs.LIFNR AS "Vendor Account Number",
  bs.UMSKS AS "Special G/L Transaction Type",
  bs.UMSKZ AS "Special G/L Indicator",
  bs.AUGDT AS "Clearing Date",
  bs.AUGBL AS "Document Number of the Clearing Document",
  bs.ZUONR AS "Assignment number",
  bs.BUZEI AS "Number of Line Item Within Accounting Document",
  lf.LIFNR AS "Vendor Account Number",
  t.ZTERM  AS "Terms of Payment Key",
  t.ZTAGG  AS "Day Limit"
FROM <catalog>.<schema>.bkpf h
LEFT JOIN <catalog>.<schema>.bseg l
  ON l.MANDT = h.MANDT
 AND l.BELNR = h.BELNR
 AND l.BUKRS = h.BUKRS
 AND l.GJAHR = h.GJAHR
LEFT JOIN <catalog>.<schema>.bsik b
  ON b.MANDT = h.MANDT
 AND b.BUKRS = h.BUKRS
 AND b.GJAHR = h.GJAHR
 AND b.BELNR = h.BELNR
LEFT JOIN <catalog>.<schema>.bsak bs
  ON bs.MANDT = h.MANDT
 AND bs.BUKRS = h.BUKRS
 AND bs.GJAHR = h.GJAHR
 AND bs.BELNR = h.BELNR
LEFT JOIN <catalog>.<schema>.lfb1 lf
  ON lf.MANDT = h.MANDT
 AND lf.BUKRS = h.BUKRS
LEFT JOIN <catalog>.<schema>.t052 t
  ON t.MANDT = h.MANDT
WHERE
  h.MANDT = '<MANDT>'
  AND h.BUKRS = '<BUKRS>'
  AND h.BELNR = '<BELNR>'
  AND h.GJAHR = <GJAHR>
ORDER BY h.BUKRS;