SAP TABLES | Basis Components(BC) SAP BC

/XFT/INV_Q_S SAP Invoice receipt queue: Header Table and data







/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.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP /XFT/INV_Q_S Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Cannot Be Enhanced
See here for more information about this and other SAP enhancement categories


SAP /XFT/INV_Q_S Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
PROCESS_ID/XFT/DIO_PROCESS_IDCHAR34 Process ID
INV_TYPE/XFT/INV_INV_TYPECHAR4 Invoice Receipt Type
.INCLUDE/XFT/INV_S_MON_TOTAL Structure for invoice receipt monitor
.INCLUDE/XFT/INV_S_MON_BASE Structure for invoice receipt monitor
PROCESS_ID_CHILD/XFT/INV_PRO_ID_CHILDCHAR34 Child Process ID
RATING/XFT/INV_RATINGCHAR4
*
Rating
FOLLOW_ON_DOC/XFT/INV_FOLLOW_ON_OBJCHAR4 Follow-On Object Created?
WORKFLOW/XFT/INV_WORKFLCHAR4 Workflow created?
NUMBERWF/XFT/INV_NUMBER_WFINT410 Number of Unfinished Workflows
STATUS/XFT/INV_STATUSCHAR10 Status
STATUS_TEXT/XFT/INV_STATUS_TEXTCHAR32 Current Status
SYST_STATUS/XFT/INV_SYST_STATUSCHAR4 System status
CREATE_DATE/XFT/INV_CREATE_DATEDATS8 Creation Date
CREATE_TIME/XFT/INV_CREATE_TIMETIMS6 Creation Time
CHANGE_DATE/XFT/INV_CHANGE_DATEDATS8 Change date
CHANGE_TIME/XFT/INV_CHANGE_TIMETIMS6 Time of change
CHANGE_USER/XFT/USER_CHANGEDCHAR12 Change - User
MESS_EX/XFT/INV_MESSAGE_EXCHAR4 Messages
ITER_NUM_VAL/XFT/INV_ITERATION_NUM_VALINT410 Repeat Counter Validation
ITERATION_NUM/XFT/INV_ITERATION_NUMINT410 Repeat Counter
PROCESS_TYPE_DIS/XFT/INV_PROC_TYPE_DISPCHAR64 Process type
PROCESS_TYPE/XFT/INV_PROC_TYPECHAR32 Process type
PROCESS_TYPE_VAL/XFT/INV_PROC_TYPE_VALCHAR32 Process Type Validation
RECORD_ID/XFT/INV_REC_IDCHAR32 Record ID
TIMESTAMPTIMESTAMPDEC15 UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
DOCUMENTS/XFT/INV_DOC_ID_XMLSTRING Serialized Doc. IDs
DOC_STRUCNAMECHAR64CHAR64 Character field, length 64
MESSAGES/XFT/INV_MESSAGESSTRING Serialized Messages
MESS_STRUCNAMECHAR64CHAR64 Character field, length 64
BARCODE/XFT/INV_BARCODECHAR40 Barcode
REB_COLORCHAR4CHAR4 Not More Closely Defined Area, Possibly Used for Patchlevels
.INCLUDE/XFT/INV_S_MON_APPL Application data that should appear in monitor
INV_DOC_NO/XFT/INV_RE_BELNRCHAR10 Invoice Document Number
INV_DOC_YEAR/XFT/INV_LFGJANUMC4 Fiscal Year of Current PeriodGJAHR
OBJECT_TYPEOJ_NAMECHAR10
*
Object type
MIRO_ICON/XFT/INV_MIRO_ICONCHAR4 PO Reference?
MRM_VORGANG/XFT/MRM_VORGANGCHAR1 Transaction Types for Incoming Invoice
.INCLUDE/XFT/INV_S_HEAD Header data incoming invoice



