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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

98 columns | Print definition?ERP 6.0  | ZFBDT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPFI00003cashier system - checks concentration22ZFBDTBaseline date for due date calculationnvarchar80
2/ATL/KPFI00003DLcashier system - checks concentration deleted22ZFBDTBaseline date for due date calculationnvarchar80
3/ATL/KPFI00003KPCashier system - checks concentration - Temporary22ZFBDTBaseline date for due date calculationnvarchar80
4/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta27ZFBDTnvarchar80
5/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta27ZFBDTnvarchar80
6/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items71ZFBDTnvarchar80
7/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact71ZFBDTnvarchar80
8/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items83ZFBDTnvarchar80
9/CCEE/SIFIPOBOTIePoboti: Obligatory manysided reconciliation - XML output37ZFBDTBaseline Date for Due Date Calculationnvarchar80
10/CCEE/SIFI_UMSITTax items applied for decrease/increase of input VAT16ZFBDTBaseline Date for Due Date Calculationnvarchar80
11BBP_RBKPDocument Header: Invoice Receipt68ZFBDTBaseline Date for Due Date Calculationnvarchar80
12BOE_ACTION_REQBoe action request10ZFBDTBaseline Date for Due Date Calculationnvarchar80
13BOE_DOCBoe Document51ZFBDTBaseline Date for Due Date Calculationnvarchar80
14BOE_REF_DOCReference documnet for BoE29ZFBDTBaseline Date for Due Date Calculationnvarchar80
15BSAD_BAKAccounting: Secondary index for customers (cleared items)39ZFBDTBaseline Date for Due Date Calculationnvarchar80
16BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)41ZFBDTBaseline Date for Due Date Calculationnvarchar80
17BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)30ZFBDTBaseline Date for Due Date Calculationnvarchar80
18BSEGAccounting Document Segment106ZFBDTBaseline Date for Due Date Calculationnvarchar80
19BSID_BAKAccounting: Secondary Index for Customers39ZFBDTBaseline Date for Due Date Calculationnvarchar80
20BSIK_BAKAccounting: Secondary index for vendors41ZFBDTBaseline Date for Due Date Calculationnvarchar80
21BSIS_BAKAccounting: Secondary Index for G/L Accounts30ZFBDTBaseline Date for Due Date Calculationnvarchar80
22BSSEGAccounting Document Segment95ZFBDTBaseline Date for Due Date Calculationnvarchar80
23EPIC_EBR_FEBAdditional Data on Bank Statement Line Item for Bank Receipt31ZFBDTBaseline Date for Due Date Calculationnvarchar80
24FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)30ZFBDTBaseline Date for Due Date Calculationnvarchar80
25FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts30ZFBDTBaseline Date for Due Date Calculationnvarchar80
26FIAPSAD_ORDR_HDOrder Number Header KSA19ZFBDTBaseline Date for Due Date Calculationnvarchar80
27FUDT_VDOCBSEGVerification Document Item with Additional Info95ZFBDTBaseline Date for Due Date Calculationnvarchar80
28FUDT_VDOCBSEGEVVerification Document Item in the Entry View95ZFBDTBaseline Date for Due Date Calculationnvarchar80
29FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)95ZFBDTBaseline Date for Due Date Calculationnvarchar80
30GLPOS_C_CTFI Document: Entry View316ZFBDTBaseline Date for Due Date Calculationnvarchar80
31GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items316ZFBDTBaseline Date for Due Date Calculationnvarchar80
32GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items316ZFBDTBaseline Date for Due Date Calculationnvarchar80
33GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items316ZFBDTBaseline Date for Due Date Calculationnvarchar80
34GLPOS_N_CTNew General Ledger: Line Item with Currency Type325ZFBDTBaseline Date for Due Date Calculationnvarchar80
35GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type325ZFBDTBaseline Date for Due Date Calculationnvarchar80
36MHNDDunning Data22ZFBDTBaseline Date for Due Date Calculationnvarchar80
37REGUPProcessed items from payment program49ZFBDTBaseline Date for Due Date Calculationnvarchar80
38VDSEPA_AUTODEBRecords for new auto debit (SEPA direct debit)13ZFBDTBaseline Date for Due Date Calculationnvarchar80
39VDSEPA_AUTODEB_ORecords for new auto debit (SEPA direct debit) (up to 604)13ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPAccounting Interface
40GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)102ZFBDTBaseline Date for Due Date Calculationnvarchar80
41GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)102ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPBasic Functions
42BSIWIndex table for customer bills of exchange used17ZFBDTBaseline Date for Due Date Calculationnvarchar80
43BSIXIndex table for customer bills of exchange used17ZFBDTBaseline Date for Due Date Calculationnvarchar80
44FDLFCash Management Line Items for Agency Business5ZFBDTBaseline Date for Due Date Calculationnvarchar80
45FDLF2Cash Management Line Items for Agency Business (As of 604)5ZFBDTBaseline Date for Due Date Calculationnvarchar80
46T045DTADME file check table for bill of exchange presentation7ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPCosting
47COERSales Order Value Revenue51ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPCross-Application Components
48BBSIDAccounting: Secondary index for customers39ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPData Collection
49S008Communications Table SD -> CO/Projects29ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPData Retention Tool
50TXW_S_BSEGRetrieve BSEG from archive87ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPData Transfer
51PPDITTransfer to Accounting: Lines in HR IDOCs28ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPFinancial Accounting
52/OPT/VIM_1HEADDocument Header162ZFBDTBaseline Date for Due Date Calculationnvarchar80
53ACCTITCompressed Data from FI/CO Document184ZFBDTBaseline Date for Due Date Calculationnvarchar80
54BSADAccounting: Secondary Index for Customers (Cleared Items)39ZFBDTBaseline Date for Due Date Calculationnvarchar80
55BSAKAccounting: Secondary Index for Vendors (Cleared Items)41ZFBDTBaseline Date for Due Date Calculationnvarchar80
56BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)30ZFBDTBaseline Date for Due Date Calculationnvarchar80
57BSIDAccounting: Secondary Index for Customers39ZFBDTBaseline Date for Due Date Calculationnvarchar80
58BSIKAccounting: Secondary Index for Vendors41ZFBDTBaseline Date for Due Date Calculationnvarchar80
59BSISAccounting: Secondary Index for G/L Accounts30ZFBDTBaseline Date for Due Date Calculationnvarchar80
60VBSEGDDocument Segment for Customer Document Parking49ZFBDTBaseline Date for Due Date Calculationnvarchar80
61VBSEGKDocument Segment for Vendor Document Parking55ZFBDTBaseline Date for Due Date Calculationnvarchar80
62VBSEGSDocument Segment for Document Parking - G/L Account Database23ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPFunctions for U.S. Federal Government
63FMRES_INSTMTSComplete log on Rescheduling7ZFBDTBaseline Date for Due Date Calculationnvarchar80
64FMRES_RECV_LISTList of all rescheduled receivables11ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPFunds Management
65FMEPFI-FM Line Items32ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPFunds Management-Specific Postings
66FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years25ZFBDTBaseline Date for Due Date Calculationnvarchar80
67PSOSEGDDocument Segment: Recurring Request, Customer50ZFBDTBaseline Date for Due Date Calculationnvarchar80
68PSOSEGKRecurring Request Document Segment, Vendors56ZFBDTBaseline Date for Due Date Calculationnvarchar80
69PSOSEGSRecurring Request Document Segment, G/L Accounts24ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPGeneral Ledger Accounting
70FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)30ZFBDTBaseline Date for Due Date Calculationnvarchar80
71FAGLBSISAccounting: Secondary Index for G/L Accounts30ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPInformation System
72BWPOSValuations for Open Items23ZFBDTBaseline Date for Due Date Calculationnvarchar80
73DKKOPBalance Audit Trail47ZFBDTBaseline Date for Due Date Calculationnvarchar80
74DKOKPOpen Item Account Balance Audit Trail51ZFBDTBaseline Date for Due Date Calculationnvarchar80
75DSKOPBalance Audit Trail50ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPInvoice Verification
76RBKPDocument Header: Invoice Receipt68ZFBDTBaseline Date for Due Date Calculationnvarchar80
77RBKPBInvoice Document Header (Batch Invoice Verification)85ZFBDTNot used. Base date for due-date calculationnvarchar80
TOPJoint Venture und Production Sharing Accounting
78T8J4BJV Cash Call Batch table18ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPLoans Management
79TTONFTVZZBEPPTest neue FIMA: VZZBEPP214ZFBDTZahlungstagnvarchar80
80VDBEPPFlow Data - Planned Item137ZFBDTPayment Datenvarchar80
81VDBOBEPPBusiness Operation: Entered and Activated Flow Data137ZFBDTPayment Datenvarchar80
82VDZNB_USAGEPayment Postprocessing: Usage of a Payment Postpr. Activity26ZFBDTBaseline Date for Due Date Calculationnvarchar80
83VZFZE_VDBEPPCentral Entry Table for Release Procedure140ZFBDTPayment Datenvarchar80
TOPLocalization
84FPIA_FI_IDXFI Index Table for Interest Calculation - Chorus8ZFBDTBaseline Date for Due Date Calculationnvarchar80
85FPIA_INTERESTTable for Penalty Interest13ZFBDTBaseline Date for Due Date Calculationnvarchar80
86J_1BNFDOCNota Fiscal Header49ZFBDTBaseline Date for Due Date Calculationnvarchar80
87J_3RFTAX_EXTRDTax Extract Detail Lines86ZFBDTBaseline Date for Due Date Calculationnvarchar80
88RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions85ZFBDTBaseline Date for Due Date Calculationnvarchar80
89RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions85ZFBDTBaseline Date for Due Date Calculationnvarchar80
90RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions85ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPPayment Transactions
91FPRL_ITEMItem Data41ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPPeriodical Sales and Distribution
92JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS24ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPReal Estate Management
93VIAK16SCS: Identification Of Settlement With Log Reference26ZFBDTBaseline date for due date calculationnvarchar80
94VIAKBSEGDocument Line Item from SCS for Interface31ZFBDTDatenvarchar80
95VIMIIPInvoice Items14ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPReal Estate Slovakia
96VIXCSKTAXASSESProperty Tax - Tax Assessment7ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPRemaining Beverage - Obsolete Objects
97/BEV3/CH1030BSG1Document Segment CH Event Ledger Part197ZFBDTBaseline Date for Due Date Calculationnvarchar80
TOPTravel Expenses
98PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document34ZFBDTBaseline Date for Due Date Calculationnvarchar80