SAP ABAP Table LOYD_PPA_TXN (Loyalty Management Partner Point Account Transaction.)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY (Application Component) Loyalty
⤷ LOY_PPA_DB (Package) Loyalty Management Partner Point Acount DDIC
⤷ CRM-LOY (Application Component) Loyalty
⤷ LOY_PPA_DB (Package) Loyalty Management Partner Point Acount DDIC
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | LOYD_PPA_TXN | Table Relationship Diagram |
Short Description | Loyalty Management Partner Point Account Transaction. |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | LOY FRW : Primary key Include | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
4 | OBJECT_ID | LOY_PPA_ACCT_SET_ID | LOY_PT_OBJECT_ID | CHAR | 15 | 0 | Loyalty Management Partner Point Account Set ID | ||
5 | .INCLUDE | 0 | 0 | LOY FRW : Non-Key Framework Include | |||||
6 | REF_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_PPA | |
7 | APPLICATION | LOY_FRW_APPLICATION | LOY_FRW_APPLICATION | CHAR | 4 | 0 | Application | ||
8 | PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
9 | ACTIVITY_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MA_GENATTR | |
10 | MEMBER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
11 | PPA_TXN_TYPE | LOY_PPA_TXN_TYPE | LOY_PPA_PTTXNTYPE | CHAR | 4 | 0 | Loyalty Management Partner Point Transaction Type | ||
12 | PPA_TXN_RSN | LOY_PPA_TXN_RSN | CHAR | 15 | 0 | Loyalty Management Partner Point Transaction Reason | |||
13 | PT_TYPE | LOY_PPA_TYPE | LOY_POINT_CODE | CHAR | 10 | 0 | Loyalty Management Partner Point Type | ||
14 | POINTS | LOY_PPA_POINT | DEC | 10 | 2 | Loyalty Management Partner Point Account Number of Points | |||
15 | POSTING_DATE | LOY_PPA_TXN_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Loyalty Management Partner Point Transaction Time Stamp | ||
16 | PARTNER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
17 | REFERENCE | LOY_PPA_TXN_REF | CHAR | 100 | 0 | Loyalty Management Partner Point Transaction Reference | |||
18 | CAMPAIGN_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
19 | REWARD_RULE_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
20 | PSH_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_PSH | |
21 | PARTNER_TIER | LOY_PSH_PARTNER_TIER | CRM_LOY_PSH_PARTNER_TIER | CHAR | 20 | 0 | Partner Tier | ||
22 | MEMBERSHIP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MSH_MEMS | |
23 | .INCLUDE | 0 | 0 | Extensibility Include for Partner Point Transaction | |||||
24 | PPA_TXN_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
25 | .INCLUDE | 0 | 0 | ||||||
26 | .INCLUDE | 0 | 0 | LOY FRW : Administrative Include | |||||
27 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
28 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
29 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
30 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
31 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
32 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
33 | PT_TXN_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LOYD_PPA_TXN | ACTIVITY_GUID | LOYD_MA_GENATTR | CLIENT | KEY | ||
2 | LOYD_PPA_TXN | MEMBERSHIP_GUID | LOYD_MSH_MEMS | CLIENT | KEY | ||
3 | LOYD_PPA_TXN | PSH_GUID | LOYD_PSH | CLIENT | KEY | ||
4 | LOYD_PPA_TXN | REF_GUID | LOYD_PPA | CLIENT | KEY |
History
Last changed by/on | SAP | 20100421 |
SAP Release Created in | 701 |