_COLLSPROMISETOPAY
_COLLSPROMISETOPAY is an SAP database table in S/4HANA. It contains 30 fields.
Fields (30)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA