I_PAYMENTREQUISITION

CDS View

Payment Requisition

I_PAYMENTREQUISITION is a CDS View in S/4HANA. Payment Requisition. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_CN_PayReqnWrkflwApprvlTmpl view_entity inner CONSUMPTION Payment Requisition Approval Email
C_CN_PayReqnWrkflwNotifTmpl view_entity inner CONSUMPTION Payment Requisiton Notification Email
R_CN_PaymentRequisitionTP view_entity from TRANSACTIONAL Payment Requisition for CN

Fields (16)

KeyField CDS FieldsUsed in Views
ChangedOnDateTime ChangedOnDateTime 2
CompanyCode CompanyCode 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
Currency Currency 2
LastChangedByUser LastChangedByUser 2
PaymentDifferenceReason PaymentDifferenceReason 2
PaymentMethod PaymentMethod 2
PaymentRequisitionNumber PaymentRequisitionNumber 2
PaymentRequisitionPriority PaymentRequisitionPriority 2
PaymentRequisitionStatus PaymentRequisitionStatus 2
PaymentRequisitionType PaymentRequisitionType 2
PaytRequisitionAmtInTransCrcy PaytRequisitionAmtInTransCrcy 2
PlannedPaymentDate PlannedPaymentDate 2
Supplier Supplier 2
WorkflowApproverNote WorkflowApproverNote 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PAYMENTREQUISITION (
    CHANGEDONDATETIME,
    COMPANYCODE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CURRENCY,
    LASTCHANGEDBYUSER,
    PAYMENTDIFFERENCEREASON,
    PAYMENTMETHOD,
    PAYMENTREQUISITIONNUMBER,
    PAYMENTREQUISITIONPRIORITY,
    PAYMENTREQUISITIONSTATUS,
    PAYMENTREQUISITIONTYPE,
    PAYTREQUISITIONAMTINTRANSCRCY,
    PLANNEDPAYMENTDATE,
    SUPPLIER,
    WORKFLOWAPPROVERNOTE
);