SAP ABAP Table CRMS_WEC_ORDER_PAYMENT (Internet Sales: Payment Card)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ WEC-APP-SLS-CRM (Application Component) WebChannel Sales using CRM Sales
⤷ CRM_WEC_SALESTRANSACTIONS (Package) Web Channel: Sales Transactions
⤷ WEC-APP-SLS-CRM (Application Component) WebChannel Sales using CRM Sales
⤷ CRM_WEC_SALESTRANSACTIONS (Package) Web Channel: Sales Transactions
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_WEC_ORDER_PAYMENT | Table Relationship Diagram |
Short Description | Internet Sales: Payment Card |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | GUID | COMT_PAYPLAN_D_GUID | SYSUUID | RAW | 16 | 0 | GUID of Date/Item in Payment Plan | ||
2 | CARD_GUID | COMT_CARD_GUID | SYSUUID | RAW | 16 | 0 | Payment Cards: GUID of Payment Card | ||
3 | CARD_TYPE | CC_INSTITUTE | CC_INSTITUTE | CHAR | 4 | 0 | Payment card type | TB033 | |
4 | CARD_TYPE_DESCRIPTION | COMT_PAYCARD_TYPE_DESCR | TEXT40 | CHAR | 40 | 0 | Payment Form for Payment Plan Dates / Items | ||
5 | CARD_HOLDER | CCNAME | TEXT40 | CHAR | 40 | 0 | Payment Cards: Name of Cardholder | ||
6 | CARD_NUMBER | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | * | |
7 | CARD_EXP_DATE | CC_DATBI | DATUM | DATS | 8 | 0 | Payment Cards: Valid To | ||
8 | CARD_CVV | COMT_CARD_CVV | COM_CARD_CVV | CHAR | 6 | 0 | Payment Cards: Card Verification Value | ||
9 | CARD_SUFFIX | COMT_CARD_SUFFIX | CHAR10 | CHAR | 10 | 0 | Sequential Number of Payment Card | ||
10 | AUTH_LIMIT | COMT_AUTH_LIMIT | WERTV8 | CURR | 15 | 2 | Payment Cards: Maximum Amount of Value to be Authorized | ||
11 | AUTH_LIMITED | COMT_AUTH_LIMITED | XFELD | CHAR | 1 | 0 | Payment Cards: Limited Value | ||
12 | AUTH_STATUS | CHAR2 | CHAR2 | CHAR | 2 | 0 | Version Number Component | ||
13 | CURRENCY | COMT_PAYPLAN_CURRENCY | WAERS | CUKY | 5 | 0 | Currency in Payment Plan | * | |
14 | PAYM_SRV_PROV | COM_WEC_PAYMENT_SRV_PROVIDER | COM_WEC_PAYMENT_SRV_PROVIDER | CHAR | 4 | 0 | Payment Service Provider | * | |
15 | PAYM_SRV_PROV_DESC | COM_WEC_PSP_DESCRIPTION | COM_WEC_PSP_DESCRIPTION | CHAR | 40 | 0 | Description of Payment Service Provider | ||
16 | PAYM_TRANS_GUID | COM_WEC_TRANSACTION_GUID | COM_WEC_TRANSACTION_GUID | RAW | 16 | 0 | Payment Transaction Reference GUID | ||
17 | PSP_STATUS | COM_WEC_TRANSACTION_STATUS | COM_WEC_TRANSACTION_STATUS | CHAR | 4 | 0 | Payment Transaction Status | * | |
18 | PSP_STATUS_PF | COM_WEC_TRANSACTION_PROFILE | COM_WEC_TRANSACTION_PROFILE | CHAR | 4 | 0 | Payment Status Profile | * | |
19 | PSP_TRANS_AMT | COM_WEC_TRANSACTION_AMOUNT | WERTV8 | CURR | 15 | 2 | Payment Transaction Amount | ||
20 | PSP_TRANS_CURR | COM_WEC_TRANSACTION_CURRENCY | WAERS | CUKY | 5 | 0 | Payment Transaction Currency | * | |
21 | PSP_TRANS_CURR_ISO | ISOCD | ISOCD | CHAR | 3 | 0 | ISO currency code | ||
22 | PSP_TRANS_ID | COM_WEC_PSP_TRANSACTION_ID | COM_WEC_PSP_TRANSACTION_ID | CHAR | 35 | 0 | ID of the Payment Transaction in the PSP System |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMS_WEC_ORDER_PAYMENT | CARD_TYPE | TB033 | CCINS |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |