SAP ABAP Table LOYS_PT_TXN_RES_ATTR_AC (Point Transaction Archive Search Result Structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY-PA (Application Component) Point Account
⤷ LOY_POINT_ACCOUNT (Package) Loyalty management Point Account
⤷ CRM-LOY-PA (Application Component) Point Account
⤷ LOY_POINT_ACCOUNT (Package) Loyalty management Point Account
Basic Data
Table Category | INTTAB | Structure |
Structure | LOYS_PT_TXN_RES_ATTR_AC | Table Relationship Diagram |
Short Description | Point Transaction Archive Search Result Structure |
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 | Structure for point Account transaction | |||||
2 | .INCLUDE | 0 | 0 | Loyalty Management Point Account Transaction. | |||||
3 | .INCLUDE | 0 | 0 | LOY FRW : Primary key Include | |||||
4 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
6 | .INCLUDE | 0 | 0 | LOY FRW : Non-Key Framework Include | |||||
7 | REF_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
8 | APPLICATION | LOY_FRW_APPLICATION | LOY_FRW_APPLICATION | CHAR | 4 | 0 | Application | ||
9 | PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
10 | MEMBERSHIP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MSH_MEMS | |
11 | ACTIVITY_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MA_GENATTR | |
12 | MEMBER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MEM_MEMBER | |
13 | TXN_TYPE | LOY_PT_TXN_TYPE | LOY_PTTXNTYPE | CHAR | 4 | 0 | Loyalty Point Transaction Type | ||
14 | TXN_REASON | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
15 | PT_TYPE | LOY_PT_TYPE | LOY_PT_TYPE | CHAR | 20 | 0 | Point Type | ||
16 | QUAL_TYPE | LOY_PT_QUAL_TYPE | LOY_PTQUALTYPE | CHAR | 20 | 0 | Point Qualification Type | ||
17 | POINTS | LOY_PT_POINT | DEC | 10 | 2 | Number of Points | |||
18 | POSTING_DATE | LOY_PT_TXN_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Storing Time Stamp | ||
19 | EXPIRY_DATE | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
20 | CARD_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
21 | PARTNER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
22 | REFERENCE | LOY_PT_TXN_REF | CHAR | 100 | 0 | Loyalty Point Transaction Reference | |||
23 | CAMPAIGN_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
24 | REWARD_RULE_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
25 | ACTUAL_POINTS | LOY_PT_POINT | DEC | 10 | 2 | Number of Points | |||
26 | .INCLUDE | 0 | 0 | Extensibility Include Structure for point transactions | |||||
27 | PT_TXN_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
28 | .INCLUDE | 0 | 0 | ||||||
29 | PSH_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
30 | PARTNER_TIER | LOY_PSH_PARTNER_TIER | CRM_LOY_PSH_PARTNER_TIER | CHAR | 20 | 0 | Partner Tier | ||
31 | ACCOUNT_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
32 | .INCLUDE | 0 | 0 | LOY FRW : Administrative Include | |||||
33 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
34 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
35 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
36 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
37 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
38 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
39 | QUAL_POINTS | LOY_PT_POINT | DEC | 10 | 2 | Number of Points | |||
40 | .INCLUDE | 0 | 0 | LOY FRW : Actions Include | |||||
41 | PROCESS_MODE | LOY_FRW_MODE | LOY_FRW_MODE | CHAR | 1 | 0 | Mode | ||
42 | .INCLUDE | 0 | 0 | Structure to fill ID for Point Account transactions | |||||
43 | MEMBERSHIP_ID | LOY_MEMS_ID | LOY_MEMS_ID | CHAR | 10 | 0 | Membership ID | ||
44 | ACTIVITY_ID | LOY_MA_ACT_ID | LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
45 | CARD_ID | LOY_CRD_CARD_ID | LOY_CRD_CARD_ID | CHAR | 16 | 0 | Card ID | ||
46 | MEMBER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
47 | TXN_TYPE_DESC | LOY_MA_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Member Activity Description | ||
48 | TXN_REASON_DESC | LOY_MA_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Member Activity Description | ||
49 | QUAL_TYPE_DESC | LOY_MA_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Member Activity Description | ||
50 | REWARD_RULE_ID | LOY_EXTERNAL_ID | CGPL_EXTID | CHAR | 24 | 0 | Generic External ID | ||
51 | POSTING_DATE_ALT | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
52 | PSH_ID | LOY_PSH_ID | LOY_PSH_ID | CHAR | 10 | 0 | Partnership ID | ||
53 | ACCOUNT_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
54 | .INCLUDE | 0 | 0 | LOY FRW: Archive Include for Archive Search Result Structure | |||||
55 | ARCHIVEKEY | ARKEY | ARKEY | CHAR | 20 | 0 | Key for Archive File | ||
56 | ARCHIVEOFS | ADMI_OFFST | INT4 | 10 | 0 | Archive file data object offset | |||
57 | OBJECT_KEY | STRG | 0 | 0 | |||||
58 | PARTNER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
59 | POINT_ACCOUNT_ID | LOY_PT_ACCT_ID | LOY_PT_ACCT_OBJECT_ID | CHAR | 18 | 0 | Loyalty Management Point Account ID | ||
60 | PT_TYPE_DESC | CRMT_MKTPL_LOY_POINT_NAME | CRM_MKTPL_LOY_POINT_NAME | CHAR | 20 | 0 | Description of Point | ||
61 | PARTNER_NAME | CHAR80 | CHAR80 | CHAR | 80 | 0 | Char 80 | ||
62 | MEMBER_NAME | CHAR80 | CHAR80 | CHAR | 80 | 0 | Char 80 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LOYS_PT_TXN_RES_ATTR_AC | ACTIVITY_GUID | LOYD_MA_GENATTR | CLIENT | 1 | CN | |
2 | LOYS_PT_TXN_RES_ATTR_AC | MEMBERSHIP_GUID | LOYD_MSH_MEMS | CLIENT | 1 | CN | |
3 | LOYS_PT_TXN_RES_ATTR_AC | MEMBER_GUID | LOYD_MEM_MEMBER | CLIENT | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |