P_COLLSPROMISETOPAYDRAFT

CDS View
49 Fields 3 CDS Views

Promise To Pay Draft

P_COLLSPROMISETOPAYDRAFT is a CDS View in S/4HANA. Promise To Pay Draft. It contains 49 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
R_CollsHeadOfficePromiseToPay view inner COMPOSITE Head Ofice Promise to Pay
R_CollsPrmsToPayCollsSegmentTP view inner TRANSACTIONAL Promise To Pay in Collections Segment
R_CollsPromiseToPayDraftTP view from TRANSACTIONAL Promise to Pay with Draft

Fields (49)

KeyField CDS FieldsUsed in Views
KEY Customer Customer 1
KEY PromiseToPayUUID PromiseToPayUUID 1
_CaseAttribute _CaseAttribute 1
_ChangedByContactCard _ChangedByContactCard 1
_ClosedByContactCard _ClosedByContactCard 1
_CollsPromiseToPayStatus _CollsPromiseToPayStatus 1
_CompanyCode _CompanyCode 1
_Country _Country 1
_CreatedByContactCard _CreatedByContactCard 1
_Currency _Currency 1
_Customer _Customer 1
_DraftAdministrativeData _DraftAdministrativeData 1
CaseClosedBy CaseClosedBy 1
CaseClosedTime CaseClosedTime 1
CaseCreatedBy CaseCreatedBy 1
CaseCreatedOn CaseCreatedOn 1
CaseExternalReference CaseExternalReference 1
CaseID CaseID 1
CaseLastChangedBy CaseLastChangedBy 1
CaseLastChangedOn CaseLastChangedOn 1
CaseType CaseType 1
CompanyCode CompanyCode 1
ContactPersonEmailAddress ContactPersonEmailAddress 1
ContactPersonFaxCountry ContactPersonFaxCountry 1
ContactPersonFaxNumber ContactPersonFaxNumber 1
ContactPersonPhoneNumber ContactPersonPhoneNumber 1
Currency Currency 1
DraftAdministrativeDataUUID DraftAdministrativeDataUUID 1
DraftCreationDateTime DraftCreationDateTime 1
DraftLastChangedDateTime DraftLastChangedDateTime 1
DraftUUID DraftUUID 1
DueDate DueDate 2
HasActiveEntity HasActiveEntity 1
IsActiveEntity IsActiveEntity 1
LastPaymentDate LastPaymentDate 1
LinkedInvoiceKey LinkedInvoiceKey 1
NextInstallmentAmount NextInstallmentAmount 1
NextInstallmentDueDate NextInstallmentDueDate 1
NumberOfInstallments NumberOfInstallments 1
ObjectType ObjectType 1
PaidAmount PaidAmount 2
PaidOffScheduleAmount PaidOffScheduleAmount 1
PaidOnScheduleAmount PaidOnScheduleAmount 1
Prms2PToInvoiceGroupRefUUID Prms2PToInvoiceGroupRefUUID 1
PromisedAmount PromisedAmount 1
PromiseToPayDate PromiseToPayDate 1
PromiseToPayGivenByPersonName PromiseToPayGivenByPersonName 1
PromiseToPayLevel PromiseToPayLevel 1
PromiseToPayStatus PromiseToPayStatus 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.

-- Promise To Pay Draft
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_COLLSPROMISETOPAYDRAFT (
    CUSTOMER,
    PROMISETOPAYUUID,
    _CASEATTRIBUTE,
    _CHANGEDBYCONTACTCARD,
    _CLOSEDBYCONTACTCARD,
    _COLLSPROMISETOPAYSTATUS,
    _COMPANYCODE,
    _COUNTRY,
    _CREATEDBYCONTACTCARD,
    _CURRENCY,
    _CUSTOMER,
    _DRAFTADMINISTRATIVEDATA,
    CASECLOSEDBY,
    CASECLOSEDTIME,
    CASECREATEDBY,
    CASECREATEDON,
    CASEEXTERNALREFERENCE,
    CASEID,
    CASELASTCHANGEDBY,
    CASELASTCHANGEDON,
    CASETYPE,
    COMPANYCODE,
    CONTACTPERSONEMAILADDRESS,
    CONTACTPERSONFAXCOUNTRY,
    CONTACTPERSONFAXNUMBER,
    CONTACTPERSONPHONENUMBER,
    CURRENCY,
    DRAFTADMINISTRATIVEDATAUUID,
    DRAFTCREATIONDATETIME,
    DRAFTLASTCHANGEDDATETIME,
    DRAFTUUID,
    DUEDATE,
    HASACTIVEENTITY,
    ISACTIVEENTITY,
    LASTPAYMENTDATE,
    LINKEDINVOICEKEY,
    NEXTINSTALLMENTAMOUNT,
    NEXTINSTALLMENTDUEDATE,
    NUMBEROFINSTALLMENTS,
    OBJECTTYPE,
    PAIDAMOUNT,
    PAIDOFFSCHEDULEAMOUNT,
    PAIDONSCHEDULEAMOUNT,
    PRMS2PTOINVOICEGROUPREFUUID,
    PROMISEDAMOUNT,
    PROMISETOPAYDATE,
    PROMISETOPAYGIVENBYPERSONNAME,
    PROMISETOPAYLEVEL,
    PROMISETOPAYSTATUS,
    PRIMARY KEY (CUSTOMER, PROMISETOPAYUUID)
);

Learn More