SAP ABAP Table CRMS_FS_NEED_H_BTIL (AO FS: Need Analysis IL Attribute Structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IFS-BTX (Application Component) Business Transaction
     ⤷ CRM_FS_1O_EXT_NEED (Package) FS Extension for Need Analysis

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_FS_NEED_H_BTIL	Table Relationship Diagram
Short Description	AO FS: Need Analysis IL Attribute Structure

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	.INCLUDE	☐				0	0	AO FS: Need Analysis Work Area Fields
2	.INCLUDE	☐				0	0	AO FS : Customer Requirements
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	RECORD	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object	CRMD_ORDERADM_H
6	.INCLUDE	☐				0	0	Need Analysis Fields
7	NEED_CATEGORY	☐	CRM_FS_NEED_CATEGORY	CRM_FS_NEED_CATEGORY	CHAR	3	0	Need Category	*
8	NEED_TYPE	☐	CRM_FS_NEED_TYPE	CRM_FS_NEED_TYPE	CHAR	4	0	Need Type	*
9	FIN_REQ_VOL	☐	CRM_FS_AMOUNT	TFM_WRTV12	CURR	23	2	Amount
10	FIN_REQ_VOL_C	☐	CRM_FS_AMOUNT_C	WAERS	CUKY	5	0	Currency	TCURC
11	FIN_REQ_TERM	☐	CRMT_FS_TERM	CRMT_FS_TERM	NUMC	3	0	Term
12	FIN_REQ_TERM_UNIT	☐	CRMT_FS_TIMEUNIT	TIMEUNITNA	CHAR	12	0	Time Unit	TIMECUUT
13	PROPERTY_VALUE	☐	CRM_FS_AMOUNT	TFM_WRTV12	CURR	23	2	Amount
14	PROPERTY_VALUE_C	☐	CRM_FS_AMOUNT_C	WAERS	CUKY	5	0	Currency	TCURC
15	PROPERTY_LOC_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
16	PROPERTY_LOC_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
17	DOWN_PAYMENT	☐	CRM_FS_AMOUNT	TFM_WRTV12	CURR	23	2	Amount
18	DOWN_PAYMENT_C	☐	CRM_FS_AMOUNT_C	WAERS	CUKY	5	0	Currency	TCURC
19	INT_RATE_TYPE	☐	CRM_FS_INT_RATE_TYPE	CRM_FS_INT_RATE_TYPE	CHAR	1	0	Interest Rate Type
20	EXPECTED_CONTRACT_START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
21	NEED_ITEM_ID	☐	CRM_FS_NEED_ITEM_ID	CRM_ITEM_NO	NUMC	10	0	Need Item ID in Banking Opportunity
22	COST_OF_RENOVATION	☐	CRM_FS_AMOUNT	TFM_WRTV12	CURR	23	2	Amount
23	COST_OF_RENOVATION_C	☐	CRM_FS_AMOUNT_C	WAERS	CUKY	5	0	Currency	TCURC
24	.INCLUDE	☐				0	0	AO FS: Banking Opportunity extensibility include
25	CRM_FS_BOP_NEED_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
26	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
27	DELETED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_FS_NEED_H_BTIL	COST_OF_RENOVATION_C	TCURC	WAERS
2	CRMS_FS_NEED_H_BTIL	DOWN_PAYMENT_C	TCURC	WAERS
3	CRMS_FS_NEED_H_BTIL	FIN_REQ_TERM_UNIT	TIMECUUT	NAME_UNIT
4	CRMS_FS_NEED_H_BTIL	FIN_REQ_VOL_C	TCURC	WAERS
5	CRMS_FS_NEED_H_BTIL	GUID	CRMD_ORDERADM_H	CLIENT	KEY	1	CN
6	CRMS_FS_NEED_H_BTIL	PROPERTY_LOC_COUNTRY	T005	LAND1
7	CRMS_FS_NEED_H_BTIL	PROPERTY_VALUE_C	TCURC	WAERS

History

Last changed by/on	SAP	20130604
SAP Release Created in	703