TRPRT_PAYMENTS

Transparent Table Application Table
53 Fields 2 CDS Views

Persistent Data for Payment Requests

TRPRT_PAYMENTS is an SAP database table in S/4HANA. Persistent Data for Payment Requests. It contains 53 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TreasuryPaymentRequest view_entity from BASIC Treasury Payment Request
P_TrprtPayments view_entity from BASIC CDS view for Treasury table: TRPRT_PAYMENTS

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY os_guid os_guid GUID
company_code bukrs Company Code
prq_keyno prq_keyno Key Number
payment_awkey tpm_payment_awkey Payment Ref.
bustransid tpm_bustransid Bus. Trans. ID
valuation_area tpm_val_area Valuation Area
item_number posnr_acc Position
flow_number tpm_trdflownr Flow Number
belnr belnr_d Document Number
buzei buzei Item
posting_year gjahr Fiscal Year
payment_curr tpm_payment_curr Payment Crcy
payment_amt tpm_payment_amt Payment Amount
payment_date tpm_payment_date Payt Date
spayrq tb_spayrqk Payment Request
sprsng tb_sprsng Individual pmnt
scspay tb_scspay Same Direction
sign tb_ssign Direction
sprgrd tb_sprgrd Group Determ.
paygr paygr Grouping
house_bank tb_rhabki House Bank
house_bank_acc tb_rhktid House Bank Acct
rpzahl tb_rpzahl_new Payer/Payee
rpbank tb_rpbank Partner Bank
zwels dzwels Payment Methods
rpcode rpcode Repetitive Code
rp_text rpcode_text Reference Text
kunnr kunnr Customer
gl_account hkont G/L Acct
clearing_acc prq_bkhbk Bank G/L account
fi_rev_reason stgrd Reversal Reason
tr_rev_reason sstogrd Reversal Reason
reversal_date budat Posting Date
payment_state tpm_trprstate Status
release_state tpm_trpr_relstate Release
sgtxt sgtxt Text
swift_text prq_swtxt SWIFT Text
urgent prq_xurge Ind.: Urgent
dtams dtams DME Rec. Code
dtaws dtaws Instruction Key
dtws1 dtat16 Instruct. Key 1
dtws2 dtat17 Instruct. Key 2
dtws3 dtat18 Instruct. key 3
dtws4 dtat19 Instruct. key 4
sub_flow_number tpm_trdflownr Flow Number
uzawe uzawe Pmnt Meth. Sup.
class_oid os_guid GUID
position_oid tpm_db_os_guid DB Object ID
mndid sepa_mndid Mandate Ref.
payment_cat tpm_payment_cat Paymt. Cat.
payment_reason farp_payt_rsn Payment Reason
lifnr tpm_lifnr Vendor

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Persistent Data for Payment Requests
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRPRT_PAYMENTS (
    MANDT,            -- Client [mandt]
    OS_GUID,          -- GUID [os_guid]
    COMPANY_CODE,     -- Company Code [bukrs]
    PRQ_KEYNO,        -- Key Number [prq_keyno]
    PAYMENT_AWKEY,    -- Payment Ref. [tpm_payment_awkey]
    BUSTRANSID,       -- Bus. Trans. ID [tpm_bustransid]
    VALUATION_AREA,   -- Valuation Area [tpm_val_area]
    ITEM_NUMBER,      -- Position [posnr_acc]
    FLOW_NUMBER,      -- Flow Number [tpm_trdflownr]
    BELNR,            -- Document Number [belnr_d]
    BUZEI,            -- Item [buzei]
    POSTING_YEAR,     -- Fiscal Year [gjahr]
    PAYMENT_CURR,     -- Payment Crcy [tpm_payment_curr]
    PAYMENT_AMT,      -- Payment Amount [tpm_payment_amt]
    PAYMENT_DATE,     -- Payt Date [tpm_payment_date]
    SPAYRQ,           -- Payment Request [tb_spayrqk]
    SPRSNG,           -- Individual pmnt [tb_sprsng]
    SCSPAY,           -- Same Direction [tb_scspay]
    SIGN,             -- Direction [tb_ssign]
    SPRGRD,           -- Group Determ. [tb_sprgrd]
    PAYGR,            -- Grouping [paygr]
    HOUSE_BANK,       -- House Bank [tb_rhabki]
    HOUSE_BANK_ACC,   -- House Bank Acct [tb_rhktid]
    RPZAHL,           -- Payer/Payee [tb_rpzahl_new]
    RPBANK,           -- Partner Bank [tb_rpbank]
    ZWELS,            -- Payment Methods [dzwels]
    RPCODE,           -- Repetitive Code [rpcode]
    RP_TEXT,          -- Reference Text [rpcode_text]
    KUNNR,            -- Customer [kunnr]
    GL_ACCOUNT,       -- G/L Acct [hkont]
    CLEARING_ACC,     -- Bank G/L account [prq_bkhbk]
    FI_REV_REASON,    -- Reversal Reason [stgrd]
    TR_REV_REASON,    -- Reversal Reason [sstogrd]
    REVERSAL_DATE,    -- Posting Date [budat]
    PAYMENT_STATE,    -- Status [tpm_trprstate]
    RELEASE_STATE,    -- Release [tpm_trpr_relstate]
    SGTXT,            -- Text [sgtxt]
    SWIFT_TEXT,       -- SWIFT Text [prq_swtxt]
    URGENT,           -- Ind.: Urgent [prq_xurge]
    DTAMS,            -- DME Rec. Code [dtams]
    DTAWS,            -- Instruction Key [dtaws]
    DTWS1,            -- Instruct. Key 1 [dtat16]
    DTWS2,            -- Instruct. Key 2 [dtat17]
    DTWS3,            -- Instruct. key 3 [dtat18]
    DTWS4,            -- Instruct. key 4 [dtat19]
    SUB_FLOW_NUMBER,  -- Flow Number [tpm_trdflownr]
    UZAWE,            -- Pmnt Meth. Sup. [uzawe]
    CLASS_OID,        -- GUID [os_guid]
    POSITION_OID,     -- DB Object ID [tpm_db_os_guid]
    MNDID,            -- Mandate Ref. [sepa_mndid]
    PAYMENT_CAT,      -- Paymt. Cat. [tpm_payment_cat]
    PAYMENT_REASON,   -- Payment Reason [farp_payt_rsn]
    LIFNR,            -- Vendor [tpm_lifnr]
    PRIMARY KEY (MANDT, OS_GUID)
);

Learn More