LOYD_PT_TXN is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of LOYD_PT_TXN in SAP.
- Table description : Loyalty Management Point Account Transaction.
- Module : CRM-LOY-PA
- Parent Module : CRM
- Package : LOY_POINT_ACCOUNT
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP LOYD_PT_TXN Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| .INCLUDE | LOY FRW : Primary key Include | ||
| CLIENT | Client | MANDT | MANDT |
| GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| .INCLUDE | LOY FRW : Non-Key Framework Include | ||
| REF_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| APPLICATION | Application | LOY_FRW_APPLICATION | LOY_FRW_APPLICATION |
| PROCESS_TYPE | Process Type | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE |
| MEMBERSHIP_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| ACTIVITY_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| MEMBER_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| TXN_TYPE | Loyalty Point Transaction Type | LOY_PT_TXN_TYPE | LOY_PTTXNTYPE |
| TXN_REASON | Process Type | LOY_FRW_PROCESS_TYPE | LOY_FRW_PROCESS_TYPE |
| PT_TYPE | Point Type | LOY_PT_TYPE | LOY_PT_TYPE |
| QUAL_TYPE | Point Qualification Type | LOY_PT_QUAL_TYPE | LOY_PTQUALTYPE |
| POINTS | Number of Points | LOY_PT_POINT | |
| POSTING_DATE | Storing Time Stamp | LOY_PT_TXN_TIMESTAMP | BCOS_TSTMP |
| EXPIRY_DATE | Created On - OBSOLETE !!! | LOY_FRW_CREATED_ON | SYDATS |
| CARD_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| PARTNER_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| REFERENCE | Loyalty Point Transaction Reference | LOY_PT_TXN_REF | |
| CAMPAIGN_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| REWARD_RULE_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| ACTUAL_POINTS | Number of Points | LOY_PT_POINT | |
| .INCLUDE | Extensibility Include Structure for point transactions | ||
| PT_TXN_DUMMY | Dummy function in length 1 | DUMMY | DUMMY |
| .INCLUDE | |||
| PSH_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| PARTNER_TIER | Partner Tier | LOY_PSH_PARTNER_TIER | CRM_LOY_PSH_PARTNER_TIER |
| ACCOUNT_GUID | Object GUID | LOY_FRW_GUID | SYSUUID |
| .INCLUDE | LOY FRW : Administrative Include | ||
| CREATED_ON | Created On - OBSOLETE !!! | LOY_FRW_CREATED_ON | SYDATS |
| CREATED_BY | Created By | LOY_FRW_CREATED_BY | UNAME |
| CREATED_AT | Created At (Output in User Time Zone) | LOY_FRW_CREATED_AT | LOY_TSTMP |
| CHANGED_ON | Changed On - OBSOLETE !!! | LOY_FRW_CHANGED_ON | SYDATS |
| CHANGED_BY | Changed By | LOY_FRW_CHANGED_BY | UNAME |
| CHANGED_AT | Changed At (Output in User Time Zone) | LOY_FRW_CHANGED_AT | LOY_TSTMP |
| QUAL_POINTS | Number of Points | LOY_PT_POINT |
LOYD_PT_TXN related tables
| Table | Note |
|---|---|
| LOYD_PPA_TXN | Loyalty Management Partner Point Account Transaction. |
| LOYD_PT_TXN | Loyalty Management Point Account Transaction. |
| LOYD_PPA | Loyalty Management Partner Point Account |
| LOYD_PPA_SET | Loyalty Management Partner Point Account Set |
| LOYD_PT_ACCT | Loyalty management Point Account |
| LOYD_PT_ACCT_SET | Loyalty Management Point Account Set |
| LOY_LOG_CLST_TXN | Loyalty Management Partner Point Transaction Log |
| CRMC_LOY_POINT | Loyalty Management Point Type Table |
| CRMC_LOY_POINT_T | Loyalty Management Point Type Text Table |
| CRMC_SO_LOY_PNT | Loyalty Management Point Type Table |
| CRMC_SO_LOY_PNTT | Loyalty Management Point Type Text Table |
| CRMC_LPE_RO_PTPA | For Point Account # Point Type RO |
| CRMC_POINT_PROFT | Loyalty Point type profile |
| CRMC_TIERPOINT | Loyalty Mgmt Point Expiration Procedure Override |
| CRM_ACE2_PA_ACL | Point Accounts: Loyalty Access Control List |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP