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

Home | ERP 6.0  | FEBKO
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
Financials :: Financial Supply Chain Management :: Cash and Liquidity Management :: Cash Management :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FEBKO612Electronic Bank Statement Header RecordsBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, ANWND, ABSND, AZIDT, EMKEY, KUKEY, ASTAT, DSTAT, VB1OK, VB2OK, KIPRE, VFDAT, GRP01, XKEP1, GRP02, XKEP2, WVDAT, WVTIM, WVART, HKONT, KTONR, KTOIH, KTOSB, AZNUM, AZSNR, AZDAT, BUKRS, KTOPL, WAERS, SSTYP, SSVOZ, SSBTR, SUMSO, SUMHA, ESTYP, ESVOZ, ESBTR, ESDMB, BLAUF, ELAUF, HZINS, TEILN, BKTOA, ANZES, VGTYP, EFART, HBKID, HKTID, EUSER, EDATE, ETIME, BKREF, XFDIS, DSART, XVERD, XBENR, XBTYP, SEQ_NUMBER, SEQ_STATUS, INPUT_FORMAT, SIBAN FROM FEBKO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ANWNDApplication using bank data storagenvarchar40CHAR(N' ')NoANWND_EBKO Allow NULL? 
3ABSNDSending bank (electronic bank statement)nvarchar500CHAR(N' ')NoABSND_EB Allow NULL? 
4AZIDTBank statement identificationnvarchar200CHAR(N' ')NoAZIDT_EB Allow NULL? 
5EMKEYPayee Keysnvarchar200CHAR(N' ')NoEMKEY_EB Allow NULL? 
6KUKEYShort key (surrogate)nvarchar80NUMC(N'00000000')YesKUKEY_EB Allow NULL? 
7ASTATStatement statuschar10CHAR(N' ')YesASTAT_EB Allow NULL? 
8DSTATPrint statuschar10CHAR(N' ')YesDSTAT_EB Allow NULL? 
9VB1OKAll postings in area 1 are OKchar10CHAR(N' ')YesVB1OK_EBKO Allow NULL? 
10VB2OKAll postings in area 2 are OKchar10CHAR(N' ')YesVB2OK_EBKO Allow NULL? 
11KIPREAll items on header record were interpretedchar10CHAR(N' ')YesKIPRE_EB Allow NULL? 
12VFDATData expiry datenvarchar80DATS(N'00000000')YesVFDAT_EB Allow NULL? 
13GRP01Session name for bank postingsnvarchar120CHAR(N' ')YesGRP01_EB Allow NULL? 
14XKEP1Keep session 1 after processingchar10CHAR(N' ')YesXKEP1_EB Allow NULL? 
15GRP02Session name for subledger accountingnvarchar120CHAR(N' ')YesGRP02_EB Allow NULL? 
16XKEP2Keep session 2 after processingchar10CHAR(N' ')YesXKEP2_EB Allow NULL? 
17WVDATFurther processing datenvarchar80DATS(N'00000000')YesWVDAT_EB Allow NULL? 
18WVTIMFurther processing timenvarchar60TIMS(N'000000')YesWVTIM_EB Allow NULL? 
19WVARTFurther processing typechar10CHAR(N' ')YesWVART_EB Allow NULL? 
20HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKB1HKONT Allow NULL? 
21KTONRBank account numbernvarchar180CHAR(N' ')YesBANKN Allow NULL? 
22KTOIHBank account holdernvarchar350CHAR(N' ')YesKTOIH_EB Allow NULL? 
23KTOSBSpecial account namenvarchar350CHAR(N' ')YesKTOSB_EB Allow NULL? 
24AZNUMStatement numbernvarchar50NUMC(N'00000')YesAZNUM_EB Allow NULL? 
25AZSNRStatement page numbernvarchar30NUMC(N'000')YesAZSNR_EB Allow NULL? 
26AZDATStatement Datenvarchar80DATS(N'00000000')YesAZDAT_EB Allow NULL? 
27BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
28KTOPLChart of Accountsnvarchar40CHAR(N' ')YesT004KTOPL Allow NULL? 
29WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
30SSTYPBeginning balance type (F=begin balance, M=interim balance)char10CHAR(N' ')YesSSTYP_EB Allow NULL? 
31SSVOZStarting balance +/- signchar10CHAR(N' ')YesSSVOZ_EB Allow NULL? 
32SSBTROpening balance amountdecimal172CURR((0))YesSSBTR_EB
33SUMSOTotal Debitdecimal172CURR((0))YesSUMSO_EB
34SUMHATotal Creditdecimal172CURR((0))YesSUMHA_EB
35ESTYPEnding balance type (F=ending balance, M=interim balance)char10CHAR(N' ')YesESTYP_EB Allow NULL? 
36ESVOZClosing balance +/- signchar10CHAR(N' ')YesESVOZ_EB Allow NULL? 
37ESBTREnding balance amountdecimal172CURR((0))YesESBTR_EB
38ESDMBEnding balance equivalent in local currencydecimal172CURR((0))YesESDMB_EB
39BLAUFLife startnvarchar80DATS(N'00000000')YesBLAUF_EB Allow NULL? 
40ELAUFLife endnvarchar80DATS(N'00000000')YesELAUF_EB Allow NULL? 
41HZINSCredit interestdecimal93DEC((0))YesHZINS_EB
42TEILNCustomer/vendor EB numbernvarchar200CHAR(N' ')YesTEILN_EB Allow NULL? 
43BKTOABank account typenvarchar230CHAR(N' ')YesBKTOA_EB Allow NULL? 
44ANZESNumber of memo records from the bank statementnvarchar50NUMC(N'00000')YesANZES_EB Allow NULL? 
45VGTYPTransaction typenvarchar80CHAR(N' ')Yes*VGTYP_EB Allow NULL? 
46EFARTInput Typechar10CHAR(N' ')YesEFART_EB Allow NULL? 
47HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
48HKTIDID for account detailsnvarchar50CHAR(N' ')Yes*HKTID Allow NULL? 
49EUSERUser who fills the bank data buffernvarchar120CHAR(N' ')YesEUSER_EB Allow NULL? 
50EDATEImport date into bank data puffernvarchar80DATS(N'00000000')YesEDATE_EB Allow NULL? 
51ETIMEImport time into bank data buffernvarchar60TIMS(N'000000')YesETIME_EB Allow NULL? 
52BKREFReference specifications for bank detailsnvarchar200CHAR(N' ')YesBKREF Allow NULL? 
53XFDISX - cash management payment advice notes were createdchar10CHAR(N' ')YesXFDIS_EB Allow NULL? 
54DSARTPlanning typenvarchar20CHAR(N' ')Yes*DSART Allow NULL? 
55XVERDSummarize bank statement itemschar10CHAR(N' ')YesFFDISXVERD Allow NULL? 
56XBENRReference Keynvarchar200CHAR(N' ')YesAWKEY Allow NULL? 
57XBTYPReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
58SEQ_NUMBERBank statement sequential numbernvarchar40NUMC(N'0000')YesSEQ_NUMBER Allow NULL? 
59SEQ_STATUSSequence statuschar10CHAR(N' ')YesSEQ_STATUS Allow NULL? 
60INPUT_FORMATInput formatnvarchar20CHAR(N' ')YesINPUT_FORMAT Allow NULL? 
61SIBANSender Bank Account: IBANnvarchar340CHAR(N' ')YesSIBAN_EB Allow NULL? 
NamePrimaryUniqueTypeColumns
FEBKO~0YesYesCLUSTEREDEMKEY, AZIDT, ABSND, ANWND, MANDT
FEBKO~1NoYesNONCLUSTEREDKUKEY, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy