COLLP2PDRA

Transparent Table Application Table
46 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 46 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 (46)

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
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_p2p_incl_eew_ps CFD_DUMMY Dummy

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]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,   -- abap.char
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_P2P_INCL_EEW_PS,          -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PROMISETOPAYUUID, DRAFTUUID)
);

Learn More