PAYREQN_REQN

Transparent Table Application Table
20 Fields 1 CDS Views

Payment Requisition

PAYREQN_REQN is an SAP database table in S/4HANA. Payment Requisition. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PaymentRequisition view from BASIC Payment Requisition

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY reqn_uuid payreqn_reqn_uuid PaymentReqnID
reqn_num payreqn_reqn_num PayReqnNumber
bukrs bukrs Company Code
reqn_status payreqn_reqn_status PayReqnStatus
lifnr lifnr Supplier
priority payreqn_priority Priority
reqn_amount payreqn_reqn_amount Payt Reqn Amount
currency waers Currency
reqn_type payreqn_reqn_type PayReqnType
prefer_pay_method payreqn_payment_method Pref Payment Method
notetext payreqn_notetext Remark
reject_reason payreqn_reject_reason Reject Reason
planned_payment_date payreqn_plan_payt_date Planned Payment Date
payment_reason farp_rstgr Reason Code
authorizationgroup brgru Authorization
created_by vdm_createdbyuserid Created By
created_on farp_prq_cr_date Created On
changed_by farp_changed_by Changed By
changed_on farp_prq_chg_date Changed On

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 Requisition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PAYREQN_REQN (
    MANDT,                 -- Client [mandt]
    REQN_UUID,             -- PaymentReqnID [payreqn_reqn_uuid]
    REQN_NUM,              -- PayReqnNumber [payreqn_reqn_num]
    BUKRS,                 -- Company Code [bukrs]
    REQN_STATUS,           -- PayReqnStatus [payreqn_reqn_status]
    LIFNR,                 -- Supplier [lifnr]
    PRIORITY,              -- Priority [payreqn_priority]
    REQN_AMOUNT,           -- Payt Reqn Amount [payreqn_reqn_amount]
    CURRENCY,              -- Currency [waers]
    REQN_TYPE,             -- PayReqnType [payreqn_reqn_type]
    PREFER_PAY_METHOD,     -- Pref Payment Method [payreqn_payment_method]
    NOTETEXT,              -- Remark [payreqn_notetext]
    REJECT_REASON,         -- Reject Reason [payreqn_reject_reason]
    PLANNED_PAYMENT_DATE,  -- Planned Payment Date [payreqn_plan_payt_date]
    PAYMENT_REASON,        -- Reason Code [farp_rstgr]
    AUTHORIZATIONGROUP,    -- Authorization [brgru]
    CREATED_BY,            -- Created By [vdm_createdbyuserid]
    CREATED_ON,            -- Created On [farp_prq_cr_date]
    CHANGED_BY,            -- Changed By [farp_changed_by]
    CHANGED_ON,            -- Changed On [farp_prq_chg_date]
    PRIMARY KEY (MANDT, REQN_UUID)
);

Learn More