/XFT/INV_Q_S SAP (Invoice receipt queue: Header) Table details
Dictionary Type: Table
Description: Invoice receipt queue: Header
Description: Invoice receipt queue: Header
Table field list including key, data, relationships and ABAP select examples
/XFT/INV_Q_S is a standard SAP Table which is used to store Invoice receipt queue: Header data and is available within R/3 SAP systems depending on the version and release level.
The /XFT/INV_Q_S table consists of various fields, each holding specific information or linking keys about Invoice receipt queue: Header data available in SAP. These include PROCESS_ID (Process ID), INV_TYPE (Invoice Receipt Type), PROCESS_ID_CHILD (Child Process ID), RATING (Rating).. 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: Cannot Be Enhanced
SAP /XFT/INV_Q_S 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PROCESS_ID | Process ID | /XFT/DIO_PROCESS_ID | CHAR | 34 | /XFT/DIO_ID | ||||
INV_TYPE | Invoice Receipt Type | /XFT/INV_INV_TYPE | CHAR | 4 | CHAR4 | /XFT/INV_INV_TYPE | |||
PROCESS_ID_CHILD | Child Process ID | /XFT/INV_PRO_ID_CHILD | CHAR | 34 | /XFT/DIO_ID | ||||
RATING | Rating | /XFT/INV_RATING | CHAR | 4 | Assigned to domain | /XFT/INV_RATING | |||
FOLLOW_ON_DOC | Follow-On Object Created? | /XFT/INV_FOLLOW_ON_OBJ | CHAR | 4 | /XFT/INV_FOLLOW_ON_OBJ | ||||
WORKFLOW | Workflow created? | /XFT/INV_WORKFL | CHAR | 4 | /XFT/INV_WORKFLOW | ||||
NUMBERWF | Number of Unfinished Workflows | /XFT/INV_NUMBER_WF | INT4 | 10 | INT4 | ||||
STATUS | Status | /XFT/INV_STATUS | CHAR | 10 | /XFT/INV_STATUS | ||||
STATUS_TEXT | Current Status | /XFT/INV_STATUS_TEXT | CHAR | 32 | TEXT32 | ||||
SYST_STATUS | System status | /XFT/INV_SYST_STATUS | CHAR | 4 | /XFT/INV_SYST_STATUS | ||||
CREATE_DATE | Creation Date | /XFT/INV_CREATE_DATE | DATS | 8 | DATS | ||||
CREATE_TIME | Creation Time | /XFT/INV_CREATE_TIME | TIMS | 6 | UZEIT | ||||
CHANGE_DATE | Change date | /XFT/INV_CHANGE_DATE | DATS | 8 | DATS | ||||
CHANGE_TIME | Time of change | /XFT/INV_CHANGE_TIME | TIMS | 6 | UZEIT | ||||
CHANGE_USER | Change - User | /XFT/USER_CHANGED | CHAR | 12 | USERNAME | ||||
MESS_EX | Messages | /XFT/INV_MESSAGE_EX | CHAR | 4 | /XFT/INV_MESSAGE_EX | ||||
ITER_NUM_VAL | Repeat Counter Validation | /XFT/INV_ITERATION_NUM_VAL | INT4 | 10 | INT4 | ||||
ITERATION_NUM | Repeat Counter | /XFT/INV_ITERATION_NUM | INT4 | 10 | INT4 | ||||
PROCESS_TYPE_DIS | Process type | /XFT/INV_PROC_TYPE_DISP | CHAR | 64 | TEXT64 | ||||
PROCESS_TYPE | Process type | /XFT/INV_PROC_TYPE | CHAR | 32 | CHAR32 | /XFT/INV_PRO_TYPE_ID | |||
PROCESS_TYPE_VAL | Process Type Validation | /XFT/INV_PROC_TYPE_VAL | CHAR | 32 | CHAR32 | /XFT/INV_PRO_TYPE_ID | |||
RECORD_ID | Record ID | /XFT/INV_REC_ID | CHAR | 32 | /XFT/SRM_DYN_REC_REC_ID | ||||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
DOCUMENTS | Serialized Doc. IDs | /XFT/INV_DOC_ID_XML | STRG | 0 | |||||
DOC_STRUCNAME | Character field, length 64 | CHAR64 | CHAR | 64 | CHAR64 | ||||
MESSAGES | Serialized Messages | /XFT/INV_MESSAGES | STRG | 0 | |||||
MESS_STRUCNAME | Character field, length 64 | CHAR64 | CHAR | 64 | CHAR64 | ||||
BARCODE | Barcode | /XFT/INV_BARCODE | CHAR | 40 | CHAR40 | ||||
REB_COLOR | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | CHAR4 | ||||
INV_DOC_NO | Invoice Document Number | /XFT/INV_RE_BELNR | CHAR | 10 | CHAR10 | ||||
INV_DOC_YEAR | Fiscal Year of Current Period | /XFT/INV_LFGJA | NUMC | 4 | GJAHR | GJAHR | |||
OBJECT_TYPE | Object type | OJ_NAME | CHAR | 10 | Assigned to domain | OJ_NAME | |||
MIRO_ICON | PO Reference? | /XFT/INV_MIRO_ICON | CHAR | 4 | /XFT/INV_MIRO_ICON | ||||
MRM_VORGANG | Transaction Types for Incoming Invoice | /XFT/MRM_VORGANG | CHAR | 1 | /XFT/MRM_VORGANG | ||||
INVOICE_IND | Invoice Indicator | /XFT/XRECH | CHAR | 1 | /XFT/BOOLEAN | ||||
DOC_TYPE | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
DOC_DATE | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
PSTNG_DATE | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
REF_DOC_NO | Reference Document Number | XBLNR | CHAR | 16 | XBLNR | ||||
COMP_CODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
DIFF_INV | Invoicing party | /XFT/INV_LIFRE | CHAR | 10 | ALPHA | /XFT/INV_LIFRE | |||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
CURRENCY_ISO | ISO currency code | ISOCD | CHAR | 3 | ISOCD | ||||
GROSS_AMOUNT | Currency amount | /XFT/INV_BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
INV_REC_DATE | Invoice Receipt Date | /XFT/REINDAT | DATS | 8 | DATS | ||||
CALC_TAX_IND | Calculate Tax Automatically? | /XFT/INV_XMWST | CHAR | 1 | XFELD | ||||
BLINE_DATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
PMNTTRMS | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
DSCT_DAYS1 | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
DSCT_PCT1 | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
DSCT_DAYS2 | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
DSCT_PCT2 | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
NETTERMS | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
FIXEDTERMS | Fixed Payment Terms | /XFT/INV_DZBFIX | CHAR | 1 | /XFT/INV_DZBFIX | ||||
PMNT_BLOCK | Payment Block Key | DZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
DSCT_AMOUNT | Cash discount in document currency | /XFT/INV_BAPI_WSKTO | DEC | 23(4) | BAPICURR | ||||
PYMT_METH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
INV_REF_NO | Invoice Reference: Document Number for Invoice Reference | AWREF_REB | CHAR | 10 | ALPHA | AWREF | |||
INV_YEAR | Fiscal year of related invoice (in case of credit memo) | /XFT/INV_REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
PARTNER_BK | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
HOUSEBANKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
EXCH_RATE | Direct Quoted Exchange Rate | UKURSP | DEC | 9(5) | PKURS | ||||
EXCH_RATE_V | Indirect Quoted Exchange Rate | UKURSM | DEC | 9(5) | PKURS | ||||
IV_CATEGORY | Origin of a Logistics Invoice Verification Document | /XFT/INV_IVTYP | CHAR | 1 | /XFT/IVTYP | ||||
DEL_COSTS | Unplanned delivery costs | /XFT/INV_BAPI_BEZNK | DEC | 23(4) | BAPICURR | ||||
DEL_COSTS_TAXC | Tax code, delivery costs | /XFT/INV_MWSKZ_BNK | CHAR | 2 | CHAR2 | ||||
DEL_COSTS_TAXJ | Jurisdiction code, delivery costs | /XFT/INV_TXJCD_BNK | CHAR | 15 | CHAR15 | ||||
PERSON_EXT | Name of creator of external system | /XFT/INV_ERNAME | CHAR | 12 | CHAR12 | ||||
PMTMTHSUPL | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
SCBANK_IND | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
SUPCOUNTRY | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
BLLSRV_IND | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
REF_DOC_NO_LONG | Reference Document Number (for Dependencies see Long Text) | XBLNR_LONG | CHAR | 35 | XBLNR_LONG | ||||
PO_SUB_NO | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
PO_CHECKDG | ISR Check Digit | ESRPZ | CHAR | 2 | CHAR2 | ||||
PO_REF_NO | ISR Reference Number | ESRRE | CHAR | 27 | ALPHA | ESRRE | |||
PAYEE_PAYER | Payee/Payer | /XFT/INV_EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
ALLOC_NMBR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
PAYMT_REF | Payment Reference | /XFT/INV_KIDNO | CHAR | 30 | CHAR30 | ||||
PLANNING_LEVEL | Planning Level | /XFT/INV_FDLEV | CHAR | 2 | CHAR2 | ||||
PLANNING_DATE | Planning Date | /XFT/INV_FDTAG | DATS | 8 | DATUM | ||||
BUS_AREA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
LOT_NUMBER | Bundeling Indicator for Documents | /XFT/INV_LOTKZ | CHAR | 10 | CHAR10 | ||||
ITEM_TEXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
J_1BNFTYPE | Nota Fiscal Type | /XFT/INV_J_1BNFTYPE | CHAR | 2 | CHAR2 | ||||
EU_TRIANG_DEAL | Indicator: Triangular Deal within the EU ? | /XFT/INV_XEGDR | CHAR | 1 | XFELD | ||||
REPCOUNTRY | Reporting Country for Delivery of Goods within the EU | /XFT/INV_EGMLD_BSEZ | CHAR | 3 | Assigned to domain | LAND1 | |||
BU_PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
ACC_1_TIME | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
NAME | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME_2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME_3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME_4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
POSTL_CODE | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
COUNTRY | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
STREET | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PO_BOX | PO Box | PFACH | CHAR | 10 | PFACH | ||||
POBX_PCD | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
FORM_OF_ADDR | Title | ANRED | CHAR | 15 | TEXT15 | ||||
LANGU | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
POBK_CURAC | Account Number of Bank Account At Post Office | PSKTO | CHAR | 16 | PSKTO | ||||
BANK_ACCT | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BANK_NO | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
BANK_CTRY | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
CTRL_KEY | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BANK_REF | Reference specifications for bank details | BKREF | CHAR | 20 | CHAR20 | ||||
TAX_NO_1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
TAX_NO_2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
TAX_NO_3 | Tax Number 3 | STCD3 | CHAR | 18 | CHAR18 | ||||
TAX_NO_4 | Tax Number 4 | STCD4 | CHAR | 18 | CHAR18 | ||||
SLS_PUR_TX | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
EQUAL_TAX | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
TAX_CATEGORY | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
TAX_NO_TY | Tax Number Type | J_1ATOID | CHAR | 2 | Assigned to domain | J_1ATOID | |||
SOLE_PROP | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
VAT_REG_NO | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
USER_STATUS | User status | /XFT/INV_USER_STATUS | CHAR | 10 | CHAR10 | /XFT/INV_USER_STATUS | |||
PERSON_RESP | Agent | /XFT/INV_PERSON_RESP | CHAR | 12 | USERNAME | ||||
ORG_UNIT | Organizational Unit | /XFT/INV_ORG_UNIT | CHAR | 14 | HROBJEC_14 | ||||
DESCRIPTION | Comment | /XFT/INV_DESCRIPTION | CHAR | 4 | CHAR4 | ||||
USER1 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER2 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER3 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER4 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER5 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER6 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER7 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER8 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER9 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER10 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER11 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER12 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER13 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER14 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
USER15 | User Field | /XFT/INV_USER_FIELD | CHAR | 128 | TEXT128 | ||||
MIRO | Flag: Reference to Purchase Order | /XFT/INV_MIRO_REL | CHAR | 1 | /XFT/INV_MIRO_FLAG | ||||
REFERENZBELEGTYP | Reference Document Category | /XFT/INV_MRM_REFERENZBELEGTYP | CHAR | 1 | /XFT/INV_MRM_REFERENZBELEGTYP | ||||
BLART_FI | FI Document Type | /XFT/INV_BLART_FI | CHAR | 2 | Assigned to domain | BLART |
Key field | Non-key field |
How do I retrieve data from SAP table /XFT/INV_Q_S using ABAP code
The following ABAP code Example will allow you to do a basic selection on /XFT/INV_Q_S to SELECT all data from the tableDATA: WA_/XFT/INV_Q_S TYPE /XFT/INV_Q_S.
SELECT SINGLE *
FROM /XFT/INV_Q_S
INTO CORRESPONDING FIELDS OF WA_/XFT/INV_Q_S
WHERE...
How to access SAP table /XFT/INV_Q_S
Within an ECC or HANA version of SAP you can also view further information about /XFT/INV_Q_S 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