PAYTRCPT

Transparent Table Application Table
31 Fields 4 CDS Views

Payment Receipt

PAYTRCPT is an SAP database table in S/4HANA. Payment Receipt. It contains 31 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PaymentReceipt view from BASIC Payment Receipt
I_PaymentReceiptPaytDetail view inner BASIC Payment Receipt Payment Detail
I_PaymentReceiptRelatedDoc view left_outer BASIC Payment Receipt Related Acctg Documents
I_PH_PaymentReceipt view inner BASIC Payment Receipt for PH Specific fields

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY paytrcpt_uuid paytrcpt_uuid Payt Rcpt UUID
paytrcpt_ref_no awkey Reference Key
paytrcpt_type paytrcpt_type Payment Receipt Type
bukrs bukrs Company Code
paytrcpt_group grouprct Receipt Lot
paytrcpt_date paytrcpt_date Payt Rcpt Date
fiscalyear gjahr Fiscal Year
createrefuuid paytrcpt_crted_ref_uuid Based Receipt No
voidrefuuid paytrcpt_uuid Payt Rcpt UUID
ryoshusho ryoshusho Receipt (Japan)
createdbyuser uname User Name
createddate paytrcpt_createdate Payt Rcpt Crted Date
lastchangedbyuser uname User Name
changeddate paytrcpt_date Payt Rcpt Date
change_at timestampl Time Stamp
voidbyuser uname User Name
voideddate paytrcpt_voiddate Payt Rcpt Void Date
paytrcpt_id paytrcpt_id Payment Receipt ID
rldnr rldnr Ledger
customer kunnr Customer
supplier lifnr Supplier
status paytrcpt_status Status
output_uuid /bobf/conf_key NodeID
voidr paytrcpt_voidr Voided Reason
voidremark paytrcpt_remarks PR Void Reason Note
paytrcpt_ref1 paytrcpt_ref1 Reference 1
paytrcpt_ref2 paytrcpt_ref2 Reference 2
paytrcpt_ref3 paytrcpt_ref3 Reference 3
paidamount paytrcpt_amt_paid_in_tc
transactioncurrency waers Currency

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.

-- Payment Receipt
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PAYTRCPT (
    MANDT,                -- Client [mandt]
    PAYTRCPT_UUID,        -- Payt Rcpt UUID [paytrcpt_uuid]
    PAYTRCPT_REF_NO,      -- Reference Key [awkey]
    PAYTRCPT_TYPE,        -- Payment Receipt Type [paytrcpt_type]
    BUKRS,                -- Company Code [bukrs]
    PAYTRCPT_GROUP,       -- Receipt Lot [grouprct]
    PAYTRCPT_DATE,        -- Payt Rcpt Date [paytrcpt_date]
    FISCALYEAR,           -- Fiscal Year [gjahr]
    CREATEREFUUID,        -- Based Receipt No [paytrcpt_crted_ref_uuid]
    VOIDREFUUID,          -- Payt Rcpt UUID [paytrcpt_uuid]
    RYOSHUSHO,            -- Receipt (Japan) [ryoshusho]
    CREATEDBYUSER,        -- User Name [uname]
    CREATEDDATE,          -- Payt Rcpt Crted Date [paytrcpt_createdate]
    LASTCHANGEDBYUSER,    -- User Name [uname]
    CHANGEDDATE,          -- Payt Rcpt Date [paytrcpt_date]
    CHANGE_AT,            -- Time Stamp [timestampl]
    VOIDBYUSER,           -- User Name [uname]
    VOIDEDDATE,           -- Payt Rcpt Void Date [paytrcpt_voiddate]
    PAYTRCPT_ID,          -- Payment Receipt ID [paytrcpt_id]
    RLDNR,                -- Ledger [rldnr]
    CUSTOMER,             -- Customer [kunnr]
    SUPPLIER,             -- Supplier [lifnr]
    STATUS,               -- Status [paytrcpt_status]
    OUTPUT_UUID,          -- NodeID [/bobf/conf_key]
    VOIDR,                -- Voided Reason [paytrcpt_voidr]
    VOIDREMARK,           -- PR Void Reason Note [paytrcpt_remarks]
    PAYTRCPT_REF1,        -- Reference 1 [paytrcpt_ref1]
    PAYTRCPT_REF2,        -- Reference 2 [paytrcpt_ref2]
    PAYTRCPT_REF3,        -- Reference 3 [paytrcpt_ref3]
    PAIDAMOUNT,           -- paytrcpt_amt_paid_in_tc
    TRANSACTIONCURRENCY,  -- Currency [waers]
    PRIMARY KEY (MANDT, PAYTRCPT_UUID)
);

Learn More