SAP ABAP Table LOYD_MA_GENATTR (Table to store member activity generic attributes)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-LOY-MA (Application Component) Member Activity
⤷ LOY_MEMBER_ACTIVITY_DB (Package) Loyalty Member Activity
⤷ CRM-LOY-MA (Application Component) Member Activity
⤷ LOY_MEMBER_ACTIVITY_DB (Package) Loyalty Member Activity
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | LOYD_MA_GENATTR | Table Relationship Diagram |
Short Description | Table to store member activity generic attributes |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 FRW : Primary key Include | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
4 | .INCLUDE | 0 | 0 | LOY FRW : Non-Key Framework Include | |||||
5 | REF_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
6 | APPLICATION | LOY_FRW_APPLICATION | LOY_FRW_APPLICATION | CHAR | 4 | 0 | Application | ||
7 | PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE | CHAR | 15 | 0 | Process Type | ||
8 | .INCLUDE | 0 | 0 | Struture for member activity generic attributes | |||||
9 | OBJECT_ID | LOY_MA_ACT_ID | LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
10 | MEMBERSHIP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MSH_MEMS | |
11 | IS_SHARE_PT_ACCT | LOY_MA_BOOLEAN | LOY_MA_BOOLEAN | CHAR | 1 | 0 | Type Boolean | ||
12 | MEMBER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MEM_MEMBER | |
13 | PROGRAM_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
14 | CARD_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_CRD_CARD | |
15 | CATEGORY | LOY_MA_CAT_ID | LOY_MA_CAT_ID | CHAR | 30 | 0 | Member Activity Category ID | LOYC_MA_CAT | |
16 | .INCLUDE | 0 | 0 | Structure for status in loyalty | |||||
17 | ISTAT | LOY_FRW_JISTAT | J_ISTAT | CHAR | 5 | 0 | Element for System Status | * | |
18 | ESTAT | LOY_FRW_JESTAT | J_ESTAT | CHAR | 5 | 0 | User Status | * | |
19 | PARTNER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
20 | ACTIVITY_DATE | LOY_MA_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Storing Time Stamp | ||
21 | ACTIVITY_TZ | LOY_MA_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Member Activity Timezone | * | |
22 | PT_ACCT_SET_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
23 | ERR_CODE | LOY_MA_ERR_CODE | LOY_MA_ERR_CODE | CHAR | 12 | 0 | Twelve Character Error Code | ||
24 | .INCLUDE | 0 | 0 | LOY FRW : Administrative Include | |||||
25 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
26 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
27 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
28 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
29 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
30 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
31 | .INCLUDE | 0 | 0 | Extensibility Include Structure for Member Activity Generic | |||||
32 | MAGENATTR_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
33 | .INCLUDE | 0 | 0 | ||||||
34 | .INCLUDE | 0 | 0 | Partnership Attribute Include | |||||
35 | PARTNERSHIP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
36 | PARTNSHIP_EXT_ID | LOY_MA_PART_EXT_ID | LOY_MA_PARTNER_ID | CHAR | 10 | 0 | MEMBER ACTIVITY PARTNERSHIP EXTERNAL ID | ||
37 | PARSHIP_EXT_DES | LOY_MA_PART_EXT_DESC | LOY_MA_PARTNER_DESC | CHAR | 50 | 0 | Member Activity External Partner Description |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LOYD_MA_GENATTR | CARD_GUID | LOYD_CRD_CARD | CLIENT | 1 | CN | |
2 | LOYD_MA_GENATTR | CATEGORY | LOYC_MA_CAT | CAT_ID | 1 | CN | |
3 | LOYD_MA_GENATTR | MEMBERSHIP_GUID | LOYD_MSH_MEMS | CLIENT | 1 | CN | |
4 | LOYD_MA_GENATTR | MEMBER_GUID | LOYD_MEM_MEMBER | CLIENT | 1 | CN |
History
Last changed by/on | SAP | 20100420 |
SAP Release Created in | 700 |