SAP ABAP Table CRMS_FS_NEED_H_DB_WRK (AO FS: Need Analysis DB Buffer Fields)

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_DB_WRK	Table Relationship Diagram
Short Description	AO FS: Need Analysis DB Buffer Fields

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

Foreign Keys

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

History

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