SAP ABAP Table LOYS_MA_GEN_ATTR (struture for 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 | INTTAB | Structure |
Structure | LOYS_MA_GEN_ATTR | Table Relationship Diagram |
Short Description | struture for member activity generic attributes |
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 | Table to store member activity generic attributes | |||||
2 | .INCLUDE | 0 | 0 | LOY FRW : Primary key Include | |||||
3 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
4 | GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
5 | .INCLUDE | 0 | 0 | LOY FRW : Non-Key Framework Include | |||||
6 | REF_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
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 | .INCLUDE | 0 | 0 | Struture for member activity generic attributes | |||||
10 | OBJECT_ID | LOY_MA_ACT_ID | LOY_MA_ACTID | CHAR | 10 | 0 | Member Activity ID | ||
11 | MEMBERSHIP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MSH_MEMS | |
12 | IS_SHARE_PT_ACCT | LOY_MA_BOOLEAN | LOY_MA_BOOLEAN | CHAR | 1 | 0 | Type Boolean | ||
13 | MEMBER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_MEM_MEMBER | |
14 | PROGRAM_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
15 | CARD_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | LOYD_CRD_CARD | |
16 | CATEGORY | LOY_MA_CAT_ID | LOY_MA_CAT_ID | CHAR | 30 | 0 | Member Activity Category ID | LOYC_MA_CAT | |
17 | .INCLUDE | 0 | 0 | Structure for status in loyalty | |||||
18 | ISTAT | LOY_FRW_JISTAT | J_ISTAT | CHAR | 5 | 0 | Element for System Status | * | |
19 | ESTAT | LOY_FRW_JESTAT | J_ESTAT | CHAR | 5 | 0 | User Status | * | |
20 | PARTNER_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
21 | ACTIVITY_DATE | LOY_MA_TIMESTAMP | BCOS_TSTMP | DEC | 15 | 0 | Storing Time Stamp | ||
22 | ACTIVITY_TZ | LOY_MA_TIMEZONE | TZNZONE | CHAR | 6 | 0 | Member Activity Timezone | * | |
23 | PT_ACCT_SET_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
24 | ERR_CODE | LOY_MA_ERR_CODE | LOY_MA_ERR_CODE | CHAR | 12 | 0 | Twelve Character Error Code | ||
25 | .INCLUDE | 0 | 0 | LOY FRW : Administrative Include | |||||
26 | CREATED_ON | LOY_FRW_CREATED_ON | SYDATS | DATS | 8 | 0 | Created On - OBSOLETE !!! | ||
27 | CREATED_BY | LOY_FRW_CREATED_BY | UNAME | CHAR | 12 | 0 | Created By | ||
28 | CREATED_AT | LOY_FRW_CREATED_AT | LOY_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
29 | CHANGED_ON | LOY_FRW_CHANGED_ON | SYDATS | DATS | 8 | 0 | Changed On - OBSOLETE !!! | ||
30 | CHANGED_BY | LOY_FRW_CHANGED_BY | UNAME | CHAR | 12 | 0 | Changed By | ||
31 | CHANGED_AT | LOY_FRW_CHANGED_AT | LOY_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
32 | .INCLUDE | 0 | 0 | Extensibility Include Structure for Member Activity Generic | |||||
33 | MAGENATTR_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
34 | .INCLUDE | 0 | 0 | ||||||
35 | .INCLUDE | 0 | 0 | Partnership Attribute Include | |||||
36 | PARTNERSHIP_GUID | LOY_FRW_GUID | SYSUUID | RAW | 16 | 0 | Object GUID | ||
37 | PARTNSHIP_EXT_ID | LOY_MA_PART_EXT_ID | LOY_MA_PARTNER_ID | CHAR | 10 | 0 | MEMBER ACTIVITY PARTNERSHIP EXTERNAL ID | ||
38 | PARSHIP_EXT_DES | LOY_MA_PART_EXT_DESC | LOY_MA_PARTNER_DESC | CHAR | 50 | 0 | Member Activity External Partner Description | ||
39 | .INCLUDE | 0 | 0 | Structure to only create Partnership ID and Description | |||||
40 | PARTNERSHIP_ID | LOY_PSH_ID | LOY_PSH_ID | CHAR | 10 | 0 | Partnership ID | ||
41 | PARTNERSHIP_DESC | LOY_PSH_EXT_REF | LOY_PSH_EXT_REF | CHAR | 40 | 0 | Partnership External Reference | ||
42 | .INCLUDE | 0 | 0 | LOY FRW : Actions Include | |||||
43 | PROCESS_MODE | LOY_FRW_MODE | LOY_FRW_MODE | CHAR | 1 | 0 | Mode | ||
44 | .INCLUDE | 0 | 0 | Structure for MA generic attribute IDs | |||||
45 | MEMBERSHIP_ID | LOY_MA_MEMBERSHIP_ID | LOY_MA_MEMBERSHIP_ID | CHAR | 10 | 0 | Membership ID | ||
46 | MEMBER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
47 | PROGRAM_ID | CGPL_EXTID | CGPL_EXTID | CHAR | 24 | 0 | Project Planning: External Indentifier of an Element | ||
48 | CARD_ID | LOY_CRD_CARD_ID | LOY_CRD_CARD_ID | CHAR | 16 | 0 | Card ID | ||
49 | PROGRAM_DESC | CHAR | 40 | 0 | |||||
50 | PARTNER_DESC | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
51 | PARTNER_ID | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
52 | MEMBER_DESC | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
53 | SHORT_ERR_CODE | LOY_MA_SHORT_CODE | LOY_MA_SHORT_CODE | CHAR | 20 | 0 | Short Code | ||
54 | SHORT_ERR_DESC | LOY_ERR_CODE_DESCR | LOYM_ERR_CODE_DESCR | CHAR | 255 | 0 | Error Code Description | ||
55 | EXTERNAL_CARD_NU | LOY_CRD_CARD_EXT_ID | LOY_CRD_CARD_EXT_ID | CHAR | 25 | 0 | External Card ID | ||
56 | .INCLUDE | 0 | 0 | Extensibility Include Struct for Member Activity Generic IDs | |||||
57 | MAGENATTR_ID_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
58 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LOYS_MA_GEN_ATTR | CARD_GUID | LOYD_CRD_CARD | CLIENT | 1 | CN | |
2 | LOYS_MA_GEN_ATTR | CATEGORY | LOYC_MA_CAT | CAT_ID | 1 | CN | |
3 | LOYS_MA_GEN_ATTR | MEMBERSHIP_GUID | LOYD_MSH_MEMS | CLIENT | 1 | CN | |
4 | LOYS_MA_GEN_ATTR | MEMBER_GUID | LOYD_MEM_MEMBER | CLIENT | 1 | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |