TRPRT_PAYMENTS

Transparent Table Application Table
61 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 61 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_TreasuryPaymentRequest view from BASIC Treasury Payment Request
P_TrprtPayments view from BASIC

Fields (61)

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
create_name RERF Entered By
create_date DERF First Enterd On
create_time TERF Time
create_tcode TCODE Transaction Code
change_name RBEAR Last Changed By
change_date DBEAR Last Edited On
change_time TBEAR Last Edited At
change_tcode TCODE Transaction Code
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]
    CREATE_NAME,      -- Entered By [RERF]
    CREATE_DATE,      -- First Enterd On [DERF]
    CREATE_TIME,      -- Time [TERF]
    CREATE_TCODE,     -- Transaction Code [TCODE]
    CHANGE_NAME,      -- Last Changed By [RBEAR]
    CHANGE_DATE,      -- Last Edited On [DBEAR]
    CHANGE_TIME,      -- Last Edited At [TBEAR]
    CHANGE_TCODE,     -- Transaction Code [TCODE]
    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