INVOICE_IND/XFT/XRECHCHAR1 Invoice Indicator
DOC_TYPEBLARTCHAR2
*
Document Type
DOC_DATEBLDATDATS8 Document Date in Document
PSTNG_DATEBUDATDATS8 Posting Date in the Document
REF_DOC_NOXBLNRCHAR16 Reference Document Number
COMP_CODEBUKRSCHAR4
*
Company Code
DIFF_INV/XFT/INV_LIFRECHAR10 Invoicing partyALPHA
CURRENCYWAERSCUKY5
*
Currency Key
CURRENCY_ISOISOCDCHAR3 ISO currency code
GROSS_AMOUNT/XFT/INV_BAPICURR_DDEC23(4) Currency amount
INV_REC_DATE/XFT/REINDATDATS8 Invoice Receipt Date
CALC_TAX_IND/XFT/INV_XMWSTCHAR1 Calculate Tax Automatically?
.INCLUDE/XFT/INV_S_HEAD_ZAHLBED Payment terms
BLINE_DATEDZFBDTDATS8 Baseline Date for Due Date Calculation
PMNTTRMSDZTERMCHAR4 Terms of Payment Key
DSCT_DAYS1DZBD1TDEC3 Cash discount days 1
DSCT_PCT1DZBD1PDEC5(3) Cash Discount Percentage 1
DSCT_DAYS2DZBD2TDEC3 Cash discount days 2
DSCT_PCT2DZBD2PDEC5(3) Cash Discount Percentage 2
NETTERMSDZBD3TDEC3 Net Payment Terms Period
FIXEDTERMS/XFT/INV_DZBFIXCHAR1 Fixed Payment Terms
PMNT_BLOCKDZLSPRCHAR1
*
Payment Block Key
DSCT_AMOUNT/XFT/INV_BAPI_WSKTODEC23(4) Cash discount in document currency
PYMT_METHDZLSCHCHAR1
*
Payment Method
INV_REF_NOAWREF_REBCHAR10 Invoice Reference: Document Number for Invoice ReferenceALPHA
INV_YEAR/XFT/INV_REBZJNUMC4 Fiscal year of related invoice (in case of credit memo)GJAHR
PARTNER_BKBVTYPCHAR4 Partner Bank Type
HOUSEBANKIDHBKIDCHAR5
*
Short Key for a House Bank
.INCLUDE/XFT/INV_S_HEAD_RESERVE Remaining header fields of BAPI structure
EXCH_RATEUKURSPDEC9(5) Direct Quoted Exchange Rate
EXCH_RATE_VUKURSMDEC9(5) Indirect Quoted Exchange Rate
IV_CATEGORY/XFT/INV_IVTYPCHAR1 Origin of a Logistics Invoice Verification Document
DEL_COSTS/XFT/INV_BAPI_BEZNKDEC23(4) Unplanned delivery costs
DEL_COSTS_TAXC/XFT/INV_MWSKZ_BNKCHAR2 Tax code, delivery costs
DEL_COSTS_TAXJ/XFT/INV_TXJCD_BNKCHAR15 Jurisdiction code, delivery costs
PERSON_EXT/XFT/INV_ERNAMECHAR12 Name of creator of external system
PMTMTHSUPLUZAWECHAR2
*
Payment Method Supplement
SCBANK_INDLZBKZCHAR3
*
State Central Bank Indicator
SUPCOUNTRYLANDLCHAR3
*
Supplying Country




