The CDBD_PAYPLAN_DC table in SAP ERP or S/4HANA stores BT – payment plan – Dat e – Payment Card data. There are total 51 fields in CDBD_PAYPLAN_DC table. The BT – payment plan – Dat e – Payment Card table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CDBD_PAYPLAN_DC table. It is in CRM Order: CDB Objects for General Sales Order Processing (CDB_ORDER) ABAP package and is part of the Business Transactions (CRM-BTX) module.
SAP CDBD_PAYPLAN_DC Table Fields
Following is the list of fields that are available in SAP CDBD_PAYPLAN_DC table. The primary key fields of BT – payment plan – Dat e – Payment Card table in SAP are CLIENT (Client), PAYPLAN_DC_GUID (Own guid for Payment Plan Date/Item: Payment Card Data).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| PAYPLAN_DC_GUID | Own guid for Payment Plan Date/Item: Payment Card Data | CDBT_PAYPLAN_DC_GUID | RAW (16) | |
| PAYPLAN_GUID | Own guid for Payment Plan Header | CDBT_PAYPLAN_GUID | RAW (16) | |
| CARD_TYPE | Payment Card Type | CC_INSTITUTE | TB033 | CHAR (4) |
| CARD_NO | Payment cards: Card number | CCNUM | * | CHAR (25) |
| CARD_SUFFIX | Sequential Number of Payment Card | COMT_CARD_SUFFIX | CHAR (10) | |
| CARD_REF_NO | Payment Cards: Reference Number of a Payment Card | COMT_CARD_REF_NO | CHAR (25) | |
| CARD_BEG_DATE | Payment cards: Valid from | CC_DATAB | DATS (8) | |
| CARD_EXP_DATE | Payment Cards: Valid To | CC_DATBI | DATS (8) | |
| CARD_HOLDER | Payment cards: Name of cardholder | CCNAME | CHAR (40) | |
| CARD_MERCH_ID | Identification of Merchant at Clearing House | COMT_CARD_MERCH_ID | * | CHAR (15) |
| CARD_DEFAULT | Payment Cards: Indicator for a Standard Card | COMT_CARD_DEFAULT | CHAR (1) | |
| CARD_CVV | Payment Cards: Card Verification Value | COMT_CARD_CVV | CHAR (6) | |
| CARD_CVV_STATUS | Payment Cards: State of Card Verification Value | COMT_CARD_CVV_STATUS | CHAR (1) | |
| CARD_CVV_CONTROL | Payment Cards: Control Field for Card Verification Value | COMT_CARD_CVV_CONTROL | CHAR (1) | |
| CARD_GUID | Payment Cards: GUID of Payment Card | COMT_CARD_GUID | RAW (16) | |
| CARD_TOKEN | Token for Credit Card Integration | CCTOKEN | * | CHAR (25) |
| AUTH_LIMIT | Payment Cards: Maximum Amount of Value to be Authorized | COMT_AUTH_LIMIT | CURR (15) | |
| AUTH_LIMITED | Payment Cards: Limited Value | COMT_AUTH_LIMITED | CHAR (1) | |
| AUTH_AMOUNT | Payment Cards: Authorized Amount | COMT_AUTH_AMOUNT | CURR (15) | |
| AUTH_USED | Authorization Is Already Used | COMT_AUTH_USED | CHAR (1) | |
| AUTH_USED_BY | Authorization Line: Used By | COMT_AUTH_USED_BY | CHAR (10) | |
| AUTH_USED_OBJTYP | Authorization Line: Used By Object Type | COMT_AUTH_USED_OBJTYPE | * | CHAR (10) |
| AUTH_USED_LOGSYS | Authorization Line: Used By Logical System | COMT_AUTH_USED_LOGSYS | * | CHAR (10) |
| AUTH_USED_AMOUNT | Authorization Line: Used Amount | COMT_AUTH_USED_AMOUNT | CURR (15) | |
| AUTH_NO | Payment Cards: Authorization Number | COMT_AUTH_NO | CHAR (10) | |
| AUTH_REF | Authorization Reference Number of Clearing House | COMT_AUTH_REF | CHAR (30) | |
| AUTH_PRE | Payment Cards: Preauthorization | COMT_AUTH_PRE | CHAR (1) | |
| AUTH_TIMESTAMP | Date and Time of Authorization | COMT_AUTH_TIMESTAMP | DEC (15) | |
| AUTH_CALL_STATUS | Payment Cards: Status when Calling Clearing House | COMT_AUTH_CALL_STATUS | CHAR (1) | |
| AUTH_RESP | Response to Authorization Result | COMT_AUTH_RESP | CHAR (1) | |
| AUTH_REQ_AMOUNT | Payment Cards: Amount to be Authorized | COMT_AUTH_REQ_AMOUNT | CURR (15) | |
| AUTH_TIMESTAMPIO | Date and Time of Authorization in Display Format | COMT_AUTH_TIMESTAMPIO | CHAR (26) | |
| AUTH_TYPE | Authorization Type for Payment Cards | COMT_AUTH_TYPE | CHAR (1) | |
| AUTH_SEPARATE | Indicates that this card will be authorized separately | COMT_AUTH_SEPARATE | CHAR (1) | |
| AUTH_EXP_TIMESTAMP | Date and Time of Authorization Expiration | CRMS4T_AUTH_EXP_TIMESTAMP | DEC (15) | |
| AUTH_RESP_RC_AR | Payment Cards: Result of Address Check (Address Result) | COMT_AUTH_RESP_RC_AR | COMC_PC_RESP | CHAR (4) |
| AUTH_RESP_RC_AP | Payment Cards: Result of Address Check (Address Approval) | COMT_AUTH_RESP_RC_AP | COMC_PC_RESP | CHAR (4) |
| AUTH_RESP_RC_ZR | Payment Cards: Result of Address Check (ZIP Code Result) | COMT_AUTH_RESP_RC_ZR | COMC_PC_RESP | CHAR (4) |
| AUTH_RESP_RC_CC | Payment Cards: Result of Card Check (Response Code) | COMT_AUTH_RESP_RC_CC | COMC_PC_RESP | CHAR (4) |
| AUTH_RESP_RC_CVV | Payment Cards: Result Check of the Card Verification Code | COMT_AUTH_RESP_RC_CVV | CHAR (4) | |
| AUTH_RESP_CODE | Results Text of Authorization | COMT_AUTH_RESP_CODE | CHAR (40) | |
| CARD_ORIG | Payment Cards: Data Origin | COMT_CARD_ORIG | CHAR (1) | |
| CARD_CATEGORY | Payment cards: Card category | CC_CCTYP | * | CHAR (2) |
| AUTH_EXP | Payment Cards: Authorization Expired | COMT_AUTH_EXP | CHAR (1) | |
| TR_USER | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_ID | Character field, length 32 | CHAR32 | CHAR (32) | |
| TR_STATUS | Undefined range (can be used for patch levels) | CHAR4 | CHAR (4) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| DELETED | Single-Character Flag | CHAR1 | CHAR (1) | |
| TR_ROOTID | Character field, length 32 | CHAR32 | CHAR (32) |
