SAP ABAP Table CRMS_WFD_SOI_FR_ATTR_STRUCT (Find and Rank Result)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-RPL-SRV (Application Component) Service Resource Planning
⤷

CRM_WFD_BOL_GENIL_SOI (Package) BOL / Genil Implementation for Res. Planning Service Order

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_WFD_SOI_FR_ATTR_STRUCT	Table Relationship Diagram
Short Description	Find and Rank Result

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	Service Demand Data
2	ITEM_GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	CHANGED_AT	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
4	CREATED_AT	CRMT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
5	LOGSYS	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
6	.INCLUDE				0	0	General Data of a WFD Service Demand
7	ORDER_ID	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
8	HEADER_GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
9	ITEM_NUMBER	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
10	LC_STATUS	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
11	CANCELLED	CRMD_WFDSE_SERVICE_ITEM_CANCEL	CRM_WFD_SERVICE_ITEM_CANCELED	CHAR	2	0	RPA: Service Order Item Cancelled
12	SRV_PRODUCT_GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
13	SRV_PRODUCT	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
14	SUP_ITEM_NUMBER	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
15	TRANSACTION_TYPE	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
16	HEADER_DESCRIPTI	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
17	ITEM_DESCRIPTION	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
18	ITEM_TYPE	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
19	PRIORITY	NUMC1	NUMC1	NUMC	1	0	Num1
20	DURATION	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
21	DURATION_UNIT	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
22	DURATION_SI	INT4	INT4	INT4	10	0	Natural number
23	ORG_ID	HROBJID	HROBJID	NUMC	8	0	Object ID	*
24	NUMBER_RESOURCES	CRMT_SRV_PERSONS	NUMC3	NUMC	3	0	Number of Persons
25	BOOLEAN_PARTS	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
26	BOOLEAN_RELATION	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
27	BOOLEAN_QUALIFIC	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
28	.INCLUDE				0	0	WFD Service ORder Item Technical Object
29	TECH_OBJ_FROM	CHAR2	CHAR2	CHAR	2	0	Version Number Component
30	TECH_OBJ_GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
31	IOBJECT	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
32	IBASE	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
33	IBASE_COMPONENT	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
34	.INCLUDE				0	0	WFD Business Partner
35	BPID	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
36	PARTNER_PF	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
37	ADDR_NO	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
38	ADDRESS_GUID	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
39	.INCLUDE				0	0	WFD Location
40	LOCATION_FROM	CHAR2	CHAR2	CHAR	2	0	Version Number Component
41	LOC_STREET	AD_STREET	TEXT60	CHAR	60	0	Street
42	LOC_HOUSE_NUMBER	AD_HSNM1	TEXT10	CHAR	10	0	House Number
43	LOC_COUNTRY	LAND1	LAND1	CHAR	3	0	Country Key	*
44	LOC_REGION	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
45	LOC_CITY	AD_CITY1	TEXT40	CHAR	40	0	City
46	LOC_ZIP_CODE	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
47	LOC_ADDRESS_GUID	BU_ADDRESS_GUID	SYSUUID	RAW	16	0	GUID of a Business Partner Address
48	LOC_OBJECT_GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
49	LOC_BP_ID	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
50	LOC_IBASE_ID	IB_IBASE	IB_INSTANCE	NUMC	18	0	IBase: Number of the Installed Base/IBase
51	LOC_IBASE_COMP	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
52	LOC_IOBJECT_ID	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
53	LOC_LATITUDE	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude
54	LOC_LONGITUDE	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
55	LOC_PRECISID	GEOPRECIS	D_GEOPREC	NUMC	4	0	Precision (street, postal code, ...) of a Geo location
56	LOC_SRV_AREA	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
57	LOC_ADDRNUM	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
58	.INCLUDE				0	0	WFD Time Stamps
59	SELECTION_FROM	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
60	SELECTION_TO	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
61	FROM_DATE_TYPE	CRMT_APPTYPE	SC_APPTTYP	CHAR	12	0	Technical Name for Date Type	*
62	FROM_TIMESTAMP	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
63	FROM_ACTION	CHAR2	CHAR2	CHAR	2	0	Version Number Component
64	TO_DATE_TYPE	CRMT_APPTYPE	SC_APPTTYP	CHAR	12	0	Technical Name for Date Type	*
65	TO_TIMESTAMP	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
66	TO_ACTION	CHAR2	CHAR2	CHAR	2	0	Version Number Component
67	EA_DUMMY	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
68	.INCLUDE				0	0
69	.INCLUDE				0	0	WFD Data for Service Orders
70	STAFFING_LEVEL	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
71	.INCLUDE				0	0	Texts to Objects in Demand Structure
72	LC_STATUS_TEXT	TXT30	TEXT30	CHAR	30	0	Text
73	TRANSACTION_TYPE_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
74	STAFFING_LEVEL_TEXT	TXT30	TEXT30	CHAR	30	0	Text
75	ITEM_CAT_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
76	IOBJECT_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
77	IBASE_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
78	IBASE_COMP_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
79	SRV_PRODUCT_TEXT	TXT30	TEXT30	CHAR	30	0	Text
80	PRIORITY_TEXT	TXT30	TEXT30	CHAR	30	0	Text
81	SERV_AREA_TEXT	TXT30	TEXT30	CHAR	30	0	Text
82	FROM_DATE_TYPE_TEXT	TXT30	TEXT30	CHAR	30	0	Text
83	TO_DATE_TYPE_TEXT	TXT30	TEXT30	CHAR	30	0	Text
84	CUSTOMER_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
85	LOC_BP_ID_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
86	LOC_IBASE_ID_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
87	LOC_IBASE_COMP_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
88	LOC_IOBJECT_ID_TEXT	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
89	QUALIF_RANK	CRM_LRP_MATCH_QUALIF		INT2	5	0	Degree of Suitability Relating to Qualifications
90	AVAIL_RANK	CRM_LRP_MATCH_AVAIL		INT2	5	0	Degree of Suitability Relating to Availability
91	OVERALL_RANK	CRM_LRP_MATCH		INT2	5	0	Total Degree of Suitability
92	OBL_QUALIF_OK	CRM_LRP_MATCH_MUST_QUALIS	CRM_LRP_MATCH_MUST_QUALIS	CHAR	1	0	Mandatory Qualification Requirements Are Fulfilled
93	DISTANCE	CRME_WFD_MATCH_DISTANCE		QUAN	13	2	DIstance for location search
94	DISTANCE_UNIT	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*