SAP ABAP View CRMDV_SO_LOY_PNT (Database view for loyatly points)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-LOY-BTX-SLO (Application Component) Loyalty Sales Transaction
     CRM_LOY_SO_INTEG (Package) Loyalty Integration with Sales Order
Basic Data
View Type D Database View 
Database View CRMDV_SO_LOY_PNT  
Short Description Database view for loyatly points    
Root table CRMC_SO_LOY_PNT   Loyalty Management Point Type Table 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRMC_SO_LOY_PNT CRMC_SO_LOY_PNT
2 CRMC_SO_LOY_PNTT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CRMC_SO_LOY_PNT CLIENT JL EQ 0 0
2 CRMC_SO_LOY_PNTT CLIENT JR EQ AND 0 0
3 CRMC_SO_LOY_PNT POINT_CODE JL EQ 0 0
4 CRMC_SO_LOY_PNTT POINT_CODE JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CRMC_SO_LOY_PNT CLIENT   MANDT Client
2 POINT_CODE CRMC_SO_LOY_PNT POINT_CODE   CRMT_MKTPL_LOY_POINT_CODE ID of Point Type
3 LANGUAGE CRMC_SO_LOY_PNTT LANGUAGE   SYLANGU Language Key
4 POINT_NAME CRMC_SO_LOY_PNTT POINT_NAME   CRMT_MKTPL_LOY_POINT_NAME Description of Point
5 CONVERSION_FACT CRMC_SO_LOY_PNT CONVERSION_FACT   CRMT_MKTPL_LOY_POINT_CF Conversion Factor for Loyalty Points
6 EXPIRE_PROC_ID CRMC_SO_LOY_PNT EXPIRE_PROC_ID   CRM_MKTPL_LOY_DATE_RULE_CODE ID of Date Calculation Procedure
7 STATUS CRMC_SO_LOY_PNT STATUS   CRMT_MKTPL_LOY_POINT_STATUS Status
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700