SAP Table FDM_COLL_P2P_OVERVIEW

Promise to Pay Data for Invoice

FDM_COLL_P2P_OVERVIEW (Promise to Pay Data for Invoice) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FDM_COLL_P2P_OVERVIEW to other SAP tables.

FDM_COLL_P2P_OVERVIEW table fields

Field Data element Checktable Datatype Length Decimals
CUSTOMER Customer Number KUNNR CHAR 10 0
CASE_GUID FSCM-DM: GUID (Internal Key of Dispute Case) BDM_CASE_GUID CHAR 32 0
EXT_KEY Case ID SCMG_EXT_KEY CHAR 12 0
COMP_CODE Company Code BUKRS CHAR 4 0
INVOICE_NO Accounting Document Number BELNR_D CHAR 10 0
DOC_ITEM Number of Line Item Within Accounting Document BUZEI NUMC 3 0
FISCAL_YEAR Fiscal Year GJAHR NUMC 4 0
BILLING_DOC Billing Document VBELN_VF CHAR 10 0
P2P_CURR Currency of Promise to Pay BDM_PROMISE_CURR CUKY 5 0
PROMISED_AMT Amount Promised for Payment BDM_PROMISED_AMOUNT CURR 15 2
PROMISED_BY Clerk That Gave the Promise to Pay BDM_PROMISED_BY CHAR 40 0
CONTACT_MAIL e-mail Address of Contact Person at Business Partner FDM_CONTACT_EMAIL CHAR 128 0
CONTACT_TEL Telephone Number of Contact Person at Business Partner FDM_CONTACT_PHONE CHAR 30 0
CONTACT_FAX Fax Number of Contact Person at Business Partner FDM_CONTACT_FAX CHAR 30 0
CONTACT_FAXC Country of Fax Number of Contact Person FDM_CONTACT_FAXC CHAR 3 0
P2P_DUE_DATE Date for Which Payment Is Promised BDM_PROMISE_DUE_DATE DATS 8 0
PAID_AMOUNT Amount Paid for Promise to Pay FDM_PAID_P2P_AMOUNT CURR 15 2
LAST_PAYMENT Date of Last Payment BDM_LAST_PAYMENT_DATE DATS 8 0
P2P_DATE Date on Which Promise to Pay Was Given BDM_PROMISE_DATE DATS 8 0
P2P_STATE State of Promise to Pay BDM_PROMISE_STATE CHAR 1 0
0 Open
1 Broken
2 Partially Kept
3 Kept
4 Withdrawn
5 Not on Schedule
6 Partially Kept, Not on Schedule
7 Partially Kept, on Schedule
8 Kept, Not on Schedule
9 Kept, on Schedule
P2P_LEVEL Level of Promise to Pay BDM_PROMISE_LEVEL INT1 3 0
P2P_REF Promise to Pay Reference FDM_P2P_REF CHAR 30 0
INST_PLAN_TYPE Installment Plan Type for Promise to Pay FDM_INST_PLAN_TYPE CHAR 4 0
NO_OF_INST Number of Installments in the Promise to Pay in Installments BDM_NO_OF_INSTMNTS INT4 10 0
PAID_OS Installment Amounts Paid on Schedule BDM_PAID_ON_SCHEDULE CURR 15 2
PAID_NOT_OS Installment Amounts Not Paid on Schedule BDM_PAID_NOT_ON_SCHEDULE CURR 15 2
INST_IS_OVERDUE Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_D CHAR 1 0
X TRUE
NULL FALSE
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BSCHL Posting Key BSCHL CHAR 2 0