SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Basis Components
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/XFT/INV_Q_S1417Invoice receipt queue: HeaderBasis Components
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PROCESS_ID, INV_TYPE, PROCESS_ID_CHILD, RATING, FOLLOW_ON_DOC, WORKFLOW, NUMBERWF, STATUS, STATUS_TEXT, SYST_STATUS, CREATE_DATE, CREATE_TIME, CHANGE_DATE, CHANGE_TIME, CHANGE_USER, MESS_EX, ITER_NUM_VAL, ITERATION_NUM, PROCESS_TYPE_DIS, PROCESS_TYPE, PROCESS_TYPE_VAL, RECORD_ID, TIMESTAMP, DOCUMENTS, DOC_STRUCNAME, MESSAGES, MESS_STRUCNAME, BARCODE, REB_COLOR, INV_DOC_NO, INV_DOC_YEAR, OBJECT_TYPE, MIRO_ICON, MRM_VORGANG, INVOICE_IND, DOC_TYPE, DOC_DATE, PSTNG_DATE, REF_DOC_NO, COMP_CODE, DIFF_INV, CURRENCY, CURRENCY_ISO, GROSS_AMOUNT, INV_REC_DATE, CALC_TAX_IND, BLINE_DATE, PMNTTRMS, DSCT_DAYS1, DSCT_PCT1, DSCT_DAYS2, DSCT_PCT2, NETTERMS, FIXEDTERMS, PMNT_BLOCK, DSCT_AMOUNT, PYMT_METH, INV_REF_NO, INV_YEAR, PARTNER_BK, HOUSEBANKID, EXCH_RATE, EXCH_RATE_V, IV_CATEGORY, DEL_COSTS, DEL_COSTS_TAXC, DEL_COSTS_TAXJ, PERSON_EXT, PMTMTHSUPL, SCBANK_IND, SUPCOUNTRY, BLLSRV_IND, REF_DOC_NO_LONG, PO_SUB_NO, PO_CHECKDG, PO_REF_NO, PAYEE_PAYER, ALLOC_NMBR, PAYMT_REF, PLANNING_LEVEL, PLANNING_DATE, BUS_AREA, LOT_NUMBER, ITEM_TEXT, J_1BNFTYPE, EU_TRIANG_DEAL, REPCOUNTRY, BU_PARTNER, ACC_1_TIME, NAME, NAME_2, NAME_3, NAME_4, POSTL_CODE, CITY, COUNTRY, STREET, PO_BOX, POBX_PCD, REGION, FORM_OF_ADDR, LANGU, POBK_CURAC, BANK_ACCT, BANK_NO, BANK_CTRY, CTRL_KEY, BANK_REF, TAX_NO_1, TAX_NO_2, TAX_NO_3, TAX_NO_4, SLS_PUR_TX, EQUAL_TAX, TAX_CATEGORY, TAX_NO_TY, SOLE_PROP, VAT_REG_NO, USER_STATUS, PERSON_RESP, ORG_UNIT, DESCRIPTION, USER1, USER2, USER3, USER4, USER5, USER6, USER7, USER8, USER9, USER10, USER11, USER12, USER13, USER14, USER15, MIRO, REFERENZBELEGTYP, BLART_FI FROM /XFT/INV_Q_S
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PROCESS_IDProcess IDnvarchar340CHAR(N' ')No/XFT/DIO_PROCESS_ID Allow NULL? 
3INV_TYPEInvoice Receipt Typenvarchar40CHAR(N' ')Yes/XFT/INV_INV_TYPE Allow NULL? 
4PROCESS_ID_CHILDChild Process IDnvarchar340CHAR(N' ')Yes/XFT/INV_PRO_ID_CHILD Allow NULL? 
5RATINGRatingnvarchar40CHAR(N' ')Yes*/XFT/INV_RATING Allow NULL? 
6FOLLOW_ON_DOCFollow-On Object Created?nvarchar40CHAR(N' ')Yes/XFT/INV_FOLLOW_ON_OBJ Allow NULL? 
7WORKFLOWWorkflow created?nvarchar40CHAR(N' ')Yes/XFT/INV_WORKFL Allow NULL? 
8NUMBERWFNumber of Unfinished Workflowsint100INT4((0))Yes/XFT/INV_NUMBER_WF Allow NULL? 
9STATUSStatusnvarchar100CHAR(N' ')Yes/XFT/INV_STATUS Allow NULL? 
10STATUS_TEXTCurrent Statusnvarchar320CHAR(N' ')Yes/XFT/INV_STATUS_TEXT Allow NULL? 
11SYST_STATUSSystem statusnvarchar40CHAR(N' ')Yes/XFT/INV_SYST_STATUS Allow NULL? 
12CREATE_DATECreation Datenvarchar80DATS(N'00000000')Yes/XFT/INV_CREATE_DATE Allow NULL? 
13CREATE_TIMECreation Timenvarchar60TIMS(N'000000')Yes/XFT/INV_CREATE_TIME Allow NULL? 
14CHANGE_DATEChange datenvarchar80DATS(N'00000000')Yes/XFT/INV_CHANGE_DATE Allow NULL? 
15CHANGE_TIMETime of changenvarchar60TIMS(N'000000')Yes/XFT/INV_CHANGE_TIME Allow NULL? 
16CHANGE_USERChange - Usernvarchar120CHAR(N' ')Yes/XFT/USER_CHANGED Allow NULL? 
17MESS_EXMessagesnvarchar40CHAR(N' ')Yes/XFT/INV_MESSAGE_EX Allow NULL? 
18ITER_NUM_VALRepeat Counter Validationint100INT4((0))Yes/XFT/INV_ITERATION_NUM_VAL Allow NULL? 
19ITERATION_NUMRepeat Counterint100INT4((0))Yes/XFT/INV_ITERATION_NUM Allow NULL? 
20PROCESS_TYPE_DISProcess typenvarchar640CHAR(N' ')Yes/XFT/INV_PROC_TYPE_DISP Allow NULL? 
21PROCESS_TYPEProcess typenvarchar320CHAR(N' ')Yes/XFT/INV_PROC_TYPE Allow NULL? 
22PROCESS_TYPE_VALProcess Type Validationnvarchar320CHAR(N' ')Yes/XFT/INV_PROC_TYPE_VAL Allow NULL? 
23RECORD_IDRecord IDnvarchar320CHAR(N' ')Yes/XFT/INV_REC_ID Allow NULL? 
24TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
25DOCUMENTSSerialized Doc. IDsntext10737418230Yes/XFT/INV_DOC_ID_XML
26DOC_STRUCNAMECharacter field, length 64nvarchar640CHAR(N' ')YesCHAR64 Allow NULL? 
27MESSAGESSerialized Messagesntext10737418230Yes/XFT/INV_MESSAGES
28MESS_STRUCNAMECharacter field, length 64nvarchar640CHAR(N' ')YesCHAR64 Allow NULL? 
29BARCODEBarcodenvarchar400CHAR(N' ')Yes/XFT/INV_BARCODE Allow NULL? 
30REB_COLORNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40CHAR(N' ')YesCHAR4 Allow NULL? 
31INV_DOC_NOInvoice Document Numbernvarchar100CHAR(N' ')Yes/XFT/INV_RE_BELNR Allow NULL? 
32INV_DOC_YEARFiscal Year of Current Periodnvarchar40NUMC(N'0000')Yes/XFT/INV_LFGJA Allow NULL? 
33OBJECT_TYPEObject typenvarchar100CHAR(N' ')Yes*OJ_NAME Allow NULL? 
34MIRO_ICONPO Reference?nvarchar40CHAR(N' ')Yes/XFT/INV_MIRO_ICON Allow NULL? 
35MRM_VORGANGTransaction Types for Incoming Invoicechar10CHAR(N' ')Yes/XFT/MRM_VORGANG Allow NULL? 
36INVOICE_INDInvoice Indicatorchar10CHAR(N' ')Yes/XFT/XRECH Allow NULL? 
37DOC_TYPEDocument Typenvarchar20CHAR(N' ')Yes*BLART Allow NULL? 
38DOC_DATEDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
39PSTNG_DATEPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
40REF_DOC_NOReference Document Numbernvarchar160CHAR(N' ')YesXBLNR Allow NULL? 
41COMP_CODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
42DIFF_INVInvoicing partynvarchar100CHAR(N' ')Yes/XFT/INV_LIFRE Allow NULL? 
43CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
44CURRENCY_ISOISO currency codenvarchar30CHAR(N' ')YesISOCD Allow NULL? 
45GROSS_AMOUNTCurrency amountdecimal234DEC((0))Yes/XFT/INV_BAPICURR_D
46INV_REC_DATEInvoice Receipt Datenvarchar80DATS(N'00000000')Yes/XFT/REINDAT Allow NULL? 
47CALC_TAX_INDCalculate Tax Automatically?char10CHAR(N' ')Yes/XFT/INV_XMWST Allow NULL? 
48BLINE_DATEBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
49PMNTTRMSTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
50DSCT_DAYS1Cash discount days 1decimal30DEC((0))YesDZBD1T
51DSCT_PCT1Cash Discount Percentage 1decimal53DEC((0))YesDZBD1P
52DSCT_DAYS2Cash discount days 2decimal30DEC((0))YesDZBD2T
53DSCT_PCT2Cash Discount Percentage 2decimal53DEC((0))YesDZBD2P
54NETTERMSNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
55FIXEDTERMSFixed Payment Termschar10CHAR(N' ')Yes/XFT/INV_DZBFIX Allow NULL? 
56PMNT_BLOCKPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
57DSCT_AMOUNTCash discount in document currencydecimal234DEC((0))Yes/XFT/INV_BAPI_WSKTO
58PYMT_METHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
59INV_REF_NOInvoice Reference: Document Number for Invoice Referencenvarchar100CHAR(N' ')YesAWREF_REB Allow NULL? 
60INV_YEARFiscal year of related invoice (in case of credit memo)nvarchar40NUMC(N'0000')Yes/XFT/INV_REBZJ Allow NULL? 
61PARTNER_BKPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
62HOUSEBANKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
63EXCH_RATEDirect Quoted Exchange Ratedecimal95DEC((0))YesUKURSP
64EXCH_RATE_VIndirect Quoted Exchange Ratedecimal95DEC((0))YesUKURSM
65IV_CATEGORYOrigin of a Logistics Invoice Verification Documentchar10CHAR(N' ')Yes/XFT/INV_IVTYP Allow NULL? 
66DEL_COSTSUnplanned delivery costsdecimal234DEC((0))Yes/XFT/INV_BAPI_BEZNK
67DEL_COSTS_TAXCTax code, delivery costsnvarchar20CHAR(N' ')Yes/XFT/INV_MWSKZ_BNK Allow NULL? 
68DEL_COSTS_TAXJJurisdiction code, delivery costsnvarchar150CHAR(N' ')Yes/XFT/INV_TXJCD_BNK Allow NULL? 
69PERSON_EXTName of creator of external systemnvarchar120CHAR(N' ')Yes/XFT/INV_ERNAME Allow NULL? 
70PMTMTHSUPLPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
71SCBANK_INDState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
72SUPCOUNTRYSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
73BLLSRV_INDService Indicator (Foreign Payment)char10CHAR(N' ')YesDIEKZ Allow NULL? 
74REF_DOC_NO_LONGReference Document Number (for Dependencies see Long Text)nvarchar350CHAR(N' ')YesXBLNR_LONG Allow NULL? 
75PO_SUB_NOISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
76PO_CHECKDGISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
77PO_REF_NOISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
78PAYEE_PAYERPayee/Payernvarchar100CHAR(N' ')Yes/XFT/INV_EMPFB Allow NULL? 
79ALLOC_NMBRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
80PAYMT_REFPayment Referencenvarchar300CHAR(N' ')Yes/XFT/INV_KIDNO Allow NULL? 
81PLANNING_LEVELPlanning Levelnvarchar20CHAR(N' ')Yes/XFT/INV_FDLEV Allow NULL? 
82PLANNING_DATEPlanning Datenvarchar80DATS(N'00000000')Yes/XFT/INV_FDTAG Allow NULL? 
83BUS_AREABusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
84LOT_NUMBERBundeling Indicator for Documentsnvarchar100CHAR(N' ')Yes/XFT/INV_LOTKZ Allow NULL? 
85ITEM_TEXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
86J_1BNFTYPENota Fiscal Typenvarchar20CHAR(N' ')Yes/XFT/INV_J_1BNFTYPE Allow NULL? 
87EU_TRIANG_DEALIndicator: Triangular Deal within the EU ?char10CHAR(N' ')Yes/XFT/INV_XEGDR Allow NULL? 
88REPCOUNTRYReporting Country for Delivery of Goods within the EUnvarchar30CHAR(N' ')Yes*/XFT/INV_EGMLD_BSEZ Allow NULL? 
89BU_PARTNERBusiness Partner Numbernvarchar100CHAR(N' ')Yes*BU_PARTNER Allow NULL? 
90ACC_1_TIMEIndicator: Is the account a one-time account?char10CHAR(N' ')YesXCPDK Allow NULL? 
91NAMEName 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
92NAME_2Name 2nvarchar350CHAR(N' ')YesNAME2_GP Allow NULL? 
93NAME_3Name 3nvarchar350CHAR(N' ')YesNAME3_GP Allow NULL? 
94NAME_4Name 4nvarchar350CHAR(N' ')YesNAME4_GP Allow NULL? 
95POSTL_CODEPostal Codenvarchar100CHAR(N' ')YesPSTLZ Allow NULL? 
96CITYCitynvarchar350CHAR(N' ')YesORT01_GP Allow NULL? 
97COUNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1_GP Allow NULL? 
98STREETHouse number and streetnvarchar350CHAR(N' ')YesSTRAS_GP Allow NULL? 
99PO_BOXPO Boxnvarchar100CHAR(N' ')YesPFACH Allow NULL? 
100POBX_PCDP.O. Box Postal Codenvarchar100CHAR(N' ')YesPSTL2 Allow NULL? 
101REGIONRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
102FORM_OF_ADDRTitlenvarchar150CHAR(N' ')YesANRED Allow NULL? 
103LANGULanguage Keychar10LANG(N' ')Yes*SPRAS Allow NULL? 
104POBK_CURACAccount Number of Bank Account At Post Officenvarchar160CHAR(N' ')YesPSKTO Allow NULL? 
105BANK_ACCTBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
106BANK_NOBank numbernvarchar150CHAR(N' ')YesBANKL Allow NULL? 
107BANK_CTRYBank country keynvarchar30CHAR(N' ')Yes*BANKS Allow NULL? 
108CTRL_KEYBank Control Keynvarchar20CHAR(N' ')YesBKONT Allow NULL? 
109BANK_REFReference specifications for bank detailsnvarchar200CHAR(N' ')YesBKREF Allow NULL? 
110TAX_NO_1Tax Number 1nvarchar160CHAR(N' ')YesSTCD1 Allow NULL? 
111TAX_NO_2Tax Number 2nvarchar110CHAR(N' ')YesSTCD2 Allow NULL? 
112TAX_NO_3Tax Number 3nvarchar180CHAR(N' ')YesSTCD3 Allow NULL? 
113TAX_NO_4Tax Number 4nvarchar180CHAR(N' ')YesSTCD4 Allow NULL? 
114SLS_PUR_TXLiable for VATchar10CHAR(N' ')YesSTKZU Allow NULL? 
115EQUAL_TAXIndicator: Business Partner Subject to Equalization Tax?char10CHAR(N' ')YesSTKZA Allow NULL? 
116TAX_CATEGORYTax typenvarchar20CHAR(N' ')Yes*J_1AFITP_D Allow NULL? 
117TAX_NO_TYTax Number Typenvarchar20CHAR(N' ')Yes*J_1ATOID Allow NULL? 
118SOLE_PROPNatural Personchar10CHAR(N' ')YesSTKZN Allow NULL? 
119VAT_REG_NOVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
120USER_STATUSUser statusnvarchar100CHAR(N' ')Yes/XFT/INV_USER_STATUS Allow NULL? 
121PERSON_RESPAgentnvarchar120CHAR(N' ')Yes/XFT/INV_PERSON_RESP Allow NULL? 
122ORG_UNITOrganizational Unitnvarchar140CHAR(N' ')Yes/XFT/INV_ORG_UNIT Allow NULL? 
123DESCRIPTIONCommentnvarchar40CHAR(N' ')Yes/XFT/INV_DESCRIPTION Allow NULL? 
124USER1User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
125USER2User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
126USER3User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
127USER4User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
128USER5User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
129USER6User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
130USER7User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
131USER8User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
132USER9User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
133USER10User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
134USER11User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
135USER12User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
136USER13User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
137USER14User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
138USER15User Fieldnvarchar1280CHAR(N' ')Yes/XFT/INV_USER_FIELD Allow NULL? 
139MIROFlag: Reference to Purchase Orderchar10CHAR(N' ')Yes/XFT/INV_MIRO_REL Allow NULL? 
140REFERENZBELEGTYPReference Document Categorychar10CHAR(N' ')Yes/XFT/INV_MRM_REFERENZBELEGTYP Allow NULL? 
141BLART_FIFI Document Typenvarchar20CHAR(N' ')Yes*/XFT/INV_BLART_FI Allow NULL? 
NamePrimaryUniqueTypeColumns
/XFT/INV_Q_S~0YesYesCLUSTEREDPROCESS_ID, MANDT
/XFT/INV_Q_S~IN1NoNoNONCLUSTEREDINV_DOC_YEAR, INV_DOC_NO, COMP_CODE, MANDT
/XFT/INV_Q_S~IN3NoNoNONCLUSTEREDCOMP_CODE, INV_DOC_YEAR, INV_DOC_NO, MANDT
/XFT/INV_Q_S~IN4NoNoNONCLUSTEREDPERSON_RESP, MANDT
/XFT/INV_Q_S~IN5NoNoNONCLUSTEREDOBJECT_TYPE, MANDT
/XFT/INV_Q_S~IN6NoNoNONCLUSTEREDPROCESS_ID_CHILD, MANDT
/XFT/INV_Q_S~IN8NoNoNONCLUSTEREDDIFF_INV, REF_DOC_NO, DOC_DATE, MANDT