BLLSRV_INDDIEKZCHAR1 Service Indicator (Foreign Payment)
REF_DOC_NO_LONGXBLNR_LONGCHAR35 Reference Document Number (for Dependencies see Long Text)
PO_SUB_NOESRNRCHAR11 ISR Subscriber Number
PO_CHECKDGESRPZCHAR2 ISR Check Digit
PO_REF_NOESRRECHAR27 ISR Reference NumberALPHA
PAYEE_PAYER/XFT/INV_EMPFBCHAR10 Payee/PayerALPHA
ALLOC_NMBRDZUONRCHAR18 Assignment Number
PAYMT_REF/XFT/INV_KIDNOCHAR30 Payment Reference
PLANNING_LEVEL/XFT/INV_FDLEVCHAR2 Planning Level
PLANNING_DATE/XFT/INV_FDTAGDATS8 Planning Date
BUS_AREAGSBERCHAR4
*
Business Area
LOT_NUMBER/XFT/INV_LOTKZCHAR10 Bundeling Indicator for Documents
ITEM_TEXTSGTXTCHAR50 Item Text
J_1BNFTYPE/XFT/INV_J_1BNFTYPECHAR2 Nota Fiscal Type
EU_TRIANG_DEAL/XFT/INV_XEGDRCHAR1 Indicator: Triangular Deal within the EU ?
REPCOUNTRY/XFT/INV_EGMLD_BSEZCHAR3
*
Reporting Country for Delivery of Goods within the EU
.INCLUDE/XFT/INV_S_ADR Vendor address data
BU_PARTNERBU_PARTNERCHAR10
*
Business Partner NumberALPHA
ACC_1_TIMEXCPDKCHAR1 Indicator: Is the account a one-time account?
NAMENAME1_GPCHAR35 Name 1
NAME_2NAME2_GPCHAR35 Name 2
NAME_3NAME3_GPCHAR35 Name 3
NAME_4NAME4_GPCHAR35 Name 4
POSTL_CODEPSTLZCHAR10 Postal Code
CITYORT01_GPCHAR35 City
COUNTRYLAND1_GPCHAR3
*
Country Key
STREETSTRAS_GPCHAR35 House number and street
PO_BOXPFACHCHAR10 PO Box
POBX_PCDPSTL2CHAR10 P.O. Box Postal Code
FORM_OF_ADDRANREDCHAR15 Title
LANGUSPRASLANG1
*
Language KeyISOLA
.INCLUDE/XFT/INV_S_ADR_BANK Bank data
POBK_CURACPSKTOCHAR16 Account Number of Bank Account At Post Office
BANK_ACCTBANKNCHAR18 Bank account number
BANK_NOBANKLCHAR15 Bank number
BANK_CTRYBANKSCHAR3
*
Bank country key
CTRL_KEYBKONTCHAR2 Bank Control Key
BANK_REFBKREFCHAR20 Reference specifications for bank details
.INCLUDE/XFT/INV_S_ADR_TAX Tax data


TAX_NO_1STCD1CHAR16 Tax Number 1
TAX_NO_2STCD2CHAR11 Tax Number 2
TAX_NO_3STCD3CHAR18 Tax Number 3
TAX_NO_4STCD4CHAR18 Tax Number 4
SLS_PUR_TXSTKZUCHAR1 Liable for VAT
EQUAL_TAXSTKZACHAR1 Indicator: Business Partner Subject to Equalization Tax?
TAX_CATEGORYJ_1AFITP_DCHAR2
*
Tax type
TAX_NO_TYJ_1ATOIDCHAR2
*
Tax Number Type
SOLE_PROPSTKZNCHAR1 Natural Person
VAT_REG_NOSTCEGCHAR20 VAT Registration Number
.INCLUDE/XFT/INV_S_MON_APPL_CONTROL Control data
.INCLUDE/XFT/INV_S_MON_APPL_CONTROL_C Control data can be changed by user
USER_STATUS/XFT/INV_USER_STATUSCHAR10 User status
PERSON_RESP/XFT/INV_PERSON_RESPCHAR12 Agent
.INCLUDE/XFT/INV_S_MON_APPL_ORG Organizational data for invoice receipt monitor
ORG_UNIT/XFT/INV_ORG_UNITCHAR14 Organizational Unit
DESCRIPTION/XFT/INV_DESCRIPTIONCHAR4 Comment
USER1/XFT/INV_USER_FIELDCHAR128 User Field
USER2/XFT/INV_USER_FIELDCHAR128 User Field
USER3/XFT/INV_USER_FIELDCHAR128 User Field
USER4/XFT/INV_USER_FIELDCHAR128 User Field
USER5/XFT/INV_USER_FIELDCHAR128 User Field
USER6/XFT/INV_USER_FIELDCHAR128 User Field
USER7/XFT/INV_USER_FIELDCHAR128 User Field
USER8/XFT/INV_USER_FIELDCHAR128 User Field
USER9/XFT/INV_USER_FIELDCHAR128 User Field
USER10/XFT/INV_USER_FIELDCHAR128 User Field
USER11/XFT/INV_USER_FIELDCHAR128 User Field
USER12/XFT/INV_USER_FIELDCHAR128 User Field
USER13/XFT/INV_USER_FIELDCHAR128 User Field
USER14/XFT/INV_USER_FIELDCHAR128 User Field
USER15/XFT/INV_USER_FIELDCHAR128 User Field
MIRO/XFT/INV_MIRO_RELCHAR1 Flag: Reference to Purchase Order
REFERENZBELEGTYP/XFT/INV_MRM_REFERENZBELEGTYPCHAR1 Reference Document Category
BLART_FI/XFT/INV_BLART_FICHAR2
*
FI Document Type



Key field
Non-key field