_COLLSPROMISETOPAY

_COLLSPROMISETOPAY is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
CaseClosedBy CaseClosedBy 1
CaseClosedTime CaseClosedTime 1
CaseCreatedBy CaseCreatedBy 1
CaseCreatedOn CaseCreatedOn 1
CaseExternalReference CaseExternalReference 1
CaseID CaseID 1
CaseLastChangedBy CaseLastChangedBy 1
CaseLastChangedOn CaseLastChangedOn 1
ContactPerson ContactPerson 1
ContactPersonEmailAddress ContactPersonEmailAddress 1
ContactPersonFaxCountry ContactPersonFaxCountry 1
ContactPersonFaxNumber ContactPersonFaxNumber 1
ContactPersonPhoneNumber ContactPersonPhoneNumber 1
Currency Currency 1
Customer Customer 1
DueDate DueDate 1
LastPaymentDate LastPaymentDate 1
NextInstallmentAmount NextInstallmentAmount 1
NextInstallmentDueDate NextInstallmentDueDate 1
NumberOfInstallments NumberOfInstallments 1
PaidAmount PaidAmount 1
PaidOffScheduleAmount PaidOffScheduleAmount 1
PaidOnScheduleAmount PaidOnScheduleAmount 1
Prms2PToInvoiceGroupRefUUID Prms2PToInvoiceGroupRefUUID 1
PromisedAmount PromisedAmount 1
PromiseToPayDate PromiseToPayDate 1
PromiseToPayGivenByPersonName PromiseToPayGivenByPersonName 1
PromiseToPayLevel PromiseToPayLevel 1
PromiseToPayStatus PromiseToPayStatus 1
PromiseToPayUUID PromiseToPayUUID 1

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 _COLLSPROMISETOPAY (
    CASECLOSEDBY,
    CASECLOSEDTIME,
    CASECREATEDBY,
    CASECREATEDON,
    CASEEXTERNALREFERENCE,
    CASEID,
    CASELASTCHANGEDBY,
    CASELASTCHANGEDON,
    CONTACTPERSON,
    CONTACTPERSONEMAILADDRESS,
    CONTACTPERSONFAXCOUNTRY,
    CONTACTPERSONFAXNUMBER,
    CONTACTPERSONPHONENUMBER,
    CURRENCY,
    CUSTOMER,
    DUEDATE,
    LASTPAYMENTDATE,
    NEXTINSTALLMENTAMOUNT,
    NEXTINSTALLMENTDUEDATE,
    NUMBEROFINSTALLMENTS,
    PAIDAMOUNT,
    PAIDOFFSCHEDULEAMOUNT,
    PAIDONSCHEDULEAMOUNT,
    PRMS2PTOINVOICEGROUPREFUUID,
    PROMISEDAMOUNT,
    PROMISETOPAYDATE,
    PROMISETOPAYGIVENBYPERSONNAME,
    PROMISETOPAYLEVEL,
    PROMISETOPAYSTATUS,
    PROMISETOPAYUUID
);