PAYTRCPT

Transparent Table Application Table

Payment Receipt

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

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
dummy_paytrcpt_incl_eew_ps DUMMY Dummy function in length 1

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]
    DUMMY_PAYTRCPT_INCL_EEW_PS,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, PAYTRCPT_UUID)
);