SAP ABAP Table CRMV_HH_SALE (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CRMV_HH_SALE   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client  
2 ORGANIZATION CRMT_HH_ORGANIZATION HROBJEC_14 CHAR 14   0   CRM Handheld: Organization CRMC_HH_ORG
3 CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel CRMC_HH_ORG
4 TRANSACTION_TYPE CRMT_PROCESS_TYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type CRMC_PROC_TYPE
5 TRANS_TYPE_TEXT CRMT_DESCRIPTION TEXT40 CHAR 40   0   Description  
6 ITEM_CATEGORY CRMT_ITEM_TYPE CRM_ITEM_TYPE CHAR 4   0   Item Category CRMC_ITEM_TYPE
7 ITEM_CAT_TEXT CRMT_ITM_TYPE_DESC TEXT40 CHAR 40   0   Item Category Text  
8 SOLD_TO_PFC COMT_PARTNER_FCT COM_PARTNER_FCT CHAR 8   0   Partner Function CRMC_PARTNER_FCT
9 SHIP_TO_PFC COMT_PARTNER_FCT COM_PARTNER_FCT CHAR 8   0   Partner Function CRMC_PARTNER_FCT
10 EMPL_RESP_PFC COMT_PARTNER_FCT COM_PARTNER_FCT CHAR 8   0   Partner Function CRMC_PARTNER_FCT
11 CND_DISCOUNT_REL /SAPCND/COND_TYPE /SAPCND/COND_TYPE CHAR 4   0   Condition Type /SAPCND/T685
12 CND_DISCOUNT_ABS /SAPCND/COND_TYPE /SAPCND/COND_TYPE CHAR 4   0   Condition Type /SAPCND/T685
13 FROM_DATE /SAPDMC/LS_DATE_BEGIN DATUM DATS 8   0   Start Date  
14 TO_DATE /SAPDMC/LS_DATE_END DATUM DATS 8   0   End Date  
15 FREE_NUMBERS NUMC2 NUMC2 NUMC 2   0   Two digit number  
16 VALID_FROM /SAPDMC/LS_DATE_BEGIN DATUM DATS 8   0   Start Date  
17 VALID_TO /SAPDMC/LS_DATE_END DATUM DATS 8   0   End Date  
18 LOOK_BACK CRMT_HH_LOOK_BACK NUMC4 NUMC 4   0   CRM Handheld: number of days back to search for documents  
19 LOOK_AHEAD CRMT_HH_LOOK_AHEAD NUMC4 NUMC 4   0   CRM Handheld: number of days ahead to search for documents  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMV_HH_SALE CHANNEL CRMC_HH_ORG CHANNEL 1 N
2 CRMV_HH_SALE CND_DISCOUNT_ABS /SAPCND/T685 KSCHL    
3 CRMV_HH_SALE CND_DISCOUNT_REL /SAPCND/T685 KSCHL    
4 CRMV_HH_SALE EMPL_RESP_PFC CRMC_PARTNER_FCT PARTNER_FCT    
5 CRMV_HH_SALE ITEM_CATEGORY CRMC_ITEM_TYPE ITM_TYPE C CN
6 CRMV_HH_SALE ORGANIZATION CRMC_HH_ORG ORGANIZATION 1 N
7 CRMV_HH_SALE SHIP_TO_PFC CRMC_PARTNER_FCT PARTNER_FCT    
8 CRMV_HH_SALE SOLD_TO_PFC CRMC_PARTNER_FCT PARTNER_FCT    
9 CRMV_HH_SALE TRANSACTION_TYPE CRMC_PROC_TYPE PROCESS_TYPE C CN
History
Last changed by/on SAP  20130604 
SAP Release Created in