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

74 columns | Print definition?ERP 6.0  | ZLSPR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ARBA/AN_ISUINVTemp table for BTE ISU13ZLSPRPayment Block Keynvarchar10
2/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta36ZLSPRnvarchar10
3/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta36ZLSPRnvarchar10
4/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items73ZLSPRnvarchar10
5/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact73ZLSPRnvarchar10
6/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items86ZLSPRnvarchar10
7/CCEE/SIFIPOBOTIePoboti: Obligatory manysided reconciliation - XML output39ZLSPRPayment Block Keynvarchar10
8/CCEE/SIFIPOBXRFePoboti: Define reference field, blocking reason4ZLSPRPayment Block Keynvarchar10
9BBP_RBKPDocument Header: Invoice Receipt66ZLSPRPayment Block Keynvarchar10
10BSAD_BAKAccounting: Secondary index for customers (cleared items)50ZLSPRPayment Block Keynvarchar10
11BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)52ZLSPRPayment Block Keynvarchar10
12BSEGAccounting Document Segment117ZLSPRPayment Block Keynvarchar10
13BSID_BAKAccounting: Secondary Index for Customers50ZLSPRPayment Block Keynvarchar10
14BSIK_BAKAccounting: Secondary index for vendors52ZLSPRPayment Block Keynvarchar10
15BSSEGAccounting Document Segment106ZLSPRPayment Block Keynvarchar10
16CID_DB_INB_TARGTClearing Partner for PEXR200217ZLSPRPayment Block Keynvarchar10
17COPC_ACCOUNTCash Account30ZLSPRPayment Block Keynvarchar10
18FUDT_VDOCBSEGVerification Document Item with Additional Info106ZLSPRPayment Block Keynvarchar10
19FUDT_VDOCBSEGEVVerification Document Item in the Entry View106ZLSPRPayment Block Keynvarchar10
20FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)106ZLSPRPayment Block Keynvarchar10
21GLPOS_C_CTFI Document: Entry View319ZLSPRPayment Block Keynvarchar10
22GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items319ZLSPRPayment Block Keynvarchar10
23GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items319ZLSPRPayment Block Keynvarchar10
24GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items319ZLSPRPayment Block Keynvarchar10
25GLPOS_N_CTNew General Ledger: Line Item with Currency Type328ZLSPRPayment Block Keynvarchar10
26GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type328ZLSPRPayment Block Keynvarchar10
27MHNDDunning Data33ZLSPRPayment Block Keynvarchar10
28REGUPProcessed items from payment program60ZLSPRPayment Block Keynvarchar10
TOPAccounting Interface
29GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)123ZLSPRPayment Block Keynvarchar10
30GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)123ZLSPRPayment Block Keynvarchar10
TOPAutomatic Payments
31PAYRQPayment Requests135ZLSPRPayment Block Keynvarchar10
TOPContract Accounts Receivable and Payable
32DPAYPPayment program - data on paid item37ZLSPRLock Reason for Automatic Paymentnvarchar10
TOPCross-Application Components
33BBSIDAccounting: Secondary index for customers50ZLSPRPayment Block Keynvarchar10
TOPElectronic Bank Statement
34FEB_AVIR_EXTDAdvice Note Subitem Enhancement (Bank Statement Postproc.)11ZLSPRPayment Block Keynvarchar10
35FEB_ITEM_SAVESaving of Posting Items for Postprocessing (On Account)16ZLSPRPayment Block Keynvarchar10
TOPExchanges
36OIA08LIA Document: Item Data20ZLSPRBlock Key for Paymentnvarchar10
TOPExtended Rebate
37BON_ENH_LEDGERReconciliation Accounts for Rebate Credit Memos8ZLSPRPayment Block Keynvarchar10
TOPExtra Charge
38/BEV1/ECMITDExtra Charge Reconciliation Accounts9ZLSPRPayment Block Keynvarchar10
TOPFinancial Accounting
39BSADAccounting: Secondary Index for Customers (Cleared Items)50ZLSPRPayment Block Keynvarchar10
40BSAKAccounting: Secondary Index for Vendors (Cleared Items)52ZLSPRPayment Block Keynvarchar10
41BSIDAccounting: Secondary Index for Customers50ZLSPRPayment Block Keynvarchar10
42BSIKAccounting: Secondary Index for Vendors52ZLSPRPayment Block Keynvarchar10
43FMFGAAPAYBLOCKPayment block for Partial Payments by Account Assignment2ZLSPRPayment Block Keynvarchar10
44VBSEGDDocument Segment for Customer Document Parking61ZLSPRPayment Block Keynvarchar10
45VBSEGKDocument Segment for Vendor Document Parking67ZLSPRPayment Block Keynvarchar10
TOPFinancial Supply Chain Management
46IHC_PI_INB_TARGTPI: Payment Parameters for Inbound IDOC17ZLSPRPayment Block Keynvarchar10
TOPFSCM In-House Cash
47IHC_DB_INB_TARGTClearing Partner for PEXR200217ZLSPRPayment Block Keynvarchar10
TOPFund Accounting
48FMPP_CONTROLPartial Payment per G/L Account Assignments: Control Table3ZLSPRPayment Block Keynvarchar10
TOPFunds Management-Specific Postings
49FMPYIS-PS: Payment Transactions9ZLSPRPayment block keynvarchar10
50PSO37Payment Block to be Set Automatically5ZLSPRPayment Block Keynvarchar10
51PSOSEGDDocument Segment: Recurring Request, Customer62ZLSPRPayment Block Keynvarchar10
52PSOSEGKRecurring Request Document Segment, Vendors68ZLSPRPayment Block Keynvarchar10
TOPInvoice Verification
53RBKPDocument Header: Invoice Receipt66ZLSPRPayment Block Keynvarchar10
TOPLoans Management
54TTONFTVVZZKOPOTest neue Fima: VVZZKOPO102ZLSPRSchlüssel für Zahlungssperrenvarchar10
55TTONFTVZZBEPPTest neue FIMA: VZZBEPP256ZLSPRSchlüssel für Zahlungssperrenvarchar10
TOPLocalization
56J_3RFTAX_EXTRDTax Extract Detail Lines89ZLSPRPayment Block Keynvarchar10
57RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions88ZLSPRPayment Block Keynvarchar10
58RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions88ZLSPRPayment Block Keynvarchar10
59RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions88ZLSPRPayment Block Keynvarchar10
TOPMaster Data
60VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items89ZLSPRPayment Block Keynvarchar10
TOPPatient Accounting
61TN22SIS-H: Control Parameters FI Posting Down Payment Request19ZLSPRPayment Blocknvarchar10
TOPPayment Transactions
62FPRL_ITEMItem Data109ZLSPRPayment Block Keynvarchar10
63REGUHSettlement data from payment program83ZLSPRPayment Block Keynvarchar10
64REGUPOLine item status before the 'n'th change13ZLSPRPayment Block Keynvarchar10
65T042UBlock Entries for Debit Customers/Credit Vendors7ZLSPRPayment Block Keynvarchar10
TOPPeriodical Sales and Distribution
66JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS37ZLSPRPayment Block Keynvarchar10
TOPReal Estate Management
67VIAKBSEGDocument Line Item from SCS for Interface115ZLSPRPayment Block Keynvarchar10
68VIBEPPFlow data - Planned items for real estate management81ZLSPRPayment Block Keynvarchar10
TOPRemaining Beverage - Obsolete Objects
69/BEV1/BO_LEDGERReconciliation Accounts for Rebate Credit Memos8ZLSPRPayment Block Keynvarchar10
70/BEV1/RBMITDRebate Reconciliation Accounts8ZLSPRPayment Block Keynvarchar10
71/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1108ZLSPRPayment Block Keynvarchar10
TOPTransfer to Financial Accounting
72TRACT_ACCITEMAccounting Items27ZLSPRPayment Block Keynvarchar10
TOPTreasury
73VZZKOPOTable condition items92ZLSPRPayment Block Keynvarchar10
74VZZUSPPayment splitting19ZLSPRPayment Block Keynvarchar10