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

69 columns | Print definition?ERP 6.0  | MSCHL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000165000PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta39MSCHLnvarchar10
2/BIC/B0000166000PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta39MSCHLnvarchar10
3/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items37MSCHLnvarchar10
4/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact37MSCHLnvarchar10
5/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items43MSCHLnvarchar10
6BSAD_BAKAccounting: Secondary index for customers (cleared items)63MSCHLDunning keynvarchar10
7BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)66MSCHLDunning keynvarchar10
8BSEGAccounting Document Segment155MSCHLDunning keynvarchar10
9BSID_BAKAccounting: Secondary Index for Customers63MSCHLDunning keynvarchar10
10BSIK_BAKAccounting: Secondary index for vendors66MSCHLDunning keynvarchar10
11BSSEGAccounting Document Segment144MSCHLDunning keynvarchar10
12FUDT_VDOCBSEGVerification Document Item with Additional Info144MSCHLDunning keynvarchar10
13FUDT_VDOCBSEGEVVerification Document Item in the Entry View144MSCHLDunning keynvarchar10
14FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)144MSCHLDunning keynvarchar10
15GLPOS_C_CTFI Document: Entry View175MSCHLDunning keynvarchar10
16GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items175MSCHLDunning keynvarchar10
17GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items175MSCHLDunning keynvarchar10
18GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items175MSCHLDunning keynvarchar10
19GLPOS_N_CTNew General Ledger: Line Item with Currency Type178MSCHLDunning keynvarchar10
20GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type178MSCHLDunning keynvarchar10
21MHNDDunning Data26MSCHLDunning keynvarchar10
22T040Dunning keys2MSCHLDunning keynvarchar10
23T040ADunning key names3MSCHLDunning keynvarchar10
TOPAccounting Interface
24GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)119MSCHLDunning keynvarchar10
25GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)119MSCHLDunning keynvarchar10
TOPAdvertising Management
26JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header41MSCHLDunning keynvarchar10
TOPBilling
27VBRKBilling Document: Header Data64MSCHLDunning keynvarchar10
TOPConstruction Industry
28PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records17MSCHLNotification Key for Data Record ANMELnvarchar40
29PDBKNWConstruction Industry Social Fund Proced: Employee Statement33MSCHLNotification Key for Data Record ANMELnvarchar40
TOPCross-Application Components
30BBSIDAccounting: Secondary index for customers63MSCHLDunning keynvarchar10
31VVBKDSales Document: Business Data27MSCHLDunning keynvarchar10
TOPFinancial Accounting
32BSADAccounting: Secondary Index for Customers (Cleared Items)63MSCHLDunning keynvarchar10
33BSAKAccounting: Secondary Index for Vendors (Cleared Items)66MSCHLDunning keynvarchar10
34BSIDAccounting: Secondary Index for Customers63MSCHLDunning keynvarchar10
35BSIKAccounting: Secondary Index for Vendors66MSCHLDunning keynvarchar10
36VBSEGDDocument Segment for Customer Document Parking77MSCHLDunning keynvarchar10
37VBSEGKDocument Segment for Vendor Document Parking85MSCHLDunning keynvarchar10
TOPFunds Management-Specific Postings
38PSOSEGDDocument Segment: Recurring Request, Customer78MSCHLDunning keynvarchar10
39PSOSEGKRecurring Request Document Segment, Vendors86MSCHLDunning keynvarchar10
TOPInformation System
40BWPOSValuations for Open Items27MSCHLDunning keynvarchar10
41DKKOPBalance Audit Trail44MSCHLDunning keynvarchar10
42DKKOSBalance Audit Trail80MSCHLDunning keynvarchar10
43DKOKPOpen Item Account Balance Audit Trail62MSCHLDunning keynvarchar10
44DKOKSOpen Item Account Balance Audit Trail Master Record81MSCHLDunning keynvarchar10
TOPLocalization
45J_3RFTAX_EXTRDTax Extract Detail Lines46MSCHLDunning keynvarchar10
46RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions44MSCHLDunning keynvarchar10
47RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions44MSCHLDunning keynvarchar10
48RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions44MSCHLDunning keynvarchar10
TOPPatient Accounting
49NVBRKIS-H: Billing document header data46MSCHLDunning keynvarchar10
50TN22QIS-H: Control Parameters FI Posting Copayment Request6MSCHLDunning Keynvarchar10
51TN22SIS-H: Control Parameters FI Posting Down Payment Request6MSCHLDunning Keynvarchar10
TOPReal Estate Management
52VIAKBSEGDocument Line Item from SCS for Interface48MSCHLDunning keynvarchar10
TOPRemaining Beverage - Obsolete Objects
53/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1146MSCHLDunning keynvarchar10
54/BEV3/CHABRSTZ_PCH Settlement Items - With Translations60MSCHLDunning keynvarchar10
55/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items61MSCHLDunning keynvarchar10
56/BEV3/CHERGSTZ_PCH Settlement Items - With Translations60MSCHLDunning keynvarchar10
57/BEV3/CHERGSTZ_SCH Settlement Statistics61MSCHLDunning keynvarchar10
58/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics60MSCHLDunning keynvarchar10
59/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)60MSCHLDunning keynvarchar10
60/BEV3/CHSHTSTZ_PCH Settlement Item60MSCHLDunning keynvarchar10
61/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions61MSCHLDunning keynvarchar10
62/BEV3/CHSIMSTZ_PCH Simulation Items60MSCHLDunning keynvarchar10
63/BEV3/CHSIMSTZ_SCH Simulation Statistics61MSCHLDunning keynvarchar10
64/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item61MSCHLDunning keynvarchar10
65/BEV3/CHTRMSTZ_PCH Date Item60MSCHLDunning keynvarchar10
66/BEV3/CHTRMSTZ_SCH Date Statistics61MSCHLDunning keynvarchar10
67/BEV3/CHVABRSTZSCH Settlement Statistics61MSCHLDunning keynvarchar10
TOPSales
68VBKDSales Document: Business Data27MSCHLDunning keynvarchar10
TOPSimulation
69VSVBKD_CNVersion: Sales document - commercial data28MSCHLDunning keynvarchar10