/XFT/INV_Q_9 SAP (Workflow work item process ID assignment) Table details

Dictionary Type: Table
Description: Workflow work item process ID assignment




ABAP Code to SELECT data from /XFT/INV_Q_9
Related tables to /XFT/INV_Q_9
Access table /XFT/INV_Q_9




Table field list including key, data, relationships and ABAP select examples

/XFT/INV_Q_9 is a standard SAP Table which is used to store Workflow work item process ID assignment data and is available within R/3 SAP systems depending on the version and release level.

The /XFT/INV_Q_9 table consists of various fields, each holding specific information or linking keys about Workflow work item process ID assignment data available in SAP. These include PROCESS_ID (Process ID), WORKITEM_ID (Work item ID), WORKITEM_GROUP (Work item group), WITEXT (Work Item Text).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP /XFT/INV_Q_9 table 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
PROCESS_IDProcess ID /XFT/DIO_PROCESS_IDCHAR34/XFT/DIO_ID
WORKITEM_IDWork item ID SWW_WIIDNUMC12Assigned to domainSWW_WIIDWID
WORKITEM_GROUPWork item group /XFT/INV_WI_GROUPCHAR32CHAR32
WITEXTWork Item Text WITEXTCHAR120TEXT120
CREATED_BYCreate-User /XFT/INV_CREATED_BYCHAR12UNAME
WF_FINISHEDWork Item Finished? /XFT/INV_WF_FINISHEDCHAR4/XFT/INV_WF_FINISHED
TIMESTAMPCreated On /XFT/INV_CREATE_TIME_TSCHAR14TIMESTAMP
FINISHED_ATEnded on /XFT/INV_FINISH_TIME_TSCHAR14TIMESTAMP
DURATIONDuration in Seconds /XFT/INV_DURATION_SECDEC31/XFT/INV_DURATION_SEC
DURATION_TEXTDuration /XFT/INV_Q_MAN_DURATIONCHAR64CHAR64
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
STATUSApproval status /XFT/INV_APPROVAL_STATUSCHAR12/XFT/INV_APPROVAL_STATUS
STATUS_DApproval status: Text /XFT/INV_APPROVAL_STATUS_DCHAR30CHAR30
APPROVERApprover /XFT/INV_APPROVERCHAR12Assigned to domainXUBNAME
CATEGORYCategory /XFT/INV_CATEGORYCHAR15/XFT/INV_CATEGORY
CATEGORY_DCategory: Text /XFT/INV_CATEGORY_DCHAR20CHAR20
COST_CENTERCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
PSPNRWBS Element /XFT/INV_PS_POSNRNUMC8/XFT/INV_PS_POSNR
PO_NUMBERPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
PO_ITEMItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
GL_ACCOUNTG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
ASSET_NOMain Asset Number ANLN1CHAR12Assigned to domainALPHAANLN1AN1
ASSET_SUB_NOAsset Subnumber ANLN2CHAR4Assigned to domainALPHAANLN2AN2
F_COST_CENTERBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_PSPNRBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_PO_NUMBERBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_PO_ITEMBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_AUFNRBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_GL_ACCOUNTBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_ASSET_NOBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_ASSET_SUB_NOBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
F_OTHERSBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
TEXT_XML XML of text table0
COMM_CURR_XML XML table of current comment0
APPROVER_XML XML of approver list0

Key field Non-key field



How do I retrieve data from SAP table /XFT/INV_Q_9 using ABAP code

The following ABAP code Example will allow you to do a basic selection on /XFT/INV_Q_9 to SELECT all data from the table
DATA: WA_/XFT/INV_Q_9 TYPE /XFT/INV_Q_9.

SELECT SINGLE *
FROM /XFT/INV_Q_9
INTO CORRESPONDING FIELDS OF WA_/XFT/INV_Q_9
WHERE...

How to access SAP table /XFT/INV_Q_9

Within an ECC or HANA version of SAP you can also view further information about /XFT/INV_Q_9 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!