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