/XFT/INV_Q_S SAP (Invoice receipt queue: Header) Table details

Dictionary Type: Table
Description: Invoice receipt queue: Header




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




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
PROCESS_IDProcess ID /XFT/DIO_PROCESS_IDCHAR34/XFT/DIO_ID
INV_TYPEInvoice Receipt Type /XFT/INV_INV_TYPECHAR4CHAR4/XFT/INV_INV_TYPE
PROCESS_ID_CHILDChild Process ID /XFT/INV_PRO_ID_CHILDCHAR34/XFT/DIO_ID
RATINGRating /XFT/INV_RATINGCHAR4Assigned to domain/XFT/INV_RATING
FOLLOW_ON_DOCFollow-On Object Created? /XFT/INV_FOLLOW_ON_OBJCHAR4/XFT/INV_FOLLOW_ON_OBJ
WORKFLOWWorkflow created? /XFT/INV_WORKFLCHAR4/XFT/INV_WORKFLOW
NUMBERWFNumber of Unfinished Workflows /XFT/INV_NUMBER_WFINT410INT4
STATUSStatus /XFT/INV_STATUSCHAR10/XFT/INV_STATUS
STATUS_TEXTCurrent Status /XFT/INV_STATUS_TEXTCHAR32TEXT32
SYST_STATUSSystem status /XFT/INV_SYST_STATUSCHAR4/XFT/INV_SYST_STATUS
CREATE_DATECreation Date /XFT/INV_CREATE_DATEDATS8DATS
CREATE_TIMECreation Time /XFT/INV_CREATE_TIMETIMS6UZEIT
CHANGE_DATEChange date /XFT/INV_CHANGE_DATEDATS8DATS
CHANGE_TIMETime of change /XFT/INV_CHANGE_TIMETIMS6UZEIT
CHANGE_USERChange - User /XFT/USER_CHANGEDCHAR12USERNAME
MESS_EXMessages /XFT/INV_MESSAGE_EXCHAR4/XFT/INV_MESSAGE_EX
ITER_NUM_VALRepeat Counter Validation /XFT/INV_ITERATION_NUM_VALINT410INT4
ITERATION_NUMRepeat Counter /XFT/INV_ITERATION_NUMINT410INT4
PROCESS_TYPE_DISProcess type /XFT/INV_PROC_TYPE_DISPCHAR64TEXT64
PROCESS_TYPEProcess type /XFT/INV_PROC_TYPECHAR32CHAR32/XFT/INV_PRO_TYPE_ID
PROCESS_TYPE_VALProcess Type Validation /XFT/INV_PROC_TYPE_VALCHAR32CHAR32/XFT/INV_PRO_TYPE_ID
RECORD_IDRecord ID /XFT/INV_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DOCUMENTSSerialized Doc. IDs /XFT/INV_DOC_ID_XMLSTRG0
DOC_STRUCNAMECharacter field, length 64 CHAR64CHAR64CHAR64
MESSAGESSerialized Messages /XFT/INV_MESSAGESSTRG0
MESS_STRUCNAMECharacter field, length 64 CHAR64CHAR64CHAR64
BARCODEBarcode /XFT/INV_BARCODECHAR40CHAR40
REB_COLORNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
INV_DOC_NOInvoice Document Number /XFT/INV_RE_BELNRCHAR10CHAR10
INV_DOC_YEARFiscal Year of Current Period /XFT/INV_LFGJANUMC4GJAHRGJAHR
OBJECT_TYPEObject type OJ_NAMECHAR10Assigned to domainOJ_NAME
MIRO_ICONPO Reference? /XFT/INV_MIRO_ICONCHAR4/XFT/INV_MIRO_ICON
MRM_VORGANGTransaction Types for Incoming Invoice /XFT/MRM_VORGANGCHAR1/XFT/MRM_VORGANG
INVOICE_INDInvoice Indicator /XFT/XRECHCHAR1/XFT/BOOLEAN
DOC_TYPEDocument Type BLARTCHAR2Assigned to domainBLARTBAR
DOC_DATEDocument Date in Document BLDATDATS8DATUM
PSTNG_DATEPosting Date in the Document BUDATDATS8DATUM
REF_DOC_NOReference Document Number XBLNRCHAR16XBLNR
COMP_CODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
DIFF_INVInvoicing party /XFT/INV_LIFRECHAR10ALPHA/XFT/INV_LIFRE
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
CURRENCY_ISOISO currency code ISOCDCHAR3ISOCD
GROSS_AMOUNTCurrency amount /XFT/INV_BAPICURR_DDEC23(4) BAPICURR
INV_REC_DATEInvoice Receipt Date /XFT/REINDATDATS8DATS
CALC_TAX_INDCalculate Tax Automatically? /XFT/INV_XMWSTCHAR1XFELD
BLINE_DATEBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
PMNTTRMSTerms of Payment Key DZTERMCHAR4ZTERM
DSCT_DAYS1Cash discount days 1 DZBD1TDEC3ZBDXT
DSCT_PCT1Cash Discount Percentage 1 DZBD1PDEC5(3) PRZ23
DSCT_DAYS2Cash discount days 2 DZBD2TDEC3ZBDXT
DSCT_PCT2Cash Discount Percentage 2 DZBD2PDEC5(3) PRZ23
NETTERMSNet Payment Terms Period DZBD3TDEC3ZBDXT
FIXEDTERMSFixed Payment Terms /XFT/INV_DZBFIXCHAR1/XFT/INV_DZBFIX
PMNT_BLOCKPayment Block Key DZLSPRCHAR1Assigned to domainZAHLSSPE
DSCT_AMOUNTCash discount in document currency /XFT/INV_BAPI_WSKTODEC23(4) BAPICURR
PYMT_METHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
INV_REF_NOInvoice Reference: Document Number for Invoice Reference AWREF_REBCHAR10ALPHAAWREF
INV_YEARFiscal year of related invoice (in case of credit memo) /XFT/INV_REBZJNUMC4GJAHRGJAHR
PARTNER_BKPartner Bank Type BVTYPCHAR4BVTYP
HOUSEBANKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
EXCH_RATEDirect Quoted Exchange Rate UKURSPDEC9(5) PKURS
EXCH_RATE_VIndirect Quoted Exchange Rate UKURSMDEC9(5) PKURS
IV_CATEGORYOrigin of a Logistics Invoice Verification Document /XFT/INV_IVTYPCHAR1/XFT/IVTYP
DEL_COSTSUnplanned delivery costs /XFT/INV_BAPI_BEZNKDEC23(4) BAPICURR
DEL_COSTS_TAXCTax code, delivery costs /XFT/INV_MWSKZ_BNKCHAR2CHAR2
DEL_COSTS_TAXJJurisdiction code, delivery costs /XFT/INV_TXJCD_BNKCHAR15CHAR15
PERSON_EXTName of creator of external system /XFT/INV_ERNAMECHAR12CHAR12
PMTMTHSUPLPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
SCBANK_INDState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
SUPCOUNTRYSupplying Country LANDLCHAR3Assigned to domainLAND1
BLLSRV_INDService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
REF_DOC_NO_LONGReference Document Number (for Dependencies see Long Text) XBLNR_LONGCHAR35XBLNR_LONG
PO_SUB_NOISR Subscriber Number ESRNRCHAR11ESRNR
PO_CHECKDGISR Check Digit ESRPZCHAR2CHAR2
PO_REF_NOISR Reference Number ESRRECHAR27ALPHAESRRE
PAYEE_PAYERPayee/Payer /XFT/INV_EMPFBCHAR10ALPHAMAXKK
ALLOC_NMBRAssignment Number DZUONRCHAR18ZUONR
PAYMT_REFPayment Reference /XFT/INV_KIDNOCHAR30CHAR30
PLANNING_LEVELPlanning Level /XFT/INV_FDLEVCHAR2CHAR2
PLANNING_DATEPlanning Date /XFT/INV_FDTAGDATS8DATUM
BUS_AREABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
LOT_NUMBERBundeling Indicator for Documents /XFT/INV_LOTKZCHAR10CHAR10
ITEM_TEXTItem Text SGTXTCHAR50TEXT50
J_1BNFTYPENota Fiscal Type /XFT/INV_J_1BNFTYPECHAR2CHAR2
EU_TRIANG_DEALIndicator: Triangular Deal within the EU ? /XFT/INV_XEGDRCHAR1XFELD
REPCOUNTRYReporting Country for Delivery of Goods within the EU /XFT/INV_EGMLD_BSEZCHAR3Assigned to domainLAND1
BU_PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
ACC_1_TIMEIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
NAMEName 1 NAME1_GPCHAR35NAME
NAME_2Name 2 NAME2_GPCHAR35NAME
NAME_3Name 3 NAME3_GPCHAR35NAME
NAME_4Name 4 NAME4_GPCHAR35NAME
POSTL_CODEPostal Code PSTLZCHAR10PSTLZ
CITYCity ORT01_GPCHAR35TEXT35
COUNTRYCountry Key LAND1_GPCHAR3Assigned to domainLAND1C_LAND1
STREETHouse number and street STRAS_GPCHAR35TEXT35
PO_BOXPO Box PFACHCHAR10PFACH
POBX_PCDP.O. Box Postal Code PSTL2CHAR10PSTLZ
REGIONSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
FORM_OF_ADDRTitle ANREDCHAR15TEXT15
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
POBK_CURACAccount Number of Bank Account At Post Office PSKTOCHAR16PSKTO
BANK_ACCTBank account number BANKNCHAR18BANKN
BANK_NOBank number BANKLCHAR15BANKLBLZ
BANK_CTRYBank country key BANKSCHAR3Assigned to domainLAND1BKL
CTRL_KEYBank Control Key BKONTCHAR2BKONT
BANK_REFReference specifications for bank details BKREFCHAR20CHAR20
TAX_NO_1Tax Number 1 STCD1CHAR16STCD1
TAX_NO_2Tax Number 2 STCD2CHAR11STCD2
TAX_NO_3Tax Number 3 STCD3CHAR18CHAR18
TAX_NO_4Tax Number 4 STCD4CHAR18CHAR18
SLS_PUR_TXLiable for VAT STKZUCHAR1XFELD
EQUAL_TAXIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
TAX_CATEGORYTax type J_1AFITP_DCHAR2Assigned to domainJ_1AFITP
TAX_NO_TYTax Number Type J_1ATOIDCHAR2Assigned to domainJ_1ATOID
SOLE_PROPNatural Person STKZNCHAR1STKZN
VAT_REG_NOVAT Registration Number STCEGCHAR20STCEG
USER_STATUSUser status /XFT/INV_USER_STATUSCHAR10CHAR10/XFT/INV_USER_STATUS
PERSON_RESPAgent /XFT/INV_PERSON_RESPCHAR12USERNAME
ORG_UNITOrganizational Unit /XFT/INV_ORG_UNITCHAR14HROBJEC_14
DESCRIPTIONComment /XFT/INV_DESCRIPTIONCHAR4CHAR4
USER1User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER2User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER3User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER4User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER5User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER6User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER7User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER8User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER9User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER10User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER11User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER12User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER13User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER14User Field /XFT/INV_USER_FIELDCHAR128TEXT128
USER15User Field /XFT/INV_USER_FIELDCHAR128TEXT128
MIROFlag: Reference to Purchase Order /XFT/INV_MIRO_RELCHAR1/XFT/INV_MIRO_FLAG
REFERENZBELEGTYPReference Document Category /XFT/INV_MRM_REFERENZBELEGTYPCHAR1/XFT/INV_MRM_REFERENZBELEGTYP
BLART_FIFI Document Type /XFT/INV_BLART_FICHAR2Assigned to domainBLART

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 table
DATA: 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 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!