F-28

-- ============================================================
-- T-Code : F-28 Post Incoming Payments
-- Purpose: Post Incoming Payments — auto-generated boilerplate from tcode-table-map
-- Grain  : One row per BKPF joined to BSEG, BSID, BSAD, KNB1, T052
-- Tables : BKPF, BSEG, BSID, BSAD, KNB1, 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.KUNNR  AS "Customer 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.KUNNR AS "Customer 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",
  k.KUNNR  AS "Customer 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>.bsid 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>.bsad 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>.knb1 k
  ON k.MANDT = h.MANDT
 AND k.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;