SAP ABAP View LOYV_PPA_TXN_BI (Loyallty Partner Point Transactions: Data Selection View)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY (Application Component) Loyalty
⤷ LOY_BI (Package) Loyalty BI objects
⤷ CRM-LOY (Application Component) Loyalty
⤷ LOY_BI (Package) Loyalty BI objects
Basic Data
View Type | D | Database View |
Database View | LOYV_PPA_TXN_BI | |
Short Description | Loyallty Partner Point Transactions: Data Selection View | |
Root table | LOYD_PPA_TXN | Loyalty Management Partner Point Account Transaction. |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | LOYD_PPA_TXN | LOYD_PPA_TXN | ||
2 | LOYD_PPA | |||
3 | LOYD_PPA_SET |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | LOYD_PPA_TXN | CLIENT | JL | EQ | 0 | 0 | ||||
2 | LOYD_PPA | CLIENT | JR | EQ | AND | 0 | 0 | |||
3 | LOYD_PPA | CLIENT | JL | EQ | 0 | 0 | ||||
4 | LOYD_PPA_SET | CLIENT | JR | EQ | AND | 0 | 0 | |||
5 | LOYD_PPA_TXN | REF_GUID | JL | EQ | 0 | 0 | ||||
6 | LOYD_PPA | GUID | JR | EQ | AND | 0 | 0 | |||
7 | LOYD_PPA | REF_GUID | JL | EQ | 0 | 0 | ||||
8 | LOYD_PPA_SET | GUID | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | * | LOYD_PPA_TXN | * | |||||
2 | CLIENT | LOYD_PPA_TXN | CLIENT | MANDT | Client | |||
3 | - | LOYD_PPA_TXN | OBJECT_ID | LOY_PPA_ACCT_SET_ID | Loyalty Management Partner Point Account Set ID | |||
4 | REF_GUID | LOYD_PPA_TXN | REF_GUID | LOY_FRW_GUID | Object GUID | |||
5 | - | LOYD_PPA_TXN | APPLICATION | LOY_FRW_APPLICATION | Application | |||
6 | - | LOYD_PPA_TXN | PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | Process Type | |||
7 | - | LOYD_PPA_TXN | ACTIVITY_GUID | LOY_FRW_GUID | Object GUID | |||
8 | PT_TYPE | LOYD_PPA_TXN | PT_TYPE | LOY_PPA_TYPE | Loyalty Management Partner Point Type | |||
9 | POINTS | LOYD_PPA_TXN | POINTS | LOY_PPA_POINT | Loyalty Management Partner Point Account Number of Points | |||
10 | POSTING_DATE | LOYD_PPA_TXN | POSTING_DATE | LOY_PPA_TXN_TIMESTAMP | Loyalty Management Partner Point Transaction Time Stamp | |||
11 | - | LOYD_PPA_TXN | PARTNER_GUID | LOY_FRW_GUID | Object GUID | |||
12 | - | LOYD_PPA_TXN | REFERENCE | LOY_PPA_TXN_REF | Loyalty Management Partner Point Transaction Reference | |||
13 | PSH_GUID | LOYD_PPA_TXN | PSH_GUID | LOY_FRW_GUID | Object GUID | |||
14 | - | LOYD_PPA_TXN | PARTNER_TIER | LOY_PSH_PARTNER_TIER | Partner Tier | |||
15 | PPA_TXN_DUMMY | LOYD_PPA_TXN | PPA_TXN_DUMMY | DUMMY | Dummy function in length 1 | |||
16 | - | LOYD_PPA_TXN | CREATED_ON | LOY_FRW_CREATED_ON | Created On - OBSOLETE !!! | |||
17 | - | LOYD_PPA_TXN | CREATED_BY | LOY_FRW_CREATED_BY | Created By | |||
18 | CREATED_AT | LOYD_PPA_TXN | CREATED_AT | LOY_FRW_CREATED_AT | Created At (Output in User Time Zone) | |||
19 | - | LOYD_PPA_TXN | CHANGED_ON | LOY_FRW_CHANGED_ON | Changed On - OBSOLETE !!! | |||
20 | - | LOYD_PPA_TXN | CHANGED_BY | LOY_FRW_CHANGED_BY | Changed By | |||
21 | CHANGED_AT | LOYD_PPA_TXN | CHANGED_AT | LOY_FRW_CHANGED_AT | Changed At (Output in User Time Zone) | |||
22 | PT_TXN_GUID | LOYD_PPA_TXN | PT_TXN_GUID | LOY_FRW_GUID | Object GUID | |||
23 | PPA_TXN_GUID | LOYD_PPA_TXN | GUID | LOY_FRW_GUID | Object GUID | |||
24 | PPA_ID | LOYD_PPA | OBJECT_ID | LOY_PT_ACCT_ID | Loyalty Management Point Account ID | |||
25 | MEMBER_GUID | LOYD_PPA_TXN | MEMBER_GUID | LOY_FRW_GUID | Object GUID | |||
26 | PPA_TXN_TYPE | LOYD_PPA_TXN | PPA_TXN_TYPE | LOY_PPA_TXN_TYPE | Loyalty Management Partner Point Transaction Type | |||
27 | PPA_TXN_RSN | LOYD_PPA_TXN | PPA_TXN_RSN | LOY_PPA_TXN_RSN | Loyalty Management Partner Point Transaction Reason | |||
28 | LOY_CAMP_GUID | LOYD_PPA_TXN | CAMPAIGN_GUID | LOY_FRW_GUID | Object GUID | |||
29 | MSH_GUID | LOYD_PPA_TXN | MEMBERSHIP_GUID | LOY_FRW_GUID | Object GUID | |||
30 | LOY_PROG_GUID | LOYD_PPA_SET | PROGRAM_GUID | CGPL_PROJECT_GUID | Project Planning: 16 Character GUID for Projects | |||
31 | LOY_RRL_GUID | LOYD_PPA_TXN | REWARD_RULE_GUID | LOY_FRW_GUID | Object GUID | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |