PAYTRCPT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA