SAP ABAP View CRM_GIFTCARDV (Gift Card Products)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BF-GC (Application Component) Gift Certificate Management
     CRM_ORDER_GIFT_CERT (Package) Gift Card Modelling: Set type for GC
Basic Data
View Type D Database View 
Database View CRM_GIFTCARDV  
Short Description Gift Card Products    
Root table CRM_GIFTCARD   Gift Card Products 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRM_GIFTCARD CRM_GIFTCARD
2 COMM_PR_FRG_ROD  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CRM_GIFTCARD FRG_GUID JL EQ 0 0
2 COMM_PR_FRG_ROD FRAGMENT_GUID JR EQ AND 0 0
3 CRM_GIFTCARD CLIENT JL EQ 0 0
4 COMM_PR_FRG_ROD CLIENT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT CRM_GIFTCARD CLIENT   MANDT Client
2 FRG_GUID CRM_GIFTCARD FRG_GUID   COMT_FRG_GUID Set GUID
3 VALID_FROM CRM_GIFTCARD VALID_FROM   COMT_VALID_FROM Valid From (Time Stamp)
4 VALID_TO CRM_GIFTCARD VALID_TO   COMT_VALID_TO Valid To (Time Stamp)
5 UPNAME CRM_GIFTCARD UPNAME   COMT_UPNAME Name of the User Who Last Changed the Set
6 HISTEX CRM_GIFTCARD HISTEX   COMT_HISTEX History Exists
7 LOGSYS CRM_GIFTCARD LOGSYS   COMT_LOGSYS Original System
8 SALES_ORG COMM_PR_FRG_ROD SALES_ORG   CRMT_SALES_ORG Sales Organization ID
9 DISTR_CHAN COMM_PR_FRG_ROD DISTR_CHAN   CRMT_DISTRIBUTION_CHANNEL Distribution Channel
10 PRODUCT_GUID COMM_PR_FRG_ROD PRODUCT_GUID   COMT_PRODUCT_GUID Internal Unique ID of Product
11 FRAGMENT_TYPE COMM_PR_FRG_ROD FRAGMENT_TYPE   COMT_FRGTYPE_GUID Internal Key of a Set Type
12 SEND_TYPE CRM_GIFTCARD SEND_TYPE   CRM_GC_SEND_TYPE Gift Card Send Type
13 VAL_DELAY CRM_GIFTCARD VAL_DELAY   CRM_GC_VALID_DELAY Validity Delay in Days
14 VAL_PERIO CRM_GIFTCARD VAL_PERIO   CRM_GC_VALID_PERIOD Validity Period in Months
15 VAL_TYPE CRM_GIFTCARD VAL_TYPE   CRM_GC_VALUE_TYPE Gift Card Value Type
                 
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 701