SAP ABAP Table V_ICLSERVCAT (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_ICLSERVCAT   Table Relationship Diagram
Short Description Generated Table for View    
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 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 SCPOSID_INT ICL_SERVCAT_POSID_INT SYSUUID_C CHAR 32   0   Internal ID of Benefits Catalog Item  
3 ACTIVE ICL_ACTIVE2 ICL_ACTIVE2 CHAR 1   0   Status  
4 CHANGEDBY ICL_CHANGEBY XUBNAME CHAR 12   0   Version Created By (= Object Changed By) USR02
5 CHANGETIME ICL_CHANGEUTC ICL_TIMESTAMP DEC 15   0   Version Created: UTC Date+Time  
6 INACTIVETIME ICL_INACTIUTC ICL_TIMESTAMP DEC 15   0   Version Deactivated: UTC Date+Time  
7 EFFFROMTIME ICL_EFFROMUTC ICL_TIMESTAMP DEC 15   0   Version Valid From: UTC Date+Time  
8 EFFTOTIME ICL_EFFETOUTC ICL_TIMESTAMP DEC 15   0   Version Valid to: UTC-Date+Time  
9 TERMTIME ICL_TERMINUTC ICL_TIMESTAMP DEC 15   0   Valid-To Date Set: UTC Date+Time  
10 DELETED ICL_XDELETE XFELD CHAR 1   0   Flag: Deletion Entry?  
11 OSYSID ICL_OSYSID SYCHAR08 CHAR 8   0   Original System of Version  
12 OMANDT ICL_OMANDT MANDT CLNT 3   0   Client in Original System  
13 SCPOSID_PREV ICL_SERVCAT_POSID_INT SYSUUID_C CHAR 32   0   Internal ID of Benefits Catalog Item  
14 SERVCATID ICL_SERVCATID ICL_SERVCATID CHAR 10   0   ID of a Benefits, Services and Fees Catalog TICL401
15 SCPOSID_EXT ICL_SERVCAT_POSID ICL_SERVCAT_POSID CHAR 20   0   ID of a Benefits Catalog Item  
16 SCPOSID_AMNTFROM ICL_SERVCAT_POSID_AMOUNT_FROM ICL_AMOUNT CURR 15   2   Lower Interval Limit of a Benefits Catalog Item  
17 SCPOSID_AMNTTO ICL_SERVCAT_POSID_AMOUNT_TO ICL_AMOUNT CURR 15   2   Upper Interval Limit of a Benefits Catalog Item  
18 SCPOS_CURR ICL_SERVCAT_POS_CURR WAERS CUKY 5   0   Currency of Benefits/Services/Fees Catalog TCURC
19 SCPOS_PARENT ICL_SERVCAT_POSID_INT SYSUUID_C CHAR 32   0   Internal ID of Benefits Catalog Item  
20 SCPOS_TYPE ICL_SERVCAT_POS_TYPE ICL_SERVCAT_POS_TYPE CHAR 4   0   Type of Benefits Catalog Item TICL404
21 SCPOS_XSEL ICL_SERVCAT_POS_SELECTABLE XFELD CHAR 1   0   Entry Lock for Benefits Catalog Item  
22 BENTYPE ICL_BENTYPE ICL_BENTYPE CHAR 10   0   Benefit Type TICL055
23 BENTYPE_EXP BRF_EXPRESSION BRF_EXPRESSION CHAR 20   0   BRF: Expression  
24 SCPOS_XREIMBURSE ICL_SERVCAT_POS_REIMBURSABLE ICL_SERVCAT_POS_REIMBURSABLE CHAR 1   0   Reimbursability of a Benefits Catalog Item  
25 SCPOS_XAPPROVAL ICL_SERVCAT_POS_APPROVAL XFELD CHAR 1   0   Approval Requirement of a Benef/Serv/Fees Catalog Item  
26 LANGU LANGU SPRAS LANG 1   0   Language Key T002
27 SCPOSN ICL_SERVCAT_POS_SHORTNAME TEXT30 CHAR 30   0   Short Text of a Benefits Catalog Item  
28 SCPOSLN ICL_SERVCAT_POS_NAME TEXT100 CHAR 100   0   Long Text of Benefits Catalog Item  
29 SEASCPOSN ICL_SERVCAT_POS_SEASHORTNAME CHAR30 CHAR 30   0   Short Text for Search of a Benefits Catalog Item  
30 SEASCPOSLN ICL_SERVCAT_POS_SEANAME CHAR100 CHAR 100   0   Long Text for Search for Benefits Catalog Item  
31 SCPOS_QUANTITY ICL_SERVCAT_POS_QUANTITY ICL_SERVCAT_POS_QUANTITY QUAN 10   3   Evaluation Quantity of Benefits Catalog Item  
32 SCPOS_QUANUNIT ICL_SERVCAT_POS_QUANUNIT MEINS UNIT 3   0   Unit of Benefits Catalog Item T006
33 SC_VARIANT ICL_SERVCAT_VARIANT ICL_SERVCAT_VARIANT CHAR 4   0   Variant of a Benefits/Services/Fee Catalog TICL402
34 SCPOS_VALPERUNIT ICL_SERVCAT_POS_VALPERUNIT ICL_SERVCAT_POS_VALPERUNIT DEC 20   12   Value per Unit of Benefits Catalog Item  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_ICLSERVCAT BENTYPE TICL055 BENTYPE 1 CN
2 V_ICLSERVCAT CHANGEDBY USR02 BNAME 1 CN
3 V_ICLSERVCAT CLIENT T000 MANDT KEY 1 CN
4 V_ICLSERVCAT LANGU T002 SPRAS KEY 1 CN
5 V_ICLSERVCAT SCPOS_CURR TCURC WAERS 1 CN
6 V_ICLSERVCAT SCPOS_QUANUNIT T006 MSEHI 1 CN
7 V_ICLSERVCAT SCPOS_TYPE TICL404 SCPOS_TYPE 1 CN
8 V_ICLSERVCAT SC_VARIANT TICL402 SC_VARIANT    
9 V_ICLSERVCAT SERVCATID TICL401 SERVCATID    
History
Last changed by/on SAP  20110901 
SAP Release Created in