SAP ABAP Table CRMS_LOY_PT_TXN_ALT (Point account txn with posting date field not a timestamp)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MKT (Application Component) Marketing
⤷ CRM_LOY_POINT_ACCOUNT_GENIL (Package) Genil Package for point account
⤷ CRM-MKT (Application Component) Marketing
⤷ CRM_LOY_POINT_ACCOUNT_GENIL (Package) Genil Package for point account
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMS_LOY_PT_TXN_ALT | Table Relationship Diagram |
Short Description | Point account txn with posting date field not a timestamp |
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 | .INCLUDE | 0 | 0 | LOY : Loyalty Key Structure | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
4 | .INCLUDE | 0 | 0 | LOY : Loyalty Object Strucure | |||||
5 | REF_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
6 | APPLICATION | CRM_LOY_COM_APPLICATION | CRM_LOY_COM_APPLICATION | CHAR | 4 | 0 | LOY : Application | ||
7 | PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
8 | MEMBERSHIP_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
9 | ACTIVITY_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
10 | MEMBER_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
11 | TXN_TYPE | CRM_LOY_PT_TXN_TYPE | CRM_LOY_PTTXNTYPE | CHAR | 4 | 0 | Loyalty Point Transaction Type | ||
12 | TXN_REASON | CRM_LOY_COM_PROCESS_TYPE | CRM_LOY_COM_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
13 | PT_TYPE | CRM_LOY_PT_TYPE | CHAR | 20 | 0 | Loyalty Management Point Type | |||
14 | QUAL_TYPE | CRM_LOY_PT_QUAL_TYPE | CHAR | 20 | 0 | Loyalty Point Qualification Type | |||
15 | POINTS | CRM_LOY_PT_POINT | DEC | 10 | 2 | Loyalty Point | |||
16 | POSTING_DATE | CRM_LOY_COM_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Data element for time stamp | ||
17 | EXPIRY_DATE | CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! | ||
18 | CARD_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
19 | PARTNER_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
20 | REFERENCE | CRM_LOY_PT_TXN_REF | CHAR | 100 | 0 | Loyalty Point Transaction Reference | |||
21 | CAMPAIGN_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
22 | REWARD_RULE_GUID | CRM_LOY_COM_GUID | SYSUUID | RAW | 16 | 0 | LOY : CRM Loyalty GUID | ||
23 | ACTUAL_POINTS | CRM_LOY_PT_POINT | DEC | 10 | 2 | Loyalty Point | |||
24 | .INCLUDE | 0 | 0 | Extensibility Include Structure for point transactions | |||||
25 | PT_TXN_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
26 | .INCLUDE | 0 | 0 | ||||||
27 | .INCLUDE | 0 | 0 | LOY : Loaylty Action Structure | |||||
28 | PROCESS_MODE | CRM_LOY_COM_MODE | CRM_LOY_COM_MODE | CHAR | 1 | 0 | LOY: Loyalty Mode | ||
29 | .INCLUDE | 0 | 0 | Structure to fill ID for point account transactions | |||||
30 | MEMBERSHIP_ID | CRM_LOY_MEMS_ID | CRM_LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
31 | ACTIVITY_ID | CRM_LOY_MA_ACT_ID | CRM_LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
32 | CARD_ID | CRM_CRD_CARD_ID | CRM_CRD_CARD_ID | CHAR | 16 | 0 | Card ID | ||
33 | MEMBER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
34 | TXN_TYPE_DESC | CRM_LOY_COM_DESCRIPTION | CRM_LOY_COM_DESCRIPTION | CHAR | 40 | 0 | LOY: Description | ||
35 | TXN_REASON_DESC | CRM_LOY_COM_DESCRIPTION | CRM_LOY_COM_DESCRIPTION | CHAR | 40 | 0 | LOY: Description | ||
36 | QUAL_TYPE_DESC | CRM_LOY_COM_DESCRIPTION | CRM_LOY_COM_DESCRIPTION | CHAR | 40 | 0 | LOY: Description | ||
37 | REWARD_RULE_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
38 | QUAL_POINTS | CRM_LOY_PT_POINT | DEC | 10 | 2 | Loyalty Point | |||
39 | POSTING_DATE_ALT | CRM_LOY_COM_CREATED_ON | SYDATS | DATS | 8 | 0 | LOY : Created On - OBSOLETE !!! |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 700 |