SAP Reference

F-28

Create S/4HANA status: Active

Post Incoming Payments

Module: FI · Financial Accounting
What the badges mean
S/4HANA status: Active
Active and unchanged in S/4HANA.
S/4HANA status: Deprecated
Still readable today, but no longer SAP's strategic path — plan around it.
S/4HANA status: Replaced
Replaced by a new persistence in S/4HANA; the classic name may still answer reads (see read mechanism).
S/4HANA status: Migrating to IBP
Planning scope is moving from APO toward IBP.
S/4HANA status: Active (StRM) · Replaced (EWM)
Path-dependent: active with SAP Stock Room Management, replaced where EWM is the warehouse path.
S/4HANA status: Replaced · Compat View
Compatibility view: the classic table name is redirected to a view over the new persistence — see how the physical model moved.
S/4HANA status: Active · Proxy View
Proxy view: reads route through NSDM proxy/CDS views — see how the physical model moved.
master
Data class: what the table holds — master data, transaction documents, org structure, config, or texts (one row per language — see the quirks guide).
In field listings, K marks a primary-key field, and linked type codes in the Type column jump to the matching quirks-guide section.

Boilerplate SQL

Databricks SQL

Starting point for querying the tables behind this transaction. Set your Unity Catalog location and filter values below — they’re substituted into the SQL and the copy button.

Query parameters

6 parameters not filled: <catalog>, <schema>, <MANDT>, <BUKRS>, <BELNR>, <GJAHR>

-- ============================================================
-- 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;

Tables Used by This Transaction

A curated list of the main business tables behind this transaction, drawn from this reference’s catalog. Tables a query joins only for names and descriptions may be left out.

How these tables connect — join details in the list below.

Loading relationship diagram…

Join details

  • BKPFBSEGheader item · 1:N
    ON bkpf.BELNR = bseg.BELNR

R read · W write · R/W read + write

More Financial Accounting t-codes