SAP ABAP Table CRMS_WFD_SOI_DETAILS (Service Demand Data)

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_DETAILS	Table Relationship Diagram
Short Description	Service Demand Data

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