I_PREPAYMENTAGREEMENTTP

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 Agreement Transactional view
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PREPAYMENTAGREEMENTTP (
    PREPAYMENTAGREEMENTUUID,
    _PREPAYMENTECONOMICGRPREL,
    ADDRESSNUMBER,
    BPTAXNUMBER,
    COMPANYCODE,
    COMPANYREGION,
    COUNTERPARTY,
    COUNTRYCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    ISREJECTED,
    LASTCHANGEDATETIME,
    PLANT,
    PREPAYMENTAGREEMENT,
    PREPAYMENTAGREEMENTAMOUNT,
    PREPAYMENTAGREEMENTCATEGORY,
    PREPAYMENTAGREEMENTCOMMODITY,
    PREPAYMENTAGREEMENTCURRENCY,
    PREPAYMENTAGREEMENTDESCRIPTION,
    PREPAYMENTAGREEMENTRATING,
    PREPAYMENTAGREEMENTSTATUS,
    PREPAYMENTAGREEMENTTYPE,
    PREPAYMENTAGRMTBPTYPE,
    PREPAYMENTAGRMTCROPSEASON,
    PREPAYMENTAGRMTDUEDATE,
    PREPAYMENTAGRMTEXTCOMMENTTEXT,
    PREPAYMENTAGRMTINTCOMMENTTEXT,
    PREPAYMENTAGRMTISBARTER,
    PREPAYMENTAGRMTISLINKED,
    PREPAYMENTAGRMTISPOSTED,
    PREPAYMENTAGRMTISRENEGOTIATED,
    PREPAYMENTAGRMTISREOPENED,
    PREPAYMENTAGRMTLINKSTATUS,
    PREPAYMENTAGRMTPOSTINGSTATUS,
    PREPAYMENTAGRMTRJCNREASON,
    PREPAYMENTBARTERLINKSTATUS,
    PREPAYMENTCMTMTPERCENT,
    PREPAYMENTCOSTHECTARECURRENCY,
    PREPAYMENTCOSTOFPLEDGEAMT,
    PREPAYMENTCOSTOFPLEDGECURRENCY,
    PREPAYMENTCOSTPERHECTAREAMT,
    PREPAYMENTCREDITCONTRACTFLAG,
    PREPAYMENTCREDITHISTORYTXT,
    PREPAYMENTCREDITREGION,
    PREPAYMENTCREDITTOTALAREAQTY,
    PREPAYMENTCREDITTOTALAREAUOM,
    PREPAYMENTCREDITTOTALCOST,
    PREPAYMENTECONOMICGROUP,
    PREPAYMENTESTIMATEDPRODNQTY,
    PREPAYMENTESTIMATEDPRODNUOM,
    PREPAYMENTISRENEGOTIATED,
    PREPAYMENTISRENEGTTNCSHSETTLMT,
    PREPAYMENTISRENEGTTNSTOPINTRST,
    PREPAYMENTLEASEDPLANTAREAQTY,
    PREPAYMENTLIMITCREDITDATE,
    PREPAYMENTOWNPLANTINGAREAQTY,
    PREPAYMENTOWNPLANTINGAREAUOM,
    PREPAYMENTOWNPLEDGEDAREAQTY,
    PREPAYMENTOWNPLEDGEDAREAUOM,
    PREPAYMENTPAYOUTPERCENT,
    PREPAYMENTPLANTINGAREAUOM,
    PREPAYMENTPLEDGEDAREAQTY,
    PREPAYMENTPLEDGEDAREAUOM,
    PREPAYMENTPLEDGEDPRODTVAREAQTY,
    PREPAYMENTPLEDGEDPRODTVAREAUOM,
    PREPAYMENTPOSTINGPROFILE,
    PREPAYMENTPRINCIPALREDUCTION,
    PREPAYMENTPRODTVPLANTAREAQTY,
    PREPAYMENTPRODTVPLANTAREAUOM,
    PREPAYMENTPRODUCTIVEFCTRPERUOM,
    PREPAYMENTPRODUCTIVITYFCTRQTY,
    PREPAYMENTPRODUCTIVITYFCTRUOM,
    PREPAYMENTREJECTIONTEXT,
    PREPAYMENTRENEGOTIATIONACTION,
    PREPAYMENTRENEGTTNSTOPDATE,
    PREPAYMENTRESTRICTIONSTXT,
    PREPAYMENTSIMULATEISVISIBLE,
    PREPAYMENTSTARTINTRSTDATE,
    PREPAYMENTSTARTINTRSTDATETYPE,
    PREPAYMENTSTOPINTRSTDATE,
    PREPAYMENTSTOPINTRSTDATETYPE,
    PREPAYMENTSUSPENDINTRSTFROMDTE,
    PREPAYMENTSUSPENDINTRSTTODTE,
    PREPAYMENTTOTALCOSTCURRENCY,
    PREPAYMENTTOTALPLEDGEDAREAQTY,
    PREPAYMENTTOTALPLEDGEDAREAUOM,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SALESORGANIZATION,
    PRIMARY KEY (PREPAYMENTAGREEMENTUUID)
);