PREPAYMENTAGREEMENT

PREPAYMENTAGREEMENT is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY PrepaymentAgreementUUID PrepaymentAgreementUUID 4
AuthorizationGroup AuthorizationGroup 2
CompanyCode CompanyCode 7
Counterparty Counterparty 8
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 2
Plant Plant 1
PrepaymentAgreementAmount PrepaymentAgreementAmount 6
PrepaymentAgreementCategory PrepaymentAgreementCategory 6
PrepaymentAgreementCommodity PrepaymentAgreementCommodity 7
PrepaymentAgreementCurrency PrepaymentAgreementCurrency 6
PrepaymentAgreementStatus PrepaymentAgreementStatus 8
PrepaymentAgreementType PrepaymentAgreementType 7
PrepaymentAgrmtLinkStatus PrepaymentAgrmtLinkStatus 7
PrepaymentAgrmtPostingStatus PrepaymentAgrmtPostingStatus 5
PrepaymentBarterLinkStatus PrepaymentBarterLinkStatus 4
PrepaymentPayoutPercent PrepaymentPayoutPercent 5
PrepaymentStartIntrstDateType PrepaymentStartIntrstDateType 3
PrepaymentStopIntrstDateType PrepaymentStopIntrstDateType 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PREPAYMENTAGREEMENT (
    PREPAYMENTAGREEMENTUUID,
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    COUNTERPARTY,
    ISBUSINESSPURPOSECOMPLETED,
    PLANT,
    PREPAYMENTAGREEMENTAMOUNT,
    PREPAYMENTAGREEMENTCATEGORY,
    PREPAYMENTAGREEMENTCOMMODITY,
    PREPAYMENTAGREEMENTCURRENCY,
    PREPAYMENTAGREEMENTSTATUS,
    PREPAYMENTAGREEMENTTYPE,
    PREPAYMENTAGRMTLINKSTATUS,
    PREPAYMENTAGRMTPOSTINGSTATUS,
    PREPAYMENTBARTERLINKSTATUS,
    PREPAYMENTPAYOUTPERCENT,
    PREPAYMENTSTARTINTRSTDATETYPE,
    PREPAYMENTSTOPINTRSTDATETYPE,
    PRIMARY KEY (PREPAYMENTAGREEMENTUUID)
);