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

50 columns | Print definition?ERP 6.0  | ANBWA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1AUAASettlement Document: Receiver Segment42ANBWAAsset Transaction Typenvarchar30
2BSEGAccounting Document Segment77ANBWAAsset Transaction Typenvarchar30
3BSSEGAccounting Document Segment66ANBWAAsset Transaction Typenvarchar30
4FUDT_VDOCBSEGVerification Document Item with Additional Info66ANBWAAsset Transaction Typenvarchar30
5FUDT_VDOCBSEGEVVerification Document Item in the Entry View66ANBWAAsset Transaction Typenvarchar30
6FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)66ANBWAAsset Transaction Typenvarchar30
7GLPCA_CTProfit Center Documents39ANBWAAsset Transaction Typenvarchar30
8GLPCA_T_CTProfit Center Documents55ANBWAAsset Transaction Typenvarchar30
9GLPOS_C_CTFI Document: Entry View37ANBWAAsset Transaction Typenvarchar30
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items37ANBWAAsset Transaction Typenvarchar30
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items37ANBWAAsset Transaction Typenvarchar30
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items37ANBWAAsset Transaction Typenvarchar30
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type37ANBWAAsset Transaction Typenvarchar30
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type37ANBWAAsset Transaction Typenvarchar30
TOPAccounting Interface
15GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)150ANBWAAsset Transaction Typenvarchar30
16GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)150ANBWAAsset Transaction Typenvarchar30
TOPContract Accounts Receivable and Payable
17DFKKOPKXItems for Contract Accounting Document (Enhancement)8ANBWAAsset Transaction Typenvarchar30
18DFKKORDERPOSRequests: Items82ANBWAAsset Transaction Typenvarchar30
19DFKKORDERPOS_SRequest Templates: Items59ANBWAAsset Transaction Typenvarchar30
TOPData Retention Tool
20TXW_S_BSEGRetrieve BSEG from archive48ANBWAAsset Transaction Typenvarchar30
TOPElectronic Bank Statement
21FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)37ANBWAAsset Transaction Typenvarchar30
22FEB_ACTAcct Assignment Templates37ANBWAAsset Transaction Typenvarchar30
TOPFinancial Accounting
23ACCTITCompressed Data from FI/CO Document45ANBWAAsset Transaction Typenvarchar30
24EBSEGDoc.Segment of Fin.Accntng External Documents42ANBWAAsset Transaction Typenvarchar30
25KMZEIFI: Account Assignment Model Item Information27ANBWAAsset Transaction Typenvarchar30
26KOMUAccount Assignment Templates for G/L Account Items27ANBWAAsset Transaction Typenvarchar30
27VBSEGADocument Segment for Document Parking - Asset Database25ANBWAAsset Transaction Typenvarchar30
28VBSEGDDocument Segment for Customer Document Parking119ANBWAAsset Transaction Typenvarchar30
29VBSEGKDocument Segment for Vendor Document Parking130ANBWAAsset Transaction Typenvarchar30
30VBSEGSDocument Segment for Document Parking - G/L Account Database27ANBWAAsset Transaction Typenvarchar30
TOPFunds Management-Specific Postings
31FMBGACORRSHistory for Input Tax Adjustments PCOs11ANBWAAsset Transaction Typenvarchar30
32FMBGADCTAXData from Backdated Tax Calculation for PCOs11ANBWAAsset Transaction Typenvarchar30
33PSOSEGADocument Segment for Assets Document Parking26ANBWAAsset Transaction Typenvarchar30
TOPGeneral Ledger Accounting
34BSEG_ADDEntry View of Accounting Document for Additional Ledgers27ANBWAAsset Transaction Typenvarchar30
35FAGL_SPLINFOSplittling Information of Open Items37ANBWAAsset Transaction Typenvarchar30
TOPGL Account Posting
36TCJ_POSITIONSCash Journal Document Items44ANBWAAsset Transaction Typenvarchar30
TOPInventory Management
37MWZDM07M1ZDM07M1219ANBWAAsset Transaction Typenvarchar30
TOPJoint Venture und Production Sharing Accounting
38JVOO1Object Table for FI-SL Table JVTO119ANBWAAsset Transaction Typenvarchar30
39JVPSC01AActual line item table33ANBWAAsset Transaction Typenvarchar30
40JVPSC01CObject table 28ANBWAAsset Transaction Typenvarchar30
41JVPSC01PPlan line item table33ANBWAAsset Transaction Typenvarchar30
42JVPSC01TSummary table32ANBWAAsset Transaction Typenvarchar30
43T8JHMTransaction type per line type4ANBWAAsset Transaction Typenvarchar30
44T8JHVAsset Operator Ownership Transaction Table2ANBWAAsset Transaction Typenvarchar30
TOPOverhead Cost Orders
45COBRBDistribution Rules Settlement Rule Order Settlement58ANBWAAsset Transaction Typenvarchar30
46TKB6Account Determination for Settlement10ANBWAAsset Transaction Typenvarchar30
TOPProfit Center Accounting
47GLPCAEC-PCA: Actual Line Items61ANBWAAsset Transaction Typenvarchar30
48GLPCPEC-PCA: Plan Line Items122ANBWAAsset Transaction Typenvarchar30
TOPReal Estate Management
49VIAKBSEGDocument Line Item from SCS for Interface43ANBWAAsset Transaction Typenvarchar30
TOPRemaining Beverage - Obsolete Objects
50/BEV3/CH1030BSG1Document Segment CH Event Ledger Part168ANBWAAsset Transaction Typenvarchar30