WFDSS_SERVICE_DEMAND_DATA_FR SAP (Find and Rank Result) Structure details
Description: Find and Rank Result
Related tables to WFDSS_SERVICE_DEMAND_DATA_FR
Access table WFDSS_SERVICE_DEMAND_DATA_FR
Structure field list including key, data, relationships and ABAP select examples
WFDSS_SERVICE_DEMAND_DATA_FR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Find and Rank Result" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_WFDSS_SERVICE_DEMAND_DATA_FR TYPE WFDSS_SERVICE_DEMAND_DATA_FR.
The WFDSS_SERVICE_DEMAND_DATA_FR table consists of various fields, each holding specific information or linking keys about Find and Rank Result data available in SAP. These include ITEM_GUID (GUID), CHANGED_AT (Changed timestamp), CREATED_AT (Created timestamp), LOGSYS (Logical system).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP WFDSS_SERVICE_DEMAND_DATA_FR structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
ITEM_GUID | GUID | WFDSE_RAW16_GUID | RAW | 16 | |||||
CHANGED_AT | Changed timestamp | WFDSE_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
CREATED_AT | Created timestamp | WFDSE_CREATED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
ORDER_ID | Business Transaction Number | WFDSE_ORDER_ID | CHAR | 10 | |||||
HEADER_GUID | GUID | WFDSE_RAW16_GUID | RAW | 16 | |||||
ITEM_NUMBER | Item Number in Document | WFDSE_ITEM_NUMBER | NUMC | 10 | |||||
LC_STATUS | Live Cycle Status Order | WFDSE_LC_STATUS | CHAR | 5 | WFDS_LC_STATUS | ||||
CANCELLED | Service Order Item is cancelled | WFDSE_SERVICE_ITEM_CANCELED | CHAR | 2 | WFDS_SERVICE_ITEM_CANCELED | ||||
SRV_PRODUCT_GUID | GUID | WFDSE_RAW16_GUID | RAW | 16 | |||||
SRV_PRODUCT | Product ID | WFDSE_PRODUCT_ID | CHAR | 54 | WFDS_PRODUCT_ID | ||||
SUP_ITEM_NUMBER | Item Number in Document | WFDSE_ITEM_NUMBER | NUMC | 10 | |||||
TRANSACTION_TYPE | Business Transaction Type | WFDSE_PROCESS_TYPE | CHAR | 4 | |||||
HEADER_DESCRIPTI | Description | WFDSE_HEADER_DESCRIPTION | CHAR | 40 | |||||
ITEM_DESCRIPTION | Description | WFDSE_ITEM_DESCRIPTION | CHAR | 40 | |||||
ITEM_TYPE | Item Category | WFDSE_ITEM_TYPE | CHAR | 4 | |||||
PRIORITY | Priority | WFDSE_PRIORITY | NUMC | 1 | |||||
DURATION | Duration | WFDSE_DURATION | QUAN | 13(3) | |||||
DURATION_UNIT | Unit for Duration of Work | WFDSE_DURATION_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DURATION_SI | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
ORG_ID | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
NUMBER_RESOURCES | Number of Persons | WFDSE_PERSONS | NUMC | 3 | |||||
BOOLEAN_PARTS | Flag: Spare Parts Required | WFDSE_PARTS_REQ | CHAR | 1 | BOOLE | ||||
BOOLEAN_RELATION | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
BOOLEAN_QUALIFIC | Flag: Qualifications required | WFDSE_QUALIF_REQ | CHAR | 1 | BOOLE | ||||
TECH_OBJ_FROM | Source of the Location a job has to be performed | WFDSE_LOCATION_FROM | CHAR | 2 | WFDS_LOCATION_FROM | ||||
TECH_OBJ_GUID | GUID | WFDSE_RAW16_GUID | RAW | 16 | |||||
IOBJECT | IObject | WFDSE_IOBJECT_ID | CHAR | 40 | |||||
IBASE | Installed Base Number | WFDSE_IBASE_ID | NUMC | 18 | |||||
IBASE_COMPONENT | IBASE Component (Instance) | WFDSE_IBASE_INSTANCE | NUMC | 18 | |||||
BPID | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNER_PF | Partner Function Category | WFDSE_PARTNER_PFT | CHAR | 4 | WFDS_PARTNER_PFT | ||||
ADDR_NO | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
ADDRESS_GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
LOCATION_FROM | Source of the Location a job has to be performed | WFDSE_LOCATION_FROM | CHAR | 2 | WFDS_LOCATION_FROM | ||||
LOC_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
LOC_HOUSE_NUMBER | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
LOC_COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
LOC_REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
LOC_CITY | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
LOC_ZIP_CODE | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
LOC_ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
LOC_OBJECT_GUID | GUID | WFDSE_RAW16_GUID | RAW | 16 | |||||
LOC_BP_ID | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
LOC_IBASE_ID | Installed Base Number | WFDSE_IBASE_ID | NUMC | 18 | |||||
LOC_IBASE_COMP | IBASE Component (Instance) | WFDSE_IBASE_INSTANCE | NUMC | 18 | |||||
LOC_IOBJECT_ID | IObject | WFDSE_IOBJECT_ID | CHAR | 40 | |||||
LOC_LATITUDE | Geo location latitude | GEOLAT | DEC | 15(12) | GEOLONLAT | ||||
LOC_LONGITUDE | Geo location longitude | GEOLON | DEC | 15(12) | GEOLONLAT | ||||
LOC_PRECISID | Precision (street, postal code, ...) of a Geo location | GEOPRECIS | NUMC | 4 | D_GEOPREC | ||||
LOC_SRV_AREA | Service Area Code | WFDSE_SERVICE_AREA_CODE | CHAR | 10 | |||||
LOC_ADDRNUM | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
SELECTION_FROM | Time Stamp (Date and Time) | WFDSE_TIMESTAMP | DEC | 15 | TSTPS | BCOS_TSTMP | |||
SELECTION_TO | Time Stamp (Date and Time) | WFDSE_TIMESTAMP | DEC | 15 | TSTPS | BCOS_TSTMP | |||
FROM_DATE_TYPE | Date Types for 'Selection From' | WFDSE_DATE_TYPE | CHAR | 12 | Assigned to domain | WFDS_POSSIBLE_DATE_TYPES | |||
FROM_TIMESTAMP | Time Stamp (Date and Time) | WFDSE_TIMESTAMP | DEC | 15 | TSTPS | BCOS_TSTMP | |||
FROM_ACTION | Action | WFDSE_ACTION | CHAR | 2 | WFDS_ACTION | ||||
TO_DATE_TYPE | Date Types for 'Selection From' | WFDSE_DATE_TYPE | CHAR | 12 | Assigned to domain | WFDS_POSSIBLE_DATE_TYPES | |||
TO_TIMESTAMP | Time Stamp (Date and Time) | WFDSE_TIMESTAMP | DEC | 15 | TSTPS | BCOS_TSTMP | |||
TO_ACTION | Action | WFDSE_ACTION | CHAR | 2 | WFDS_ACTION | ||||
EA_DUMMY | Dummy Data Element for Enhanced Attributes | WFDSE_DUMMY | CHAR | 1 | |||||
STAFFING_LEVEL | Staffing Level | WFDSE_ASSIGNMENT_STATE | CHAR | 1 | WFDS_ASSIGNMENT_STATE | ||||
LC_STATUS_TEXT | Text | TXT30 | CHAR | 30 | TEXT30 | ||||
TRANSACTION_TYPE_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
STAFFING_LEVEL_TEXT | Text | TXT30 | CHAR | 30 | TEXT30 | ||||
ITEM_CAT_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
IOBJECT_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
IBASE_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
IBASE_COMP_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
SRV_PRODUCT_TEXT | Text | TXT30 | CHAR | 30 | TEXT30 | ||||
PRIORITY_TEXT | Text | TXT30 | CHAR | 30 | TEXT30 | ||||
SERV_AREA_TEXT | Text | TXT30 | CHAR | 30 | TEXT30 | ||||
FROM_DATE_TYPE_TEXT | Text | TXT30 | CHAR | 30 | TEXT30 | ||||
TO_DATE_TYPE_TEXT | Text | TXT30 | CHAR | 30 | TEXT30 | ||||
CUSTOMER_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
LOC_BP_ID_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
LOC_IBASE_ID_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
LOC_IBASE_COMP_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
LOC_IOBJECT_ID_TEXT | Character field of length 40 | CHAR40 | CHAR | 40 | CHAR40 | ||||
QUALIF_RANK | Degree of Suitability Relating to Qualifications | WFDSE_MATCH_QUALIF | INT2 | 5 | |||||
AVAIL_RANK | Degree of Suitability Relating to Availability | WFDSE_MATCH_AVAIL | INT2 | 5 | |||||
OVERALL_RANK | Total Suitability | WFDSE_MATCH | INT2 | 5 | |||||
OBL_QUALIF_OK | Mandatory Qualification Requirements Are Fulfilled | WFDSE_MATCH_OBL_OK | CHAR | 1 | WFDS_BOOLEAN | ||||
DISTANCE | DIstance for location search | WFDSE_DISTANCE | QUAN | 13(2) | |||||
DISTANCE_UNIT | Unit of Measurement | MSEHI | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
Key field | Non-key field |
How do I retrieve data from SAP structure WFDSS_SERVICE_DEMAND_DATA_FR using ABAP code?
As WFDSS_SERVICE_DEMAND_DATA_FR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WFDSS_SERVICE_DEMAND_DATA_FR as there is no data to select.How to access SAP table WFDSS_SERVICE_DEMAND_DATA_FR
Within an ECC or HANA version of SAP you can also view further information about WFDSS_SERVICE_DEMAND_DATA_FR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects