PAYTRCPT

Transparent Table Application Table
29 Fields 4 CDS Views

Payment Receipt

PAYTRCPT is an SAP database table in S/4HANA. Payment Receipt. It contains 29 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 (29)

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

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]
    PRIMARY KEY (MANDT, PAYTRCPT_UUID)
);

Learn More