SAP ABAP Table CRMS_WFD_SEARCH_SOI (WFD UIU: Search for Service Order Item Demands)

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_SEARCH_SOI	Table Relationship Diagram
Short Description	WFD UIU: Search for Service Order Item Demands

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

History

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