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

110 columns | Print definition?ERP 6.0  | MANSP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta38MANSPnvarchar10
2/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta38MANSPnvarchar10
3/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items34MANSPnvarchar10
4/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact34MANSPnvarchar10
5/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items40MANSPnvarchar10
6/SMD/MD_____00NDSID-Tabelle fuer Dunning block3MANSPDunning blocknvarchar10
7/SMD/MD_____00ZESID-Tabelle fuer Dunning block3MANSPDunning blocknvarchar10
8BSAD_BAKAccounting: Secondary index for customers (cleared items)62MANSPDunning blocknvarchar10
9BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)65MANSPDunning blocknvarchar10
10BSEGAccounting Document Segment156MANSPDunning blocknvarchar10
11BSID_BAKAccounting: Secondary Index for Customers62MANSPDunning blocknvarchar10
12BSIK_BAKAccounting: Secondary index for vendors65MANSPDunning blocknvarchar10
13BSSEGAccounting Document Segment145MANSPDunning blocknvarchar10
14FUDT_VDOCBSEGVerification Document Item with Additional Info145MANSPDunning blocknvarchar10
15FUDT_VDOCBSEGEVVerification Document Item in the Entry View145MANSPDunning blocknvarchar10
16FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)145MANSPDunning blocknvarchar10
17GLPOS_C_CTFI Document: Entry View170MANSPDunning blocknvarchar10
18GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items170MANSPDunning blocknvarchar10
19GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items170MANSPDunning blocknvarchar10
20GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items170MANSPDunning blocknvarchar10
21GLPOS_N_CTNew General Ledger: Line Item with Currency Type173MANSPDunning blocknvarchar10
22GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type173MANSPDunning blocknvarchar10
23MHNDDunning Data28MANSPDunning blocknvarchar10
24REGUPProcessed items from payment program148MANSPDunning blocknvarchar10
25T028BTransaction Type of Sender Bank12MANSPSet Dunning Blocknvarchar10
26T040SBlocking reasons for dunning notices2MANSPDunning blocknvarchar10
27T040TDunning block reason names3MANSPDunning blocknvarchar10
TOPAccounting
28TDIOA_TEMPLTemplate for Interest On Arrears Calculation11MANSPDunning blocknvarchar10
TOPAccounting Interface
29GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)122MANSPDunning blocknvarchar10
30GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)122MANSPDunning blocknvarchar10
TOPAccounts Receivable Accounting Process Integration
31TFDM_P2PCCSettings for Promise to Pay per Company Code5MANSPDunning Block for Items with Open Promises to Paynvarchar10
TOPAdvertising Management
32/NAM/TJHBAD_DEBTFilter Conditions for Customer Bad Debt Accounts5MANSPDunning blocknvarchar10
33JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header42MANSPDunning blocknvarchar10
TOPBank Accounting
34FPS_BLOCKPayment and Dunning Block for Each Payment Service Provider4MANSPDunning blocknvarchar10
TOPBasic Functions
35FEBEPElectronic Bank Statement Line Items77MANSPDunning blocknvarchar10
36FEBPIPolling Statement Line Item Information21MANSPSet Dunning Blocknvarchar10
37T028ZReturns Activities: Change Open Items4MANSPSet Dunning Blocknvarchar10
TOPBilling
38VBRKBilling Document: Header Data65MANSPDunning blocknvarchar10
TOPContract Accounts Receivable and Payable
39DFKKMACFCSMKFICA Dunning - Blocked Accounts6MANSPDunning Lock Reasonnvarchar10
40DFKKMOPItems in contract account document74MANSPDunning Lock Reasonnvarchar10
41DFKKMOPWItems in contract account document15MANSPDunning Lock Reasonnvarchar10
42DFKKOPItems in contract account document74MANSPDunning Lock Reasonnvarchar10
43DFKKOPWItems in contract account document15MANSPDunning Lock Reasonnvarchar10
44DFKKOP_REPOpen Items from FPO478MANSPDunning Lock Reasonnvarchar10
45FKKBEPElectronic Bank Statement Line Items77MANSPDunning blocknvarchar10
46FKKMAZEDunning history of line items20MANSPDunning Lock Reasonnvarchar10
47FKKVKPContract Account Partner-Specific40MANSPDunning Lock Reasonnvarchar10
48TE305Transactions for Company Code and Division11MANSPDunning Lock Reasonnvarchar10
49TFK047SDunning block reasons2MANSPDunning Lock Reasonnvarchar10
50TFK047STDunning block reason text3MANSPDunning Lock Reasonnvarchar10
TOPCross-Application Components
51BBSIDAccounting: Secondary index for customers62MANSPDunning blocknvarchar10
52VVBKDSales Document: Business Data28MANSPDunning blocknvarchar10
TOPDunning
53MHNDODunning data version before the next change15MANSPDunning blocknvarchar10
54MHNKDunning data (account entries)28MANSPDunning blocknvarchar10
55MHNKODunning data (acct entries) version before the next change29MANSPDunning blocknvarchar10
TOPElectronic Bank Statement
56FEB_AVIR_EXTDAdvice Note Subitem Enhancement (Bank Statement Postproc.)12MANSPDunning blocknvarchar10
57FEB_ITEM_SAVESaving of Posting Items for Postprocessing (On Account)17MANSPDunning blocknvarchar10
TOPFinancial Accounting
58BSADAccounting: Secondary Index for Customers (Cleared Items)62MANSPDunning blocknvarchar10
59BSAKAccounting: Secondary Index for Vendors (Cleared Items)65MANSPDunning blocknvarchar10
60BSIDAccounting: Secondary Index for Customers62MANSPDunning blocknvarchar10
61BSIKAccounting: Secondary Index for Vendors65MANSPDunning blocknvarchar10
62KNB5Customer master (dunning data)6MANSPDunning blocknvarchar10
63LFB5Vendor master (dunning data)6MANSPDunning blocknvarchar10
64VBSEGDDocument Segment for Customer Document Parking78MANSPDunning blocknvarchar10
65VBSEGKDocument Segment for Vendor Document Parking86MANSPDunning blocknvarchar10
TOPFunds Management-Specific Postings
66PAYRCAdditional Header Data for Recovery Order10MANSPDunning blocknvarchar10
67PSOSEGDDocument Segment: Recurring Request, Customer79MANSPDunning blocknvarchar10
68PSOSEGKRecurring Request Document Segment, Vendors87MANSPDunning blocknvarchar10
TOPGeneric Contract Accounts Receivable and Payable
69TFSCHVTVTransactions for Company Code and Division11MANSPDunning Lock Reasonnvarchar10
TOPInformation System
70BWPOSValuations for Open Items28MANSPDunning blocknvarchar10
TOPInvoicing
71DEABPSCustomer change table: Logical view of BB amounts67MANSPDunning Lock Reasonnvarchar10
72EABPS_CORRSub Budget Billing Plan for Correspondence Print48MANSPDunning Lock Reasonnvarchar10
TOPLoans Management
73TDREPAY_TEMPLTable for Payoff and Notice Templates31MANSPDunning blocknvarchar10
74TTONFTVVZZKOPOTest neue Fima: VVZZKOPO87MANSPMahnsperrenvarchar10
75TTONFTVZZBEPPTest neue FIMA: VZZBEPP191MANSPMahnsperrenvarchar10
76TVDSTPosting applications control table6MANSPDunning blocknvarchar10
77VDBEPIPosted line items for document header89MANSPDunning blocknvarchar10
78VDBEPI_SHADOWShadow Table for VDBEPI (Restrictions)89MANSPDunning blocknvarchar10
79VDBEPPFlow Data - Planned Item122MANSPDunning blocknvarchar10
80VDBOBEPPBusiness Operation: Entered and Activated Flow Data122MANSPDunning blocknvarchar10
81VDCFWAREHOUSECash Flow Management85MANSPDunning blocknvarchar10
82VDREPAYMENTPayoff Master Data86MANSPDunning blocknvarchar10
83VZFZE_VDBEPPCentral Entry Table for Release Procedure125MANSPDunning blocknvarchar10
TOPLocalization
84J_3RFTAX_EXTRDTax Extract Detail Lines43MANSPDunning blocknvarchar10
85RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions41MANSPDunning blocknvarchar10
86RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions41MANSPDunning blocknvarchar10
87RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions41MANSPDunning blocknvarchar10
TOPMaster Data
88EVERIS-U Cont.90MANSPDunning Lock Reasonnvarchar10
89VDESCROWKOPO0TEMPORARY USE: Escrow Condition Items77MANSPDunning blocknvarchar10
TOPMove-InOut
90EAUSVMove-out Doc. Contract Level16MANSPDunning Lock Reasonnvarchar10
91TE490AVMove-Out Control: Contract Level8MANSPDunning Lock Reasonnvarchar10
TOPPatient Accounting
92NVBRKIS-H: Billing document header data47MANSPDunning blocknvarchar10
93TN22QIS-H: Control Parameters FI Posting Copayment Request5MANSPIS-H: Dunning Blocknvarchar10
94TN22RIS-H: Control Params FI Posting Copayment/Copay.Cred.Memo32MANSPIS-H: Dunning Blocknvarchar10
95TN22SIS-H: Control Parameters FI Posting Down Payment Request5MANSPIS-H: Dunning Blocknvarchar10
TOPPortfolio
96VDCOT_VER_CONConditions in the Condition Table43MANSPDunning blocknvarchar10
TOPReal Estate Management
97S407Rental agreements107MANSPDunning: Blocking reasonnvarchar10
98TZK02Condition group, condition group - condition type allocation43MANSPDunning blocknvarchar10
99VIAKBSEGDocument Line Item from SCS for Interface47MANSPDunning blocknvarchar10
100VIMI04Old. replaced in 3.0 with VIMIMV94MANSPDunning blocknvarchar10
101VIMIEVSupplementary lease-outs10MANSPDunning blocknvarchar10
102VIMIMVLease-Out74MANSPDunning: Blocking reasonnvarchar10
103VIRPS407Rental agreements107MANSPDunning blocknvarchar10
TOPRemaining Beverage - Obsolete Objects
104/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1147MANSPDunning blocknvarchar10
105/BEV3/CHRGMHNSPDunning Block Rule10MANSPDunning blocknvarchar10
TOPSales
106VBKDSales Document: Business Data28MANSPDunning blocknvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
107TN22FIS-H: Steuerungsparameter FI-Buchung amb. Zuzahl.anforderung5MANSPIS-H: Mahnsperrenvarchar10
108TN22GIS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung5MANSPIS-H: Mahnsperrenvarchar10
TOPSimulation
109VSVBKD_CNVersion: Sales document - commercial data29MANSPDunning blocknvarchar10
TOPTreasury
110VZZKOPOTable condition items80MANSPDunning blocknvarchar10