COLLP2PDRA

Transparent Table Application Table
38 Fields 1 CDS Views

Draft table for entity R_COLLSPROMISETOPAYTP

COLLP2PDRA is an SAP database table in S/4HANA. Draft table for entity R_COLLSPROMISETOPAYTP. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CollsPromiseToPayDraft view from BASIC Promise To Pay Draft

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY promisetopayuuid bdm_case_guid Internal Key
KEY draftuuid sdraft_uuid Draft Document ID
companycode bdm_comp_code Company Code
customer udm_kunnr Customer
objecttype swo_objtyp Object Type
linkedinvoicekey swo_typeid Key
promisedamount coll_p2p_promised_amount Promised Amount
paidamount coll_p2p_paid_amount Paid Amount
currency bdm_promise_curr Currency
duedate bdm_promise_due_date Promised For
promisetopaydate bdm_promise_date Promised On
lastpaymentdate bdm_last_payment_date Last Payment
promisetopaystatus bdm_promise_state State
promisetopaylevel bdm_promise_level Level
promisetopaygivenbypersonname bdm_promised_by Promised By
contactpersonemailaddress udm_contact_email Email
contactpersonphonenumber udm_contact_phone Telephone No.
contactpersonfaxnumber udm_contact_fax Fax Number
contactpersonfaxcountry udm_contact_faxc C/R of Fax No.
contactperson udm_contact_key Contact Person Key
numberofinstallments bdm_no_of_instmnts Installments
paidonscheduleamount coll_p2p_inst_paid_os Installment Amounts Paid on Schedule
paidoffscheduleamount bdm_paid_not_on_schedule Not on Schedule
nextinstallmentduedate udm_next_inst_due_date Due Date of Next Open Installment
nextinstallmentamount udm_next_inst_open_amt Open Amount
prms2ptoinvoicegrouprefuuid sysuuid_c UUID
caseid scmg_ext_key Case ID
caseexternalreference coll_p2p_external_reference External Reference
casecreatedby scmg_create_user Created By
casecreatedon coll_pr_creation_date_time Created At
caselastchangedby scmg_change_user Changed By
caselastchangedon coll_pr_changed_at Last Changed At
caseclosedby scmg_closed_by Closed By
caseclosedtime coll_pr_closed_at Closed At
promisedamountforedit coll_p2p_promised_amount Promised Amount
iscleared integer Integer
bopfuuid sdraft_uuid Draft Document ID

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.

-- Draft table for entity R_COLLSPROMISETOPAYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COLLP2PDRA (
    MANDT,                          -- Client [mandt]
    PROMISETOPAYUUID,               -- Internal Key [bdm_case_guid]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    COMPANYCODE,                    -- Company Code [bdm_comp_code]
    CUSTOMER,                       -- Customer [udm_kunnr]
    OBJECTTYPE,                     -- Object Type [swo_objtyp]
    LINKEDINVOICEKEY,               -- Key [swo_typeid]
    PROMISEDAMOUNT,                 -- Promised Amount [coll_p2p_promised_amount]
    PAIDAMOUNT,                     -- Paid Amount [coll_p2p_paid_amount]
    CURRENCY,                       -- Currency [bdm_promise_curr]
    DUEDATE,                        -- Promised For [bdm_promise_due_date]
    PROMISETOPAYDATE,               -- Promised On [bdm_promise_date]
    LASTPAYMENTDATE,                -- Last Payment [bdm_last_payment_date]
    PROMISETOPAYSTATUS,             -- State [bdm_promise_state]
    PROMISETOPAYLEVEL,              -- Level [bdm_promise_level]
    PROMISETOPAYGIVENBYPERSONNAME,  -- Promised By [bdm_promised_by]
    CONTACTPERSONEMAILADDRESS,      -- Email [udm_contact_email]
    CONTACTPERSONPHONENUMBER,       -- Telephone No. [udm_contact_phone]
    CONTACTPERSONFAXNUMBER,         -- Fax Number [udm_contact_fax]
    CONTACTPERSONFAXCOUNTRY,        -- C/R of Fax No. [udm_contact_faxc]
    CONTACTPERSON,                  -- Contact Person Key [udm_contact_key]
    NUMBEROFINSTALLMENTS,           -- Installments [bdm_no_of_instmnts]
    PAIDONSCHEDULEAMOUNT,           -- Installment Amounts Paid on Schedule [coll_p2p_inst_paid_os]
    PAIDOFFSCHEDULEAMOUNT,          -- Not on Schedule [bdm_paid_not_on_schedule]
    NEXTINSTALLMENTDUEDATE,         -- Due Date of Next Open Installment [udm_next_inst_due_date]
    NEXTINSTALLMENTAMOUNT,          -- Open Amount [udm_next_inst_open_amt]
    PRMS2PTOINVOICEGROUPREFUUID,    -- UUID [sysuuid_c]
    CASEID,                         -- Case ID [scmg_ext_key]
    CASEEXTERNALREFERENCE,          -- External Reference [coll_p2p_external_reference]
    CASECREATEDBY,                  -- Created By [scmg_create_user]
    CASECREATEDON,                  -- Created At [coll_pr_creation_date_time]
    CASELASTCHANGEDBY,              -- Changed By [scmg_change_user]
    CASELASTCHANGEDON,              -- Last Changed At [coll_pr_changed_at]
    CASECLOSEDBY,                   -- Closed By [scmg_closed_by]
    CASECLOSEDTIME,                 -- Closed At [coll_pr_closed_at]
    PROMISEDAMOUNTFOREDIT,          -- Promised Amount [coll_p2p_promised_amount]
    ISCLEARED,                      -- Integer [integer]
    BOPFUUID,                       -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, PROMISETOPAYUUID, DRAFTUUID)
);

Learn More