PAYREQN_HIST

Transparent Table Application Table
17 Fields 1 CDS Views

Payment Requisition History

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RequisitionHistory view from BASIC Payment Requisition: History

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY hist_uuid payreqn_hist_uuid PayReqnHistID
reqn_uuid payreqn_reqn_uuid PaymentReqnID
stgy_uuid payreqn_stgy_uuid Payt Reqn Stgy UUID
pay_item_uuid payreqn_pay_item_uuid PayItemUUID
action payreqn_action Action
msgty symsgty Message Type
msgid symsgid Message Class
msgno msgnr Message
msgv1 symsgv Message Variable
msgv2 symsgv Message Variable
msgv3 symsgv Message Variable
msgv4 symsgv Message Variable
created_by vdm_createdbyuserid Created By
created_on farp_prq_cr_date Created On
changed_on farp_prq_chg_date Changed On
historydatetime farp_prq_cr_date Created 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 History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PAYREQN_HIST (
    MANDT,            -- Client [mandt]
    HIST_UUID,        -- PayReqnHistID [payreqn_hist_uuid]
    REQN_UUID,        -- PaymentReqnID [payreqn_reqn_uuid]
    STGY_UUID,        -- Payt Reqn Stgy UUID [payreqn_stgy_uuid]
    PAY_ITEM_UUID,    -- PayItemUUID [payreqn_pay_item_uuid]
    ACTION,           -- Action [payreqn_action]
    MSGTY,            -- Message Type [symsgty]
    MSGID,            -- Message Class [symsgid]
    MSGNO,            -- Message [msgnr]
    MSGV1,            -- Message Variable [symsgv]
    MSGV2,            -- Message Variable [symsgv]
    MSGV3,            -- Message Variable [symsgv]
    MSGV4,            -- Message Variable [symsgv]
    CREATED_BY,       -- Created By [vdm_createdbyuserid]
    CREATED_ON,       -- Created On [farp_prq_cr_date]
    CHANGED_ON,       -- Changed On [farp_prq_chg_date]
    HISTORYDATETIME,  -- Created On [farp_prq_cr_date]
    PRIMARY KEY (MANDT, HIST_UUID)
);

Learn More