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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

75 columns | Print definition?ERP 6.0  | BKTXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ARBA/AN_ISUINVTemp table for BTE ISU9BKTXTDocument Header Textnvarchar250
2/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items145BKTXTnvarchar250
3/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact145BKTXTnvarchar250
4/BIC/B0000170000PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta62BKTXTnvarchar250
5/CEECV/BEFI_VATDVAT Report Estonia - document processed from RFUMSV0020BKTXTDocument Header Textnvarchar250
6BBP_RBKPDocument Header: Invoice Receipt31BKTXTDocument Header Textnvarchar250
7FIAPSAD_ADP_HDEmployee's Advance Payment Request Header Data17BKTXTAdvance Payment Request: Descriptionnvarchar1500
8FIAPSAD_ORDR_HDOrder Number Header KSA20BKTXTExpenditure Order Header Textnvarchar1000
9FIEUD_FIDOC_HSAFT: FI Transaction Document Header49BKTXTDocument Header Textnvarchar250
10FUDT_VDOCBKPFVerification Document Header21BKTXTDocument Header Textnvarchar250
11FUDT_VDOCBKPFHVerification Document Header(History)21BKTXTDocument Header Textnvarchar250
12GLPOS_C_CTFI Document: Entry View58BKTXTDocument Header Textnvarchar250
13GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items58BKTXTDocument Header Textnvarchar250
14GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items58BKTXTDocument Header Textnvarchar250
15GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items58BKTXTDocument Header Textnvarchar250
16GLPOS_N_CTNew General Ledger: Line Item with Currency Type58BKTXTDocument Header Textnvarchar250
17GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type58BKTXTDocument Header Textnvarchar250
18IDCN_3RFF4ADJDOCAdjustment Document Header18BKTXTDocument Header Textnvarchar250
19J_1UF_CONTRREFContract Summary Voucher Reference Documents6BKTXTDocument Header Textnvarchar250
20J_1UF_ORD_IN_TAXOrder data used in tax vouchers and corrections21BKTXTDocument Header Textnvarchar250
21J_1UF_REEI_XML_AXML table for J_1UF_REEI with User11BKTXTHeader Textnvarchar250
22J_1UF_REP_XMLXML table for J_1UF_REP10BKTXTHeader Textnvarchar250
23J_1UF_REP_XML_AXML table for J_1UF_REEI with User11BKTXTHeader Textnvarchar250
24J_1UF_TAX_POSExtended data of tax document positions3BKTXTDocument Header Textnvarchar250
25MEV_D_AD_ROOTPeriod-End Valuation: Accruals Document Root14BKTXTDocument Header Textnvarchar250
TOPAccounting Interface
26GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)14BKTXTDocument Header Textnvarchar250
27GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)14BKTXTDocument Header Textnvarchar250
TOPActual CostingMaterial Ledger
28MLHDMaterial Ledger Document: Header20BKTXTDocument Header Textnvarchar250
TOPAlternative Valuation Run
29CKMLAVRDOCClosing Document for Cumulation12BKTXTDocument Header Textnvarchar250
TOPBalance Sheet Valuation Procedures
30MYLAUFCUSTCustomizing for Balance Sheet Valuation Delta Run by Account7BKTXTDocument Header Textnvarchar250
31MYLAUFHDRun for Balance Sheet Values by Account8BKTXTDocument Header Textnvarchar250
TOPBasic Functions
32TINSOFailed Payment Transactions and Charges18BKTXTDocument Header Textnvarchar250
TOPBasis Components
33ZDS400_BKPFBelegkopf für Buchhaltung21BKTXTBelegkopftextnvarchar250
TOPClinical System
34N2BERKATIS-H*MED: Authorization Category4BKTXTDescription of Authorization Categorynvarchar600
TOPCross-Application Components
35BKKPFAccounting document header21BKTXTDocument Header Textnvarchar250
TOPCustomizing Tools Techniques
36ZC003Conversion set2BKTXTDocument Header Textnvarchar250
TOPData Retention Tool
37TXW_S_BKPFRetrieve BKPF from archive16BKTXTDocument Header Textnvarchar250
38TXW_S_MKPFRetrieve MKPF from archive16BKTXTDocument Header Textnvarchar250
TOPDownstream
39OIGSJ1BHBrazilian Taxes for Delivery Header7BKTXTDocument Header Textnvarchar250
TOPExternal Services
40ESSRService Entry Sheet Header Data36BKTXTDocument Header Textnvarchar250
TOPFinancial Accounting
41/OPT/VIM_1HEADDocument Header81BKTXTDocument Header Textnvarchar250
42ACCTHDCompressed Data from FI/CO Document - Header11BKTXTDocument Header Textnvarchar250
43BKPFAccounting Document Header21BKTXTDocument Header Textnvarchar250
44EBKPFFin.Accntng Doc.Header (of Docs from Extern.Systems)19BKTXTDocument Header Textnvarchar250
45J_1GJOURNAL1Journals20BKTXTDocument Header Textnvarchar250
46J_1UF_REEI_XMLXML table for J_1UF_REEI10BKTXTHeader Textnvarchar250
47J_3KNA14_PRIMControl of field remark in foreign payment order5BKTXTDocument header textnvarchar10
48VBKPFDocument Header for Document Parking20BKTXTDocument Header Textnvarchar250
TOPFunds Management
49FMIFIHDFI Header Table in Funds Management9BKTXTDocument Header Textnvarchar250
50FMINVPAYFurther document to be posted6BKTXTDocument Header Textnvarchar250
TOPFunds Management-Specific Postings
51PSOKPFRecurring Request Document Header21BKTXTDocument Header Textnvarchar250
TOPGeneral Ledger Accounting
52BKPF_ADDAccounting Document Header21BKTXTDocument Header Textnvarchar250
TOPGermany
53T5D4MOfficial Social Insurance Key6BKTXTDiffering Name of Key for Federal Miner's Insurancenvarchar400
TOPInformation System
54DKKOPBalance Audit Trail26BKTXTDocument Header Textnvarchar250
55DKOKPOpen Item Account Balance Audit Trail29BKTXTDocument Header Textnvarchar250
56DSKOPBalance Audit Trail25BKTXTDocument Header Textnvarchar250
TOPInventory Management
57MKPFHeader: Material Document15BKTXTDocument Header Textnvarchar250
58MWMKPFHeader Table for the Interface15BKTXTDocument Header Textnvarchar250
TOPInvoice Verification
59RBKPDocument Header: Invoice Receipt31BKTXTDocument Header Textnvarchar250
TOPJapan
60T5J76HR Santei/Geppen Form remarks column text JP4BKTXTSantei/Geppen Form Remark Textnvarchar240
TOPLoans Management
61VDZNB_HEADPmnt Postproc.: Header for a Payment Postprocessing Activity6BKTXTDocument Header Textnvarchar250
TOPLocalization
62IDEU_VATEU VAT Posting25BKTXTDocument Header Textnvarchar250
63J_1IRAINHDRArticle Inward Note Header10BKTXTDocument Header Textnvarchar250
TOPPatient Accounting
64NFALACPIS-H: Case Accrual per Day14BKTXTDocument Header Textnvarchar250
65TN21ZIS-H: Incoming Payments Control Parameters8BKTXTDocument Header Textnvarchar250
66TN24TIS-H: Text for the treatment category of a case5BKTXTIS-H: Short Text for Treatment Categorynvarchar150
67TN27IS-H: Revenue Accrual Posting Parameters7BKTXTIS-H: Document Header Text for Accrual/Deferral Postingnvarchar250
TOPPayment Transactions
68CRFILEPOSPayment Card File: Individual Records28BKTXTDocument Header Textnvarchar250
TOPReal Estate Management
69VIAKBKPFDocument Header from Service Charge Settlement for Interface18BKTXTText length 25nvarchar250
70VISLIDDebit position history22BKTXTDocument Header Textnvarchar250
TOPRemaining Beverage - Obsolete Objects
71/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103023BKTXTDocument Header Textnvarchar250
TOPRepetitive Manufacturing
72RMIOInput Structure of Repetitive Manufacturing Confirmation16BKTXTDocument Header Textnvarchar250
TOPTransfer to Financial Accounting
73TRACT_DOCUMENTTreasury: Accounting Adaptor Document27BKTXTDocument Header Textnvarchar250
TOPTreasury
74FLQHEADMALiquidity Calculation - Header for Manual Transfer Postings6BKTXTLiquidity Calculation - Header Text for Man. Trans. Postingsnvarchar400
TOPValue Adjustment
75/IBS/CRB_RBDBW_TRBD RBD Flow Types (Texts)5BKTXTRBD: Document Header Text for FI Documentnvarchar250