I_PREPAYMENTPAYMENTTERMS

CDS View
21 Fields 5 CDS Views

Prepayment Payment Terms

I_PREPAYMENTPAYMENTTERMS is a CDS View in S/4HANA. Prepayment Payment Terms. It contains 21 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_PrepaymentAgreementRequest view from CONSUMPTION Prepayment Request Tab Contract App
I_PrepaymentPayTermPostingMade view from COMPOSITE Prepayment Payment Terms Posting Made
I_PrepaymentPayTermPostingMade view union COMPOSITE Prepayment Payment Terms Posting Made
I_PrepaymentRequestPostingMade view from COMPOSITE Prepayment Request Posting Made
R_ACMContrPrePaytReqTP view_entity from TRANSACTIONAL Root for Prepayment Request

Fields (21)

KeyField CDS FieldsUsed in Views
KEY PrepaymentRequestUUID PrepaymentRequestUUID 2
ConditionApplication ConditionApplication 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
CustomerPaymentTerms CustomerPaymentTerms 3
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PrepaymentAgreement PrepaymentAgreement 2
PrepaymentReqPostingStatus PrepaymentReqPostingStatus 2
PrepaymentRequestAmount PrepaymentRequestAmount 2
PrepaymentRequestCurrency PrepaymentRequestCurrency 2
PrepaymentRequestDate PrepaymentRequestDate 2
PrepaymentRequestDocItem PrepaymentRequestDocItem 2
PrepaymentRequestDocNumber PrepaymentRequestDocNumber 2
PrepaymentRequestIsDeleted PrepaymentRequestIsDeleted 1
PrepaymentRequestIsMade PrepaymentRequestIsMade 1
PrepaymentRequestIsReceived PrepaymentRequestIsReceived 1
PrepaymentRequestIsRequested PrepaymentRequestIsRequested 1
PrepaymentRequestType PrepaymentRequestType 2
PrepaymentSerialNumber PrepaymentSerialNumber 2
SAPBusinessObjectTypeCode SAPBusinessObjectTypeCode 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.

-- Prepayment Payment Terms
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTPAYMENTTERMS (
    PREPAYMENTREQUESTUUID,
    CONDITIONAPPLICATION,
    CREATEDBYUSER,
    CREATIONDATETIME,
    CUSTOMERPAYMENTTERMS,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PREPAYMENTAGREEMENT,
    PREPAYMENTREQPOSTINGSTATUS,
    PREPAYMENTREQUESTAMOUNT,
    PREPAYMENTREQUESTCURRENCY,
    PREPAYMENTREQUESTDATE,
    PREPAYMENTREQUESTDOCITEM,
    PREPAYMENTREQUESTDOCNUMBER,
    PREPAYMENTREQUESTISDELETED,
    PREPAYMENTREQUESTISMADE,
    PREPAYMENTREQUESTISRECEIVED,
    PREPAYMENTREQUESTISREQUESTED,
    PREPAYMENTREQUESTTYPE,
    PREPAYMENTSERIALNUMBER,
    SAPBUSINESSOBJECTTYPECODE,
    PRIMARY KEY (PREPAYMENTREQUESTUUID)
);

Learn More